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
16
votes
2answers
141 views

How can I check how many times a user has made the Hot Network Questions list?

During my time on SE, I've asked more than one question that hit the Hot Network Questions list (3 that I know of, each from a different SE site; same linked account). Other than analyzing the number ...
16
votes
1answer
655 views

Running queries to StackExchange Data Explorer from anywhere

Now that we have an awesome tool StackExchange Data Explorer, won't its usefulness be multiplied manifolds if we could have a way of embedding queries onto a site that can fetch the results without ...
16
votes
1answer
2k views

Is there a beginner's tutorial for using the Stack Exchange API v2.0?

Is there a "Stack Exchange API 2.0 for Dummies" page out there somewhere? Almost all of the support questions on Stack Apps are for 1.0. Everything explaining how to use javascript to parse through ...
16
votes
1answer
146 views

Can we get a Stack Exchange Data Explorer update?

The latest SEDE update was on March 21. Since it needed two Meta questions last time to get it, I'll ask here: can we get a SEDE update, pretty please? Could them updates be monthly, pretty pretty ...
16
votes
0answers
207 views

Users who can't write good posts ≠ users who want to write good posts

I recently came across this post, which states (emphasis mine): ..The problem that became evident was that people who want to learn how to write a good question and people who can't write a good ...
15
votes
2answers
314 views

Why is the logo used on the Stack Exchange data explorer different from the standard Stack Exchange logo?

Here is the standard Stack Exchange logo: Now here is the one used on the Data Explorer: As you can see, the text is a different font and the 3D styles on the speech bubble are different in each ...
15
votes
1answer
272 views

Why are there so few posts with zero comments?

While researching my theory that showing comments costs votes, I noticed that there are surprisingly few posts with zero comments. Here's what the distribution looks like: That graph was generated ...
15
votes
1answer
452 views

Is the Data Explorer now updated weekly? [duplicate]

There was an update around the 17th or 18th. Now, I see that all of the sites have been updated as of the 25th. I know that there was a time when a weekly or every-two-week update cycle was planned, ...
15
votes
2answers
239 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 ...
15
votes
3answers
320 views

“member for” is a negative number on Data.SE

I've recently joined Data.SE, and seen this: -55, -54, and counting… it reached 0, but then it started over from -59! It seems I'm not alone with this problem
15
votes
1answer
135 views

What are these mysterious gaps in the progression of post id?

Initially, I assume that PostId is auto-incremented. Except for very rare cases, where the data is completely wiped from the database, leaving some holes in the PostId progression, I expect that the ...
15
votes
1answer
267 views

How to calculate per site meta reputation?

The displayed reputation on per site meta is the same as on the respective parent site. However, out of curiosity, I'd like to see the actual reputation users would have on a meta if it was counted ...
15
votes
1answer
213 views

How many times was a shared link clicked on?

Background The Announcer badge is awarded to people who share a link that results in 25 distinct IPs clicking on it. To track that the URLs are constructed like this: https://stackoverflow.com/a/...
15
votes
1answer
170 views

Taxonomist Badge - Who's the owner?

I have identified an anomaly in the awarding of a Taxonomist badge in Gardening. This fortunate user was awarded Taxonomist for tomatoes. This is doubly fortunate because this user has never added a ...
15
votes
1answer
527 views

Why do Data Explorer and Stack Overflow data dumps have different schemas?

I have downloaded the Stack Overflow data dump and imported it into a MySQL database. There were six XML files in the dump, so I created six tables, one for each XML file present in the dump: badges, ...
15
votes
1answer
127 views

Anonymous Feedback disappeared from the Data Explorer?

I went to use my query for "Anonymous Feedback for a specific question", but now it throws an error: Invalid object name 'PostFeedback'. It seems the PostFeedback table is not in the current SEDE ...
15
votes
1answer
165 views

Tag delimiters are not consistent in posthistory.xml

In the September 2011, December 2011, and several of the closed site data dumps the tag history is not delimited consistently across all sites. As an example from IT Security: <row Id="48" ...
15
votes
1answer
252 views

Provide more frequent data dumps to Data Explorer

In the SO blog post "Introducing Stack Exchange Data Explorer" (2010-06-13), Jeff states in a footnote: we are looking at eventually making special weekly or biweekly dumps for SEDE Is this still ...
15
votes
0answers
129 views

Add Full-Text Search and Semantic Search to Data Explorer

Can SQL Server Full-Text Search and Semantic Search be added to Stack Exchange Data Explorer? Much of the textual data is difficult to query using T-SQL alone (impossible, if one hits a time out). ...
15
votes
0answers
306 views

Please provide a way to download SEDE data via an API

I recently suggested on the Stack Apps site that a formal API be added to SEDE, and it was suggested I reference the feature request here, for visibility. My use case is a query that the API does not ...
15
votes
0answers
79 views

Include ViewCount in the Posts table for tag wikis (in SEDE)

Currently, the ViewCount column of the Posts table in SEDE is always null for tag wikis (posts where PostTypeId = 4). But this data is certainly tracked somewhere internally - I can look at the ...
14
votes
5answers
604 views

Strunk-and-White problem?

Thanks to the new edit system(which I really like, BTW) I recently got Strunk-and-White. Awesome! I'm a curious guy, so I had been periodically seeing how many edits I had with some data explorer ...
14
votes
2answers
435 views

Does data explorer give access to the markdown version of post? (photobucket issue)

Photobucket has gone bad, so I've a number of old posts across the network which have broken images as I made them prior to the imgur deal. The internal search doesn't work - "user:me photobucket" ...
14
votes
1answer
104 views

Why do Data Explorer queries sometimes load *and* run, and other times just load?

I haven't gathered enough data on this to figure it out, so maybe it's Yet Another Feature I'm Still Learning About Stack Exchange. I have several queries in SEDE; my typical SEDE usage is: load the ...
14
votes
1answer
78 views

SEDE graphs displaying nothing after today's update

Stack Exchange tweeted today about a SEDE update After this update, the "graph" view of the SEDE seems broken. It displays absolutely nothing.
14
votes
1answer
154 views

SEDE migration failed?

It's currently 11AM UTC and SEDE still has previous week's data (usually migration occurs around 4AM Sunday UTC). I know there's no SLA; this is just a heads-up and bug-placeholder in case there's a ...
14
votes
1answer
121 views

How can I delete my Stack Exchange Data Explorer account?

How can I delete an account on the Stack Exchange data explorer? I can't find any way to request the deletion when logged in to the account. (Note that SEDE is an independent system. SEDE accounts ...
14
votes
1answer
150 views

Query Which Omits Questions I've Voted to Delete

I've written a query " List of Questions with only 1 Remaining Delete Vote Required to Delete ". One of the several problems with this query is that it includes questions that I have already voted to ...
14
votes
1answer
153 views

Data Explorer — are updates still happening?

I occasionally browse the Data Explorer and appreciate it's not real-time, but only a snapshot at the time it was last updated. I thought it was updated monthly, at least that's what the FAQ states ...
14
votes
1answer
108 views

More user-friendly behaviour for too-long titles in Data Explorer

Using a title longer than 100 characters for a Data Explorer query produces an MS SQL error message: String or binary data would be truncated. The statement has been terminated. This should be made ...
14
votes
1answer
80 views

Please add suggested edit rejection reasons to SEDE

The SuggestedEditVotes table on SEDE only records whether the vote was an approval (VoteTypeId = 2) or a rejection (VoteTypeId = 3). Please add the rejection reason as well. This would be useful for ...
14
votes
1answer
156 views

Can the bit of random site icon placement at SE Data Explorer be changed?

