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.

Filter by
Sorted by
Tagged with
4 votes
1 answer
315 views

Measuring the health of MSE over time (in terms of activity)

I'm wondering if there's a way to see site health diagnostics, like: the number of active users currently on the site (cf. Reddit has this feature), perhaps with further data on the tags to which ...
  • 6,006
1 vote
0 answers
94 views

What are the hottest sinks on Mathematics SE? [duplicate]

Consider the directed graph in which nodes are questions on Mathematics SE and (directed) edges are links from one question to another question. What questions have the highest in-degree? Can one find ...
4 votes
2 answers
93 views

Is there a functioning tracker for the number of questions that need review in the close queue?

Recently, the number of items that need review in the close queue stood at $10$, nearly into the single digits. Here is a screenshot: I was curious and searched for a way to track the number of ...
  • 16k
8 votes
0 answers
278 views

HNQ-title ban list should be data-based; but we don't have the data

In reference to this discussion on title ban for HNQ An empirical approach would be far better than what we're doing right now imo. More specifically, a keyword should be banned for HNQ if the ratio ...
0 votes
1 answer
59 views

Inactive posts for the last six months

I wonder how to find all the inactive for at least 6 months posts in mathstack? Thanks.
  • 3,184
24 votes
1 answer
819 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 ...
  • 24.8k
1 vote
1 answer
111 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?
  • 44.4k
8 votes
1 answer
189 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 ...
20 votes
1 answer
663 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 ...
  • 8,746
13 votes
1 answer
508 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 ...
's user avatar
1 vote
2 answers
233 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 ...
5 votes
2 answers
365 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 ...
  • 41.8k
1 vote
2 answers
146 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
1 answer
367 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.
  • 52.2k
2 votes
1 answer
564 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....
  • 15.6k
21 votes
1 answer
366 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
1 answer
446 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 ...
  • 14.3k
1 vote
1 answer
353 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 ...
's user avatar
8 votes
1 answer
208 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 ...
  • 41.8k
1 vote
1 answer
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?
  • 15.7k
12 votes
2 answers
353 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 ...
  • 375k
2 votes
1 answer
78 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 ...
  • 15.7k
2 votes
0 answers
113 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 ...
  • 36.5k
2 votes
1 answer
92 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 ...
  • 18.3k
10 votes
2 answers
346 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 ...
  • 5,477