ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 10001 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3851 | 3851 | 2020-03-18 | Kent | Delaware | 10001 | 3 | 0 |
4516 | 4516 | 2020-03-19 | Kent | Delaware | 10001 | 4 | 0 |
5295 | 5295 | 2020-03-20 | Kent | Delaware | 10001 | 4 | 0 |
6222 | 6222 | 2020-03-21 | Kent | Delaware | 10001 | 5 | 0 |
7258 | 7258 | 2020-03-22 | Kent | Delaware | 10001 | 5 | 0 |
8404 | 8404 | 2020-03-23 | Kent | Delaware | 10001 | 9 | 0 |
9649 | 9649 | 2020-03-24 | Kent | Delaware | 10001 | 10 | 0 |
11023 | 11023 | 2020-03-25 | Kent | Delaware | 10001 | 14 | 0 |
12571 | 12571 | 2020-03-26 | Kent | Delaware | 10001 | 19 | 0 |
14240 | 14240 | 2020-03-27 | Kent | Delaware | 10001 | 21 | 0 |
16024 | 16024 | 2020-03-28 | Kent | Delaware | 10001 | 25 | 2 |
17916 | 17916 | 2020-03-29 | Kent | Delaware | 10001 | 25 | 2 |
19896 | 19896 | 2020-03-30 | Kent | Delaware | 10001 | 27 | 2 |
21973 | 21973 | 2020-03-31 | Kent | Delaware | 10001 | 34 | 2 |
24132 | 24132 | 2020-04-01 | Kent | Delaware | 10001 | 41 | 2 |
26362 | 26362 | 2020-04-02 | Kent | Delaware | 10001 | 43 | 2 |
28664 | 28664 | 2020-04-03 | Kent | Delaware | 10001 | 54 | 2 |
31022 | 31022 | 2020-04-04 | Kent | Delaware | 10001 | 68 | 2 |
33428 | 33428 | 2020-04-05 | Kent | Delaware | 10001 | 86 | 2 |
35873 | 35873 | 2020-04-06 | Kent | Delaware | 10001 | 128 | 3 |
38363 | 38363 | 2020-04-07 | Kent | Delaware | 10001 | 147 | 3 |
40906 | 40906 | 2020-04-08 | Kent | Delaware | 10001 | 201 | 3 |
43480 | 43480 | 2020-04-09 | Kent | Delaware | 10001 | 214 | 3 |
46080 | 46080 | 2020-04-10 | Kent | Delaware | 10001 | 230 | 3 |
48710 | 48710 | 2020-04-11 | Kent | Delaware | 10001 | 255 | 4 |
51372 | 51372 | 2020-04-12 | Kent | Delaware | 10001 | 281 | 4 |
54051 | 54051 | 2020-04-13 | Kent | Delaware | 10001 | 288 | 6 |
56743 | 56743 | 2020-04-14 | Kent | Delaware | 10001 | 329 | 7 |
59451 | 59451 | 2020-04-15 | Kent | Delaware | 10001 | 345 | 8 |
62170 | 62170 | 2020-04-16 | Kent | Delaware | 10001 | 352 | 9 |
64903 | 64903 | 2020-04-17 | Kent | Delaware | 10001 | 384 | 9 |
67651 | 67651 | 2020-04-18 | Kent | Delaware | 10001 | 417 | 10 |
70413 | 70413 | 2020-04-19 | Kent | Delaware | 10001 | 417 | 10 |
73182 | 73182 | 2020-04-20 | Kent | Delaware | 10001 | 430 | 13 |
75958 | 75958 | 2020-04-21 | Kent | Delaware | 10001 | 459 | 14 |
78742 | 78742 | 2020-04-22 | Kent | Delaware | 10001 | 503 | 15 |
81536 | 81536 | 2020-04-23 | Kent | Delaware | 10001 | 539 | 15 |
84336 | 84336 | 2020-04-24 | Kent | Delaware | 10001 | 558 | 15 |
87144 | 87144 | 2020-04-25 | Kent | Delaware | 10001 | 579 | 18 |
89961 | 89961 | 2020-04-26 | Kent | Delaware | 10001 | 625 | 22 |
92779 | 92779 | 2020-04-27 | Kent | Delaware | 10001 | 652 | 23 |
95611 | 95611 | 2020-04-28 | Kent | Delaware | 10001 | 728 | 23 |
98456 | 98456 | 2020-04-29 | Kent | Delaware | 10001 | 743 | 25 |
101306 | 101306 | 2020-04-30 | Kent | Delaware | 10001 | 759 | 26 |
104161 | 104161 | 2020-05-01 | Kent | Delaware | 10001 | 773 | 27 |
107026 | 107026 | 2020-05-02 | Kent | Delaware | 10001 | 793 | 29 |
109895 | 109895 | 2020-05-03 | Kent | Delaware | 10001 | 821 | 30 |
112770 | 112770 | 2020-05-04 | Kent | Delaware | 10001 | 833 | 30 |
115653 | 115653 | 2020-05-05 | Kent | Delaware | 10001 | 847 | 32 |
118613 | 118613 | 2020-05-06 | Kent | Delaware | 10001 | 891 | 33 |
121582 | 121582 | 2020-05-07 | Kent | Delaware | 10001 | 945 | 34 |
124562 | 124562 | 2020-05-08 | Kent | Delaware | 10001 | 963 | 36 |
127548 | 127548 | 2020-05-09 | Kent | Delaware | 10001 | 985 | 38 |
130539 | 130539 | 2020-05-10 | Kent | Delaware | 10001 | 1016 | 38 |
133530 | 133530 | 2020-05-11 | Kent | Delaware | 10001 | 1044 | 39 |
136519 | 136519 | 2020-05-12 | Kent | Delaware | 10001 | 1060 | 43 |
139510 | 139510 | 2020-05-13 | Kent | Delaware | 10001 | 1084 | 45 |
142506 | 142506 | 2020-05-14 | Kent | Delaware | 10001 | 1115 | 46 |
145506 | 145506 | 2020-05-15 | Kent | Delaware | 10001 | 1146 | 48 |
148509 | 148509 | 2020-05-16 | Kent | Delaware | 10001 | 1176 | 52 |
151518 | 151518 | 2020-05-17 | Kent | Delaware | 10001 | 1197 | 52 |
154530 | 154530 | 2020-05-18 | Kent | Delaware | 10001 | 1219 | 52 |
157546 | 157546 | 2020-05-19 | Kent | Delaware | 10001 | 1238 | 53 |
160572 | 160572 | 2020-05-20 | Kent | Delaware | 10001 | 1253 | 55 |
163600 | 163600 | 2020-05-21 | Kent | Delaware | 10001 | 1281 | 55 |
166633 | 166633 | 2020-05-22 | Kent | Delaware | 10001 | 1296 | 56 |
169670 | 169670 | 2020-05-23 | Kent | Delaware | 10001 | 1315 | 56 |
172711 | 172711 | 2020-05-24 | Kent | Delaware | 10001 | 1340 | 56 |
175754 | 175754 | 2020-05-25 | Kent | Delaware | 10001 | 1356 | 56 |
178798 | 178798 | 2020-05-26 | Kent | Delaware | 10001 | 1368 | 57 |
181842 | 181842 | 2020-05-27 | Kent | Delaware | 10001 | 1374 | 61 |
184896 | 184896 | 2020-05-28 | Kent | Delaware | 10001 | 1392 | 61 |
187952 | 187952 | 2020-05-29 | Kent | Delaware | 10001 | 1401 | 62 |
191017 | 191017 | 2020-05-30 | Kent | Delaware | 10001 | 1432 | 63 |
194084 | 194084 | 2020-05-31 | Kent | Delaware | 10001 | 1436 | 63 |
197154 | 197154 | 2020-06-01 | Kent | Delaware | 10001 | 1440 | 63 |
200227 | 200227 | 2020-06-02 | Kent | Delaware | 10001 | 1450 | 66 |
203303 | 203303 | 2020-06-03 | Kent | Delaware | 10001 | 1451 | 66 |
206383 | 206383 | 2020-06-04 | Kent | Delaware | 10001 | 1454 | 69 |
209464 | 209464 | 2020-06-05 | Kent | Delaware | 10001 | 1465 | 71 |
212549 | 212549 | 2020-06-06 | Kent | Delaware | 10001 | 1496 | 72 |
215636 | 215636 | 2020-06-07 | Kent | Delaware | 10001 | 1511 | 76 |
218727 | 218727 | 2020-06-08 | Kent | Delaware | 10001 | 1513 | 76 |
221822 | 221822 | 2020-06-09 | Kent | Delaware | 10001 | 1522 | 76 |
224917 | 224917 | 2020-06-10 | Kent | Delaware | 10001 | 1530 | 78 |
228019 | 228019 | 2020-06-11 | Kent | Delaware | 10001 | 1543 | 79 |
231122 | 231122 | 2020-06-12 | Kent | Delaware | 10001 | 1544 | 79 |
234228 | 234228 | 2020-06-13 | Kent | Delaware | 10001 | 1554 | 82 |
237335 | 237335 | 2020-06-14 | Kent | Delaware | 10001 | 1557 | 83 |
240443 | 240443 | 2020-06-15 | Kent | Delaware | 10001 | 1565 | 83 |
243554 | 243554 | 2020-06-16 | Kent | Delaware | 10001 | 1573 | 84 |
246667 | 246667 | 2020-06-17 | Kent | Delaware | 10001 | 1579 | 84 |
249779 | 249779 | 2020-06-18 | Kent | Delaware | 10001 | 1584 | 84 |
252894 | 252894 | 2020-06-19 | Kent | Delaware | 10001 | 1602 | 84 |
256013 | 256013 | 2020-06-20 | Kent | Delaware | 10001 | 1606 | 84 |
259140 | 259140 | 2020-06-21 | Kent | Delaware | 10001 | 1613 | 84 |
262267 | 262267 | 2020-06-22 | Kent | Delaware | 10001 | 1620 | 84 |
265395 | 265395 | 2020-06-23 | Kent | Delaware | 10001 | 1624 | 89 |
268525 | 268525 | 2020-06-24 | Kent | Delaware | 10001 | 1628 | 89 |
271661 | 271661 | 2020-06-25 | Kent | Delaware | 10001 | 1630 | 89 |
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);