ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 24 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
538332 | 538332 | 2020-09-16 | Pope | Illinois | 17151 | 24 | 1 |
535096 | 535096 | 2020-09-15 | Pope | Illinois | 17151 | 24 | 1 |
522111 | 522111 | 2020-09-11 | Hardin | Illinois | 17069 | 24 | 0 |
518874 | 518874 | 2020-09-10 | Hardin | Illinois | 17069 | 24 | 0 |
509143 | 509143 | 2020-09-07 | Brown | Illinois | 17009 | 24 | 0 |
505911 | 505911 | 2020-09-06 | Brown | Illinois | 17009 | 24 | 0 |
502677 | 502677 | 2020-09-05 | Brown | Illinois | 17009 | 24 | 0 |
499443 | 499443 | 2020-09-04 | Brown | Illinois | 17009 | 24 | 0 |
493055 | 493055 | 2020-09-02 | Schuyler | Illinois | 17169 | 24 | 0 |
489826 | 489826 | 2020-09-01 | Stark | Illinois | 17175 | 24 | 0 |
486593 | 486593 | 2020-08-31 | Stark | Illinois | 17175 | 24 | 0 |
467116 | 467116 | 2020-08-25 | Calhoun | Illinois | 17013 | 24 | 0 |
447776 | 447776 | 2020-08-19 | Henderson | Illinois | 17071 | 24 | 0 |
444549 | 444549 | 2020-08-18 | Henderson | Illinois | 17071 | 24 | 0 |
441323 | 441323 | 2020-08-17 | Henderson | Illinois | 17071 | 24 | 0 |
431634 | 431634 | 2020-08-14 | Edwards | Illinois | 17047 | 24 | 0 |
431690 | 431690 | 2020-08-14 | Richland | Illinois | 17159 | 24 | 0 |
428406 | 428406 | 2020-08-13 | Edwards | Illinois | 17047 | 24 | 0 |
428462 | 428462 | 2020-08-13 | Richland | Illinois | 17159 | 24 | 0 |
425182 | 425182 | 2020-08-12 | Edwards | Illinois | 17047 | 24 | 0 |
422012 | 422012 | 2020-08-11 | Pike | Illinois | 17149 | 24 | 0 |
409113 | 409113 | 2020-08-07 | Marshall | Illinois | 17123 | 24 | 0 |
386563 | 386563 | 2020-07-31 | Fulton | Illinois | 17057 | 24 | 0 |
380128 | 380128 | 2020-07-29 | Fulton | Illinois | 17057 | 24 | 0 |
376911 | 376911 | 2020-07-28 | Fulton | Illinois | 17057 | 24 | 0 |
373690 | 373690 | 2020-07-27 | Edgar | Illinois | 17045 | 24 | 0 |
373696 | 373696 | 2020-07-27 | Fulton | Illinois | 17057 | 24 | 0 |
370478 | 370478 | 2020-07-26 | Edgar | Illinois | 17045 | 24 | 0 |
370484 | 370484 | 2020-07-26 | Fulton | Illinois | 17057 | 24 | 0 |
367264 | 367264 | 2020-07-25 | De Witt | Illinois | 17039 | 24 | 0 |
367268 | 367268 | 2020-07-25 | Edgar | Illinois | 17045 | 24 | 0 |
364057 | 364057 | 2020-07-24 | De Witt | Illinois | 17039 | 24 | 0 |
364061 | 364061 | 2020-07-24 | Edgar | Illinois | 17045 | 24 | 0 |
360850 | 360850 | 2020-07-23 | De Witt | Illinois | 17039 | 24 | 0 |
357634 | 357634 | 2020-07-22 | Carroll | Illinois | 17015 | 24 | 2 |
357645 | 357645 | 2020-07-22 | De Witt | Illinois | 17039 | 24 | 0 |
357687 | 357687 | 2020-07-22 | Massac | Illinois | 17127 | 24 | 0 |
354432 | 354432 | 2020-07-21 | Carroll | Illinois | 17015 | 24 | 2 |
354443 | 354443 | 2020-07-21 | De Witt | Illinois | 17039 | 24 | 0 |
354518 | 354518 | 2020-07-21 | Wabash | Illinois | 17185 | 24 | 0 |
348039 | 348039 | 2020-07-19 | Crawford | Illinois | 17033 | 24 | 0 |
344824 | 344824 | 2020-07-18 | Bond | Illinois | 17005 | 24 | 2 |
344829 | 344829 | 2020-07-18 | Carroll | Illinois | 17015 | 24 | 2 |
344919 | 344919 | 2020-07-18 | White | Illinois | 17193 | 24 | 0 |
341624 | 341624 | 2020-07-17 | Bond | Illinois | 17005 | 24 | 2 |
341695 | 341695 | 2020-07-17 | Piatt | Illinois | 17147 | 24 | 0 |
341719 | 341719 | 2020-07-17 | White | Illinois | 17193 | 24 | 0 |
338511 | 338511 | 2020-07-16 | Shelby | Illinois | 17173 | 24 | 1 |
332090 | 332090 | 2020-07-14 | Logan | Illinois | 17107 | 24 | 0 |
328919 | 328919 | 2020-07-13 | Moultrie | Illinois | 17139 | 24 | 0 |
325689 | 325689 | 2020-07-12 | Fayette | Illinois | 17051 | 24 | 3 |
325723 | 325723 | 2020-07-12 | Mason | Illinois | 17125 | 24 | 0 |
325733 | 325733 | 2020-07-12 | Moultrie | Illinois | 17139 | 24 | 0 |
322484 | 322484 | 2020-07-11 | Alexander | Illinois | 17003 | 24 | 0 |
322508 | 322508 | 2020-07-11 | Fayette | Illinois | 17051 | 24 | 3 |
322542 | 322542 | 2020-07-11 | Mason | Illinois | 17125 | 24 | 0 |
322552 | 322552 | 2020-07-11 | Moultrie | Illinois | 17139 | 24 | 0 |
319347 | 319347 | 2020-07-10 | Johnson | Illinois | 17087 | 24 | 0 |
319363 | 319363 | 2020-07-10 | Mason | Illinois | 17125 | 24 | 0 |
316148 | 316148 | 2020-07-09 | Cumberland | Illinois | 17035 | 24 | 0 |
312974 | 312974 | 2020-07-08 | Cumberland | Illinois | 17035 | 24 | 0 |
312982 | 312982 | 2020-07-08 | Fayette | Illinois | 17051 | 24 | 3 |
309882 | 309882 | 2020-07-07 | Washington | Illinois | 17189 | 24 | 0 |
303518 | 303518 | 2020-07-05 | Menard | Illinois | 17129 | 24 | 0 |
300354 | 300354 | 2020-07-04 | Menard | Illinois | 17129 | 24 | 0 |
297192 | 297192 | 2020-07-03 | Menard | Illinois | 17129 | 24 | 0 |
284582 | 284582 | 2020-06-29 | Menard | Illinois | 17129 | 24 | 0 |
281437 | 281437 | 2020-06-28 | Menard | Illinois | 17129 | 24 | 0 |
278230 | 278230 | 2020-06-27 | Bureau | Illinois | 17011 | 24 | 1 |
278289 | 278289 | 2020-06-27 | Menard | Illinois | 17129 | 24 | 0 |
275082 | 275082 | 2020-06-26 | Bureau | Illinois | 17011 | 24 | 1 |
271940 | 271940 | 2020-06-25 | Bureau | Illinois | 17011 | 24 | 1 |
268803 | 268803 | 2020-06-24 | Bureau | Illinois | 17011 | 24 | 1 |
265673 | 265673 | 2020-06-23 | Bureau | Illinois | 17011 | 24 | 1 |
262545 | 262545 | 2020-06-22 | Bureau | Illinois | 17011 | 24 | 1 |
259418 | 259418 | 2020-06-21 | Bureau | Illinois | 17011 | 24 | 1 |
256292 | 256292 | 2020-06-20 | Bureau | Illinois | 17011 | 24 | 1 |
253172 | 253172 | 2020-06-19 | Bureau | Illinois | 17011 | 24 | 1 |
250057 | 250057 | 2020-06-18 | Bureau | Illinois | 17011 | 24 | 1 |
246945 | 246945 | 2020-06-17 | Bureau | Illinois | 17011 | 24 | 1 |
243832 | 243832 | 2020-06-16 | Bureau | Illinois | 17011 | 24 | 1 |
231496 | 231496 | 2020-06-12 | Woodford | Illinois | 17203 | 24 | 2 |
228393 | 228393 | 2020-06-11 | Woodford | Illinois | 17203 | 24 | 2 |
212863 | 212863 | 2020-06-06 | Jersey | Illinois | 17083 | 24 | 1 |
209778 | 209778 | 2020-06-05 | Jersey | Illinois | 17083 | 24 | 1 |
206697 | 206697 | 2020-06-04 | Jersey | Illinois | 17083 | 24 | 1 |
203617 | 203617 | 2020-06-03 | Jersey | Illinois | 17083 | 24 | 1 |
200541 | 200541 | 2020-06-02 | Jersey | Illinois | 17083 | 24 | 1 |
197468 | 197468 | 2020-06-01 | Jersey | Illinois | 17083 | 24 | 1 |
194398 | 194398 | 2020-05-31 | Jersey | Illinois | 17083 | 24 | 1 |
166945 | 166945 | 2020-05-22 | Jo Daviess | Illinois | 17085 | 24 | 0 |
133851 | 133851 | 2020-05-11 | Livingston | Illinois | 17105 | 24 | 1 |
130824 | 130824 | 2020-05-10 | Coles | Illinois | 17029 | 24 | 1 |
130860 | 130860 | 2020-05-10 | Livingston | Illinois | 17105 | 24 | 1 |
127869 | 127869 | 2020-05-09 | Livingston | Illinois | 17105 | 24 | 1 |
124882 | 124882 | 2020-05-08 | Livingston | Illinois | 17105 | 24 | 1 |
121903 | 121903 | 2020-05-07 | Livingston | Illinois | 17105 | 24 | 1 |
121926 | 121926 | 2020-05-07 | Pulaski | Illinois | 17153 | 24 | 0 |
113106 | 113106 | 2020-05-04 | Morgan | Illinois | 17137 | 24 | 1 |
110215 | 110215 | 2020-05-03 | Livingston | Illinois | 17105 | 24 | 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);