ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 282 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1080145 | 1080145 | 2021-03-02 | Pope | Illinois | 17151 | 282 | 3 |
1076900 | 1076900 | 2021-03-01 | Pope | Illinois | 17151 | 282 | 3 |
1073654 | 1073654 | 2021-02-28 | Pope | Illinois | 17151 | 282 | 3 |
1070408 | 1070408 | 2021-02-27 | Pope | Illinois | 17151 | 282 | 3 |
1067163 | 1067163 | 2021-02-26 | Pope | Illinois | 17151 | 282 | 3 |
1063918 | 1063918 | 2021-02-25 | Pope | Illinois | 17151 | 282 | 3 |
921072 | 921072 | 2021-01-12 | Hardin | Illinois | 17069 | 282 | 8 |
846427 | 846427 | 2020-12-20 | Gallatin | Illinois | 17059 | 282 | 4 |
729590 | 729590 | 2020-11-14 | Hamilton | Illinois | 17065 | 282 | 3 |
684168 | 684168 | 2020-10-31 | De Witt | Illinois | 17039 | 282 | 6 |
684223 | 684223 | 2020-10-31 | Piatt | Illinois | 17147 | 282 | 2 |
680925 | 680925 | 2020-10-30 | De Witt | Illinois | 17039 | 282 | 6 |
680980 | 680980 | 2020-10-30 | Piatt | Illinois | 17147 | 282 | 2 |
612832 | 612832 | 2020-10-09 | Lawrence | Illinois | 17101 | 282 | 6 |
586888 | 586888 | 2020-10-01 | Jo Daviess | Illinois | 17085 | 282 | 2 |
541546 | 541546 | 2020-09-17 | Livingston | Illinois | 17105 | 282 | 5 |
538273 | 538273 | 2020-09-16 | Crawford | Illinois | 17033 | 282 | 1 |
531880 | 531880 | 2020-09-14 | Warren | Illinois | 17187 | 282 | 1 |
528643 | 528643 | 2020-09-13 | Warren | Illinois | 17187 | 282 | 1 |
525407 | 525407 | 2020-09-12 | Warren | Illinois | 17187 | 282 | 1 |
454234 | 454234 | 2020-08-21 | Iroquois | Illinois | 17075 | 282 | 15 |
454289 | 454289 | 2020-08-21 | Vermilion | Illinois | 17183 | 282 | 2 |
447778 | 447778 | 2020-08-19 | Iroquois | Illinois | 17075 | 282 | 14 |
444519 | 444519 | 2020-08-18 | Bureau | Illinois | 17011 | 282 | 4 |
412314 | 412314 | 2020-08-08 | Jefferson | Illinois | 17081 | 282 | 19 |
396216 | 396216 | 2020-08-03 | Grundy | Illinois | 17063 | 282 | 5 |
354479 | 354479 | 2020-07-21 | Macon | Illinois | 17115 | 282 | 22 |
351277 | 351277 | 2020-07-20 | Macon | Illinois | 17115 | 282 | 22 |
319392 | 319392 | 2020-07-10 | Stephenson | Illinois | 17177 | 282 | 6 |
316219 | 316219 | 2020-07-09 | Stephenson | Illinois | 17177 | 282 | 6 |
191328 | 191328 | 2020-05-30 | Jackson | Illinois | 17077 | 282 | 10 |
148783 | 148783 | 2020-05-16 | Boone | Illinois | 17007 | 282 | 14 |
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);