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.

158 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7
votes
0answers
57 views

UsersHistory Table on SEDE

Stack Exchange Data Explorer is awesome! It's an invaluable tool to analyze a site's activity, monitor unanswered questions and answering time, or just to fetch a dataset for further analysis of ...
7
votes
0answers
119 views

Color of site icons on Stack Exchange Data Explorer is (not technically incorrect but) confusing

In the Stack Exchange Data Explorer, the icon color for the various sites *seems** incorrect: Whenever I select a main site, the icon is greyed out, and when ever I select the corresponding meta site, ...
7
votes
0answers
103 views

Viewing total re-open votes in SE Data Explorer?

Can you allow us to view total re-open vote count in data explorer? I am asking because I find it extremely hard to get questions re-opened by the community on lower traffic SE sites. Closed ...
7
votes
0answers
61 views

Add reputation at post time to PostHistory records in the data dump

One of the weaknesses of the data dump is that it is not possible to determine a user's reputation at a particular point in time. This is "by-design" and perfectly okay. However, there are a number ...
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 ...
6
votes
0answers
53 views

How can I track for rejected migrations in the SEDE?

I would like to collect the data of the rejected question migrations in the SEDE. I can't see a direct reference to it - the PostHistoryTypes table contains only references to the really executed ...
6
votes
0answers
77 views

Enable SEDE graph image to be saved or copied

When graphing data on SEDE, eg this example, right-clicking on the image and selecting either "Save as file" or "Copy image" both result in a totally black rectangle (albeit of the correct dimensions) ...
6
votes
0answers
54 views

Make SEDE graphing easier

SEDE is generally great, but the one thing that keeps bugging me about it is its graphing support. The given example of graphing in the SEDE help is graphing the number of posts for each score. ...
6
votes
0answers
52 views

Who am I on data.stackexchange.com?

After logging in to http://data.stackexchange.com/, I noticed my username was something like jon.doe15295. So I changed that to something more readable. But then I found that the account I had logged ...
6
votes
0answers
106 views

Is user's breakdown of votes per Q/A available on Data Explorer?

I can get total UVs and total DVs of the user from Data Explorer: select UpVotes,DownVotes from Users where DisplayName='sjl' -- user randomly picked from the first SE tab I had open, as long as not ...
6
votes
0answers
62 views

Is there a way to recover how people voted to close a question post-close?

