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.
541
questions
377
votes
2
answers
113k
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 ...
43
votes
1
answer
1k
views
When will data.SE get updated data?
Zypher promised that data.SE would "soon" get live data:
How to count the number of times I earned 200 daily reputation?
https://chat.stackexchange.com/transcript/message/5865764#5865764
I ...
- 12.3k
102
votes
1
answer
2k
views
Can some metadata about deleted posts be included in Data.SE?
I like to use Data.SE to view usage stats for some of the sites, however deleted posts are not included on Data.SE and I think this skews the numbers quite a bit, particularly on sites with a lot of ...
- 19.3k
164
votes
31
answers
11k
views
Interesting queries on Data Explorer [closed]
Let's collect some interesting queries for the Stack Exchange Data Explorer here.
How many upvotes do I have for each tag? (how long before tag badges?)
SELECT TOP 20
TagName,
COUNT(*) AS ...
17
votes
2
answers
515
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 ...
GlorfindelMod
- 247k
17
votes
1
answer
287
views
Why are my SEDE results inaccurate/obsolete/incorrect/outdated?
When I use the Stack Exchange Data Explorer (SEDE), the results I get don't reflect recent activity. Sometimes the data I get back are two months out of date. What's wrong?
This is intended to be a ...
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 ...
- 48k
48
votes
3
answers
638
views
Allow cross-site queries in data explorer
I think it would be useful if we could join across databases in the data-explorer.
For example, I'd like to query up a list of questions that I had a hand in migrating away from SO, and see what ...
- 6,163
13
votes
1
answer
477
views
Data from the Stack Exchange Data Explorer is obsolete [duplicate]
I was querying data from https://data.stackexchange.com/stackoverflow/atom using a LINQ query in LINQPAD and found that the data I got back is quite obsolete. I searched for Shekhar-Pro (me) by using ...
- 351
28
votes
2
answers
413
views
Why am I jon.doe when logging into Data Explorer?
I just tried to login to the Data Explorer and it gave me a jon.doe user.
I used the same openid...
How can I link this to my other accounts?
- 3,334
19
votes
2
answers
649
views
Why is vote time missing in the SE data dump and SEDE?
Is there a particular reason why vote times are omitted in the data dump?
IMO this could be a very useful data-set. Is this one of the steps that was done to anonymize the data, or does it simply not ...
- 14.7k
63
votes
8
answers
3k
views
Introducing the Stack Exchange Data Explorer aka SEDE
This is the announcement post of the Stack Exchange Data Explorer. Its answers were meant to iron out the initial glitches 6 to 8 years ago.
If you have found a bug or need support today with any of ...
- 108k
32
votes
2
answers
368
views
Extend or remove Data Explorer timeout [duplicate]
I know that we don't have automatic login for the Data Explorer, but what's with the automatic timeout/logout? There have been times that I am logged into the site, maybe I walk away for a little bit,...
- 51.4k
104
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 ...
- 1,163
68
votes
3
answers
1k
views
Where can I see how many posts have I edited?
I've found here many queries to check edit counts, and I get different results for each one. Which one is the most accurate and up-to-date query? Or is there any way to see the edit count in stats?
- 1,247
43
votes
1
answer
9k
views
reCaptcha v1 is shutting down on March 31, but SEDE still uses it
According to this post, I thought the new recaptcha API was used network-wide.
Though today, when going to SEDE (which for whatever reasons never recognized me automatically), I got this message ...
- 549
7
votes
1
answer
226
views
Wrong user when logging into Data Explorer
I think I'm having the same issue as reported in this question:
Why am I jon.doe when logging into Data Explorer?
When I log into SEDE with the same OpenID account I use for SE, a different user ...
- 418
82
votes
4
answers
848
views
Let SEDE users get hold of data on unsuccessful close votes for stats
I have the feeling that with the growing influx of questions, an increasing number of questions that are clear closing candidates (i.e. it is totally obvious and undisputed that they belong closed ...
- 114k
70
votes
2
answers
549
views
Delete own query on data explorer
Is it possible to delete or at least hide your own data explorer query when you know you've only been testing something and don't want it to show?
- 2,087
50
votes
3
answers
612
views
Please open the Hot Network Questions to auditing via the Data Explorer
One of the contentious issues on today's Stack Exchange is the Hot Network Questions sidebar, which can drive a lot of traffic to junk-food questions that can be very poor fits to the sites that host ...
- 19.4k
46
votes
1
answer
642
views
Include the "People Reached" and "Helpful Flags (count)" data in SEDE
I know the new profile design hasn't been updated for every site on the network yet, so maybe this is a bit too early. Nonetheless, please include the "People Reached" data in SEDE at your ...
- 13.5k
36
votes
3
answers
559
views
Please provide a Moderators table in the Data Explorer
Moderators are special, privileged users who should serve as an example to the rest of us. Therefore, it is natural to want to query behaviors and statistics about these model users, Like I did, for ...
- 20.6k
33
votes
2
answers
601
views
Why is the ##UserID## parameter not populated in Data Explorer anymore?
Environment
I'm logging in using the OpenID from http://openid.stackexchange.com and using Chrome 31.0.1650.57 m if that matters.
Steps to reproduce:
Log in to Data Explorer and compose a query, for ...
- 1,863
12
votes
1
answer
154
views
Where do I ask questions about data explorer?
The tag wiki for data-explorer says:
The Data Explorer, located at data.stackexchange.com, allows you to
create and run queries against copies of the databases of popular
StackExchange sites to ...
- 21.1k
12
votes
0
answers
278
views
Notify/contact SEDE user of fix to query
I guess I'm asking for comments, with subsequent notifications, to be added to queries in SEDE, so we can point out [fixes] 1 to flawed queries, especially when [the query] 0 has a comment in it ...
- 5,656
85
votes
1
answer
7k
views
"OpenID 2.0 for Google Accounts is going away"; will this affect Stack Exchange? [closed]
Apparently, for some reason, Google is retiring its OpenID 2.0 platform. I got this notice while logging in with Disqus, but not with Stack Exchange.
So... is Stack Exchange going to be affected by ...
- 33.5k
35
votes
2
answers
6k
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 ...
- 1,194
34
votes
2
answers
9k
views
Database Diagram of Stack Exchange model?
I went over the Archive site where I could retrieve data from Astronomy.SE. After I downloaded the content, I found 8 XML files that came maybe from a dump process.
Now I am not able to assemble all ...
- 475
32
votes
0
answers
326
views
Show successful close/reopen votes in SEDE regardless of if they've expired or not?
Currently Data.SE only show currently active close and reopen votes. Once these votes expire, they're removed from the Votes table. This makes them rather useless when trying to query anything related ...
- 19.3k
22
votes
1
answer
177
views
SEDE logs me out more often than it used to do
I'm pretty sure that since a month or so, SEDE seems much more eager to get rid of my session and log me out in that process.
I don't mind logging in a couple of times per day, if that helps to reduce ...
- 85.7k
21
votes
1
answer
469
views
In the PostHistory table what is that number in the comment column?
In SEDE the PostHistory table holds for PostHistoryTypeId's 33 and 34 the Notice added and Notice removed events.
When inspecting those rows with this query the comment field holds a number.
...
- 85.7k
20
votes
3
answers
863
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 ...
- 154k
7
votes
3
answers
2k
views
Why can't I pull in all the SO users from Data Explorer?
It only returns 50,000 rows when I do the query below. I thought there are more than that.
select id,DisplayName from Users
- 245
28
votes
1
answer
736
views
Please provide a way to download SEDE data via an API
I recently suggested on the Stack Apps site that a formal API be added to SEDE, and it was suggested I reference the feature request here, for visibility.
My use case is a query that the API does not ...
- 2,632
22
votes
1
answer
156
views
Long sites break the layout on the front page
The long name pushes the stats to a weird place. And what's with the "Stack Exchange" at the end anyway?
- 7,669
22
votes
0
answers
312
views
SEDE should pick up on changes to community metadata [duplicate]
It appears that site meta data isn't updated in SEDE. As an example, Moderators.SE was renamed to Community Building in December 2014. It is still listed in SEDE as Moderators.SE, as of July 2015.
To ...
- 19.7k
18
votes
2
answers
732
views
A site URL changed and now its icon in SEDE is broken
This has happened before, and it's happened again, all because Cognitive Sciences recently was renamed Psychology & Neuroscience, with a change to the URL.
The first thing that needs to be fixed ...
- 48k
11
votes
2
answers
359
views
How can I write a cross-site Data Explorer query that joins databases on linked accounts?
The answer to this question implies that you can write cross-site Data Explorer queries, but the sample query doesn't appear to do what I think it should.
SELECT TOP 1 *
FROM [StackOverflow....
- 14.8k
11
votes
1
answer
214
views
Data is showing MvcMiniProfiler results. Is that expected?
Not sure if this is actually desired, but data is currently showing me (a SE non-dev) mvc-mini-profiler results, including all queries that are being run against the DB (not talking about data-...
- 1,327
26
votes
2
answers
252
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 ...
- 14k
21
votes
2
answers
293
views
Can we include tag-wiki associations in SEDE?
Is it possible to include the tag-wiki associations in the Data Explorer? To do this would require two additional columns in the postTags table that associate a tag wiki excerpt and a tag wiki to ...
- 959
18
votes
1
answer
274
views
Make it possible to merge user accounts in Data Explorer
This is my profile in Data Explorer. I logged in there with Gmail account which I am using in Stack Exchange. So my user id of any Stack Exchange site is automatically populated there. I have three ...
- 33.6k
16
votes
1
answer
400
views
No Facebook log in for StackExchange Data Explorer
StackExchange Data Explorer allows login with about a dozen open IDs, but, unlike every other Stack Exchange site (in my understanding), Facebook isn't offered as one of the options.
Is there a ...
- 4,690
15
votes
6
answers
866
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 ...
- 31.4k
10
votes
2
answers
251
views
Automatic logging into Data Explorer
On most Stack Exchange sites, when I visit them I am already logged in if I have logged in before.
Why isn't it the case with Data Explorer?
- 8,497
9
votes
1
answer
550
views
Graphing lots of data crashes my browser
I wanted to run a Data Explorer query to return a large amount of data so I could export the lot to CSV. Problem is, the page is crashing my machine - the query triggers graphing, and the graphing ...
- 321
9
votes
1
answer
170
views
I'm being logged into Data Explorer as "jon.doe18", why?
Forgive me if I'm just ignorant of some well-known fact that explains this behavior:
When I log into Data Explorer with my usual OpenID provider (myOpenID), then I'm logged into the system as
http://...
- 2,537
4
votes
1
answer
140
views
SEDE FAQ - small discrepancy - update day
According to this https://data.stackexchange.com/help, SEDE is updated every Monday morning around 3:00 UTC. However, it is showing that it was last updated around Sunday morning around 3:00 UTC. And ...
- 13.5k
2
votes
1
answer
360
views
Finding specific users by their location and a tag score
I want to see who has the highest score in a specific tag (for example c#) in my country.
Is there any query or script for that?
I've found this query, but it doesn't work. Can any one take a look at ...
- 131
66
votes
11
answers
4k
views
The company's commitment to the data dumps, the API, and SEDE
Many words have been written around the company's commitment to the ongoing existence of the data dumps, the API, and the Stack Exchange Data Explorer (SEDE). Much of that text can be confusing or ...
- 19.7k