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,541
questions
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
-8
votes
1
answer
111
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 ...
- 5,741
6
votes
1
answer
207
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 ...
9
votes
3
answers
1k
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:...
- 85.7k
-11
votes
3
answers
402
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 ...
- 14.4k
3
votes
1
answer
110
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?
...
- 37.8k
17
votes
1
answer
125
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, ...
- 85.7k
19
votes
1
answer
115
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 ...
GlorfindelMod
- 247k
2
votes
1
answer
93
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 ...
- 33.7k
14
votes
1
answer
151
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 ...
GlorfindelMod
- 247k
7
votes
1
answer
85
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 ...
- 231
1
vote
0
answers
63
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 "...
- 119
11
votes
1
answer
145
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 ...
4
votes
3
answers
95
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....
- 51
5
votes
1
answer
56
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 ...
- 32.8k
4
votes
0
answers
189
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 ...
-5
votes
1
answer
125
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....
- 303
4
votes
2
answers
84
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 ...
2
votes
1
answer
66
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 ...
- 1,088
5
votes
0
answers
47
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
-------------|----------------|-----------...
- 399
4
votes
1
answer
59
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 ...
- 26.7k
14
votes
2
answers
115
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 ...
- 85.7k
6
votes
0
answers
73
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 ...
- 26.7k
-7
votes
1
answer
136
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/...
- 199
19
votes
0
answers
223
views
Planned Maintenance scheduled for Tuesday, September 29, 2020 for Data Explorer
Update: The maintenance went as planned.
tl;dr; Planned service interruption that will impact Stack Exchange Data Explorer (SEDE). The site will be inaccessible for up to 12 hours on September 29, ...
- 51.4k
6
votes
1
answer
161
views
Running a query in Data Explorer returns a JSON string {"captcha":true}
I am trying to run this query:
https://data.stackexchange.com/stackoverflow/query/430132/split-users-by-amount-of-reputation-digits
When I hit Run Query, it redirects to a page with nothing but a JSON ...
- 161
9
votes
1
answer
209
views
Rename "Favorite" vote type to "Bookmark" in VoteTypes table SEDE
Over at SEDE, in this query, it shows the vote type (or what should be the vote type) "bookmark" as "favorite":
Can we update that to say "bookmark", since favorites are ...
- 26.7k
4
votes
0
answers
52
views
Add the ability to increase width of Database Schema SEDE
At SEDE, you can increase the height of the Database Schema with this button:
And with the whole thing, including the area where you make your queries. But you can't increase the width, which would ...
- 26.7k
12
votes
1
answer
201
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", ...
- 26.7k
7
votes
2
answers
103
views
Are there any keyboard shortcuts to run a query at SEDE?
Is there a keyboard shortcut to run a query/activate the "Run Query" button at SEDE?
- 26.7k
13
votes
1
answer
288
views
NET::ERR_CERT_DATE_INVALID error at data.stackexchange.com
I'm currently getting a "connection not private error" over at the Stack Exchange Data Explorer (using Chrome). I have verified that my date and time settings are correct, and another user ...
- 7,682
27
votes
1
answer
475
views
Stack Exchange Data Explorer Login is Changing
Update Aug 27, 2020
The migrations have been executed.
I've just tested that I can login into my old account via the new login method!
In line with our efforts to discontinue support for OpenID, we'...
- 22.2k
15
votes
1
answer
151
views
Typo in old close reason 'noise or pointless' in SEDE
There used to be a close reason 'noise or pointless' on Meta sites. However, in SEDE it's listed as "noise of pointless", which makes it look like the person who inserted that was either ...
GlorfindelMod
- 247k
8
votes
0
answers
257
views
It's time to remove Yahoo login from https://data.stackexchange.com/
Follow up question to:
Is it possible to merge an old and new data.SE login?
I was able to log in few days after asking that question.
Now I am unable to log in with Yahoo which is how I log into my ...
- 4,590
21
votes
1
answer
232
views
The Stack Exchange Data Explorer intermittently goes down
Since Sunday, I expect after the refresh of 03:00 UTC, the Stack Exchange Data Explorer seems to have troubles serving pages to us.
I notice that I'm either logged out frequently, I get the red error ...
- 85.7k
12
votes
1
answer
109
views
The close reason descriptions for "Needs details or clarity" and "Opinion-based" are swapped in SEDE
The close reason descriptions for "Needs details or clarity" and "Opinion-based" are swapped in SEDE. Can this be corrected?
For reference, this is what those close reason ...
user313042
7
votes
0
answers
160
views
Make whether a deleted question was deleted voluntarily or for moderation reasons available in the API and SEDE
When a <10k user browses to a deleted question, they are told whether the question was deleted voluntarily by its author, or by others moderating the site (i.e. "for reasons of moderation"...
4
votes
1
answer
100
views
Write a query to get top rep. users who have silver badges, but no gold ones
I am trying to compose a query that will list all high rep users who have a silver badge, but no gold ones.
I am new to the SEDE. I have gone through the tutorial and properties documentation, but I ...
- 207
6
votes
1
answer
71
views
Counting the number of deleted answers on questions that have been protected
So, I'm continuing my dig into the protection feature on my site for a data deep dive and I'm getting stuck trying to find this data.
I'm looking this time for the list of all questions that have been ...
- 6,636
7
votes
2
answers
96
views
SEDE query to find out how many posts have been protected with spam on them
We are in the middle of an important discussion on our site about how we use the protection tool and we need some data for that discussion.
Specifically, how many posts have ever been protected on the ...
- 6,636
1
vote
0
answers
54
views
Can I merge duplicate data.SX queries I've written? [duplicate]
I've written identically-titled SX data explorer queries, by mistake. Can I merge them (including merging their star count)? If not, can I make the system forget about one of them (i.e. delete one of ...
- 26k
10
votes
1
answer
115
views
Backslash before single quote breaks syntax highlighting (the quote is not escaped, but gets highlighted as if it is) in SEDE query
I was trying to write a query to find posts with <%break%> or <%%>, and realised that % works as a glob. Someone suggested using ESCAPE '\' to search for literal %, and that worked and the ...
- 3,047
0
votes
0
answers
55
views
Accessing https://data.stackexchange.com/query APIs programmatically [duplicate]
All, We want to get the list of all deleted question Id's from StackOverflow (with additional tags and/or date filters, if possible). However we don't see an useful API for this here:
https://api....
- 9
7
votes
0
answers
92
views
Moving comments to chat seems to be missing in timeline and SEDE?
There are two possibilities how comments can be moved to chatroom. Either a moderator moves them or the users who discuss in comments are offered to continue in chat - and if they choose this option, ...
- 15k
2
votes
1
answer
61
views
Search question titles from all questions I have interacted with
This is basically a follow up to this popular thread, Can I search my comments using some keyword(s)?, with a similar reasoning behind it: I am sure I have seen an question already to a given problem ...
- 130
20
votes
1
answer
163
views
Certificate Expired on SEDE
It looks like the SSL certificate for data.stackexchange.com just expired.
If you were in the middle of running queries you would be greeted with:
Something unexpected went wrong while running ...
- 85.7k
3
votes
1
answer
71
views
How can I view top contributors in a country by week?
I just want to view the top contributors based on the reputation points by this week in a given country.
select row_number() over(order by reputation desc)
, reputation
, views
, id as ...
4
votes
1
answer
77
views
I'm getting an "Invalid object name 'StackExchange.Cstheory.Meta_Temp.dbo.posts'." when executing a cross-site query in SEDE
Vanity causes me to visit this SEDE page from time to time to check out how hot I am. Today I felt like the evil queen in Cinderella because I received bad news:
received both errors:
Invalid object ...
- 6,354
1
vote
2
answers
249
views
How can I write a query DATA.SE to list top users from all countries in the world?
I am trying to create a query, that lists TOP user(s) by reputation from all countries.
I don't know where to start from. I have a query, which lists TOP user from a specific country:
SELECT top 1
...
- 61
6
votes
1
answer
86
views
SEDE refresh seems to be stuck (again)
The weekly SEDE refresh doesn't seem to have completed successfully, just like two weeks ago; the Stack Overflow and Super User database are still a week old. If you look at the database timestamps, ...
GlorfindelMod
- 247k