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,295
questions
-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?
