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
2answers
77 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 ...
5
votes
0answers
258 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 ...
1
vote
1answer
57 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.
25
votes
1answer
805 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
103 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
183 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
1answer
616 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
496 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
212 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
2answers
360 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
142 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
363 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
474 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
321 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
440 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 ...
2
votes
1answer
305 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
203 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
288 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
74 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
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 ...
2
votes
1answer
87 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
336 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 ...