Linked Questions
273 questions linked to/from Database schema documentation for the public data dump and SEDE
1860
votes
0
answers
126k
views
FAQ for Stack Exchange sites
Community FAQ
For sites in the Stack Exchange 2.0 network
To see a list of commonly used words and phrases, see the glossary.
For official guidance from Stack Exchange, visit the Help Center.
Asking ...
164
votes
76
answers
17k
views
Bookmarks have evolved into Saves
Update Oct 6
Maintenance is complete: all bookmarks have been migrated to Saves across all network sites, including Stack Overflow. All saves, saved lists, private notes, and bookmarks are now ...
134
votes
6
answers
1k
views
Support anchor names in posts
I admit this feature request is probably somewhat limited in useful scope, but I'm throwing it out there anyway. Inspired by this answer, and because I want to use it on this one, I'm requesting that ...
102
votes
1
answer
2k
views
Can some metadata about deleted posts be included in Data.SE?
I like to use Data.SE to view usage stats for some of the sites, however deleted posts are not included on Data.SE and I think this skews the numbers quite a bit, particularly on sites with a lot of ...
75
votes
6
answers
938
views
Migrated question's answers can be upvoted twice by the same user
This question was created on Server Fault, answered on Server Fault, I upvoted some of those answers on Server Fault, and then moved by consensus to Super User.
Now that the question is on Super User,...
70
votes
7
answers
8k
views
How do you view deleted questions?
10k rep members are allowed to see deleted questions, is there a way to find questions that were deleted or to see a list of them somewhere?
65
votes
12
answers
960
views
Favorites are now known as Bookmarks
As mentioned previously, we are renaming the Favorites feature to Bookmarks. This allows us to both match how it's currently used more closely and communicate what to expect from it better.
Some more ...
63
votes
2
answers
32k
views
Where are the Stack Exchange data dumps?
I see a lot of talk around here regarding the Stack Overflow public data dump.
Where is it? How can I play with it?
Return to FAQ index
51
votes
2
answers
920
views
Can one take the entire Q&A base and move it to a new site?
In the light of all recent moderators and experienced users quitting, I was wondering if anyone is allowed to take the entire Q&A set of a site, and move it to a new site, with new rules?
I think ...
45
votes
1
answer
2k
views
Automatically add id attributes to headers to enable link targeting
MediaWiki, the software used on Wikipedia, has some cool functionality as part of its header text syntax. It makes a slug out of the text, and automatically adds that slug to the id attribute of the ...
41
votes
1
answer
343
views
Why does the SEDE ReviewTaskResults table not include user data, which is all public anyway?
I wanted to do some data mining on the SEDE, and I ran across a limitation which I cannot understand.
The Data Explorer table ReviewTaskResults currently contains the following information:
Id
...
36
votes
3
answers
568
views
Please provide a Moderators table in the Data Explorer
Moderators are special, privileged users who should serve as an example to the rest of us. Therefore, it is natural to want to query behaviors and statistics about these model users, Like I did, for ...
35
votes
2
answers
9k
views
Database Diagram of Stack Exchange model?
I went over the Archive site where I could retrieve data from Astronomy.SE. After I downloaded the content, I found 8 XML files that came maybe from a dump process.
Now I am not able to assemble all ...
32
votes
2
answers
3k
views
Meaning of Values for PostTypeId in data explorer or in data-dump [duplicate]
I am looking for some explanation of the schema for the data dump of se sites.
Specifically I'd like to know the values for PostTypeId field (1=Questions?, 2=Answers?, 3=?, etc).
I have tried to ...
32
votes
1
answer
336
views
First posts and Help & improvement review queues say you need 2147.5 million rep to review
Now that the 'First posts' and 'Help & improvement' review queues have been retired, they don't appear in the list of the review queues in the top bar, nor do they appear in the /review page.
...