ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 17021 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417740 | 1417740 | 2021-06-14 | Christian | Illinois | 17021 | 3836 | 93 |
1414494 | 1414494 | 2021-06-13 | Christian | Illinois | 17021 | 3836 | 93 |
1411249 | 1411249 | 2021-06-12 | Christian | Illinois | 17021 | 3836 | 93 |
1408004 | 1408004 | 2021-06-11 | Christian | Illinois | 17021 | 3835 | 93 |
1404758 | 1404758 | 2021-06-10 | Christian | Illinois | 17021 | 3834 | 93 |
1401513 | 1401513 | 2021-06-09 | Christian | Illinois | 17021 | 3834 | 93 |
1398268 | 1398268 | 2021-06-08 | Christian | Illinois | 17021 | 3834 | 93 |
1395021 | 1395021 | 2021-06-07 | Christian | Illinois | 17021 | 3833 | 92 |
1391776 | 1391776 | 2021-06-06 | Christian | Illinois | 17021 | 3832 | 92 |
1388531 | 1388531 | 2021-06-05 | Christian | Illinois | 17021 | 3832 | 92 |
1385286 | 1385286 | 2021-06-04 | Christian | Illinois | 17021 | 3832 | 92 |
1382040 | 1382040 | 2021-06-03 | Christian | Illinois | 17021 | 3831 | 91 |
1378795 | 1378795 | 2021-06-02 | Christian | Illinois | 17021 | 3830 | 91 |
1375549 | 1375549 | 2021-06-01 | Christian | Illinois | 17021 | 3820 | 91 |
1372304 | 1372304 | 2021-05-31 | Christian | Illinois | 17021 | 3802 | 91 |
1369059 | 1369059 | 2021-05-30 | Christian | Illinois | 17021 | 3795 | 91 |
1365813 | 1365813 | 2021-05-29 | Christian | Illinois | 17021 | 3793 | 91 |
1362567 | 1362567 | 2021-05-28 | Christian | Illinois | 17021 | 3784 | 91 |
1359320 | 1359320 | 2021-05-27 | Christian | Illinois | 17021 | 3770 | 91 |
1356074 | 1356074 | 2021-05-26 | Christian | Illinois | 17021 | 3756 | 91 |
1352828 | 1352828 | 2021-05-25 | Christian | Illinois | 17021 | 3749 | 91 |
1349582 | 1349582 | 2021-05-24 | Christian | Illinois | 17021 | 3744 | 91 |
1346335 | 1346335 | 2021-05-23 | Christian | Illinois | 17021 | 3742 | 91 |
1343087 | 1343087 | 2021-05-22 | Christian | Illinois | 17021 | 3736 | 91 |
1339839 | 1339839 | 2021-05-21 | Christian | Illinois | 17021 | 3723 | 91 |
1336592 | 1336592 | 2021-05-20 | Christian | Illinois | 17021 | 3707 | 91 |
1333345 | 1333345 | 2021-05-19 | Christian | Illinois | 17021 | 3702 | 91 |
1330098 | 1330098 | 2021-05-18 | Christian | Illinois | 17021 | 3694 | 91 |
1326851 | 1326851 | 2021-05-17 | Christian | Illinois | 17021 | 3686 | 91 |
1323605 | 1323605 | 2021-05-16 | Christian | Illinois | 17021 | 3679 | 91 |
1320359 | 1320359 | 2021-05-15 | Christian | Illinois | 17021 | 3677 | 91 |
1317112 | 1317112 | 2021-05-14 | Christian | Illinois | 17021 | 3667 | 91 |
1313865 | 1313865 | 2021-05-13 | Christian | Illinois | 17021 | 3659 | 91 |
1310618 | 1310618 | 2021-05-12 | Christian | Illinois | 17021 | 3657 | 91 |
1307372 | 1307372 | 2021-05-11 | Christian | Illinois | 17021 | 3650 | 91 |
1304126 | 1304126 | 2021-05-10 | Christian | Illinois | 17021 | 3646 | 91 |
1300879 | 1300879 | 2021-05-09 | Christian | Illinois | 17021 | 3644 | 91 |
1297632 | 1297632 | 2021-05-08 | Christian | Illinois | 17021 | 3640 | 91 |
1294386 | 1294386 | 2021-05-07 | Christian | Illinois | 17021 | 3636 | 91 |
1291140 | 1291140 | 2021-05-06 | Christian | Illinois | 17021 | 3630 | 91 |
1287894 | 1287894 | 2021-05-05 | Christian | Illinois | 17021 | 3625 | 91 |
1284648 | 1284648 | 2021-05-04 | Christian | Illinois | 17021 | 3620 | 91 |
1281401 | 1281401 | 2021-05-03 | Christian | Illinois | 17021 | 3615 | 91 |
1278154 | 1278154 | 2021-05-02 | Christian | Illinois | 17021 | 3610 | 91 |
1274907 | 1274907 | 2021-05-01 | Christian | Illinois | 17021 | 3601 | 91 |
1271660 | 1271660 | 2021-04-30 | Christian | Illinois | 17021 | 3596 | 91 |
1268413 | 1268413 | 2021-04-29 | Christian | Illinois | 17021 | 3578 | 90 |
1265166 | 1265166 | 2021-04-28 | Christian | Illinois | 17021 | 3576 | 90 |
1261919 | 1261919 | 2021-04-27 | Christian | Illinois | 17021 | 3560 | 90 |
1258672 | 1258672 | 2021-04-26 | Christian | Illinois | 17021 | 3554 | 90 |
1255425 | 1255425 | 2021-04-25 | Christian | Illinois | 17021 | 3551 | 90 |
1252178 | 1252178 | 2021-04-24 | Christian | Illinois | 17021 | 3542 | 90 |
1248931 | 1248931 | 2021-04-23 | Christian | Illinois | 17021 | 3540 | 90 |
1245684 | 1245684 | 2021-04-22 | Christian | Illinois | 17021 | 3531 | 90 |
1242437 | 1242437 | 2021-04-21 | Christian | Illinois | 17021 | 3527 | 90 |
1239190 | 1239190 | 2021-04-20 | Christian | Illinois | 17021 | 3521 | 90 |
1235943 | 1235943 | 2021-04-19 | Christian | Illinois | 17021 | 3514 | 90 |
1232696 | 1232696 | 2021-04-18 | Christian | Illinois | 17021 | 3511 | 90 |
1229447 | 1229447 | 2021-04-17 | Christian | Illinois | 17021 | 3511 | 90 |
1226199 | 1226199 | 2021-04-16 | Christian | Illinois | 17021 | 3504 | 90 |
1222952 | 1222952 | 2021-04-15 | Christian | Illinois | 17021 | 3497 | 90 |
1219704 | 1219704 | 2021-04-14 | Christian | Illinois | 17021 | 3489 | 89 |
1216456 | 1216456 | 2021-04-13 | Christian | Illinois | 17021 | 3483 | 89 |
1213209 | 1213209 | 2021-04-12 | Christian | Illinois | 17021 | 3475 | 89 |
1209961 | 1209961 | 2021-04-11 | Christian | Illinois | 17021 | 3470 | 89 |
1206712 | 1206712 | 2021-04-10 | Christian | Illinois | 17021 | 3468 | 89 |
1203464 | 1203464 | 2021-04-09 | Christian | Illinois | 17021 | 3457 | 89 |
1200216 | 1200216 | 2021-04-08 | Christian | Illinois | 17021 | 3447 | 89 |
1196967 | 1196967 | 2021-04-07 | Christian | Illinois | 17021 | 3440 | 89 |
1193719 | 1193719 | 2021-04-06 | Christian | Illinois | 17021 | 3433 | 89 |
1190469 | 1190469 | 2021-04-05 | Christian | Illinois | 17021 | 3426 | 89 |
1187222 | 1187222 | 2021-04-04 | Christian | Illinois | 17021 | 3425 | 89 |
1183975 | 1183975 | 2021-04-03 | Christian | Illinois | 17021 | 3424 | 89 |
1180728 | 1180728 | 2021-04-02 | Christian | Illinois | 17021 | 3422 | 89 |
1177481 | 1177481 | 2021-04-01 | Christian | Illinois | 17021 | 3417 | 89 |
1174234 | 1174234 | 2021-03-31 | Christian | Illinois | 17021 | 3411 | 89 |
1170987 | 1170987 | 2021-03-30 | Christian | Illinois | 17021 | 3405 | 89 |
1167739 | 1167739 | 2021-03-29 | Christian | Illinois | 17021 | 3400 | 89 |
1164491 | 1164491 | 2021-03-28 | Christian | Illinois | 17021 | 3398 | 89 |
1161243 | 1161243 | 2021-03-27 | Christian | Illinois | 17021 | 3397 | 89 |
1157995 | 1157995 | 2021-03-26 | Christian | Illinois | 17021 | 3395 | 89 |
1154748 | 1154748 | 2021-03-25 | Christian | Illinois | 17021 | 3393 | 89 |
1151501 | 1151501 | 2021-03-24 | Christian | Illinois | 17021 | 3389 | 89 |
1148254 | 1148254 | 2021-03-23 | Christian | Illinois | 17021 | 3386 | 89 |
1145007 | 1145007 | 2021-03-22 | Christian | Illinois | 17021 | 3380 | 89 |
1141760 | 1141760 | 2021-03-21 | Christian | Illinois | 17021 | 3377 | 89 |
1138514 | 1138514 | 2021-03-20 | Christian | Illinois | 17021 | 3376 | 89 |
1135268 | 1135268 | 2021-03-19 | Christian | Illinois | 17021 | 3375 | 89 |
1132021 | 1132021 | 2021-03-18 | Christian | Illinois | 17021 | 3372 | 89 |
1128773 | 1128773 | 2021-03-17 | Christian | Illinois | 17021 | 3364 | 89 |
1125527 | 1125527 | 2021-03-16 | Christian | Illinois | 17021 | 3360 | 89 |
1122281 | 1122281 | 2021-03-15 | Christian | Illinois | 17021 | 3359 | 89 |
1119034 | 1119034 | 2021-03-14 | Christian | Illinois | 17021 | 3357 | 89 |
1115787 | 1115787 | 2021-03-13 | Christian | Illinois | 17021 | 3355 | 89 |
1112541 | 1112541 | 2021-03-12 | Christian | Illinois | 17021 | 3353 | 89 |
1109295 | 1109295 | 2021-03-11 | Christian | Illinois | 17021 | 3353 | 89 |
1106049 | 1106049 | 2021-03-10 | Christian | Illinois | 17021 | 3346 | 89 |
1102803 | 1102803 | 2021-03-09 | Christian | Illinois | 17021 | 3343 | 88 |
1099557 | 1099557 | 2021-03-08 | Christian | Illinois | 17021 | 3341 | 88 |
1096309 | 1096309 | 2021-03-07 | Christian | Illinois | 17021 | 3336 | 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);