When the question has close votes (<5), and you click on "Close" link, in the dialog for closing it shows you how many people voted for each of separate options (e.g. 1 voted as Duplicate, 3 voted ...
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 ...
5
votes
0answers
42 views

Provide a permalink to a query with parameters

I've noticed that sometimes I get a "permalink" for a query that includes the parameters I gave. This is very inconsistent, and I failed to find out when it's provided and when it isn't. So I have to ...
5
votes
0answers
125 views

How to login normally to data.stackexchange.com

I used to log in to https://data.stackexchange.com by inputting my login/pass from Stack Overflow. But today, on the login page, I only see this: But I never created accounts on Yahoo, LiveJournal, ...
5
votes
0answers
38 views

data.SE - better way to distinguish between forks/same-title queries

When I search for queries on data.SE, I often get a large number of results with the same query name, which are, I assume, forks and variations of the same query. I believe something needs to be ...
5
votes
0answers
71 views

Add the “Days Visited” metric to SEDE

I was writing a query on SEDE, when I noticed there was no "Days Visited" value. I have circled the available user metrics, alas there is no Days Visited While there is a CreationDate, this can't be ...
5
votes
0answers
116 views

Make Handled flags also availaible

Some months ago (when Meta was still Meta Stack Overflow), I got the feeling that the time a flag get handled is increasing when the first flagging is trigged on a question older than one month ...
5
votes
0answers
33 views

SEDE Database Schema overlapping text

Overlapping text on right side box: To repro, follow this link and scroll down about half way.
5
votes
0answers
135 views

There are no foreign-keys constraints in the data-explorer database

While creating the answer for Database Diagram of Stack Exchange model? I was looking for the schema information stored in the SEDE database. The sys.tables and sys.columns are populated but when I ...
5
votes
0answers
74 views

What about adding CreationDate to Tags in SEDE database?

Would it be possible (from the technical viewpoint) adding creation date to the Database Schema of SEDE.1 (Or maybe even id of the user who created the tag or id of the question where it was created.) ...
5
votes
0answers
40 views

SEDE not parsing localized tags

I ran the query Most common tags with missing wiki/excerpt and Stack Overflow em Português localized tags are rendering as: I think it's not a duplicate, the other bug report renders the following in ...
5
votes
0answers
50 views

Finding historical reputation requirements

Stack Exchange sites have different reputation thresholds that allow users to do various things. For example, on Stack Overflow, creating tags requires 1,500 reputation, while on Database ...
5
votes
0answers
55 views

Deletion via Low Quality review should be recorded in Data Explorer

When an answer is deleted from Low Quality Review by under-20K users, this is recorded as "Post Deleted from Review" in the revision history. However, there is no record of this event in the Data ...
5
votes
0answers
44 views

Expose SuggestedEditVotes in the data dump

I'd like to use the SuggestedEditVotes table (which is available in SEDE) to find robo-reviewers. I'm often offline without connection to SEDE, and I want to do something remotely productive during ...
5
votes
0answers
39 views

Beta meta site descriptions are wrong on SEDE

Code Review Meta's description: Q&A for peer programmer code reviews This is the same as the description for Code Review itself. In keeping with the description for the non-beta metas, this ...
5
votes
0answers
68 views

I forgot to sign in to Data Explorer. Can I get my queries back?

I recently created a series of queries in the data explorer which I'm quite proud of. To wit, they are What reputation do people with Popular/Notable/Famous Question badges typically have?, and after ...
5
votes
0answers
81 views

Can't get Data Explorer results to agree with StackOverflow close vote queue size

I'm messing around with Data Explorer and having some trouble getting results that match the Stack Overflow close vote queue size displayed on /review. The review page says the current queue size is ~...
5
votes
0answers
414 views

Can't Permalink to text results in data explorer

When you: compose a query in the Data Explorer check the Text-only results checkbox run the query the permalink hyperlink looks like this: http://data.stackexchange.com/user%20experience/query/...
5
votes
0answers
62 views

Can these accounts on Data.SE please be merged?

Normally getting accounts merged is a straightforward process that can easily be done by a moderator. However, that is definitely not the case over on Data.SE. I have accidentally created two user ...
5
votes
0answers
58 views

Please add a Privileges table to the Data Explorer

I was reviewing some of the "Interesting queries on Data Explorer", and saw that the top-voted answer, "How many users can do X?", was broken and obsolete. And, it only had data for Stack Overflow ...
5
votes
0answers
68 views

Known deployments or users of Stack Exchange Data Explorer source?

Do we know of any known installations of the Stack Exchange Data Explorer code out in the wild?
5
votes
0answers
65 views

http://data.stackexchange.com does not onebox in chat

When posting a link to the frontpage of a site in the Stack Exchange network in chat, it gets oneboxed automatically. However, when a link to the Data Explorer gets posted in chat, it does not onebox,...
5
votes
0answers
82 views

New Altruist Moderator Query : Spreading the badges

I have started to use that nice tool, DataExplorer, yesterday. I would like to have comments and suggestions about this Badge oriented Query Its purpose is to list posts which are close to the ...
5
votes
0answers
61 views

Ability to “vote to close” Data Explorer queries

I have recently come across an SO Data Explorer query which produces incorrect results and posted a question about having it removed: Data Explorer - Invalid Query: Electorate Badge Progress This ...
4
votes
0answers
92 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 ...
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 ...
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, ...
4
votes
0answers
34 views

Is it possible to estimate the active reviewer population using the SEDE data?

My main site has, I think, a problem with a shrinking reviewer population, and I would like to use the SEDE data to estimate whether this is indeed the case and, if so, how bad it is and how it has ...
4
votes
0answers
57 views

Invalid Tags in Data Dump

I noticed a minor inconsistency in the 2017-12 Stack Exchange data dump. In the Posts.xml files, the tags for posts are stored in the Tags attribute, each surrounded by <>: <row Id="307517" ...
4
votes
0answers
37 views

SEDE statistical model construction, how do I calculate the effect of the upvotes to the new content?

I think we all know the endorphin produced by the Green Rectangle very well. Varying from our individual habit, mood, SE experience, and a lot others, I think we can agree it is a major force growing ...
4
votes
0answers
43 views

How to identify “questions upvoted” and “answers downvoted” in SEDE?

In this query: DECLARE @PERCENT float = ##PERCENTUPVOTES## DECLARE @MIN_VOTES int = ##MINVOTES## SELECT id as [User Link], Reputation, UpVotes, DownVotes, (1.0*UpVotes/(1.0*UpVotes+1.0*...
4
votes
0answers
85 views

Accessing Deleted Question Content

I'm a 10k user on Math.SE. As a human using my browser, I can access deleted questions and view them, just like non-deleted questions. I'd like to use this access to collect data for a personal ...
4
votes
0answers
93 views

Inconsistencies in SEDE URLs for meta sites

There is a weird inconsistency in the URL usage for meta sites inside the Data Explorer: For example, it's usually academia and meta.academia, but it can sometimes be arduino and arduinome. Why is ...
4
votes
0answers
79 views

Cannot log in on data.stackexchange.com with Yahoo! anymore

Opened http://data.stackexchange.com/account/login Clicked Yahoo! image Getting the following message: This message has already been processed. This could indicate a replay attack in progress. ...
4
votes
0answers
39 views

Add Data Explorer to the new top-bar

The new top bar does not contain the Stack Exchange Data Explorer in the list. Can we please add it? Area51 is in the list too. So don't you give me a This is no real site argument.
4
votes
0answers
528 views

Search over queries needed

We've got enough in "everything", at least, to want to search for specific queries. E.g. I know I had some 'queries' that just PRINTed stuff, with no result sets, that would have been useful to test ...
3
votes
0answers
31 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?
3
votes
0answers
79 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 ...
3
votes
0answers
40 views

OpenID login on SEDE over HTTP is broken, doesn't show error

I was trying to log into SEDE using the Stack Exchange OpenID function. However, without any erros, I kept not being logged in. Eventually, I discovered I was using the HTTP to connect to SEDE, not ...
3
votes
0answers
54 views

How do I get into my data.stackexchange.com account?

When I log into http://data.stackexchange.com/ with either open id or google or stack exchange, it takes me to some fake username jon-doe27508 That's not me: http://data.stackexchange.com/users/27507/...