Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [data-explorer]

The Stack Exchange Data Explorer (SEDE), located at data.stackexchange.com, allows you to create and run queries against copies of the databases of popular Stack Exchange sites to investigate trends or satisfy your curiosity.

2
votes
0answers
127 views

Are there (public) stats about how many users are banned to ask more questions per month or year in the site Mathematics Stack Exchange?

I would like to know, if it is possible, how many users are banned to ask more questions per month or year. I'm asking for an approximation. Also I would also like to know if these users are typically ...
18
votes
0answers
689 views

Who Maximizes the Ratio of “People Reached” to “Questions Answered”?

Whoever maximizes the ratio $$ \frac{\text{People Reached}}{\text{Questions Answered}} $$ must have an uncanny sense for which questions are going to be heavily viewed and worth answering. In some ...
1
vote
1answer
96 views

List of users by number of badges?

Where can I find a ranking of all mathSE users by total number of badges? Where can I find a ranking of all mathSE users by total number of gold badges?
8
votes
1answer
148 views

How can I find statistics on number of edits on math.SE?

How can I find various statistics about number of edits done on math.SE. For example, if I am interested in number of edits per day/month/year and how these numbers have evolved, number of edits done ...
21
votes
1answer
573 views

Average Q/A score?

Is it currently possible to get a mean score for either questions or answers for yourself, or other users? The motivation behind asking, is that sometimes total reputation is not always a clear ...
13
votes
1answer
483 views

How many posts get deleted, and what are they?

Stack Exchange Data Explorer now includes the table PostsWithDeleted, which, as the name suggests, includes some data on deleted posts. (Meta announcement.) The content of deleted posts is not made ...
1
vote
2answers
198 views

Are most of the SE users American? (And can SE publicise itself more?)

Is there any public data on which nationalities do most SE (dominated by SO) users belong? I was curious because I'm from India. Hardly anyone knows of the site, and I got to know from the net. I ...
6
votes
2answers
357 views

Accepted answers rate low - actions?

More than a year ago I asked about the Accepted answers rate. Back then I think the conclusion was that the rate had just dropped below $50\%$. If I understand the query it has dropped to $34\%$. My ...
1
vote
2answers
129 views

How can I query the question database?

How can I query the question database? For example, at this moment I would like to see the questions with 0 answers for the tag elementary-number-theory. Is there a query syntax? Are there more query ...
11
votes
1answer
359 views

Can we observe the 24-hour cycle distribution of when votes are cast?

Is there a way to view a distribution of numbers of votes cast (for questions or for answers) over the 24-hour daily cycle? Or over a full weekly cycle? I didn't find such a query at data.SE.
1
vote
1answer
369 views

Most upvoted answers

How to get the list of top $N$ answers that have been upvoted the most? For questions it is very easy, but not for answers. I don't expect some hidden web page, but a database query would be perfect....
19
votes
1answer
317 views

How to obtain the math.SE network whose edges are linked questions?

Q: What is the best way to obtain the math.SE network whose edges are linked questions? I.e., the network whose nodes are the on the site and we have an undirected edge from node A to node B ...
14
votes
1answer
430 views

What is the rate at which questions are typically upvoted?

Every now and then I get a stray upvote for an answer I answered months ago. Usually these are for the more prominent answers I've given. But most of the time, the upvotes I get are shortly after I ...
1
vote
1answer
267 views

Backup, save, download all questions and answers for individual users

Why can't I run data queries on the Math Site?, How do I know I won't lose all my work in math.SE? say there are data dumps for math.se. But how do I download only the data for one user? This ...
8
votes
1answer
199 views

Accepted answers rate

Is there a way with a query to calculate how the number of questions with accepted answers divided by asked questions has changed over time? One could, for example, find this as function of each month ...
1
vote
1answer
75 views

Are there any methods so that I can search for all users who earned the particular hat?

Are there any methods so that I can search for all users who earned the particular hat(s)? Is Data Explorer helpful for doing those by writing some new queries?
11
votes
2answers
287 views

My very own tags

The badge Taxonomist is given when a user creates a tag which reaches 50 questions. This means that somewhere in the system there is an assignment for the user who created a tag. Is there any ...
2
votes
1answer
70 views

Can Data Explorer do those things?

Can Data Explorer do those things? For example: Search all of the questions which have the only tag of the particular tag Search all of the questions which have the particular tag(s) but haven't the ...
2
votes
0answers
110 views

Why the up-votes and down-votes does not sum up to reputation?

I know there are minor differences between votes sum and reputation, like the fact that no user can have negative reputation. However, the sum of the up/down-votes and bounties differ from the ...
2
votes
1answer
81 views

Eliminating some questions from the unanswered queue by upvoting using data query

I am using this data query provided by user75064,ˈjuː.zɚ79365, 40 votes and Lord Farin to upvote some answers with no upvotes but actually address some/all concerns of OP. The data query is looking ...
10
votes
2answers
334 views

Why can't I run data queries on the Math Site?

Maybe this question has already been asked, but I can't seem to find Math.SE on data explorer. On other sites there have been some useful queries run, and I was hoping to look into the Math site, but ...