All Questions
Tagged with support data-explorer
702
questions
9
votes
1
answer
154
views
How do I view "Hot Network Question" history associated with a given account?
I have asked a lot of questions that made it to "Hot Network Question" list across multiple websites in the Stack Exchange Network, and I need a list of all questions posted by me that had ...
5
votes
1
answer
80
views
Missing UserIDs
I'm working on some performance tests for my ORM.
I just noticed this with the 2010; these two queries return results.
SELECT distinct UserId FROM Comments WHERE not UserId in (Select ID From Users) ...
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 ...
8
votes
2
answers
196
views
How can I find posts with particularly large code blocks in a non-code-based site?
From time to time in Space SE a question or answer about a calculation will need to share a significant amount of tabular data, say 100 or 1000 lines. It needs to be forever available to future ...
6
votes
1
answer
175
views
Is the post body of the Stack Exchange data dump sanitized?
I am building a project based on the Stack Overflow data dump.
As per Database schema documentation for the public data dump and SEDE the Body of Posts / PostsWithDeleted is given as rendered HTML and ...
6
votes
2
answers
188
views
SO Dataset query to retrieve questions, related answers and comments with a specific question tag
For a small part of my master thesis I need to retrieve a dataset from SEDE that contains all questions as well as the related multiple answers (and if possible also comments) with the tag "text-...
2
votes
1
answer
145
views
How to get tags of questions answered by a user in Stack Exchange Data Explorer
I can't solve this problem: using a remote DBMS from the Stack Overflow site (URL: http://data.stackexchange.com/stackoverflow/query/new). Write a SQL query that displays the names of users with a ...
9
votes
1
answer
137
views
How can I query SEDE to see the number of questions for a specific tag per year?
Having in mind a specific tag from Stack Overflow (i.e. python). Is there any query to make in SEDE which could provide the number of questions and answers posted per year in the specific tag?
8
votes
0
answers
152
views
Is there a complete list of private guidance for network-wide closure reasons?
There is a difference between what others users see and what the post owner sees when a question is closed.
For example, when a question is closed as a duplicate users see1:
Some community members ...
3
votes
2
answers
103
views
Number of users in a Stack Overflow SEDE query
I tried to run this query on SEDE:
SELECT *
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY u.Displayname DESC) AS row,
u.Id, u.Reputation
FROM
Users u
WHERE
...
3
votes
1
answer
126
views
Do I include way more images in my posts than others, (or do I just post way more)? Can SEDE address this?
The inclusion of images in posts has up and down sides. They convey information and sometimes the question is specifically about the image. At the same time they also consume bandwidth, make for slow ...
4
votes
1
answer
86
views
Why doesn't LIMIT work in Stack Exchange Data Explorer? [duplicate]
For some reason this isn't working in Data Explorer:
select ownerUserId, creationDate from posts LIMIT 1
I'm getting
Line 1: Incorrect syntax near '1'.
What am I doing wrong?
4
votes
0
answers
179
views
Seeking an efficient way (no scraping) to get details about all the SEDE queries in non-HTML (JSON / XML / etc.) format
I am looking for an efficient way to get a dump of the current revisions of (preferably all) the SEDE queries, in a format which is natively queryable (such as XML / JSON). For each query, I ideally ...
18
votes
3
answers
455
views
Is flagging a bunch of "thanks" comments OK?
I made a SEDE query to find all the comments that contained thank, the @ character, weren't saying yes/no to something, and were less than 20 characters. The query is here. It returned over 1400 ...
18
votes
2
answers
225
views
Top network askers?
This is probably very easy for anyone who knows how Data.SE and whatever programming language it uses, but beyond my non-existent programming knowledge.
Is there a way to get a list of who has asked ...