あれ
2024/12/14 0:01:00
集計に使ったコマンド(SQL)
duckdb --markdown -c "WITH ranking as (SELECT text, COUNT(*) as count FROM 'notes-2024-12-13-14-17-04.json' WHERE text LIKE '%ノートのネタ帳%' GROUP BY text ORDER BY COUNT(*) DESC) SELECT text.regexp_extract('^[^\n]+') as text, count FROM ranking;" > netanote.md