COVID-19 daily stats by location [shared]

	A	B	C	D
1	COVID-19: Daily cases, deaths & recoveries by location
2
3	Instructions: 1. Make a copy of this sheet so you can edit it (File > Make a Copy). 2. Select your locations of interest from the dropdowns below, then check tabs 1-3 for graphs.
4
5	Location 1	UK
6	Location 2	France
7	Location 3	Iceland
8	Location 4	Italy
9	Location 5
10
11	Explanation
12	The Johns Hopkins map [1] is useful, but I wanted a daily breakdown by location. This sheet provides an easy way to get that, using data from the Johns Hopkins Github repo [2], specifically this [3]. The sheet should update automatically within a few hours after the Johns Hopkins daily database update. A couple notes for understanding these figures: 1. The difference between # of actual cases and # of confirmed case depends on the amount of testing that's being done in a given location. As I understand it, the amount of testing varies widely by location. 2. Yes, these growth rates are concerning.		Links
13			[1]	https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6
14			[2]	https://github.com/CSSEGISandData/COVID-19
15			[3]	https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_time_series
16
17
18	Notes
19	If you spot problems with this sheet, please tweet @peterhartree. If you want to suggest improvements, please make a copy and tweet me a link to your new version.
20
21	For more things like this, see:
22	https://coronavirustechhandbook.com/
23
24	Grabbing data from a public CSV file is easy – you just need the Google Sheets IMPORTDATA() function:
25	https://support.google.com/docs/answer/3093335?hl=en
26
27	Todo, maybe:
28	- Add 7-day MA growth rate
29	- Nicer graph formatting
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
88
89
90
91
92
93
94
95
96
97
98
99
100