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,407
questions
5
votes
2answers
19 views
How can I get URLs and site names for a cross-site SEDE query?
When doing cross-site queries on the Stack Exchange Data Explorer, two of the main problems are 1) getting the URLs right and 2) getting the site names right. For URLs, we have constructions like the ...
3
votes
2answers
50 views
Get the dates of last five answers by top users
I've been trying to get the dates of the last five answers by the top 50 users (say Reputation > 3000 AND Count(Posts.Id) > 50). I've modeled my SEDE query after another popular query and here's ...
2
votes
1answer
49 views
Having difficulty listing my comments on Stack Exchange Data Explorer [duplicate]
I'm having difficulty listing my comments on Stack Exchange Data Explorer. I'm not experienced with it.
I tried this query, and it didn't list anything. 42672 is my id on SuperUser.
SELECT
Id AS [...
3
votes
1answer
40 views
Data and statistics regarding the subject of duplicate questions?
Browsing the WordPress community, there seems to be many questions on the same exact problem, such as: using .htaccess to redirect to HTTPS... Obviously, we are not searching (enough) prior to asking.
...
7
votes
1answer
56 views
How to escape single quotes in SEDE ##keyword## search?
The interactive SQL explorer interface for https://data.stackexchange.com/ has a convenient feature where you can request user input in a text field using syntax like ##variable##. But the ...
10
votes
1answer
206 views
Users should have the “Unsung Hero” badge, but they have not
I wrote a SEDE query to find the users who should have the Unsung Hero badge, but they have not.
The query simply counts the non-CW, not self-accepted, but accepted answers of the users, and compares ...
6
votes
0answers
95 views
Why do I have to log in again to https://data.stackexchange.com/ frequently? [duplicate]
I stay logged in on https://*.stackexchange.com for weeks except on https://data.stackexchange.com, where I have to log in again every few days. Why?
5
votes
1answer
163 views
What percentage of questions which are deleted by the Roomba later get undeleted?
I'd like to know the percentage of questions that are deleted by Stack Exchange's automated deletion scripts, which later get undeleted, on each site.
Initially, I thought I could query for this in ...
3
votes
2answers
67 views
Please make post lockedness meta-data available in the SEDE
My subjective experience is that the count of the mod-locked questions is growing, and I feel this starts to cause more and more troubles with time.
I think, adding some new columns to the SEDE ...
24
votes
1answer
516 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 ...
12
votes
1answer
187 views
Overlapping text in Database Schema SEDE
Over at SEDE, there is overlapping text in the Database Schema under Close-As-Off-Topic-Reason-Types:
that makes it really hard to read. This is also happening underneath "Pending Flags", ...
39
votes
2answers
742 views
Include a line number when there's a syntax error
When there's an error in a SEDE query, you just get the error message.
Incorrect syntax near '*'.
This can leave me guessing as to which one of the * in my query is causing the error.
SSMS seems ...
21
votes
2answers
602 views
Add better descriptions and E/R diagram to Data Explorer's schema
Schema should show descriptions and possible values for fields. Maybe it should even have some kind of entity-relationship diagram for the tables.
3
votes
1answer
58 views
How can I see the percentages of the data coming from different websites on Stack Exchange?
I have to write a data description of the data collected using the query below.
SELECT p.Title,p.Body,c.Text
FROM Posts p
JOIN Comments c ON c.PostId = p.Id
-- filter on tags
inner join posttags pt ...
7
votes
0answers
46 views
The Stack Exchange Data Explorer reports an error on Line 0
In the fix I wrote for Include a line number when there's a syntax error
I tried to handle both regular errors and errors that come with an Line number:
if (response.line) {
msg = 'Line ' + ...
7
votes
1answer
48 views
What can I do to find how many distinct users contribute to all the posts and comments this query seaches for?
I have used the query below to form a result table and now I need to find how many users are contributing to it. Is there any way I can achieve that?
SELECT p.Title,p.Body,c.Text
FROM Posts p
JOIN ...
14
votes
3answers
168 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 ...
53
votes
15answers
2k views
Can we become our own “Northwind” for teaching SQL / databases?
In the Microsoft ecosystem there are some standard databases like Northwind ...
The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, which ...
5
votes
4answers
202 views
How can I query SEDE for tags I've created?
How can I query the Stack Exchange Data Explorer for tags I've created?
2
votes
0answers
22 views
Incorrect name and broken image for site at SEDE [duplicate]
Over at SEDE, on the list of sites, Psychology & Neuroscience is still listed as "Cognitive Sciences" and the image is scrambled:
Can we fix that?
2
votes
1answer
28 views
SEDE search mashes together “X queries containing” multiline text
An example query. If the search query is big enough so that it spans two lines, it blurs:
Can we free the bottom half of "containing" and add a bit more space?
-9
votes
3answers
304 views
What are the sites that allow questions without details and any research?
A few days ago I posted a feature request asking to block questions where the title is equal to the body.
Someone argued that there are SE sites that "do not require research". I think that ...
-7
votes
1answer
101 views
It is already 11:13 (UTC), but the SO snapshot did not arrive at the SEDE [closed]
It is already 11:13 (UTC) and the weekly SO snapshot is not yet on the SEDE. Last week it could have been synced until 05:09 (UTC)1.
Other sites look fine.
Are your scripts okay?
1This is coming from ...
15
votes
8answers
818 views
Is it harder to write a good question or a good answer?
I was wondering whether there's any evidence to be had as to whether it's harder to write good questions or good answers.
For example, from the data available in SEDE or previous surveys.
I suppose "...
12
votes
1answer
228 views
Color of site icons on Stack Exchange Data Explorer is (not technically incorrect but) confusing
In the Stack Exchange Data Explorer, the icon color for the various sites seems* incorrect: Whenever I select a main site, the icon is greyed out, and when ever I select the corresponding meta site, ...
8
votes
3answers
745 views
Chrome warns me my connection is not secure when authenticating in SEDE with a Google account
When I go to the login page of the Stack Exchange Data Explorer here and click the Log in using Google button, I'm not getting logged in but instead greeted with a Chrome message protecting my privacy:...
4
votes
1answer
75 views
How can I check if a specific user has answered any of my questions?
Is there a way to check a specific user has answered a question of mine or not?
If the user did answer some of my questions, how can I get the list of those questions with the answers' links?
...
337
votes
2answers
77k 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 Stack Exchange ...
14
votes
1answer
139 views
Expose moderator-only and required tags in SEDE
The API has two methods to get a list of required tags (the gray ones) and moderator-only tags (the red ones):
required tags
moderator only tags
That means there must be an enumeration (or two ...
16
votes
1answer
113 views
How can I find my posts that use “old school” table format?
Now that the Table support feature Feature Preview: Table Support live, I would like to update my posts that still use the workarounds to show tables. Basically posts where I went nuts with dashes, ...
4
votes
1answer
103 views
SEDE thinks I'm running 2 queries at once
I was just told that I can't run another query:
Too many queries are running, you may only run 2 queries at a time
But I was only running one. Why did it tell me this?
Does running one for Stack ...
2
votes
1answer
87 views
How can I view the median number of views on questions in a given SE website?
Ideally, I also would like to see the standard deviation, average and interquartile range (IQR), add have some way to plot question age vs. median number of views on the questions with IQR or standard ...
17
votes
0answers
71 views
Add 'Export as Markdown' option to SEDE
Now that Markdown tables are a thing, can we please have an option in the Stack Exchange Data Explorer to export the data in a format that's ready to paste in a Stack Exchange post?
I mean, I can do ...
4
votes
1answer
89 views
How to get time of question posting and question migration of a Stack Exchange websites?
I want to retrieve time when a question is posted on a Stack Exchange website and time when its migrated (Basically time difference between question posting and migration).
Is there any way to get ...
7
votes
1answer
62 views
Which data dump has the information related to mentioned users in a comment
From the Stack Exchange API, I can retrieve the comments in which a specific user is mentioned using @ method.
Here is the /users/{ids}/mentioned API.
Which data dump on archive.org hosts this ...
1
vote
0answers
61 views
How to find votes that were made with under 15 reputation [duplicate]
I've been using the LaTeX Stack Exchange site for a while to assist my learning of LaTeX. In this time, I have upvoted questions and answers that I found to be helpful. However, these weren't "...
12
votes
1answer
124 views
Descriptions for review task result types 22 and 23 are swapped in SEDE
The descriptions for review task result types 22 and 23 are swapped in the Data Explorer.
For context, these are the internal database numbers used to indicate the type of review someone made on a ...
2
votes
1answer
65 views
Finding meta.stackexchange.com on Data S.E [duplicate]
It is well known that Data Explorer can extract data from all Stack Exchange sites, even including meta sites and Primary Meta Stack Exchange (metaSE).
I request for the functionality to switch sites ...
3
votes
1answer
68 views
Upvotes I have for each tag is not consistent with what my page says
I came across several queries that calculate the upvotes I have for each tag and found the statistics are not the same as what my own page displays. For some tags, the calculation is less, while some ...
4
votes
3answers
69 views
Find questions where any of the tags are in the title or body?
I would like to find posts where any of the tags are present in the title or body of the question, e.g. Python and C# are the tags and title is Fix my Python Problem?
SELECT TOP 10
Posts.Id,
Posts....
5
votes
1answer
53 views
How can I list posts which have a particular tag, but didn't have it when originally asked?
I would like to gather some hard data on the use / misuse / non-use of some particular tags. I need a Data.SE query, customisable by tag, which can provide me with a list of all posts which:
have had ...
-5
votes
1answer
87 views
“Execution Timeout Expired” while trying to write a query to find the posts and comments related to Winter Bash
SELECT p.Title,p.Body,c.Text
FROM Posts p
JOIN Comments c ON c.PostId = p.Id
WHERE p.Body like '%Winter Bash%'
AND p.CreationDate < '2015-12-31'
And p.CreationDate > '2011-01-01'
ORDER BY p....
3
votes
0answers
65 views
Find users who bookmarked a question? [duplicate]
Is there any data explorer query that allows to find the users who bookmarked a specific question?
EDIT:
I tried searching for a direct hit on data-explorer but didn't find any post having a ...
4
votes
2answers
77 views
Top users list of answerers that includes post count
I wanted a query like this that ranks by answer vote count for a given tag but that also includes a column with the number of answers.
Essentially a replica of the topusers page list for all-time ...
5
votes
0answers
40 views
SEDE Graph add column names as label for axis
This graph result shows number of post (y-axis) over the last months (x-axis).
The query result has this format
MonthsAgo | TagName | NrOfPosts
-------------|----------------|-----------...
14
votes
2answers
103 views
The votes table doesn't have the votes for deleted posts, does it?
Over the weekend I had a major mishap in my understanding what the Votes table in the Stack Exchange Data Explorer actually contains.
For the last 6 to 8 years I assumed the schema only contains data ...
4
votes
1answer
45 views
Link to GitHub StackExchange.DataExplorer has incorrect formatting, in Applications profile tab
In my applications tab, I noticed that the link to the GitHub StackExchange.DataExplorer had incorrect formatting (the bit where it says [open source]:
It doesn't actually look like it has incorrect ...
-9
votes
1answer
128 views
Why are people casting fewer votes [closed]
Fewer people are casting their votes. Check these queries:
Votes
https://data.stackexchange.com/stackoverflow/query/1303081/votes-on-posts-year-on-year
Posts
https://data.stackexchange.com/...
6
votes
0answers
49 views
Change SO login to show Stack Overflow icon rather than Stack Exchange icon SEDE
When I go to login at SEDE, I usually login with Stack Overflow, but the SO login is using the icon from Stack Exchange:
Could we change that to Stack Overflow's icon ()? It's a small thing, but I ...
21
votes
1answer
535 views
Data Explorer syntax or language reference?
Where can I find a syntax or language reference for the query language used on https://data.stackexchange.com/?