Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

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.

4
votes
0answers
42 views

Notify user that they've been logged out of SEDE (instead of appearing to function normally)

I'm an unusually frequent/avid SEDE user. It's like a gourmet buffet for a self-proclaimed "data geek" like myself. Thus, I've put off reporting this problem for a while, but it's continuing to cause ...
1
vote
2answers
99 views

Total reputation (sum of all reputations) of all Stack Overflow users?

I wanted to know if it is possible to get the total reputation of all Stack Overflow users - i.e. the sum of ALL reputation scores of ALL Stack Overflow users. I am aware that this would be a large ...
6
votes
0answers
37 views

Can the PerSite setting be switched to true so the shown metadata is consistent?

I was looking at some of the *-Types tables in the Stack Exchange Data Explorer. specially CloseAsOffTopicReasonTypes. As I'm lazy I clicked the (i) that is found in the right hand side of the SEDE ...
11
votes
1answer
180 views

On which Stack Exchange do you get the quickest answers?

I was writing an answer on this now-deleted question which basically asked 'Why do I get an answer quicker when I post on Stack Overflow than on Server Fault?'. This triggered me; was this just an N=1 ...
3
votes
1answer
40 views

Can I query history of my SEDE queries?

Is there a way to query my SEDE saved queries or query history? I could scrape the list from https://data.stackexchange.com/users/{SEDE User#}/?order_by=recent&page={PAGE#} (in my case, 350 pages/...
2
votes
1answer
63 views

How to find all users that work in same company as mine?

I would like to find all users that have a login to Stack Overflow and that work in my company. To do that, I have seen that I can create a custom query on http://data.stackexchange.com/stackoverflow/...
7
votes
1answer
64 views

What's causing this error in SEDE?

In the Stack Exchange Data Explorer, how come: select sum(len(body)) from posts works fine, but, select sum(len(text)) from comments throws an error? Arithmetic overflow error converting ...
3
votes
1answer
58 views

Are Data Explorer full-text column indexes planned?

Is it a possibility that full-text indexes will be eventually added to certain columns in the Data Explorer? I perfectly understand that SO servers are under a heavy load, and this would add ...
0
votes
1answer
60 views

How can I find the number of total questions and unanswered questions, for each month, for the 10 most popular tags on Cross Validated

I'd like to write a query in the Stack Exchange Data Explorer for the Cross Validated site, which returns me the Question and Answers on Cross Validated by month and by tag, for the 10 tags which ...
4
votes
0answers
29 views

Is it possible to estimate the active reviewer population using the SEDE data?

My main site has, I think, a problem with a shrinking reviewer population, and I would like to use the SEDE data to estimate whether this is indeed the case and, if so, how bad it is and how it has ...
1
vote
1answer
39 views

What is Views of users in the database schema documentation?

In the Database Schema Documentation, what is the Views field for Users? It does not match the (estimated) "number of people reached" displayed for users on their profile page.
3
votes
1answer
24 views

Is Stack Exchange Meta data available on Data Explorer?

I am trying to run a query in Data Explorer and can't seem to target Meta SE. I've tried a few different ways (Stack Exchange Meta, Meta, Big meta, Meta Stack Exchange), pasted the URL meta....
1
vote
0answers
56 views

Is Stack Exchange working on providing a GraphQL based API endpoint?

GitHub currently offers both REST API and a GraphQL endpoint to query its entire database. I was wondering if Stack Exchange (SE) is working on offering a GraphQL endpoint sometime soon. As a ...
6
votes
2answers
102 views

Should we rollback / improve the answer on “Database schema documentation”

I'm about to rollback the community wiki answer on Database schema documentation for the public data dump and SEDE It was seriously overhauled in revisions 75 and 76 but I had to do a partial patch ...
1
vote
0answers
20 views

Provide a permalink to a query with parameters

I've noticed that sometimes, I get a "permalink" for a query, that includes the parameters that I gave. But this is very inconsistent, I failed to find out when it's provided and when it isn't. So I ...
1
vote
1answer
25 views

Query to compute user content traffic

Trying to create a query to view the total amount of user's content traffic. That is, how many views the user questions/answers has received, my first attempt has been: Select Id As [Post Link], ...
2
votes
1answer
49 views

