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

Prevent setting birthday to something less than 13 years old in SEDE

From the legal section: Subscriber certifies to Stack Exchange that Subscriber is an individual (i.e., not a corporate entity) at least 13 years of age. In your Stack Exchange Network's profile, ...
-1
votes
1answer
86 views

Can't find myself in the query database

I was trying to find a question that I'd commented on on math.stackexchange.com (This should be MUCH easier than it is!!). I found the query frontend at http://data.stackexchange.com/stackoverflow/...
-1
votes
2answers
32 views

Why can't I see the data query account in the accounts section? [duplicate]

When I go to my accounts page I can't find the Data Explorer account. What makes this site more special than the others? Why doesn't it appear in the list of accounts?
-1
votes
1answer
94 views

Count of all total edited entries

I just checked with this query with user ID 494543 how many edits I made, but it is not showing any result. On the other hand I have edited more than 30 questions. What am I missing here?
-1
votes
2answers
68 views

SEDE official host name? And OpenId not seen as the same from second hostname

I noticed another hostname for SEDE here. Is this the official site? I logged in and my OpenId was associated with a new user. Surely it should see my existing OpenId as the same user irrespective of ...
-1
votes
2answers
136 views

when is odata.stackexchange updated?

odata.stackexchange.com is damn funny. But when are cached(?) query results like this Q get updated?
-1
votes
1answer
35 views

How to get refined data of a Stack Exchange website

I have used the following SQL query on Academia Stack Exchange: SELECT * FROM Posts This query generated 50,000 rows ... but the total number of questions on the website is approximately 28,000. ...
-1
votes
1answer
46 views

Queries on data.stackexchange.com return empty fields

Many queries that I wrote or not, return blank fields, but not always. To reproduce the problem try to execute this request : http://data.stackexchange.com/stackoverflow/query/90306/compare-size-and-...
-1
votes
0answers
4 views

How to combine multiple rows in dplyr randomly

I have a data set that looks like this: Id Type Tag 1 a blue 1 a green 1 b yellow 1 b red 2 a black 2 a grey 2 b purple 2 b cyan 3 a orange 3 a yellow 3 b ...
-2
votes
1answer
86 views

Query returns wrong result [duplicate]

Possible Duplicate: Why are my SEDE results inaccurate/obsolete/incorrect/outdated? I've run the following query, just to see if it actually works, but I'm getting no results even though I have ...
-2
votes
1answer
180 views

Can we add vote history to the data.se dumps?

EDIT AGAIN For everyone downvoting this request - how is this different from the data already publicly available from the new /users/<id>/<name>?tab=reputation page? At least leave an ...
-2
votes
1answer
66 views

User details are not correct in the Stack Overflow DB table User

I just tried to write a simple select query to get user details. And the result is not correct. For SO it displays the reputation count less than what it is now. And the last access date is 2015-02-...
-2
votes
1answer
450 views

Unsung Hero query on Data Explorer [closed]

Can someone make a query on Stack Exchange Data Explorer for users to track their progress on Unsung Hero badge? I mean, in some queries, I saw some input box for users to input custom data for ...
-2
votes
1answer
49 views

Is database in data.stackexchange 4 days behind? [duplicate]

I wrote a simple query to get latest posts SELECT TOP 10 * FROM Posts ORDER BY CreationDate DESC and the result it returns are dated 2015-07-12 (today is 2015-07-16). Is the data 4 days behind?
-2
votes
2answers
125 views

Data Explorer queries most likely to find dormant users that if engaged are likely to become active users

Currently my thought is the profile of such a user would be that they: have not visited the site in a month and posted a answer/comment/question have an answer/comment/question on the site have been ...
-3
votes
1answer
59 views

Ability to query who is following a specified tag in Stack Exchange Data Explorer

It would be great if we can query who all are following a particular tag. So something like this should be the query. Select * from Users u inner join TagUserMap tum on u.Id = tum.UserId where tum....
-3
votes
4answers
152 views

www.odata.stackexchange.com does not exist?

I've recently found out that www.odata.stackexchange.com does not work while odata.stackexchange.com does. Now I know the www prefix isn't liked, but it should exist, and simply redirect to odata....
-3
votes
1answer
85 views

What is the meaning of posts.communityowned date? [duplicate]

There is a field in the posts table named communityowneddate. What is the meaning of that field? And in what case is the post owned by community?
-3
votes
1answer
52 views

What language are SE Data Explorer queries written in? [duplicate]

I want to write a query for the Stack Exchange Data Explorer, but I'm not sure which language I need to learn in order to do so. At a glance it looks a bit like SQL, but I'm not entirely sure. What ...
-3
votes
1answer
94 views

Vote timestamps have 00:00:00 time [duplicate]

On data explorer, why do votes have the time part of their creationDate (a DATETIME datatype, that is a date and a time) all set to midnight? This query shows that this has been the case for some ...
-4
votes
2answers
131 views

Query returns wrong information about me [duplicate]

Possible Duplicate: Data from the Stack Exchange Data Explorer are obsolete I'm not getting the expected results when running queries with my userId. Tried to debug what is happening and created ...
-4
votes
2answers
87 views

