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,540
questions
3
votes
1
answer
97
views
Missing space in SEDE tutorial text
There's a missing space between the x and "to" in the SEDE tutorial (when viewed on my Android v.11 Galaxy XCover Pro, with Google app version 12.41.19.23.arm64):
- 2,140
18
votes
3
answers
445
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 ...
- 9,092
18
votes
2
answers
222
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 ...
- 32.7k
5
votes
2
answers
104
views
Use cron to get SE Data Explorer data when it's updated
According to this answer from 2012, the SE Data Explorer data is updated every Sunday at 3am. If true, is it possible to schedule a cron job to run every Monday and execute this query?
When the query ...
- 287
3
votes
1
answer
53
views
Extract data for several user ids in SEDE
How do I extract data from data.stackexchange.com for several user ids?
I'm trying to do
select * from posts where (owneruserid = 123 or owneruserid = 456);
but it only outputs the results for the ...
8
votes
1
answer
154
views
Up-vote frequency per capita ordered by country
As a social experiment, I'm curious to know if users in certain countries up-vote more than others. Maybe the answers help users in some regions more than others, or maybe users in those regions are ...
- 381
3
votes
2
answers
175
views
Modifying existing SEDE query to output the post's URL
There is this existing SE Data Explorer query: All my posts on the SE Network
The query is awesome and works great with one small flaw (IMO). It outputs a "Post ID" which is useless for me ...
- 287
4
votes
1
answer
50
views
Query to get users with highest number of sites with at least one famous question
I want to know who are the top users across all sites in terms of number of sites in which they've got at least one famous question (so, count is across sites, not across famous questions).
I know ...
- 594
24
votes
0
answers
1k
views
Planned SEDE maintenance scheduled for Oct 15, 2021 and Oct 16, 2021 15:00-17:00 UTC (11am-1pm ET)
Update 4: 2021-10-16 16:33 UTC: Today's window is done. Actual user-visible downtime was negligible. Thanks for bearing with us! This round of maintenance is done.
Update 3: 2021-10-16 15:00 UTC: ...
- 7,226
4
votes
0
answers
111
views
Obfuscated Ask Ubuntu logo when composing a query on SEDE [duplicate]
When composing a query for Ask Ubuntu on SEDE, the logo for that site in the upper-right corner shows up like this:
Without the "Ubuntu" part, and it looks like this happens elsewhere on ...
- 26.7k
6
votes
1
answer
128
views
Is there a way to see the date/time I bookmarked a question?
Is there a way to see the date/time I bookmarked a question? I looked at How do question bookmarks work?, but my question was not addressed. I know that on my profile page I can go to the “Votes” tab ...
- 171
9
votes
2
answers
141
views
Is null assignment of `ClosedDate` column of Posts table from Stack Overflow Data dump correct?
In the Stack Overflow data dump, I can see some posts whose ClosedDate column from the Posts table is null, but their PostHistoryTypeId = 10 (which represents post was closed) from PostHistory tables.
...
- 113
39
votes
0
answers
2k
views
Planned SEDE maintenance scheduled for Sept 22, 2021 at 01:00-04:00 UTC (Sept 21 9:00 pm-midnight EDT)
Note: The originally planned second window on Sept 24 is cancelled as the upgrade was a success within the first window.
Note: 2021-09-21 0225Z - Maintenance has ended. Please leave a comment if there ...
- 1,514
7
votes
2
answers
196
views
Is there any user data that can be used to infer how many answers are read on individual posts?
On Skeptics we are discussing the new "unpinned answer" feature and I had the thought that perhaps the discussion often assumes the premise that only the top answer is typically read. I don'...
user803868
18
votes
1
answer
137
views
The SEDE refresh job didn't start
Normally, at 03:00 UTC each Sunday the Stack Exchange Data Explorer is being refreshed with the weekly full backup from all sites.
I have this query to check on the status of the refresh as it takes 6 ...
- 85.7k
4
votes
1
answer
129
views
Is it possible to refresh SEDE daily?
I'm currently working on changing http to https in questions and answers of mine. To not flood the homepage (SF&F doesn't have the volume SO has), I do about 5 a day. When I run the query the next ...
- 4,656
17
votes
0
answers
169
views
Inclusion of the tables available in SEDE in the data dump at the Internet Archive
Table of contents
Prologue
The feature request
TL; DR
Current content of the data dump
Missing tables in the data dump
Motivation for doing this
Epilogue
Prologue
First of all, I would like to ...
- 531
4
votes
1
answer
207
views
How to get the data dump of all the tables (29 tables) for each site?
Prologue
We all know that we can use the Stack Exchange Data Explorer to perform queries in (most if not all) of the Stack Exchange tables. The tables listed, as for [2021-08-05 Thu 18:21], are 29. ...
- 531
1
vote
0
answers
48
views
In the Data Explorer, can you get the change in the number of views for a single question? [duplicate]
I am trying to find out the monthly change in views for a single question in Data Explorer.
I was able to get the current number of views, but could not figure out how to get the past number of views.
...
- 11
4
votes
1
answer
179
views
Finding who answered a question in the Stack Overflow dataset dump
Is there a way to know who (user_id) answered a question on Stack Overflow from the Stack Overflow dataset tables?
I am thinking it should be in the Posts table, but I couldn't find a clue.
- 43
10
votes
0
answers
136
views
Have there been analyses to see if views of well-received answers are reduced by closure as duplicate which try to control for other factors?
This is a narrowly-scoped question; I'm just curious if this has been investigated quantitatively.
Background only:
I spent some substantial time and effort and love and coffee writing this answer to ...
- 6,354
5
votes
0
answers
126
views
Is there a data dump for SE chat logs?
I am working on a research project looking at Stackexchange posts. I am aware of the data explorer as well as the data dump stored on the internet archive. I was wondering if there was any information ...
- 51
11
votes
1
answer
137
views
Include meta reputation in the Users table for meta sites
The table Users returns the same number as reputation if a query is run on the meta site and on the main site. Maybe it would make more sense to user "meta reputation" from meta if the query ...
- 15k
14
votes
1
answer
269
views
Who earned most reputation from a single post?
Kyle Hale on Sci-Fi & Fantasy SE has earned almost 10,000 reputation even though he's only ever made one single post on the site. Is this a network record?
Among users with just one post on a site,...
- 32.7k
8
votes
1
answer
118
views
Why/how does SEDE enrich my query with (partially relevant) documentation?
I thought by now I'd know all features of the Stack Exchange Data Explorer but apparently I don't. This is what I do:
Click the Compose Query button on the home page.
Paste SELECT MAX(CreationDate) ...
GlorfindelMod
- 247k
26
votes
1
answer
250
views
SEDE refresh didn't happen this Sunday
The Stack Exchange Data Explorer is updated every Sunday morning; the first sites are already finished by 3am UTC. However, today this doesn't seem to happen; all I can find is posts from May 30th and ...
GlorfindelMod
- 247k
5
votes
0
answers
85
views
Slightly misleading title on SEDE login page
The login page of the Stack Exchange Data Explorer says "Log in with OpenID", but that pertains to just the bottom part of the options; Stack Exchange itself doesn't provide OpenID ...
GlorfindelMod
- 247k
12
votes
2
answers
91
views
Can posts with no votes (as opposed to zero score) be queried?
I am curious to know how many posts (questions, in particular) have zero score because no one has ever voted on them versus posts with zero score because they have equal (non-zero) numbers of upvotes ...
- 474
10
votes
1
answer
78
views
How to get "duplicates list edited" history from the public data dump or SEDE?
I want to search questions whose duplicates list has been edited. Take this question as an example:
The timeline shows that the type of "duplicates list edited" is history, but the list ...
- 101
10
votes
0
answers
106
views
SEDE calls Code Golf Stack Exchange by its old name [duplicate]
As of May 30'th 2019, Code Golf.SE's new official name is Code Golf and Coding Challenges. However, SEDE hasn't updated this:
I know this is a minor bug, but it shouldn't take much effort to change ...
- 2,175
4
votes
1
answer
102
views
How can we know the number of deleted and edited posts?
Is there any way to find the number of deleted posts and number of edited posts on Stack Exchange Meta in a specific period of time?
- 105
7
votes
1
answer
140
views
Most upvoted comments across Stack Exchange (Cross site query)
I was interested in finding out the most upvoted comments per user across the entire Stack Exchange network (cross-site query).
I found this query, which works very well, but only for one site at a ...
- 4,030
6
votes
1
answer
116
views
Missing high rep users by last post date
This stems from a chat:
We lost indeed quite a few high reputation people over the last year. Seven in total by the count of this query: https://data.stackexchange.com/aviation/query/1381723/which-...
- 5,659
12
votes
1
answer
103
views
How can I find my posts where the headers are now busted after the migration to CommonMark
CommonMark is a bit more strict than the previous markdown flavor.
One of these cases is the markdown for headers to generate an H1, H2 or H3. A # on a new line followed by text was all that was ...
- 85.7k
5
votes
0
answers
67
views
Get a list of audit reviews for each review queue
Is there a way (I suppose via Data Explorer request) to get a list of completed (with any result) audit review for each review queue on site?
- 62.3k
4
votes
2
answers
134
views
A query ranking users by number of badges per class - like the user card
I wanted a query that would rank users by total count of badges per class. That is, a ranking like the user card; with 3 columns: gold, silver, bronze - having the total counts (and possibly with the ...
5
votes
1
answer
61
views
Do the upvotes/downvotes shown on the profile page and in SEDE include votes on the deleted posts?
Information about number of up/downvotes cast by a specific users is displayed both in the user's profile and is also available in SEDE. In the user profile, it is in the part "votes cast" ...
- 15k
17
votes
2
answers
515
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 ...
GlorfindelMod
- 247k
2
votes
1
answer
55
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 [...
- 630
3
votes
1
answer
52
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.
...
user878464
7
votes
1
answer
79
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 ...
- 13.3k
6
votes
0
answers
108
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?
- 33.7k
10
votes
1
answer
233
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 ...
- 5,741
2
votes
2
answers
80
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 ...
- 5,741
8
votes
0
answers
62
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 ' + ...
- 85.7k
2
votes
1
answer
61
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 ...
- 303
7
votes
1
answer
56
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 ...
- 303
2
votes
0
answers
34
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?
- 26.7k
14
votes
3
answers
187
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 ...
- 823
2
votes
1
answer
33
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?
- 26.7k