35 ms·
The Most Popular Blogs on HN in 2025
- simonw 9mo agoThis CSV file looks potentially useful for other projects - maps domain names to author name, bio and tags and since it's in a GitHub repo you can JS fetch() it from any page via CORS https://github.com/mtlynch/hn-popularity-contest-data/blob/master/data/domains-meta.csv https://github.com/mtlynch/hn-popularity-contest-data/blob/m...
- simonw 9mo agoOh cool... the main CSV data (~3MB) is available via CORS too! https://hn-popularity.cdn.refactoringenglish.com/hn-data.csv https://hn-popularity.cdn.refactoringenglish.com/hn-data.csv I had Claude write me a SQL query for showing the relative rankings of different domains over time, here's that query running in Datasette Lite directly against the CORS CSV file: https://lite.datasette.io/?csv=https://hn-popularity.cdn.refactoringenglish.com/hn-data.csv#/data?sql=WITH+yearly_scores+AS+%28%0A++++SELECT+%0A++++++++domain%2C%0A++++++++strftime%28%27%25Y%27%2C+date%29+AS+year%2C%0A++++++++SUM%28score%29+AS+total_score%2C%0A++++++++COUNT%28DISTINCT+date%29+AS+days_mentioned%0A++++FROM+%22hn-data%22%0A++++GROUP+BY+domain%2C+strftime%28%27%25Y%27%2C+date%29%0A%29%2C%0Aranked+AS+%28%0A++++SELECT+%0A++++++++domain%2C%0A++++++++year%2C%0A++++++++total_score%2C%0A++++++++days_mentioned%2C%0A++++++++RANK%28%29+OVER+%28PARTITION+BY+year+ORDER+BY+total_score+DESC%29+AS+rank%0A++++FROM+yearly_scores%0A%29%0ASELECT+%0A++++r.year%2C%0A++++r.total_score%2C%0A++++r.rank%2C%0A++++r.days_mentioned%0AFROM+ranked+r%0AWHERE+r.domain+%3D+%3Adomain%0A++AND+r.year+%3E%3D+%28%0A++++++SELECT+MIN%28strftime%28%27%25Y%27%2C+date%29%29+%0A++++++FROM+%22hn-data%22%0A++++++WHERE+domain+%3D+%3Adomain%0A++%29%0AORDER+BY+r.year+DESC&domain=simonwillison.net&_hide_sql=1 https://lite.datasette.io/?csv=https://hn-popularity.cdn.ref... ... and then I saw you have that feature already! https://refactoringenglish.com/tools/hn-popularity/domain/?d=simonwillison.net https://refactoringenglish.com/tools/hn-popularity/domain/?d...
- simonw 9mo agoWrote up my explorations here: https://simonwillison.net/2026/Jan/2/most-popular-blogs-of-hacker-news/ https://simonwillison.net/2026/Jan/2/most-popular-blogs-of-h...