ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55045 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199533 | 1199533 | 2021-04-07 | Green | Wisconsin | 55045 | 3504 | 23 |
1196284 | 1196284 | 2021-04-06 | Green | Wisconsin | 55045 | 3501 | 23 |
1193036 | 1193036 | 2021-04-05 | Green | Wisconsin | 55045 | 3496 | 22 |
1189786 | 1189786 | 2021-04-04 | Green | Wisconsin | 55045 | 3495 | 22 |
1186539 | 1186539 | 2021-04-03 | Green | Wisconsin | 55045 | 3491 | 22 |
1183292 | 1183292 | 2021-04-02 | Green | Wisconsin | 55045 | 3486 | 22 |
1180045 | 1180045 | 2021-04-01 | Green | Wisconsin | 55045 | 3483 | 22 |
1176798 | 1176798 | 2021-03-31 | Green | Wisconsin | 55045 | 3478 | 22 |
1173551 | 1173551 | 2021-03-30 | Green | Wisconsin | 55045 | 3467 | 22 |
1170304 | 1170304 | 2021-03-29 | Green | Wisconsin | 55045 | 3461 | 22 |
1167056 | 1167056 | 2021-03-28 | Green | Wisconsin | 55045 | 3456 | 22 |
1163808 | 1163808 | 2021-03-27 | Green | Wisconsin | 55045 | 3447 | 22 |
1160560 | 1160560 | 2021-03-26 | Green | Wisconsin | 55045 | 3434 | 22 |
1157312 | 1157312 | 2021-03-25 | Green | Wisconsin | 55045 | 3419 | 22 |
1154065 | 1154065 | 2021-03-24 | Green | Wisconsin | 55045 | 3410 | 22 |
1150818 | 1150818 | 2021-03-23 | Green | Wisconsin | 55045 | 3390 | 22 |
1147571 | 1147571 | 2021-03-22 | Green | Wisconsin | 55045 | 3390 | 22 |
1144324 | 1144324 | 2021-03-21 | Green | Wisconsin | 55045 | 3387 | 22 |
1141077 | 1141077 | 2021-03-20 | Green | Wisconsin | 55045 | 3384 | 22 |
1137831 | 1137831 | 2021-03-19 | Green | Wisconsin | 55045 | 3377 | 22 |
1134585 | 1134585 | 2021-03-18 | Green | Wisconsin | 55045 | 3372 | 23 |
1131337 | 1131337 | 2021-03-17 | Green | Wisconsin | 55045 | 3368 | 23 |
1128090 | 1128090 | 2021-03-16 | Green | Wisconsin | 55045 | 3357 | 23 |
1124844 | 1124844 | 2021-03-15 | Green | Wisconsin | 55045 | 3356 | 23 |
1121598 | 1121598 | 2021-03-14 | Green | Wisconsin | 55045 | 3355 | 23 |
1118351 | 1118351 | 2021-03-13 | Green | Wisconsin | 55045 | 3351 | 23 |
1115104 | 1115104 | 2021-03-12 | Green | Wisconsin | 55045 | 3343 | 23 |
1111858 | 1111858 | 2021-03-11 | Green | Wisconsin | 55045 | 3333 | 23 |
1108612 | 1108612 | 2021-03-10 | Green | Wisconsin | 55045 | 3326 | 23 |
1105366 | 1105366 | 2021-03-09 | Green | Wisconsin | 55045 | 3309 | 23 |
1102120 | 1102120 | 2021-03-08 | Green | Wisconsin | 55045 | 3302 | 22 |
1098874 | 1098874 | 2021-03-07 | Green | Wisconsin | 55045 | 3300 | 22 |
1095626 | 1095626 | 2021-03-06 | Green | Wisconsin | 55045 | 3297 | 22 |
1092380 | 1092380 | 2021-03-05 | Green | Wisconsin | 55045 | 3292 | 22 |
1089134 | 1089134 | 2021-03-04 | Green | Wisconsin | 55045 | 3288 | 22 |
1085889 | 1085889 | 2021-03-03 | Green | Wisconsin | 55045 | 3280 | 22 |
1082643 | 1082643 | 2021-03-02 | Green | Wisconsin | 55045 | 3262 | 22 |
1079397 | 1079397 | 2021-03-01 | Green | Wisconsin | 55045 | 3257 | 22 |
1076152 | 1076152 | 2021-02-28 | Green | Wisconsin | 55045 | 3257 | 22 |
1072906 | 1072906 | 2021-02-27 | Green | Wisconsin | 55045 | 3256 | 22 |
1069660 | 1069660 | 2021-02-26 | Green | Wisconsin | 55045 | 3230 | 22 |
1066415 | 1066415 | 2021-02-25 | Green | Wisconsin | 55045 | 3219 | 22 |
1063170 | 1063170 | 2021-02-24 | Green | Wisconsin | 55045 | 3209 | 22 |
1059925 | 1059925 | 2021-02-23 | Green | Wisconsin | 55045 | 3190 | 22 |
1056679 | 1056679 | 2021-02-22 | Green | Wisconsin | 55045 | 3186 | 22 |
1053433 | 1053433 | 2021-02-21 | Green | Wisconsin | 55045 | 3185 | 22 |
1050186 | 1050186 | 2021-02-20 | Green | Wisconsin | 55045 | 3175 | 22 |
1046939 | 1046939 | 2021-02-19 | Green | Wisconsin | 55045 | 3151 | 22 |
1043694 | 1043694 | 2021-02-18 | Green | Wisconsin | 55045 | 3131 | 22 |
1040449 | 1040449 | 2021-02-17 | Green | Wisconsin | 55045 | 3119 | 22 |
1037204 | 1037204 | 2021-02-16 | Green | Wisconsin | 55045 | 3087 | 22 |
1033959 | 1033959 | 2021-02-15 | Green | Wisconsin | 55045 | 3080 | 22 |
1030713 | 1030713 | 2021-02-14 | Green | Wisconsin | 55045 | 3075 | 22 |
1027466 | 1027466 | 2021-02-13 | Green | Wisconsin | 55045 | 3067 | 22 |
1024221 | 1024221 | 2021-02-12 | Green | Wisconsin | 55045 | 3045 | 22 |
1020976 | 1020976 | 2021-02-11 | Green | Wisconsin | 55045 | 3017 | 21 |
1017731 | 1017731 | 2021-02-10 | Green | Wisconsin | 55045 | 3000 | 21 |
1014486 | 1014486 | 2021-02-09 | Green | Wisconsin | 55045 | 2962 | 21 |
1011241 | 1011241 | 2021-02-08 | Green | Wisconsin | 55045 | 2957 | 19 |
1007995 | 1007995 | 2021-02-07 | Green | Wisconsin | 55045 | 2950 | 19 |
1004749 | 1004749 | 2021-02-06 | Green | Wisconsin | 55045 | 2940 | 19 |
1001503 | 1001503 | 2021-02-05 | Green | Wisconsin | 55045 | 2922 | 19 |
998257 | 998257 | 2021-02-04 | Green | Wisconsin | 55045 | 2901 | 19 |
995011 | 995011 | 2021-02-03 | Green | Wisconsin | 55045 | 2874 | 19 |
991765 | 991765 | 2021-02-02 | Green | Wisconsin | 55045 | 2844 | 19 |
988519 | 988519 | 2021-02-01 | Green | Wisconsin | 55045 | 2837 | 19 |
985272 | 985272 | 2021-01-31 | Green | Wisconsin | 55045 | 2829 | 19 |
982025 | 982025 | 2021-01-30 | Green | Wisconsin | 55045 | 2812 | 19 |
978779 | 978779 | 2021-01-29 | Green | Wisconsin | 55045 | 2805 | 19 |
975534 | 975534 | 2021-01-28 | Green | Wisconsin | 55045 | 2773 | 17 |
972289 | 972289 | 2021-01-27 | Green | Wisconsin | 55045 | 2756 | 17 |
969044 | 969044 | 2021-01-26 | Green | Wisconsin | 55045 | 2730 | 17 |
965800 | 965800 | 2021-01-25 | Green | Wisconsin | 55045 | 2716 | 17 |
962555 | 962555 | 2021-01-24 | Green | Wisconsin | 55045 | 2712 | 17 |
959310 | 959310 | 2021-01-23 | Green | Wisconsin | 55045 | 2705 | 17 |
956064 | 956064 | 2021-01-22 | Green | Wisconsin | 55045 | 2683 | 15 |
952819 | 952819 | 2021-01-21 | Green | Wisconsin | 55045 | 2659 | 15 |
949574 | 949574 | 2021-01-20 | Green | Wisconsin | 55045 | 2649 | 15 |
946328 | 946328 | 2021-01-19 | Green | Wisconsin | 55045 | 2635 | 15 |
943081 | 943081 | 2021-01-18 | Green | Wisconsin | 55045 | 2630 | 15 |
939836 | 939836 | 2021-01-17 | Green | Wisconsin | 55045 | 2625 | 14 |
936591 | 936591 | 2021-01-16 | Green | Wisconsin | 55045 | 2614 | 14 |
933346 | 933346 | 2021-01-15 | Green | Wisconsin | 55045 | 2597 | 14 |
930101 | 930101 | 2021-01-14 | Green | Wisconsin | 55045 | 2578 | 14 |
926856 | 926856 | 2021-01-13 | Green | Wisconsin | 55045 | 2566 | 14 |
923610 | 923610 | 2021-01-12 | Green | Wisconsin | 55045 | 2542 | 14 |
920365 | 920365 | 2021-01-11 | Green | Wisconsin | 55045 | 2527 | 14 |
917120 | 917120 | 2021-01-10 | Green | Wisconsin | 55045 | 2523 | 14 |
913875 | 913875 | 2021-01-09 | Green | Wisconsin | 55045 | 2511 | 14 |
910630 | 910630 | 2021-01-08 | Green | Wisconsin | 55045 | 2489 | 14 |
907385 | 907385 | 2021-01-07 | Green | Wisconsin | 55045 | 2471 | 13 |
904139 | 904139 | 2021-01-06 | Green | Wisconsin | 55045 | 2459 | 13 |
900894 | 900894 | 2021-01-05 | Green | Wisconsin | 55045 | 2438 | 13 |
897649 | 897649 | 2021-01-04 | Green | Wisconsin | 55045 | 2438 | 12 |
894403 | 894403 | 2021-01-03 | Green | Wisconsin | 55045 | 2430 | 12 |
891157 | 891157 | 2021-01-02 | Green | Wisconsin | 55045 | 2430 | 12 |
887910 | 887910 | 2021-01-01 | Green | Wisconsin | 55045 | 2407 | 12 |
884665 | 884665 | 2020-12-31 | Green | Wisconsin | 55045 | 2392 | 12 |
881420 | 881420 | 2020-12-30 | Green | Wisconsin | 55045 | 2376 | 12 |
878175 | 878175 | 2020-12-29 | Green | Wisconsin | 55045 | 2340 | 12 |
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);