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,356
questions
6
votes
2answers
74 views
SEDE query to find out how many posts have been protected with spam on them
We are in the middle of an important discussion on our site about how we use the protection tool and we need some data for that discussion.
Specifically, how many posts have ever been protected on the ...
1
vote
0answers
49 views
Can I merge duplicate data.SX queries I've written? [duplicate]
I've written identically-titled SX data explorer queries, by mistake. Can I merge them (including merging their star count)? If not, can I make the system forget about one of them (i.e. delete one of ...
9
votes
0answers
58 views
Backslash before single quote breaks syntax highlighting (the quote is not escaped, but gets highlighted as if it is) in SEDE query
I was trying to write a query to find posts with <%break%> or <%%>, and realised that % works as a glob. Someone suggested using ESCAPE '\' to search for literal %, and that worked and the ...
0
votes
0answers
42 views
Accessing https://data.stackexchange.com/query APIs programmatically [duplicate]
All, We want to get the list of all deleted question Id's from StackOverflow (with additional tags and/or date filters, if possible). However we don't see an useful API for this here:
https://api....
4
votes
2answers
80 views
How can I query the Data Explorer for historical changes in posts' tags?
On my home site of RPG.SE, I'm trying to investigate whether a particular tag might be causing trouble. Specifically, I'm trying to find all the questions that had that tag in the first revision but ...
6
votes
0answers
37 views
Moving comments to chat seems to be missing in timeline and SEDE?
There are two possibilities how comments can be moved to chatroom. Either a moderator moves them or the users who discuss in comments are offered to continue in chat - and if they choose this option, ...
7
votes
1answer
96 views
How to find the current top questions by number of views? Or the quarterly number of views per question?
Stack Overflow provides the total number of pageviews per question - but it doesn't tell you if those views are historical or if the question is still current. How can I find the current top questions?...
18
votes
1answer
474 views
Data Explorer syntax or language reference?
Where can I find a syntax or language reference for the query language used on http://data.stackexchange.com/?
326
votes
2answers
71k views
Database schema documentation for the public data dump and SEDE
Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the Stack Exchange ...
7
votes
1answer
80 views
Is the count of anonymous feedback available in the schema?
I've been interested in what sort of questions are helpful to anonymous people rather than regulars. I would like to get a count of anonymous feedback "Helpful" and "Not Helpful" votes on a question.
...
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 ...
1
vote
2answers
192 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
...
2
votes
1answer
79 views
Recreate a query for the tags associated with a user based on time filter
I'm looking to recreate a SEDE query that represents the tags associated with a user based on a specific time filter. Consider, for example, the list of users sorted by reputation, filtered by week:
...
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 ...
1
vote
1answer
117 views
Find top User for a Country for a specific Month/Year
I've came across Finding Top Users by country regarding a query to know who is in the top X of a given country.
I would like to know how to improve this query and also know the top reputation earner ...
5
votes
3answers
951 views
Why can't I pull in all the SO users from Data Explorer?
It only returns 50,000 rows when I do the query below. I thought there are more than that.
select id,DisplayName from Users
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 ...
Shadow Wizard Wearing Mask
142k25 gold badges330 silver badges685 bronze badges
3
votes
1answer
61 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 ...
P.Mort. - forgot Clay Shirky_q
6,4044 gold badges30 silver badges53 bronze badges
1
vote
3answers
135 views
Data Explorer Cache
In Stack Exchange Data Explorer, I noticed that after a query is executed, it is stored in the cache (I think). How do I disable this feature?
For example, when I run this query, it should generate a ...
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 ...
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&...
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
71 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 ...
P.Mort. - forgot Clay Shirky_q
6,4044 gold badges30 silver badges53 bronze badges
1
vote
3answers
99 views
How do I modify this query to search for specific tags?
I am forking this query, which essentially outputs the time between the question being asked and the answer being given. However, I am trying to modify the query to only search for java. I tried this:
...
P.Mort. - forgot Clay Shirky_q
6,4044 gold badges30 silver badges53 bronze badges
27
votes
2answers
6k views
Is there any place to see a leaderboard of top “Helpful Flaggers”?
There are a few members of Stack Overflow especially who have a ridiculous number of helpful flags.
At the moment, there does not appear to be any way to display the top users with the most helpful ...
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-...
P.Mort. - forgot Clay Shirky_q
6,4044 gold badges30 silver badges53 bronze badges
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 ...
8
votes
2answers
243 views
What's the Codegolf_Temp database (and why does it mess up my query)?
Today, I was running some queries on SEDE and found out that this one fails to run because of the following error:
Invalid object name 'StackExchange.Codegolf_Temp.dbo.badges'.
Apparently, there's ...
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,
...
Tiago Martins Peres ę大ä»
1,1372 gold badges7 silver badges17 bronze badges
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 ...
9
votes
0answers
97 views
Can the Description for the CloseReasonTypes be added for the newer Close Reasons?
The table CloseReasonTypes in The Stack Exchange Data Explorer holds the id, name and description for the various close reasons.
When the close reasons got a major overhaul the new close reasons got ...
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?
9
votes
1answer
224 views
How often do questions get answered after they got closed?
As most of us know, there is a grace period for users who started to write an answer and the question got closed. This grace period is set to 4 hours server-side. In the web interface though sending ...
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 ...
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 = '%...
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 ...
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 ...
24
votes
2answers
795 views
Record for most consecutive days visited?
Is there a way to find out the actual number for the highest ever consecutive days visited?
I don't want to know who the user is that holds the record (I would hope that information would be kept ...
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)...
15
votes
1answer
187 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 ...
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 = ...
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 ...
