ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55015 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199518 | 1199518 | 2021-04-07 | Calumet | Wisconsin | 55015 | 6270 | 50 |
1196269 | 1196269 | 2021-04-06 | Calumet | Wisconsin | 55015 | 6261 | 50 |
1193021 | 1193021 | 2021-04-05 | Calumet | Wisconsin | 55015 | 6253 | 50 |
1189771 | 1189771 | 2021-04-04 | Calumet | Wisconsin | 55015 | 6249 | 50 |
1186524 | 1186524 | 2021-04-03 | Calumet | Wisconsin | 55015 | 6231 | 50 |
1183277 | 1183277 | 2021-04-02 | Calumet | Wisconsin | 55015 | 6232 | 50 |
1180030 | 1180030 | 2021-04-01 | Calumet | Wisconsin | 55015 | 6224 | 50 |
1176783 | 1176783 | 2021-03-31 | Calumet | Wisconsin | 55015 | 6213 | 50 |
1173536 | 1173536 | 2021-03-30 | Calumet | Wisconsin | 55015 | 6207 | 50 |
1170289 | 1170289 | 2021-03-29 | Calumet | Wisconsin | 55015 | 6203 | 50 |
1167041 | 1167041 | 2021-03-28 | Calumet | Wisconsin | 55015 | 6195 | 50 |
1163793 | 1163793 | 2021-03-27 | Calumet | Wisconsin | 55015 | 6193 | 50 |
1160545 | 1160545 | 2021-03-26 | Calumet | Wisconsin | 55015 | 6188 | 50 |
1157297 | 1157297 | 2021-03-25 | Calumet | Wisconsin | 55015 | 6182 | 50 |
1154050 | 1154050 | 2021-03-24 | Calumet | Wisconsin | 55015 | 6165 | 50 |
1150803 | 1150803 | 2021-03-23 | Calumet | Wisconsin | 55015 | 6145 | 50 |
1147556 | 1147556 | 2021-03-22 | Calumet | Wisconsin | 55015 | 6145 | 50 |
1144309 | 1144309 | 2021-03-21 | Calumet | Wisconsin | 55015 | 6142 | 50 |
1141062 | 1141062 | 2021-03-20 | Calumet | Wisconsin | 55015 | 6137 | 50 |
1137816 | 1137816 | 2021-03-19 | Calumet | Wisconsin | 55015 | 6127 | 50 |
1134570 | 1134570 | 2021-03-18 | Calumet | Wisconsin | 55015 | 6118 | 49 |
1131322 | 1131322 | 2021-03-17 | Calumet | Wisconsin | 55015 | 6109 | 49 |
1128075 | 1128075 | 2021-03-16 | Calumet | Wisconsin | 55015 | 6105 | 48 |
1124829 | 1124829 | 2021-03-15 | Calumet | Wisconsin | 55015 | 6098 | 47 |
1121583 | 1121583 | 2021-03-14 | Calumet | Wisconsin | 55015 | 6095 | 47 |
1118336 | 1118336 | 2021-03-13 | Calumet | Wisconsin | 55015 | 6094 | 47 |
1115089 | 1115089 | 2021-03-12 | Calumet | Wisconsin | 55015 | 6090 | 47 |
1111843 | 1111843 | 2021-03-11 | Calumet | Wisconsin | 55015 | 6084 | 47 |
1108597 | 1108597 | 2021-03-10 | Calumet | Wisconsin | 55015 | 6069 | 47 |
1105351 | 1105351 | 2021-03-09 | Calumet | Wisconsin | 55015 | 6058 | 47 |
1102105 | 1102105 | 2021-03-08 | Calumet | Wisconsin | 55015 | 6056 | 47 |
1098859 | 1098859 | 2021-03-07 | Calumet | Wisconsin | 55015 | 6051 | 47 |
1095611 | 1095611 | 2021-03-06 | Calumet | Wisconsin | 55015 | 6050 | 47 |
1092365 | 1092365 | 2021-03-05 | Calumet | Wisconsin | 55015 | 6048 | 47 |
1089119 | 1089119 | 2021-03-04 | Calumet | Wisconsin | 55015 | 6041 | 47 |
1085874 | 1085874 | 2021-03-03 | Calumet | Wisconsin | 55015 | 6034 | 47 |
1082628 | 1082628 | 2021-03-02 | Calumet | Wisconsin | 55015 | 6027 | 47 |
1079382 | 1079382 | 2021-03-01 | Calumet | Wisconsin | 55015 | 6018 | 46 |
1076137 | 1076137 | 2021-02-28 | Calumet | Wisconsin | 55015 | 6014 | 46 |
1072891 | 1072891 | 2021-02-27 | Calumet | Wisconsin | 55015 | 6010 | 46 |
1069645 | 1069645 | 2021-02-26 | Calumet | Wisconsin | 55015 | 6002 | 45 |
1066400 | 1066400 | 2021-02-25 | Calumet | Wisconsin | 55015 | 5993 | 45 |
1063155 | 1063155 | 2021-02-24 | Calumet | Wisconsin | 55015 | 5984 | 45 |
1059910 | 1059910 | 2021-02-23 | Calumet | Wisconsin | 55015 | 5976 | 45 |
1056664 | 1056664 | 2021-02-22 | Calumet | Wisconsin | 55015 | 5970 | 45 |
1053418 | 1053418 | 2021-02-21 | Calumet | Wisconsin | 55015 | 5965 | 45 |
1050171 | 1050171 | 2021-02-20 | Calumet | Wisconsin | 55015 | 5958 | 45 |
1046924 | 1046924 | 2021-02-19 | Calumet | Wisconsin | 55015 | 5949 | 45 |
1043679 | 1043679 | 2021-02-18 | Calumet | Wisconsin | 55015 | 5935 | 45 |
1040434 | 1040434 | 2021-02-17 | Calumet | Wisconsin | 55015 | 5928 | 44 |
1037189 | 1037189 | 2021-02-16 | Calumet | Wisconsin | 55015 | 5922 | 43 |
1033944 | 1033944 | 2021-02-15 | Calumet | Wisconsin | 55015 | 5916 | 43 |
1030698 | 1030698 | 2021-02-14 | Calumet | Wisconsin | 55015 | 5910 | 43 |
1027451 | 1027451 | 2021-02-13 | Calumet | Wisconsin | 55015 | 5904 | 43 |
1024206 | 1024206 | 2021-02-12 | Calumet | Wisconsin | 55015 | 5893 | 43 |
1020961 | 1020961 | 2021-02-11 | Calumet | Wisconsin | 55015 | 5885 | 42 |
1017716 | 1017716 | 2021-02-10 | Calumet | Wisconsin | 55015 | 5865 | 42 |
1014471 | 1014471 | 2021-02-09 | Calumet | Wisconsin | 55015 | 5854 | 41 |
1011226 | 1011226 | 2021-02-08 | Calumet | Wisconsin | 55015 | 5844 | 41 |
1007980 | 1007980 | 2021-02-07 | Calumet | Wisconsin | 55015 | 5833 | 41 |
1004734 | 1004734 | 2021-02-06 | Calumet | Wisconsin | 55015 | 5830 | 41 |
1001488 | 1001488 | 2021-02-05 | Calumet | Wisconsin | 55015 | 5820 | 41 |
998242 | 998242 | 2021-02-04 | Calumet | Wisconsin | 55015 | 5801 | 41 |
994996 | 994996 | 2021-02-03 | Calumet | Wisconsin | 55015 | 5769 | 41 |
991750 | 991750 | 2021-02-02 | Calumet | Wisconsin | 55015 | 5746 | 41 |
988504 | 988504 | 2021-02-01 | Calumet | Wisconsin | 55015 | 5738 | 41 |
985257 | 985257 | 2021-01-31 | Calumet | Wisconsin | 55015 | 5727 | 41 |
982010 | 982010 | 2021-01-30 | Calumet | Wisconsin | 55015 | 5706 | 41 |
978764 | 978764 | 2021-01-29 | Calumet | Wisconsin | 55015 | 5683 | 41 |
975519 | 975519 | 2021-01-28 | Calumet | Wisconsin | 55015 | 5660 | 41 |
972274 | 972274 | 2021-01-27 | Calumet | Wisconsin | 55015 | 5633 | 41 |
969029 | 969029 | 2021-01-26 | Calumet | Wisconsin | 55015 | 5619 | 41 |
965785 | 965785 | 2021-01-25 | Calumet | Wisconsin | 55015 | 5595 | 41 |
962540 | 962540 | 2021-01-24 | Calumet | Wisconsin | 55015 | 5580 | 41 |
959295 | 959295 | 2021-01-23 | Calumet | Wisconsin | 55015 | 5557 | 41 |
956049 | 956049 | 2021-01-22 | Calumet | Wisconsin | 55015 | 5539 | 41 |
952804 | 952804 | 2021-01-21 | Calumet | Wisconsin | 55015 | 5522 | 41 |
949559 | 949559 | 2021-01-20 | Calumet | Wisconsin | 55015 | 5499 | 41 |
946313 | 946313 | 2021-01-19 | Calumet | Wisconsin | 55015 | 5485 | 41 |
943066 | 943066 | 2021-01-18 | Calumet | Wisconsin | 55015 | 5473 | 40 |
939821 | 939821 | 2021-01-17 | Calumet | Wisconsin | 55015 | 5466 | 40 |
936576 | 936576 | 2021-01-16 | Calumet | Wisconsin | 55015 | 5451 | 40 |
933331 | 933331 | 2021-01-15 | Calumet | Wisconsin | 55015 | 5410 | 40 |
930086 | 930086 | 2021-01-14 | Calumet | Wisconsin | 55015 | 5380 | 40 |
926841 | 926841 | 2021-01-13 | Calumet | Wisconsin | 55015 | 5359 | 40 |
923595 | 923595 | 2021-01-12 | Calumet | Wisconsin | 55015 | 5331 | 40 |
920350 | 920350 | 2021-01-11 | Calumet | Wisconsin | 55015 | 5315 | 39 |
917105 | 917105 | 2021-01-10 | Calumet | Wisconsin | 55015 | 5294 | 39 |
913860 | 913860 | 2021-01-09 | Calumet | Wisconsin | 55015 | 5261 | 39 |
910615 | 910615 | 2021-01-08 | Calumet | Wisconsin | 55015 | 5220 | 38 |
907370 | 907370 | 2021-01-07 | Calumet | Wisconsin | 55015 | 5177 | 38 |
904124 | 904124 | 2021-01-06 | Calumet | Wisconsin | 55015 | 5142 | 37 |
900879 | 900879 | 2021-01-05 | Calumet | Wisconsin | 55015 | 5110 | 37 |
897634 | 897634 | 2021-01-04 | Calumet | Wisconsin | 55015 | 5089 | 37 |
894388 | 894388 | 2021-01-03 | Calumet | Wisconsin | 55015 | 5075 | 37 |
891142 | 891142 | 2021-01-02 | Calumet | Wisconsin | 55015 | 5054 | 37 |
887895 | 887895 | 2021-01-01 | Calumet | Wisconsin | 55015 | 5040 | 37 |
884650 | 884650 | 2020-12-31 | Calumet | Wisconsin | 55015 | 5015 | 37 |
881405 | 881405 | 2020-12-30 | Calumet | Wisconsin | 55015 | 4980 | 37 |
878160 | 878160 | 2020-12-29 | Calumet | Wisconsin | 55015 | 4947 | 37 |
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);