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
0
votes
0answers
15 views

Not able to see Location in StackExchange Data Explorer [duplicate]

I am using the following query in StackExchange Data Explorer: SELECT Id, DisplayName, Reputation, Location FROM users WHERE Id = '3628106' ORDER BY Reputation DESC But not seeing Location in the ...
4
votes
0answers
87 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
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 ...
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 ...
297
votes
2answers
59k 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
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 ...
11
votes
0answers
135 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-...
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.
13
votes
2answers
218 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
221 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
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
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
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: ...
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?
15
votes
2answers
206 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 ...
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)?
13
votes
6answers
681 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
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, ...
6
votes
2answers
219 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
34 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....
9
votes
1answer
58 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"). ...
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 ...
33
votes
2answers
523 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, ...
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. ...
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
374 views

Data Explorer syntax or language reference?

Where can I find a syntax or language reference for the query language used on http://data.stackexchange.com/?
13
votes
2answers
200 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 ...
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 ...
12
votes
1answer
371 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?
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 ...
87
votes
3answers
2k views

Why is my profile image different?

When I first signed up on a Stack Exchange site and got a profile image, it was this one (see my current user card I'm actually not sure what I look like any more): Later, I got Area 51 and SEDE ...
54
votes
8answers
2k views

Introducing the Stack Exchange Data Explorer aka SEDE

I would like to gather some feedback on the new Sandbox I have been constructing. What does it do? Allows you to run arbitrary SQL queries on the data dumps, and share those queries with your ...
26
votes
2answers
4k views

Database Diagram of Stack Exchange model?

I went over the Archive site where I could retrieve data from Astronomy.SE. After I downloaded the content, I found 8 XML files that came maybe from a dump process. Now I am not able to assemble all ...
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 ...
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 ...
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 ...
4
votes
2answers
63 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 ...
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 ...