Linked Questions

382 votes
2 answers
124k 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 ...
20 votes
2 answers
621 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.
Juha Syrjälä's user avatar
4 votes
1 answer
208 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 ...
dermoritz's user avatar
  • 173
6 votes
1 answer
668 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 ...
Przemyslaw Remin's user avatar
3 votes
1 answer
686 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 ...
r2j2's user avatar
  • 73
1 vote
1 answer
95 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 ...
D A's user avatar
  • 120
5 votes
1 answer
57 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 ...
Wildcard's user avatar
  • 6,482
8 votes
0 answers
197 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 ...
rene's user avatar
  • 91.1k
3 votes
1 answer
67 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 ...
bigblind's user avatar
  • 663
3 votes
0 answers
104 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? ...
Jonathan Solorzano's user avatar