All Questions
Tagged with data-explorer discussion
278
questions
14
votes
1
answer
555
views
What caused the drop in questions in April 2023?
Rerunning this query by starball for new questions and answers posted across the network generated the following graph:
It plots posts by their creation date, and includes deleted posts.
The decline ...
7
votes
1
answer
144
views
What site should I post a question about an error given from a SEDE (Stack Exchange Data Explorer) query?
I am working on composing a SEDE (Stack Exchange Data Explorer) query to find questions from 3-4 months ago that do not have any accepted answers that I feel like I could answer (as in limiting it to ...
3
votes
1
answer
121
views
Discrepancy in Post Counts between Local MySQL Stack Overflow Database and Data Stack Exchange Query
I recently downloaded the Stack Overflow data from Stack Overflow datadump and imported it into my local MySQL database. While attempting to retrieve the total number of posts for the year 2021 using ...
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/...
1
vote
0
answers
40
views
View "people reached" data/trend through time for user
Is there a way to view a trend (graphically or tabulated) in the number of "people reached" per user per site?
E.g., to see how many people a user's posts impacted monthly or annually, etc.
...
1
vote
0
answers
31
views
Where is the GitHub link in the Data Exchange Explorer located? [duplicate]
I went closely over the SEDE's fields, but couldn't find where the GitHub link is saved for a user:
I ran this query on my own profile but couldn't find my GitHub account.
4
votes
1
answer
153
views
How do I get the highest posters for a certain tag in a specific country?
I would like to get the user IDs, user names, the number of posts, and the total score for a certain tag for each user in a specific country (sorted in descending order by score).
For example, in the ...
2
votes
2
answers
93
views
How can I get the total number of posts for a user that have a certain tag in them?
User abbood (myself) has eight posts (in total) that have the tag cocoapods; six questions and two answers.
I thought that this query should simply get all eight:
SELECT Count(*)
FROM posts p
...
0
votes
0
answers
60
views
Why isn't the summation of a user's score equal to their reputation? [duplicate]
I was going over the database schema documentation and was trying to understand how the Post scoring system works. I was expecting this query:
select sum(p.score)
from posts p
where p.OwnerUserId = ...
34
votes
1
answer
268
views
The current SEDE refresh was delayed overnight
On Saturday, January 22nd, we had a failure on a backup share that won't be fully resolved until Monday.
We've immediately re-routed backups to multiple secondary locations, so that concern has been ...
4
votes
1
answer
52
views
How do I extract posts from Data.SE that contain code in them?
I'd like to extract posts from Stack Overflow using Data.SE, that contain code in them. I am mainly interested in the posts that come from the tag [artificial-intelligence]. Here is the code that I ...
3
votes
1
answer
89
views
Why can I not filter the Posts table in data.stackexchange by tags?
While trying to write a query on https://data.stackexchange.com/datascience/, using the Posts table, I cannot filter by tags.
For instance, if I try to extract the tags from the Posts table:
select ...
9
votes
1
answer
104
views
Is there a way to filter posts created with the Ask Wizard in the Data Explorer?
Stack Overflow recently re-debuted the Ask Wizard for use by new users.
Using the Data Explorer, is there any (current or planned) way to query posts that were created using this tool?
7
votes
2
answers
253
views
Query for getting top users on a specific tag by country sorted by tag score (Stack Overflow)
I need a query for getting top users on a specific tag by country sorted by tag score on the Stack Overflow site.
For example.
Top users of JavaScript that live in the United States and sorted by ...
1
vote
0
answers
83
views
Is there a way to check the change of geographical distribution of user base on SE?
I found geographical distribution checkers on SEDE, but is there a way to see how the population changes with time?
I want to see, for instance, from what country most people are joining vs from what ...