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

Query for maximum number of comments by a user on a post

Does a query exist in the Data Explorer which lets you know the maximum number of comments by a user on a question? I've not been able to find one; the closest query I was able to find was Number of ...
6
votes
1answer
63 views

Is there a query that returns answers one vote away from the Pizza hat?

I want to identify answers that are just one vote away from the Pizza Hat (was Extra Toppings last year). Searching for "pizza" or "toppings" on SEDE did not reveal a suitable query. How to query for ...
7
votes
0answers
103 views

Why is BountyAmount for votetypeid = 8 empty in the votes table of MathOverflow

While helping out on a SEDE query here I was looking at the votes table in the MathOveflow database, specially the records for votetypeid = 8. I noticed that the bountyamount isn't present in these ...
8
votes
1answer
85 views

See which posts had their CW status removed

According to this thread, Can a user revert Community Wiki on a post?, diamond moderators can remove the community wiki status from a post. Is there any way to know from which posts community wiki ...
3
votes
0answers
65 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
1answer
81 views

Is it possible to delete SEDE queries from our account history? [duplicate]

As the title says. There's a history of all our queries and it would be good to be able to delete the lousy queries and keep the useful ones. Is there a way to do this?
3
votes
1answer
67 views

How to collect history of deleted posts?

When a question migrates, answers are deleted and the question left as a stub. For example, a question is migrated from site superuser (post id: 82342) to stack overflow (post id: 1894170). I can ...
3
votes
1answer
69 views

How can I see if my question is still active?

Years and years ago, I posted a very awkward question on Stack Overflow. Now I checked it again and I discovered it got around 7k views and the answers to that question have got a discrete number of ...
4
votes
0answers
33 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?
34
votes
2answers
6k views

Which tools and technologies are used to build Data Explorer?

Which technologies you are using for building Data Explorer? This is interesting if it gets open sourced at some point in future. Do you use same stuff as with SO? C#, ASP.NET, MVC?
6
votes
2answers
532 views

Tag synonyms and data dump

Now that the tag synonyms are implemented, how does it affect the monthly data dump? Should the data dump have the list of tag synonyms?
3
votes
1answer
128 views

Export result of data Stack Exchange query to Excel

What is my Archaeologist badge progress? The link above is to a query to calculate Archaeologist badge progress. Can I export the results of my query to Excel format?
4
votes
1answer
93 views

Downloaded results from data.SE cause errors in Excel

I suspect that this has more to do with Excel than it has to do with SE code, but I thought it might be good to bring it up anyway. When I open the file provided by data.StackExcange.com, I get the ...
-7
votes
1answer
122 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.
3
votes
1answer
77 views

What are the advantages of exploring SE data via Google BigQuery over the T-SQL data explorer?

I have seen that it's possible to explore Stack Exchange data via Google BigQuery as well as via the Data Explorer. What are the benefits of this? As far as I see, the data explorer is T-SQL, which ...
5
votes
1answer
72 views

Can I query history of my SEDE queries?

Is there a way to query my SEDE saved queries or query history? I could scrape the list from https://data.stackexchange.com/users/{SEDE User#}/?order_by=recent&page={PAGE#} (in my case, 350 pages/...
4
votes
1answer
69 views

How can I find people who have asked a large number of high quality unanswered questions on UXSE?

I am looking to try and reduce the number of unanswered questions on the UXSE site by identifying high quality questions that hasn't been addressed probably because it is either difficult to answer or ...
29
votes
3answers
421 views

Please provide a Moderators table in the Data Explorer

Moderators are special, privileged users who should serve as an example to the rest of us. Therefore, it is natural to want to query behaviors and statistics about these model users, Like I did, for ...
10
votes
1answer
81 views

