All Questions
Tagged with data-explorer stack-exchange
26
questions
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/...
4
votes
1
answer
106
views
How do I access this built-in SEDE functionality to run multi-site queries?
Queries in the Stack Exchange Data Explorer are usually run over one database, i.e. a single Stack Exchange site. It is possible to do a multi-site query by fully qualifying tables (including the ...
14
votes
3
answers
188
views
Is there a page listing the founding date and the "out of beta" date for all Stack Exchange communities?
Just out of curiosity I would like to see a list of all Stack Exchange communities along with the founding date and "out of beta" date.
If the list can be generated using a query, that would ...
1
vote
1
answer
54
views
How do I find all questions containing certain text and the user is from a certain country?
I am trying to build the following query:
Find all questions containing certain text and the user is from a certain country.
What I have done so far is:
SELECT q.Id AS [Post Link],
q....
4
votes
1
answer
76
views
How can I find the number of communities for a user in the Stack Exchange data set?
Is there any way I can extract, from the Stack Exchange data set, the communities that a user joined?
I want to use this data set to extract this feature for all users:
https://archive.org/download/...
4
votes
1
answer
59
views
The query on Stack Exchange Data Explorer returns different results from Stack Exchange website
I am running this query on the Stack Exchange Data Explorer (for Stack Overflow):
select owneruserid
, row_number() over(order by rep desc) as ranking
, rep
from (
select p.owneruserid
,sum(...
1
vote
0
answers
36
views
Data Explorer: Shrink query window a little more
The "Query Window" textbox on data.stackexchange.com is already stretchable, but it would be helpful if the minimum height were set "even smaller".
When testing quick edits to a query, it would be ...
3
votes
1
answer
155
views
How to get data (question details) of a specific Stack Exchange site?
I am working on a data science project for which I need data (questions and corresponding tags) of a specific Stack Exchange site, Academia SE for example. From this blog we know that SE data is ...
7
votes
2
answers
104
views
Which SE site has the most questions associated with a given [tag]?
Is it possible to do a list of SE sites sorted by the highest appearance of questions with a given tag? For example [markdown]?
Something like:
Stack Overflow 3970 questions
...
TeX 119 questions
I ...
2
votes
1
answer
65
views
How history of posts are stored and how diffs are created
I like the way Stack Exchange presents diffs of (suggested) edits (or "posts" in general). At the moment I am experimenting with a webapp (with a relational DB in the backend) and I want to try to ...
2
votes
0
answers
55
views
How to retrieve "badge type" in Data Explorer?
I'm trying to write a query (Badge Order Received) on the Stack Exchange Data Explorer, within whose results I want to link to a user's awards of a given badge. On Stack Overflow, such a link may be ...
1
vote
1
answer
95
views
Is there a site dedicated to Stack Exchange Data Explorer questions?
Where should I ask questions about the StackExchange Data Explorer?
I found this page which explains that stack exchange data is dumped somewhere, and in the help section I am told to ask questions ...
2
votes
1
answer
112
views
Querying for reputation of the commenter and its addressee using SEDE
How can I modify this Data Explorer query for the case when user of the comment is same as the poster, then the query should look for the tagged user in the comment and print the tagged user ...
7
votes
0
answers
63
views
UsersHistory Table on SEDE
Stack Exchange Data Explorer is awesome!
It's an invaluable tool to analyze a site's activity, monitor unanswered questions and answering time, or just to fetch a dataset for further analysis of ...