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.
1,541
questions
7
votes
0
answers
81
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 ...
- 15k
9
votes
1
answer
101
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 ...
- 15k
-6
votes
1
answer
239
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 ...
- 143
4
votes
0
answers
48
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 ...
- 9,658
1
vote
0
answers
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-...
- 111
15
votes
1
answer
329
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&...
- 2,063
4
votes
1
answer
67
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 ...
- 327
3
votes
2
answers
54
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 ...
- 31
5
votes
0
answers
135
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 ...
- 15k
1
vote
1
answer
88
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,
...
- 2,187
8
votes
1
answer
185
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 ...
- 485
2
votes
1
answer
70
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 = '%...
- 391
4
votes
1
answer
71
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 ...
- 391
3
votes
0
answers
62
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?
- 391
2
votes
1
answer
67
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 ...
- 391
5
votes
1
answer
76
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 ...
- 391
2
votes
1
answer
32
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-...
- 121
3
votes
1
answer
97
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 ...
- 391
3
votes
1
answer
73
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)...
- 21.6k
9
votes
1
answer
265
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 ...
- 745
-2
votes
1
answer
136
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 = ...
- 745
15
votes
1
answer
205
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 ...
GlorfindelMod
- 247k
33
votes
1
answer
557
views
SEDE is offline
Cannot access SEDE at all.
Have checked with https://downforeveryoneorjustme.com/data.stackexchange.com which also says it's down.
- 33k
-12
votes
1
answer
113
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 ...
user226001
3
votes
1
answer
59
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 ....
- 185
8
votes
1
answer
104
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....
- 85.8k
87
votes
4
answers
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 ...
- 51.4k
8
votes
1
answer
71
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)
[...
- 21.6k
5
votes
1
answer
251
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.
...
- 185
0
votes
2
answers
137
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 ...
- 37.8k
11
votes
1
answer
121
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 ...
- 21.6k
4
votes
2
answers
58
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
...
- 187
3
votes
1
answer
83
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 ...
user569408
0
votes
0
answers
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!)
- 484
8
votes
1
answer
147
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 ...
user569408
2
votes
1
answer
89
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?...
user569408
3
votes
1
answer
102
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) ...
- 6,636
11
votes
0
answers
116
views
Data Explorer fails to properly format lists of tags with Cyrillic characters [duplicate]
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 ...
- 211
5
votes
1
answer
180
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 ...
- 169
3
votes
1
answer
53
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?
- 133
5
votes
1
answer
75
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 ...
- 245
6
votes
1
answer
55
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
1
answer
81
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
1
answer
557
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 ...
- 85.8k
17
votes
1
answer
420
views
Is there a way to systematically find duplicate or similar posts on Stack Overflow?
I am planning to do some analysis on duplicated or similar question posts from Stack Overflow. Therefore, I need to collect the posts (regardless of question or answer) as the ground truth data, which ...
- 317
6
votes
1
answer
192
views
Is it possible to create a Data Explorer query that returns questions from users who have more answers than questions?
I've found a query that returns questions from users with a certain minimum reputation:
select top 20 p.id as [Post Link], p.score, p.viewcount, p.answercount, p.tags,
u.reputation
from posts p, ...
- 1,761
2
votes
1
answer
152
views
Number of queries in SEDE overflows
The total number of queries on SEDE (shown on the query list page) overflows sometimes, depending on the actual number:
I think it's still readable if the font size is reduced by a few points, or ...
GlorfindelMod
- 247k
11
votes
1
answer
249
views
SEDE footer still links to version 3.0 of Creative Commons license
According to Stack Exchange and Stack Overflow have moved to CC BY-SA 4.0, subscriber content is now licensed under version 4.0 of the Creative Commons license. The change is reflected in the footer ...
GlorfindelMod
- 247k
12
votes
0
answers
111
views
How much are tag warnings used?
Although I'm reasonably experienced on Stack Exchange (8+ years of activity, 40 sites with 500+ reputation, 247k total rep) and have been a diamond moderator on one site for some 5 years, today I saw ...
- 9,260
2
votes
0
answers
66
views
Is "helpful flag" data accessible via SEDE? [duplicate]
I'm looking to find the top flaggers on a given site, and am trying to do so in SEDE.
I was inclined to write up a SEDE query, but, to my amateur eye, there doesn't seem to be any table that lists ...
- 6,636