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
6 votes
1 answer
97 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 ...
user avatar
  • 20.6k
6 votes
0 answers
48 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 ...
user avatar
  • 216k
8 votes
1 answer
90 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 ...
user avatar
8 votes
1 answer
131 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 ...
user avatar
5 votes
1 answer
75 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) ...
user avatar
5 votes
1 answer
66 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 ...
user avatar
  • 80.3k
8 votes
2 answers
169 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 ...
user avatar
  • 5,899
6 votes
1 answer
139 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 ...
user avatar
6 votes
2 answers
103 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-...
user avatar
2 votes
1 answer
53 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 ...
user avatar
  • 123
10 votes
0 answers
55 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 ...
user avatar
  • 216k
2 votes
0 answers
28 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 ...
user avatar
  • 305
28 votes
1 answer
355 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 ...
user avatar
  • 80.3k
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 ...
user avatar
  • 216k
9 votes
1 answer
89 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?
user avatar
  • 125
7 votes
0 answers
101 views

Is there a complete list of private guidance for network-wide closure reasons?

There is a difference between what privileged users see and what the post owner sees when a question is closed. For example, when a question is closed as a duplicate privileged users see1: Some ...
user avatar
  • 1,956
3 votes
2 answers
84 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 ...
user avatar
  • 125
4 votes
0 answers
110 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 ...
user avatar
  • 6,434
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 ...
user avatar
  • 5,899
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 ...
user avatar
3 votes
1 answer
46 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 ...
user avatar
3 votes
1 answer
62 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?
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 10.7k
4 votes
0 answers
173 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 ...
user avatar
3 votes
1 answer
93 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):
user avatar
  • 1,970
16 votes
3 answers
402 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 ...
user avatar
  • 293
18 votes
2 answers
197 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 ...
user avatar
  • 26.6k
5 votes
2 answers
96 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 381
3 votes
2 answers
165 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 ...
user avatar
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 ...
user avatar
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: ...
user avatar
  • 6,720
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 ...
user avatar
  • 25.8k
6 votes
1 answer
101 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 ...
user avatar
  • 163
9 votes
2 answers
135 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. ...
user avatar
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 ...
user avatar
  • 1,514
7 votes
2 answers
192 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'...
user avatar
18 votes
1 answer
132 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 ...
user avatar
  • 80.3k
4 votes
1 answer
113 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 ...
user avatar
  • 4,284
15 votes
0 answers
147 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 ...
user avatar
  • 511
4 votes
1 answer
147 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. ...
user avatar
  • 511
1 vote
0 answers
46 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. ...
user avatar
  • 11
4 votes
1 answer
121 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.
user avatar
  • 43
10 votes
0 answers
127 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 ...
user avatar
  • 5,899
5 votes
0 answers
112 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 ...
user avatar
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 ...
user avatar
  • 12.8k
14 votes
1 answer
264 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,...
user avatar
  • 26.6k
8 votes
1 answer
114 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) ...
user avatar
  • 216k

1
2 3 4 5
30