Query that computes user normalized rank

Consider this python code: from datetime import datetime # q1: https://stackoverflow.com/questions/50498770/why-does-instance-of-object-foo-is-instance-of-object-foo-evaluate-false/50498830#50498830 ...
5
votes
1answer
62 views

SEDE doesn't age well (aka don't let users input their Birthday on SEDE and stop showing their age)

Stack Exchange has removed anything related to age from their live database recently, following the GDPR, in the database level, including in the tables used by SEDE. However, SEDE itself still let ...
3
votes
0answers
32 views

OpenID login on SEDE over HTTP is broken, doesn't show error

I was trying to log into SEDE using the Stack Exchange OpenID function. However, without any erros, I kept not being logged in. Eventually, I discovered I was using the HTTP to connect to SEDE, not ...
1
vote
1answer
57 views

Are all tables available in SEDE available in Google BigQuery's Stack Overflow dataset?

Specifically, I'm looking for tables like CloseReasonTypes and PostHistoryTypeId. Is there a schema somewhere? I only see a few tables in the Google BigQuery UI: Do I need to use the Data Explorer ...
0
votes
0answers
27 views

Is it possible to obtain data on the evolution of questions' views over time? [duplicate]

In the SE data dump we can obtain a snapshot of the number of views over time. In particular, it is in the Posts table. I am looking for data on the evolution of views over time. My question is ...
-11
votes
3answers
276 views

Could network-wide suspensions last longer than 10 years?

The dupe candidate deals about suspensions in general, the essential part of this question is the increase of the network-wide suspension length from 10 years to 30. The answer to the question has ...
10
votes
1answer
96 views

The SEDE Refresh batch failed a second time in a row

Last week it was asked what Codegolf_Temp database is and it turned out to be a batch job that stalled mid-way and didn't recover. That was then rectified by restarting the batch later on the day. ...
7
votes
0answers
61 views

Better handling of large legends in Stack Exchange Data Explorer?

