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)