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.
1,561
questions
1
vote
1
answer
55
views
Data Explorer query to count number of edits, but using the same criteria as the Users->editors tab
How does one create a query similar to the one seen on the editors tab? This one skews the count a bit: it counts title, body, and tag edits separately, even when they occur within the same grace ...
1
vote
1
answer
55
views
Why won't DataExplorer load? [closed]
I was testing my app, and it didn't seem to load the csv requested from https://data.stackexchange.com/, so I tried visiting the site myself. It wouldn't load. I tried again.
It's not loading. ...
1
vote
1
answer
90
views
Data stack exchange: query from all sites [duplicate]
While creating a query on Stack Exchange Explorer, how do you write a query to include all Stack Exchange sites?
select P.ID as [Post Link],
p.Score,
P.Title,
P....
1
vote
1
answer
1k
views
Remove commas in Data Explorer query for CSV export [closed]
I am working on linguistic analyses on Programmers. I am running a query in the Data Explorer that grabs all the user information. The query is the following:
select * from Users;
The query is fine ...
1
vote
1
answer
50
views
Unable to retrieve number of close votes before year 2011
The Stack Overflow schema says that VoteTypeId field in the Votes table corresponds to the type of vote received andVoteTypeId = 6 indicates a close vote. I am trying to find the number of close votes ...
1
vote
1
answer
70
views
Sort the table and column by name in Data Explorer
This just bugs me everytime I want to check for a column name:
Why? Posts and Users are so important that they must appears first? Id is an important column, no doubt. But seriously, when we seek a ...
1
vote
1
answer
51
views
How to reset data.stackexchange.com cache
When I run any query on data.stackexchange.com, it shows old data. In says xx rows returned in xx ms (cached).
The cached data is old one. How to reset/remove this caching?
1
vote
1
answer
61
views
Data Explorer generates malformed links for user websites
This is a tiny bug on the Data Explorer site. In the user details page, the link href to the user's website is missing the colon in the protocol specifier (e.g. http//example.org instead of http://...
1
vote
1
answer
93
views
Help writing a data explorer query
I'm trying to (eventually) write a query to give me number of upvotes per day for a given tag. Unfortunately I'm having trouble getting off the ground. Right now I'm just trying to get answers I've ...
1
vote
1
answer
113
views
Unable to run any queries on Stack Exchange Data Explorer
I am trying to run a query on Stack Exchange Data Explorer. Not logged into it results in an output of
{"captcha":true}
instead of the actual CAPTCHA coming up.
To be specific, it's coming ...
1
vote
1
answer
66
views
Some logos in data explorer clash with page
Some of the logos on the main page of the data explorer are too narrow or have the same colour text as the background.
1
vote
1
answer
45
views
Crash when editing profile on data explorer
I just tried to update my profile on SEDE, but got a crash (the ASP.Net yellow screen of death) when I clicked save.
Does the "about me" section support markdown (like the other SOFU sites), as I was ...
1
vote
2
answers
66
views
DataExplorer Feature request: Associate OpenID with other accounts in the trilogy, then allow push-button insertion of the user's own UserID
With the new site, there is (understandably, since it's barely even been announced) no tie-in with accounts on the other sites.
If/when account association gets added, it would be nice to add the ...
1
vote
1
answer
117
views
Data Explorer Recent Queries not Updating
The recent queries view in the data explorer seems to be broken. It shows, since quite a while, that Mark Hurd asked for Quick Answers, zero seconds ago. The view doesn't seem to be updated by new ...
1
vote
1
answer
143
views
SEDE query to pull votes on a post within 90 days of its creation date
I am trying to query SEDE so I can count the upvotes (and I would also like to count the downvotes in its own column) that happen within 90 days after the question or answer was created.
I have tried ...
1
vote
1
answer
192
views
Data Explorer - You can only run 2 queries [duplicate]
So I tried running a query on the data explorer against stackoverflow.com and am faced with an error:
The thing is, I just visited the site to run a query, and haven't run anything since Friday last ...
1
vote
1
answer
47
views
View all tag synonyms I can vote on [duplicate]
Is there any way to view all tag synonyms that I can vote on, with my tag scores?
I can't find anything in the main interface, but perhaps there's a data query I can't find?
1
vote
1
answer
28
views
Query to check the most active editors over a specific period
Is there a way to do that without being limited by having to be the last editor of the specific posts, as seen with the use of Posts.LastEditorUserId in this query.
As a bonus, is there some way to ...
1
vote
1
answer
110
views
Is tag and tag-synonym table schema current in the Data Explorer?
https://data.stackexchange.com/stackoverflow/query/new
**Tags**
Id
TagName
**TagSynonyms**
Id
SourceTagName
TargetTagName
AutoRenameCount
(There's no foreign key relation between the two)
I type sdk ...
1
vote
2
answers
796
views
SQL version of a recent Stack Overflow data-dump
I am trying to find a sql version of a recent stack overflow data-dump (2012 or 2013). I have been able to download an XML version but my programming knowledge is too limited to convert it in an sql ...
1
vote
1
answer
158
views
Known StackExchange OpenID receives jon.doeXXXX username at data.stackexchange.com [duplicate]
Possible Duplicate:
I'm being logged into Data Explorer as “jon.doe18”, why?
I logged into data.stackexchange.com for the first time, using the same OpenID that I use on ServerFault and throughout ...
1
vote
1
answer
110
views
How to obtain total number of views for a user combining questions and answers?
I'm interested in how to communicate the value of a contribution to StackExchange sites to others who know nothing about StackExchange. I thought that one index would be to have a total view count of ...
1
vote
1
answer
88
views
Is there a way to prevent Data Explorer from ignoring whitespace in query parameters?
I was thinking that a query to find posts with newlines followed by end-brackets might be useful for finding posts with code formatting issues-- for example, posts that look like this:
Here is what I ...
1
vote
1
answer
92
views
Close button + Esc for the save query dialogue in Data Explorer
When I vote to close a question on Stack Overflow, the dialogue layer shows a close button at the top left corner:
and pressing Esc dismisses the dialogue.
However, when I want to save a query in ...
1
vote
1
answer
176
views
OData continuation link is invalid
Repro: Open https://data.stackexchange.com/stackoverflow/atom/Posts
Observe: continuation link has port 20000:
<link rel="next" href="http://odata.stackexchange.com:20000/...
1
vote
3
answers
124
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)....
1
vote
1
answer
100
views
Slow queries don't stop, you just don't see the result, unless you find it in "everything"
If you locate my most recent "Quick Answers" result, note it does have a result, but note that it took 104 seconds!
This is much more than the Ajax timeout, but clearly the query didn't stop. This ...
1
vote
0
answers
91
views
What am I supposed to do when I get what is probably the "requires external JavaScript" error for the chat domains and SEDE?
I'm suddenly getting this error in my main sites (like SO and MSE)
Meta Stack Exchange requires external JavaScript from another domain, which is blocked or failed to load. Retry using another source....
1
vote
0
answers
38
views
View "people reached" data/trend through time for user
Is there a way to view a trend (graphically or tabulated) in the number of "people reached" per user per site?
E.g., to see how many people a user's posts impacted monthly or annually, etc.
...
1
vote
0
answers
31
views
Where is the GitHub link in the Data Exchange Explorer located? [duplicate]
I went closely over the SEDE's fields, but couldn't find where the GitHub link is saved for a user:
I ran this query on my own profile but couldn't find my GitHub account.
1
vote
0
answers
66
views
Login options in SEDE do not work
Clicking the login options such as Yahoo in https://data.stackexchange.com/account/login?returnurl=/account/login?returnurl=/account/login?returnurl=/stackoverflow/queries doesn't work. Hovering ...
1
vote
0
answers
82
views
Is there a way to check the change of geographical distribution of user base on SE?
I found geographical distribution checkers on SEDE, but is there a way to see how the population changes with time?
I want to see, for instance, from what country most people are joining vs from what ...
1
vote
0
answers
48
views
In the Data Explorer, can you get the change in the number of views for a single question? [duplicate]
I am trying to find out the monthly change in views for a single question in Data Explorer.
I was able to get the current number of views, but could not figure out how to get the past number of views.
...
1
vote
0
answers
63
views
How to find votes that were made with under 15 reputation [duplicate]
I've been using the LaTeX Stack Exchange site for a while to assist my learning of LaTeX. In this time, I have upvoted questions and answers that I found to be helpful. However, these weren't "...
1
vote
0
answers
54
views
Can I merge duplicate data.SX queries I've written? [duplicate]
I've written identically-titled SX data explorer queries, by mistake. Can I merge them (including merging their star count)? If not, can I make the system forget about one of them (i.e. delete one of ...
1
vote
0
answers
40
views
No new data on https://data.stackexchange.com/ [duplicate]
I noticed that the newest data for some tags from Stack Overflow is a week old. An example is here: https://data.stackexchange.com/stackoverflow/revision/1232357/1515799/custom-questions-between-time-...
1
vote
1
answer
88
views
Results table in Query SO
When using SO trying to find the Top 200 users in Europe,
SELECT TOP 200
ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#],
Id AS [User Link],
DisplayName,
Reputation,
WebsiteUrl,
...
1
vote
0
answers
20
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 ...
1
vote
0
answers
31
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 ...
1
vote
0
answers
56
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 ...
1
vote
0
answers
63
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 ...
1
vote
0
answers
32
views
Is it possible to obtain data on the evolution of questions' views over time? [duplicate]
In the SE data dump we can obtain a snapshot of the number of views over time. In particular, it is in the Posts table. I am looking for data on the evolution of views over time.
My question is ...
1
vote
0
answers
37
views
The recaptcha on data stackexchange isn't working [duplicate]
Is this a temporary situation or something that needed to be reported?
1
vote
0
answers
1k
views
Should we be worried by the V1 SHUTDOWN recaptcha? [duplicate]
It looks like ye old Google RECAPTCHA is being decommissioned but we still use it on data.stackexchange.com
Google decided to warn us with this "NUCLEAR HAZARD" style image.
So, dear site owners, ...
1
vote
0
answers
26
views
Recaptcha is breaking [duplicate]
I was trying to execute a query on data.stackexchange.com without being logged in, and it throws up this error (screenshot):
The devs might want to look into it, since this may be happening elsewhere ...
1
vote
0
answers
36
views
Data Explorer: Shrink query window a little more
The "Query Window" textbox on data.stackexchange.com is already stretchable, but it would be helpful if the minimum height were set "even smaller".
When testing quick edits to a query, it would be ...
1
vote
0
answers
67
views
SEDE Query to find posts I have cast delete vote on but aren't yet deleted?
Related to 10k "Most Delete Votes" List - Don't Show Questions I Can't Vote For, I'd like to be able to identify posts I've cast delete votes on, but which aren't yet deleted.
My ...
1
vote
0
answers
40
views
How to get "people reached" info from Users Table? [duplicate]
How can I get "people reached" data from the Users table for Stack Overflow?
I didn't find any fields related to the people reached state in the Users table/schema.
Is it possible to get that data ...
1
vote
0
answers
28
views
SEDE does not draw lines on execution plan when plan is very complex
In the execution plan for this query, the lines between the boxes are not drawn:
I am not sure if it is related to the number of boxes, or if it is because of the dimensions of the plan.
Chrome 58, ...
1
vote
0
answers
87
views
How to identify moderators in Data SE queries? [duplicate]
As I can see, the Data SE doesn't contain data, who are/were the moderator currently, or in the past.
To some queries, I would like to use this data. Currently, I do this by checking the election ...