Skip to content

Instantly share code, notes, and snippets.

@rjpcasalino

rjpcasalino/fetch-covid-awk

Last active April 10, 2020 18:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rjpcasalino/014e57103339f8f60f6218e21ee75b93 to your computer and use it in GitHub Desktop.
Save rjpcasalino/014e57103339f8f60f6218e21ee75b93 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fetch-covid-awk
#!/usr/bin/env bash
wget -q -O data.csv "https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/$(date --date="yesterday" +%m-%d-%Y).csv"
LC_ALL=en_US.UTF-8 awk -v updated="$(date --date="yesterday" +%y-%m-%d) 23:00:00" -F, 'FNR==NR && $5 > updated { deaths[$3] += $9; confirmed[$3] += $8; next }
{ for (state in deaths)
if (state == $5 && deaths[state] > 0)
printf("%s\n Population: %'"'"'d\n Deaths: %'"'"'d\n Confirmed: %'"'"'d\n '%' Dead: %'"'"'f\n '%' Confirmed: %f\n", state, $16, deaths[state], confirmed[state], deaths[state] / $16 * 100, confirmed[state] / $16 * 100)
}' $1 $2 > output
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment