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
2answers
79 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 ...
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?
0
votes
0answers
36 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)?
13
votes
6answers
724 views

How can I get all users' total reputation across all sites?

I like how Area 51 shows users by their total reputation across all sites, as an indication of the user's general familiarity with the Stack Exchange format. Is it possible to get a list of all (or a ...
-5
votes
1answer
109 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
55 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, ...
6
votes
2answers
220 views

When are data posted to Stack Exchange Data Explorer? [duplicate]

When are data posted to Stack Exchange Data Explorer? What is the frequency of data being posted to Stack Exchange Data Explorer?
-1
votes
1answer
42 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
82 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....
9
votes
1answer
60 views

Add lock reasons to Data Explorer

Posts are locked for different reasons. Some are in effect permanent ("historical significance", wiki-lock), some are meant to be temporary ("disputes are being resolved", "off-topic comments"). ...
33
votes
2answers
560 views

Why is the ##UserID## parameter not populated in Data Explorer anymore?

Environment I'm logging in using the OpenID from http://openid.stackexchange.com and using Chrome 31.0.1650.57 m if that matters. Steps to reproduce: Log in to Data Explorer and compose a query, ...
3
votes
1answer
84 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 + ...
13
votes
2answers
229 views

Please add a tutorial for SEDE

I recently discovered the Stack Exchange Data Explorer, and it seems pretty interesting... except... I have absolutely no clue how to use it. It would be nice to have a "beginner's tutorial" of sorts ...
28
votes
1answer
396 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 ...
13
votes
1answer
428 views

Why do some comments have 0 score but others have null score in Data Explorer?

In Data Explorer, looking through some SO data, I noticed that some comments have 0 for Score, while others are null. Why is this? Is there a difference between 0 and null comment scores?
17
votes
1answer
177 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 ...
2
votes
1answer
61 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
69 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 ...
7
votes
3answers
184 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 may be ...
2
votes
1answer
49 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
96 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 ...
5
votes
2answers
79 views

SEDE query to find question with most duplicates pointing at it?

I just saw this question: What is the most rampant duplicate on Stack Exchange sites? Is there an SEDE query to find this? I seem to remember there being a page of "questions linked to this" for ...
3
votes
1answer
69 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 ...
4
votes
2answers
330 views

What is the difference between LastEditDate and LastActivityDate in the posts table in the SO schema?

I'm not sure why Stack Overflow has LastActivityDate and LastEditDate. Do they not represent the same thing by definition?
13
votes
1answer
106 views

Get favorite count for tag

Is there a way to get the number of times a tag is favorited or the favorite tags for a user in Data Explorer? It seems Tags.Count is the total number of questions with that tag. Count won't work ...
18
votes
1answer
203 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 ...
12
votes
1answer
86 views

Expose vote time data for accepts, bounty starts/awards, and edit approvals in the Data Explorer

To preface, I'm not asking for vote time to be exposed for upvotes or downvotes. I'm aware that that's bad because it allows voting history to be reconstructed. However, certain other types of votes ...
53
votes
15answers
2k views

Can we become our own “Northwind” for teaching SQL / databases?

In the Microsoft ecosystem there are some standard databases like Northwind ... The Northwind Traders sample database contains the sales data for a fictitious company called Northwind Traders, ...
2
votes
1answer
101 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 ...
46
votes
3answers
524 views

Please open the Hot Network Questions to auditing via the Data Explorer

One of the contentious issues on today's Stack Exchange is the Hot Network Questions sidebar, which can drive a lot of traffic to junk-food questions that can be very poor fits to the sites that host ...
3
votes
1answer
43 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?
2
votes
1answer
39 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 ...
12
votes
2answers
103 views

How can I find posts that need editing using Data Explorer?

Is there a way, using Data Explorer queries, to find posts with chatty noise such as 'Hello guys' (or 'people', 'hi there', 'help me our', etc.)? It occurred to me that I could try something like ...
4
votes
1answer
65 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?
15
votes
1answer
97 views

Add reputation history to SEDE

A similar question was posed quite a while back, without much specificity. The only answer identifies the taxing nature of a SEDE query on the server in order to get a rough estimate of the user ...
19
votes
0answers
170 views

Data Explorer execution plans are no longer available because SHOWPLAN permission is denied [closed]

I noticed after a recent maintenance downtime that now I get the following message when trying to include an execution plan with a query: SHOWPLAN permission denied in database 'StackOverflow'. ...
3
votes
1answer
42 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 ...
4
votes
2answers
149 views

Finding potential new users based on reputation from answers?

Is it a good idea to show reputation without the +100 association bonus, in the new user's tab? Specifically in smaller sites, not only would it be easier to visualize who is contributing the most to ...
8
votes
1answer
147 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 ...
11
votes
0answers
174 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 ...
5
votes
0answers
35 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
43 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 ...
3
votes
2answers
113 views

How can I find questions from users of a minimum reputation and accept rate?

How can I find questions from users of a minimum reputation and accept rate?
6
votes
2answers
165 views

How to use Data Explorer to find the most prolific closers on a site?

Goal: Make the list of Top 50 users who closed most questions on a site. This means the questions that actually got closed, not pending close votes/flags. Deleted questions are excluded from ...
4
votes
1answer
59 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(...
9
votes
1answer
165 views

Build Stack Exchange Data Explorer on top of the Stack Exchange Q&A Engine

This is a huge request, but I would love to see http://data.stackexchange.com/ built on top of the Stack Exchange Q&A engine. The data explorer is great for exploring on your own, but really bad ...
1
vote
0answers
56 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 ...
5
votes
4answers
87 views

Is there a way to filter out merged questions from the data explorer?

I'm writing a query to find old questions without much answer attention, to help combat the xkcd "Wisdom of the Ancients" problem. I can filter out closed posts with p.ClosedDate IS NULL, but I'm ...
16
votes
1answer
315 views

How to calculate per site meta reputation?

The displayed reputation on per site meta is the same as on the respective parent site. However, out of curiosity, I'd like to see the actual reputation users would have on a meta if it was counted ...
-12
votes
1answer
165 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?

1 2 3
4
5
28