9

I am looking in the Users table for Stack Overflow in the SE data dump and have noticed something strange. There is a field for the website, namely WebsiteUrl.

However, if a user has filled this in and in addition also posted a link to his a GitHub, Twitter, LinkedIn, etc. profile, then we only see the website and not the links to these social media profiles. Why is that? Is there perhaps a way to retrieve also the social media / GitHub links?

As an example, consider the famous Jon Skeet. In his profile, he includes links to his website, GitHub and Twitter accounts. However, in the Users table we can only see his website, namely 'http://csharpindepth.com', in the WebsiteUrl field.

3
  • 1
    The API doesn't have these fields either.
    – rene
    Commented Jan 21, 2018 at 20:25
  • 1
    @rene and neither does SEDE.... looks like SE never exposed those outside for some reason. Commented Jan 28, 2018 at 14:06
  • Maybe they this is because they are inside of the about-me text? Commented Feb 9, 2018 at 8:34

1 Answer 1

8
+50

Those don't appear in the data dump or in SEDE because the social media/GitHub links aren't stored in the Users table - it only has the WebsiteUrl column.

The others links are stored in a separate UsersMetadata table that isn't included in any of the public data dumps.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .