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
13
votes
1answer
131 views

Is it possible to get my posts in a downloadable file?

Is it possible to get my posts and the answers given on SO and other SE sites in the form of a downloadable text/html file? Similar to how tumblr allows its users to transfer their download their blog ...
13
votes
1answer
130 views

Auto-linkification of Tags.TagName fails when the tag name contains nonstandard characters

Run the following SEDE query: http://data.stackexchange.com/japanese/query/178382. All the tags except kyūjitai-and-shinjitai, renyōkei, あれ, and たい-form get auto-linkified. These happen to also be ...
13
votes
1answer
144 views

Username overflow in Data Explorer users page

Well, see for yourself: On other sites that I checked the user names are trimmed, so it appears to be local problem with the Data Explorer site only. Despite being fixed, the fix is still not ...
13
votes
1answer
71 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 ...
13
votes
1answer
90 views

Please adjust syntax highlighting on SEDE to the SQL that is actually in use

The highlighting on SEDE is a bit off occasionally. I've noticed that it highlights Length and Concat as function names, but the backend doesn't support those (it has Len and + instead). Can the ...
13
votes
0answers
72 views

Can the reviewtasks table include the reviews for deleted posts as well?

The table reviewtasks is sanitized for deleted posts. This means that it is hard, if not impossible, for the users that care and for those that want to evaluate the effectiveness of a community to ...
13
votes
0answers
82 views

A mysterious “StackOverflow_Temp” database appeared in the Data Explorer [closed]

Sometime within the past few weeks, a mysterious database named StackOverflow_Temp appeared in the Data Explorer. The Data Explorer user cannot actually USE this database: The server principal "...
13
votes
0answers
74 views

In the SEDE the data for Meta Stack Exchange is missing

In the Data Explorer this site, Meta Stack Exchange, is missing. Can this be added to the weekly data dump, please?
12
votes
1answer
154 views

What did Stack Exchange/Overflow change in May 2016 that cut low-quality questions so dramatically on the flagship sites?

So, I'll confess, I'm addicted to SEDE. To date, I've spent most of my time crafting queries to help with Spring Cleaning over on Chem.SE. However, alongside the site cleanup efforts, it appears that ...
12
votes
2answers
100 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 ...
12
votes
2answers
177 views

Is there a query to see how far are you from the proofreader badge?

So, is there a query to get how far are you from the proofreader badge? Something like How many Copy Editor/Strunk & White-qualifying edits have I made?
12
votes
1answer
196 views

On which Stack Exchange do you get the quickest answers?

I was writing an answer on this now-deleted question which basically asked 'Why do I get an answer quicker when I post on Stack Overflow than on Server Fault?'. This triggered me; was this just an N=1 ...
12
votes
3answers
141 views

When will Mathematica be added to the Data Explorer?

I think the Mathematica site has ample depth to be added to the Data Explorer. We have 2,988 questions, 6000+ answers, and 2000+ users. Half the sites represented on the Data Explorer cannot boast ...
12
votes
1answer
222 views

How does StackExchange DataExplorer prevent DOS attacks?

I have seen the page for composing Data Explorer queries. If I enter some stupid queries like: select * from Posts a, Posts b, Posts c ..... where 1=1 etc., how does StackExchange prevent it from ...
12
votes
1answer
145 views

Where do I ask questions about data explorer?

The tag wiki for data-explorer says: The Data Explorer, located at data.stackexchange.com, allows you to create and run queries against copies of the databases of popular StackExchange sites to ...
12
votes
1answer
167 views

Why are there no close or reopen votes in the data explorer following June 25th, 2013?

