ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 463 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1404777 | 1404777 | 2021-06-10 | Gallatin | Illinois | 17059 | 463 | 5 |
1401532 | 1401532 | 2021-06-09 | Gallatin | Illinois | 17059 | 463 | 5 |
1398287 | 1398287 | 2021-06-08 | Gallatin | Illinois | 17059 | 463 | 5 |
1395040 | 1395040 | 2021-06-07 | Gallatin | Illinois | 17059 | 463 | 5 |
1391795 | 1391795 | 2021-06-06 | Gallatin | Illinois | 17059 | 463 | 5 |
1388550 | 1388550 | 2021-06-05 | Gallatin | Illinois | 17059 | 463 | 5 |
1385305 | 1385305 | 2021-06-04 | Gallatin | Illinois | 17059 | 463 | 5 |
1382059 | 1382059 | 2021-06-03 | Gallatin | Illinois | 17059 | 463 | 5 |
1268404 | 1268404 | 2021-04-29 | Alexander | Illinois | 17003 | 463 | 11 |
1268480 | 1268480 | 2021-04-29 | Putnam | Illinois | 17155 | 463 | 4 |
1265157 | 1265157 | 2021-04-28 | Alexander | Illinois | 17003 | 463 | 11 |
1261910 | 1261910 | 2021-04-27 | Alexander | Illinois | 17003 | 463 | 11 |
1258663 | 1258663 | 2021-04-26 | Alexander | Illinois | 17003 | 463 | 11 |
1255416 | 1255416 | 2021-04-25 | Alexander | Illinois | 17003 | 463 | 11 |
1252169 | 1252169 | 2021-04-24 | Alexander | Illinois | 17003 | 463 | 11 |
1248922 | 1248922 | 2021-04-23 | Alexander | Illinois | 17003 | 463 | 11 |
775062 | 775062 | 2020-11-28 | Menard | Illinois | 17129 | 463 | 1 |
667944 | 667944 | 2020-10-26 | Cass | Illinois | 17017 | 463 | 11 |
632319 | 632319 | 2020-10-15 | Saline | Illinois | 17165 | 463 | 7 |
596595 | 596595 | 2020-10-04 | Fayette | Illinois | 17051 | 463 | 8 |
564169 | 564169 | 2020-09-24 | Christian | Illinois | 17021 | 463 | 12 |
551295 | 551295 | 2020-09-20 | Stephenson | Illinois | 17177 | 463 | 6 |
515610 | 515610 | 2020-09-09 | Bureau | Illinois | 17011 | 463 | 9 |
493012 | 493012 | 2020-09-02 | Jefferson | Illinois | 17081 | 463 | 35 |
383365 | 383365 | 2020-07-30 | LaSalle | Illinois | 17099 | 463 | 18 |
364077 | 364077 | 2020-07-24 | Jackson | Illinois | 17077 | 463 | 19 |
275148 | 275148 | 2020-06-26 | Peoria | Illinois | 17143 | 463 | 27 |
197430 | 197430 | 2020-06-01 | Boone | Illinois | 17007 | 463 | 17 |
59755 | 59755 | 2020-04-15 | Kane | Illinois | 17089 | 463 | 24 |
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);