Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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 environments, etc.). I have to use the data retrieved to create models depicting the manner in which these two technologies have grown over time. It would really help me if someone (who has prior experience with deriving data from Stack Exchange) could give some inputs on this.

share|improve this question
Do you have a specific question? Are you stuck with some part of the process? Try to add more detail so people can give you specific advice. – Pëkka Mar 5 '13 at 21:16
When it comes back online, you can get all your data from, I'm sure. – Martijn Pieters Mar 5 '13 at 21:16
The box is back up and we're copying databases across the network now, ETA to it being usable again is about 30 min – Nick Craver Mar 5 '13 at 21:17
For starters, there doesn't seem to be any resource that I could use to get started with [link]( I'm not at all aware of the underlying schema of this database and I suppose that I would have to query it to get the needed details. If you know of any online resource that I could use, I'd be obliged. – r2j2 Mar 5 '13 at 21:19
@r2j2 - the schema is listed on the right-hand side as part of the data explorer. Additionally, we are preparing a data dump based on that very data now...the hardware upgrade we just performed was partially for a fully automated data dump we try and provide on a regular basis...automating it should make it regular again. – Nick Craver Mar 5 '13 at 21:54

Here are some queries to get you started:

More ready-made queries can be found in What SEDE examples would be most useful to new users?

The explanation of the schema can be found in Database schema documentation for the public data dump and SEDE and The Data Explorer as a FAQ for itself. The database is hosted in a SQL Server instance so you can use most of the T-SQL statements.

In this answer of mine you'll find an ERD model.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .