ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Marathon" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056693 | 1056693 | 2021-02-22 | Marathon | Wisconsin | 55073 | 14917 | 204 |
1053447 | 1053447 | 2021-02-21 | Marathon | Wisconsin | 55073 | 14903 | 204 |
1050200 | 1050200 | 2021-02-20 | Marathon | Wisconsin | 55073 | 14896 | 204 |
1046953 | 1046953 | 2021-02-19 | Marathon | Wisconsin | 55073 | 14873 | 204 |
1043708 | 1043708 | 2021-02-18 | Marathon | Wisconsin | 55073 | 14858 | 203 |
1040463 | 1040463 | 2021-02-17 | Marathon | Wisconsin | 55073 | 14848 | 203 |
1037218 | 1037218 | 2021-02-16 | Marathon | Wisconsin | 55073 | 14835 | 203 |
1033973 | 1033973 | 2021-02-15 | Marathon | Wisconsin | 55073 | 14827 | 203 |
1030727 | 1030727 | 2021-02-14 | Marathon | Wisconsin | 55073 | 14820 | 203 |
1027480 | 1027480 | 2021-02-13 | Marathon | Wisconsin | 55073 | 14804 | 203 |
1024235 | 1024235 | 2021-02-12 | Marathon | Wisconsin | 55073 | 14788 | 203 |
1020990 | 1020990 | 2021-02-11 | Marathon | Wisconsin | 55073 | 14775 | 202 |
1017745 | 1017745 | 2021-02-10 | Marathon | Wisconsin | 55073 | 14742 | 202 |
1014500 | 1014500 | 2021-02-09 | Marathon | Wisconsin | 55073 | 14723 | 202 |
1011255 | 1011255 | 2021-02-08 | Marathon | Wisconsin | 55073 | 14715 | 202 |
1008009 | 1008009 | 2021-02-07 | Marathon | Wisconsin | 55073 | 14712 | 202 |
1004763 | 1004763 | 2021-02-06 | Marathon | Wisconsin | 55073 | 14698 | 202 |
1001517 | 1001517 | 2021-02-05 | Marathon | Wisconsin | 55073 | 14695 | 202 |
998271 | 998271 | 2021-02-04 | Marathon | Wisconsin | 55073 | 14680 | 201 |
995025 | 995025 | 2021-02-03 | Marathon | Wisconsin | 55073 | 14658 | 201 |
991779 | 991779 | 2021-02-02 | Marathon | Wisconsin | 55073 | 14643 | 201 |
988533 | 988533 | 2021-02-01 | Marathon | Wisconsin | 55073 | 14620 | 201 |
985286 | 985286 | 2021-01-31 | Marathon | Wisconsin | 55073 | 14609 | 201 |
982039 | 982039 | 2021-01-30 | Marathon | Wisconsin | 55073 | 14584 | 201 |
978793 | 978793 | 2021-01-29 | Marathon | Wisconsin | 55073 | 14568 | 201 |
975548 | 975548 | 2021-01-28 | Marathon | Wisconsin | 55073 | 14532 | 201 |
972303 | 972303 | 2021-01-27 | Marathon | Wisconsin | 55073 | 14493 | 201 |
969058 | 969058 | 2021-01-26 | Marathon | Wisconsin | 55073 | 14457 | 201 |
965814 | 965814 | 2021-01-25 | Marathon | Wisconsin | 55073 | 14417 | 200 |
962569 | 962569 | 2021-01-24 | Marathon | Wisconsin | 55073 | 14395 | 200 |
959324 | 959324 | 2021-01-23 | Marathon | Wisconsin | 55073 | 14358 | 200 |
956078 | 956078 | 2021-01-22 | Marathon | Wisconsin | 55073 | 14306 | 199 |
952833 | 952833 | 2021-01-21 | Marathon | Wisconsin | 55073 | 14278 | 199 |
949588 | 949588 | 2021-01-20 | Marathon | Wisconsin | 55073 | 14233 | 197 |
946342 | 946342 | 2021-01-19 | Marathon | Wisconsin | 55073 | 14184 | 196 |
943095 | 943095 | 2021-01-18 | Marathon | Wisconsin | 55073 | 14129 | 194 |
939850 | 939850 | 2021-01-17 | Marathon | Wisconsin | 55073 | 14108 | 194 |
936605 | 936605 | 2021-01-16 | Marathon | Wisconsin | 55073 | 14058 | 194 |
933360 | 933360 | 2021-01-15 | Marathon | Wisconsin | 55073 | 14011 | 193 |
930115 | 930115 | 2021-01-14 | Marathon | Wisconsin | 55073 | 13929 | 193 |
926870 | 926870 | 2021-01-13 | Marathon | Wisconsin | 55073 | 13893 | 193 |
923624 | 923624 | 2021-01-12 | Marathon | Wisconsin | 55073 | 13827 | 188 |
920379 | 920379 | 2021-01-11 | Marathon | Wisconsin | 55073 | 13752 | 185 |
917134 | 917134 | 2021-01-10 | Marathon | Wisconsin | 55073 | 13698 | 185 |
913889 | 913889 | 2021-01-09 | Marathon | Wisconsin | 55073 | 13662 | 185 |
910644 | 910644 | 2021-01-08 | Marathon | Wisconsin | 55073 | 13562 | 185 |
907399 | 907399 | 2021-01-07 | Marathon | Wisconsin | 55073 | 13509 | 185 |
904153 | 904153 | 2021-01-06 | Marathon | Wisconsin | 55073 | 13422 | 185 |
900908 | 900908 | 2021-01-05 | Marathon | Wisconsin | 55073 | 13329 | 183 |
897663 | 897663 | 2021-01-04 | Marathon | Wisconsin | 55073 | 13234 | 183 |
894417 | 894417 | 2021-01-03 | Marathon | Wisconsin | 55073 | 13210 | 183 |
891171 | 891171 | 2021-01-02 | Marathon | Wisconsin | 55073 | 13134 | 183 |
887924 | 887924 | 2021-01-01 | Marathon | Wisconsin | 55073 | 13133 | 183 |
884679 | 884679 | 2020-12-31 | Marathon | Wisconsin | 55073 | 13062 | 183 |
881434 | 881434 | 2020-12-30 | Marathon | Wisconsin | 55073 | 12967 | 179 |
878189 | 878189 | 2020-12-29 | Marathon | Wisconsin | 55073 | 12903 | 178 |
874944 | 874944 | 2020-12-28 | Marathon | Wisconsin | 55073 | 12809 | 173 |
871699 | 871699 | 2020-12-27 | Marathon | Wisconsin | 55073 | 12761 | 173 |
868454 | 868454 | 2020-12-26 | Marathon | Wisconsin | 55073 | 12696 | 173 |
865209 | 865209 | 2020-12-25 | Marathon | Wisconsin | 55073 | 12696 | 173 |
861964 | 861964 | 2020-12-24 | Marathon | Wisconsin | 55073 | 12632 | 173 |
858719 | 858719 | 2020-12-23 | Marathon | Wisconsin | 55073 | 12549 | 173 |
855474 | 855474 | 2020-12-22 | Marathon | Wisconsin | 55073 | 12463 | 165 |
852229 | 852229 | 2020-12-21 | Marathon | Wisconsin | 55073 | 12397 | 163 |
848984 | 848984 | 2020-12-20 | Marathon | Wisconsin | 55073 | 12368 | 163 |
845739 | 845739 | 2020-12-19 | Marathon | Wisconsin | 55073 | 12308 | 163 |
842493 | 842493 | 2020-12-18 | Marathon | Wisconsin | 55073 | 12210 | 163 |
839248 | 839248 | 2020-12-17 | Marathon | Wisconsin | 55073 | 12147 | 163 |
836003 | 836003 | 2020-12-16 | Marathon | Wisconsin | 55073 | 12067 | 163 |
832757 | 832757 | 2020-12-15 | Marathon | Wisconsin | 55073 | 12013 | 162 |
829510 | 829510 | 2020-12-14 | Marathon | Wisconsin | 55073 | 11974 | 162 |
826264 | 826264 | 2020-12-13 | Marathon | Wisconsin | 55073 | 11916 | 162 |
823017 | 823017 | 2020-12-12 | Marathon | Wisconsin | 55073 | 11813 | 162 |
819771 | 819771 | 2020-12-11 | Marathon | Wisconsin | 55073 | 11747 | 162 |
816525 | 816525 | 2020-12-10 | Marathon | Wisconsin | 55073 | 11631 | 159 |
813279 | 813279 | 2020-12-09 | Marathon | Wisconsin | 55073 | 11517 | 159 |
810035 | 810035 | 2020-12-08 | Marathon | Wisconsin | 55073 | 11366 | 159 |
806790 | 806790 | 2020-12-07 | Marathon | Wisconsin | 55073 | 11284 | 158 |
803545 | 803545 | 2020-12-06 | Marathon | Wisconsin | 55073 | 11202 | 153 |
800300 | 800300 | 2020-12-05 | Marathon | Wisconsin | 55073 | 11094 | 153 |
797055 | 797055 | 2020-12-04 | Marathon | Wisconsin | 55073 | 10993 | 149 |
793810 | 793810 | 2020-12-03 | Marathon | Wisconsin | 55073 | 10876 | 149 |
790565 | 790565 | 2020-12-02 | Marathon | Wisconsin | 55073 | 10741 | 143 |
787320 | 787320 | 2020-12-01 | Marathon | Wisconsin | 55073 | 10619 | 140 |
784076 | 784076 | 2020-11-30 | Marathon | Wisconsin | 55073 | 10509 | 139 |
780831 | 780831 | 2020-11-29 | Marathon | Wisconsin | 55073 | 10460 | 139 |
777585 | 777585 | 2020-11-28 | Marathon | Wisconsin | 55073 | 10396 | 139 |
774340 | 774340 | 2020-11-27 | Marathon | Wisconsin | 55073 | 10269 | 139 |
771095 | 771095 | 2020-11-26 | Marathon | Wisconsin | 55073 | 10165 | 139 |
767849 | 767849 | 2020-11-25 | Marathon | Wisconsin | 55073 | 10018 | 132 |
764604 | 764604 | 2020-11-24 | Marathon | Wisconsin | 55073 | 9875 | 126 |
761359 | 761359 | 2020-11-23 | Marathon | Wisconsin | 55073 | 9777 | 126 |
758114 | 758114 | 2020-11-22 | Marathon | Wisconsin | 55073 | 9694 | 125 |
754867 | 754867 | 2020-11-21 | Marathon | Wisconsin | 55073 | 9544 | 124 |
751621 | 751621 | 2020-11-20 | Marathon | Wisconsin | 55073 | 9406 | 123 |
748375 | 748375 | 2020-11-19 | Marathon | Wisconsin | 55073 | 9288 | 123 |
745129 | 745129 | 2020-11-18 | Marathon | Wisconsin | 55073 | 9140 | 120 |
741882 | 741882 | 2020-11-17 | Marathon | Wisconsin | 55073 | 8924 | 111 |
738635 | 738635 | 2020-11-16 | Marathon | Wisconsin | 55073 | 8823 | 106 |
735391 | 735391 | 2020-11-15 | Marathon | Wisconsin | 55073 | 8650 | 106 |
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);