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
vote
1answer
54 views

Search question titles from all questions I have interacted with

This is basically a follow up to this popular thread, Can I search my comments using some keyword(s)?, with a similar reasoning behind it: I am sure I have seen an question already to a given problem ...
20
votes
1answer
109 views

Certificate Expired on SEDE

It looks like the SSL certificate for data.stackexchange.com just expired. If you were in the middle of running queries you would be greeted with: Something unexpected went wrong while running ...
3
votes
1answer
60 views

How can I view top contributors in a country by week?

I just want to view the top contributors based on the reputation points by this week in a given country. select row_number() over(order by reputation desc) , reputation , views , id as ...
4
votes
1answer
59 views

I'm getting an “Invalid object name 'StackExchange.Cstheory.Meta_Temp.dbo.posts'.” when executing a cross-site query in SEDE

Vanity causes me to visit this SEDE page from time to time to check out how hot I am. Today I felt like the evil queen in Cinderella because I received bad news: received both errors: Invalid object ...
1
vote
2answers
191 views

How can I write a query DATA.SE to list top users from all countries in the world?

I am trying to create a query, that lists TOP user(s) by reputation from all countries. I don't know where to start from. I have a query, which lists TOP user from a specific country: SELECT top 1 ...
6
votes
1answer
77 views

SEDE refresh seems to be stuck (again)

The weekly SEDE refresh doesn't seem to have completed successfully, just like two weeks ago; the Stack Overflow and Super User database are still a week old. If you look at the database timestamps, ...
7
votes
0answers
70 views

Why is the user who ended a bounty shown in SEDE differently from the timeline and the revision history?

Recently I looked at situations where the PostNotices table shows a different OwnerUserId and DeletionUserId. This was based on Glorfindel's advice, who suggested this as a way to find bounties which ...
8
votes
1answer
89 views

When a bounty is returned by moderator, is this shown in the revision history (timeline, SEDE)?

Moderators can refund the bounty to the users offering bounties. (However, this only happens in some rare situations.) If that happens, can we see this in the timeline and revision history? Is some ...
-6
votes
1answer
143 views

What post query does Stack Overflow fire to get a question's details with answers, tags, votes, etc.?

As I was reading to get a question or post below, a query may be fired by Stack Overflow: SELECT * # Replace the actual fields FROM posts WHERE (Id = {POST_ID}) OR (ParentId = {POST_ID}) ORDER BY ...
4
votes
0answers
40 views

SEDE bug: Anonymous users asked to solve captcha, but captcha not shown

To reproduce: Visit a SEDE query without being logged in Click "Run Query" "I'm not a robot" challenge is displayed and the message "Anonymous users must solve a captcha. Please complete the captcha ...
1
vote
0answers
40 views

No new data on https://data.stackexchange.com/ [duplicate]

I noticed that the newest data for some tags from Stack Overflow is a week old. An example is here: https://data.stackexchange.com/stackoverflow/revision/1232357/1515799/custom-questions-between-time-...
15
votes
1answer
272 views

SEDE appears to be partially-refreshed

I went to check some of my queries against UNIX & Linux this morning and noticed that the results all had dates older than a week. Going to rene's "did the SEDE refresh work?" query, I see that U&...
4
votes
1answer
62 views

A bug In Stack Exchange Data Query for How Unsung Am I

I was surfing through the How Unsung Am I data queries, because I felt I would receive that soon. But one of the famous query by Martijn Pieters showed that I had to go a long way to get that. But ...
3
votes
2answers
50 views

Is there a way to exclude from Stack Exchange Data Query posts that I have already viewed?

I want to become better at answering questions and making useful comments. My problem is that I've only been developing for a few years. I feel like I have the most to offer someone who has a low ...
5
votes
0answers
130 views

What are reasonable ways to check if activity on a site (or the whole network) has decreased?

I have encountered in various chatrooms discussions whether recently (for obvious reasons) there has been decrease of the activity on a specific site. (Or that some site has less visitors or less ...
1
vote
1answer
84 views

Results table in Query SO

When using SO trying to find the Top 200 users in Europe, SELECT TOP 200 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], Id AS [User Link], DisplayName, Reputation, WebsiteUrl, ...
3
votes
0answers
71 views