The problem The legend on Stack Exchange Data Explorer (SEDE), keeps going on, below the bottom of the page, on a white background, breaking the page (I've cropped this out to keep the page from ...
6
votes
2answers
129 views

What's the Codegolf_Temp database (and why does it mess up my query)?

Today, I was running some queries on SEDE and found out that this one fails to run because of the following error: Invalid object name 'StackExchange.Codegolf_Temp.dbo.badges'. Apparently, there's ...
2
votes
1answer
47 views

How can I see if my question is still active?

Years and years ago, I posted a very awkward question on StackOverflow. Now I checked it again and I discovered it got around 7k views and the answers to that question have got a discrete number of ...
3
votes
1answer
36 views

Difference between Votes, PostFeedback and PostNotices

I was curious to know the database schema for the public data dump and came across this thread. Does anyone know the difference between the following tables: Votes PostFeedback PostNotices
18
votes
1answer
173 views

Are questions by veteran users better received than questions by new users?

This now deleted question (10k only) stated that questions by new users are generally received worse than other questions. It was based on anecdotal (n=1) evidence, but are there some statistics from ...
4
votes
2answers
38 views

SEDE login loops back to “log in” link

I tried to log in to http://data.stackexchange.com/ and it appeared to succeed, but it didn't show my profile pic in the upper right, just the "log in" link. I selected the "Log in using Stack ...
2
votes
0answers
61 views

Magic Column [User Link] produces “Out of Resources” error on simple SEDE queries

Question shrunk since the issue is known and will be addressed in due time. (View complete question.) Error in SEDE when using magic column: Example #1: Control query (no magic column). ...
16
votes
1answer
191 views

Is there any place to see a leaderboard of top “Helpful Flaggers”?

There are a few members of Stack Overflow especially who have a ridiculous number of helpful flags. At the moment, there does not appear to be any way to display the top users with the most helpful ...
4
votes
0answers
175 views

data.SE recaptcha error [closed]

Currently data.stackexchange.com is unusable for anonymous users, with the following error message: I think I'm supposed to tell you to go to http://g.co/recaptcha/upgrade. Either than or I'm ...
-4
votes
1answer
70 views

What is the fastest and average time to attain each badge?

These seem to be interesting questions to understand in general how much effort is expended to attain a badge. Effort is the wrong word, some badges are gained through fortune or uncontrollable chaos....
1
vote
1answer
23 views

How to get just Query Plan for Query that is timing out?

I have a Data Explorer query(*) that is timing out. My sql badges are telling me that I could tune it if I had the Query Plan, but since the query never finishes the "Include Query Plan" check box ...
0
votes
0answers
38 views

Stack Exchange Data Explorer uses deprecated reCAPTCHA [duplicate]

I tried to run a query in Stack Exchange Data Explorer without being signed in. Doing so, I was presented with a reCAPTCHA that seems to be deprecated. I was running this query: http://data....
1
vote
0answers
36 views

The recaptcha on data stackexchange isn't working [duplicate]

Is this a temporary situation or something that needed to be reported?
2
votes
0answers
687 views

Should we be worried by the V1 SHUTDOWN recaptcha? [duplicate]

It looks like ye old Google RECAPTCHA is being decommissioned but we still use it on data.stackexchange.com Google decided to warn us with this "NUCLEAR HAZARD" style image. So, dear site owners, ...
2
votes
1answer
38 views

Is it possible to get the main site activity and meta activity together in one SEDE query?

What I wish to obtain is a neat table displaying these columns from left to right - "User Name", "Reputation", "Main site posts count", "Meta site posts count". The problem here is that SEDE won't (...
1
vote
1answer
20 views

Get the dates of last five answers by top users

I've been trying to get the dates of the last five answers by the top 50 users (say Reputation > 3000 AND Count(Posts.Id) > 50). I've modeled my SEDE query after another popular query and here's ...
1
vote
0answers
24 views

Recaptcha is breaking [duplicate]

I was trying to execute a query on data.stackexchange.com without being logged in, and it throws up this error (screenshot): The devs might want to look into it, since this may be happening elsewhere ...
2
votes
1answer
36 views

Searching the edit history for occurrences of a case-sensitive keyword

I wish to search my edit history ("revisions" tab in user profile) for occurrences of a particular keyword. Is it possible to get a list of all such revisions, possibly through SEDE? And can the ...
4
votes
1answer
32 views

Tag Count by Date

I'm looking for a total tag count up until a specific date for a given tag - or ideally, tags plural - on Stack Overflow. Any suggestions appreciated.
2
votes
0answers
37 views

CogSci is now Psychology.SE but SEDE isn't aware of it [duplicate]

SEDE seems to be unaware of the name change on Cognitive Sciences (to Psychology & Neuroscience). The site icon is a broken image and the text of the site name still reads "Cognitive Sciences" ...
4
votes
1answer
51 views

Sorting SEDE output is unstable

When you sort the output of a Stack Exchange Data Explorer query by a column that contains duplicate values, any rows sharing the same value in the column will end up ordered semi-randomly relative to ...
4
votes
0answers
466 views

Data Explorer returns “Captcha Shutdown” warning [duplicate]

I tried to execute this Data Explorer query and instead of the usual Captcha message I got the following: V1 shutdown on 2018-03-31 Direct site owners to g.co/recaptcha/upgrade Who needs to ...
2
votes
2answers
104 views

Get all interlinked questions

As an example, this question: http://stackoverflow.com/q/1371012/print-utf-8-from-c-console-application has linked questions here: http://stackoverflow.com/questions/linked/1371012 however some of ...
6
votes
0answers
39 views

Non-Latin tags are not parsed as tags in SEDE [duplicate]

For instance, in this SEDE request the cells in the tag column contain not parsed tags if at least one question's tag is not Latin only:
2
votes
1answer
64 views

There are PostHistory records for deleted posts, but only a very few

Checking for the PostHistory entries in the SEDE for deleted Posts, I get some results, but only a very few. For example, there is only 33 such records for the whole SO. All of them are from 2018. I ...
6
votes
2answers
53 views

Data Explorer site-switch search showing unrelated results first

I'm using Stack Exchange Data Explorer and trying to switch from Web Applications to Stack Overflow. I enter sta into "Switch sites" field, but search showing unrelated results first (3D Printing, ...
2
votes
1answer
22 views

View average number of answers per question in a particular time frame

What is the average number of answers per question? is a related question but not a duplicate since it asked for overall average of answers i.e. ever since the site was created. I am asking for ...