Is there a reason that some icons of SE sites are not paired up neatly with their respective meta icon on SE Data Explorer, while the vast majority are? If not or if it is bypassable, I suggest the ...
14
votes
2answers
163 views

Infallible Answerers

Most people have a bad day once in a while and post an answer that doesn't receive any upvotes. With an increasing number of posted answers the probability increases that there are such answers. If ...
14
votes
1answer
135 views

Programming Puzzles & Code Golf throws an error on the Data Explorer

Although the Stack Exchange Data Explorer is an invaluable tool for many, it appears that the Programming Puzzles & Code Golf site is throwing an error upon querying. It appears to me to be a ...
14
votes
1answer
167 views

This definitely shouldn't be here

BOOOOOOOOOOOOOOOO!! http://img175.imageshack.us/img175/3962/editlink.jpg I'm not ausaitis or a moderator, so I don't think I should be editing his profile... The link doesn't work, it just sends me ...
14
votes
0answers
86 views

Stack Exchange Data Explorer and Stack Exchange Data Dumps should include public chat room messages

All data from public chat rooms should be available in the data dumps and queryable in the Stack Exchange Data Explorer. Of course, deleted messages should not be available (since the general public ...
14
votes
0answers
145 views

Directly support cross-site queries in the Data Explorer

Often you want to query some statistic for a user across all sites. For example, you might write a query to find your rejected suggested edits across all Stack Exchange sites. To implement this, you ...
13
votes
2answers
193 views

Is there a way to auto-identify tag synonyms which differ by *only* a hyphen?

Note: There is a nice background discussion on this here: Should tags take the form foobar or foo-bar?. This discussion is not part of this question however: I'd like to go through and propose a ...
13
votes
6answers
684 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 ...
13
votes
2answers
203 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 ...
13
votes
2answers
229 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?
13
votes
3answers
390 views

Why is there a TextBox instead of a Button in Data Explorer's Captcha?

I was trying to run a query in Data Explorer without logging in (I didn't notice that I am not logged in). When I click on Run Query button, I got a Captcha to avoid spam queries. But what I found ...
13
votes
1answer
510 views

My project requires data from Stack Overflow. What can I do?

I want to make research on Stack Overflow (or any other Stack Exchange website). How can I parse the website's data using regular expressions?
13
votes
1answer
427 views

Data from the Stack Exchange Data Explorer is obsolete [duplicate]

I was querying data from http://data.stackexchange.com/stackoverflow/atom using a LINQ query in LINQPAD and found that the data I got back is quite obsolete. I searched for Shekhar-Pro (me) by using a ...
13
votes
2answers
129 views

Did something change in SEDE's data?

Over on Ask Ubuntu, we have been using this query to find out old posts with non-imgur images. It was working alright before this weekend, but now it's returning 0 rows. What's going wrong?
13
votes
1answer
143 views

Why Are Queries Joining to Votes So Slow?

I've written two queries which are concerned in some way with delete votes, and in both cases, they are too slow. They both time out if I don't use TOP n at various points in the query. For the first ...
13
votes
1answer
119 views

SEDE not fully-up-to-date after last “update”

According to this previous bug report, SEDE had error so it did not update at usual time. The bug report was marked status-completed. Even though SEDE says it "updated 14 hours ago", it isn't ...
13
votes
1answer
132 views

When will StackExchange sites be available in Data-explorer

When will StackExchange 2.0 beta sites be available to query to Data Explorer? It would be helpful to building the site to be able to query them. If they are available now, how can I access them? ...
13
votes
1answer
147 views

Data “dumpification”

I'm not one to pester*, so I wanted to put in a polite request for new data to be placed in the Data Explorer whenever there is an opportunity. I know there are posts saying that the schedule is ...
13
votes
1answer
165 views

Information about database indexes in the Data Explorer

Some days ago I discovered the Stack Exchange Data Explorer (SEDE) which provides already lots of interesting queries out of the box (thanks to the contributors). After a while I noticed that some of ...