All Questions
Tagged with data-explorer tags
68
questions
3
votes
1
answer
54
views
How can I search for tags with that include a specified string in their Usage Guidance?
I would like to search for all tags (on Stack Overflow) that include some specific string in the Usage Guidance portion of their Tag Wiki. How can I do that?
Specifically I would like to search for ...
-1
votes
1
answer
120
views
Data explorer query takes a lot of time and needs to be optimized
This is a Stack Exchange Data Explorer query which gets the top users on specific skill scores (example: JavaScript) based on a specific country (example: Egypt), and it took a lot of time until it ...
14
votes
1
answer
271
views
Tags column of Posts table changed delimiter format. Many historical queries broken. Special tag rendering also broken
To the best of my memory, and in reading my past queries- some of which I re-run on a regular basis- the format of the Tags column of the Posts table in SEDE used to be like <starball><is>&...
4
votes
1
answer
153
views
How do I get the highest posters for a certain tag in a specific country?
I would like to get the user IDs, user names, the number of posts, and the total score for a certain tag for each user in a specific country (sorted in descending order by score).
For example, in the ...
2
votes
2
answers
93
views
How can I get the total number of posts for a user that have a certain tag in them?
User abbood (myself) has eight posts (in total) that have the tag cocoapods; six questions and two answers.
I thought that this query should simply get all eight:
SELECT Count(*)
FROM posts p
...
6
votes
0
answers
107
views
What's the Data Explorer query to get the latest data that Stack Overflow Trends shows?
Stack Overflow Trends shows the percentage of questions with a certain tag. Here's an example for Java IDEs. On Jan 7, 2023, this link produces this graph:
So VS Code is at 0.8%, and IntelliJ is ...
7
votes
1
answer
97
views
The magic column [tagname] should handle number columns results gracefully
The magic column [tagname] will decorate and auto link tag names when used in a query. This feature relies on the JavaScript processing in the browser. The client-side script assumes it will always ...
9
votes
1
answer
150
views
Is there a way (e.g. with SEDE) to find questions with an existing tag that's been synonymized (but not merged) into another tag?
Say Tag 1 has been added as a synonym of Tag 2, so that new questions attempting to use Tag 1 will be automatically pointed to Tag 2. However, the two tags haven't been merged (yet). Then, if you ...
3
votes
1
answer
89
views
Why can I not filter the Posts table in data.stackexchange by tags?
While trying to write a query on https://data.stackexchange.com/datascience/, using the Posts table, I cannot filter by tags.
For instance, if I try to extract the tags from the Posts table:
select ...
7
votes
2
answers
253
views
Query for getting top users on a specific tag by country sorted by tag score (Stack Overflow)
I need a query for getting top users on a specific tag by country sorted by tag score on the Stack Overflow site.
For example.
Top users of JavaScript that live in the United States and sorted by ...
8
votes
1
answer
96
views
Which tags attract drive-by questions? Or: How do I compute, for each tag, the number of users of that tag who have ≤N total questions?
I'm currently thinking about questions with the character-identification tag at Chinese Language. I feel like a lot of the questions with this tag are "drive-by" questions, i.e., the user ...
6
votes
2
answers
188
views
SO Dataset query to retrieve questions, related answers and comments with a specific question tag
For a small part of my master thesis I need to retrieve a dataset from SEDE that contains all questions as well as the related multiple answers (and if possible also comments) with the tag "text-...
2
votes
1
answer
145
views
How to get tags of questions answered by a user in Stack Exchange Data Explorer
I can't solve this problem: using a remote DBMS from the Stack Overflow site (URL: http://data.stackexchange.com/stackoverflow/query/new). Write a SQL query that displays the names of users with a ...
9
votes
1
answer
137
views
How can I query SEDE to see the number of questions for a specific tag per year?
Having in mind a specific tag from Stack Overflow (i.e. python). Is there any query to make in SEDE which could provide the number of questions and answers posted per year in the specific tag?
14
votes
1
answer
152
views
Expose moderator-only and required tags in SEDE
The API has two methods to get a list of required tags (the gray ones) and moderator-only tags (the red ones):
required tags
moderator only tags
That means there must be an enumeration (or two ...