7

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.

  • 1
    The API doesn't have these fields either. – rene Jan 21 '18 at 20:25
  • 1
    @rene and neither does SEDE.... looks like SE never exposed those outside for some reason. – Shadow Wizard Jan 28 '18 at 14:06
  • Maybe they this is because they are inside of the about-me text? – MEE the sneaky user Feb 9 '18 at 8:34
4
+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 .