ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Winnebago" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1391867 | 1391867 | 2021-06-06 | Winnebago | Illinois | 17201 | 33979 | 529 |
1388622 | 1388622 | 2021-06-05 | Winnebago | Illinois | 17201 | 33951 | 527 |
1385377 | 1385377 | 2021-06-04 | Winnebago | Illinois | 17201 | 33934 | 526 |
1382131 | 1382131 | 2021-06-03 | Winnebago | Illinois | 17201 | 33926 | 524 |
1378886 | 1378886 | 2021-06-02 | Winnebago | Illinois | 17201 | 33901 | 523 |
1375640 | 1375640 | 2021-06-01 | Winnebago | Illinois | 17201 | 33893 | 523 |
1372395 | 1372395 | 2021-05-31 | Winnebago | Illinois | 17201 | 33883 | 523 |
1369150 | 1369150 | 2021-05-30 | Winnebago | Illinois | 17201 | 33866 | 523 |
1365904 | 1365904 | 2021-05-29 | Winnebago | Illinois | 17201 | 33843 | 522 |
1362658 | 1362658 | 2021-05-28 | Winnebago | Illinois | 17201 | 33793 | 520 |
1359411 | 1359411 | 2021-05-27 | Winnebago | Illinois | 17201 | 33752 | 519 |
1356165 | 1356165 | 2021-05-26 | Winnebago | Illinois | 17201 | 33704 | 517 |
1352919 | 1352919 | 2021-05-25 | Winnebago | Illinois | 17201 | 33680 | 516 |
1349673 | 1349673 | 2021-05-24 | Winnebago | Illinois | 17201 | 33657 | 516 |
1346426 | 1346426 | 2021-05-23 | Winnebago | Illinois | 17201 | 33634 | 516 |
1343178 | 1343178 | 2021-05-22 | Winnebago | Illinois | 17201 | 33597 | 516 |
1339930 | 1339930 | 2021-05-21 | Winnebago | Illinois | 17201 | 33575 | 515 |
1336683 | 1336683 | 2021-05-20 | Winnebago | Illinois | 17201 | 33526 | 513 |
1333436 | 1333436 | 2021-05-19 | Winnebago | Illinois | 17201 | 33483 | 509 |
1330189 | 1330189 | 2021-05-18 | Winnebago | Illinois | 17201 | 33426 | 508 |
1326942 | 1326942 | 2021-05-17 | Winnebago | Illinois | 17201 | 33393 | 507 |
1323696 | 1323696 | 2021-05-16 | Winnebago | Illinois | 17201 | 33359 | 507 |
1320450 | 1320450 | 2021-05-15 | Winnebago | Illinois | 17201 | 33296 | 505 |
1317203 | 1317203 | 2021-05-14 | Winnebago | Illinois | 17201 | 33247 | 505 |
1313956 | 1313956 | 2021-05-13 | Winnebago | Illinois | 17201 | 33178 | 504 |
1310709 | 1310709 | 2021-05-12 | Winnebago | Illinois | 17201 | 33136 | 503 |
1307463 | 1307463 | 2021-05-11 | Winnebago | Illinois | 17201 | 33017 | 502 |
1304217 | 1304217 | 2021-05-10 | Winnebago | Illinois | 17201 | 32961 | 502 |
1300970 | 1300970 | 2021-05-09 | Winnebago | Illinois | 17201 | 32927 | 502 |
1297723 | 1297723 | 2021-05-08 | Winnebago | Illinois | 17201 | 32863 | 500 |
1294477 | 1294477 | 2021-05-07 | Winnebago | Illinois | 17201 | 32808 | 500 |
1291231 | 1291231 | 2021-05-06 | Winnebago | Illinois | 17201 | 32697 | 500 |
1287985 | 1287985 | 2021-05-05 | Winnebago | Illinois | 17201 | 32619 | 499 |
1284739 | 1284739 | 2021-05-04 | Winnebago | Illinois | 17201 | 32526 | 499 |
1281492 | 1281492 | 2021-05-03 | Winnebago | Illinois | 17201 | 32465 | 499 |
1278245 | 1278245 | 2021-05-02 | Winnebago | Illinois | 17201 | 32381 | 499 |
1274998 | 1274998 | 2021-05-01 | Winnebago | Illinois | 17201 | 32302 | 498 |
1271751 | 1271751 | 2021-04-30 | Winnebago | Illinois | 17201 | 32195 | 497 |
1268504 | 1268504 | 2021-04-29 | Winnebago | Illinois | 17201 | 32069 | 495 |
1265257 | 1265257 | 2021-04-28 | Winnebago | Illinois | 17201 | 31947 | 493 |
1262010 | 1262010 | 2021-04-27 | Winnebago | Illinois | 17201 | 31815 | 491 |
1258763 | 1258763 | 2021-04-26 | Winnebago | Illinois | 17201 | 31746 | 491 |
1255516 | 1255516 | 2021-04-25 | Winnebago | Illinois | 17201 | 31670 | 490 |
1252269 | 1252269 | 2021-04-24 | Winnebago | Illinois | 17201 | 31592 | 490 |
1249022 | 1249022 | 2021-04-23 | Winnebago | Illinois | 17201 | 31518 | 490 |
1245775 | 1245775 | 2021-04-22 | Winnebago | Illinois | 17201 | 31421 | 490 |
1242528 | 1242528 | 2021-04-21 | Winnebago | Illinois | 17201 | 31341 | 490 |
1239281 | 1239281 | 2021-04-20 | Winnebago | Illinois | 17201 | 31230 | 489 |
1236034 | 1236034 | 2021-04-19 | Winnebago | Illinois | 17201 | 31173 | 489 |
1232787 | 1232787 | 2021-04-18 | Winnebago | Illinois | 17201 | 31102 | 488 |
1229538 | 1229538 | 2021-04-17 | Winnebago | Illinois | 17201 | 30947 | 488 |
1226290 | 1226290 | 2021-04-16 | Winnebago | Illinois | 17201 | 30845 | 488 |
1223043 | 1223043 | 2021-04-15 | Winnebago | Illinois | 17201 | 30711 | 488 |
1219795 | 1219795 | 2021-04-14 | Winnebago | Illinois | 17201 | 30606 | 487 |
1216547 | 1216547 | 2021-04-13 | Winnebago | Illinois | 17201 | 30463 | 487 |
1213300 | 1213300 | 2021-04-12 | Winnebago | Illinois | 17201 | 30380 | 487 |
1210052 | 1210052 | 2021-04-11 | Winnebago | Illinois | 17201 | 30308 | 487 |
1206803 | 1206803 | 2021-04-10 | Winnebago | Illinois | 17201 | 30151 | 487 |
1203555 | 1203555 | 2021-04-09 | Winnebago | Illinois | 17201 | 30076 | 487 |
1200307 | 1200307 | 2021-04-08 | Winnebago | Illinois | 17201 | 29940 | 487 |
1197058 | 1197058 | 2021-04-07 | Winnebago | Illinois | 17201 | 29843 | 487 |
1193810 | 1193810 | 2021-04-06 | Winnebago | Illinois | 17201 | 29737 | 486 |
1190560 | 1190560 | 2021-04-05 | Winnebago | Illinois | 17201 | 29669 | 485 |
1187313 | 1187313 | 2021-04-04 | Winnebago | Illinois | 17201 | 29618 | 485 |
1184066 | 1184066 | 2021-04-03 | Winnebago | Illinois | 17201 | 29495 | 485 |
1180819 | 1180819 | 2021-04-02 | Winnebago | Illinois | 17201 | 29443 | 484 |
1177572 | 1177572 | 2021-04-01 | Winnebago | Illinois | 17201 | 29362 | 484 |
1174325 | 1174325 | 2021-03-31 | Winnebago | Illinois | 17201 | 29299 | 482 |
1171078 | 1171078 | 2021-03-30 | Winnebago | Illinois | 17201 | 29216 | 482 |
1167830 | 1167830 | 2021-03-29 | Winnebago | Illinois | 17201 | 29165 | 482 |
1164582 | 1164582 | 2021-03-28 | Winnebago | Illinois | 17201 | 29129 | 482 |
1161334 | 1161334 | 2021-03-27 | Winnebago | Illinois | 17201 | 29068 | 482 |
1158086 | 1158086 | 2021-03-26 | Winnebago | Illinois | 17201 | 29020 | 481 |
1154839 | 1154839 | 2021-03-25 | Winnebago | Illinois | 17201 | 28956 | 481 |
1151592 | 1151592 | 2021-03-24 | Winnebago | Illinois | 17201 | 28926 | 480 |
1148345 | 1148345 | 2021-03-23 | Winnebago | Illinois | 17201 | 28877 | 478 |
1145098 | 1145098 | 2021-03-22 | Winnebago | Illinois | 17201 | 28857 | 478 |
1141851 | 1141851 | 2021-03-21 | Winnebago | Illinois | 17201 | 28840 | 478 |
1138605 | 1138605 | 2021-03-20 | Winnebago | Illinois | 17201 | 28796 | 478 |
1135359 | 1135359 | 2021-03-19 | Winnebago | Illinois | 17201 | 28768 | 478 |
1132112 | 1132112 | 2021-03-18 | Winnebago | Illinois | 17201 | 28714 | 478 |
1128864 | 1128864 | 2021-03-17 | Winnebago | Illinois | 17201 | 28674 | 478 |
1125618 | 1125618 | 2021-03-16 | Winnebago | Illinois | 17201 | 28650 | 477 |
1122372 | 1122372 | 2021-03-15 | Winnebago | Illinois | 17201 | 28631 | 476 |
1119125 | 1119125 | 2021-03-14 | Winnebago | Illinois | 17201 | 28612 | 476 |
1115878 | 1115878 | 2021-03-13 | Winnebago | Illinois | 17201 | 28579 | 476 |
1112632 | 1112632 | 2021-03-12 | Winnebago | Illinois | 17201 | 28548 | 475 |
1109386 | 1109386 | 2021-03-11 | Winnebago | Illinois | 17201 | 28523 | 473 |
1106140 | 1106140 | 2021-03-10 | Winnebago | Illinois | 17201 | 28502 | 474 |
1102894 | 1102894 | 2021-03-09 | Winnebago | Illinois | 17201 | 28474 | 474 |
1099648 | 1099648 | 2021-03-08 | Winnebago | Illinois | 17201 | 28477 | 473 |
1096400 | 1096400 | 2021-03-07 | Winnebago | Illinois | 17201 | 28470 | 474 |
1093154 | 1093154 | 2021-03-06 | Winnebago | Illinois | 17201 | 28447 | 474 |
1089908 | 1089908 | 2021-03-05 | Winnebago | Illinois | 17201 | 28430 | 474 |
1086663 | 1086663 | 2021-03-04 | Winnebago | Illinois | 17201 | 28407 | 473 |
1083417 | 1083417 | 2021-03-03 | Winnebago | Illinois | 17201 | 28380 | 472 |
1080171 | 1080171 | 2021-03-02 | Winnebago | Illinois | 17201 | 28357 | 470 |
1076926 | 1076926 | 2021-03-01 | Winnebago | Illinois | 17201 | 28351 | 470 |
1073680 | 1073680 | 2021-02-28 | Winnebago | Illinois | 17201 | 28340 | 469 |
1070434 | 1070434 | 2021-02-27 | Winnebago | Illinois | 17201 | 28319 | 468 |
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);