Sanitized public dumps of the MathOverflow database will probably be created roughly once every month.
All the content contributed to MathOverflow is cc-wiki licensed, intended to be shared and remixed. We even provide all our data as a convenient data dump.
But our cc-wiki licensing, while intentionally permissive, does require attribution:
If you republish this content, we require that you:
You can "nofollow" the links if you like.
- Indicate that the content is from MathOverflow in some way. It doesn't have to be obnoxious; a discreet text blurb is fine.
- Link to the original question on MathOverflow (e.g., http://mathoverflow.net/questions/12345).
- Show the author names for every question and answer.
- Link each author name back to their user profile page (e.g., http://mathoverflow.net/users/12345/username).
You are not legally obligated to cite where you learned things, but good citations are academically honest and they help your readers by making it easy to track things down. The recommended citation
format for MathOverflow posts as follows. Suppose you're citing post number 1234 (which could be a question or an answer), whose author is John Doe.
 Doe, John. Title of the question. mathoverflow.net/questions/1234 (2010)
The important thing is to include a link to the relevant post. MathOverflow makes this easy to do in a couple of ways:
- Even though the full URL of the question is
everything after the question number can be safely omitted. It's just there to make it easier for search engines to understand what the page is about.
- Even if post number 1234 is an answer rather than a question, the given URL will point to the right place. If you prefer, you can also link to the anchor with the URL
http://mathoverflow.net/questions/123#1234. Here, I've assumed that post number 1234 is an answer to question number 123.
Here is a description of what information is contained in each file in the dump.
- UserId, e.g.: "123"
- Name, e.g.: "Teacher"
- Date, e.g.: "2010-03-01T08:55:03.923"
- Text, e.g.: "@Joe User: Thanks Joe"
- CreationDate, e.g.:"2010-02-01T08:07:10.730"
- PostTypeId (Question = 1, Answer = 2)
- ParentId (only present if PostTypeId is 2)
- AcceptedAnswerId (only present if PostTypeId is 1)
- LastEditorDisplayName="Joe User"
UserId (only for VoteTypeId 5, 6, or 7)
BountyAwarded (only for VoteTypeId 9)
- 1: AcceptedByOriginator
- 2: UpMod
- 3: DownMod
- 4: Offensive
- 5: Favorite (UserId will be included)
- 6: Close (UserId will be included)
- 7: Reopen (UserId will be included)
- 8: BountyStart
- 9: BountyClose (BountyAwarded will be included)
- 10: Deletion
- 11: Undeletion
- 12: Spam
- 13: InformModerator