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
-11
votes
0answers
65 views

Is it okay to use Data Explorer as a recruiting tool?

It occurred to me that the Data Explorer makes enough user information publicly available that it can be an effective recruiting tool. I.e. it is easy to get a list of users in a particular location, ...
8
votes
1answer
71 views

Populate the “UserId” field in “Votes” for Answer Accepts in SEDE

In the Stack Exchange Data Explorer (SEDE), votes are not recorded with the user that cast them, for privacy reasons, except in cases of bounties and favorite votes. However, for answer accept votes ...
55
votes
8answers
2k 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 ...
5
votes
2answers
66 views

Query for no. of many questions I have answered which are closed later

Is there a query to know how many questions received answers before they are put on hold and I am one of the users who wrote an answer before the question is closed? If it looks confusing, let me ...
1
vote
0answers
70 views

Facing Error to access “SEDE” [closed]

I asked a question about a solution for searching tags in Meta SE, you can see my question in following the link: SEDE It was working since Aug 10th and after that when I was trying to open SEDE like ...
5
votes
0answers
128 views

Inconsistencies in SEDE URLs for meta sites

There is a weird inconsistency in the URL usage for meta sites inside the Data Explorer: For example, it's usually academia and meta.academia, but it can sometimes be arduino and arduinome. Why is ...
11
votes
1answer
167 views

Alias “Post Link” in data.stackexchange.com generate invalid links for “Meta sites” of pt.stackoverflow and es.stackoverflow

I create a query using [Post Link] and [Comment Link] and I noticed that the generated links are inverted for some sites, for example: This http://data.stackexchange.com/ptme/query/775699/bug-in-...
5
votes
1answer
79 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 ...
5
votes
1answer
53 views

Beta meta site descriptions are wrong on SEDE

Code Review Meta's description: Q&A for peer programmer code reviews This is the same as the description for Code Review itself. In keeping with the description for the non-beta metas, this ...
6
votes
2answers
66 views

Change taglines for non-English sites and new Meta sites on SEDE homepage

The homepage of the Stack Exchange Data Explorer has mixed-language taglines for non-English sites; e.g. for Russian Stack Overflow it is "Q&A for программистов". Can this be changed to something ...
2
votes
0answers
30 views

Long site title messes up SEDE site list formatting [duplicate]

On the Stack Exchange Data Explorer homepage, if you scroll down a bit, you'll encounter a site with a very long title: Software Recommendations Meta Stack Exchange. A title this long messes up the ...
6
votes
1answer
65 views

Meta Stack Overflow's description in the Data Explorer hasn't been updated since it was the only meta

From the site list at http://data.stackexchange.com/: Q&A about Stack Overflow, Server Fault and Super User A tad dated. Consider building from real descriptions (the audience property of /...
15
votes
2answers
240 views

Data.SE breaks when looking things up on Beer, Wine, and Spirits

When switching sites to Beer, Wine, and Spirits on the site switcher on data.SE (this thing), I get a Runtime Error: Description: An application error occurred on the server. The current custom error ...
18
votes
1answer
151 views

Why do some sites have an extra “SE” in their names? [duplicate]

In the homepage of Data SE, I see that some sites have an extra "SE" in the name, while the rest don't have. Is this an intention or just a kind of bug? At first I thought that this is a duplicate ...
3
votes
1answer
54 views

Few site and meta site names are ending with Stack Exchange and not all the sites in the data explorer main page

In the Stack Exchange Data Explorer main page the Stack Exchange site and it's meta site names are displaying. For the following site and it's meta site's names are ending with Stack Exchange but not ...
4
votes
1answer
43 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....
22
votes
1answer
146 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?
2
votes
1answer
54 views

How to query for the most popular job tags in Data Explorer

I'm just looking for a way to query the most popular tags in Stack Overflow Jobs, but I can't find anything related to it, I mean, a Jobs column or table or so. Is there a means to accomplish that ...
3
votes
1answer
46 views

How can I find the number of communities for a user in the Stack Exchange data set?

Is there any way I can extract, from the Stack Exchange data set, the communities that a user joined? I want to use this data set to extract this feature for all users: https://archive.org/download/...
1
vote
0answers
18 views

What are the reasons that the `FavoriteCount` column in the `Posts` table has elements that are not available? [duplicate]

I was taking a look at this post which details the database schema for the Stack Exchange Data Explorer. I had one question about the Posts data set: what are the reasons that the FavoriteCount column ...
7
votes
1answer
134 views

Are there any site moderators with very low reputation?

Are there any moderators on SE that have very low reputation? I ask, since naturally, moderators are experienced users, who would have a decent amount of rep unless they have given away many bounties. ...
13
votes
0answers
72 views

Can the reviewtasks table include the reviews for deleted posts as well?

The table reviewtasks is sanitized for deleted posts. This means that it is hard, if not impossible, for the users that care and for those that want to evaluate the effectiveness of a community to ...
12
votes
1answer
134 views

When are closed sites removed from SEDE?

Augur Stack Exchange has been closed down four days ago, according to its Area 51 page. Yet, it's still visible in SEDE. I was wondering how long it would be kept; sites which have been closed for ...
4
votes
2answers
142 views

Query to return user tags along with usage count

I've been trying to find this on the data explorer, but no luck. I need some help to write a query identical to the one found on our profile pages that displays tag information. The query would have ...
2
votes
2answers
80 views

Search Body for a Keyword

Is it possible to search the body for a keyword answered by a particular user in a particular tag? Example: Search for string "prototype" by user "xx" for tag "javascript" I want to write a query ...
12
votes
1answer
100 views

