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
18 votes
1 answer
195 views

Weekly SEDE refresh has been contemplating Buddhism for a significant amount of time

Buddhism is interesting, surely, but either the weekly SEDE refresh has gained some Artificial Intelligence and is contemplating rebirth, or something is stuck. I'm not sure which one to hope for! I'm ...
8 votes
1 answer
135 views

Which sites have the most prominent top users?

I was looking at the top users of Chess Stack Exchange and noticed the top user @BrianTowers has more than twice the reputation (79k) of the next user @PhishMaster (32.1k). Are there more Stack ...
  • 225k
2 votes
2 answers
204 views

Highest reputation moderators?

Highest-rep users on the network are easy enough to find. What about highest-rep moderators? We all know that moderation ability doesn't necessarily correlate with reputation, and moderators on ...
  • 27.2k
1 vote
0 answers
81 views

Is there a way to check the change of geographical distribution of user base on SE?

I found geographical distribution checkers on SEDE, but is there a way to see how the population changes with time? I want to see, for instance, from what country most people are joining vs from what ...
11 votes
1 answer
133 views

An edit missing from PostHistory in SEDE

I was looking at the revision history of the question "Is all ordinary mathematics contained in high school mathematics?" on MathOverflow (revision history, edit suggestion). I was curious ...
  • 13.3k
18 votes
1 answer
297 views

Weekly SEDE refresh stuck at Gaming.SE

The weekly SEDE refresh is stuck, this query shows the problem occurred while copying the Gaming Stack Exchange database: Note: a similar thing happened before.
  • 225k
1 vote
1 answer
57 views

Search a SO post that I closed with a certain keyword

Is there a way to search for a Stack Overflow post that I closed and that has a certain keyword say "this" or certain code say this in it? I mean, I want to search by typing in the search ...
36 votes
0 answers
301 views

Can't login to SEDE - "StackApps authentication failed"

When I try to login to the Stack Exchange Data Explorer using Stack Overflow, it fails with the following error message: StackApps authentication failed I've tried several browsers, and even in ...
  • 225k
3 votes
1 answer
142 views

Query for retrieving all answer ids for questions which a user already answered

I'm looking for a query from a Stack Overflow dump to find this. Example: user-id 'XXXXX' answered_list_id:[10,20,30,40] Also, I don't consider whether the answer is accepted or not. FROM Users AS u ...
  • 31
4 votes
1 answer
100 views

How do I access this built-in SEDE functionality to run multi-site queries?

Queries in the Stack Exchange Data Explorer are usually run over one database, i.e. a single Stack Exchange site. It is possible to do a multi-site query by fully qualifying tables (including the ...
  • 225k
5 votes
1 answer
112 views

Capitalization of "site" in the Data Explorer's footer

There's a small capitalization inconsistency in the footer between the main site and the Data Explorer. On SE the footer has the word "Site" capitalized while it's written "site" ...
  • 23.5k
5 votes
2 answers
134 views

How can I see the list of questions that were removed by a mod from the list of hot network questions on a given SE website?

How can I see the list of questions that were manually removed (= removed by a mod) from the list of hot network questions on a given SE website?
6 votes
1 answer
106 views

Find questions with the longest titles

I want to find the list of questions on a site that have the longest titles. The purpose is testing design elements that might break or have layout problems if the title is too long. It's also an ...
  • 23.5k
6 votes
0 answers
52 views

Improve/remove OpenID information in the Data Explorer

I just looked at my profile in the Stack Exchange Data Explorer: First of all, Support for OpenID ended on July 25, 2018 (well, somewhat later actually) so in my case it can be removed. For the ...
  • 225k
8 votes
1 answer
95 views

Which tags attract drive-by questions? Or: How do I compute, for each tag, the number of users of that tag who have ≤N total questions?

I'm currently thinking about questions with the character-identification tag at Chinese Language. I feel like a lot of the questions with this tag are "drive-by" questions, i.e., the user ...
8 votes
1 answer
138 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
77 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) ...
5 votes
1 answer
72 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 ...
  • 81.8k
8 votes
2 answers
172 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 ...
  • 5,981
6 votes
1 answer
141 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
112 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
59 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 ...
  • 123
10 votes
0 answers
56 views

SEDE favorite button fails silently when not logged in

I was trying to bookmark/favorite this interesting Proof of Concept on the Stack Exchange Data Explorer, but clicking the favorite button did not do anything. Of course, I should have realized SEDE ...
  • 225k
2 votes
0 answers
30 views

Data explorer data have not been updated for some sites [duplicate]

Data explorer page says "Data updated May 8 at 3:27", but for some sites such as Mathematics, Math Overflow, Physics, etc... the newest added post is from May 1. For example this query show ...
  • 305
28 votes
1 answer
405 views

Can you please close the "Stackexchange.Arduino" database? It has been open long enough for now

I was running a query this morning similar to: create table #validaccounts(accountid int primary key) declare @sql nvarchar(max) select @sql = concat(N'insert into #validaccounts select distinct ...
  • 81.8k
5 votes
0 answers
36 views

Open SEDE links in a new tab by default

The Stack Exchange Data Explorer has some functionality to generate links. Those links open in the current tab by default, which has one significant disadvantage: when you navigate back, you have to ...
  • 225k
9 votes
1 answer
96 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?
  • 125
8 votes
0 answers
145 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,136
3 votes
2 answers
86 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 ...
  • 125
4 votes
0 answers
112 views

Real-time, site-specific traffic indicators?

Are there any real-time indicators of site traffic available? I'm aware of Real time SE specific traffic page?, and my question is different. I'm thinking more along the lines of access to real-time ...
  • 6,666
3 votes
1 answer
121 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 ...
  • 5,981
5 votes
0 answers
44 views

Link to the SEDE guide should open a new tab rather than changing the current URL (of the query composer)

The compose query page displays a ? icon that directs us to the schema documentation: Please make it so that the link opens up a new tab rather than changing the current URL without any prompt asking ...
3 votes
1 answer
47 views

When running a query in SEDE that needs UserId as input parameter, add an option to indicate the ID of the logged-in user, based on the selected site

Feature request: When running a query in SEDE that needs the UserId as input parameter, add an option to indicate the ID of the logged in user, based on the SE website they selected to run the query ...
3 votes
1 answer
67 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?
  • 275
4 votes
1 answer
120 views

How can a User's CreationDate be after they have posted?

I am currently analysing an Archive-Datadump of the apple.stackexchange.org. When looking on the posts.xml together with the users.xml, there is a strange anomaly. The earliest CreationDate among ...
  • 51
17 votes
1 answer
156 views

Did the recent change in layout of question lists have an impact on site usage and if yes, how much?

Recently, a new post summary design and greatest hits page design was rolled out (and is expected to be extended to all other such lists of questions everywhere). It was met with strong disapproval ...
  • 10.7k
4 votes
0 answers
174 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 ...
3 votes
1 answer
94 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,164
17 votes
3 answers
414 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 ...
  • 1,074
18 votes
2 answers
207 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 ...
  • 27.2k
5 votes
2 answers
97 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 ...
3 votes
1 answer
48 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
153 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
169 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 ...
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 ...
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: ...
  • 6,838
4 votes
0 answers
110 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 ...
  • 26k
6 votes
1 answer
110 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 ...
  • 163
9 votes
2 answers
136 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. ...
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

1
2 3 4 5
30