Skip to content

Instantly share code, notes, and snippets.

@darashi

darashi/patients_summary.sql

Created September 21, 2024 01:51
Show Gist options
  • Save darashi/5cbc023246aed296e00f583e27c6373c to your computer and use it in GitHub Desktop.
Save darashi/5cbc023246aed296e00f583e27c6373c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
patients_summary.sql
SELECT sum(小計) AS count, year(日付) AS year FROM 'https://ckan.pf-sapporo.jp/dataset/c89f65e7-45a8-4ab2-b94d-494ae192c70f/resource/b83606f6-3aa2-4e0c-8a1a-509dd36be2ae/download/patients_summary.csv' GROUP BY year ORDER BY year;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment