Linked Questions

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 ...
Unreason's user avatar
  • 707
28 votes
4 answers
9k views

SO database schema [duplicate]

Has the database schema for Stack Overflow been made publicly available? If not, could it be? If not the whole schema, how about a list of the tables used? I want this as a learning resource.
JonnyBoats's user avatar
11 votes
1 answer
1k views

Documentation for Stack Exchange Data Explorer Schema? [duplicate]

Maybe I'm missing something obvious, but is there documentation on the SEDE schema anywhere? As listed here http://odata.stackexchange.com/stackoverflow/query/new, it's not obvious what all the fields ...
Richard's user avatar
  • 213
3 votes
1 answer
1k views

List of Vote type IDs [duplicate]

This is mainly for SEDE use. I know the basic VoteTypeIds, like 1 for accept, 2 for upvote, and 3 for downvote. There are also some other less well-known ones like 11 for undelete. Is there a ...
nneonneo's user avatar
  • 3,621
4 votes
1 answer
378 views

What is LastAccessDate in the Database schema? [duplicate]

I have a doubt regarding the meaning of LastAccessDate in the StackExchange database under the User table. Is it the last date on which the user have performed some activity on the site(like asking ...
arman's user avatar
  • 359
-2 votes
1 answer
239 views

What is the meaning of posts.communityowned date? [duplicate]

There is a field in the posts table named communityowneddate. What is the meaning of that field? And in what case is the post owned by community?
Gerel tumen's user avatar
2 votes
1 answer
177 views

What's the website for running SQL queries on Stack Overflows database? [duplicate]

I knew I've visited it but I just can't remember the URL. The website consists of a number of user submitted SQL queries that return remaining points to badges, top users in a week and much much more....
Marko Ivanovski's user avatar
0 votes
1 answer
359 views

Tag prediction for Stack Overflow posts [duplicate]

I'm working on a small project where I have to create a model (nltk) that will predict the tags from questions that may be published on Stack Overflow. I used this link https://data.stackexchange.com/...
Laurent R's user avatar
  • 101
3 votes
1 answer
119 views

Stack Exchange SQL dumps don't contain answers? [duplicate]

Stack Exchange provides database dumps on this link. However, the structure of files don't contain answers. It has only: Badges, Comments, PostLinks, PostHistory, Posts, Tags, Users, and Votes. In ...
Ondrej Tokar's user avatar
4 votes
0 answers
191 views

Find users who bookmarked a question? [duplicate]

Is there any data explorer query that allows to find the users who bookmarked a specific question? EDIT: I tried searching for a direct hit on data-explorer but didn't find any post having a ...
bad_coder's user avatar
0 votes
1 answer
94 views

How do I link the Stack Exchange data together? [duplicate]

I was trying to link the Stack Exchange data together from the archive.org data dump as my college database subject project, but I can't understand how to link the Post and its answer. I tried to link ...
Suraj Sajeev's user avatar
2 votes
0 answers
188 views

What is the AcceptedAnswerId field in Stack Overflow data MSR 2015? [duplicate]

I mean, how can I find the total list of description for AcceptedAnswerId in the post schema?
Rejaul Karim's user avatar
0 votes
1 answer
110 views

What are all the IDs on the /reputation page, and what do they mean? [duplicate]

Here's an excerpt from my https://stackoverflow.com/reputation page: 1 14132869 (2) 1 14132300 (15) 3 14138562 (-1) 2 14138574 (10) 2 14138574 (10) 2 14138746 (10) 2 14140825 (10) 2 ...
Doorknob's user avatar
  • 45.5k
0 votes
0 answers
110 views

Is there a way to backup an SE site? [duplicate]

I am not a high rep user nor active on Meta SE yet I worried that SE might disappear forever. Can I backup a certain site?
user1298069's user avatar
2 votes
0 answers
88 views

What is posthistory? [duplicate]

I am trying to use Stack Overflow offline and I see that there are 2 files names Posts and PostHistory in archive.org available for downloads. Can someone tell me what PostHistory is? Is it all the ...
user avatar

15 30 50 per page
1
2 3 4 5
19