ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 17007 and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
33684 | 33684 | 2020-04-05 | Boone | Illinois | 17007 | 3 | 0 |
36135 | 36135 | 2020-04-06 | Boone | Illinois | 17007 | 4 | 0 |
38629 | 38629 | 2020-04-07 | Boone | Illinois | 17007 | 6 | 0 |
41173 | 41173 | 2020-04-08 | Boone | Illinois | 17007 | 7 | 1 |
43747 | 43747 | 2020-04-09 | Boone | Illinois | 17007 | 7 | 1 |
46349 | 46349 | 2020-04-10 | Boone | Illinois | 17007 | 7 | 1 |
48980 | 48980 | 2020-04-11 | Boone | Illinois | 17007 | 7 | 1 |
51642 | 51642 | 2020-04-12 | Boone | Illinois | 17007 | 11 | 1 |
54322 | 54322 | 2020-04-13 | Boone | Illinois | 17007 | 13 | 1 |
57014 | 57014 | 2020-04-14 | Boone | Illinois | 17007 | 13 | 1 |
59721 | 59721 | 2020-04-15 | Boone | Illinois | 17007 | 16 | 1 |
62442 | 62442 | 2020-04-16 | Boone | Illinois | 17007 | 18 | 1 |
65174 | 65174 | 2020-04-17 | Boone | Illinois | 17007 | 21 | 2 |
67922 | 67922 | 2020-04-18 | Boone | Illinois | 17007 | 29 | 2 |
70684 | 70684 | 2020-04-19 | Boone | Illinois | 17007 | 30 | 2 |
73453 | 73453 | 2020-04-20 | Boone | Illinois | 17007 | 33 | 3 |
76229 | 76229 | 2020-04-21 | Boone | Illinois | 17007 | 35 | 6 |
79013 | 79013 | 2020-04-22 | Boone | Illinois | 17007 | 41 | 6 |
81806 | 81806 | 2020-04-23 | Boone | Illinois | 17007 | 54 | 7 |
84606 | 84606 | 2020-04-24 | Boone | Illinois | 17007 | 60 | 8 |
87416 | 87416 | 2020-04-25 | Boone | Illinois | 17007 | 71 | 8 |
90232 | 90232 | 2020-04-26 | Boone | Illinois | 17007 | 76 | 8 |
93051 | 93051 | 2020-04-27 | Boone | Illinois | 17007 | 79 | 9 |
95883 | 95883 | 2020-04-28 | Boone | Illinois | 17007 | 81 | 9 |
98727 | 98727 | 2020-04-29 | Boone | Illinois | 17007 | 89 | 9 |
101578 | 101578 | 2020-04-30 | Boone | Illinois | 17007 | 98 | 9 |
104433 | 104433 | 2020-05-01 | Boone | Illinois | 17007 | 113 | 9 |
107298 | 107298 | 2020-05-02 | Boone | Illinois | 17007 | 129 | 11 |
110168 | 110168 | 2020-05-03 | Boone | Illinois | 17007 | 138 | 11 |
113043 | 113043 | 2020-05-04 | Boone | Illinois | 17007 | 144 | 11 |
115926 | 115926 | 2020-05-05 | Boone | Illinois | 17007 | 146 | 11 |
118886 | 118886 | 2020-05-06 | Boone | Illinois | 17007 | 155 | 11 |
121856 | 121856 | 2020-05-07 | Boone | Illinois | 17007 | 168 | 11 |
124835 | 124835 | 2020-05-08 | Boone | Illinois | 17007 | 177 | 12 |
127822 | 127822 | 2020-05-09 | Boone | Illinois | 17007 | 185 | 11 |
130813 | 130813 | 2020-05-10 | Boone | Illinois | 17007 | 193 | 11 |
133804 | 133804 | 2020-05-11 | Boone | Illinois | 17007 | 206 | 12 |
136793 | 136793 | 2020-05-12 | Boone | Illinois | 17007 | 244 | 13 |
139784 | 139784 | 2020-05-13 | Boone | Illinois | 17007 | 253 | 13 |
142780 | 142780 | 2020-05-14 | Boone | Illinois | 17007 | 268 | 13 |
145780 | 145780 | 2020-05-15 | Boone | Illinois | 17007 | 274 | 14 |
148783 | 148783 | 2020-05-16 | Boone | Illinois | 17007 | 282 | 14 |
151792 | 151792 | 2020-05-17 | Boone | Illinois | 17007 | 290 | 14 |
154804 | 154804 | 2020-05-18 | Boone | Illinois | 17007 | 307 | 14 |
157820 | 157820 | 2020-05-19 | Boone | Illinois | 17007 | 314 | 14 |
160846 | 160846 | 2020-05-20 | Boone | Illinois | 17007 | 324 | 14 |
163874 | 163874 | 2020-05-21 | Boone | Illinois | 17007 | 343 | 15 |
166907 | 166907 | 2020-05-22 | Boone | Illinois | 17007 | 368 | 16 |
169944 | 169944 | 2020-05-23 | Boone | Illinois | 17007 | 389 | 16 |
172985 | 172985 | 2020-05-24 | Boone | Illinois | 17007 | 393 | 16 |
176029 | 176029 | 2020-05-25 | Boone | Illinois | 17007 | 397 | 16 |
179073 | 179073 | 2020-05-26 | Boone | Illinois | 17007 | 407 | 16 |
182117 | 182117 | 2020-05-27 | Boone | Illinois | 17007 | 410 | 16 |
185171 | 185171 | 2020-05-28 | Boone | Illinois | 17007 | 424 | 16 |
188228 | 188228 | 2020-05-29 | Boone | Illinois | 17007 | 428 | 17 |
191293 | 191293 | 2020-05-30 | Boone | Illinois | 17007 | 441 | 17 |
194360 | 194360 | 2020-05-31 | Boone | Illinois | 17007 | 452 | 17 |
197430 | 197430 | 2020-06-01 | Boone | Illinois | 17007 | 463 | 17 |
200503 | 200503 | 2020-06-02 | Boone | Illinois | 17007 | 476 | 17 |
203579 | 203579 | 2020-06-03 | Boone | Illinois | 17007 | 481 | 17 |
206659 | 206659 | 2020-06-04 | Boone | Illinois | 17007 | 488 | 17 |
209740 | 209740 | 2020-06-05 | Boone | Illinois | 17007 | 498 | 17 |
212825 | 212825 | 2020-06-06 | Boone | Illinois | 17007 | 500 | 18 |
215912 | 215912 | 2020-06-07 | Boone | Illinois | 17007 | 504 | 18 |
219003 | 219003 | 2020-06-08 | Boone | Illinois | 17007 | 506 | 18 |
222098 | 222098 | 2020-06-09 | Boone | Illinois | 17007 | 507 | 18 |
225193 | 225193 | 2020-06-10 | Boone | Illinois | 17007 | 511 | 18 |
228295 | 228295 | 2020-06-11 | Boone | Illinois | 17007 | 515 | 18 |
231398 | 231398 | 2020-06-12 | Boone | Illinois | 17007 | 518 | 18 |
234504 | 234504 | 2020-06-13 | Boone | Illinois | 17007 | 520 | 19 |
237611 | 237611 | 2020-06-14 | Boone | Illinois | 17007 | 524 | 19 |
240719 | 240719 | 2020-06-15 | Boone | Illinois | 17007 | 525 | 19 |
243830 | 243830 | 2020-06-16 | Boone | Illinois | 17007 | 537 | 19 |
246943 | 246943 | 2020-06-17 | Boone | Illinois | 17007 | 542 | 19 |
250055 | 250055 | 2020-06-18 | Boone | Illinois | 17007 | 546 | 19 |
253170 | 253170 | 2020-06-19 | Boone | Illinois | 17007 | 551 | 19 |
256290 | 256290 | 2020-06-20 | Boone | Illinois | 17007 | 554 | 20 |
259416 | 259416 | 2020-06-21 | Boone | Illinois | 17007 | 555 | 20 |
262543 | 262543 | 2020-06-22 | Boone | Illinois | 17007 | 556 | 20 |
265671 | 265671 | 2020-06-23 | Boone | Illinois | 17007 | 562 | 21 |
268801 | 268801 | 2020-06-24 | Boone | Illinois | 17007 | 560 | 21 |
271938 | 271938 | 2020-06-25 | Boone | Illinois | 17007 | 567 | 21 |
275080 | 275080 | 2020-06-26 | Boone | Illinois | 17007 | 568 | 21 |
278228 | 278228 | 2020-06-27 | Boone | Illinois | 17007 | 572 | 21 |
281376 | 281376 | 2020-06-28 | Boone | Illinois | 17007 | 577 | 21 |
284521 | 284521 | 2020-06-29 | Boone | Illinois | 17007 | 579 | 21 |
287670 | 287670 | 2020-06-30 | Boone | Illinois | 17007 | 586 | 21 |
290820 | 290820 | 2020-07-01 | Boone | Illinois | 17007 | 595 | 21 |
293974 | 293974 | 2020-07-02 | Boone | Illinois | 17007 | 595 | 21 |
297131 | 297131 | 2020-07-03 | Boone | Illinois | 17007 | 602 | 21 |
300293 | 300293 | 2020-07-04 | Boone | Illinois | 17007 | 608 | 21 |
303457 | 303457 | 2020-07-05 | Boone | Illinois | 17007 | 608 | 21 |
306622 | 306622 | 2020-07-06 | Boone | Illinois | 17007 | 610 | 21 |
309790 | 309790 | 2020-07-07 | Boone | Illinois | 17007 | 617 | 21 |
312960 | 312960 | 2020-07-08 | Boone | Illinois | 17007 | 623 | 21 |
316134 | 316134 | 2020-07-09 | Boone | Illinois | 17007 | 629 | 21 |
319307 | 319307 | 2020-07-10 | Boone | Illinois | 17007 | 630 | 21 |
322486 | 322486 | 2020-07-11 | Boone | Illinois | 17007 | 635 | 21 |
325667 | 325667 | 2020-07-12 | Boone | Illinois | 17007 | 637 | 21 |
328853 | 328853 | 2020-07-13 | Boone | Illinois | 17007 | 639 | 21 |
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);