ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 17133 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417796 | 1417796 | 2021-06-14 | Monroe | Illinois | 17133 | 4380 | 94 |
1414550 | 1414550 | 2021-06-13 | Monroe | Illinois | 17133 | 4380 | 94 |
1411305 | 1411305 | 2021-06-12 | Monroe | Illinois | 17133 | 4380 | 94 |
1408060 | 1408060 | 2021-06-11 | Monroe | Illinois | 17133 | 4379 | 94 |
1404814 | 1404814 | 2021-06-10 | Monroe | Illinois | 17133 | 4378 | 94 |
1401569 | 1401569 | 2021-06-09 | Monroe | Illinois | 17133 | 4378 | 94 |
1398324 | 1398324 | 2021-06-08 | Monroe | Illinois | 17133 | 4378 | 94 |
1395077 | 1395077 | 2021-06-07 | Monroe | Illinois | 17133 | 4377 | 94 |
1391832 | 1391832 | 2021-06-06 | Monroe | Illinois | 17133 | 4377 | 94 |
1388587 | 1388587 | 2021-06-05 | Monroe | Illinois | 17133 | 4376 | 94 |
1385342 | 1385342 | 2021-06-04 | Monroe | Illinois | 17133 | 4376 | 94 |
1382096 | 1382096 | 2021-06-03 | Monroe | Illinois | 17133 | 4375 | 94 |
1378851 | 1378851 | 2021-06-02 | Monroe | Illinois | 17133 | 4374 | 94 |
1375605 | 1375605 | 2021-06-01 | Monroe | Illinois | 17133 | 4373 | 94 |
1372360 | 1372360 | 2021-05-31 | Monroe | Illinois | 17133 | 4373 | 94 |
1369115 | 1369115 | 2021-05-30 | Monroe | Illinois | 17133 | 4373 | 94 |
1365869 | 1365869 | 2021-05-29 | Monroe | Illinois | 17133 | 4372 | 94 |
1362623 | 1362623 | 2021-05-28 | Monroe | Illinois | 17133 | 4370 | 94 |
1359376 | 1359376 | 2021-05-27 | Monroe | Illinois | 17133 | 4368 | 94 |
1356130 | 1356130 | 2021-05-26 | Monroe | Illinois | 17133 | 4364 | 94 |
1352884 | 1352884 | 2021-05-25 | Monroe | Illinois | 17133 | 4363 | 94 |
1349638 | 1349638 | 2021-05-24 | Monroe | Illinois | 17133 | 4362 | 94 |
1346391 | 1346391 | 2021-05-23 | Monroe | Illinois | 17133 | 4362 | 94 |
1343143 | 1343143 | 2021-05-22 | Monroe | Illinois | 17133 | 4360 | 93 |
1339895 | 1339895 | 2021-05-21 | Monroe | Illinois | 17133 | 4359 | 93 |
1336648 | 1336648 | 2021-05-20 | Monroe | Illinois | 17133 | 4359 | 93 |
1333401 | 1333401 | 2021-05-19 | Monroe | Illinois | 17133 | 4359 | 93 |
1330154 | 1330154 | 2021-05-18 | Monroe | Illinois | 17133 | 4358 | 93 |
1326907 | 1326907 | 2021-05-17 | Monroe | Illinois | 17133 | 4357 | 93 |
1323661 | 1323661 | 2021-05-16 | Monroe | Illinois | 17133 | 4357 | 93 |
1320415 | 1320415 | 2021-05-15 | Monroe | Illinois | 17133 | 4356 | 93 |
1317168 | 1317168 | 2021-05-14 | Monroe | Illinois | 17133 | 4357 | 93 |
1313921 | 1313921 | 2021-05-13 | Monroe | Illinois | 17133 | 4357 | 93 |
1310674 | 1310674 | 2021-05-12 | Monroe | Illinois | 17133 | 4356 | 93 |
1307428 | 1307428 | 2021-05-11 | Monroe | Illinois | 17133 | 4355 | 93 |
1304182 | 1304182 | 2021-05-10 | Monroe | Illinois | 17133 | 4355 | 93 |
1300935 | 1300935 | 2021-05-09 | Monroe | Illinois | 17133 | 4355 | 93 |
1297688 | 1297688 | 2021-05-08 | Monroe | Illinois | 17133 | 4354 | 93 |
1294442 | 1294442 | 2021-05-07 | Monroe | Illinois | 17133 | 4350 | 93 |
1291196 | 1291196 | 2021-05-06 | Monroe | Illinois | 17133 | 4350 | 92 |
1287950 | 1287950 | 2021-05-05 | Monroe | Illinois | 17133 | 4348 | 92 |
1284704 | 1284704 | 2021-05-04 | Monroe | Illinois | 17133 | 4347 | 91 |
1281457 | 1281457 | 2021-05-03 | Monroe | Illinois | 17133 | 4346 | 91 |
1278210 | 1278210 | 2021-05-02 | Monroe | Illinois | 17133 | 4344 | 91 |
1274963 | 1274963 | 2021-05-01 | Monroe | Illinois | 17133 | 4343 | 91 |
1271716 | 1271716 | 2021-04-30 | Monroe | Illinois | 17133 | 4340 | 91 |
1268469 | 1268469 | 2021-04-29 | Monroe | Illinois | 17133 | 4333 | 91 |
1265222 | 1265222 | 2021-04-28 | Monroe | Illinois | 17133 | 4332 | 91 |
1261975 | 1261975 | 2021-04-27 | Monroe | Illinois | 17133 | 4329 | 90 |
1258728 | 1258728 | 2021-04-26 | Monroe | Illinois | 17133 | 4327 | 90 |
1255481 | 1255481 | 2021-04-25 | Monroe | Illinois | 17133 | 4325 | 90 |
1252234 | 1252234 | 2021-04-24 | Monroe | Illinois | 17133 | 4323 | 90 |
1248987 | 1248987 | 2021-04-23 | Monroe | Illinois | 17133 | 4321 | 90 |
1245740 | 1245740 | 2021-04-22 | Monroe | Illinois | 17133 | 4319 | 90 |
1242493 | 1242493 | 2021-04-21 | Monroe | Illinois | 17133 | 4317 | 90 |
1239246 | 1239246 | 2021-04-20 | Monroe | Illinois | 17133 | 4314 | 90 |
1235999 | 1235999 | 2021-04-19 | Monroe | Illinois | 17133 | 4312 | 90 |
1232752 | 1232752 | 2021-04-18 | Monroe | Illinois | 17133 | 4312 | 90 |
1229503 | 1229503 | 2021-04-17 | Monroe | Illinois | 17133 | 4310 | 90 |
1226255 | 1226255 | 2021-04-16 | Monroe | Illinois | 17133 | 4309 | 90 |
1223008 | 1223008 | 2021-04-15 | Monroe | Illinois | 17133 | 4305 | 90 |
1219760 | 1219760 | 2021-04-14 | Monroe | Illinois | 17133 | 4301 | 90 |
1216512 | 1216512 | 2021-04-13 | Monroe | Illinois | 17133 | 4296 | 90 |
1213265 | 1213265 | 2021-04-12 | Monroe | Illinois | 17133 | 4288 | 90 |
1210017 | 1210017 | 2021-04-11 | Monroe | Illinois | 17133 | 4282 | 90 |
1206768 | 1206768 | 2021-04-10 | Monroe | Illinois | 17133 | 4280 | 90 |
1203520 | 1203520 | 2021-04-09 | Monroe | Illinois | 17133 | 4269 | 90 |
1200272 | 1200272 | 2021-04-08 | Monroe | Illinois | 17133 | 4263 | 90 |
1197023 | 1197023 | 2021-04-07 | Monroe | Illinois | 17133 | 4241 | 90 |
1193775 | 1193775 | 2021-04-06 | Monroe | Illinois | 17133 | 4232 | 90 |
1190525 | 1190525 | 2021-04-05 | Monroe | Illinois | 17133 | 4227 | 90 |
1187278 | 1187278 | 2021-04-04 | Monroe | Illinois | 17133 | 4225 | 90 |
1184031 | 1184031 | 2021-04-03 | Monroe | Illinois | 17133 | 4220 | 90 |
1180784 | 1180784 | 2021-04-02 | Monroe | Illinois | 17133 | 4217 | 90 |
1177537 | 1177537 | 2021-04-01 | Monroe | Illinois | 17133 | 4212 | 90 |
1174290 | 1174290 | 2021-03-31 | Monroe | Illinois | 17133 | 4202 | 90 |
1171043 | 1171043 | 2021-03-30 | Monroe | Illinois | 17133 | 4197 | 90 |
1167795 | 1167795 | 2021-03-29 | Monroe | Illinois | 17133 | 4191 | 90 |
1164547 | 1164547 | 2021-03-28 | Monroe | Illinois | 17133 | 4190 | 90 |
1161299 | 1161299 | 2021-03-27 | Monroe | Illinois | 17133 | 4187 | 90 |
1158051 | 1158051 | 2021-03-26 | Monroe | Illinois | 17133 | 4177 | 89 |
1154804 | 1154804 | 2021-03-25 | Monroe | Illinois | 17133 | 4171 | 89 |
1151557 | 1151557 | 2021-03-24 | Monroe | Illinois | 17133 | 4167 | 89 |
1148310 | 1148310 | 2021-03-23 | Monroe | Illinois | 17133 | 4160 | 89 |
1145063 | 1145063 | 2021-03-22 | Monroe | Illinois | 17133 | 4155 | 89 |
1141816 | 1141816 | 2021-03-21 | Monroe | Illinois | 17133 | 4155 | 89 |
1138570 | 1138570 | 2021-03-20 | Monroe | Illinois | 17133 | 4153 | 89 |
1135324 | 1135324 | 2021-03-19 | Monroe | Illinois | 17133 | 4148 | 89 |
1132077 | 1132077 | 2021-03-18 | Monroe | Illinois | 17133 | 4141 | 89 |
1128829 | 1128829 | 2021-03-17 | Monroe | Illinois | 17133 | 4135 | 89 |
1125583 | 1125583 | 2021-03-16 | Monroe | Illinois | 17133 | 4131 | 89 |
1122337 | 1122337 | 2021-03-15 | Monroe | Illinois | 17133 | 4120 | 89 |
1119090 | 1119090 | 2021-03-14 | Monroe | Illinois | 17133 | 4116 | 89 |
1115843 | 1115843 | 2021-03-13 | Monroe | Illinois | 17133 | 4116 | 89 |
1112597 | 1112597 | 2021-03-12 | Monroe | Illinois | 17133 | 4112 | 89 |
1109351 | 1109351 | 2021-03-11 | Monroe | Illinois | 17133 | 4105 | 89 |
1106105 | 1106105 | 2021-03-10 | Monroe | Illinois | 17133 | 4099 | 89 |
1102859 | 1102859 | 2021-03-09 | Monroe | Illinois | 17133 | 4095 | 89 |
1099613 | 1099613 | 2021-03-08 | Monroe | Illinois | 17133 | 4091 | 88 |
1096365 | 1096365 | 2021-03-07 | Monroe | Illinois | 17133 | 4092 | 87 |
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);