ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Dodge" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063161 | 1063161 | 2021-02-24 | Dodge | Wisconsin | 55027 | 12143 | 176 |
1059916 | 1059916 | 2021-02-23 | Dodge | Wisconsin | 55027 | 12133 | 176 |
1056670 | 1056670 | 2021-02-22 | Dodge | Wisconsin | 55027 | 12131 | 176 |
1053424 | 1053424 | 2021-02-21 | Dodge | Wisconsin | 55027 | 12127 | 176 |
1050177 | 1050177 | 2021-02-20 | Dodge | Wisconsin | 55027 | 12124 | 176 |
1046930 | 1046930 | 2021-02-19 | Dodge | Wisconsin | 55027 | 12111 | 176 |
1043685 | 1043685 | 2021-02-18 | Dodge | Wisconsin | 55027 | 12096 | 175 |
1040440 | 1040440 | 2021-02-17 | Dodge | Wisconsin | 55027 | 12089 | 175 |
1037195 | 1037195 | 2021-02-16 | Dodge | Wisconsin | 55027 | 12075 | 175 |
1033950 | 1033950 | 2021-02-15 | Dodge | Wisconsin | 55027 | 12064 | 175 |
1030704 | 1030704 | 2021-02-14 | Dodge | Wisconsin | 55027 | 12061 | 175 |
1027457 | 1027457 | 2021-02-13 | Dodge | Wisconsin | 55027 | 12057 | 175 |
1024212 | 1024212 | 2021-02-12 | Dodge | Wisconsin | 55027 | 12047 | 175 |
1020967 | 1020967 | 2021-02-11 | Dodge | Wisconsin | 55027 | 12041 | 175 |
1017722 | 1017722 | 2021-02-10 | Dodge | Wisconsin | 55027 | 12019 | 175 |
1014477 | 1014477 | 2021-02-09 | Dodge | Wisconsin | 55027 | 11999 | 175 |
1011232 | 1011232 | 2021-02-08 | Dodge | Wisconsin | 55027 | 11982 | 175 |
1007986 | 1007986 | 2021-02-07 | Dodge | Wisconsin | 55027 | 11973 | 174 |
1004740 | 1004740 | 2021-02-06 | Dodge | Wisconsin | 55027 | 11964 | 174 |
1001494 | 1001494 | 2021-02-05 | Dodge | Wisconsin | 55027 | 11948 | 171 |
998248 | 998248 | 2021-02-04 | Dodge | Wisconsin | 55027 | 11928 | 166 |
995002 | 995002 | 2021-02-03 | Dodge | Wisconsin | 55027 | 11909 | 165 |
991756 | 991756 | 2021-02-02 | Dodge | Wisconsin | 55027 | 11897 | 165 |
988510 | 988510 | 2021-02-01 | Dodge | Wisconsin | 55027 | 11880 | 165 |
985263 | 985263 | 2021-01-31 | Dodge | Wisconsin | 55027 | 11871 | 165 |
982016 | 982016 | 2021-01-30 | Dodge | Wisconsin | 55027 | 11860 | 164 |
978770 | 978770 | 2021-01-29 | Dodge | Wisconsin | 55027 | 11848 | 162 |
975525 | 975525 | 2021-01-28 | Dodge | Wisconsin | 55027 | 11828 | 161 |
972280 | 972280 | 2021-01-27 | Dodge | Wisconsin | 55027 | 11806 | 161 |
969035 | 969035 | 2021-01-26 | Dodge | Wisconsin | 55027 | 11772 | 160 |
965791 | 965791 | 2021-01-25 | Dodge | Wisconsin | 55027 | 11747 | 156 |
962546 | 962546 | 2021-01-24 | Dodge | Wisconsin | 55027 | 11734 | 156 |
959301 | 959301 | 2021-01-23 | Dodge | Wisconsin | 55027 | 11727 | 156 |
956055 | 956055 | 2021-01-22 | Dodge | Wisconsin | 55027 | 11693 | 150 |
952810 | 952810 | 2021-01-21 | Dodge | Wisconsin | 55027 | 11672 | 150 |
949565 | 949565 | 2021-01-20 | Dodge | Wisconsin | 55027 | 11638 | 150 |
946319 | 946319 | 2021-01-19 | Dodge | Wisconsin | 55027 | 11623 | 150 |
943072 | 943072 | 2021-01-18 | Dodge | Wisconsin | 55027 | 11608 | 146 |
939827 | 939827 | 2021-01-17 | Dodge | Wisconsin | 55027 | 11595 | 146 |
936582 | 936582 | 2021-01-16 | Dodge | Wisconsin | 55027 | 11572 | 146 |
933337 | 933337 | 2021-01-15 | Dodge | Wisconsin | 55027 | 11543 | 146 |
930092 | 930092 | 2021-01-14 | Dodge | Wisconsin | 55027 | 11499 | 146 |
926847 | 926847 | 2021-01-13 | Dodge | Wisconsin | 55027 | 11476 | 144 |
923601 | 923601 | 2021-01-12 | Dodge | Wisconsin | 55027 | 11417 | 144 |
920356 | 920356 | 2021-01-11 | Dodge | Wisconsin | 55027 | 11388 | 143 |
917111 | 917111 | 2021-01-10 | Dodge | Wisconsin | 55027 | 11360 | 143 |
913866 | 913866 | 2021-01-09 | Dodge | Wisconsin | 55027 | 11336 | 143 |
910621 | 910621 | 2021-01-08 | Dodge | Wisconsin | 55027 | 11288 | 143 |
907376 | 907376 | 2021-01-07 | Dodge | Wisconsin | 55027 | 11232 | 143 |
904130 | 904130 | 2021-01-06 | Dodge | Wisconsin | 55027 | 11178 | 143 |
900885 | 900885 | 2021-01-05 | Dodge | Wisconsin | 55027 | 11121 | 143 |
897640 | 897640 | 2021-01-04 | Dodge | Wisconsin | 55027 | 11101 | 142 |
894394 | 894394 | 2021-01-03 | Dodge | Wisconsin | 55027 | 11084 | 142 |
891148 | 891148 | 2021-01-02 | Dodge | Wisconsin | 55027 | 11067 | 142 |
887901 | 887901 | 2021-01-01 | Dodge | Wisconsin | 55027 | 11054 | 142 |
884656 | 884656 | 2020-12-31 | Dodge | Wisconsin | 55027 | 10999 | 137 |
881411 | 881411 | 2020-12-30 | Dodge | Wisconsin | 55027 | 10964 | 136 |
878166 | 878166 | 2020-12-29 | Dodge | Wisconsin | 55027 | 10913 | 135 |
874921 | 874921 | 2020-12-28 | Dodge | Wisconsin | 55027 | 10890 | 128 |
871676 | 871676 | 2020-12-27 | Dodge | Wisconsin | 55027 | 10880 | 127 |
868431 | 868431 | 2020-12-26 | Dodge | Wisconsin | 55027 | 10849 | 127 |
865186 | 865186 | 2020-12-25 | Dodge | Wisconsin | 55027 | 10831 | 127 |
861941 | 861941 | 2020-12-24 | Dodge | Wisconsin | 55027 | 10760 | 127 |
858696 | 858696 | 2020-12-23 | Dodge | Wisconsin | 55027 | 10713 | 126 |
855451 | 855451 | 2020-12-22 | Dodge | Wisconsin | 55027 | 10664 | 126 |
852206 | 852206 | 2020-12-21 | Dodge | Wisconsin | 55027 | 10600 | 119 |
848961 | 848961 | 2020-12-20 | Dodge | Wisconsin | 55027 | 10582 | 119 |
845716 | 845716 | 2020-12-19 | Dodge | Wisconsin | 55027 | 10557 | 118 |
842470 | 842470 | 2020-12-18 | Dodge | Wisconsin | 55027 | 10425 | 113 |
839225 | 839225 | 2020-12-17 | Dodge | Wisconsin | 55027 | 10366 | 105 |
835980 | 835980 | 2020-12-16 | Dodge | Wisconsin | 55027 | 10320 | 105 |
832734 | 832734 | 2020-12-15 | Dodge | Wisconsin | 55027 | 10240 | 98 |
829487 | 829487 | 2020-12-14 | Dodge | Wisconsin | 55027 | 10212 | 94 |
826241 | 826241 | 2020-12-13 | Dodge | Wisconsin | 55027 | 10176 | 94 |
822994 | 822994 | 2020-12-12 | Dodge | Wisconsin | 55027 | 10135 | 94 |
819748 | 819748 | 2020-12-11 | Dodge | Wisconsin | 55027 | 9994 | 94 |
816502 | 816502 | 2020-12-10 | Dodge | Wisconsin | 55027 | 9870 | 93 |
813256 | 813256 | 2020-12-09 | Dodge | Wisconsin | 55027 | 9702 | 93 |
810012 | 810012 | 2020-12-08 | Dodge | Wisconsin | 55027 | 9640 | 89 |
806767 | 806767 | 2020-12-07 | Dodge | Wisconsin | 55027 | 9544 | 88 |
803522 | 803522 | 2020-12-06 | Dodge | Wisconsin | 55027 | 9484 | 88 |
800277 | 800277 | 2020-12-05 | Dodge | Wisconsin | 55027 | 9383 | 88 |
797032 | 797032 | 2020-12-04 | Dodge | Wisconsin | 55027 | 9205 | 82 |
793787 | 793787 | 2020-12-03 | Dodge | Wisconsin | 55027 | 9060 | 79 |
790542 | 790542 | 2020-12-02 | Dodge | Wisconsin | 55027 | 8880 | 78 |
787297 | 787297 | 2020-12-01 | Dodge | Wisconsin | 55027 | 8822 | 78 |
784053 | 784053 | 2020-11-30 | Dodge | Wisconsin | 55027 | 8764 | 75 |
780808 | 780808 | 2020-11-29 | Dodge | Wisconsin | 55027 | 8718 | 75 |
777562 | 777562 | 2020-11-28 | Dodge | Wisconsin | 55027 | 8669 | 75 |
774317 | 774317 | 2020-11-27 | Dodge | Wisconsin | 55027 | 8607 | 75 |
771072 | 771072 | 2020-11-26 | Dodge | Wisconsin | 55027 | 8545 | 74 |
767826 | 767826 | 2020-11-25 | Dodge | Wisconsin | 55027 | 8462 | 74 |
764581 | 764581 | 2020-11-24 | Dodge | Wisconsin | 55027 | 8220 | 74 |
761336 | 761336 | 2020-11-23 | Dodge | Wisconsin | 55027 | 8140 | 70 |
758091 | 758091 | 2020-11-22 | Dodge | Wisconsin | 55027 | 8067 | 70 |
754844 | 754844 | 2020-11-21 | Dodge | Wisconsin | 55027 | 8010 | 70 |
751598 | 751598 | 2020-11-20 | Dodge | Wisconsin | 55027 | 7813 | 69 |
748352 | 748352 | 2020-11-19 | Dodge | Wisconsin | 55027 | 7737 | 69 |
745106 | 745106 | 2020-11-18 | Dodge | Wisconsin | 55027 | 7457 | 63 |
741859 | 741859 | 2020-11-17 | Dodge | Wisconsin | 55027 | 7252 | 58 |
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);