Linked Questions

29
votes
2answers
2k 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 ...
11
votes
1answer
900 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 ...
3
votes
1answer
685 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 ...
3
votes
1answer
121 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 ...
-3
votes
1answer
84 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?
0
votes
1answer
209 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/...
3
votes
1answer
86 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 ...
0
votes
1answer
81 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 ...
0
votes
1answer
44 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 ...
1
vote
0answers
88 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?
97
votes
4answers
915 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 ...
67
votes
6answers
818 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,...
26
votes
2answers
4k 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 ...
97
votes
1answer
1k 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 ...
16
votes
2answers
1k views

Logic Behind StackOverflow Question IDs

First of all, I should say that I think that this question does not belong on Meta. StackOverflow URLs are inspirational to me, the way they are designed is very clever and they work really well but ...

15 30 50 per page