Stack Exchange Data Explorer
Tag badges with links to tag edit history
Percentage of (non-deleted) questions which get closed as duplicates, month by month
select DATEADD(MONTH, DATEDIFF(MONTH, 0, p.CreationDate)...
Duplicates posted over time
Favorites that you haven't posted in
Questions by a given user with unaccepted answers
Top-scoring self-answered Q&As
SELECT TOP 50 PostId AS [Post Link], Score, Text, Creatio...
My Comment Score distribution
SELECT --TOP 50 COUNT(*) FROM PostsWithDeleted WHERE Post...
Select id AS [Post Link] FROM Posts WHERE OwnerUserId = 8...
Highest daily post scores
SELECT * FROM CloseAsOffTopicReasonTypes
SELECT Posts.Id AS [Post Link], PostHistory.CreationDate ...
site design / logo © 2019 Stack Exchange Inc; user contributions licensed under
cc by-sa 3.0