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 |
---|---|---|---|---|---|---|---|
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 |
869213 | 869213 | 2020-12-27 | Winnebago | Illinois | 17201 | 23539 | 357 |
865968 | 865968 | 2020-12-26 | Winnebago | Illinois | 17201 | 23500 | 355 |
862723 | 862723 | 2020-12-25 | Winnebago | Illinois | 17201 | 23392 | 355 |
859478 | 859478 | 2020-12-24 | Winnebago | Illinois | 17201 | 23323 | 351 |
856233 | 856233 | 2020-12-23 | Winnebago | Illinois | 17201 | 23201 | 349 |
852988 | 852988 | 2020-12-22 | Winnebago | Illinois | 17201 | 23071 | 345 |
849743 | 849743 | 2020-12-21 | Winnebago | Illinois | 17201 | 22965 | 339 |
846498 | 846498 | 2020-12-20 | Winnebago | Illinois | 17201 | 22861 | 339 |
843252 | 843252 | 2020-12-19 | Winnebago | Illinois | 17201 | 22759 | 338 |
840007 | 840007 | 2020-12-18 | Winnebago | Illinois | 17201 | 22663 | 335 |
836762 | 836762 | 2020-12-17 | Winnebago | Illinois | 17201 | 22488 | 333 |
833516 | 833516 | 2020-12-16 | Winnebago | Illinois | 17201 | 22350 | 329 |
830269 | 830269 | 2020-12-15 | Winnebago | Illinois | 17201 | 22182 | 323 |
827023 | 827023 | 2020-12-14 | Winnebago | Illinois | 17201 | 22031 | 321 |
823776 | 823776 | 2020-12-13 | Winnebago | Illinois | 17201 | 21879 | 321 |
820530 | 820530 | 2020-12-12 | Winnebago | Illinois | 17201 | 21752 | 319 |
817284 | 817284 | 2020-12-11 | Winnebago | Illinois | 17201 | 21555 | 314 |
814038 | 814038 | 2020-12-10 | Winnebago | Illinois | 17201 | 21295 | 311 |
810793 | 810793 | 2020-12-09 | Winnebago | Illinois | 17201 | 21038 | 306 |
807548 | 807548 | 2020-12-08 | Winnebago | Illinois | 17201 | 20860 | 303 |
804303 | 804303 | 2020-12-07 | Winnebago | Illinois | 17201 | 20645 | 300 |
801058 | 801058 | 2020-12-06 | Winnebago | Illinois | 17201 | 20465 | 300 |
797813 | 797813 | 2020-12-05 | Winnebago | Illinois | 17201 | 20275 | 298 |
794568 | 794568 | 2020-12-04 | Winnebago | Illinois | 17201 | 20052 | 290 |
791323 | 791323 | 2020-12-03 | Winnebago | Illinois | 17201 | 19765 | 284 |
788078 | 788078 | 2020-12-02 | Winnebago | Illinois | 17201 | 19547 | 277 |
784834 | 784834 | 2020-12-01 | Winnebago | Illinois | 17201 | 19376 | 264 |
781589 | 781589 | 2020-11-30 | Winnebago | Illinois | 17201 | 19150 | 262 |
778343 | 778343 | 2020-11-29 | Winnebago | Illinois | 17201 | 18948 | 262 |
775098 | 775098 | 2020-11-28 | Winnebago | Illinois | 17201 | 18680 | 262 |
771853 | 771853 | 2020-11-27 | Winnebago | Illinois | 17201 | 18509 | 262 |
768608 | 768608 | 2020-11-26 | Winnebago | Illinois | 17201 | 18330 | 259 |
765362 | 765362 | 2020-11-25 | Winnebago | Illinois | 17201 | 18042 | 253 |
762117 | 762117 | 2020-11-24 | Winnebago | Illinois | 17201 | 17843 | 248 |
758872 | 758872 | 2020-11-23 | Winnebago | Illinois | 17201 | 17480 | 246 |
755625 | 755625 | 2020-11-22 | Winnebago | Illinois | 17201 | 17303 | 246 |
752379 | 752379 | 2020-11-21 | Winnebago | Illinois | 17201 | 17073 | 244 |
749133 | 749133 | 2020-11-20 | Winnebago | Illinois | 17201 | 16786 | 243 |
745887 | 745887 | 2020-11-19 | Winnebago | Illinois | 17201 | 16528 | 236 |
742640 | 742640 | 2020-11-18 | Winnebago | Illinois | 17201 | 16225 | 233 |
739393 | 739393 | 2020-11-17 | Winnebago | Illinois | 17201 | 16045 | 231 |
736149 | 736149 | 2020-11-16 | Winnebago | Illinois | 17201 | 15872 | 228 |
732903 | 732903 | 2020-11-15 | Winnebago | Illinois | 17201 | 15571 | 227 |
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);