SEDE magic columns (and site://) do not use HTTPS

Post links generated via the SEDE magic columns (e.g. [Post Link], [Comment Link], etc.) as well as site:// provide HTTP links, but should provide HTTPS links instead. Example query: select (...
4
votes
1answer
95 views

Is SEDE secure?

The Stack Exchange Data Explorer aka SEDE is not mentioned in Network-wide HTTPS: It's time. It is not listed in any of the steps, which makes sense as it's not officially part of Stack Exchange, ...
3
votes
1answer
68 views

Data explorer update seems to have failed

I noticed the data Explorer update for September 30 at 3:00 UTC seems to have failed. Looking at the Data Explorer main page it shows the last update was yesterday however the following query shows ...
5
votes
2answers
109 views

My user id doesn't work in a query

This is my profile link: https://data.stackexchange.com/users/26755/taz My understanding is my user id is 26755. But when I run this query: select * from users where id=26755 (at https://data....
4
votes
1answer
47 views

Why is there some data unaccessible from the Data Explorer?

I was wondering why I didn't get the Unsung Hero badge when I theoretically should have it on Stack Overflow. The How Unsung am I? requests shows only 10 unscored answers, the real count is 11 but ...
2
votes
1answer
35 views

Unanswered questions by tag without my answer

How can I get unanswered (unaccepted) questions by tag that are not answered by me on Stack Overflow? I want to answer users who did not get a satisfying answer. But every time I open the unanswered ...
5
votes
1answer
36 views

Can I get Correct SE attribution from Data Explorer

I'd like to get titles (only) from various SE sites for my writer's prompts website. I cannot see how to use SE Data Explorer queries to get the required information. From the Attribution page I see ...
44
votes
3answers
501 views

Allow cross-site queries in data explorer

I think it would be useful if we could join across databases in the data-explorer. For example, I'd like to query up a list of questions that I had a hand in migrating away from SO, and see what ...
3
votes
1answer
104 views

How does a post end up in the review queue?

I've read about Review Tasks here and examined the tables here. My questions are: What kinds of posts get to the review table? (E.g., questions, answers,..) What is the qualifying factor? Who/what ...
5
votes
1answer
114 views

Top viewed questions by tag within a timeframe

How can I use the data explorer to fetch the top viewed questions within a certain tag within some time frame on Stack Overflow? For example, the top viewed questions tagged [Android] in the last 6 ...
14
votes
1answer
123 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 ...
4
votes
1answer
80 views

Why does this simple Data Explorer query only return 124 rows instead of 4,912?

Why does this query only return 124 rows when https://stackoverflow.com/users/470749/ryan?tab=votes&sort=all says "4,912 Votes Cast"? SELECT v.id, v.VoteTypeId, v.CreationDate FROM Votes v WHERE ...
2
votes
2answers
143 views

Why is Data Explorer not accurate? [duplicate]

Possible Duplicate: Data from the Stack Exchange Data Explorer are obsolete I'm just now exploring Data Explorer (for Stack Overflow) and I wrote a simple query to see how many questions I ...
3
votes
0answers
90 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
69 views

Can I find the length of a post post-rendering? [duplicate]

I can find the length of the post's HTML-converted source (len(Posts.body)) in data.SE. Is there a way — short of copy/pasting from actual SE page — to find out the textual length of the ...
3
votes
0answers
61 views

Top voted questions not voted by me

How can I get top voted questions by tag, that are not voted by me (down/up). Can you help me with a SEDE query, or easier solution? Edit If above query is not possible, Can it be possible To ...
6
votes
1answer
97 views

Does Stack Exchange track the edit history of a user's `Location` field?

If I want to compare how many posts per location are asked by users over a period of N years, I would want to know how many users have changed locations during the period that I want to query. Is ...
6
votes
1answer
293 views

Data Explorer query to get my post with specific tag

I would like to select all my posts with a specific tag with Data Explorer. Some posts may have multiple tags. If my specific tag is say powerbi I would like to select also all the posts that have ...
42
votes
1answer
1k views

When will data.SE get updated data?

Zypher promised that data.SE would "soon" get live data: http://meta.serverfault.com/questions/3551/how-to-count-the-number-of-times-i-earned-200-daily-reputation/3552#comment6746_3552 http://chat....
3
votes
0answers
41 views

How to query the Data Explorer for reviewer stats

I've been trying to figure out if it's possible to query the Data Explorer to give me data similar to what you get when you hover over people's names: I thought it may be similar to the ...
2
votes
1answer
42 views

Treat “Enter Query Title” and “Enter Query Description” same as missing in Titles and Tooltips when Browsing Queries

Especially now that you have a default description filled in when a new query is created, when these have not been updated, you have no idea what they're doing until you follow the link. The feature ...
6
votes
0answers
54 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 ...
4
votes
2answers
210 views

Total reputation (sum of all reputations) of all Stack Overflow users?

I wanted to know if it is possible to get the total reputation of all Stack Overflow users - i.e. the sum of ALL reputation scores of ALL Stack Overflow users. I am aware that this would be a large ...
5
votes
1answer
1k views

Is there any way to view comment flags in the Data Explorer?

Using the Data Explorer (SEDE), is there any way to view the flags on individual comments? After reading this post, it appears there is plenty of information in the tables FlagTypes, PendingFlags, ...
12
votes
1answer
204 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 ...
-11
votes
3answers
390 views

Could network-wide suspensions last longer than 10 years? [duplicate]

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 ...
3
votes
1answer
80 views

How to find all users that work in same company as mine?

I would like to find all users that have a login to Stack Overflow and that work in my company. To do that, I have seen that I can create a custom query on http://data.stackexchange.com/stackoverflow/...
4
votes
1answer
73 views

Are Data Explorer full-text column indexes planned?

Is it a possibility that full-text indexes will be eventually added to certain columns in the Data Explorer? I perfectly understand that SO servers are under a heavy load, and this would add ...
8
votes
1answer
73 views

What's causing this error in SEDE?

In the Stack Exchange Data Explorer, how come: select sum(len(body)) from posts works fine, but, select sum(len(text)) from comments throws an error? Arithmetic overflow error converting ...
1
vote
1answer
134 views

How can I find the number of total questions and unanswered questions, for each month, for the 10 most popular tags on Cross Validated

I'd like to write a query in the Stack Exchange Data Explorer for the Cross Validated site, which returns me the Question and Answers on Cross Validated by month and by tag, for the 10 tags which ...
2
votes
1answer
109 views

Are all tables available in SEDE available in Google BigQuery's Stack Overflow dataset?

Specifically, I'm looking for tables like CloseReasonTypes and PostHistoryTypeId. Is there a schema somewhere? I only see a few tables in the Google BigQuery UI: Do I need to use the Data Explorer ...
5
votes
0answers
38 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 ...

1
3 4
5
6 7
28