ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 453 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1622327 | 1622327 | 2021-08-16 | Hardin | Illinois | 17069 | 453 | 12 |
1245703 | 1245703 | 2021-04-22 | Gallatin | Illinois | 17059 | 453 | 5 |
1245751 | 1245751 | 2021-04-22 | Putnam | Illinois | 17155 | 453 | 4 |
1242456 | 1242456 | 2021-04-21 | Gallatin | Illinois | 17059 | 453 | 5 |
1239209 | 1239209 | 2021-04-20 | Gallatin | Illinois | 17059 | 453 | 5 |
1235962 | 1235962 | 2021-04-19 | Gallatin | Illinois | 17059 | 453 | 5 |
1232715 | 1232715 | 2021-04-18 | Gallatin | Illinois | 17059 | 453 | 5 |
1229466 | 1229466 | 2021-04-17 | Gallatin | Illinois | 17059 | 453 | 5 |
1226218 | 1226218 | 2021-04-16 | Gallatin | Illinois | 17059 | 453 | 5 |
1222971 | 1222971 | 2021-04-15 | Gallatin | Illinois | 17059 | 453 | 5 |
1219723 | 1219723 | 2021-04-14 | Gallatin | Illinois | 17059 | 453 | 5 |
1216475 | 1216475 | 2021-04-13 | Gallatin | Illinois | 17059 | 453 | 5 |
1213228 | 1213228 | 2021-04-12 | Gallatin | Illinois | 17059 | 453 | 5 |
1209980 | 1209980 | 2021-04-11 | Gallatin | Illinois | 17059 | 453 | 5 |
1148245 | 1148245 | 2021-03-23 | Alexander | Illinois | 17003 | 453 | 10 |
1148328 | 1148328 | 2021-03-23 | Scott | Illinois | 17171 | 453 | 1 |
1144998 | 1144998 | 2021-03-22 | Alexander | Illinois | 17003 | 453 | 10 |
1145081 | 1145081 | 2021-03-22 | Scott | Illinois | 17171 | 453 | 1 |
1141751 | 1141751 | 2021-03-21 | Alexander | Illinois | 17003 | 453 | 10 |
1138505 | 1138505 | 2021-03-20 | Alexander | Illinois | 17003 | 453 | 10 |
1135259 | 1135259 | 2021-03-19 | Alexander | Illinois | 17003 | 453 | 10 |
1132012 | 1132012 | 2021-03-18 | Alexander | Illinois | 17003 | 453 | 10 |
1128764 | 1128764 | 2021-03-17 | Alexander | Illinois | 17003 | 453 | 10 |
1125518 | 1125518 | 2021-03-16 | Alexander | Illinois | 17003 | 453 | 10 |
1122272 | 1122272 | 2021-03-15 | Alexander | Illinois | 17003 | 453 | 10 |
1119025 | 1119025 | 2021-03-14 | Alexander | Illinois | 17003 | 453 | 10 |
1115778 | 1115778 | 2021-03-13 | Alexander | Illinois | 17003 | 453 | 10 |
1112532 | 1112532 | 2021-03-12 | Alexander | Illinois | 17003 | 453 | 10 |
1109286 | 1109286 | 2021-03-11 | Alexander | Illinois | 17003 | 453 | 10 |
1106040 | 1106040 | 2021-03-10 | Alexander | Illinois | 17003 | 453 | 9 |
1102794 | 1102794 | 2021-03-09 | Alexander | Illinois | 17003 | 453 | 9 |
1099548 | 1099548 | 2021-03-08 | Alexander | Illinois | 17003 | 453 | 9 |
1096300 | 1096300 | 2021-03-07 | Alexander | Illinois | 17003 | 453 | 9 |
1093054 | 1093054 | 2021-03-06 | Alexander | Illinois | 17003 | 453 | 9 |
1089808 | 1089808 | 2021-03-05 | Alexander | Illinois | 17003 | 453 | 9 |
989198 | 989198 | 2021-02-02 | Calhoun | Illinois | 17013 | 453 | 5 |
985951 | 985951 | 2021-02-01 | Calhoun | Illinois | 17013 | 453 | 5 |
982704 | 982704 | 2021-01-31 | Calhoun | Illinois | 17013 | 453 | 5 |
979458 | 979458 | 2021-01-30 | Calhoun | Illinois | 17013 | 453 | 5 |
976213 | 976213 | 2021-01-29 | Calhoun | Illinois | 17013 | 453 | 5 |
943789 | 943789 | 2021-01-19 | Henderson | Illinois | 17071 | 453 | 16 |
813970 | 813970 | 2020-12-10 | Hamilton | Illinois | 17065 | 453 | 7 |
723089 | 723089 | 2020-11-12 | Cumberland | Illinois | 17035 | 453 | 6 |
716604 | 716604 | 2020-11-10 | De Witt | Illinois | 17039 | 453 | 10 |
677733 | 677733 | 2020-10-29 | Moultrie | Illinois | 17139 | 453 | 6 |
651721 | 651721 | 2020-10-21 | Cass | Illinois | 17017 | 453 | 11 |
642018 | 642018 | 2020-10-18 | Jersey | Illinois | 17083 | 453 | 21 |
590112 | 590112 | 2020-10-02 | Fayette | Illinois | 17051 | 453 | 8 |
557744 | 557744 | 2020-09-22 | McDonough | Illinois | 17109 | 453 | 15 |
544818 | 544818 | 2020-09-18 | Stephenson | Illinois | 17177 | 453 | 6 |
512377 | 512377 | 2020-09-08 | Bureau | Illinois | 17011 | 453 | 9 |
509144 | 509144 | 2020-09-07 | Bureau | Illinois | 17011 | 453 | 9 |
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);