ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 64 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
739368 | 739368 | 2020-11-17 | Pope | Illinois | 17151 | 64 | 1 |
674427 | 674427 | 2020-10-28 | Calhoun | Illinois | 17013 | 64 | 0 |
622596 | 622596 | 2020-10-12 | Stark | Illinois | 17175 | 64 | 2 |
609623 | 609623 | 2020-10-08 | Schuyler | Illinois | 17169 | 64 | 1 |
593405 | 593405 | 2020-10-03 | Putnam | Illinois | 17155 | 64 | 0 |
590164 | 590164 | 2020-10-02 | Putnam | Illinois | 17155 | 64 | 0 |
586852 | 586852 | 2020-10-01 | Calhoun | Illinois | 17013 | 64 | 0 |
586923 | 586923 | 2020-10-01 | Putnam | Illinois | 17155 | 64 | 0 |
577149 | 577149 | 2020-09-28 | Edwards | Illinois | 17047 | 64 | 0 |
567422 | 567422 | 2020-09-25 | Edwards | Illinois | 17047 | 64 | 0 |
564182 | 564182 | 2020-09-24 | Edwards | Illinois | 17047 | 64 | 0 |
560942 | 560942 | 2020-09-23 | Edwards | Illinois | 17047 | 64 | 0 |
560954 | 560954 | 2020-09-23 | Henderson | Illinois | 17071 | 64 | 0 |
541495 | 541495 | 2020-09-17 | Alexander | Illinois | 17003 | 64 | 1 |
522095 | 522095 | 2020-09-11 | De Witt | Illinois | 17039 | 64 | 1 |
496235 | 496235 | 2020-09-03 | Gallatin | Illinois | 17059 | 64 | 2 |
493001 | 493001 | 2020-09-02 | Gallatin | Illinois | 17059 | 64 | 2 |
476864 | 476864 | 2020-08-28 | Massac | Illinois | 17127 | 64 | 1 |
470413 | 470413 | 2020-08-26 | Pike | Illinois | 17149 | 64 | 0 |
444573 | 444573 | 2020-08-18 | Mason | Illinois | 17125 | 64 | 0 |
434875 | 434875 | 2020-08-15 | Jasper | Illinois | 17079 | 64 | 7 |
425161 | 425161 | 2020-08-12 | Bond | Illinois | 17005 | 64 | 3 |
425166 | 425166 | 2020-08-12 | Carroll | Illinois | 17015 | 64 | 4 |
425232 | 425232 | 2020-08-12 | Piatt | Illinois | 17147 | 64 | 0 |
409150 | 409150 | 2020-08-07 | Washington | Illinois | 17189 | 64 | 0 |
409152 | 409152 | 2020-08-07 | White | Illinois | 17193 | 64 | 0 |
405932 | 405932 | 2020-08-06 | White | Illinois | 17193 | 64 | 0 |
364092 | 364092 | 2020-07-24 | Logan | Illinois | 17107 | 64 | 0 |
360913 | 360913 | 2020-07-23 | Saline | Illinois | 17165 | 64 | 0 |
348065 | 348065 | 2020-07-19 | Jo Daviess | Illinois | 17085 | 64 | 1 |
348125 | 348125 | 2020-07-19 | Woodford | Illinois | 17203 | 64 | 3 |
316198 | 316198 | 2020-07-09 | Montgomery | Illinois | 17135 | 64 | 0 |
188323 | 188323 | 2020-05-29 | Williamson | Illinois | 17199 | 64 | 2 |
160878 | 160878 | 2020-05-20 | Henry | Illinois | 17073 | 64 | 0 |
157904 | 157904 | 2020-05-19 | Tazewell | Illinois | 17179 | 64 | 4 |
154809 | 154809 | 2020-05-18 | Cass | Illinois | 17017 | 64 | 0 |
154861 | 154861 | 2020-05-18 | McDonough | Illinois | 17109 | 64 | 2 |
151797 | 151797 | 2020-05-17 | Cass | Illinois | 17017 | 64 | 0 |
151824 | 151824 | 2020-05-17 | Henry | Illinois | 17073 | 64 | 0 |
151849 | 151849 | 2020-05-17 | McDonough | Illinois | 17109 | 64 | 2 |
148815 | 148815 | 2020-05-16 | Henry | Illinois | 17073 | 64 | 0 |
145812 | 145812 | 2020-05-15 | Henry | Illinois | 17073 | 64 | 0 |
136798 | 136798 | 2020-05-12 | Cass | Illinois | 17017 | 64 | 0 |
93111 | 93111 | 2020-04-27 | Monroe | Illinois | 17133 | 64 | 10 |
90292 | 90292 | 2020-04-26 | Monroe | Illinois | 17133 | 64 | 10 |
73526 | 73526 | 2020-04-20 | Sangamon | Illinois | 17167 | 64 | 5 |
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);