Is there a way to export the list of tags as plain text?

I want to export the list of tags as a plain text file. It's fine if I have to massage the data a bit, as long as I don't need to click through pages and pages of tags. Why? Because I use that input ...
2
votes
1answer
67 views

What does *description* in query refer to?

A nice guy @rene gave the answer to keywords search on SEDE might need improvement builder.Where(@" qs.Title LIKE @search OR qs.[Description] LIKE @search", new { search = '%...
4
votes
1answer
66 views

Is it possible to generate pie chart with SEDE built-in graph tool?

Sometime I would like to explore data in pie chart, for instance, top 10 users posts proportion. for that case line graph (https://data.stackexchange.com/ell/query/1206772/desc#graph) does not make ...
3
votes
0answers
60 views

Does SEDE has some built-in data visualization tools?

Exploring data visually might help users get a whole view quickly, does SEDE has some basic built-in data visualization tools?
2
votes
1answer
32 views

Limit of the size of result set

I am trying to get a list of users that made at least one post. By "an user made at least one post", I mean there is at least one post linked to this user, and there are 7k posts on ELL having a NULL ...
5
votes
1answer
65 views

keywords search on SEDE might need improvement

I wrote a query to list all posts for a given user by user id. SELECT id, PostTypeId, posts.Title, Body, CreationDate FROM posts WHERE posts.OwnerUserId = 9872 which could be found by search the ...
2
votes
1answer
31 views

Queries : find interesting unanswered questions - filter own interraction

I have started to use queries to find some interesting unanswered questions, most specifically this query : https://data.stackexchange.com/stackoverflow/query/4038/find-interesting-unanswered-...
3
votes
1answer
96 views

I wrote a query to word count a user, could someone please give some feedback?

Sometimes I would like use word count to describe someone's contribution, so, I wrote a query (https://data.stackexchange.com/ell/query/1206589/word-count-a-user) to do the job: DECLARE @total_count ...
3
votes
1answer
66 views

Data explorer query request: a plot of total views vs. reputation

There's a recent push to be more welcoming to beginners. This leads me to the question: Are people coming to Stack Exchange because of questions made by low-rep users? To get some data (not opinions)...
9
votes
1answer
228 views

What does “Mod” stand for in “UpMod”?

I've gone through relevant posts such as (Database schema documentation for the public data dump and SEDE) and (What do these votetypeids in the votetypes table mean?). I am also aware that in terms ...
-2
votes
1answer
115 views

How to use stackexchange query correctly?

I am trying to find one piece of comments by someone else on my post("that I continue to learn and grow", does this expression sound natural?), following another meta post. with userid = ...
15
votes
1answer
185 views

Unable to login into Stack Exchange Data Explorer

It might be related to the recent SEDE outage but I'm unable to login to SEDE via Stack Exchange Open ID. When clicking the 'Log in using Stack Exchange' button, I get an error message No OpenID ...
32
votes
1answer
512 views

SEDE is offline

Cannot access SEDE at all. Have checked with https://downforeveryoneorjustme.com/data.stackexchange.com which also says it's down.
-11
votes
1answer
106 views

How can I see which users advertise their willingness to offer bounties in their user profile, ranked by their reputation?

How can I politely request a bounty to be placed on my question? - Meta Stack Exchange Some users advertise their willingness to offer bounties in their user profile. Skim through that list and see ...
3
votes
1answer
49 views

Include answers along with questions in SEDE query

I want to modify the query below so that the answers to the questions are also included. The full code is here. I would also like to print/report the results in order, so question, answer1, answer2 ....
8
votes
1answer
98 views

Can the number of elections graph from the former Elections site be re-created?

There used to be an elections site that obviously showed how many elections took place each month over time. Image by Tim Stone But that site for reasons unknown to me no longer exists in that form....
88
votes
4answers
8k views

Planned Maintenance scheduled for Wednesday, February 5, 2020 for Data Explorer

Update: The maintenance went as planned. tl;dr; Planned service interruption that will impact Stack Exchange Data Explorer (SEDE). The site will be inaccessible for up to 12 hours on February 5, 2020 ...
6
votes
1answer
66 views

How do I list the SE sites that have a specified tag, sorted by the number of questions with that tag?

I whipped up a Chinese.SE meta post in which: Sites that have a [China] tag... Travel (tag; 718 Q's) History (tag; 281 Q's) Politics (tag; 201 Q's) Skeptics (tag; 74 Q's) Expatriates (tag; 54 Q's) [...
5
votes
1answer
234 views

Dump my Stack Exchange Favorites

I'm trying to morph this wonderful query to get all of one's posts so that it retrieves all the posts I have favorited. Full code here but here is the key piece I have modified, but does not work. ...
0
votes
2answers
128 views

SEDE help page still links to version 3.0 of Creative Commons license

Related to the post : SEDE footer still links to version 3.0 of Creative Commons license. In the Stack Exchange Data Explorer help page, currently the Creative Commons license is referred with ...
9
votes
1answer
107 views

What proportion of Peer-Pressure and Disciplined-badge-earning posts stay deleted?

As far as I know, one can earn the Peer Pressure and Disciplined badges by deleting and subsequently undeleting posts with the appropriate scores (-3 and +3, respectively). See: I cheated on the ...
4
votes
2answers
50 views

How to select the time of a Review Task Result in Data Explorer Stack Exchange?

I am trying to find those posts that were edited after a Leave Closed result of a Reopen Votes review queue. For that, I had written the following query in the Stack Exchange Data explorer: SELECT ...
3
votes
1answer
75 views

Get upvoted answers where question doesn’t have tag

I want to get all of my upvoted answers where the question doesn’t have a specific tag. What query can I write to get that data from SEDE? For example, I want to get all my upvoted answers to posts ...
0
votes
0answers
41 views

Is there any way to view an answer's score over time? [duplicate]

I'd like to see the time-graph of how many points an answer (or a question, I guess?) had. Can I get at that data (even in a raw form, to shove into Excel!)
8
votes
1answer
133 views

Get overall activity difference between two years

Recently the 'Moderation results' were published across all Stack Exchange sites. On my main site, Drupal Answers, I noticed a drastic fall in moderation actions, flagging etc. from the results that ...
2
votes
1answer
88 views

Query to get un-accepted answers, where OP has been active recently

I want to get a list of my own un-accepted answers, where the OP have been active during the last week. How can I write such a query on SEDE? Is it even possible to query a user's activity on a site?...
3
votes
1answer
93 views

Why do these two SEDE queries get different results?

I'm trying to aggregate some data for my site to give some context to Shog9's awesome moderation yearly statistics. So I wanted to write my own SEDE query to find out the number of (undeleted) ...
8
votes
0answers
78 views

Data Explorer fails to properly format lists of tags with Cyrillic characters

There is a minor issue with how Data Explorer handles tag output. Ordinarily it replaces every one of them with a decorated and clickable link. But it seems like whenever that list includes tags with ...
3
votes
1answer
108 views

How can I query users with a specific Job title?

I'm looking for a query which can be used to search a user by their title. I have tried looking into the Users table but the Job title/position column isn't present there. It's the one highlighted ...
3
votes
1answer
45 views

Is it possible to get a time series of reputation from the Data Explorer?

I would like to know the reputation score from a certain user on some specific moments in the past, is there the possibility of recovering this with the SQL language?
5
votes
1answer
64 views

Query to find top prolific questioners by tag

I would like to get the list of questioners who asked the most questions per tag. Can you please advise me how to write such a query? I do not care about the reputation of questioners, I care about ...
5
votes
1answer
45 views

How to select 'community wiki locked' questions?

I want to write a query which selects the highest scored community-wiki-lock questions (like this one). This is not typical comunity-wiki question like this - but comunity-wiki-lock (e.g. we see there ...
5
votes
1answer
72 views

How to select community wiki questions?

I want to write a query which selects the highest scored community-wiki questions (like this one) but I don't have an idea how to do it. This is what I have so far: https://data.stackexchange.com/...
29
votes
1answer
478 views

How many posts are downvoted without a comment?

A returning theme on our beautiful and productive Meta sites is the topic on downvoting without leaving a comment. Yes, that is a bit cheeky and admit it: you've done that as well. In a recent post ...

1
2 3 4 5
28