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.

Filter by
Sorted by
Tagged with
5
votes
0answers
68 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 ...
9
votes
2answers
64 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 ...
7
votes
1answer
43 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 ...
9
votes
0answers
76 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 ...
4
votes
1answer
80 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?
6
votes
1answer
103 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 ...
6
votes
1answer
100 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-...
11
votes
1answer
86 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 ...
5
votes
0answers
58 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?
4
votes
2answers
99 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 ...
4
votes
1answer
47 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" ...
11
votes
2answers
146 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 ...
2
votes
1answer
53 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
47 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
63 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 ...
6
votes
0answers
102 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?
10
votes
1answer
222 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 ...
2
votes
2answers
68 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 ...
7
votes
0answers
51 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 ' + ...
2
votes
1answer
59 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
1answer
49 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 ...
2
votes
0answers
23 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?
14
votes
3answers
175 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 ...
2
votes
1answer
29 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?
-8
votes
1answer
108 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
votes
1answer
180 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 ...
8
votes
3answers
881 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:...
-9
votes
3answers
310 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 ...
3
votes
1answer
77 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? ...
16
votes
1answer
117 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, ...
17
votes
1answer
96 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 ...
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 ...
14
votes
1answer
147 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 ...
7
votes
1answer
69 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
62 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 "...
11
votes
1answer
133 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 ...
3
votes
3answers
85 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 ...
3
votes
0answers
73 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
1answer
91 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....
4
votes
2answers
78 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
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 ...
5
votes
0answers
41 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 -------------|----------------|-----------...
4
votes
1answer
46 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 ...
14
votes
2answers
109 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 ...
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 ...
-8
votes
1answer
132 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/...
19
votes
0answers
210 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, ...
3
votes
0answers
61 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 ...
7
votes
0answers
134 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 ...

1
2 3 4 5
29