Hacker News new | ask | show | jobs
by SushiHippie 980 days ago
On clickhouse I can't see that crash. IIRC clickhouse sources their data from https://www.gharchive.org/

The query I used: https://play.clickhouse.com/play?user=play#U0VMRUNUIAogICAgZ...

EDIT: just saw that ossinsight also uses gharchive

I didn't filter for US region though. This is not really published by the github api, only the "location" field is published where users can put everything. ossinsight probably tried to parse the country codes?

But on ossinsight only ~5% of the users have a country code attached to https://ossinsight.io/explore/?id=28da49bd-fec9-4720-a4df-da...