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
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 ...
tshepang's user avatar
  • 9,893
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. ...
Cilan's user avatar
  • 2,611
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....
Prabhanjan Naib's user avatar
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 ...
user1029296's user avatar
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 ...
Dexter's user avatar
  • 215
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 ...
Cyril Gandon's user avatar
  • 1,643
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?
Tilak's user avatar
  • 825
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://...
jli's user avatar
  • 113
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 ...
Adam Rackis's user avatar
  • 22.3k
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 ...
Sathyajith Bhat's user avatar
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.
Gelatin's user avatar
  • 9,350
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 ...
adrianbanks's user avatar
  • 2,200
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 ...
Margaret's user avatar
  • 1,385
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 ...
sth's user avatar
  • 16.4k
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 ...
Dennisdd's user avatar
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 ...
Ian's user avatar
  • 275
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?
Chris's user avatar
  • 1,846
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 ...
tshepang's user avatar
  • 9,893
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 ...
Eugene's user avatar
  • 467
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 ...
user1029296's user avatar
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 ...
Miles Erickson's user avatar
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 ...
Jeromy Anglim's user avatar
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 ...
Jason Plank's user avatar
  • 4,570
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 ...
user avatar
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/...
Pavel Chuchuva's user avatar
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)....
scunliffe's user avatar
  • 1,304
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 ...
Mark Hurd's user avatar
  • 5,632
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....
starball's user avatar
  • 23.6k
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. ...
theforestecologist's user avatar
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.
abbood's user avatar
  • 373
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 ...
Tim's user avatar
  • 1
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 ...
tryst with freedom's user avatar
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. ...
Rukaku's user avatar
  • 11
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 "...
JAK Zero's user avatar
  • 119
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 ...
einpoklum's user avatar
  • 26.7k
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-...
MWZ's user avatar
  • 111
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, ...
Tiago Martins Peres's user avatar
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 ...
Taylor's user avatar
  • 111
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 ...
वरुण's user avatar
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 ...
Stormblessed's user avatar
  • 9,720
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 ...
Andre Silva's user avatar
  • 1,982
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 ...
splinter's user avatar
  • 299
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?
Avyansh Katiyar's user avatar
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, ...
Sklivvz's user avatar
  • 36.3k
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 ...
Anshul Goyal's user avatar
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 ...
ashleedawg's user avatar
  • 1,123
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 ...
Mogsdad's user avatar
  • 1,584
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 ...
Silent Spectator's user avatar
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, ...
Jason C's user avatar
  • 26k
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 ...
peterh's user avatar
  • 5,772

1
26 27
28
29 30
32