ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 106 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
693965 | 693965 | 2020-11-03 | Schuyler | Illinois | 17169 | 106 | 1 |
664776 | 664776 | 2020-10-25 | Scott | Illinois | 17171 | 106 | 0 |
661476 | 661476 | 2020-10-24 | Gallatin | Illinois | 17059 | 106 | 2 |
658232 | 658232 | 2020-10-23 | Gallatin | Illinois | 17059 | 106 | 2 |
654987 | 654987 | 2020-10-22 | Gallatin | Illinois | 17059 | 106 | 2 |
651742 | 651742 | 2020-10-21 | Gallatin | Illinois | 17059 | 106 | 2 |
638762 | 638762 | 2020-10-17 | Hamilton | Illinois | 17065 | 106 | 2 |
573910 | 573910 | 2020-09-27 | Ford | Illinois | 17053 | 106 | 5 |
564219 | 564219 | 2020-09-24 | Massac | Illinois | 17127 | 106 | 2 |
496271 | 496271 | 2020-09-03 | Mercer | Illinois | 17131 | 106 | 5 |
483364 | 483364 | 2020-08-30 | Wabash | Illinois | 17185 | 106 | 1 |
473666 | 473666 | 2020-08-27 | Washington | Illinois | 17189 | 106 | 1 |
463957 | 463957 | 2020-08-24 | Pulaski | Illinois | 17153 | 106 | 1 |
451002 | 451002 | 2020-08-20 | Hancock | Illinois | 17067 | 106 | 1 |
409108 | 409108 | 2020-08-07 | Logan | Illinois | 17107 | 106 | 0 |
405855 | 405855 | 2020-08-06 | Douglas | Illinois | 17041 | 106 | 2 |
380142 | 380142 | 2020-07-29 | Jo Daviess | Illinois | 17085 | 106 | 1 |
373695 | 373695 | 2020-07-27 | Franklin | Illinois | 17055 | 106 | 0 |
367301 | 367301 | 2020-07-25 | Macoupin | Illinois | 17117 | 106 | 3 |
351290 | 351290 | 2020-07-20 | Montgomery | Illinois | 17135 | 106 | 1 |
348090 | 348090 | 2020-07-19 | Montgomery | Illinois | 17135 | 106 | 1 |
322544 | 322544 | 2020-07-11 | McDonough | Illinois | 17109 | 106 | 15 |
319340 | 319340 | 2020-07-10 | Henry | Illinois | 17073 | 106 | 1 |
300330 | 300330 | 2020-07-04 | Jefferson | Illinois | 17081 | 106 | 17 |
297128 | 297128 | 2020-07-03 | Adams | Illinois | 17001 | 106 | 1 |
297168 | 297168 | 2020-07-03 | Jefferson | Illinois | 17081 | 106 | 17 |
281413 | 281413 | 2020-06-28 | Jefferson | Illinois | 17081 | 106 | 17 |
278265 | 278265 | 2020-06-27 | Jefferson | Illinois | 17081 | 106 | 17 |
278324 | 278324 | 2020-06-27 | Williamson | Illinois | 17199 | 106 | 4 |
240784 | 240784 | 2020-06-15 | Morgan | Illinois | 17137 | 106 | 2 |
237676 | 237676 | 2020-06-14 | Morgan | Illinois | 17137 | 106 | 2 |
231461 | 231461 | 2020-06-12 | Monroe | Illinois | 17133 | 106 | 12 |
225237 | 225237 | 2020-06-10 | Knox | Illinois | 17095 | 106 | 0 |
148871 | 148871 | 2020-05-16 | Warren | Illinois | 17187 | 106 | 0 |
136836 | 136836 | 2020-05-12 | LaSalle | Illinois | 17099 | 106 | 5 |
136879 | 136879 | 2020-05-12 | Warren | Illinois | 17187 | 106 | 0 |
110234 | 110234 | 2020-05-03 | Peoria | Illinois | 17143 | 106 | 3 |
101587 | 101587 | 2020-04-30 | Clinton | Illinois | 17027 | 106 | 3 |
101626 | 101626 | 2020-04-30 | Macon | Illinois | 17115 | 106 | 12 |
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);