11
votes
1answer
467 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
229 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
62 views

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

there is field in posts table namely communityowneddate. What is the meaning of that field? And in what case the post is owned by community?
-1
votes
1answer
62 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 ...
-2
votes
1answer
79 views

How Stack Overflow save and showing tags? [duplicate]

Possible Duplicate: Database schema documentation for the public data dump and Data Explorer Which tools and technologies build the Stack Exchange Network? I am a user on ...
1
vote
1answer
37 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
0answers
21 views

What are 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.
54
votes
5answers
691 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 ...
16
votes
2answers
449 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 ...
19
votes
5answers
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
84
votes
1answer
648 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 ...
20
votes
2answers
724 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 ...
34
votes
1answer
989 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 ...
12
votes
1answer
423 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 ...
17
votes
3answers
323 views

Magic number in Data Explorer should be documented

There are several columns such as Posts.PostTypeId where the content are encoded as an integer. Although not hard to find out playing with a few queries, what these integers represent should be ...

15 30 50 per page