User zcoop98 - Meta Stack Overflow
zcoop98 Member for 7 years, 9 months Last seen this week GitHub 127.0.0.1 Dallas, TX, USA Main user Network profile Profile Activity Profile Stats 3,309 reputation 156k reached 87 answers 8 questions Loading… Communities View all Meta Stack Exchange 11.2k Stack Overflow 3.3k Arqade 182 Stack Apps 161 Super User 109 About I'm a Dallas-based full-stack software developer dealing mostly in JavaScript and .NET Core. I've worked with React , but my heart lies with Vue .
Some Stack Exchange Data Explorer (SEDE) queries I've written that I think are interesting: Cross-Tag Tag Usage Breakdown A breakdown and usage count of each and every tag used alongside the given tag on posts. Anonymous Vote Counts and Adjusted Post Scores Ever wonder where anonymous votes go? Pulls all votes by anonymous users and users without the respective voting privilege and aggregates them by post voted on. List of Average Question Scores Per Tag and Average Score of All Q's & A's in [Tag] Gets the average score of all questions using a given tag.
The first query pulls all tags, the second pulls Q & A averages for a specific tag. All Vote Totals By Year-Month Timeline of votes (up, down, total) cast on the given site. Total Users By Year-Month Total new users that joined [site] each year-month over the given site's history. 100 Most Duplicated Posts on [Site] and Duplicates for [Post] Lists the 100 most duplicated posts on the given site; the latter query lists every duplicate of a specific post.
Timeline of Questions & Answers Posted per Month Totals of the amount of questions, answers, and questions & answers combined posted on [site] over time, grouped by year-month. Comment Length Popularity Breakdown Groups all undeleted comments by length. (Did you know that the most common comment length on Stack Overflow is 61 characters?) Most Voted on Q & A Posts in [Date Range] Pulls the most voted on posts on [site] in the given date range.
Especially useful for finding the most popular or contentious posts in a specific time frame. New Comments on Older Posts Pulls a list of "older" posts with "newer" comment(s). (Probably most useful for exploring site Metas.) Badges View all badges 3 gold badges Lifeboat Mar 25, 2021 Populist Apr 27, 2021 Electorate Oct 26, 2020 44 silver badges Sportsmanship Jun 25 Deputy Jan 18, 2022 Strunk & White May 6, 2022 74 bronze badges Tag Editor Aug 2, 2021 discussion May 27, 2021 Explainer Apr 7, 2022 Top tags View all tags discussion 877 Score 57 Posts 60 Posts % tags 207 Score 17 Posts 18 Posts % feature-request 165 Score 15 Posts 16 Posts % burninate-request 150 Score 5 Posts 5 Posts % status-completed 131 Score 7 Posts 7 Posts % support 123 Score 20 Posts 21 Posts % Top posts View all questions and answers 79 Why do we reward users for answering bad questions and would it be a good idea to incentivize those who downvote or flag them instead?
Sep 14, 2021 78 The tag removal is [complete] Apr 16, 2021 60 What am I doing so wrong when I suggest things to SO? All of my ideas are terribly received Mar 23, 2021 58 "Do not use" recently added to [language-agnostic] Feb 10, 2021 42 You should [readme]: this tag is useless Aug 16, 2021 41 Are articles allowed to be off-topic? Jul 1, 2021 36 Is full attribution required when quoting parts of the question in an answer?
Nov 9, 2021 34 Rollback of enhancement in answer without justification Oct 31, 2025 32 Small but important tag excerpt change rejected? Aug 6, 2021 31 The user research behind Collectives™ on Stack Overflow Jun 23, 2021 Top network posts View all network posts 122 New responsive Activity page 70 Favicon sprites are offset in site list dropdown, not as a result of a new site being created 53 Our Partnership with OpenAI 46 Announcing a change to the data-dump process 45 New Feature: Table Support