Search query based on author reputation

I want to list all the posts(questions or answers) posted based on the author reputation. Example list all posts posted by the users having reputation more than 50 and less then 100. Because these ...
-4
votes
2answers
927 views

Allow some basic HTML formating inside query results or interpret MarkDown

I wrote this query and Markdown inside third column wasn't converted to HTML. So I converted the closes reasons to HTML and it appears that the Javascript doesn't make the rows look parsed. As there ...
-4
votes
1answer
84 views

What is the fastest and average time to attain each badge?

These seem to be interesting questions to understand in general how much effort is expended to attain a badge. Effort is the wrong word, some badges are gained through fortune or uncontrollable chaos....
-4
votes
2answers
403 views

Badge Statistics and maximum number of badges on Stack Overflow

We can see statistics about reputation at http://stackexchange.com/leagues/1/alltime/stackoverflow. How can I find who had maximum number of badges on Stack Overflow ? It would be nice to see ...
-5
votes
2answers
814 views

Please STOP requiring Google profile info, and switch to the other endpoint!

I know this change already took place some months ago, but I wanted to write about this now. Here's the situation: When I click on I login on my Gmail account and get :And I don’t have a public ...
-5
votes
1answer
103 views

SEDE query to find users' reputation when posting their questions

Each question has an Id, OwnerUserId, and CreationDate. I need to calculate the reputation of that user (questioner) was during the question creation time. I find the question (Determining user's ...
-6
votes
1answer
69 views

Enable extended database information if data is private to executing user

Right now, the UserId for Votes is only available if the vote is a favorite. It would be nice if users logged in could have UserId for all types of votes that they themselves cast, so queries for ...
-7
votes
1answer
101 views

What exactly is data.stackexchange.com? [duplicate]

What exactly is data.stackexchange.com? I cannot understand, regardless of how much I read about it. It would be helpful if someone explained.
-8
votes
6answers
320 views

Include user's “Interesting” and “Ignored” tags in the data dump

I added a feature-request earlier that revolves around my use of tagging to draw .NET developers to questions that are language-agnostic (as far as C# and VB.NET are concerned). The request is based ...
-9
votes
1answer
49 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 ...
-9
votes
1answer
71 views

When is the best time to ask questions (v2)? [duplicate]

This question just serves as an updated version of this 2009 question that hasn't been updated in 8 years. As such, I've copied the text of that question and used it here. What's the best time of day,...
-9
votes
1answer
124 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 ...
-10
votes
1answer
60 views

How can SO query's result did not encrypt the id?

What's the reason StackExchange Data explorer website didnt encrypt the id of the query result ? I mean it's just give the result like postId=1 or postId=655011. Does it make the data in SO vulnerable ...
-11
votes
3answers
336 views

Could network-wide suspensions last longer than 10 years?

The dupe candidate deals about suspensions in general, the essential part of this question is the increase of the network-wide suspension length from 10 years to 30. The answer to the question has ...
-11
votes
1answer
92 views

Percentage of deleted posts per site

I would like someone to post the ratio of deleted posts to total number of posts for each site, preferably computed over a recent time period such as the last three months. Could someone please do a ...
-11
votes
1answer
65 views

Arithmetic exception when running a query on SEDE

We are not able to run a query like the following in SEDE: select avg(viewCount) from Posts It is giving us an arithmetic exception which should ideally not be the case. All we need to do is change ...
-12
votes
2answers
305 views

What's the average time required to write a question or an answer on Stack Exchange? [closed]

I do need to estimate how much time do people spend on Stack Exchange sites on creative activities, like adding questions or answers, maybe even comments. Probably there is a big correlation between ...
-12
votes
1answer
99 views

How to access user last connection IP address on profile

I'm doing some work on the network analysis of a Stack Exchange community. I need the location of its users, but as you know, not everyone fills in the Location field. I find the [Data.StackExchange]....
-12
votes
1answer
125 views

Find top Stack Overflow users by their technology stack and location [duplicate]

How to find top Stack Overflow users by their technology stack and location?
-14
votes
1answer
128 views

How to get votes cast by a user

I want to query the upvotes and downvotes that have been cast by a person. Is there an API call for that? (I don't see one on the API docs.) If there isn't a call for that, could this be achieved ...
-16
votes
1answer
192 views

Where is the Markdown used in the About Me section of profiles stored?

After examining the SEDE documentation, poking around with a few queries, and reading How do you cross the 3k character limit for About Me?, I learned that the Markdown for questions and answers are ...
-18
votes
2answers
107 views

Do we want a data.meta.stackexchange.com?

Unfortunately, the data SE doesn't have any meta site. It could be a very useful feature, people could share their tips and experiences about the site.
-19
votes
2answers
146 views

Request for linked voting in data dump

I am interested in analyzing directed voting behavior of users in relation to their reputation on stackoverflow. Since voting is an anonymous activity for obvious reasons, I was hoping that I could ...
-23
votes
1answer
211 views

Badge request for heavy downvoters: punisher [duplicate]

I wonder if there is such a query on stack exchange data explorer queries, similar to this one on user base who cast the most downvotes.