Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

2
votes
1answer
36 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 ...
5
votes
1answer
56 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
39 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
71 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
43 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
89 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
88 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 ...
0
votes
1answer
83 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
35 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
44 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
34 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
42 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
37 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
39 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
48 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
175 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
81 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
37 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
24 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
56 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
53 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
76 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
94 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
62 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
30 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?
26
votes
0answers
152 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 ...
-7
votes
1answer
99 views

What exactly is data.stackexchange.com? [duplicate]

What exactly is data.stackexchange.com? I cannot understand, regardless of how much I read about it. It would be helpful if someone explained.
2
votes
1answer
46 views

What are the advantages of exploring SE data via Google BigQuery over the T-SQL data explorer?

I have seen that it's possible to explore Stack Exchange data via Google BigQuery as well as via the Data Explorer. What are the benefits of this? As far as I see, the data explorer is T-SQL, which ...
3
votes
1answer
57 views

How can I find people who have asked a large number of high quality unanswered questions on UXSE?

I am looking to try and reduce the number of unanswered questions on the UXSE site by identifying high quality questions that hasn't been addressed probably because it is either difficult to answer or ...
2
votes
1answer
65 views

Data explorer update seems to have failed

I noticed the data Explorer update for September 30 at 3:00 UTC seems to have failed. Looking at the Data Explorer main page it shows the last update was yesterday however the following query shows ...
4
votes
1answer
37 views

Why is there some data unaccessible from the Data Explorer?

I was wondering why I didn't get the Unsung Hero badge when I theoretically should have it on Stack Overflow. The How Unsung am I? requests shows only 10 unscored answers, the real count is 11 but ...
1
vote
1answer
28 views

Unanswered questions by tag without my answer

How can I get unanswered (unaccepted) questions by tag that are not answered by me on Stack Overflow? I want to answer users who did not get a satisfying answer. But every time I open the unanswered ...
4
votes
1answer
27 views

Can I get Correct SE attribution from Data Explorer

I'd like to get titles (only) from various SE sites for my writer's prompts website. I cannot see how to use SE Data Explorer queries to get the required information. From the Attribution page I see ...
7
votes
1answer
131 views

Return reputation from answers & get a permalink of the results in the Stack Exchange Data Explorer

How do I get a link to send to someone, so even non-logged in users can see the results directly: ...without needing to click "Run Query" or anything? Is there any way to get reputation from only ...
3
votes
1answer
75 views

Why does this simple Data Explorer query only return 124 rows instead of 4,912?

Why does this query only return 124 rows when https://stackoverflow.com/users/470749/ryan?tab=votes&sort=all says "4,912 Votes Cast"? SELECT v.id, v.VoteTypeId, v.CreationDate FROM Votes v WHERE ...
4
votes
0answers
76 views

Improvements to 'Data updated x hours/days ago' message in SEDE

At the moment of posting this, the SEDE homepage says it has been updated one hour ago: However, when I try to execute a cross-site database query, it runs into an error: According to Taryn's ...
2
votes
0answers
57 views

Top voted questions not voted by me

How can I get top voted questions by tag, that are not voted by me (down/up). Can you help me with a SEDE query, or easier solution? Edit If above query is not possible, Can it be possible To ...
4
votes
1answer
73 views

Does Stack Exchange track the edit history of a user's `Location` field?

If I want to compare how many posts per location are asked by users over a period of N years, I would want to know how many users have changed locations during the period that I want to query. Is ...
5
votes
1answer
96 views

Top viewed questions by tag within a timeframe

How can I use the data explorer to fetch the top viewed questions within a certain tag within some time frame on Stack Overflow? For example, the top viewed questions tagged [Android] in the last 6 ...
4
votes
1answer
127 views

Data Explorer query to get my post with specific tag

I would like to select all my posts with a specific tag with Data Explorer. Some posts may have multiple tags. If my specific tag is say powerbi I would like to select also all the posts that have ...
5
votes
0answers
50 views

Notify user that they've been logged out of SEDE (instead of appearing to function normally)

I'm an unusually frequent/avid SEDE user. It's like a gourmet buffet for a self-proclaimed "data geek" like myself. Thus, I've put off reporting this problem for a while, but it's continuing to cause ...
1
vote
2answers
149 views

Total reputation (sum of all reputations) of all Stack Overflow users?

I wanted to know if it is possible to get the total reputation of all Stack Overflow users - i.e. the sum of ALL reputation scores of ALL Stack Overflow users. I am aware that this would be a large ...
10
votes
0answers
95 views

Can the PerSite setting be switched to true so the shown metadata is consistent?

I was looking at some of the *-Types tables in the Stack Exchange Data Explorer. specially CloseAsOffTopicReasonTypes. As I'm lazy I clicked the (i) that is found in the right hand side of the SEDE ...
12
votes
1answer
194 views

On which Stack Exchange do you get the quickest answers?

I was writing an answer on this now-deleted question which basically asked 'Why do I get an answer quicker when I post on Stack Overflow than on Server Fault?'. This triggered me; was this just an N=1 ...
4
votes
1answer
57 views

Can I query history of my SEDE queries?

Is there a way to query my SEDE saved queries or query history? I could scrape the list from https://data.stackexchange.com/users/{SEDE User#}/?order_by=recent&page={PAGE#} (in my case, 350 pages/...
2
votes
1answer
67 views

How to find all users that work in same company as mine?

I would like to find all users that have a login to Stack Overflow and that work in my company. To do that, I have seen that I can create a custom query on http://data.stackexchange.com/stackoverflow/...