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
-12
votes
1answer
91 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
46 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
88 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
65 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) ...
5
votes
1answer
220 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
127 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 ...
8
votes
1answer
103 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
49 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
74 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
39 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
131 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
87 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
92 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
73 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
96 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
40 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
68 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
460 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 ...
15
votes
1answer
149 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 ...
6
votes
1answer
180 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, ...
2
votes
1answer
150 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 ...
10
votes
1answer
230 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 ...
2
votes
0answers
57 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 ...
2
votes
1answer
65 views

How do you join between Posts and Users in the Stack Overflow database?

I'm trying to join between stackoverflow.com's dataset Posts and Users files and I'm having trouble. I want to add the user profile of the question poster to a Post. Do I use User.AccountId or User....
14
votes
8answers
761 views

Is it harder to write a good question or a good answer?

I was wondering whether there's any evidence to be had as to whether it's harder to write good questions or good answers. For example, from the data available in SEDE or previous surveys. I suppose "...
3
votes
0answers
58 views

Downloaded csv does not contain the whole post body [closed]

I use the following query to download a post from stack exchange database. The query results show the exact body as the post. However, the CSV file downloaded from the page only contains the first ...
5
votes
0answers
127 views

Is anything done with the “Send Feedback” (anonymous user feedback) data? [duplicate]

What's done with the anonymous user feedback data? I get 10k-ers can view it; the data is now available for viewing in the Data Explorer But does this data serve any purpose for improving the site? ...
2
votes
1answer
53 views

Can't switch sites to Meta Stack Exchange when running SEDE query

I know that I can choose a query to run on Meta.SE, but when I'm looking at a query from another site, Meta.SE doesn't appear in the dropdown when I try to switch the site:
4
votes
1answer
62 views

Can I search for users GitHub or Twitter info in Data.SE?

I'm curious if I can find users in Data Explorer by their GitHub username or Twitter handle. I know I can find users from their Location (Location) or their Website link (WebsiteUrl). Is there a way ...
11
votes
1answer
146 views

Cross-site queries on SEDE fail with “The EXECUTE permission was denied”

I just noticed that any cross-site queries using dynamically generated SQL on the Stack Exchange Data Explorer (SEDE) now fail with the error message: The EXECUTE permission was denied on the ...
2
votes
1answer
76 views

Count city wise users from Stackoverflow Database

How do I get City wise users count from Stackoverflow Database? I found one Location field in Users table which may contains City, State, Country I wanted to get count all the City wise Users from ...
3
votes
2answers
69 views

Get user list of SO whose bio contains given words

I know that we can get data from the Stack Overflow database using a query. I wanted to get data about whose bios contain some given words. For example, If I put flutter, kotlin then I will get a ...
1
vote
1answer
33 views

How do I find all questions containing certain text and the user is from a certain country?

I am trying to build the following query: Find all questions containing certain text and the user is from a certain country. What I have done so far is: SELECT q.Id AS [Post Link], q....
4
votes
0answers
138 views

Can we get Stack Exchange voting data updates?

During some discussion, a very kind user linked me to this since I was combing trough SO(comp)/SE trying to familiarise myself with this website and data it provides. What I am interested in are ...
16
votes
1answer
165 views

Network-wide queries don't work on the SEDE

For example, a SELECT * FROM sysdatabases; results maybe some synchronization is running and it is only a temporary situation? Note, no network-wide query will work, if you make this permanent.
5
votes
2answers
74 views

Merge Comments on Data Explorer

I'm trying to get StackOverflow posts along with comments. However it returns each post with the individual comments as a separate record. Something like this - ID Post Comment1 ID Post Comment2 ID ...
-9
votes
1answer
123 views

Is it okay to use Data Explorer as a recruiting tool?

It occurred to me that the Data Explorer makes enough user information publicly available that it can be an effective recruiting tool. I.e. it is easy to get a list of users in a particular location, ...
5
votes
2answers
92 views

Query for no. of many questions I have answered which are closed later

Is there a query to know how many questions received answers before they are put on hold and I am one of the users who wrote an answer before the question is closed? If it looks confusing, let me ...
2
votes
0answers
33 views

Long site title messes up SEDE site list formatting [duplicate]

On the Stack Exchange Data Explorer homepage, if you scroll down a bit, you'll encounter a site with a very long title: Software Recommendations Meta Stack Exchange. A title this long messes up the ...
6
votes
2answers
74 views

Change taglines for non-English sites and new Meta sites on SEDE homepage

The homepage of the Stack Exchange Data Explorer has mixed-language taglines for non-English sites; e.g. for Russian Stack Overflow it is "Q&A for программистов". Can this be changed to something ...
4
votes
1answer
55 views

How can I find the number of communities for a user in the Stack Exchange data set?

Is there any way I can extract, from the Stack Exchange data set, the communities that a user joined? I want to use this data set to extract this feature for all users: https://archive.org/download/...
1
vote
0answers
20 views

What are the reasons that the `FavoriteCount` column in the `Posts` table has elements that are not available? [duplicate]

I was taking a look at this post which details the database schema for the Stack Exchange Data Explorer. I had one question about the Posts data set: what are the reasons that the FavoriteCount column ...
7
votes
1answer
154 views

Are there any site moderators with very low reputation?

Are there any moderators on SE that have very low reputation? I ask, since naturally, moderators are experienced users, who would have a decent amount of rep unless they have given away many bounties. ...
2
votes
1answer
83 views

How to query for the most popular job tags in Data Explorer

I'm just looking for a way to query the most popular tags in Stack Overflow Jobs, but I can't find anything related to it, I mean, a Jobs column or table or so. Is there a means to accomplish that ...
12
votes
1answer
142 views

When are closed sites removed from SEDE?

Augur Stack Exchange has been closed down four days ago, according to its Area 51 page. Yet, it's still visible in SEDE. I was wondering how long it would be kept; sites which have been closed for ...
2
votes
1answer
35 views

SEDE query for posts flagged as NAA

I am trying to figure out where in the database schema is stored the information about the kind of flag that has eventually been raised on a given answer. It seems spam/offensive flags should ...
9
votes
1answer
169 views

Why is there a clustering of answers at full (half) hours between answers?

I analyzed posting data from several SE communities and found that time gaps of almost precisely 30, 60, 90, and 120 minutes between consecutive answers are particular frequent. The figures show this ...

1 2 3 4 5 27