ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55105 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056710 | 1056710 | 2021-02-22 | Rock | Wisconsin | 55105 | 15857 | 165 |
1053464 | 1053464 | 2021-02-21 | Rock | Wisconsin | 55105 | 15846 | 165 |
1050217 | 1050217 | 2021-02-20 | Rock | Wisconsin | 55105 | 15833 | 165 |
1046970 | 1046970 | 2021-02-19 | Rock | Wisconsin | 55105 | 15817 | 165 |
1043725 | 1043725 | 2021-02-18 | Rock | Wisconsin | 55105 | 15795 | 165 |
1040480 | 1040480 | 2021-02-17 | Rock | Wisconsin | 55105 | 15772 | 165 |
1037235 | 1037235 | 2021-02-16 | Rock | Wisconsin | 55105 | 15755 | 165 |
1033990 | 1033990 | 2021-02-15 | Rock | Wisconsin | 55105 | 15737 | 165 |
1030744 | 1030744 | 2021-02-14 | Rock | Wisconsin | 55105 | 15710 | 164 |
1027497 | 1027497 | 2021-02-13 | Rock | Wisconsin | 55105 | 15675 | 164 |
1024252 | 1024252 | 2021-02-12 | Rock | Wisconsin | 55105 | 15647 | 162 |
1021007 | 1021007 | 2021-02-11 | Rock | Wisconsin | 55105 | 15609 | 162 |
1017762 | 1017762 | 2021-02-10 | Rock | Wisconsin | 55105 | 15556 | 162 |
1014517 | 1014517 | 2021-02-09 | Rock | Wisconsin | 55105 | 15491 | 162 |
1011272 | 1011272 | 2021-02-08 | Rock | Wisconsin | 55105 | 15482 | 161 |
1008026 | 1008026 | 2021-02-07 | Rock | Wisconsin | 55105 | 15468 | 161 |
1004780 | 1004780 | 2021-02-06 | Rock | Wisconsin | 55105 | 15449 | 161 |
1001534 | 1001534 | 2021-02-05 | Rock | Wisconsin | 55105 | 15423 | 160 |
998288 | 998288 | 2021-02-04 | Rock | Wisconsin | 55105 | 15352 | 158 |
995042 | 995042 | 2021-02-03 | Rock | Wisconsin | 55105 | 15296 | 158 |
991796 | 991796 | 2021-02-02 | Rock | Wisconsin | 55105 | 15268 | 158 |
988550 | 988550 | 2021-02-01 | Rock | Wisconsin | 55105 | 15229 | 157 |
985303 | 985303 | 2021-01-31 | Rock | Wisconsin | 55105 | 15210 | 157 |
982056 | 982056 | 2021-01-30 | Rock | Wisconsin | 55105 | 15178 | 157 |
978810 | 978810 | 2021-01-29 | Rock | Wisconsin | 55105 | 15124 | 152 |
975565 | 975565 | 2021-01-28 | Rock | Wisconsin | 55105 | 15083 | 150 |
972320 | 972320 | 2021-01-27 | Rock | Wisconsin | 55105 | 15033 | 150 |
969075 | 969075 | 2021-01-26 | Rock | Wisconsin | 55105 | 14997 | 149 |
965831 | 965831 | 2021-01-25 | Rock | Wisconsin | 55105 | 14949 | 148 |
962586 | 962586 | 2021-01-24 | Rock | Wisconsin | 55105 | 14925 | 148 |
959341 | 959341 | 2021-01-23 | Rock | Wisconsin | 55105 | 14871 | 146 |
956095 | 956095 | 2021-01-22 | Rock | Wisconsin | 55105 | 14780 | 145 |
952850 | 952850 | 2021-01-21 | Rock | Wisconsin | 55105 | 14718 | 145 |
949605 | 949605 | 2021-01-20 | Rock | Wisconsin | 55105 | 14642 | 143 |
946359 | 946359 | 2021-01-19 | Rock | Wisconsin | 55105 | 14585 | 142 |
943112 | 943112 | 2021-01-18 | Rock | Wisconsin | 55105 | 14526 | 140 |
939867 | 939867 | 2021-01-17 | Rock | Wisconsin | 55105 | 14488 | 140 |
936622 | 936622 | 2021-01-16 | Rock | Wisconsin | 55105 | 14404 | 140 |
933377 | 933377 | 2021-01-15 | Rock | Wisconsin | 55105 | 14341 | 138 |
930132 | 930132 | 2021-01-14 | Rock | Wisconsin | 55105 | 14241 | 136 |
926887 | 926887 | 2021-01-13 | Rock | Wisconsin | 55105 | 14126 | 135 |
923641 | 923641 | 2021-01-12 | Rock | Wisconsin | 55105 | 14089 | 134 |
920396 | 920396 | 2021-01-11 | Rock | Wisconsin | 55105 | 13975 | 131 |
917151 | 917151 | 2021-01-10 | Rock | Wisconsin | 55105 | 13919 | 131 |
913906 | 913906 | 2021-01-09 | Rock | Wisconsin | 55105 | 13887 | 131 |
910661 | 910661 | 2021-01-08 | Rock | Wisconsin | 55105 | 13770 | 131 |
907416 | 907416 | 2021-01-07 | Rock | Wisconsin | 55105 | 13634 | 128 |
904170 | 904170 | 2021-01-06 | Rock | Wisconsin | 55105 | 13516 | 128 |
900925 | 900925 | 2021-01-05 | Rock | Wisconsin | 55105 | 13411 | 127 |
897680 | 897680 | 2021-01-04 | Rock | Wisconsin | 55105 | 13267 | 125 |
894434 | 894434 | 2021-01-03 | Rock | Wisconsin | 55105 | 13216 | 126 |
891188 | 891188 | 2021-01-02 | Rock | Wisconsin | 55105 | 13175 | 126 |
887941 | 887941 | 2021-01-01 | Rock | Wisconsin | 55105 | 13134 | 126 |
884696 | 884696 | 2020-12-31 | Rock | Wisconsin | 55105 | 13032 | 126 |
881451 | 881451 | 2020-12-30 | Rock | Wisconsin | 55105 | 12895 | 124 |
878206 | 878206 | 2020-12-29 | Rock | Wisconsin | 55105 | 12776 | 123 |
874961 | 874961 | 2020-12-28 | Rock | Wisconsin | 55105 | 12680 | 121 |
871716 | 871716 | 2020-12-27 | Rock | Wisconsin | 55105 | 12625 | 120 |
868471 | 868471 | 2020-12-26 | Rock | Wisconsin | 55105 | 12500 | 119 |
865226 | 865226 | 2020-12-25 | Rock | Wisconsin | 55105 | 12492 | 119 |
861981 | 861981 | 2020-12-24 | Rock | Wisconsin | 55105 | 12421 | 119 |
858736 | 858736 | 2020-12-23 | Rock | Wisconsin | 55105 | 12338 | 116 |
855491 | 855491 | 2020-12-22 | Rock | Wisconsin | 55105 | 12256 | 114 |
852246 | 852246 | 2020-12-21 | Rock | Wisconsin | 55105 | 12194 | 112 |
849001 | 849001 | 2020-12-20 | Rock | Wisconsin | 55105 | 12140 | 112 |
845756 | 845756 | 2020-12-19 | Rock | Wisconsin | 55105 | 12075 | 110 |
842510 | 842510 | 2020-12-18 | Rock | Wisconsin | 55105 | 11951 | 109 |
839265 | 839265 | 2020-12-17 | Rock | Wisconsin | 55105 | 11820 | 106 |
836020 | 836020 | 2020-12-16 | Rock | Wisconsin | 55105 | 11625 | 107 |
832774 | 832774 | 2020-12-15 | Rock | Wisconsin | 55105 | 11586 | 107 |
829527 | 829527 | 2020-12-14 | Rock | Wisconsin | 55105 | 11552 | 106 |
826281 | 826281 | 2020-12-13 | Rock | Wisconsin | 55105 | 11517 | 105 |
823034 | 823034 | 2020-12-12 | Rock | Wisconsin | 55105 | 11265 | 105 |
819788 | 819788 | 2020-12-11 | Rock | Wisconsin | 55105 | 11053 | 104 |
816542 | 816542 | 2020-12-10 | Rock | Wisconsin | 55105 | 10910 | 103 |
813296 | 813296 | 2020-12-09 | Rock | Wisconsin | 55105 | 10809 | 102 |
810052 | 810052 | 2020-12-08 | Rock | Wisconsin | 55105 | 10715 | 102 |
806807 | 806807 | 2020-12-07 | Rock | Wisconsin | 55105 | 10659 | 101 |
803562 | 803562 | 2020-12-06 | Rock | Wisconsin | 55105 | 10590 | 101 |
800317 | 800317 | 2020-12-05 | Rock | Wisconsin | 55105 | 10421 | 101 |
797072 | 797072 | 2020-12-04 | Rock | Wisconsin | 55105 | 10348 | 100 |
793827 | 793827 | 2020-12-03 | Rock | Wisconsin | 55105 | 10141 | 93 |
790582 | 790582 | 2020-12-02 | Rock | Wisconsin | 55105 | 9999 | 93 |
787337 | 787337 | 2020-12-01 | Rock | Wisconsin | 55105 | 9936 | 90 |
784093 | 784093 | 2020-11-30 | Rock | Wisconsin | 55105 | 9872 | 85 |
780848 | 780848 | 2020-11-29 | Rock | Wisconsin | 55105 | 9795 | 84 |
777602 | 777602 | 2020-11-28 | Rock | Wisconsin | 55105 | 9708 | 84 |
774357 | 774357 | 2020-11-27 | Rock | Wisconsin | 55105 | 9412 | 80 |
771112 | 771112 | 2020-11-26 | Rock | Wisconsin | 55105 | 9413 | 80 |
767866 | 767866 | 2020-11-25 | Rock | Wisconsin | 55105 | 9231 | 76 |
764621 | 764621 | 2020-11-24 | Rock | Wisconsin | 55105 | 9156 | 76 |
761376 | 761376 | 2020-11-23 | Rock | Wisconsin | 55105 | 9059 | 71 |
758131 | 758131 | 2020-11-22 | Rock | Wisconsin | 55105 | 8979 | 71 |
754884 | 754884 | 2020-11-21 | Rock | Wisconsin | 55105 | 8824 | 71 |
751638 | 751638 | 2020-11-20 | Rock | Wisconsin | 55105 | 8554 | 70 |
748392 | 748392 | 2020-11-19 | Rock | Wisconsin | 55105 | 8468 | 64 |
745146 | 745146 | 2020-11-18 | Rock | Wisconsin | 55105 | 8382 | 62 |
741899 | 741899 | 2020-11-17 | Rock | Wisconsin | 55105 | 8294 | 62 |
738652 | 738652 | 2020-11-16 | Rock | Wisconsin | 55105 | 8184 | 62 |
735408 | 735408 | 2020-11-15 | Rock | Wisconsin | 55105 | 7995 | 62 |
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);