ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 38 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
655033 | 655033 | 2020-10-22 | Pope | Illinois | 17151 | 38 | 1 |
541571 | 541571 | 2020-09-17 | Putnam | Illinois | 17155 | 38 | 0 |
538340 | 538340 | 2020-09-16 | Schuyler | Illinois | 17169 | 38 | 0 |
505994 | 505994 | 2020-09-06 | Stark | Illinois | 17175 | 38 | 1 |
480060 | 480060 | 2020-08-29 | Edwards | Illinois | 17047 | 38 | 0 |
470357 | 470357 | 2020-08-26 | De Witt | Illinois | 17039 | 38 | 1 |
463899 | 463899 | 2020-08-24 | De Witt | Illinois | 17039 | 38 | 1 |
447759 | 447759 | 2020-08-19 | De Witt | Illinois | 17039 | 38 | 0 |
444530 | 444530 | 2020-08-18 | Crawford | Illinois | 17033 | 38 | 0 |
444532 | 444532 | 2020-08-18 | De Witt | Illinois | 17039 | 38 | 0 |
444546 | 444546 | 2020-08-18 | Hamilton | Illinois | 17065 | 38 | 0 |
444588 | 444588 | 2020-08-18 | Pike | Illinois | 17149 | 38 | 0 |
441300 | 441300 | 2020-08-17 | Clay | Illinois | 17025 | 38 | 0 |
441306 | 441306 | 2020-08-17 | De Witt | Illinois | 17039 | 38 | 0 |
409085 | 409085 | 2020-08-07 | Greene | Illinois | 17061 | 38 | 0 |
386561 | 386561 | 2020-07-31 | Ford | Illinois | 17053 | 38 | 1 |
383343 | 383343 | 2020-07-30 | Ford | Illinois | 17053 | 38 | 1 |
380126 | 380126 | 2020-07-29 | Ford | Illinois | 17053 | 38 | 1 |
376909 | 376909 | 2020-07-28 | Ford | Illinois | 17053 | 38 | 1 |
376933 | 376933 | 2020-07-28 | Lawrence | Illinois | 17101 | 38 | 0 |
370458 | 370458 | 2020-07-26 | Bond | Illinois | 17005 | 38 | 2 |
370541 | 370541 | 2020-07-26 | Shelby | Illinois | 17173 | 38 | 1 |
364136 | 364136 | 2020-07-24 | White | Illinois | 17193 | 38 | 0 |
354490 | 354490 | 2020-07-21 | Mercer | Illinois | 17131 | 38 | 0 |
351248 | 351248 | 2020-07-20 | Fayette | Illinois | 17051 | 38 | 3 |
348066 | 348066 | 2020-07-19 | Johnson | Illinois | 17087 | 38 | 0 |
341646 | 341646 | 2020-07-17 | Effingham | Illinois | 17049 | 38 | 1 |
328855 | 328855 | 2020-07-13 | Bureau | Illinois | 17011 | 38 | 2 |
316172 | 316172 | 2020-07-09 | Jersey | Illinois | 17083 | 38 | 1 |
309889 | 309889 | 2020-07-07 | Woodford | Illinois | 17203 | 38 | 2 |
303480 | 303480 | 2020-07-05 | Ford | Illinois | 17053 | 38 | 1 |
265710 | 265710 | 2020-06-23 | Jo Daviess | Illinois | 17085 | 38 | 1 |
265720 | 265720 | 2020-06-23 | Livingston | Illinois | 17105 | 38 | 2 |
262582 | 262582 | 2020-06-22 | Jo Daviess | Illinois | 17085 | 38 | 1 |
259455 | 259455 | 2020-06-21 | Jo Daviess | Illinois | 17085 | 38 | 1 |
256329 | 256329 | 2020-06-20 | Jo Daviess | Illinois | 17085 | 38 | 1 |
243847 | 243847 | 2020-06-16 | Douglas | Illinois | 17041 | 38 | 0 |
240736 | 240736 | 2020-06-15 | Douglas | Illinois | 17041 | 38 | 0 |
237628 | 237628 | 2020-06-14 | Douglas | Illinois | 17041 | 38 | 0 |
200568 | 200568 | 2020-06-02 | Morgan | Illinois | 17137 | 38 | 1 |
185257 | 185257 | 2020-05-28 | Vermilion | Illinois | 17183 | 38 | 1 |
170007 | 170007 | 2020-05-23 | Montgomery | Illinois | 17135 | 38 | 0 |
166970 | 166970 | 2020-05-22 | Montgomery | Illinois | 17135 | 38 | 0 |
163937 | 163937 | 2020-05-21 | Montgomery | Illinois | 17135 | 38 | 0 |
151855 | 151855 | 2020-05-17 | Montgomery | Illinois | 17135 | 38 | 0 |
148851 | 148851 | 2020-05-16 | Perry | Illinois | 17145 | 38 | 0 |
145848 | 145848 | 2020-05-15 | Perry | Illinois | 17145 | 38 | 0 |
142848 | 142848 | 2020-05-14 | Perry | Illinois | 17145 | 38 | 0 |
139852 | 139852 | 2020-05-13 | Perry | Illinois | 17145 | 38 | 0 |
136860 | 136860 | 2020-05-12 | Perry | Illinois | 17145 | 38 | 0 |
133871 | 133871 | 2020-05-11 | Perry | Illinois | 17145 | 38 | 0 |
130863 | 130863 | 2020-05-10 | Macoupin | Illinois | 17117 | 38 | 1 |
130880 | 130880 | 2020-05-10 | Perry | Illinois | 17145 | 38 | 0 |
127872 | 127872 | 2020-05-09 | Macoupin | Illinois | 17117 | 38 | 1 |
124885 | 124885 | 2020-05-08 | Macoupin | Illinois | 17117 | 38 | 1 |
118938 | 118938 | 2020-05-06 | Marion | Illinois | 17121 | 38 | 0 |
110200 | 110200 | 2020-05-03 | Iroquois | Illinois | 17075 | 38 | 0 |
95913 | 95913 | 2020-04-28 | Henry | Illinois | 17073 | 38 | 0 |
95963 | 95963 | 2020-04-28 | Tazewell | Illinois | 17179 | 38 | 3 |
79055 | 79055 | 2020-04-22 | LaSalle | Illinois | 17099 | 38 | 1 |
57022 | 57022 | 2020-04-14 | Clinton | Illinois | 17027 | 38 | 0 |
54329 | 54329 | 2020-04-13 | Clinton | Illinois | 17027 | 38 | 0 |
20136 | 20136 | 2020-03-30 | Kankakee | Illinois | 17091 | 38 | 0 |
18134 | 18134 | 2020-03-29 | Kankakee | Illinois | 17091 | 38 | 0 |
11205 | 11205 | 2020-03-25 | Kane | Illinois | 17089 | 38 | 1 |
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);