coronavirus/Makefile at master · vmchale/coronavirus · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
.PHONY: clean all

.DELETE_ON_ERROR:

all: time_series_2019-ncov-Confirmed.csv time_series_2019-ncov-Deaths.csv nst-est2019-alldata.csv chicago-tested.csv chicago-cases.csv chicago-hospitalized.csv excess.csv excess-age.csv moderna.csv pfizer.csv cdc.csv janssen.csv variants.csv test.csv hosp.csv pop.csv

sources-csv.zip:
	curl $$(curl https://www.covid19.admin.ch/api/data/context -s | jq -r '.sources.zip.csv') -o $@


data/COVID19Cases_geoRegion.csv data/COVID19Hosp_geoRegion.csv &: sources-csv.zip
	unzip $< $@

variants.csv:
	curl -L https://raw.githubusercontent.com/myhelix/helix-covid19db/master/counts_by_state.csv -o $@

hosp.csv:
	wget https://healthdata.gov/api/views/g62h-syeh/rows.csv -O $@
	perl -i -pe 's/(\d{4})\/(\d{2})\/(\d{2})/\1-\2-\3/' $@

test.csv:
	curl -L https://healthdata.gov/api/views/j8mb-icvb/rows.csv -o $@
	perl -i -pe 's/(\d+)\/(\d+)\/(\d+)/\1-\2-\3/g' $@

all.csv:
	curl -L https://data.cdc.gov/api/views/vbim-akqf/rows.csv -o $@
	perl -i -pe 's/(\d+)\/(\d+)\/(\d+)/\1-\2-\3/g' $@

WPP2019_TotalPopulationBySex.csv:
	curl -L 'https://population.un.org/wpp/Download/Files/1_Indicators%20(Standard)/CSV_FILES/WPP2019_TotalPopulationBySex.csv' -o $@

cdc.csv:
	curl -L https://data.cdc.gov/api/views/9mfq-cb36/rows.csv -o $@
	perl -i -pe 's/(\d+)\/(\d+)\/(\d+)/\3-\1-\2/' $@

nst-est2019-alldata.csv:
	curl -L https://www2.census.gov/programs-surveys/popest/datasets/2010-2019/national/totals/nst-est2019-alldata.csv -o $@

pop.csv: nst-est2019-alldata.csv
	sed 's/ //g' $< > $@

moderna.csv:
	curl -L https://data.cdc.gov/api/views/b7pe-5nws/rows.csv -o $@
	perl -i -pe 's/(\d+)\/(\d+)\/(\d+)/\3-\1-\2/' $@

pfizer.csv:
	curl -L https://data.cdc.gov/api/views/saz5-9hgg/rows.csv -o $@
	perl -i -pe 's/(\d+)\/(\d+)\/(\d+)/\3-\1-\2/' $@

janssen.csv:
	curl -L https://data.cdc.gov/api/views/w9zu-fywh/rows.csv -o $@
	perl -i -pe 's/(\d+)\/(\d+)\/(\d+)/\3-\1-\2/' $@

excess-j.csv:
	curl -L https://data.cdc.gov/api/views/xkkf-xrst/rows.csv -o $@

excess.csv: excess-j.csv
	sed 's/ //g' $< > $@

excess-age.csv:
	curl -L https://data.cdc.gov/api/views/y5bj-9g5w/rows.csv -o $@
	perl -i -pe 's/(\d+)\/(\d+)\/(\d+)/\3-\1-\2/' $@

time_series_2019-ncov-Confirmed.csv:
	curl -L https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv -o $@

time_series_2019-ncov-Deaths.csv:
	curl -L https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv -o $@

us-states.csv:
	curl -L https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv -o $@

chicago-tested.csv:
	curl -L https://data.cityofchicago.org/resource/t4hh-4ku9.csv -o $@

chicago-cases.csv:
	curl -L https://data.cityofchicago.org/resource/naz8-j4nc.csv -o $@
	xsv sort $@ -o $@

chicagoCases.csv:
	curl -L https://data.cityofchicago.org/resource/naz8-j4nc.csv -o $@

chicago-hospitalized.csv:
	curl -L https://data.cityofchicago.org/resource/f3he-c6sv.csv -o $@

clean:
	rm -rf time_series_*.csv ilgen.csv us-states.csv nst-est2019-alldata.csv WPP2019_TotalPopulationBySex.csv chicago-tested.c* chicago-hospitalized.c* chicago-cases.c* excess.csv jdclass excess-age.csv moderna.csv pfizer.csv cdc.csv all.csv test.csv hosp.csv janssen.csv variants.csv .shake data sources-csv.zip sources.schema.json excess-j.csv pop.csv chicagoCases.csv __pycache__