I ran this query select distinct CreationDate from votes where (VoteTypeId = 6 OR VoteTypeId = 7) order by CreationDate desc and got (That's showing the top of the list.) What's going on? I know ...
12
votes
3answers
240 views

Charts in the data explorer

I don't know whether the data explorer was created for SOFU, obviously if it wasn't this is impractical. Would it be possible to add an option to display the results as a chart?
12
votes
1answer
97 views

Data Explorer PRIMARY filegroup full

Same as this from 2011, I'm getting: trying to run any of the progress-towards-generalist queries.
12
votes
3answers
231 views

How close am I to earning the <TagName> badge

I have a request for someone to write a query in the data explorer that will accurately predict how close someone is to earning a tag-based badge. The current query (How Many Upvotes Do I have for ...
12
votes
1answer
100 views

Data.SE dumps are monthly… but when?

I've been playing with our awesome data site and wondering how frequently it's updated, and of course the FAQ says: How frequently is Stack Exchange Data Explorer updated? Data is updated ...
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 ...
12
votes
2answers
195 views

How often does data.stackexchange.com data synchronize? [duplicate]

I was running some queries just to test the site and the returns do not seem to reflect my activity at all. E.g., "How Unsung am I?" query tells me that I have 2 answers on SO, with one scored and one ...
12
votes
1answer
87 views

Are attempts at voting on locked posts recorded anywhere?

Like anonymous feedback, where SE gathers data about unregistered users voting on normal posts, is the same done for locked posts, and is this information stored on SEDE?
12
votes
1answer
133 views

When are closed sites removed from SEDE?

Augur Stack Exchange has been closed down four days ago, according to its Area 51 page. Yet, it's still visible in SEDE. I was wondering how long it would be kept; sites which have been closed for ...
12
votes
1answer
453 views

SHOWPLAN permission denied when including execution plan in Data Explorer

If I select the "Include execution plan" checkbox in the Data Explorer, the query fails: SHOWPLAN permission denied in database 'StackOverflow'. I see that this has happened before following ...
12
votes
1answer
372 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?
12
votes
1answer
78 views

When logging in to SEDE, please redirect back to the original page

Pretty straightforward request. If you're on the query page and log in, currently you get redirected back to the home page after logging in. I would like to be redirected back to the page where the ...
12
votes
1answer
147 views

404 on Beer Meta image

The Beer Stack Exchange icon on Data Explorer is missing or misdirected. The HREF points to an image that seems inappropriately named: cdn.sstatic.net/Sites/beermeta/img/apple-touch-icon.png
12
votes
1answer
75 views

The images on the main page of SEDE are not loading

I visited the main page of SEDE and noticed that most of the images return a 404: This looks like a similar problem as reported earlier in Missing images in SEDE but that covered the site-switch drop ...
12
votes
1answer
234 views

How can we write a query in data.stackexchange to find the CloseAsOffTopicReasonType for a closed question?

I am attempting some data mining via data.stackexchange but failing in my current task, as I cannot find the "off topic reason" for closed "off-topic" questions. Given a closed 'off topic' question ...
12
votes
1answer
133 views

Data migration did not run last weekend

The migration of data to data.SE "didn't work" - dara is only up to 2013-10-06 (nine days ago as of now). Could someone please look into it? Update: Still not run - 13 days old now. BTW I've ...
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://...
12
votes
1answer
100 views

Add content for the URL data.stackexchange/sitename

So you start at the Data Explorer start page, and then you click on the Stack Overflow site. And then a couple of days later, when you start typing the URL in your browser, you remove the last parts ...
12
votes
2answers
132 views

Data Explorer needs the ability to comment on queries [duplicate]

Possible Duplicate: Notify/contact SEDE user of fix to query I just tried out odata.stackexchange.com for the first time - quite impressive! However, I really missed the abilty to comment on ...
12
votes
1answer
78 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 ...
12
votes
0answers
164 views

Create example, reference queries on Data Explorer

Could we have some example queries, generated by the Stack Exchange team themselves, to use as a reference for the Data Explorer? Edit: Based on the comments, I need to clarify that I am suggesting ...
11
votes
5answers
549 views

Most and least dangerous tags to answer (among the tags with 1000+ questions) [closed]

Most and least dangerous tags to answer (among the tags with 1000+ questions) Turns out that MS-Access answers get a 10% chance of a downvote. Good thing I steer clear of MS Access!
11
votes
1answer
469 views

LIMITs on data.stackexchange.com?

SELECT Id, DisplayName FROM Users ORDER BY CreationDate DESC LIMIT 10; That query didn't work on data.stackexchange.com. I guess LIMIT isn't a key word. As such how would I go about doing a LIMIT?
11
votes
1answer
201 views

Data is showing MvcMiniProfiler results. Is that expected?

Not sure if this is actually desired, but data is currently showing me (a SE non-dev) mvc-mini-profiler results, including all queries that are being run against the DB (not talking about data-...
11
votes
1answer
238 views

A couple of (popular) queries on the Data Explorer aren't working

So far, it seems to be: How long until I get the generalist badge? How many upvotes do I have for each tag? The first query gives me no results, the second gives me two rows: TagName ...
11
votes
2answers
89 views

How to find the users who took a long break from posting on an SE site?

I would like to find the users who took a break from posting on a particular SE site. That is, top N users by the length of time interval between two consecutive posts. I know that Data Explorer ...
11
votes
1answer
127 views

Pretty pretty please, can you update the SEDE data? (not just the date)

So, after asking for a SEDE update, we got one — sort of: the date was changed, but it's still the old data. Same as last time. Can we, pretty pretty please, get a real SEDE update?
11
votes
1answer
907 views

Documentation for Stack Exchange Data Explorer Schema? [duplicate]

Maybe I'm missing something obvious, but is there documentation on the SEDE schema anywhere? As listed here http://odata.stackexchange.com/stackoverflow/query/new, it's not obvious what all the fields ...
11
votes
1answer
198 views

Why is the data explorer telling me there are closed questions with no close votes?

I am curious why SE Data Explorer is telling me there are closed questions with no close votes I don't think my query is wrong, but I suppose it could be: select Closevotes, count(*) from ( ...
11
votes
1answer
124 views

Show names and ids from VoteTypes, PostTypes, etc. tables in the Data Explorer UI

While writing a query in the Data Explorer, I nearly always have to interrupt the process to query the VoteTypes, PostTypes, and / or PostHistoryTypes tables (so I can remember the Ids I need). I ...
11
votes
3answers
1k views

How to browse SO data dump?

I'm looking for a way to let my students browse StackOverflow, Superuser and other StackExchange sites from within our inner network (internet connection is not an option). I'm currently downloading ...
11
votes
2answers
134 views

Add close reasons to the data dump and to Data Explorer

We already have the close votes (VoteTypeId = 6), but there aren't any close reasons associated with each vote.
11
votes
1answer
139 views

Data Explorer data hasn't been updated for at least three weeks

It's currently been about 3 weeks since the last data migration to data.stackexchange. The help page says that data is updated weekly. Why hasn't that been happening? Surely this should be an ...
11
votes
1answer
253 views

Show top user rank

I have search to find top user as different way like : Top user of Specific Country Top User base on Profile View Top User base on Technology I am able to check all above query result in Data ...
11
votes
1answer
166 views

Direct links to the new SEDE graphs

I noticed we can now generate graphs on SEDE (Awesome!!), but unfortunately there doesn't appear to be any way to provide a link directly to the graph tab of a query. Is there any chance we can get ...