hello world i'll just dump random town related shit here
sqlite> select year, count(*) from (select *, strftime("%Y", datetime(created, 'unixepoch', 'localtime')) as year from users) group by year;
year|count(*)
2014|1
2017|738
2018|446
2019|238
2020|687
2021|338
2022|343
2023|244
2024|14
this is how many people have joined per year according to this one incomplete
source (there are others but it doesn't seem like they were integrated into
this db)