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 |
---|---|---|---|---|---|---|---|
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 |
1067189 | 1067189 | 2021-02-26 | Winnebago | Illinois | 17201 | 28297 | 468 |
1063944 | 1063944 | 2021-02-25 | Winnebago | Illinois | 17201 | 28263 | 466 |
1060699 | 1060699 | 2021-02-24 | Winnebago | Illinois | 17201 | 28221 | 464 |
1057453 | 1057453 | 2021-02-23 | Winnebago | Illinois | 17201 | 28194 | 461 |
1054207 | 1054207 | 2021-02-22 | Winnebago | Illinois | 17201 | 28179 | 460 |
1050960 | 1050960 | 2021-02-21 | Winnebago | Illinois | 17201 | 28157 | 460 |
1047713 | 1047713 | 2021-02-20 | Winnebago | Illinois | 17201 | 28132 | 458 |
1044468 | 1044468 | 2021-02-19 | Winnebago | Illinois | 17201 | 28110 | 458 |
1041223 | 1041223 | 2021-02-18 | Winnebago | Illinois | 17201 | 28080 | 458 |
1037978 | 1037978 | 2021-02-17 | Winnebago | Illinois | 17201 | 28026 | 454 |
1034733 | 1034733 | 2021-02-16 | Winnebago | Illinois | 17201 | 27986 | 455 |
1031487 | 1031487 | 2021-02-15 | Winnebago | Illinois | 17201 | 27960 | 455 |
1028240 | 1028240 | 2021-02-14 | Winnebago | Illinois | 17201 | 27940 | 455 |
1024995 | 1024995 | 2021-02-13 | Winnebago | Illinois | 17201 | 27913 | 454 |
1021750 | 1021750 | 2021-02-12 | Winnebago | Illinois | 17201 | 27852 | 452 |
1018505 | 1018505 | 2021-02-11 | Winnebago | Illinois | 17201 | 27788 | 448 |
1015260 | 1015260 | 2021-02-10 | Winnebago | Illinois | 17201 | 27739 | 446 |
1012015 | 1012015 | 2021-02-09 | Winnebago | Illinois | 17201 | 27697 | 442 |
1008769 | 1008769 | 2021-02-08 | Winnebago | Illinois | 17201 | 27671 | 441 |
1005523 | 1005523 | 2021-02-07 | Winnebago | Illinois | 17201 | 27647 | 440 |
1002277 | 1002277 | 2021-02-06 | Winnebago | Illinois | 17201 | 27603 | 436 |
999031 | 999031 | 2021-02-05 | Winnebago | Illinois | 17201 | 27548 | 435 |
995785 | 995785 | 2021-02-04 | Winnebago | Illinois | 17201 | 27488 | 435 |
992539 | 992539 | 2021-02-03 | Winnebago | Illinois | 17201 | 27428 | 433 |
989293 | 989293 | 2021-02-02 | Winnebago | Illinois | 17201 | 27357 | 431 |
986046 | 986046 | 2021-02-01 | Winnebago | Illinois | 17201 | 27291 | 431 |
982799 | 982799 | 2021-01-31 | Winnebago | Illinois | 17201 | 27231 | 429 |
979553 | 979553 | 2021-01-30 | Winnebago | Illinois | 17201 | 27199 | 429 |
976307 | 976307 | 2021-01-29 | Winnebago | Illinois | 17201 | 27133 | 429 |
973062 | 973062 | 2021-01-28 | Winnebago | Illinois | 17201 | 27024 | 427 |
969817 | 969817 | 2021-01-27 | Winnebago | Illinois | 17201 | 26962 | 424 |
966573 | 966573 | 2021-01-26 | Winnebago | Illinois | 17201 | 26895 | 421 |
963328 | 963328 | 2021-01-25 | Winnebago | Illinois | 17201 | 26813 | 416 |
960083 | 960083 | 2021-01-24 | Winnebago | Illinois | 17201 | 26766 | 415 |
956837 | 956837 | 2021-01-23 | Winnebago | Illinois | 17201 | 26700 | 414 |
953592 | 953592 | 2021-01-22 | Winnebago | Illinois | 17201 | 26623 | 414 |
950347 | 950347 | 2021-01-21 | Winnebago | Illinois | 17201 | 26504 | 412 |
947101 | 947101 | 2021-01-20 | Winnebago | Illinois | 17201 | 26406 | 409 |
943854 | 943854 | 2021-01-19 | Winnebago | Illinois | 17201 | 26295 | 407 |
940609 | 940609 | 2021-01-18 | Winnebago | Illinois | 17201 | 26265 | 407 |
937364 | 937364 | 2021-01-17 | Winnebago | Illinois | 17201 | 26161 | 407 |
934119 | 934119 | 2021-01-16 | Winnebago | Illinois | 17201 | 26094 | 407 |
930874 | 930874 | 2021-01-15 | Winnebago | Illinois | 17201 | 25971 | 407 |
927629 | 927629 | 2021-01-14 | Winnebago | Illinois | 17201 | 25854 | 404 |
924383 | 924383 | 2021-01-13 | Winnebago | Illinois | 17201 | 25726 | 403 |
921138 | 921138 | 2021-01-12 | Winnebago | Illinois | 17201 | 25606 | 400 |
917893 | 917893 | 2021-01-11 | Winnebago | Illinois | 17201 | 25527 | 397 |
914648 | 914648 | 2021-01-10 | Winnebago | Illinois | 17201 | 25397 | 396 |
911403 | 911403 | 2021-01-09 | Winnebago | Illinois | 17201 | 25288 | 396 |
908158 | 908158 | 2021-01-08 | Winnebago | Illinois | 17201 | 25147 | 393 |
904912 | 904912 | 2021-01-07 | Winnebago | Illinois | 17201 | 24962 | 390 |
901667 | 901667 | 2021-01-06 | Winnebago | Illinois | 17201 | 24794 | 387 |
898422 | 898422 | 2021-01-05 | Winnebago | Illinois | 17201 | 24625 | 383 |
895177 | 895177 | 2021-01-04 | Winnebago | Illinois | 17201 | 24510 | 378 |
891930 | 891930 | 2021-01-03 | Winnebago | Illinois | 17201 | 24388 | 378 |
888684 | 888684 | 2021-01-02 | Winnebago | Illinois | 17201 | 24310 | 377 |
885438 | 885438 | 2021-01-01 | Winnebago | Illinois | 17201 | 24019 | 373 |
882193 | 882193 | 2020-12-31 | Winnebago | Illinois | 17201 | 24019 | 373 |
878948 | 878948 | 2020-12-30 | Winnebago | Illinois | 17201 | 23840 | 370 |
875703 | 875703 | 2020-12-29 | Winnebago | Illinois | 17201 | 23760 | 364 |
872458 | 872458 | 2020-12-28 | Winnebago | Illinois | 17201 | 23650 | 360 |
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);