I am trying to find the Stack Overflow data dump, and if there any existing code to actually put the data into SQL tables. Also where can I find the description of the tables that are available in the data dump?
2 Answers
The schema description is changing sometimes, with improvements to the site, and can be found here. You can download the latest version at the time of writing or an older version.
- 2The latest version, as of Dec 2012 is from Sept 2011? So much for the tri-monthly, or even annual release schedule. Has SE decided to give up Creative Commons?Cerin– Cerin2012-12-12 19:47:59 +00:00Commented Dec 12, 2012 at 19:47
- At the time of writing, the lastest version of the data dump is from 2012-08-17.This_is_NOT_a_forum– This_is_NOT_a_forum2013-01-05 13:58:21 +00:00Commented Jan 5, 2013 at 13:58
- @Cerin: see previous.This_is_NOT_a_forum– This_is_NOT_a_forum2013-01-05 15:22:30 +00:00Commented Jan 5, 2013 at 15:22
-
Stack Exchange has an API through which you can access its data. It's better to use the API to do what you are trying as the internal structure are often changed as per requirement. Go for
And, if you want to explore the data and run queries on it, go for: