ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,825 rows where county = "Allen" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Allen · 3,825 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
5427 | 5427 | 2020-03-20 | Allen | Indiana | 18003 | 1 | 0 |
6362 | 6362 | 2020-03-21 | Allen | Indiana | 18003 | 4 | 0 |
7416 | 7416 | 2020-03-22 | Allen | Indiana | 18003 | 4 | 0 |
7493 | 7493 | 2020-03-22 | Allen | Kentucky | 21003 | 1 | 0 |
8655 | 8655 | 2020-03-23 | Allen | Kentucky | 21003 | 1 | 0 |
8683 | 8683 | 2020-03-23 | Allen | Louisiana | 22003 | 2 | 0 |
9938 | 9938 | 2020-03-24 | Allen | Kentucky | 21003 | 1 | 0 |
9971 | 9971 | 2020-03-24 | Allen | Louisiana | 22003 | 2 | 0 |
11338 | 11338 | 2020-03-25 | Allen | Kentucky | 21003 | 1 | 0 |
11375 | 11375 | 2020-03-25 | Allen | Louisiana | 22003 | 2 | 0 |
12907 | 12907 | 2020-03-26 | Allen | Kentucky | 21003 | 1 | 0 |
12950 | 12950 | 2020-03-26 | Allen | Louisiana | 22003 | 5 | 0 |
14610 | 14610 | 2020-03-27 | Allen | Kentucky | 21003 | 1 | 0 |
14657 | 14657 | 2020-03-27 | Allen | Louisiana | 22003 | 5 | 0 |
16418 | 16418 | 2020-03-28 | Allen | Kentucky | 21003 | 1 | 0 |
16475 | 16475 | 2020-03-28 | Allen | Louisiana | 22003 | 7 | 0 |
17035 | 17035 | 2020-03-28 | Allen | Ohio | 39003 | 2 | 0 |
18327 | 18327 | 2020-03-29 | Allen | Kentucky | 21003 | 1 | 0 |
18969 | 18969 | 2020-03-29 | Allen | Ohio | 39003 | 4 | 0 |
20341 | 20341 | 2020-03-30 | Allen | Kentucky | 21003 | 1 | 0 |
21012 | 21012 | 2020-03-30 | Allen | Ohio | 39003 | 4 | 0 |
22440 | 22440 | 2020-03-31 | Allen | Kentucky | 21003 | 1 | 0 |
23144 | 23144 | 2020-03-31 | Allen | Ohio | 39003 | 5 | 0 |
24616 | 24616 | 2020-04-01 | Allen | Kentucky | 21003 | 1 | 0 |
25339 | 25339 | 2020-04-01 | Allen | Ohio | 39003 | 6 | 0 |
26860 | 26860 | 2020-04-02 | Allen | Kentucky | 21003 | 1 | 0 |
27605 | 27605 | 2020-04-02 | Allen | Ohio | 39003 | 10 | 0 |
29176 | 29176 | 2020-04-03 | Allen | Kentucky | 21003 | 1 | 0 |
29934 | 29934 | 2020-04-03 | Allen | Ohio | 39003 | 13 | 0 |
31550 | 31550 | 2020-04-04 | Allen | Kentucky | 21003 | 1 | 0 |
32323 | 32323 | 2020-04-04 | Allen | Ohio | 39003 | 15 | 0 |
33967 | 33967 | 2020-04-05 | Allen | Kentucky | 21003 | 3 | 0 |
34756 | 34756 | 2020-04-05 | Allen | Ohio | 39003 | 18 | 0 |
36425 | 36425 | 2020-04-06 | Allen | Kentucky | 21003 | 3 | 0 |
37225 | 37225 | 2020-04-06 | Allen | Ohio | 39003 | 19 | 0 |
38930 | 38930 | 2020-04-07 | Allen | Kentucky | 21003 | 3 | 0 |
41478 | 41478 | 2020-04-08 | Allen | Kentucky | 21003 | 3 | 0 |
44053 | 44053 | 2020-04-09 | Allen | Kentucky | 21003 | 4 | 0 |
46661 | 46661 | 2020-04-10 | Allen | Kentucky | 21003 | 4 | 0 |
49298 | 49298 | 2020-04-11 | Allen | Kentucky | 21003 | 4 | 0 |
51964 | 51964 | 2020-04-12 | Allen | Kentucky | 21003 | 2 | 0 |
54645 | 54645 | 2020-04-13 | Allen | Kentucky | 21003 | 2 | 0 |
57340 | 57340 | 2020-04-14 | Allen | Kentucky | 21003 | 2 | 0 |
60049 | 60049 | 2020-04-15 | Allen | Kentucky | 21003 | 3 | 0 |
62769 | 62769 | 2020-04-16 | Allen | Kentucky | 21003 | 3 | 0 |
65508 | 65508 | 2020-04-17 | Allen | Kentucky | 21003 | 4 | 0 |
68257 | 68257 | 2020-04-18 | Allen | Kentucky | 21003 | 4 | 0 |
71018 | 71018 | 2020-04-19 | Allen | Kentucky | 21003 | 4 | 0 |
73790 | 73790 | 2020-04-20 | Allen | Kentucky | 21003 | 4 | 0 |
76570 | 76570 | 2020-04-21 | Allen | Kentucky | 21003 | 4 | 0 |
79355 | 79355 | 2020-04-22 | Allen | Kentucky | 21003 | 5 | 0 |
82151 | 82151 | 2020-04-23 | Allen | Kentucky | 21003 | 5 | 0 |
84954 | 84954 | 2020-04-24 | Allen | Kentucky | 21003 | 6 | 0 |
87763 | 87763 | 2020-04-25 | Allen | Kentucky | 21003 | 7 | 0 |
90579 | 90579 | 2020-04-26 | Allen | Kentucky | 21003 | 7 | 0 |
93400 | 93400 | 2020-04-27 | Allen | Kentucky | 21003 | 8 | 0 |
96233 | 96233 | 2020-04-28 | Allen | Kentucky | 21003 | 9 | 0 |
99079 | 99079 | 2020-04-29 | Allen | Kentucky | 21003 | 12 | 0 |
101931 | 101931 | 2020-04-30 | Allen | Kentucky | 21003 | 13 | 0 |
104792 | 104792 | 2020-05-01 | Allen | Kentucky | 21003 | 14 | 0 |
107657 | 107657 | 2020-05-02 | Allen | Kentucky | 21003 | 14 | 0 |
110528 | 110528 | 2020-05-03 | Allen | Kentucky | 21003 | 14 | 0 |
113405 | 113405 | 2020-05-04 | Allen | Kentucky | 21003 | 14 | 0 |
116287 | 116287 | 2020-05-05 | Allen | Kentucky | 21003 | 16 | 0 |
119248 | 119248 | 2020-05-06 | Allen | Kentucky | 21003 | 19 | 0 |
122218 | 122218 | 2020-05-07 | Allen | Kentucky | 21003 | 25 | 0 |
125200 | 125200 | 2020-05-08 | Allen | Kentucky | 21003 | 25 | 0 |
128188 | 128188 | 2020-05-09 | Allen | Kentucky | 21003 | 25 | 0 |
131178 | 131178 | 2020-05-10 | Allen | Kentucky | 21003 | 25 | 0 |
241010 | 241010 | 2020-06-15 | Allen | Kansas | 20001 | 1 | 0 |
244121 | 244121 | 2020-06-16 | Allen | Kansas | 20001 | 1 | 0 |
247234 | 247234 | 2020-06-17 | Allen | Kansas | 20001 | 1 | 0 |
250346 | 250346 | 2020-06-18 | Allen | Kansas | 20001 | 1 | 0 |
253461 | 253461 | 2020-06-19 | Allen | Kansas | 20001 | 1 | 0 |
256581 | 256581 | 2020-06-20 | Allen | Kansas | 20001 | 1 | 0 |
259707 | 259707 | 2020-06-21 | Allen | Kansas | 20001 | 1 | 0 |
262834 | 262834 | 2020-06-22 | Allen | Kansas | 20001 | 1 | 0 |
265962 | 265962 | 2020-06-23 | Allen | Kansas | 20001 | 1 | 0 |
269092 | 269092 | 2020-06-24 | Allen | Kansas | 20001 | 1 | 0 |
272229 | 272229 | 2020-06-25 | Allen | Kansas | 20001 | 1 | 0 |
275371 | 275371 | 2020-06-26 | Allen | Kansas | 20001 | 4 | 0 |
278519 | 278519 | 2020-06-27 | Allen | Kansas | 20001 | 4 | 0 |
281667 | 281667 | 2020-06-28 | Allen | Kansas | 20001 | 5 | 0 |
284812 | 284812 | 2020-06-29 | Allen | Kansas | 20001 | 5 | 0 |
287961 | 287961 | 2020-06-30 | Allen | Kansas | 20001 | 5 | 0 |
291111 | 291111 | 2020-07-01 | Allen | Kansas | 20001 | 5 | 0 |
294265 | 294265 | 2020-07-02 | Allen | Kansas | 20001 | 5 | 0 |
297423 | 297423 | 2020-07-03 | Allen | Kansas | 20001 | 5 | 0 |
300585 | 300585 | 2020-07-04 | Allen | Kansas | 20001 | 5 | 0 |
303749 | 303749 | 2020-07-05 | Allen | Kansas | 20001 | 5 | 0 |
306914 | 306914 | 2020-07-06 | Allen | Kansas | 20001 | 5 | 0 |
310082 | 310082 | 2020-07-07 | Allen | Kansas | 20001 | 5 | 0 |
313252 | 313252 | 2020-07-08 | Allen | Kansas | 20001 | 5 | 0 |
316426 | 316426 | 2020-07-09 | Allen | Kansas | 20001 | 5 | 0 |
319599 | 319599 | 2020-07-10 | Allen | Kansas | 20001 | 6 | 0 |
322778 | 322778 | 2020-07-11 | Allen | Kansas | 20001 | 6 | 0 |
325959 | 325959 | 2020-07-12 | Allen | Kansas | 20001 | 6 | 0 |
329145 | 329145 | 2020-07-13 | Allen | Kansas | 20001 | 8 | 0 |
332332 | 332332 | 2020-07-14 | Allen | Kansas | 20001 | 8 | 0 |
335525 | 335525 | 2020-07-15 | Allen | Kansas | 20001 | 8 | 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);