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
2
votes
1answer
48 views

Can't switch sites to Meta Stack Exchange when running SEDE query

I know that I can choose a query to run on Meta.SE, but when I'm looking at a query from another site, Meta.SE doesn't appear in the dropdown when I try to switch the site:
4
votes
1answer
53 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 ...
11
votes
1answer
119 views

Cross-site queries on SEDE fail with “The EXECUTE permission was denied”

I just noticed that any cross-site queries using dynamically generated SQL on the Stack Exchange Data Explorer (SEDE) now fail with the error message: The EXECUTE permission was denied on the ...
2
votes
1answer
65 views

Count city wise users from Stackoverflow Database

How do I get City wise users count from Stackoverflow Database? I found one Location field in Users table which may contains City, State, Country I wanted to get count all the City wise Users from ...
3
votes
2answers
50 views

Get user list of SO whose bio contains given words

I know that we can get data from the Stack Overflow database using a query. I wanted to get data about whose bios contain some given words. For example, If I put flutter, kotlin then I will get a ...
1
vote
1answer
27 views

How do I find all questions containing certain text and the user is from a certain country?

I am trying to build the following query: Find all questions containing certain text and the user is from a certain country. What I have done so far is: SELECT q.Id AS [Post Link], q....
4
votes
0answers
136 views

Can we get Stack Exchange voting data updates?

During some discussion, a very kind user linked me to this since I was combing trough SO(comp)/SE trying to familiarise myself with this website and data it provides. What I am interested in are ...
16
votes
1answer
145 views

Network-wide queries don't work on the SEDE

For example, a SELECT * FROM sysdatabases; results maybe some synchronization is running and it is only a temporary situation? Note, no network-wide query will work, if you make this permanent.
5
votes
2answers
69 views

Merge Comments on Data Explorer

I'm trying to get StackOverflow posts along with comments. However it returns each post with the individual comments as a separate record. Something like this - ID Post Comment1 ID Post Comment2 ID ...
-10
votes
1answer
105 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, ...
5
votes
2answers
77 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 ...
2
votes
0answers
33 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
2answers
72 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 ...
4
votes
1answer
49 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
19 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
144 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. ...
2
votes
1answer
63 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 ...
12
votes
1answer
137 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 ...
2
votes
1answer
30 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
165 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
26 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
73 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
78 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 ---- -------------...
8
votes
1answer
82 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 ...
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
96 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
39 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
86 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 ...
1
vote
0answers
45 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 ...
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 ...
5
votes
1answer
55 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 ...
4
votes
0answers
64 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
2answers
68 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: ...
2
votes
2answers
70 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 ...
0
votes
0answers
35 views

Redirect to the original page after authorization on SEDE [duplicate]

After authorization, https://data.stackexchange.com redirects to the main page. Could you redirect to the original page (from which I've tried to log in)?
-5
votes
1answer
104 views

SEDE query to find users' reputation when posting their questions

Each question has an Id, OwnerUserId, and CreationDate. I need to calculate the reputation of that user (questioner) was during the question creation time. I find the question (Determining user's ...
4
votes
0answers
50 views

Can't copy results in SEDE

Copying the output from the Stack Exchange Data Explorer is pretty broken. I stole a query here that outputs numbers from 1-100 to demonstrate the issue. Here's a GIF of me selecting everything, ...
-1
votes
1answer
36 views

How to get refined data of a Stack Exchange website

I have used the following SQL query on Academia Stack Exchange: SELECT * FROM Posts This query generated 50,000 rows ... but the total number of questions on the website is approximately 28,000. ...
4
votes
1answer
77 views

SEDE query to find how many questions remain unanswered related to a particular tag

For example, there are N questions which have a tag named X (there might be other tags also) and M of the questions remain unanswered. I require the number M associated with all tags in Stack Overflow....
3
votes
1answer
66 views

Help section update related to ##UserID## in data.stackexchange

On help page of data.stackexchange, It is stated that: The ##UserId## parameter is treated specially for users who are logged in. If they have an account on the target site that shares the email ...
3
votes
1answer
59 views

Retrieve list of top 100 users on Stack Overflow sorted by posted content?

I am trying to replicate the top user page with the users sorted by number of posts. Suppose there are two users: User 'A' with 5608 post (Answers + questions) And User 'B' with 2627 post(Answers + ...
17
votes
1answer
168 views

Why do some questions have a favorite count of 0 while others have none?

I was playing around on SEDE when I noticed some questions have a favourite count of 0, while the majority have a favourite count of NULL. What's the reason behind this? For the questions with a count ...
6
votes
0answers
75 views

Can the Description for the CloseReasonTypes be added for the newer Close Reasons?

The table CloseReasonTypes in The Stack Exchange Data Explorer holds the id, name and description for the various close reasons. When the close reasons got a major overhaul the new close reasons got ...
5
votes
1answer
103 views

Retrieve list of top 100 user on stackexchange for a specific tag sorted by posted content?

I am trying to replicate the top user page with user sorted by number of post for a specific tag. Suppose there are two users for tag. User 'A' with 5608 post for tag. And User 'B' with 2627 post. ...
2
votes
1answer
48 views

VoteTypeIds in the context of Comments for StackOverflow Posts

Known information: As per this answer comments can't be downvoted. VoteTypeId 3 means downvote on a given post. referred answer My Assumption: Comments should not be downvoted and therefore Votes ...
6
votes
1answer
67 views

Edit counts toward Strunk & White badge do not always add up to 80

There are a number of similar questions but they don't seem to capture the following: There is a list of criteria for edits that do / do not count towards the Strunk & White badge; however, when I ...
2
votes
1answer
44 views

More information for TagSynonyms to calculate transitivity of tag synonyms

I want to calculate all the tag synonyms possible for any given tag. TagSynonyms table gives the relation between Tag1 -> Tag1Master. As per TagSynonyms table, Master tag can be mapped to multiple ...
5
votes
1answer
76 views

Is it possible to track the question-to-answer ratio of users on a given site?

I'm trying to run a query which takes the top, say, 50 users on a site (bonus points if you can edit this number when running the query), and outputs a table listing all of the users, how many ...
2
votes
1answer
54 views

SEDE query for questions that have positive scores but get at least one downvote and vice versa

I require to find the number (or percentage) of questions that have a positive score but received at least one downvote. I think this finding also help to find the alternative case i.e. negative score ...