ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 264 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
986020 | 986020 | 2021-02-01 | Pope | Illinois | 17151 | 264 | 3 |
982773 | 982773 | 2021-01-31 | Pope | Illinois | 17151 | 264 | 3 |
979527 | 979527 | 2021-01-30 | Pope | Illinois | 17151 | 264 | 3 |
976282 | 976282 | 2021-01-29 | Pope | Illinois | 17151 | 264 | 3 |
801035 | 801035 | 2020-12-06 | Putnam | Illinois | 17155 | 264 | 0 |
801042 | 801042 | 2020-12-06 | Scott | Illinois | 17171 | 264 | 0 |
797797 | 797797 | 2020-12-05 | Scott | Illinois | 17171 | 264 | 0 |
768591 | 768591 | 2020-11-26 | Schuyler | Illinois | 17169 | 264 | 1 |
723132 | 723132 | 2020-11-12 | Massac | Illinois | 17127 | 264 | 2 |
690732 | 690732 | 2020-11-02 | Wabash | Illinois | 17185 | 264 | 6 |
687487 | 687487 | 2020-11-01 | Wabash | Illinois | 17185 | 264 | 6 |
667954 | 667954 | 2020-10-26 | De Witt | Illinois | 17039 | 264 | 6 |
667975 | 667975 | 2020-10-26 | Jasper | Illinois | 17079 | 264 | 10 |
664731 | 664731 | 2020-10-25 | Jasper | Illinois | 17079 | 264 | 10 |
661544 | 661544 | 2020-10-24 | White | Illinois | 17193 | 264 | 4 |
642007 | 642007 | 2020-10-18 | Greene | Illinois | 17061 | 264 | 15 |
632271 | 632271 | 2020-10-15 | Hancock | Illinois | 17067 | 264 | 3 |
603134 | 603134 | 2020-10-06 | Richland | Illinois | 17159 | 264 | 9 |
564255 | 564255 | 2020-09-24 | Wayne | Illinois | 17191 | 264 | 5 |
512457 | 512457 | 2020-09-08 | Shelby | Illinois | 17173 | 264 | 3 |
499449 | 499449 | 2020-09-04 | Christian | Illinois | 17021 | 264 | 7 |
493066 | 493066 | 2020-09-02 | Warren | Illinois | 17187 | 264 | 1 |
473612 | 473612 | 2020-08-27 | Jersey | Illinois | 17083 | 264 | 3 |
434928 | 434928 | 2020-08-15 | Vermilion | Illinois | 17183 | 264 | 2 |
341635 | 341635 | 2020-07-17 | Clinton | Illinois | 17027 | 264 | 16 |
182191 | 182191 | 2020-05-27 | Randolph | Illinois | 17157 | 264 | 4 |
59773 | 59773 | 2020-04-15 | McHenry | Illinois | 17111 | 264 | 11 |
16238 | 16238 | 2020-03-28 | Lake | Illinois | 17097 | 264 | 2 |
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);