ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Amherst" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 70 ✖
- 0 138
- 40 66
- 1 38
- 4 38
- 6 35
- 33 33
- 10 29
- 88 29
- 37 25
- 62 23
- 35 22
- 61 19
- 84 18
- 41 16
- 7 15
- 63 15
- 83 13
- 53 12
- 11 10
- 13 10
- 57 10
- 86 9
- 8 8
- 36 8
- 60 8
- 43 6
- 65 6
- 69 6
- 76 6
- 79 6
- 9 5
- 12 5
- 34 5
- 46 5
- 55 5
- 56 5
- 59 5
- 64 5
- 38 4
- 44 4
- 48 4
- 89 4
- 3 3
- 21 3
- 39 3
- 47 3
- 66 3
- 74 3
- 87 3
- 24 2
- 45 2
- 50 2
- 51 2
- 54 2
- 80 2
- 82 2
- 85 2
- 2 1
- 5 1
- 15 1
- 17 1
- 19 1
- 20 1
- 23 1
- 30 1
- 31 1
- 70 1
- 71 1
- 75 1
- 77 1
state 1
- Virginia 783
fips 1
- 51009 783
county 1
- Amherst · 783 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
8146 | 8146 | 2020-03-22 | Amherst | Virginia | 51009 | 1 | 0 |
9367 | 9367 | 2020-03-23 | Amherst | Virginia | 51009 | 1 | 0 |
10713 | 10713 | 2020-03-24 | Amherst | Virginia | 51009 | 1 | 0 |
12225 | 12225 | 2020-03-25 | Amherst | Virginia | 51009 | 1 | 0 |
13862 | 13862 | 2020-03-26 | Amherst | Virginia | 51009 | 1 | 0 |
15628 | 15628 | 2020-03-27 | Amherst | Virginia | 51009 | 1 | 0 |
17502 | 17502 | 2020-03-28 | Amherst | Virginia | 51009 | 2 | 0 |
19462 | 19462 | 2020-03-29 | Amherst | Virginia | 51009 | 2 | 0 |
21525 | 21525 | 2020-03-30 | Amherst | Virginia | 51009 | 3 | 0 |
23664 | 23664 | 2020-03-31 | Amherst | Virginia | 51009 | 3 | 0 |
25879 | 25879 | 2020-04-01 | Amherst | Virginia | 51009 | 5 | 0 |
28168 | 28168 | 2020-04-02 | Amherst | Virginia | 51009 | 6 | 0 |
30511 | 30511 | 2020-04-03 | Amherst | Virginia | 51009 | 6 | 0 |
32909 | 32909 | 2020-04-04 | Amherst | Virginia | 51009 | 6 | 0 |
35347 | 35347 | 2020-04-05 | Amherst | Virginia | 51009 | 6 | 0 |
37828 | 37828 | 2020-04-06 | Amherst | Virginia | 51009 | 6 | 0 |
40358 | 40358 | 2020-04-07 | Amherst | Virginia | 51009 | 8 | 0 |
42927 | 42927 | 2020-04-08 | Amherst | Virginia | 51009 | 8 | 0 |
45521 | 45521 | 2020-04-09 | Amherst | Virginia | 51009 | 9 | 0 |
48145 | 48145 | 2020-04-10 | Amherst | Virginia | 51009 | 9 | 0 |
50803 | 50803 | 2020-04-11 | Amherst | Virginia | 51009 | 10 | 0 |
53478 | 53478 | 2020-04-12 | Amherst | Virginia | 51009 | 10 | 0 |
56167 | 56167 | 2020-04-13 | Amherst | Virginia | 51009 | 10 | 0 |
58873 | 58873 | 2020-04-14 | Amherst | Virginia | 51009 | 10 | 0 |
61592 | 61592 | 2020-04-15 | Amherst | Virginia | 51009 | 10 | 0 |
64324 | 64324 | 2020-04-16 | Amherst | Virginia | 51009 | 10 | 0 |
67072 | 67072 | 2020-04-17 | Amherst | Virginia | 51009 | 10 | 0 |
69834 | 69834 | 2020-04-18 | Amherst | Virginia | 51009 | 10 | 0 |
72604 | 72604 | 2020-04-19 | Amherst | Virginia | 51009 | 10 | 0 |
75380 | 75380 | 2020-04-20 | Amherst | Virginia | 51009 | 10 | 0 |
89377 | 89377 | 2020-04-25 | Amherst | Virginia | 51009 | 9 | 0 |
92194 | 92194 | 2020-04-26 | Amherst | Virginia | 51009 | 9 | 0 |
95023 | 95023 | 2020-04-27 | Amherst | Virginia | 51009 | 9 | 0 |
97865 | 97865 | 2020-04-28 | Amherst | Virginia | 51009 | 9 | 0 |
100715 | 100715 | 2020-04-29 | Amherst | Virginia | 51009 | 11 | 0 |
103570 | 103570 | 2020-04-30 | Amherst | Virginia | 51009 | 12 | 0 |
106434 | 106434 | 2020-05-01 | Amherst | Virginia | 51009 | 13 | 0 |
109303 | 109303 | 2020-05-02 | Amherst | Virginia | 51009 | 12 | 0 |
112177 | 112177 | 2020-05-03 | Amherst | Virginia | 51009 | 14 | 0 |
115060 | 115060 | 2020-05-04 | Amherst | Virginia | 51009 | 14 | 0 |
118019 | 118019 | 2020-05-05 | Amherst | Virginia | 51009 | 15 | 0 |
120983 | 120983 | 2020-05-06 | Amherst | Virginia | 51009 | 15 | 0 |
123964 | 123964 | 2020-05-07 | Amherst | Virginia | 51009 | 15 | 0 |
126949 | 126949 | 2020-05-08 | Amherst | Virginia | 51009 | 15 | 0 |
129938 | 129938 | 2020-05-09 | Amherst | Virginia | 51009 | 15 | 0 |
132928 | 132928 | 2020-05-10 | Amherst | Virginia | 51009 | 15 | 0 |
135918 | 135918 | 2020-05-11 | Amherst | Virginia | 51009 | 16 | 0 |
138909 | 138909 | 2020-05-12 | Amherst | Virginia | 51009 | 17 | 0 |
141905 | 141905 | 2020-05-13 | Amherst | Virginia | 51009 | 20 | 0 |
144902 | 144902 | 2020-05-14 | Amherst | Virginia | 51009 | 21 | 0 |
147905 | 147905 | 2020-05-15 | Amherst | Virginia | 51009 | 22 | 0 |
150914 | 150914 | 2020-05-16 | Amherst | Virginia | 51009 | 24 | 0 |
153925 | 153925 | 2020-05-17 | Amherst | Virginia | 51009 | 25 | 0 |
156942 | 156942 | 2020-05-18 | Amherst | Virginia | 51009 | 25 | 0 |
159966 | 159966 | 2020-05-19 | Amherst | Virginia | 51009 | 25 | 0 |
162994 | 162994 | 2020-05-20 | Amherst | Virginia | 51009 | 25 | 0 |
166023 | 166023 | 2020-05-21 | Amherst | Virginia | 51009 | 25 | 0 |
169059 | 169059 | 2020-05-22 | Amherst | Virginia | 51009 | 25 | 0 |
172100 | 172100 | 2020-05-23 | Amherst | Virginia | 51009 | 25 | 0 |
175143 | 175143 | 2020-05-24 | Amherst | Virginia | 51009 | 25 | 0 |
178188 | 178188 | 2020-05-25 | Amherst | Virginia | 51009 | 26 | 0 |
181232 | 181232 | 2020-05-26 | Amherst | Virginia | 51009 | 26 | 0 |
184283 | 184283 | 2020-05-27 | Amherst | Virginia | 51009 | 27 | 0 |
187340 | 187340 | 2020-05-28 | Amherst | Virginia | 51009 | 27 | 0 |
190404 | 190404 | 2020-05-29 | Amherst | Virginia | 51009 | 27 | 0 |
193470 | 193470 | 2020-05-30 | Amherst | Virginia | 51009 | 27 | 0 |
196540 | 196540 | 2020-05-31 | Amherst | Virginia | 51009 | 27 | 0 |
199613 | 199613 | 2020-06-01 | Amherst | Virginia | 51009 | 27 | 0 |
202689 | 202689 | 2020-06-02 | Amherst | Virginia | 51009 | 27 | 0 |
205768 | 205768 | 2020-06-03 | Amherst | Virginia | 51009 | 27 | 0 |
208850 | 208850 | 2020-06-04 | Amherst | Virginia | 51009 | 27 | 0 |
211935 | 211935 | 2020-06-05 | Amherst | Virginia | 51009 | 27 | 0 |
215022 | 215022 | 2020-06-06 | Amherst | Virginia | 51009 | 27 | 0 |
218112 | 218112 | 2020-06-07 | Amherst | Virginia | 51009 | 27 | 0 |
221204 | 221204 | 2020-06-08 | Amherst | Virginia | 51009 | 27 | 0 |
224300 | 224300 | 2020-06-09 | Amherst | Virginia | 51009 | 27 | 0 |
227400 | 227400 | 2020-06-10 | Amherst | Virginia | 51009 | 27 | 0 |
230504 | 230504 | 2020-06-11 | Amherst | Virginia | 51009 | 27 | 0 |
233609 | 233609 | 2020-06-12 | Amherst | Virginia | 51009 | 27 | 0 |
236716 | 236716 | 2020-06-13 | Amherst | Virginia | 51009 | 27 | 0 |
239824 | 239824 | 2020-06-14 | Amherst | Virginia | 51009 | 27 | 0 |
242935 | 242935 | 2020-06-15 | Amherst | Virginia | 51009 | 27 | 0 |
246047 | 246047 | 2020-06-16 | Amherst | Virginia | 51009 | 28 | 0 |
249159 | 249159 | 2020-06-17 | Amherst | Virginia | 51009 | 28 | 0 |
252274 | 252274 | 2020-06-18 | Amherst | Virginia | 51009 | 28 | 0 |
255392 | 255392 | 2020-06-19 | Amherst | Virginia | 51009 | 28 | 0 |
258519 | 258519 | 2020-06-20 | Amherst | Virginia | 51009 | 29 | 0 |
261646 | 261646 | 2020-06-21 | Amherst | Virginia | 51009 | 29 | 0 |
264775 | 264775 | 2020-06-22 | Amherst | Virginia | 51009 | 29 | 0 |
267904 | 267904 | 2020-06-23 | Amherst | Virginia | 51009 | 31 | 0 |
271038 | 271038 | 2020-06-24 | Amherst | Virginia | 51009 | 31 | 0 |
274178 | 274178 | 2020-06-25 | Amherst | Virginia | 51009 | 32 | 0 |
277326 | 277326 | 2020-06-26 | Amherst | Virginia | 51009 | 35 | 0 |
280474 | 280474 | 2020-06-27 | Amherst | Virginia | 51009 | 35 | 0 |
283620 | 283620 | 2020-06-28 | Amherst | Virginia | 51009 | 35 | 0 |
286766 | 286766 | 2020-06-29 | Amherst | Virginia | 51009 | 35 | 0 |
289916 | 289916 | 2020-06-30 | Amherst | Virginia | 51009 | 36 | 0 |
293069 | 293069 | 2020-07-01 | Amherst | Virginia | 51009 | 36 | 0 |
296224 | 296224 | 2020-07-02 | Amherst | Virginia | 51009 | 36 | 0 |
299386 | 299386 | 2020-07-03 | Amherst | Virginia | 51009 | 37 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);