ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 27 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
567474 | 567474 | 2020-09-25 | Pope | Illinois | 17151 | 27 | 1 |
535055 | 535055 | 2020-09-15 | Hardin | Illinois | 17069 | 27 | 0 |
518917 | 518917 | 2020-09-10 | Putnam | Illinois | 17155 | 27 | 0 |
496212 | 496212 | 2020-09-03 | Calhoun | Illinois | 17013 | 27 | 0 |
492978 | 492978 | 2020-09-02 | Calhoun | Illinois | 17013 | 27 | 0 |
441311 | 441311 | 2020-08-17 | Edwards | Illinois | 17047 | 27 | 0 |
425171 | 425171 | 2020-08-12 | Clay | Illinois | 17025 | 27 | 0 |
425243 | 425243 | 2020-08-12 | Scott | Illinois | 17171 | 27 | 0 |
418773 | 418773 | 2020-08-10 | Marshall | Illinois | 17123 | 27 | 0 |
402639 | 402639 | 2020-08-05 | Edgar | Illinois | 17045 | 27 | 0 |
389770 | 389770 | 2020-08-01 | De Witt | Illinois | 17039 | 27 | 0 |
386553 | 386553 | 2020-07-31 | De Witt | Illinois | 17039 | 27 | 0 |
380133 | 380133 | 2020-07-29 | Hancock | Illinois | 17067 | 27 | 1 |
376916 | 376916 | 2020-07-28 | Hancock | Illinois | 17067 | 27 | 1 |
373701 | 373701 | 2020-07-27 | Hancock | Illinois | 17067 | 27 | 1 |
370489 | 370489 | 2020-07-26 | Hancock | Illinois | 17067 | 27 | 1 |
364135 | 364135 | 2020-07-24 | Wayne | Illinois | 17191 | 27 | 1 |
360839 | 360839 | 2020-07-23 | Carroll | Illinois | 17015 | 27 | 2 |
360928 | 360928 | 2020-07-23 | Wayne | Illinois | 17191 | 27 | 1 |
357723 | 357723 | 2020-07-22 | Wayne | Illinois | 17191 | 27 | 1 |
354521 | 354521 | 2020-07-21 | Wayne | Illinois | 17191 | 27 | 1 |
351273 | 351273 | 2020-07-20 | Lawrence | Illinois | 17101 | 27 | 0 |
351319 | 351319 | 2020-07-20 | Wayne | Illinois | 17191 | 27 | 1 |
344907 | 344907 | 2020-07-18 | Shelby | Illinois | 17173 | 27 | 1 |
341707 | 341707 | 2020-07-17 | Shelby | Illinois | 17173 | 27 | 1 |
338427 | 338427 | 2020-07-16 | Alexander | Illinois | 17003 | 27 | 0 |
335283 | 335283 | 2020-07-15 | Logan | Illinois | 17107 | 27 | 0 |
322526 | 322526 | 2020-07-11 | Johnson | Illinois | 17087 | 27 | 0 |
319328 | 319328 | 2020-07-10 | Effingham | Illinois | 17049 | 27 | 1 |
297155 | 297155 | 2020-07-03 | Franklin | Illinois | 17055 | 27 | 0 |
293998 | 293998 | 2020-07-02 | Franklin | Illinois | 17055 | 27 | 0 |
275103 | 275103 | 2020-06-26 | Ford | Illinois | 17053 | 27 | 1 |
225231 | 225231 | 2020-06-10 | Jersey | Illinois | 17083 | 27 | 1 |
191310 | 191310 | 2020-05-30 | Douglas | Illinois | 17041 | 27 | 0 |
179111 | 179111 | 2020-05-26 | Jo Daviess | Illinois | 17085 | 27 | 0 |
176046 | 176046 | 2020-05-25 | Douglas | Illinois | 17041 | 27 | 0 |
176067 | 176067 | 2020-05-25 | Jo Daviess | Illinois | 17085 | 27 | 0 |
169961 | 169961 | 2020-05-23 | Douglas | Illinois | 17041 | 27 | 0 |
166924 | 166924 | 2020-05-22 | Douglas | Illinois | 17041 | 27 | 0 |
157868 | 157868 | 2020-05-19 | Livingston | Illinois | 17105 | 27 | 1 |
154852 | 154852 | 2020-05-18 | Livingston | Illinois | 17105 | 27 | 1 |
136864 | 136864 | 2020-05-12 | Pulaski | Illinois | 17153 | 27 | 0 |
133875 | 133875 | 2020-05-11 | Pulaski | Illinois | 17153 | 27 | 0 |
130884 | 130884 | 2020-05-10 | Pulaski | Illinois | 17153 | 27 | 0 |
127893 | 127893 | 2020-05-09 | Pulaski | Illinois | 17153 | 27 | 0 |
121863 | 121863 | 2020-05-07 | Christian | Illinois | 17021 | 27 | 5 |
121919 | 121919 | 2020-05-07 | Morgan | Illinois | 17137 | 27 | 1 |
107360 | 107360 | 2020-05-02 | Montgomery | Illinois | 17135 | 27 | 0 |
101609 | 101609 | 2020-04-30 | Iroquois | Illinois | 17075 | 27 | 0 |
95887 | 95887 | 2020-04-28 | Cass | Illinois | 17017 | 27 | 0 |
90236 | 90236 | 2020-04-26 | Cass | Illinois | 17017 | 27 | 0 |
84612 | 84612 | 2020-04-24 | Christian | Illinois | 17021 | 27 | 5 |
73459 | 73459 | 2020-04-20 | Christian | Illinois | 17021 | 27 | 5 |
67962 | 67962 | 2020-04-18 | LaSalle | Illinois | 17099 | 27 | 1 |
65213 | 65213 | 2020-04-17 | LaSalle | Illinois | 17099 | 27 | 1 |
59719 | 59719 | 2020-04-15 | Adams | Illinois | 17001 | 27 | 0 |
57012 | 57012 | 2020-04-14 | Adams | Illinois | 17001 | 27 | 0 |
51701 | 51701 | 2020-04-12 | Peoria | Illinois | 17143 | 27 | 1 |
46376 | 46376 | 2020-04-10 | Jackson | Illinois | 17077 | 27 | 2 |
36191 | 36191 | 2020-04-06 | Randolph | Illinois | 17157 | 27 | 0 |
24397 | 24397 | 2020-04-01 | Kendall | Illinois | 17093 | 27 | 2 |
16235 | 16235 | 2020-03-28 | Kankakee | Illinois | 17091 | 27 | 0 |
12769 | 12769 | 2020-03-26 | McHenry | Illinois | 17111 | 27 | 1 |
1443 | 1443 | 2020-03-12 | Cook | Illinois | 17031 | 27 | 0 |
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);