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
297
votes
2answers
59k 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 Stack Exchange ...
42
votes
1answer
987 views

When will data.SE get updated data?

Zypher promised that data.SE would "soon" get live data: http://meta.serverfault.com/questions/3551/how-to-count-the-number-of-times-i-earned-200-daily-reputation/3552#comment6746_3552 http://chat....
156
votes
31answers
8k 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 ...
16
votes
1answer
259 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 ...
97
votes
1answer
1k 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 ...
13
votes
1answer
426 views

Data from the Stack Exchange Data Explorer is obsolete [duplicate]

I was querying data from http://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 a ...
41
votes
3answers
457 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 ...
87
votes
3answers
2k 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 ...
67
votes
3answers
850 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?
27
votes
2answers
398 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?
31
votes
2answers
308 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,...
42
votes
1answer
8k 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 ...
7
votes
1answer
217 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 ...
78
votes
4answers
808 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 ...
54
votes
8answers
2k views

Introducing the Stack Exchange Data Explorer aka SEDE

I would like to gather some feedback on the new Sandbox I have been constructing. What does it do? Allows you to run arbitrary SQL queries on the data dumps, and share those queries with your ...
38
votes
1answer
496 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 earliest ...
12
votes
1answer
145 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 ...
10
votes
0answers
267 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 to flawed queries, especially when the query has a comment in it explaining ...
11
votes
1answer
200 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-...
85
votes
1answer
7k views

“OpenID 2.0 for Google Accounts is going away”; will this affect Stack Exchange?

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 ...
56
votes
2answers
421 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?
26
votes
2answers
4k 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 ...
29
votes
0answers
283 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 ...
33
votes
2answers
523 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, ...
27
votes
3answers
373 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 ...
17
votes
2answers
468 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 ...
10
votes
1answer
279 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....
20
votes
0answers
280 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 ...
20
votes
1answer
140 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 ...
14
votes
3answers
593 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 ...
10
votes
2answers
585 views

Captcha is missing in Data Explorer when connected over HTTPS

When I tried to run How many upvotes do I have for each tag?, I got the below screen: The captcha is missing! I tried in other browsers too. Update: From @Oded's comments, I changed to HTTP and it ...
56
votes
2answers
1k views

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 ...
46
votes
3answers
500 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 ...
20
votes
2answers
271 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 ...
16
votes
1answer
233 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 ...
9
votes
1answer
166 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://...
9
votes
1answer
372 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 ...
4
votes
1answer
96 views

SEDE FAQ - small discrepancy - update day

According to this http://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 I ...
18
votes
1answer
238 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. ...
26
votes
2answers
254 views

Can we expose class for badges in Data Explorer?

According to this answer the following metadata is exposed for badges: Id UserId Name Date Why isn't class exposed in some way? It's obviously in the schema, since we can sort / filter in the UI. ...
10
votes
1answer
764 views

Where did EmailHash go?

There are at least four ways to get to StackExchange data: OData (http://data.stackexchange.com/stackoverflow/atom/), Data Explorer (http://data.stackexchange.com/), XML data dumps (https://archive....
7
votes
1answer
137 views

Out-of-resources when trying to run a popular DataExplorer query

So, I tried to run this query Users with highest Socratic progress (socratic hopefuls) which has many views (so I assume it's popular), but I get a message saying: The query processor ran out of ...
6
votes
1answer
231 views

Search on Stack Exchange Data Explorer

Could we please have a search box on SEDE to search the queries?
18
votes
1answer
248 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 ...
15
votes
3answers
320 views

“member for” is a negative number on Data.SE

I've recently joined Data.SE, and seen this: -55, -54, and counting… it reached 0, but then it started over from -59! It seems I'm not alone with this problem
10
votes
2answers
213 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?
4
votes
1answer
128 views

Odata feeds are down

Seems to be lots of reports for this, but none recently it seems. So, odata feeds are down, i emailed about this but was told to report it here. http://data.stackexchange.com/ Click any of the ...
66
votes
8answers
10k views

Implement OData API for Stack Overflow

The request is simple Implement the OData API for Stack Overflow sites Benefits: It's a standard API. OData allows the Stack Overflow database to be queried and navigated for questions, users, ...
13
votes
6answers
680 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 ...
9
votes
1answer
253 views

Reputation History from Data Explorer

Is there a way to get the reputation history for a user in Data Explorer. I know you can do this through the StackExchange API through Reputation Changes. But there's a limit of 10K queries a day (at ...