Questions tagged [data-explorer]
For questions about the functionalities, queries, databases and datamodel of The Stack Exchange Data Explorer (SEDE). SEDE allows you to create and run queries against copies of the databases of popular Stack Exchange sites.
1,574
questions
3
votes
1
answer
54
views
How can I search for tags with that include a specified string in their Usage Guidance?
I would like to search for all tags (on Stack Overflow) that include some specific string in the Usage Guidance portion of their Tag Wiki. How can I do that?
Specifically I would like to search for ...
9
votes
1
answer
193
views
What is going on with SEDE (and SO)? Can it be used only after the weekly update ends?
It seems that at the moment:
After clicking on compose query you get: "Server Error in '/' Application. - Runtime Error". But it works if you use a different site instead of SO.
Running any ...
9
votes
1
answer
150
views
Is there a way (e.g. with SEDE) to find questions with an existing tag that's been synonymized (but not merged) into another tag?
Say Tag 1 has been added as a synonym of Tag 2, so that new questions attempting to use Tag 1 will be automatically pointed to Tag 2. However, the two tags haven't been merged (yet). Then, if you ...
20
votes
0
answers
322
views
Users who can't write good posts ≠ users who want to write good posts
I recently came across this post, which states (emphasis mine):
... The problem that became evident was that people who want to learn how to write a good question and people who can't write a good ...
4
votes
2
answers
161
views
Any plans for a Data Explorer for Area 51?
As the title says...
29
votes
2
answers
839
views
Please provide a way to download SEDE data via an API
I recently suggested on the Stack Apps site that a formal API be added to SEDE, and it was suggested I reference the feature request here, for visibility.
My use case is a query that the API does not ...
2
votes
2
answers
197
views
How to run a Stack Exchange data query with the Stack Exchange API
I'm trying to find out if there is a way to run a query/complex search on the Stack Exchange API.
I need to find all users that have a reputation greater than 250 and are from a certain location. I ...
16
votes
1
answer
720
views
Running queries to StackExchange Data Explorer from anywhere
Now that we have an awesome tool StackExchange Data Explorer, won't its usefulness be multiplied manifolds if we could have a way of embedding queries onto a site that can fetch the results without ...
-1
votes
1
answer
173
views
Increase max SEDE query running time
I see an increasing amount of:
Line 0: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
errors (screenshot) on SEDE due to ...
-5
votes
0
answers
136
views
How can I run SEDE queries on my computer? [duplicate]
Some SEDE queries time out on SEDE. How can I run SEDE queries on my computer?
7
votes
2
answers
249
views
Data Explorer Query crashes with collation conflict error
I have a website built off my Q & A posted in Stack Exchange sites such as; Ask Ubuntu, Stack Overflow, SE Security, etc.
Data Explorer is used to scrape ALL Stack Exchange Q & A I've posted ...
12
votes
1
answer
332
views
What are the indices used in SEDE?
I'm writing an application that uses the Stack Exchange Data Dump. I've imported the most recent dump into SQL Server 2014 on my local development machine.
I wrote a query that runs very slowly on my ...
17
votes
1
answer
268
views
Can we exchange one index for another one?
In the Stack Exchange Data Explorer only the most logical/beneficial yet minimal set of indexes is created for the tables found in the schema.
One of those indexes is on the Users table:
CREATE ...
6
votes
2
answers
245
views
How long does the Data Explorer Refresh take for each database?
Each Sunday at 03:00 UTC the Stack Exchange Data Explorer gets refreshed. It takes 6 to 8 hours to refresh all 350+ databases that hold the Posts, Votes, History etc for the Main and Meta sites.
I was ...
382
votes
2
answers
124k
views
Database schema documentation for the public data dump and SEDE
Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the ...