All Questions
38
questions
2
votes
1
answer
48
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 ...
- 4,057
-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 ...
- 23
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 ...
- 161
9
votes
1
answer
149
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 ...
- 7,525
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 ...
- 22.1k
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 ...
- 123
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?
- 125
4
votes
3
answers
96
views
Find questions where any of the tags are in the title or body?
I would like to find posts where any of the tags are present in the title or body of the question, e.g. Python and C# are the tags and title is Fix my Python Problem?
SELECT TOP 10
Posts.Id,
Posts....
- 51
5
votes
1
answer
56
views
How can I list posts which have a particular tag, but didn't have it when originally asked?
I would like to gather some hard data on the use / misuse / non-use of some particular tags. I need a Data.SE query, customisable by tag, which can provide me with a list of all posts which:
have had ...
- 33.4k
4
votes
2
answers
85
views
Top users list of answerers that includes post count
I wanted a query like this that ranks by answer vote count for a given tag but that also includes a column with the number of answers.
Essentially a replica of the topusers page list for all-time ...
- 27.3k
8
votes
1
answer
71
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)
[...
- 22.1k
1
vote
3
answers
158
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:
...
- 287
2
votes
2
answers
89
views
Reproduce top tags for multiple users with Data Explorer
I want to reproduce the top tags overview for multiple users with the Data Explorer:
In the following I simplify for two users. The required solution should be able to scale to 50+ users.
What I ...
- 122
7
votes
1
answer
191
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 ...
- 183