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
2
votes
1answer
77 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
101 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
115 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
927 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
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 ...
1
vote
3answers
132 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
57 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 ...
0
votes
1answer
138 views

How can I write a query for DATA.SE to combine and list results?

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 ...
15
votes
1answer
270 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&...
325
votes
2answers
70k 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 ...
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
69 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
85 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
98 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
61 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
242 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
129 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
68 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
96 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
65 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
791 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
65 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
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 ...
9
votes
1answer
226 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
508 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
100 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 ...
13
votes
1answer
198 views

SEDE footer still says “stack overflow internet services, inc”

The footer of most Stack Exchange sites was changed to show "stack exchange inc" as a result of https://meta.stackexchange.com/questions/82744/footer-is-wrong. However, the Data Explorer's footer has ...
3
votes
1answer
106 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 ...
14
votes
1answer
576 views

LIMITs on data.stackexchange.com?

SELECT Id, DisplayName FROM Users ORDER BY CreationDate DESC LIMIT 10; That query didn't work on data.stackexchange.com. I guess LIMIT isn't a key word. As such how would I go about doing a LIMIT?
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 ...
3
votes
1answer
48 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
97 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....
7
votes
1answer
148 views

How can I retrieve list of top 100 users on Stack Exchange for a specific tag sorted by posted content?

I am trying to replicate the top user page with users sorted by number of posts for a specific tag. Suppose there are two users for a tag. User 'A' with 5608 posts for a tag. And User 'B' with 2627 ...
12
votes
1answer
485 views

A site URL changed and now its icon in SEDE is broken

This has happened before, and it's happened again, all because Cognitive Sciences recently was renamed Psychology & Neuroscience, with a change to the URL. The first thing that needs to be fixed ...
8
votes
0answers
77 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 ...
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) [...

1
2 3 4 5
27