14 lines
806 B
Bash
Executable File
14 lines
806 B
Bash
Executable File
#!/usr/bin/env bash
|
|
# set -ex
|
|
set -eo pipefail
|
|
|
|
cd $(dirname $0) && \
|
|
curl -fsS 'https://covid-19.datasettes.com/covid.csv?sql=select+day%2C+last_update%2C+sum(deaths)+sum_deaths%0D%0Afrom+johns_hopkins_csse_daily_reports%0D%0Awhere+country_or_region+not+like+%27%25Olympics%25%27%0D%0Agroup+by+day%0D%0Aorder+by+day+desc%0D%0Alimit+7%0D%0A&_header=off' | tac > covid_deaths.csv && \
|
|
./sqlite3.com covid_deaths.db \
|
|
'pragma journal_mode = "wal"' \
|
|
'create table if not exists covid_deaths(day text, last_update text, sum_deaths integer)' \
|
|
'create index if not exists covid_deaths_by_day on covid_deaths (day)' \
|
|
'.mode csv' \
|
|
'.import covid_deaths.csv covid_deaths' \
|
|
'delete from covid_deaths where rowid not in ( select max(rowid) from covid_deaths group by day )' > /dev/null
|