All Questions
12
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/...
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 ...
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
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 ...
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 ...
5
votes
1
answer
231
views
How to query Stack Exchange in LINQPad?
I recently recalled seeing my classmate querying Stack Exchange data using LINQPad (many years ago). When I tried to figure out a way to do this I found an old blog post, Using LINQPad to Query Stack ...
4
votes
1
answer
151
views
Trouble with fetching data
I'm trying to query the following data from stackexchange:
Fetch all the questions asked about Android, in past five years, and display post's id (a.iD), associated tags (a.Tags), for the person ...
17
votes
1
answer
418
views
How to calculate per site meta reputation?
The displayed reputation on per site meta is the same as on the respective parent site. However, out of curiosity, I'd like to see the actual reputation users would have on a meta if it was counted ...
0
votes
1
answer
938
views
How can I query the Stack Overflow database?
Some time ago I saw someone had queried their country's users of Stack Overflow in a sub-site of Stack Exchange (if I'm not wrong). I want to know how I can query Stack Overflow's database.
3
votes
1
answer
84
views
Query: list questions where the OP also left an answer
I was-trying-but-failed-miserably to assemble a query for Stack Exchange to display all the questions where the OP also wrote an answer.
Preferably, the query would hide the results where a question ...