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
5
votes
2answers
36 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
82 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
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 ...
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
49 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
25 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 ...
-1
votes
0answers
62 views

Google Chrome crashing on Stack Exchange query

How to generate scenario - Goto - https://data.stackexchange.com/stackoverflow/query/new Type any query, click on Run query, click on reCAPTCHA, and woosh, Chrome is crashed.
4
votes
0answers
61 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
63 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
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 ...
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
103 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
48 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, ...
0
votes
1answer
33 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
76 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
62 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
54 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 + ...
16
votes
1answer
157 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
73 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
98 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
44 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
66 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
43 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
75 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
53 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 ...
1
vote
3answers
95 views

Data Explorer Cache

In Stack Exchange Data Explorer, I noticed that after a query is executed, it is stored in the cache (I think). How do I disable this feature? For example, when I run this query, it should generate a ...
14
votes
1answer
109 views

How can I delete my Stack Exchange Data Explorer account?

How can I delete an account on the Stack Exchange data explorer? I can't find any way to request the deletion when logged in to the account. (Note that SEDE is an independent system. SEDE accounts ...
1
vote
1answer
95 views

How can I find all the StackExchange websites that I'm part of? - Queries on Data Explorer

How can I find all the StackExchange websites that I'm part of as well as I'm not part of using the Data Explorer..? In addition, if it's possible, I would like to use this query to do additional data ...
2
votes
1answer
36 views

Most recent questions filtered by tags and country

Would you assist in composing a Data Explorer query returning the top 100 most recent questions filtered by both tags and user country?
6
votes
1answer
48 views

How to find the current top questions by number of views? Or the quarterly number of views per question?

Stack Overflow provides the total number of pageviews per question - but it doesn't tell you if those views are historical or if the question is still current. How can I find the current top questions?...
2
votes
1answer
36 views

Retrieving sequence of Review Tasks Results (within a date)?

Is it possible to know (be sure) the sequence of review tasks results, even though the time data from 'CreationDate' is removed (i.e., there is only date, not time)? Let me explain better. I want to ...
3
votes
1answer
54 views

How can I get the summary of questions a user ask from the Stack Overflow data dump?

I need information about how many questions a user asks, how many of them are resolved, and how many of them remain unanswered. Is there any way to get this information from the SO data dump?
2
votes
1answer
38 views

SEDE login authentication

I have the impression that SE's login is universal. Once logged into any one of the sites on the SE network, one can enter other sites without further login. For example, I'm logged into Math.SE, so ...
5
votes
0answers
34 views

Show off-topic reasons for currently selected site instead of Software Engineering [duplicate]

Let's say I'm creating a new SEDE query for Meta Stack Exchange. The CloseAsOffTopicReasonTypes table has a nice 'show contents' icon, which saves me from having to execute SELECT * FROM ...
7
votes
0answers
40 views

Show year in SEDE timestamps from previous year

Can we adjust the display behaviour of timestamps in SEDE so that it matches the general Stack Exchange behaviour (better)? On Stack Exchange, the year is shown if an action (post creation, latest ...
2
votes
1answer
52 views

The query on Stack Exchange Data Explorer returns different results from Stack Exchange website

I am running this query on the Stack Exchange Data Explorer (for Stack Overflow): select owneruserid , row_number() over(order by rep desc) as ranking , rep from ( select p.owneruserid ,sum(...
1
vote
0answers
51 views

Link registered account in Data Explorer to user profile page

Lately, I have been consulting and pulling data from Data Explorer Stack Exchange for performing review activities, adding data to meta posts, learn more about some pattern, etc.. I'd like being ...
6
votes
3answers
177 views

How to find duplicates that could be deleted?

From the faq post How should duplicate questions be handled? Should duplicates be deleted? ... Duplicates that are word-for-word copies or that are so poorly written that they are not useful ...
-12
votes
1answer
113 views

Find top Stack Overflow users by their technology stack and location [duplicate]

How to find top Stack Overflow users by their technology stack and location?
3
votes
1answer
38 views

Can I select just some SE sites when looking at traffic statistics?

This question is similar to Where can I find the number of monthly pageviews for Stack Overflow? but it's not a duplicate, because I don't want to look at the statistics of a single site: I want to ...
4
votes
1answer
25 views

How do I search for non-deleted questions in data.stackexchange.com? [duplicate]

I tried to filter for questions that have not been deleted. https://data.stackexchange.com/stackoverflow/query/953463/non-deleted-posts However, the top result shows Post Link ...
5
votes
0answers
65 views

List all comments upvoted by me [duplicate]

I can see all my upvotes in the "votes" tab of my user page. For example, https://stackoverflow.com/users/139150/shantanuo?tab=votes This includes the questions, answers and comments. Is there a way ...
3
votes
1answer
54 views

Query for maximum number of comments by a user on a post

Does a query exist in the Data Explorer which lets you know the maximum number of comments by a user on a question? I've not been able to find one; the closest query I was able to find was Number of ...
6
votes
1answer
58 views

Is there a query that returns answers one vote away from the Pizza hat?

I want to identify answers that are just one vote away from the Pizza Hat (was Extra Toppings last year). Searching for "pizza" or "toppings" on SEDE did not reveal a suitable query. How to query for ...
7
votes
1answer
78 views

See which posts had their CW status removed

According to this thread, Can a user revert Community Wiki on a post?, diamond moderators can remove the community wiki status from a post. Is there any way to know from which posts community wiki ...
7
votes
0answers
97 views

Why is BountyAmount for votetypeid = 8 empty in the votes table of MathOverflow

While helping out on a SEDE query here I was looking at the votes table in the MathOveflow database, specially the records for votetypeid = 8. I noticed that the bountyamount isn't present in these ...
4
votes
1answer
63 views

Is it possible to delete SEDE queries from our account history? [duplicate]

As the title says. There's a history of all our queries and it would be good to be able to delete the lousy queries and keep the useful ones. Is there a way to do this?
2
votes
1answer
60 views

How to collect history of deleted posts?

When a question migrates, answers are deleted and the question left as a stub. For example, a question is migrated from site superuser (post id: 82342) to stack overflow (post id: 1894170). I can ...
3
votes
0answers
31 views

Make the link to Stack Exchange Data Explorer Tutorial more visible

Can you display the link to the SEDE tutorial in a more prominent fashion please? Currently, it seems buried in the text of the help page. Perhaps at the bottom of "new query" page?
27
votes
1answer
247 views

Why do some comments on Russian-language sites have negative scores?

At least on two sites: SO on Russian and Русский язык SE Data Explorer returns a lot of comments with negative score [-6...-1]: Actual comments look like normal comment without upvotes. What is ...