The Stack Exchange Data Explorer (SEDE) allows you to create and run queries against copies of the databases of popular Stack Exchange sites.
-3
votes
0answers
42 views
Databases are not synchronized? [duplicate]
I composed an query on http://data.stackexchange.com to show top 500 users from Poland on Meta. I saw that result :
From this it follows that my reputation on meta is 224, but a correct value is ...
2
votes
0answers
60 views
Why are certain PostHistoryTypeIds not present in the data explorer?
The PostHistoryTypes according to the Data Explorer are given here. However, certain HistoryTypeIds are never present while querying the Data Explorer. The most notable missing id for my personal data ...
3
votes
0answers
36 views
odata access from data.stackexchange.com down
The OData endpoint provided at data.stackexchange.com has been down for the last few days. I have searched for information about the outage, but I can't find any reason or explanation. Can someone ...
1
vote
0answers
31 views
How to get type of the badge (Bronze, Silver, Gold) from Data Explorer? [duplicate]
I was just curious who have the most Gold, Silver or Bronze badges but I can't find the field in Data Explorer that represents the type of the badge. Either it's missing or I can't find it.
So, how ...
3
votes
1answer
60 views
Where is the Stack Overflow data dump located? [duplicate]
I have already tried the data explorer but need the raw data. The most recent one I could find is from 2011.
Presumably there is a more recent version?
10
votes
1answer
115 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 ...
2
votes
1answer
46 views
Why another login is required for http://data.stackexchange.com/, when I've already logged into Stack Overflow with the same OpenID
I use the same OpenID to log onto SO sites. When I log in to http://stackoverflow.com, and then navigate to other site such as http://meta.stackoverflow.com, it recognizes the same OpenID.
But when I ...
42
votes
0answers
135 views
+50
Beta sites should be in the Data Explorer
The Stack Exchange Data Explorer is a very nice and useful tool, but it has one very large drawback: Beta sites are not included at all.
Excluding beta sites probably made a lot of sense when the ...
4
votes
1answer
81 views
Percentage of high-rep users over time?
I've thought of a SEDE project that would be very interesting, but I think it would require a time machine, and unfortunately my flux capacitor is busted. I'd like to know what the percentage of ...
18
votes
1answer
163 views
Why hasn't Christianity made it into the Data Explorer yet?
Christianity.SE officially graduated at the end of May. A question on our local meta asked when we could expect to see our site show up in the Data Explorer. The response was that it might lag a week ...
1
vote
0answers
129 views
Encouragement to write more answers
I wrote this Data Explorer query to show the average answer-accept rate vs the number of answers a user has written, minus the top power-users (who don't accurately represent the average user). ...
0
votes
0answers
18 views
Is tag and tag-synonym table schema current in the Data Explorer?
http://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 ...
4
votes
0answers
52 views
“How frequently is SEDE updated?” wrong on FAQ
According to How old is data for queries?, SEDE's data is updated every Sunday, but the FAQ says:
How frequently is Stack Exchange Data Explorer updated?
Data is updated monthly.
This ...
0
votes
0answers
42 views
My query no longer works on MSO; still works on SO
I've been using a SEDE query to give me a list of badges I haven't yet attained. It's been working fine up until now:
select distinct name
from badges
where not exists (
select *
from tags
...
2
votes
1answer
38 views
Are scores in the comments of closed questions counted towards the Pundit badge?
I recently (yesterday) got more than 5 scores in a few of my comments, but while the question was closed.
Will this be counted for my pundit badge progress? When I checked my progress in the Data ...
1
vote
1answer
76 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 ...
1
vote
2answers
109 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
0answers
44 views
Import Stack Overflow data dump into MySQL [duplicate]
I have downloaded the latest Stack Overflow data-dump (march 2013) from the ClearBits website:
http://www.clearbits.net/creators/146-stack-exchange-data-dump
I am trying to import this data dump ...
2
votes
2answers
34 views
Can the Careers data be queried?
If jobs were like SO posts, I'd love to see something like
select top 500
tags.tagname, count(posts.id) as nposts
from posts, posttags, tags
where
year(posts.creationdate)=2013
and posts.id = ...
4
votes
1answer
35 views
Extend or Remove DataExplorer timeout
I know that we don't have automatic login for the DataExplorer but what's with the automatic timeout/logout? There have been times that I am logged into the site, maybe I walk away for a little bit ...
2
votes
1answer
56 views
How old is data for queries? [duplicate]
I like to play with stack exchange queries sometimes and usually data is outdate. I assumed that SO database is cloned/copied periodically. Just wondering, how old is data?
-8
votes
1answer
98 views
Why are deleted comments not in Data Explorer
I understand everything said in this post about why comments should be brief and temporary. I'm far from that reputation count so that does not concern me at all.
The thing is I'd love to see all my ...
1
vote
1answer
42 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 ...
-7
votes
1answer
39 views
Minor error in FAQ for data.SE
On the FAQ page for data.SE; one of the question (with its answer) is:
Which sites are included?
All public Stack Exchange websites are included. Sites that are in
public or private beta ...
1
vote
1answer
42 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 ...
5
votes
1answer
46 views
What tool is used for data.stackexchange.com query building
http://data.stackexchange.com/stackoverflow/query/new
Has an awesome tool for creating queries. Is this a third-party tool or was it built in-house?
I'd love to use something similar for SQL Server ...
3
votes
1answer
162 views
Why did I get associated as Jon Doe?
When I logged into Stack Exchange Data Explorer for the first time today using my normal Stack Exchange Open ID I was given the display name Jon.Doe8551. There are indeed 66 pages of Jon.Does on ...
3
votes
1answer
57 views
5
votes
1answer
155 views
How can I find which user asked the most questions on Stack Overflow? [closed]
Is there a way to find which user has asked the most questions on Stack Overflow by today (14 - 05 - 2013)?
0
votes
2answers
33 views
Script to fetch results from data explorer
Is it possible to fetch data results from data explorer without going on the page ?
The thing is that there is a captcha to prevent spam queries so I'm not sure it's possible.
But is there a ...
5
votes
0answers
50 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 ...
30
votes
0answers
148 views
Show suspended users with their normal reputation in the Data Explorer
I was playing with the Data Explorer... And I was trying to write a query to show users who got the most % of their reputation from accepts.
So for each user: [% from Accepts] = [Rep from Accepts] / ...
3
votes
1answer
84 views
Why haven't I earned the badge, but I have it?
I saw this question, which discussed a Data Explorer query for counting edits. So I decided to try it out with the account I am most active on, Science Fiction & Fantasy. To my surprise, the ...
5
votes
0answers
47 views
'Age' field in data explorer is inconsistent with main site
This appears to be a re-occurrence (or it never was fixed) of this bug:
Age calculations are wrong in the data dump export
Basically, when running a Data.SE query, the age field seems to be ...
33
votes
2answers
282 views
Maybe it's time to update the code base of Data Explorer?
Not talking about the data, this one appears to be updating regularly which is awesome.
Talking about this:
There is outdated footer (e.g. "contact us" is still a mailto: link!) and more than ...
24
votes
1answer
166 views
User views on Data Explorer is wrong or extremely out-of-date
I noticed that the Users.Views field for every single active user is extremely out of date. It is even zero/missing for some (not too new) users.
Example:
...
1
vote
0answers
44 views
Google OpenId provided autologging me as another (possibly dummy) user [duplicate]
I wanted to find the posts eligible for archaeologist badge and came across the following link
...
6
votes
2answers
159 views
Upvotes with no user
I was just querying the stack exchange database, and I noticed that there are records in Votes
for upvotes with null UserId.
SELECT COUNT(*)
FROM Votes
WHERE VoteTypeId = 2
AND UserId IS NULL
...
4
votes
2answers
125 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 ...
1
vote
1answer
36 views
how to extract tags and the number of question tagged
I want to extract question tags in stack overflow and the number of questions of each tags. I read this post Is there a way to extract statical information based on tags?. The answer shows I can get ...
3
votes
0answers
24 views
Get favorite count for tag
Is there a way to get the number of times a tag is favorited or the favorite tags for a user in Data Explorer?
It seems Tags.Count is the total number of questions with that tag.
Count won't work ...
4
votes
2answers
155 views
Allowing JavaScript from domain microsoft.com on Stack Exchange Data Explorer (SEDE)
While logging into Stack Exchange Data Explorer (SEDE), I noticed I did not have the usual OpenID icons (for Stack Exchange, Google, Yahoo, etc.), but a blank line. Suspecting my NoScript plugin that ...
4
votes
1answer
77 views
Trouble with fetching data
I'm trying to query the following data from stackexchange:
Fetch all the questions asked about Android, in past five years, and display post's id (a.iD), associated tags (a.Tags), for the person ...
7
votes
1answer
79 views
What do these attributes refer to in the SEDE Schema?
In the SEDE Schema under Votes -> VoteTypeId, there are
Upmod
DownMod
InformModerator (Probably refers to the Inform Moderator Flag ?)
ModeratorReview
What do each of these atttributes refer to ?
...
7
votes
1answer
94 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:
...
4
votes
1answer
64 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?
12
votes
1answer
127 views
Why doesn't data.stackexchange.com log in with Stack Overflow login?
http://data.stackexchange.com/users/10766/jon-doe10767
I logged in with the same Gmail account that I use to log into all my other Stack Overflow accounts and it didn't auto-populate the name. Nor is ...
2
votes
1answer
55 views
How do I get 'posthistory' of specific 'posts' from the Stackoverflow data dump?
I have downloaded the Stackoverflow data dump updated as of August 2012 [0]. I am particularly interested in the history of a particular post and therefore, I want to concentrate on posts.xml and ...
5
votes
0answers
81 views
How to calculate per site meta reputation?
The displayed reputation on per site meta (other than MSO) 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 ...
4
votes
1answer
116 views
Is there a way to see your full Comments history?
I want to find a question I commented on about two years ago. Is this possible?
