Last night I updated my StackQL testing site with the March data set. No other updates were made (it still says "October 2009", for example, and doesn't show any new columns like e-mail hash) and it's still just Stack Overflow data — no Super User, Server Fault, or Meta Stack Overflow yet. Also, the testing site doesn't have the full-text indexes and it's still on my slow home server and connection. But otherwise the link is usable with updated data. Enjoy.

closed as too localized by Pops, Jeremy Banks, Joel Coehoorn Sep 18 '12 at 15:29

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Is there a reason why the records in the Posts table don't contain tag data? – Jon Seigel Mar 8 '10 at 16:19
  • @Jon Seigel - Ask Brent Ozar. I'm still going off of his schema, which normalizes that data into a separate PostsTags table. – Joel Coehoorn Mar 8 '10 at 16:22
  • @Joel: Got it. Thanks. – Jon Seigel Mar 8 '10 at 16:24
  • 1
    Thank you! Now at last I know how close I am to that ever-elusive pundit badge on SO ;) – Dominic Rodger Mar 8 '10 at 16:50
  • Hey Joel, I've failed to tell you in the past how great this is. So, no more fail. It's freaking great. – squillman Mar 8 '10 at 19:39
  • @Joel Coehoorn I've switched to using Sam Saffron's fantastic SoSlow.exe, which imports the XML a heck of a lot faster (despite the wacko name, heh). github.com/SamSaffron/So-Slow – Brent Ozar Mar 15 '10 at 23:13
  • Voting to close because this tool doesn't seem to exist anymore, and even if that's just my wonky corporate Internet connection, there's probably nothing it can do that SEDE can't do. – Pops Sep 18 '12 at 15:10

Great, I love it!!!

Don't want to nitpick, I'm not sure about how it's in the raw data dump, but I just noted my age is enlisted one off (I'm 18 and am listed as 19). You can try it with the following query.

SELECT * FROM USERS WHERE  DisplayName='Johannes Rudolph'
  • That's odd - it lists me as 30 even though I'm still 29. It shows up correctly on StackOverflow itself. I don't get DOB data, though; the dump just shows an age field. Looks like you found a bug with their export - congrats. – Joel Coehoorn Mar 8 '10 at 16:04
  • Great, can I buy myself anything for that :-) ? Will file an official request. – Johannes Rudolph Mar 8 '10 at 16:11
  • Already done: meta.stackexchange.com/questions/41519/… – Joel Coehoorn Mar 8 '10 at 16:11
  • just noticed the moment I hit my browsers return. – Johannes Rudolph Mar 8 '10 at 16:12

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