ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Monroe" and fips = 55081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923629 | 923629 | 2021-01-12 | Monroe | Wisconsin | 55081 | 3802 | 26 |
920384 | 920384 | 2021-01-11 | Monroe | Wisconsin | 55081 | 3783 | 25 |
917139 | 917139 | 2021-01-10 | Monroe | Wisconsin | 55081 | 3763 | 25 |
913894 | 913894 | 2021-01-09 | Monroe | Wisconsin | 55081 | 3742 | 25 |
910649 | 910649 | 2021-01-08 | Monroe | Wisconsin | 55081 | 3708 | 25 |
907404 | 907404 | 2021-01-07 | Monroe | Wisconsin | 55081 | 3682 | 25 |
904158 | 904158 | 2021-01-06 | Monroe | Wisconsin | 55081 | 3653 | 25 |
900913 | 900913 | 2021-01-05 | Monroe | Wisconsin | 55081 | 3608 | 25 |
897668 | 897668 | 2021-01-04 | Monroe | Wisconsin | 55081 | 3569 | 25 |
894422 | 894422 | 2021-01-03 | Monroe | Wisconsin | 55081 | 3556 | 25 |
891176 | 891176 | 2021-01-02 | Monroe | Wisconsin | 55081 | 3548 | 25 |
887929 | 887929 | 2021-01-01 | Monroe | Wisconsin | 55081 | 3528 | 25 |
884684 | 884684 | 2020-12-31 | Monroe | Wisconsin | 55081 | 3510 | 25 |
881439 | 881439 | 2020-12-30 | Monroe | Wisconsin | 55081 | 3480 | 25 |
878194 | 878194 | 2020-12-29 | Monroe | Wisconsin | 55081 | 3459 | 25 |
874949 | 874949 | 2020-12-28 | Monroe | Wisconsin | 55081 | 3442 | 23 |
871704 | 871704 | 2020-12-27 | Monroe | Wisconsin | 55081 | 3432 | 23 |
868459 | 868459 | 2020-12-26 | Monroe | Wisconsin | 55081 | 3427 | 23 |
865214 | 865214 | 2020-12-25 | Monroe | Wisconsin | 55081 | 3412 | 23 |
861969 | 861969 | 2020-12-24 | Monroe | Wisconsin | 55081 | 3384 | 23 |
858724 | 858724 | 2020-12-23 | Monroe | Wisconsin | 55081 | 3347 | 23 |
855479 | 855479 | 2020-12-22 | Monroe | Wisconsin | 55081 | 3324 | 21 |
852234 | 852234 | 2020-12-21 | Monroe | Wisconsin | 55081 | 3304 | 21 |
848989 | 848989 | 2020-12-20 | Monroe | Wisconsin | 55081 | 3286 | 21 |
845744 | 845744 | 2020-12-19 | Monroe | Wisconsin | 55081 | 3265 | 21 |
842498 | 842498 | 2020-12-18 | Monroe | Wisconsin | 55081 | 3224 | 21 |
839253 | 839253 | 2020-12-17 | Monroe | Wisconsin | 55081 | 3192 | 21 |
836008 | 836008 | 2020-12-16 | Monroe | Wisconsin | 55081 | 3156 | 20 |
832762 | 832762 | 2020-12-15 | Monroe | Wisconsin | 55081 | 3127 | 20 |
829515 | 829515 | 2020-12-14 | Monroe | Wisconsin | 55081 | 3103 | 20 |
826269 | 826269 | 2020-12-13 | Monroe | Wisconsin | 55081 | 3081 | 20 |
823022 | 823022 | 2020-12-12 | Monroe | Wisconsin | 55081 | 3066 | 20 |
819776 | 819776 | 2020-12-11 | Monroe | Wisconsin | 55081 | 3029 | 20 |
816530 | 816530 | 2020-12-10 | Monroe | Wisconsin | 55081 | 2986 | 19 |
813284 | 813284 | 2020-12-09 | Monroe | Wisconsin | 55081 | 2950 | 18 |
810040 | 810040 | 2020-12-08 | Monroe | Wisconsin | 55081 | 2917 | 15 |
806795 | 806795 | 2020-12-07 | Monroe | Wisconsin | 55081 | 2898 | 15 |
803550 | 803550 | 2020-12-06 | Monroe | Wisconsin | 55081 | 2880 | 15 |
800305 | 800305 | 2020-12-05 | Monroe | Wisconsin | 55081 | 2832 | 15 |
797060 | 797060 | 2020-12-04 | Monroe | Wisconsin | 55081 | 2798 | 15 |
793815 | 793815 | 2020-12-03 | Monroe | Wisconsin | 55081 | 2745 | 14 |
790570 | 790570 | 2020-12-02 | Monroe | Wisconsin | 55081 | 2713 | 14 |
787325 | 787325 | 2020-12-01 | Monroe | Wisconsin | 55081 | 2679 | 14 |
784081 | 784081 | 2020-11-30 | Monroe | Wisconsin | 55081 | 2645 | 13 |
780836 | 780836 | 2020-11-29 | Monroe | Wisconsin | 55081 | 2596 | 13 |
777590 | 777590 | 2020-11-28 | Monroe | Wisconsin | 55081 | 2558 | 12 |
774345 | 774345 | 2020-11-27 | Monroe | Wisconsin | 55081 | 2490 | 12 |
771100 | 771100 | 2020-11-26 | Monroe | Wisconsin | 55081 | 2470 | 12 |
767854 | 767854 | 2020-11-25 | Monroe | Wisconsin | 55081 | 2431 | 12 |
764609 | 764609 | 2020-11-24 | Monroe | Wisconsin | 55081 | 2393 | 12 |
761364 | 761364 | 2020-11-23 | Monroe | Wisconsin | 55081 | 2356 | 11 |
758119 | 758119 | 2020-11-22 | Monroe | Wisconsin | 55081 | 2331 | 11 |
754872 | 754872 | 2020-11-21 | Monroe | Wisconsin | 55081 | 2265 | 11 |
751626 | 751626 | 2020-11-20 | Monroe | Wisconsin | 55081 | 2217 | 11 |
748380 | 748380 | 2020-11-19 | Monroe | Wisconsin | 55081 | 2146 | 11 |
745134 | 745134 | 2020-11-18 | Monroe | Wisconsin | 55081 | 2065 | 11 |
741887 | 741887 | 2020-11-17 | Monroe | Wisconsin | 55081 | 2019 | 11 |
738640 | 738640 | 2020-11-16 | Monroe | Wisconsin | 55081 | 1986 | 11 |
735396 | 735396 | 2020-11-15 | Monroe | Wisconsin | 55081 | 1947 | 11 |
732150 | 732150 | 2020-11-14 | Monroe | Wisconsin | 55081 | 1862 | 11 |
728905 | 728905 | 2020-11-13 | Monroe | Wisconsin | 55081 | 1825 | 9 |
725662 | 725662 | 2020-11-12 | Monroe | Wisconsin | 55081 | 1778 | 8 |
722419 | 722419 | 2020-11-11 | Monroe | Wisconsin | 55081 | 1701 | 8 |
719176 | 719176 | 2020-11-10 | Monroe | Wisconsin | 55081 | 1656 | 8 |
715933 | 715933 | 2020-11-09 | Monroe | Wisconsin | 55081 | 1630 | 8 |
712689 | 712689 | 2020-11-08 | Monroe | Wisconsin | 55081 | 1579 | 8 |
709445 | 709445 | 2020-11-07 | Monroe | Wisconsin | 55081 | 1548 | 8 |
706201 | 706201 | 2020-11-06 | Monroe | Wisconsin | 55081 | 1501 | 8 |
702958 | 702958 | 2020-11-05 | Monroe | Wisconsin | 55081 | 1444 | 8 |
699715 | 699715 | 2020-11-04 | Monroe | Wisconsin | 55081 | 1397 | 8 |
696471 | 696471 | 2020-11-03 | Monroe | Wisconsin | 55081 | 1371 | 8 |
693229 | 693229 | 2020-11-02 | Monroe | Wisconsin | 55081 | 1335 | 8 |
689985 | 689985 | 2020-11-01 | Monroe | Wisconsin | 55081 | 1289 | 8 |
686740 | 686740 | 2020-10-31 | Monroe | Wisconsin | 55081 | 1260 | 8 |
683497 | 683497 | 2020-10-30 | Monroe | Wisconsin | 55081 | 1221 | 7 |
680254 | 680254 | 2020-10-29 | Monroe | Wisconsin | 55081 | 1186 | 6 |
677011 | 677011 | 2020-10-28 | Monroe | Wisconsin | 55081 | 1152 | 5 |
673768 | 673768 | 2020-10-27 | Monroe | Wisconsin | 55081 | 1131 | 4 |
670526 | 670526 | 2020-10-26 | Monroe | Wisconsin | 55081 | 1104 | 4 |
667283 | 667283 | 2020-10-25 | Monroe | Wisconsin | 55081 | 1088 | 4 |
664038 | 664038 | 2020-10-24 | Monroe | Wisconsin | 55081 | 1070 | 4 |
660794 | 660794 | 2020-10-23 | Monroe | Wisconsin | 55081 | 1046 | 4 |
657550 | 657550 | 2020-10-22 | Monroe | Wisconsin | 55081 | 1025 | 4 |
654305 | 654305 | 2020-10-21 | Monroe | Wisconsin | 55081 | 1007 | 4 |
651060 | 651060 | 2020-10-20 | Monroe | Wisconsin | 55081 | 978 | 3 |
647816 | 647816 | 2020-10-19 | Monroe | Wisconsin | 55081 | 967 | 3 |
644570 | 644570 | 2020-10-18 | Monroe | Wisconsin | 55081 | 896 | 3 |
641322 | 641322 | 2020-10-17 | Monroe | Wisconsin | 55081 | 896 | 3 |
638075 | 638075 | 2020-10-16 | Monroe | Wisconsin | 55081 | 896 | 3 |
634830 | 634830 | 2020-10-15 | Monroe | Wisconsin | 55081 | 871 | 3 |
631585 | 631585 | 2020-10-14 | Monroe | Wisconsin | 55081 | 831 | 3 |
628341 | 628341 | 2020-10-13 | Monroe | Wisconsin | 55081 | 818 | 3 |
625098 | 625098 | 2020-10-12 | Monroe | Wisconsin | 55081 | 803 | 3 |
621855 | 621855 | 2020-10-11 | Monroe | Wisconsin | 55081 | 782 | 3 |
618612 | 618612 | 2020-10-10 | Monroe | Wisconsin | 55081 | 776 | 3 |
615370 | 615370 | 2020-10-09 | Monroe | Wisconsin | 55081 | 750 | 3 |
612129 | 612129 | 2020-10-08 | Monroe | Wisconsin | 55081 | 725 | 3 |
608887 | 608887 | 2020-10-07 | Monroe | Wisconsin | 55081 | 718 | 3 |
605644 | 605644 | 2020-10-06 | Monroe | Wisconsin | 55081 | 691 | 3 |
602402 | 602402 | 2020-10-05 | Monroe | Wisconsin | 55081 | 679 | 3 |
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);