@AlecRhea The number of consecutive days visited is not stored in SEDE. The only thing related to visiting the site is LastAccessDate in the table Users, see: Database schema documentation for the public data dump and SEDE

You could get days on which a user made a post (comment), but trying to get number of consecutive days is something which goes beyond my knowledge of SQL.

Attempts by other users to do something similar lead to rather complex queries: Record for most consecutive days visited?, and How to find the users who took a long break from posting on an SE site?

As an aside, I will post here a query where you can see for some user in which times of the day (or day of the week) they created the most posts: data.stackexchange.com/mathoverflow/query/938233/… (

I have looked into some stats about the mods some time ago:

Last Access: main, meta

Recent posts: main, meta

Recent comments: main, meta.

@MartinSleziak Thank you Martin!

@MartinSleziak Could we do the proportion of days visited vs days since account creation?

@AlecRhea As mentioned before, from SEDE we can't get when a user visited the site. Still, we can get days when a user commented/posted.

Take this with a grain of salt, but if I did not make some mistake, this should be days (counts and percentages) with at least one post: meta, main.

@AlecRhea the issue is that the data is "private"; each user could it check easily. But:

The answer is old, by now he passed the mark of a decade of continued presence.

The title is misleading, as it is a question of an SO user that updates it frequently.

Of course the above is for math.se but one can speculate it is naturally pretty much the same for MO.

@quid Well, I did miss a few days here and there on MO.

But I did visit for 3919 days on MO, which is longer than I've been a member on MSE, so I couldn't have missed that many (there's just over a month difference between the registration dates).

@AsafKaragila slacker! ;-)

@AsafKaragila I don't know how you can work that much... and on top of that, you run to be a moderator on another site.

@AsafKaragila why is that? After all it's not just SE, but you also work at a university (IIUC), and I'd think there's other activities that you do.

@Verónica I don't know. That's just how I organise my life.

Here's a very rough gauge of the grown of MO in the last 8 years. The only other time there was a moderator election where a "constituent" badge was awarded was in 2013. There are currently 16 pages of "constituent" badge awardees. The cutoff between those awarded for the current election and those awarded for the 2013 election is currently on page 11. So if the election ended today, I'd be estimating 2-fold growth in the last 8 years.

I'm sure there are better ways to do this. One nice thing is that the "constituent" badge is awarded for voting in an election which I would think implies a certain minimum level engagement from a user.

@MartinSleziak Can you tell how many were from 2013 vs 2021?

Oh -- that's an old post, so those are just the 2013 ones

Now 2178 Caucus and 937 consituents.

@TimCampion Exactly, that's why I posted it.

You think of everything, Martin!

You can user also this SEDE query: data.stackexchange.com/mathoverflow/query/1316191/… (You can choose any badge and any date range.) But keep in mind that SEDE is only updated once a week.)

@AsafKaragila (: oh ok, I hope you win to be a moderator. A policeman for another department, or like a sheriff, or like a detective of those tv series Law & Order