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
4
votes
0answers
478 views

Data Explorer returns “Captcha Shutdown” warning [duplicate]

I tried to execute this Data Explorer query and instead of the usual Captcha message I got the following: V1 shutdown on 2018-03-31 Direct site owners to g.co/recaptcha/upgrade Who needs to ...
3
votes
2answers
127 views

Get all interlinked questions

As an example, this question: http://stackoverflow.com/q/1371012/print-utf-8-from-c-console-application has linked questions here: http://stackoverflow.com/questions/linked/1371012 however some of ...
6
votes
0answers
56 views

Non-Latin tags are not parsed as tags in SEDE [duplicate]

For instance, in this SEDE request the cells in the tag column contain not parsed tags if at least one question's tag is not Latin only:
2
votes
1answer
79 views

There are PostHistory records for deleted posts, but only a very few

Checking for the PostHistory entries in the SEDE for deleted Posts, I get some results, but only a very few. For example, there is only 33 such records for the whole SO. All of them are from 2018. I ...
6
votes
2answers
66 views

Data Explorer site-switch search showing unrelated results first

I'm using Stack Exchange Data Explorer and trying to switch from Web Applications to Stack Overflow. I enter sta into "Switch sites" field, but search showing unrelated results first (3D Printing, ...
2
votes
1answer
34 views

View average number of answers per question in a particular time frame

What is the average number of answers per question? is a related question but not a duplicate since it asked for overall average of answers i.e. ever since the site was created. I am asking for ...
1
vote
0answers
32 views

Data Explorer: Shrink query window a little more

The "Query Window" textbox on data.stackexchange.com is already stretchable, but it would be helpful if the minimum height were set "even smaller". When testing quick edits to a query, it would be ...
4
votes
0answers
60 views

How do I get into my data.stackexchange.com account?

When I log into http://data.stackexchange.com/ with either open id or google or stack exchange, it takes me to some fake username jon-doe27508 That's not me: http://data.stackexchange.com/users/27507/...
5
votes
2answers
90 views

How to distinguish audits from real reviews in SEDE data?

I was trying to look at some statistics on review outcomes using SEDE, but hit upon a snag: apparently, the SEDE ReviewTasks table also includes audit tasks, and there doesn't seem to be any way to ...
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 ...
2
votes
1answer
33 views

Query to show the highest voted post in each tag

Is there a query that will list the highest voted post (question or answer) for each tag on a site?
0
votes
1answer
274 views

Tag prediction for Stack Overflow posts [duplicate]

I'm working on a small project where I have to create a model (nltk) that will predict the tags from questions that may be published on Stack Overflow. I used this link https://data.stackexchange.com/...
6
votes
1answer
89 views

How can I find the election number for a given moderator nomination in the Posts table?

