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 |
---|---|---|---|---|---|---|---|
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 |
729658 | 729658 | 2020-11-14 | Winnebago | Illinois | 17201 | 15320 | 224 |
726415 | 726415 | 2020-11-13 | Winnebago | Illinois | 17201 | 15064 | 224 |
723172 | 723172 | 2020-11-12 | Winnebago | Illinois | 17201 | 14757 | 219 |
719929 | 719929 | 2020-11-11 | Winnebago | Illinois | 17201 | 14498 | 219 |
716686 | 716686 | 2020-11-10 | Winnebago | Illinois | 17201 | 14174 | 216 |
713442 | 713442 | 2020-11-09 | Winnebago | Illinois | 17201 | 13881 | 215 |
710198 | 710198 | 2020-11-08 | Winnebago | Illinois | 17201 | 13600 | 215 |
706954 | 706954 | 2020-11-07 | Winnebago | Illinois | 17201 | 13378 | 212 |
703711 | 703711 | 2020-11-06 | Winnebago | Illinois | 17201 | 13015 | 207 |
700469 | 700469 | 2020-11-05 | Winnebago | Illinois | 17201 | 12589 | 195 |
697225 | 697225 | 2020-11-04 | Winnebago | Illinois | 17201 | 12258 | 195 |
693983 | 693983 | 2020-11-03 | Winnebago | Illinois | 17201 | 12043 | 195 |
690740 | 690740 | 2020-11-02 | Winnebago | Illinois | 17201 | 11800 | 192 |
687495 | 687495 | 2020-11-01 | Winnebago | Illinois | 17201 | 11638 | 190 |
684251 | 684251 | 2020-10-31 | Winnebago | Illinois | 17201 | 11084 | 190 |
681008 | 681008 | 2020-10-30 | Winnebago | Illinois | 17201 | 11084 | 190 |
677765 | 677765 | 2020-10-29 | Winnebago | Illinois | 17201 | 10930 | 190 |
674522 | 674522 | 2020-10-28 | Winnebago | Illinois | 17201 | 10703 | 189 |
671280 | 671280 | 2020-10-27 | Winnebago | Illinois | 17201 | 10463 | 186 |
668037 | 668037 | 2020-10-26 | Winnebago | Illinois | 17201 | 10340 | 184 |
664793 | 664793 | 2020-10-25 | Winnebago | Illinois | 17201 | 10183 | 180 |
661548 | 661548 | 2020-10-24 | Winnebago | Illinois | 17201 | 10052 | 180 |
658304 | 658304 | 2020-10-23 | Winnebago | Illinois | 17201 | 9857 | 179 |
655059 | 655059 | 2020-10-22 | Winnebago | Illinois | 17201 | 9736 | 179 |
651814 | 651814 | 2020-10-21 | Winnebago | Illinois | 17201 | 9464 | 173 |
648570 | 648570 | 2020-10-20 | Winnebago | Illinois | 17201 | 9314 | 169 |
645325 | 645325 | 2020-10-19 | Winnebago | Illinois | 17201 | 9114 | 166 |
642078 | 642078 | 2020-10-18 | Winnebago | Illinois | 17201 | 9027 | 166 |
638831 | 638831 | 2020-10-17 | Winnebago | Illinois | 17201 | 8773 | 166 |
635585 | 635585 | 2020-10-16 | Winnebago | Illinois | 17201 | 8580 | 166 |
632339 | 632339 | 2020-10-15 | Winnebago | Illinois | 17201 | 8397 | 163 |
629095 | 629095 | 2020-10-14 | Winnebago | Illinois | 17201 | 8207 | 161 |
625852 | 625852 | 2020-10-13 | Winnebago | Illinois | 17201 | 8063 | 160 |
622610 | 622610 | 2020-10-12 | Winnebago | Illinois | 17201 | 7897 | 160 |
619366 | 619366 | 2020-10-11 | Winnebago | Illinois | 17201 | 7734 | 160 |
616124 | 616124 | 2020-10-10 | Winnebago | Illinois | 17201 | 7663 | 160 |
612883 | 612883 | 2020-10-09 | Winnebago | Illinois | 17201 | 7502 | 160 |
609641 | 609641 | 2020-10-08 | Winnebago | Illinois | 17201 | 7354 | 156 |
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);