17 votes
Accepted

Comparison chart of site progress over the years or over the last few months?

One way is to use Internet Archive as discussed here You can find some snap shots for earlier months and year there. I've tabulated data from available snap-snots and prepared some charts. That may ...
Pandya's user avatar
  • 26.2k
10 votes
Accepted

How to get list of top users based on number of answers, questions and both?

The following query will show users, total posts, questions, answers, tag excerpts and tag wikis. select u.id [User Link] , u.reputation , u.creationdate , count(*) [# posts] , sum(...
rene's user avatar
  • 101
8 votes
Accepted

I need a query for finding out users with high voting rates

I have created a query to get votes per day for particular user. Query is as follows: DECLARE @UserID int = ##UserId## select Id as UserId, CreationDate, LastAccessDate, UpVotes, DownVotes, DATEDIFF(...
Triyugi Narayan Mani's user avatar
8 votes

How to get list of top users based on number of answers, questions and both?

I could create those queries with the help of some other queries: https://data.stackexchange.com/hinduism/query/1423034/users-who-contributed-most-posts-qa https://data.stackexchange.com/hinduism/...
YDS's user avatar
  • 24.3k
7 votes
Accepted

Queries that rank users according to the number of close/reopen votes they have cast

What I have written here is to the best of my knowledge, but I am only a beginner at using the SE data explorer and corrections may be due. I did not write the queries mentioned but only slightly ...
Zanna's user avatar
  • 435
7 votes
Accepted

Is there a way of determining how many and which users were active on a given day?

You have to define active more precise but I have taken the users that either post or edit or leave a comment and then created this SEDE Query select activedate , count(*) [# users] from ( ...
rene's user avatar
  • 101
7 votes
Accepted

The rate at which I accept answers

Try this query: AAR A snapshot of result for your account:
TheLittleNaruto's user avatar
  • 7,326
6 votes
Accepted

Can the data "visited-number of days" be known/displayed publicly for any user?

No. It is not available for a normal user. It is available for you and moderators only. For normal users or when logged out For the user when logged in the same as you uploaded in the question. ...
Sarvabhouma's user avatar
  • 25.8k
5 votes
Accepted

Query for how many downvotes a user has received so far

There is a query present to find the User Ratio of Upvotes to Downvotes Received. select SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS [Up Votes], SUM(CASE WHEN VoteTypeId = 3 THEN 1 ...
Triyugi Narayan Mani's user avatar
3 votes

Given any user- how to find out all such tags for which he/she is the top user?

I have edited a query to make it fulfill half of the requirement. By using this query Tags for which user is top answerer. you can get all the tags for which the given user is top answerer.
Triyugi Narayan Mani's user avatar
2 votes

Comparison chart of site progress over the years or over the last few months?

There is an easier way to check the stats. This is a privilege provided by the Stack Exchange for the users with >5k reputation (Only on beta sites. 25k on normal sites). So, you have to earn all the ...
Sarvabhouma's user avatar
  • 25.8k

Only top scored, non community-wiki answers of a minimum length are eligible