All Questions
22
questions
3
votes
1
answer
523
views
How can I download a small data set (1 year 2023-2022) from Stack Exchange?
I want to download a small dataset for one year. I didn't find a link that allows me to download 1 year of data or the last five years' data.
I tried "https://data.stackexchange.com/stackoverflow/...
7
votes
1
answer
146
views
Most upvoted comments across Stack Exchange (Cross site query)
I was interested in finding out the most upvoted comments per user across the entire Stack Exchange network (cross-site query).
I found this query, which works very well, but only for one site at a ...
3
votes
1
answer
74
views
How can I view top contributors in a country by week?
I just want to view the top contributors based on the reputation points by this week in a given country.
select row_number() over(order by reputation desc)
, reputation
, views
, id as ...
5
votes
0
answers
135
views
What are reasonable ways to check if activity on a site (or the whole network) has decreased?
I have encountered in various chatrooms discussions whether recently (for obvious reasons) there has been decrease of the activity on a specific site. (Or that some site has less visitors or less ...
4
votes
1
answer
77
views
How can I find people who have asked a large number of high quality unanswered questions on UXSE?
I am looking to try and reduce the number of unanswered questions on the UXSE site by identifying high quality questions that hasn't been addressed probably because it is either difficult to answer or ...
1
vote
1
answer
214
views
How can I find the number of total questions and unanswered questions, for each month, for the 10 most popular tags on Cross Validated
I'd like to write a query in the Stack Exchange Data Explorer for the Cross Validated site, which returns me the Question and Answers on Cross Validated by month and by tag, for the 10 tags which ...
6
votes
0
answers
42
views
Is it possible to estimate the active reviewer population using the SEDE data?
My main site has, I think, a problem with a shrinking reviewer population, and I would like to use the SEDE data to estimate whether this is indeed the case and, if so, how bad it is and how it has ...
1
vote
0
answers
32
views
Is it possible to obtain data on the evolution of questions' views over time? [duplicate]
In the SE data dump we can obtain a snapshot of the number of views over time. In particular, it is in the Posts table. I am looking for data on the evolution of views over time.
My question is ...
2
votes
0
answers
73
views
Magic Column [User Link] produces "Out of Resources" error on simple SEDE queries
Question shrunk since the issue is known and will be addressed in due time. (View complete question.)
Error in SEDE when using magic column:
Example #1: Control query (no magic column).
...
5
votes
1
answer
102
views
Why is len(Posts.body) incorrect on answers in data.SE?
I was trying to find a longest answer on a site, and ran into a weird discrepancy:
This query shows that this answer has a length of 36388 (length in the query is defined as LEN(Posts.Body))
Yet, the ...
4
votes
2
answers
81
views
Can I query the SEDE for what fraction of close reviews are initiated by flags?
I would like to know what fraction of the recent close-vote review tasks were initiated by a flag cast by a user under 3k reputation (as opposed to tasks assigned to the queue by a close vote by a 3k+ ...
6
votes
1
answer
173
views
How do I make a bar chart in the Data Explorer?
I've been wondering if there was a way to graph something in SEDE other than a line graph, because line graphs are boring. I figured out how to do a scatter plot, but it's still not as cool as a bar ...
4
votes
1
answer
57
views
Finding users with highest percentage of accepted or top voted answers?
I am attempting to improve a data.SE query to find users with the highest percentage of accepted answers to include a percentage where the answer is not accepted, but highest voted.
This query works ...
18
votes
1
answer
141
views
Useful Data Queries
Over on Worldbuilding, we've come up with a list of data queries. HDE226868 suggested that these queries might be useful to other sites, and we should post them on Meta: this is the result.
This post ...
12
votes
2
answers
135
views
How can I find posts that need editing using Data Explorer?
Is there a way, using Data Explorer queries, to find posts with chatty noise such as 'Hello guys' (or 'people', 'hi there', 'help me our', etc.)?
It occurred to me that I could try something like ...