ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
829 rows where fips = 55025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056669 | 1056669 | 2021-02-22 | Dane | Wisconsin | 55025 | 41556 | 289 |
1053423 | 1053423 | 2021-02-21 | Dane | Wisconsin | 55025 | 41503 | 289 |
1050176 | 1050176 | 2021-02-20 | Dane | Wisconsin | 55025 | 41416 | 289 |
1046929 | 1046929 | 2021-02-19 | Dane | Wisconsin | 55025 | 41296 | 290 |
1043684 | 1043684 | 2021-02-18 | Dane | Wisconsin | 55025 | 41134 | 289 |
1040439 | 1040439 | 2021-02-17 | Dane | Wisconsin | 55025 | 40988 | 286 |
1037194 | 1037194 | 2021-02-16 | Dane | Wisconsin | 55025 | 40905 | 286 |
1033949 | 1033949 | 2021-02-15 | Dane | Wisconsin | 55025 | 40869 | 286 |
1030703 | 1030703 | 2021-02-14 | Dane | Wisconsin | 55025 | 40822 | 286 |
1027456 | 1027456 | 2021-02-13 | Dane | Wisconsin | 55025 | 40759 | 286 |
1024211 | 1024211 | 2021-02-12 | Dane | Wisconsin | 55025 | 40680 | 286 |
1020966 | 1020966 | 2021-02-11 | Dane | Wisconsin | 55025 | 40593 | 286 |
1017721 | 1017721 | 2021-02-10 | Dane | Wisconsin | 55025 | 40447 | 285 |
1014476 | 1014476 | 2021-02-09 | Dane | Wisconsin | 55025 | 40344 | 285 |
1011231 | 1011231 | 2021-02-08 | Dane | Wisconsin | 55025 | 40302 | 277 |
1007985 | 1007985 | 2021-02-07 | Dane | Wisconsin | 55025 | 40200 | 277 |
1004739 | 1004739 | 2021-02-06 | Dane | Wisconsin | 55025 | 40120 | 277 |
1001493 | 1001493 | 2021-02-05 | Dane | Wisconsin | 55025 | 40017 | 277 |
998247 | 998247 | 2021-02-04 | Dane | Wisconsin | 55025 | 39891 | 277 |
995001 | 995001 | 2021-02-03 | Dane | Wisconsin | 55025 | 39669 | 272 |
991755 | 991755 | 2021-02-02 | Dane | Wisconsin | 55025 | 39588 | 272 |
988509 | 988509 | 2021-02-01 | Dane | Wisconsin | 55025 | 39531 | 272 |
985262 | 985262 | 2021-01-31 | Dane | Wisconsin | 55025 | 39460 | 272 |
982015 | 982015 | 2021-01-30 | Dane | Wisconsin | 55025 | 39346 | 272 |
978769 | 978769 | 2021-01-29 | Dane | Wisconsin | 55025 | 39207 | 266 |
975524 | 975524 | 2021-01-28 | Dane | Wisconsin | 55025 | 39091 | 265 |
972279 | 972279 | 2021-01-27 | Dane | Wisconsin | 55025 | 38887 | 260 |
969034 | 969034 | 2021-01-26 | Dane | Wisconsin | 55025 | 38839 | 260 |
965790 | 965790 | 2021-01-25 | Dane | Wisconsin | 55025 | 38783 | 249 |
962545 | 962545 | 2021-01-24 | Dane | Wisconsin | 55025 | 38687 | 251 |
959300 | 959300 | 2021-01-23 | Dane | Wisconsin | 55025 | 38574 | 249 |
956054 | 956054 | 2021-01-22 | Dane | Wisconsin | 55025 | 38432 | 248 |
952809 | 952809 | 2021-01-21 | Dane | Wisconsin | 55025 | 38228 | 248 |
949564 | 949564 | 2021-01-20 | Dane | Wisconsin | 55025 | 38065 | 248 |
946318 | 946318 | 2021-01-19 | Dane | Wisconsin | 55025 | 38001 | 237 |
943071 | 943071 | 2021-01-18 | Dane | Wisconsin | 55025 | 37953 | 237 |
939826 | 939826 | 2021-01-17 | Dane | Wisconsin | 55025 | 37865 | 237 |
936581 | 936581 | 2021-01-16 | Dane | Wisconsin | 55025 | 37728 | 237 |
933336 | 933336 | 2021-01-15 | Dane | Wisconsin | 55025 | 37556 | 237 |
930091 | 930091 | 2021-01-14 | Dane | Wisconsin | 55025 | 37364 | 237 |
926846 | 926846 | 2021-01-13 | Dane | Wisconsin | 55025 | 37115 | 233 |
923600 | 923600 | 2021-01-12 | Dane | Wisconsin | 55025 | 36971 | 233 |
920355 | 920355 | 2021-01-11 | Dane | Wisconsin | 55025 | 36877 | 230 |
917110 | 917110 | 2021-01-10 | Dane | Wisconsin | 55025 | 36728 | 230 |
913865 | 913865 | 2021-01-09 | Dane | Wisconsin | 55025 | 36520 | 230 |
910620 | 910620 | 2021-01-08 | Dane | Wisconsin | 55025 | 36325 | 222 |
907375 | 907375 | 2021-01-07 | Dane | Wisconsin | 55025 | 35977 | 222 |
904129 | 904129 | 2021-01-06 | Dane | Wisconsin | 55025 | 35565 | 208 |
900884 | 900884 | 2021-01-05 | Dane | Wisconsin | 55025 | 35342 | 208 |
897639 | 897639 | 2021-01-04 | Dane | Wisconsin | 55025 | 35207 | 199 |
894393 | 894393 | 2021-01-03 | Dane | Wisconsin | 55025 | 35000 | 199 |
891147 | 891147 | 2021-01-02 | Dane | Wisconsin | 55025 | 34732 | 200 |
887900 | 887900 | 2021-01-01 | Dane | Wisconsin | 55025 | 34732 | 200 |
884655 | 884655 | 2020-12-31 | Dane | Wisconsin | 55025 | 34503 | 199 |
881410 | 881410 | 2020-12-30 | Dane | Wisconsin | 55025 | 34138 | 199 |
878165 | 878165 | 2020-12-29 | Dane | Wisconsin | 55025 | 33968 | 196 |
874920 | 874920 | 2020-12-28 | Dane | Wisconsin | 55025 | 33890 | 182 |
871675 | 871675 | 2020-12-27 | Dane | Wisconsin | 55025 | 33721 | 182 |
868430 | 868430 | 2020-12-26 | Dane | Wisconsin | 55025 | 33541 | 182 |
865185 | 865185 | 2020-12-25 | Dane | Wisconsin | 55025 | 33540 | 182 |
861940 | 861940 | 2020-12-24 | Dane | Wisconsin | 55025 | 33383 | 180 |
858695 | 858695 | 2020-12-23 | Dane | Wisconsin | 55025 | 33168 | 178 |
855450 | 855450 | 2020-12-22 | Dane | Wisconsin | 55025 | 33019 | 169 |
852205 | 852205 | 2020-12-21 | Dane | Wisconsin | 55025 | 32926 | 142 |
848960 | 848960 | 2020-12-20 | Dane | Wisconsin | 55025 | 32790 | 142 |
845715 | 845715 | 2020-12-19 | Dane | Wisconsin | 55025 | 32675 | 142 |
842469 | 842469 | 2020-12-18 | Dane | Wisconsin | 55025 | 32454 | 142 |
839224 | 839224 | 2020-12-17 | Dane | Wisconsin | 55025 | 32200 | 142 |
835979 | 835979 | 2020-12-16 | Dane | Wisconsin | 55025 | 31910 | 142 |
832733 | 832733 | 2020-12-15 | Dane | Wisconsin | 55025 | 31739 | 120 |
829486 | 829486 | 2020-12-14 | Dane | Wisconsin | 55025 | 31693 | 117 |
826240 | 826240 | 2020-12-13 | Dane | Wisconsin | 55025 | 31508 | 117 |
822993 | 822993 | 2020-12-12 | Dane | Wisconsin | 55025 | 31287 | 116 |
819747 | 819747 | 2020-12-11 | Dane | Wisconsin | 55025 | 31028 | 116 |
816501 | 816501 | 2020-12-10 | Dane | Wisconsin | 55025 | 30847 | 112 |
813255 | 813255 | 2020-12-09 | Dane | Wisconsin | 55025 | 30571 | 111 |
810011 | 810011 | 2020-12-08 | Dane | Wisconsin | 55025 | 30375 | 110 |
806766 | 806766 | 2020-12-07 | Dane | Wisconsin | 55025 | 30249 | 107 |
803521 | 803521 | 2020-12-06 | Dane | Wisconsin | 55025 | 30001 | 107 |
800276 | 800276 | 2020-12-05 | Dane | Wisconsin | 55025 | 29868 | 107 |
797031 | 797031 | 2020-12-04 | Dane | Wisconsin | 55025 | 29493 | 105 |
793786 | 793786 | 2020-12-03 | Dane | Wisconsin | 55025 | 29068 | 105 |
790541 | 790541 | 2020-12-02 | Dane | Wisconsin | 55025 | 28618 | 105 |
787296 | 787296 | 2020-12-01 | Dane | Wisconsin | 55025 | 28370 | 84 |
784052 | 784052 | 2020-11-30 | Dane | Wisconsin | 55025 | 28265 | 83 |
780807 | 780807 | 2020-11-29 | Dane | Wisconsin | 55025 | 28017 | 83 |
777561 | 777561 | 2020-11-28 | Dane | Wisconsin | 55025 | 27619 | 83 |
774316 | 774316 | 2020-11-27 | Dane | Wisconsin | 55025 | 27164 | 83 |
771071 | 771071 | 2020-11-26 | Dane | Wisconsin | 55025 | 27120 | 83 |
767825 | 767825 | 2020-11-25 | Dane | Wisconsin | 55025 | 26727 | 80 |
764580 | 764580 | 2020-11-24 | Dane | Wisconsin | 55025 | 26485 | 80 |
761335 | 761335 | 2020-11-23 | Dane | Wisconsin | 55025 | 25722 | 78 |
758090 | 758090 | 2020-11-22 | Dane | Wisconsin | 55025 | 25554 | 78 |
754843 | 754843 | 2020-11-21 | Dane | Wisconsin | 55025 | 25345 | 78 |
751597 | 751597 | 2020-11-20 | Dane | Wisconsin | 55025 | 24973 | 74 |
748351 | 748351 | 2020-11-19 | Dane | Wisconsin | 55025 | 24519 | 71 |
745105 | 745105 | 2020-11-18 | Dane | Wisconsin | 55025 | 24105 | 70 |
741858 | 741858 | 2020-11-17 | Dane | Wisconsin | 55025 | 23546 | 66 |
738611 | 738611 | 2020-11-16 | Dane | Wisconsin | 55025 | 22839 | 63 |
735367 | 735367 | 2020-11-15 | Dane | Wisconsin | 55025 | 22337 | 63 |
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);