ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where cases = 66 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
749108 | 749108 | 2020-11-20 | Pope | Illinois | 17151 | 66 | 1 |
745862 | 745862 | 2020-11-19 | Pope | Illinois | 17151 | 66 | 1 |
742615 | 742615 | 2020-11-18 | Pope | Illinois | 17151 | 66 | 1 |
703645 | 703645 | 2020-11-06 | Hardin | Illinois | 17069 | 66 | 0 |
677670 | 677670 | 2020-10-29 | Calhoun | Illinois | 17013 | 66 | 0 |
671185 | 671185 | 2020-10-27 | Calhoun | Illinois | 17013 | 66 | 0 |
667942 | 667942 | 2020-10-26 | Calhoun | Illinois | 17013 | 66 | 0 |
664698 | 664698 | 2020-10-25 | Calhoun | Illinois | 17013 | 66 | 0 |
632244 | 632244 | 2020-10-15 | Calhoun | Illinois | 17013 | 66 | 0 |
629000 | 629000 | 2020-10-14 | Calhoun | Illinois | 17013 | 66 | 0 |
625757 | 625757 | 2020-10-13 | Calhoun | Illinois | 17013 | 66 | 0 |
622515 | 622515 | 2020-10-12 | Calhoun | Illinois | 17013 | 66 | 0 |
619271 | 619271 | 2020-10-11 | Calhoun | Illinois | 17013 | 66 | 0 |
616029 | 616029 | 2020-10-10 | Calhoun | Illinois | 17013 | 66 | 0 |
612788 | 612788 | 2020-10-09 | Calhoun | Illinois | 17013 | 66 | 0 |
609546 | 609546 | 2020-10-08 | Calhoun | Illinois | 17013 | 66 | 0 |
606303 | 606303 | 2020-10-07 | Calhoun | Illinois | 17013 | 66 | 0 |
603061 | 603061 | 2020-10-06 | Calhoun | Illinois | 17013 | 66 | 0 |
599818 | 599818 | 2020-10-05 | Calhoun | Illinois | 17013 | 66 | 0 |
596576 | 596576 | 2020-10-04 | Calhoun | Illinois | 17013 | 66 | 0 |
596647 | 596647 | 2020-10-04 | Putnam | Illinois | 17155 | 66 | 0 |
593334 | 593334 | 2020-10-03 | Calhoun | Illinois | 17013 | 66 | 0 |
580390 | 580390 | 2020-09-29 | Edwards | Illinois | 17047 | 66 | 0 |
573919 | 573919 | 2020-09-27 | Henderson | Illinois | 17071 | 66 | 0 |
570676 | 570676 | 2020-09-26 | Henderson | Illinois | 17071 | 66 | 0 |
567434 | 567434 | 2020-09-25 | Henderson | Illinois | 17071 | 66 | 0 |
564194 | 564194 | 2020-09-24 | Henderson | Illinois | 17071 | 66 | 0 |
541578 | 541578 | 2020-09-17 | Scott | Illinois | 17171 | 66 | 0 |
496285 | 496285 | 2020-09-03 | Richland | Illinois | 17159 | 66 | 3 |
493051 | 493051 | 2020-09-02 | Richland | Illinois | 17159 | 66 | 3 |
473645 | 473645 | 2020-08-27 | Pike | Illinois | 17149 | 66 | 0 |
451028 | 451028 | 2020-08-20 | Mason | Illinois | 17125 | 66 | 0 |
438079 | 438079 | 2020-08-16 | Cumberland | Illinois | 17035 | 66 | 3 |
438101 | 438101 | 2020-08-16 | Jasper | Illinois | 17079 | 66 | 7 |
431684 | 431684 | 2020-08-14 | Piatt | Illinois | 17147 | 66 | 0 |
428413 | 428413 | 2020-08-13 | Greene | Illinois | 17061 | 66 | 0 |
425189 | 425189 | 2020-08-12 | Greene | Illinois | 17061 | 66 | 0 |
425255 | 425255 | 2020-08-12 | Wayne | Illinois | 17191 | 66 | 2 |
422034 | 422034 | 2020-08-11 | Wayne | Illinois | 17191 | 66 | 2 |
415519 | 415519 | 2020-08-09 | Fayette | Illinois | 17051 | 66 | 3 |
415589 | 415589 | 2020-08-09 | Washington | Illinois | 17189 | 66 | 0 |
412317 | 412317 | 2020-08-08 | Johnson | Illinois | 17087 | 66 | 0 |
412369 | 412369 | 2020-08-08 | Washington | Illinois | 17189 | 66 | 0 |
409098 | 409098 | 2020-08-07 | Johnson | Illinois | 17087 | 66 | 0 |
405878 | 405878 | 2020-08-06 | Johnson | Illinois | 17087 | 66 | 0 |
402686 | 402686 | 2020-08-05 | Moultrie | Illinois | 17139 | 66 | 0 |
392980 | 392980 | 2020-08-02 | Clark | Illinois | 17023 | 66 | 0 |
389763 | 389763 | 2020-08-01 | Clark | Illinois | 17023 | 66 | 0 |
386546 | 386546 | 2020-07-31 | Clark | Illinois | 17023 | 66 | 0 |
364091 | 364091 | 2020-07-24 | Livingston | Illinois | 17105 | 66 | 2 |
354527 | 354527 | 2020-07-21 | Woodford | Illinois | 17203 | 66 | 3 |
351265 | 351265 | 2020-07-20 | Jo Daviess | Illinois | 17085 | 66 | 1 |
351325 | 351325 | 2020-07-20 | Woodford | Illinois | 17203 | 66 | 3 |
338446 | 338446 | 2020-07-16 | Douglas | Illinois | 17041 | 66 | 0 |
319359 | 319359 | 2020-07-10 | Macoupin | Illinois | 17117 | 66 | 3 |
294028 | 294028 | 2020-07-02 | Marion | Illinois | 17121 | 66 | 0 |
290874 | 290874 | 2020-07-01 | Marion | Illinois | 17121 | 66 | 0 |
290908 | 290908 | 2020-07-01 | Vermilion | Illinois | 17183 | 66 | 2 |
284609 | 284609 | 2020-06-29 | Vermilion | Illinois | 17183 | 66 | 2 |
262616 | 262616 | 2020-06-22 | Pulaski | Illinois | 17153 | 66 | 0 |
259489 | 259489 | 2020-06-21 | Pulaski | Illinois | 17153 | 66 | 0 |
256363 | 256363 | 2020-06-20 | Pulaski | Illinois | 17153 | 66 | 0 |
191388 | 191388 | 2020-05-30 | Williamson | Illinois | 17199 | 66 | 1 |
173017 | 173017 | 2020-05-24 | Henry | Illinois | 17073 | 66 | 0 |
169976 | 169976 | 2020-05-23 | Henry | Illinois | 17073 | 66 | 0 |
166991 | 166991 | 2020-05-22 | Tazewell | Illinois | 17179 | 66 | 4 |
157825 | 157825 | 2020-05-19 | Cass | Illinois | 17017 | 66 | 0 |
142785 | 142785 | 2020-05-14 | Cass | Illinois | 17017 | 66 | 0 |
43825 | 43825 | 2020-04-09 | Winnebago | Illinois | 17201 | 66 | 3 |
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);