In the Stack Exchange Data Explorer you can find the Moderator nominations by querying the Posts Table for posttypeid = 6, like so: select id as [Post Link] , score , owneruserid as [User ...
43
votes
1answer
8k views

reCaptcha v1 is shutting down on March 31, but SEDE still uses it

According to this post, I thought the new recaptcha API was used network-wide. Though today, when going to SEDE (which for whatever reasons never recognized me automatically), I got this message ...
5
votes
0answers
140 views

How to login normally to data.stackexchange.com

I used to log in to https://data.stackexchange.com by inputting my login/pass from Stack Overflow. But today, on the login page, I only see this: But I never created accounts on Yahoo, LiveJournal, ...
1
vote
1answer
71 views

Required: One SEDE wizard (for a possibly impossible query)

Disclaimer I don't know how to write SEDE queries, so I'm afraid I have to ask you to do it for me. I don't even know what is possible and what is not, so please forgive my ignorance. The possibly ...
3
votes
1answer
78 views

How can I view all of my answers that are quoted elsewhere in someone else's answer?

Recently I saw an answer from another user where they had quoted one of my answers within theirs. It felt nice. So that had me wondering, is there any way to see all my answers that are quoted ...
1
vote
0answers
56 views

SEDE Query to find posts I have cast delete vote on but aren't yet deleted?

Related to 10k "Most Delete Votes" List - Don't Show Questions I Can't Vote For, I'd like to be able to identify posts I've cast delete votes on, but which aren't yet deleted. My ...
2
votes
1answer
42 views

How to get the historical data in users Tab

We are working on preparing the monthly report for the most active contributor in SharePoint StackExchange . One of these statistics for the most editors and voters got it from the Users tab ...
5
votes
1answer
1k views

Is there any way to view comment flags in the Data Explorer?

Using the Data Explorer (SEDE), is there any way to view the flags on individual comments? After reading this post, it appears there is plenty of information in the tables FlagTypes, PendingFlags, ...
12
votes
1answer
208 views

Alias “Post Link” in data.stackexchange.com generate invalid links for “Meta sites” of pt.stackoverflow and es.stackoverflow

I create a query using [Post Link] and [Comment Link] and I noticed that the generated links are inverted for some sites, for example: This http://data.stackexchange.com/ptme/query/775699/bug-in-...
3
votes
1answer
87 views

How to get data (question details) of a specific Stack Exchange site?

I am working on a data science project for which I need data (questions and corresponding tags) of a specific Stack Exchange site, Academia SE for example. From this blog we know that SE data is ...
3
votes
1answer
73 views

Think! Hat SEDE query?

The Think! hat (2017 Winter Bash) is for 6 posts to be edited after leaving a comment. I figured I'd look up to see what posts these were, see if any of my comments were eligible for deletion (as no ...
1
vote
2answers
332 views

SEDE: Invalid column name

I'm trying a SEDE query to known the questions that has an accepted answer and with big difference of votes between the accepted answer as "best" answer. My try of query is: SELECT TOP 10 q....
-10
votes
1answer
63 views

How can SO query's result did not encrypt the id?

What's the reason StackExchange Data explorer website didnt encrypt the id of the query result ? I mean it's just give the result like postId=1 or postId=655011. Does it make the data in SO vulnerable ...
3
votes
1answer
69 views

Stack Exchange Data Explorer returns empty results

It's been a while since I last used the Data Explorer, although any query I try now comes up with nothing, for example: How many upvotes do I have for each tag? I'm trying to query data from ...
2
votes
1answer
2k views

Any way to auto-format SQL in Stack Exchange Data Explorer?

One really nice feature of Toad (database administration tool) is the ability to auto-format your SQL (usually with CTRL + SHIFT + F). Manually formatting SQL greatly increases readability, but takes ...
4
votes
2answers
2k views

“Execution Timeout Expired” for some popular queries on data.stackexchange.com

Some popular queries, like this one are returning: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Is it a temporary ...
4
votes
1answer
95 views

Is SEDE secure?

The Stack Exchange Data Explorer aka SEDE is not mentioned in Network-wide HTTPS: It's time. It is not listed in any of the steps, which makes sense as it's not officially part of Stack Exchange, ...
10
votes
0answers
33 views

Organize queries on Stack Exchange Data Explorer

On Data.SE, I tend to write a bunch of different queries, usually when something piques my interest and I want to look at a particular subset of the data. I currently have four pages of queries that ...
4
votes
2answers
76 views

I want to find the number of unique badges a selected user has

I want to find the number of unique badges a selected user has, i.e. 737 (https://stackoverflow.com/users/22656/jon-skeet). SELECT Users.Id AS [Id], Users.DisplayName AS [Display Name],  COUNT ...
4
votes
2answers
48 views

User that suggests the most edits for posts made by other users

I'm looking for a way to select the user that suggests the most edits for posts made by others. I'm unsure of how to specify that in my query. This is what I have so far: SELECT TOP 1 COUNT (*) ...
-11
votes
1answer
94 views

Percentage of deleted posts per site

I would like someone to post the ratio of deleted posts to total number of posts for each site, preferably computed over a recent time period such as the last three months. Could someone please do a ...
3
votes
1answer
104 views

How does a post end up in the review queue?

I've read about Review Tasks here and examined the tables here. My questions are: What kinds of posts get to the review table? (E.g., questions, answers,..) What is the qualifying factor? Who/what ...
4
votes
0answers
42 views

How can I easily access the markdown text of a comment? [duplicate]

So the query in the answer to the question this has been closed against has exactly the same problem as the query I mentioned in my question - I can't actually see more than the first few words of the ...
3
votes
1answer
68 views

Why does Posts.FavoriteCount column have both Null & 0 values in SEDE?

I found that FavoriteCount column in Posts table in SEDE contains both NULL and 0 values for "questions" (PostType = 1). Why some questions have Null instead of zero?
5
votes
1answer
97 views

How can I see who has the most of a certain badge?

On a site, I've gotten 4 of a certain gold badge now and that made me curious to see who has the most, or maybe a list of users ordered by the number of times they've earned that badge. I'm not ...
2
votes
0answers
28 views

SE Data Explorer always logs me out [duplicate]

I am using Google Login for SEDE. After a day or so, I always find myself logged out, even though I did not delete my cookies etc. I am using Safari 11.0 on macOS 10.13. Is there a setting for ...
5
votes
1answer
59 views

Which SE site has the most questions associate with a given [tag]?

Is it possible to do a list of SE sites sorted by the highest appearance of questions with a given tag? for example [markdown]? Something like: StackOverflow 3970 questions ... TeX 119 questions I ...
2
votes
1answer
74 views

May I ask for the tag information of the deleted posts in the SEDE?

In the current SEDE, the PostTags table contains information only from the currently existing questions (i.e. from the questions in the Posts table, but not from the ones in the PostsWithDeleted table)...
6
votes
1answer
188 views

Choosing best resource for crawling data from Stack Exchange sites

For the purpose of an academic research project, I would like to obtain detailed data on questions, answers, tags, users, etc. That is, I seek historical data, as detailed as possible. I have seen ...
4
votes
3answers
135 views

How to retrieve exact reputation on “legendary day”?

Some weeks ago I asked about the most legendary users on the network. Now that my name shows up in that list as well (or will show up when the SEDE data is updated) - a comment of another user ...
5
votes
2answers
109 views

My user id doesn't work in a query

This is my profile link: https://data.stackexchange.com/users/26755/taz My understanding is my user id is 26755. But when I run this query: select * from users where id=26755 (at https://data....
2
votes
1answer
81 views

Any way to find the ID of a deleted post author?

Is there any way to query the user id of a deleted post author on a Stack Exchange site? I tried to query the table postswithdeleted from https://data.stackexchange.com/stackoverflow/queries. But the ...
2
votes
0answers
39 views

How to get “people reached” info from Users Table? [duplicate]

How can I get "people reached" data from the Users table for Stack Overflow? I didn't find any fields related to the people reached state in the Users table/schema. Is it possible to get that data ...
2
votes
1answer
66 views

How does ID as [user link] work as a hyperlink while running a query in the Stack Exchange Data Explorer?

In the below script, how does ID AS [USER LINK] work like a hyperlink? I am curious to know about it. Is it a Stack Overflow feature? I ran this script on Stack Exchange Data Explorer. Here is ...
8
votes
0answers
72 views

Fix http://data.stackexchange.com to https://data.stackexchange.com with Community♦ for correct session handling

If I click on an HTTPS link to https://data.stackexchange.com, I will be identified: But if I click on an HTTP link to http://data.stackexchange.com, I will not be identified: This HTTP issue ...
-11
votes
1answer
66 views

Arithmetic exception when running a query on SEDE

We are not able to run a query like the following in SEDE: select avg(viewCount) from Posts It is giving us an arithmetic exception which should ideally not be the case. All we need to do is change ...
14
votes
1answer
123 views

Why do Data Explorer queries sometimes load *and* run, and other times just load?

I haven't gathered enough data on this to figure it out, so maybe it's Yet Another Feature I'm Still Learning About Stack Exchange. I have several queries in SEDE; my typical SEDE usage is: load the ...
2
votes
0answers
62 views

Please make the “favorites” tab sortable in the SEDE

Ext: of course the best would be if it would be so nicely sortable/searchable like the questions on the ordinary sites. Currently the only way to remark "my" queries is to favorize them. However, as ...

1
3 4
5
6 7
28