Data.SE dumps are monthly… but when?

I've been playing with our awesome data site and wondering how frequently it's updated, and of course the FAQ says: How frequently is Stack Exchange Data Explorer updated? Data is updated ...
2
votes
1answer
28 views

SEDE query for posts flagged as NAA

I am trying to figure out where in the database schema is stored the information about the kind of flag that has eventually been raised on a given answer. It seems spam/offensive flags should ...
9
votes
1answer
158 views

Why is there a clustering of answers at full (half) hours between answers?

I analyzed posting data from several SE communities and found that time gaps of almost precisely 30, 60, 90, and 120 minutes between consecutive answers are particular frequent. The figures show this ...
2
votes
1answer
23 views

How to distinguish beta sites from non-beta sites in a cross-site SEDE query?

The question Mod team updates and site status on Code Review Meta contains a SEDE query by @rolfl to compare sites on how many of a certain badge they have. My eyes fell on the following comment ...
2
votes
1answer
70 views

What are the most common first names of users on Stack Overflow?

I am curious about what the most common first names are on Stack Overflow. I wondered if there was a BigQuery I could write to accomplish answering this question, but it doesn't seem feasible. Does ...
2
votes
1answer
77 views

Why aren't all users in a country listed in this SEDE query? (Character encoding issues?)

I am using this data.stackexchange query to list the top users in Bulgaria. The result I get is as follows # DisplayName User Link tt ---- -------------...
1
vote
0answers
28 views

Not able to see Location in Stack Exchange Data Explorer [duplicate]

I am using the following query in Stack Exchange Data Explorer: SELECT Id, DisplayName, Reputation, Location FROM users WHERE Id = '3628106' ORDER BY Reputation DESC But I don't see Location in the ...
4
votes
0answers
92 views

In data.stackexchange a login action for an existing account created a new user instead

I've been using data.exchange for a few months now, and I've always used the "Log in using Google" to sign in, but today, I used "Login using Stack Exchange" for the same email. This option created a ...
5
votes
2answers
37 views

SEDE query to get all custom close reasons?

Is there a way to pull a list of custom "Other..." close reasons that users have typed from SEDE, preferably including deleting posts? I'm looking to propose a new close reason on Hardware ...
2
votes
1answer
84 views

Results from SEDE's Posts is the same as PostsWithDeleted

The SEDE is currently reporting the exact same results from Posts and PostsWithDeleted. For example, Query from Posts by UserId Query from PostsWithDeleted by UserId When I include the execution ...
4
votes
0answers
41 views

Can we have Data Explorer send you back to the page you were on after logging in? [duplicate]

If you log in to Stack Exchange from any page (as far as I know) on https://stackexchange.com or any sites like https://scifi.stackexchange.com, the URL looks something like this and redirects to the ...
1
vote
0answers
44 views

Logging in to Data Explorer (SEDE) in another window changes name in the first

When writing a question a few minutes ago, I logged into Data Explorer in a private window. When I logged back into it in a normal window, my username had changed to "Stormblessed31729" due to not ...
298
votes
2answers
60k 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 ...
19
votes
1answer
141 views

SEDE login redirects to front page rather than returning

Recently, the redirect behaviour of login on SEDE has changed (for the worse). Steps to reproduce: When logged off, go to a query page Click the "login" link Login Previously, you would be returned ...
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?
12
votes
1answer
105 views

Are user accounts on data.stackexchange.com and Stack Exchange two different entities?

I tried to search for similar questions, as I always do, but was not able to find one. I just created a new account on Data.Stack Exchange with my existing Google OpenID and it seems to be not ...
5
votes
1answer
52 views

URL link issue in data explorer tutorial page

There is an issue with a URL, in one of the Data Explorer tutorial pages. In the Tutorial -> Next Steps page, I can see the following description You can find some interesting queries in this ...
4
votes
0answers
30 views

SEDE generates incorrect links for localized Stack Overflow Metas [duplicate]

Stack Exchange Data Explorer generates wrong (outdated) links for localized child metas Example query on Stack Overflow em Portugues Meta generates this url: https://meta.pt.stackoverflow.com/q/1 ...
13
votes
2answers
230 views

Is it possible to find (the undeleted) posts of a deleted user?

What happens to (good) posts when a user is deleted, and can I find them by userid, either on site or via SEDE?
12
votes
1answer
222 views

Bizarre Question Data

Here's one for those who like a toasted brain sandwich. I was running some stats using [data.SE] and noticed a few strange entries in the DB, so I wrote another query to single these out. http://...
4
votes
0answers
63 views

Why can't I sort SEDE results for some queries?

I was just checking out who earned the most of the new badges that were announced this week. I have a SEDE query for this which sorts by default on the number of sites you earned a badge. I noticed ...
1
vote
3answers
119 views

SEDE tries to auto-login when I pick my OpenID provider but fails

When I try and login (today) on http://odata.stackexchange.com/stackoverflow/queries and choose my open id provider (myopenid) it tries to auto log me in before I can even type my username (subdomain)....
2
votes
2answers
67 views

Reproduce top tags for multiple users with Data Explorer

I want to reproduce the top tags overview for multiple users with the Data Explorer: In the following I simplify for two users. The required solution should be able to scale to 50+ users. What I ...
1
vote
2answers
64 views

How do I modify this query to search for specific tags?

I am forking this query, which essentially outputs the time between the question being asked and the answer being given. However, I am trying to modify the query to only search for java. I tried this: ...
4
votes
1answer
71 views

Determine if a user got an association bonus in SEDE

Is there a way to determine if a user received the association bonus on account creation?