6

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

Without of course visiting the individual profile pages.

2
6

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
(
select distinct cast(creationdate as date) as [activedate]
     , owneruserid
from
(
select creationdate 
     , owneruserid 
from posts
union 
select lasteditdate 
     , lasteditoruserid
from posts 
union
select creationdate
     , userid
from comments
) data
) uniquerows
group by activedate
order by activedate

You can extend this query to also include events from the posthistory table and suggested edits. See Database schema documentation for the public data dump and SEDE for the possibilities.

When run today this is what the graph looks like:

graph of user counts per day

Keep in mind SEDE is only updated once a week, on Sunday. If you have more questions that can be answered with queries against the SEDE database, consider asking them on Meta Stack Exchange. They already have a bunch of queries ready and if none of the existing ones fulfill your need there are enough users around that are prepared to take on these query requests.

2
  • Do you know a ready-made query for this: meta.hinduism.stackexchange.com/q/728. Thanks. Dec 30 '16 at 14:46
  • @sv. No, I don't. Not all data presented on Area 51 in the statistic is available in SEDE (due to missing history/deleted items). But feel free to bring it up on MSE as some of the statistics can be queried.
    – rene
    Dec 30 '16 at 14:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .