11
votes
1answer
546 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 ...
2
votes
1answer
266 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 ...
-2
votes
1answer
66 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
66 views

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

Here's an excerpt from my http://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 ...
1
vote
1answer
49 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 ...
1
vote
0answers
31 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?
56
votes
5answers
704 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,...
25
votes
2answers
867 views

Values for PostTypeId in data explorer

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 ...
16
votes
2answers
492 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 ...
86
votes
1answer
718 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 ...
34
votes
1answer
1k views

Can the Stack Exchange data dump be provided as a public data set on Amazon Web Services (AWS)?

Amazon provides Public Data Sets on Amazon Web Services (AWS): Public Data Sets on AWS provides a centralized repository of public data sets that can be seamlessly integrated into AWS cloud-based ...
20
votes
3answers
3k views

Where is Stack Overflow's public data dump?

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
12
votes
2answers
270 views

Why is vote time missing in the SE data dump and SEDE?

Is there a particular reason why vote times are omitted in the data dump? IMO this could be a very useful data-set. Is this one of the steps that was done to anonymize the data, or does it simply not ...
13
votes
1answer
784 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 ...
10
votes
1answer
3k views

Stack Overflow database model

I'm currently involved in a project to design and implement an in-house question-and-answer community for our university. We've explored some open source frameworks such as OSQA, but we are also ...

15 30 50 per page