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,529
questions
5
votes
1
answer
160
views
Ranking users with most edits and close votes on a specific tag
A while back I asked this question about writing a query which would rank users based on their number of close votes on posts related to a specific tag: Table of users ranked based on their number of ...
- 1,460
11
votes
1
answer
176
views
Is there a way to find out how many edits I've made, network-wide?
I'm a prolific editor. I've made edits on a whole bunch of different sites. I'd like to know exactly how many edits I've made, network-wide. Is there a way to find out, perhaps with SEDE?
- 61.4k
11
votes
1
answer
141
views
Data Explorer throws server error when attempting to query Psychology & Neuroscience
The Stack Exchange Data Explorer lets you write SQL queries to find questions, answers, comments, users etc across the StackExchange network, but the query interface throws an error if I try to select ...
- 5,616
1
vote
0
answers
31
views
View "people reached" data/trend through time for user
Is there a way to view a trend (graphically or tabulated) in the number of "people reached" per user per site?
E.g., to see how many people a user's posts impacted monthly or annually, etc.
...
- 1,041
0
votes
2
answers
92
views
How to retrieve posts converted into comments from Stack Overflow dump?
I am trying to write queries on the data explorer to retrieve the posts that have been converted into comments.
However the votes, comments and posthistory tables have no information that shows when ...
- 85.5k
5
votes
2
answers
156
views
Table of users ranked based on their number of close votes in a specific tag
I am trying to get the list of users that have the most number of close votes (tallying each type of close votes; i.e. Duplicates, Too Broad, Need MRE, Not About Programming, etc.) in a specific tag. ...
- 85.5k
4
votes
0
answers
101
views
Some sites names shown in Data Explorer Stack Exchange doesn't match the current site name. Is this a bug or a feature?
Volume 1 : TL;DR
Please fix the names of the sites in Data Explorer of Community Building, Music: Practice & Theory, Medical Sciences, Mythology and Folklore, Bricks, Cross Validated and "...
- 18.4k
100
votes
3
answers
3k
views
Why is my profile image different?
When I first signed up on a Stack Exchange site and got a profile image, it was this one (see my current user card I'm actually not sure what I look like any more):
Later, I got Area 51 and SEDE ...
5
votes
0
answers
35
views
Add a bit column for whether a badge is retired in SEDE or a RetiredDate column
It would be nice (for example) to be able to easily filter out badges that are retired when querying SEDE for analysis purposes.
A bit for it would work, or alternatively, a nullable RetiredDate.
Or ...
- 10.7k
3
votes
1
answer
70
views
Why does this SEDE query think that the MathOverflow Meta is mathoverflow.meta.stackexchange.com?
I ran a query created by @peterh to find all my network posts. It works perfectly for the task, but it believes that all my posts made to MathOverflow Meta were actually made to https://mathoverflow....
GlorfindelMod
- 244k
20
votes
3
answers
857
views
Data dump, Programmers and Software Engineering
I've removed the poll style answers in favour of open discussion.
I realise now this isn't the best way to have a proper discussion about this issue - sorry to anyone who commented/voted.
This is ...
- 5,122
12
votes
0
answers
133
views
Why hasn't Music.SE's name changed on data.stackexchange? [duplicate]
Recently (~ November 6th), the name of Musical Practice and Performance was changed to Music: Practice & Theory.*
But, on data.stackexchange has not changed yet:
Will it be changed?
*Music SE ...
- 465
6
votes
2
answers
351
views
Add support for multiple results sets in Data Explorer
If you run this query in Data Explorer it would appear that both queries run since the message window reads...
(1 row(s) affected)
(555 row(s) affected)
...but only the first result is displayed or ...
- 154k
8
votes
1
answer
535
views
How can I export all results from a to multi-result-set-query to a CSV file?
In may, 2014 the support was added to download result sets from a SEDE query.
Today I used this query
sp_help 'tagsynonyms'
which gives 6 result sets:
I needed the second result off-line so I ...
- 12.1k
13
votes
1
answer
285
views
Weekly SEDE refresh may be stuck restoring Literature.SE
I'm again looking at rene's SEDE query Status of the SEDE Refresh on Sunday 03:00 UTC to check the status, which is currently (in part):
.
category
database_id
Description
create_date
days ago
3
...
Aaron BertrandStaff
- 35.2k
372
votes
2
answers
109k
views
Database schema documentation for the public data dump and SEDE
Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the ...
- 85.5k
55
votes
15
answers
2k
views
Can we become our own "Northwind" for teaching SQL / databases?
In the Microsoft ecosystem there are some standard databases like Northwind ...
The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, which ...
-13
votes
1
answer
137
views
Why have you hidden the "Data Explorer" tool?
Why is Data Explorer tool accessed only by clicking the word "Data" at the bottom of the page?
Correct it.
Change the word "Data" to "Data Explorer".
Bring the word &...
- 85.5k
5
votes
1
answer
98
views
When were comments first available on Stack Exchange?
I am curious about when comments first became available on Stack Exchange (or whatever the site was when the development occurred). I ask this because, in the Database schema documentation for the ...
-18
votes
3
answers
238
views
Can GPT-4 be used to do SEDE queries?
I don't know how to do SEDE queries, but I would like to explore some of the Earth Science Stack Exchange data.
Once I needed a query it was done by user rene, but I have many queries to do on Earth ...
- 85.5k
-9
votes
1
answer
102
views
Tag Analysis to know technology review by users
Is it possible to get analysis report on tags to know technology review. e.g.
1) Which technology has more questions (that has +5 vote up , atleast 1 from reputed person).
2) Which technology has ...
- 12.1k
3
votes
1
answer
107
views
How do I get the highest posters for a certain tag in a specific country?
I would like to get the user IDs, user names, the number of posts, and the total score for a certain tag for each user in a specific country (sorted in descending order by score).
For example, in the ...
GlorfindelMod
- 244k
10
votes
0
answers
97
views
Add tooltip with exact timestamp to 'Data updated ... ago' label on SEDE homepage
Can we add a tooltip with the exact UTC timestamp to the 'Data updated ... ago' label on the SEDE homepage? It would help indicating whether the refresh was slow (as it was today) or even incomplete. ...
CommunityBot
- 1
5
votes
2
answers
124
views
Can I search for users GitHub or Twitter info in Data.SE?
I'm curious if I can find users in Data Explorer by their GitHub username or Twitter handle.
I know I can find users from their Location (Location) or their Website link (WebsiteUrl).
Is there a way ...
1
vote
0
answers
30
views
Where is the GitHub link in the Data Exchange Explorer located? [duplicate]
I went closely over the SEDE's fields, but couldn't find where the GitHub link is saved for a user:
I ran this query on my own profile but couldn't find my GitHub account.
- 363
2
votes
2
answers
72
views
How can I get the total number of posts for a user that have a certain tag in them?
User abbood (myself) has eight posts (in total) that have the tag cocoapods; six questions and two answers.
I thought that this query should simply get all eight:
SELECT Count(*)
FROM posts p
...
- 6,678
0
votes
0
answers
58
views
Why isn't the summation of a user's score equal to their reputation? [duplicate]
I was going over the database schema documentation and was trying to understand how the Post scoring system works. I was expecting this query:
select sum(p.score)
from posts p
where p.OwnerUserId = ...
- 363
2
votes
1
answer
52
views
How can I find users with a specific number of earned/offered bounties?
How can I find users with a specific number of earned or/and offered bounties?
- 6,678
-2
votes
1
answer
102
views
How can you view the most upvoted comments on your posts (answers and questions)?
Is there a way to view the most upvoted comments from any of my answers or questions on Stack Overflow?
There are two similar questions/answers:
Search for my most upvoted comments and
Can I view a ...
- 7,694
2
votes
1
answer
121
views
Find posts deleted by authors, that deleted their own account later
How can we find posts deleted by their author that deleted their own account later?
- 6,678
3
votes
0
answers
83
views
How can I find my OpenID identifier for logging in to SEDE?
In my previous post, all the login options at SEDE seem to be linked to the same URL which doesn't work. The last one I haven't tried is OpenID. But how can I find it?
- 6,678
4
votes
0
answers
64
views
Why isn't there any captcha asked when running a new query in SEDE?
When I tried to create a new query on https://data.stackexchange.com/stackoverflow/query/new, I didn't see any hint for me to work on CAPTCHA, so I just clicked Run Query, and the next page was https:/...
- 6,678
2
votes
0
answers
66
views
Login options in SEDE do not work
Clicking the login options such as Yahoo in https://data.stackexchange.com/account/login?returnurl=/account/login?returnurl=/account/login?returnurl=/stackoverflow/queries doesn't work. Hovering ...
- 6,678
6
votes
1
answer
151
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 ...
CommunityBot
- 1
24
votes
2
answers
239
views
Auto-linkification of Tags.TagName fails when the tag name contains nonstandard characters
Run the following SEDE query: https://data.stackexchange.com/japanese/query/178382.
All the tags except kyūjitai-and-shinjitai, renyōkei, あれ, and たい-form get auto-linkified. These happen to also be ...
- 5,616
11
votes
0
answers
114
views
Data Explorer fails to properly format lists of tags with Cyrillic characters [duplicate]
There is a minor issue with how Data Explorer handles tag output. Ordinarily it replaces every one of them with a decorated and clickable link.
But it seems like whenever that list includes tags with ...
- 5,616
4
votes
1
answer
58
views
What is the difference between DisplayName and Id on the Stack Exchange Data Explorer Users table?
I am trying to pull a list of all users who have commented on an answer and tie it back to their User profile, if one exists. However, not all Comments table records have a UserId associated with them ...
GlorfindelMod
- 244k
34
votes
1
answer
254
views
The current SEDE refresh was delayed overnight
On Saturday, January 22nd, we had a failure on a backup share that won't be fully resolved until Monday.
We've immediately re-routed backups to multiple secondary locations, so that concern has been ...
Aaron BertrandStaff
- 35.2k
5
votes
1
answer
95
views
Is it possible to use SEDE to plot the pageviews for a specific question over time?
I answered a question on Chem.SE earlier today and noticed just now that it'd made it to HNQ. This got me wondering just how big the HNQ Effect™ is in terms of a jump in pageviews.
I found a handful ...
- 85.5k
15
votes
6
answers
865
views
How can I get all users' total reputation across all sites?
I like how Area 51 shows users by their total reputation across all sites, as an indication of the user's general familiarity with the Stack Exchange format. Is it possible to get a list of all (or a ...
5
votes
0
answers
60
views
Scrolling issues on data.stackexchange.com
I am encountering a couple of scrollbar issues viewing the results table on data.stackexchange.com. I am using OS X 10.14.6 using both Firefox 108.0.2 and Chrome 108.0.5359.98:
This happens only in ...
6
votes
1
answer
93
views
SEDE does something weird with URL parameters
Can somebody explain what happens in this SEDE query? It's a very simple one, apart from the use of a parameter:
PRINT ('%href="##url##"%')
but somehow SEDE decides to append part of its ...
- 58.2k
6
votes
0
answers
84
views
What's the Data Explorer query to get the latest data that Stack Overflow Trends shows?
Stack Overflow Trends shows the percentage of questions with a certain tag. Here's an example for Java IDEs. On Jan 7, 2023, this link produces this graph:
So VS Code is at 0.8%, and IntelliJ is ...
- 7,694
6
votes
1
answer
86
views
How can I find unaccepted answers using the SEDE?
While researching my question, "Are there any questions for which multiple answers have received enlightened badges?", I've created a query that searches for questions with multiple accepted ...
Aaron BertrandStaff
- 35.2k
7
votes
1
answer
80
views
Is there a way (e.g. with SEDE) to find questions with an existing tag that's been synonymized (but not merged) into another tag?
Say Tag 1 has been added as a synonym of Tag 2, so that new questions attempting to use Tag 1 will be automatically pointed to Tag 2. However, the two tags haven't been merged (yet). Then, if you ...
- 14.6k
7
votes
0
answers
70
views
The magic column [tagname] should handle number columns results gracefully
The magic column [tagname] will decorate and auto link tag names when used in a query. This feature relies on the JavaScript processing in the browser. The client-side script assumes it will always ...
- 85.5k
1
vote
1
answer
93
views
SEDE query to find progress on Four Ayes hat?
I've been working on a query to count the number of days a user's posts have had votes up, with no votes down on any day. But it seems like it's missing some posts. Users that have Four Ayes, do not ...
- 85.5k
4
votes
1
answer
91
views
Top voted questions not voted by me
How can I get top voted questions by tag, that are not voted by me (down/up).
Can you help me with a SEDE query, or easier solution?
Edit
If above query is not possible, Can it be possible
To ...
- 85.5k
103
votes
2
answers
3k
views
How can I search my comments using some keyword(s)?
Here's my problem: I know I've posted something on Stack Overflow about a particular topic. I know how to search all my answers with a given keyword, and that feature works well. But, if I don't ...
- 10.7k
16
votes
2
answers
227
views
Use data.stackexchange.com to make some statistics about Hats
To make some statistics, I want to use https://data.stackexchange.com/ to find, for example:
Who have the most Hats until now,
Who have this or that Hat,
How many Hat used,
How many one wear Hat,
etc....
- 264