11
votes
1answer
532 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
256 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?
-2
votes
1answer
86 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
votes
1answer
65 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
47 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.
56
votes
5answers
701 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
472 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 ...
23
votes
2answers
830 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 ...
85
votes
1answer
693 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
1answer
652 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 ...
11
votes
2answers
256 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 ...

15 30 50 per page