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
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 ...
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 ...
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 ...
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: ...
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-...
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, ...
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 ...

1
2 3 4 5
28