Linked Questions

313
votes
2answers
66k views

Database schema documentation for the public data dump and SEDE

Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the Stack Exchange ...
3
votes
1answer
146 views

Is there any documentation about the data model behind the reputation system?

While I found some good articles about reputation systems in general, and Stack Overflow in particular, I didn't find any article about the data model used. I know the data is stored in a MS-SQL ...
5
votes
1answer
236 views

Data Explorer query to get my post with specific tag

I would like to select all my posts with a specific tag with Data Explorer. Some posts may have multiple tags. If my specific tag is say powerbi I would like to select also all the posts that have ...
11
votes
1answer
553 views

Add better descriptions and E/R diagram to Data Explorer's schema

Schema should show descriptions and possible values for fields. Maybe it should even have some kind of entity-relationship diagram for the tables.
1
vote
1answer
83 views

Is there a site dedicated to Stack Exchange Data Explorer questions?

Where should I ask questions about the StackExchange Data Explorer? I found this page which explains that stack exchange data is dumped somewhere, and in the help section I am told to ask questions ...
5
votes
1answer
54 views

Which of my answers have been upvoted on the most days?

My theory is that answers which have received upvotes on 15 distinct days spaced across a year were in fact more valuable than answers which received 100 upvotes within a 2 day period (after reaching ...
2
votes
1answer
202 views

Getting data from Stack Overflow?

I intend to analyze data derived from the user behavior on Stack Overflow (i.e. the number of questions asked in the last five years, upvotes, number of users common to "Android" and "iOS" dev ...
7
votes
0answers
155 views

There are no foreign-keys constraints in the data-explorer database

While creating the answer for Database Diagram of Stack Exchange model? I was looking for the schema information stored in the SEDE database. The sys.tables and sys.columns are populated but when I ...
3
votes
1answer
57 views

Get bounty reason in data explorer

I'm trying to understand which bounty reasons get the most usage, but I can't find the bounty reason anywhere in the database schema. Also, is there any way to do a keyword search on all the table ...
3
votes
0answers
80 views

Is SODDI still working with Data Dump?

I'm following this guide: How to Query the StackExchange Databases, but when trying to connect with SQL Server 2014 it doesn't let me connect to the db. Does SODDI work for the data of January 2015? ...