ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Douglas" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923603 | 923603 | 2021-01-12 | Douglas | Wisconsin | 55031 | 3782 | 30 |
920358 | 920358 | 2021-01-11 | Douglas | Wisconsin | 55031 | 3760 | 30 |
917113 | 917113 | 2021-01-10 | Douglas | Wisconsin | 55031 | 3744 | 30 |
913868 | 913868 | 2021-01-09 | Douglas | Wisconsin | 55031 | 3736 | 30 |
910623 | 910623 | 2021-01-08 | Douglas | Wisconsin | 55031 | 3705 | 30 |
907378 | 907378 | 2021-01-07 | Douglas | Wisconsin | 55031 | 3672 | 30 |
904132 | 904132 | 2021-01-06 | Douglas | Wisconsin | 55031 | 3641 | 30 |
900887 | 900887 | 2021-01-05 | Douglas | Wisconsin | 55031 | 3614 | 30 |
897642 | 897642 | 2021-01-04 | Douglas | Wisconsin | 55031 | 3552 | 30 |
894396 | 894396 | 2021-01-03 | Douglas | Wisconsin | 55031 | 3546 | 30 |
891150 | 891150 | 2021-01-02 | Douglas | Wisconsin | 55031 | 3536 | 30 |
887903 | 887903 | 2021-01-01 | Douglas | Wisconsin | 55031 | 3522 | 30 |
884658 | 884658 | 2020-12-31 | Douglas | Wisconsin | 55031 | 3515 | 30 |
881413 | 881413 | 2020-12-30 | Douglas | Wisconsin | 55031 | 3479 | 29 |
878168 | 878168 | 2020-12-29 | Douglas | Wisconsin | 55031 | 3458 | 29 |
874923 | 874923 | 2020-12-28 | Douglas | Wisconsin | 55031 | 3428 | 29 |
871678 | 871678 | 2020-12-27 | Douglas | Wisconsin | 55031 | 3409 | 29 |
868433 | 868433 | 2020-12-26 | Douglas | Wisconsin | 55031 | 3403 | 29 |
865188 | 865188 | 2020-12-25 | Douglas | Wisconsin | 55031 | 3371 | 29 |
861943 | 861943 | 2020-12-24 | Douglas | Wisconsin | 55031 | 3340 | 29 |
858698 | 858698 | 2020-12-23 | Douglas | Wisconsin | 55031 | 3315 | 29 |
855453 | 855453 | 2020-12-22 | Douglas | Wisconsin | 55031 | 3287 | 29 |
852208 | 852208 | 2020-12-21 | Douglas | Wisconsin | 55031 | 3250 | 29 |
848963 | 848963 | 2020-12-20 | Douglas | Wisconsin | 55031 | 3232 | 29 |
845718 | 845718 | 2020-12-19 | Douglas | Wisconsin | 55031 | 3194 | 29 |
842472 | 842472 | 2020-12-18 | Douglas | Wisconsin | 55031 | 3122 | 29 |
839227 | 839227 | 2020-12-17 | Douglas | Wisconsin | 55031 | 3092 | 29 |
835982 | 835982 | 2020-12-16 | Douglas | Wisconsin | 55031 | 3046 | 29 |
832736 | 832736 | 2020-12-15 | Douglas | Wisconsin | 55031 | 3011 | 26 |
829489 | 829489 | 2020-12-14 | Douglas | Wisconsin | 55031 | 2952 | 26 |
826243 | 826243 | 2020-12-13 | Douglas | Wisconsin | 55031 | 2913 | 26 |
822996 | 822996 | 2020-12-12 | Douglas | Wisconsin | 55031 | 2882 | 26 |
819750 | 819750 | 2020-12-11 | Douglas | Wisconsin | 55031 | 2806 | 22 |
816504 | 816504 | 2020-12-10 | Douglas | Wisconsin | 55031 | 2757 | 15 |
813258 | 813258 | 2020-12-09 | Douglas | Wisconsin | 55031 | 2718 | 12 |
810014 | 810014 | 2020-12-08 | Douglas | Wisconsin | 55031 | 2654 | 13 |
806769 | 806769 | 2020-12-07 | Douglas | Wisconsin | 55031 | 2587 | 12 |
803524 | 803524 | 2020-12-06 | Douglas | Wisconsin | 55031 | 2530 | 12 |
800279 | 800279 | 2020-12-05 | Douglas | Wisconsin | 55031 | 2471 | 12 |
797034 | 797034 | 2020-12-04 | Douglas | Wisconsin | 55031 | 2386 | 6 |
793789 | 793789 | 2020-12-03 | Douglas | Wisconsin | 55031 | 2323 | 6 |
790544 | 790544 | 2020-12-02 | Douglas | Wisconsin | 55031 | 2267 | 6 |
787299 | 787299 | 2020-12-01 | Douglas | Wisconsin | 55031 | 2217 | 5 |
784055 | 784055 | 2020-11-30 | Douglas | Wisconsin | 55031 | 2160 | 1 |
780810 | 780810 | 2020-11-29 | Douglas | Wisconsin | 55031 | 2140 | 1 |
777564 | 777564 | 2020-11-28 | Douglas | Wisconsin | 55031 | 2105 | 1 |
774319 | 774319 | 2020-11-27 | Douglas | Wisconsin | 55031 | 2057 | 1 |
771074 | 771074 | 2020-11-26 | Douglas | Wisconsin | 55031 | 2005 | 1 |
767828 | 767828 | 2020-11-25 | Douglas | Wisconsin | 55031 | 1959 | 1 |
764583 | 764583 | 2020-11-24 | Douglas | Wisconsin | 55031 | 1912 | 1 |
761338 | 761338 | 2020-11-23 | Douglas | Wisconsin | 55031 | 1871 | 1 |
758093 | 758093 | 2020-11-22 | Douglas | Wisconsin | 55031 | 1822 | 1 |
754846 | 754846 | 2020-11-21 | Douglas | Wisconsin | 55031 | 1723 | 1 |
751600 | 751600 | 2020-11-20 | Douglas | Wisconsin | 55031 | 1628 | 1 |
748354 | 748354 | 2020-11-19 | Douglas | Wisconsin | 55031 | 1505 | 1 |
745108 | 745108 | 2020-11-18 | Douglas | Wisconsin | 55031 | 1441 | 1 |
741861 | 741861 | 2020-11-17 | Douglas | Wisconsin | 55031 | 1419 | 1 |
738614 | 738614 | 2020-11-16 | Douglas | Wisconsin | 55031 | 1368 | 1 |
735370 | 735370 | 2020-11-15 | Douglas | Wisconsin | 55031 | 1329 | 1 |
732124 | 732124 | 2020-11-14 | Douglas | Wisconsin | 55031 | 1304 | 1 |
728879 | 728879 | 2020-11-13 | Douglas | Wisconsin | 55031 | 1267 | 1 |
725636 | 725636 | 2020-11-12 | Douglas | Wisconsin | 55031 | 1185 | 1 |
722393 | 722393 | 2020-11-11 | Douglas | Wisconsin | 55031 | 1152 | 1 |
719150 | 719150 | 2020-11-10 | Douglas | Wisconsin | 55031 | 1106 | 1 |
715907 | 715907 | 2020-11-09 | Douglas | Wisconsin | 55031 | 1056 | 1 |
712663 | 712663 | 2020-11-08 | Douglas | Wisconsin | 55031 | 1052 | 1 |
709419 | 709419 | 2020-11-07 | Douglas | Wisconsin | 55031 | 1041 | 1 |
706175 | 706175 | 2020-11-06 | Douglas | Wisconsin | 55031 | 1004 | 1 |
702932 | 702932 | 2020-11-05 | Douglas | Wisconsin | 55031 | 953 | 1 |
699689 | 699689 | 2020-11-04 | Douglas | Wisconsin | 55031 | 939 | 1 |
696445 | 696445 | 2020-11-03 | Douglas | Wisconsin | 55031 | 893 | 1 |
693203 | 693203 | 2020-11-02 | Douglas | Wisconsin | 55031 | 870 | 1 |
689959 | 689959 | 2020-11-01 | Douglas | Wisconsin | 55031 | 848 | 1 |
686714 | 686714 | 2020-10-31 | Douglas | Wisconsin | 55031 | 846 | 1 |
683471 | 683471 | 2020-10-30 | Douglas | Wisconsin | 55031 | 825 | 2 |
680228 | 680228 | 2020-10-29 | Douglas | Wisconsin | 55031 | 803 | 2 |
676985 | 676985 | 2020-10-28 | Douglas | Wisconsin | 55031 | 786 | 1 |
673742 | 673742 | 2020-10-27 | Douglas | Wisconsin | 55031 | 779 | 1 |
670500 | 670500 | 2020-10-26 | Douglas | Wisconsin | 55031 | 773 | 1 |
667257 | 667257 | 2020-10-25 | Douglas | Wisconsin | 55031 | 761 | 1 |
664012 | 664012 | 2020-10-24 | Douglas | Wisconsin | 55031 | 745 | 1 |
660768 | 660768 | 2020-10-23 | Douglas | Wisconsin | 55031 | 733 | 1 |
657524 | 657524 | 2020-10-22 | Douglas | Wisconsin | 55031 | 722 | 1 |
654279 | 654279 | 2020-10-21 | Douglas | Wisconsin | 55031 | 714 | 1 |
651034 | 651034 | 2020-10-20 | Douglas | Wisconsin | 55031 | 708 | 1 |
647790 | 647790 | 2020-10-19 | Douglas | Wisconsin | 55031 | 702 | 1 |
644544 | 644544 | 2020-10-18 | Douglas | Wisconsin | 55031 | 679 | 1 |
641296 | 641296 | 2020-10-17 | Douglas | Wisconsin | 55031 | 679 | 1 |
638049 | 638049 | 2020-10-16 | Douglas | Wisconsin | 55031 | 679 | 1 |
634804 | 634804 | 2020-10-15 | Douglas | Wisconsin | 55031 | 661 | 1 |
631559 | 631559 | 2020-10-14 | Douglas | Wisconsin | 55031 | 654 | 1 |
628315 | 628315 | 2020-10-13 | Douglas | Wisconsin | 55031 | 645 | 1 |
625072 | 625072 | 2020-10-12 | Douglas | Wisconsin | 55031 | 631 | 0 |
621829 | 621829 | 2020-10-11 | Douglas | Wisconsin | 55031 | 628 | 0 |
618586 | 618586 | 2020-10-10 | Douglas | Wisconsin | 55031 | 622 | 0 |
615344 | 615344 | 2020-10-09 | Douglas | Wisconsin | 55031 | 609 | 0 |
612103 | 612103 | 2020-10-08 | Douglas | Wisconsin | 55031 | 591 | 0 |
608861 | 608861 | 2020-10-07 | Douglas | Wisconsin | 55031 | 569 | 0 |
605618 | 605618 | 2020-10-06 | Douglas | Wisconsin | 55031 | 562 | 0 |
602376 | 602376 | 2020-10-05 | Douglas | Wisconsin | 55031 | 555 | 0 |
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);