ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 55093 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199558 | 1199558 | 2021-04-07 | Pierce | Wisconsin | 55093 | 4614 | 41 |
1196309 | 1196309 | 2021-04-06 | Pierce | Wisconsin | 55093 | 4599 | 41 |
1193061 | 1193061 | 2021-04-05 | Pierce | Wisconsin | 55093 | 4596 | 41 |
1189811 | 1189811 | 2021-04-04 | Pierce | Wisconsin | 55093 | 4592 | 41 |
1186564 | 1186564 | 2021-04-03 | Pierce | Wisconsin | 55093 | 4585 | 41 |
1183317 | 1183317 | 2021-04-02 | Pierce | Wisconsin | 55093 | 4571 | 41 |
1180070 | 1180070 | 2021-04-01 | Pierce | Wisconsin | 55093 | 4563 | 41 |
1176823 | 1176823 | 2021-03-31 | Pierce | Wisconsin | 55093 | 4547 | 41 |
1173576 | 1173576 | 2021-03-30 | Pierce | Wisconsin | 55093 | 4538 | 41 |
1170329 | 1170329 | 2021-03-29 | Pierce | Wisconsin | 55093 | 4530 | 41 |
1167081 | 1167081 | 2021-03-28 | Pierce | Wisconsin | 55093 | 4527 | 41 |
1163833 | 1163833 | 2021-03-27 | Pierce | Wisconsin | 55093 | 4525 | 41 |
1160585 | 1160585 | 2021-03-26 | Pierce | Wisconsin | 55093 | 4516 | 41 |
1157337 | 1157337 | 2021-03-25 | Pierce | Wisconsin | 55093 | 4502 | 41 |
1154090 | 1154090 | 2021-03-24 | Pierce | Wisconsin | 55093 | 4492 | 41 |
1150843 | 1150843 | 2021-03-23 | Pierce | Wisconsin | 55093 | 4487 | 41 |
1147596 | 1147596 | 2021-03-22 | Pierce | Wisconsin | 55093 | 4487 | 41 |
1144349 | 1144349 | 2021-03-21 | Pierce | Wisconsin | 55093 | 4482 | 41 |
1141102 | 1141102 | 2021-03-20 | Pierce | Wisconsin | 55093 | 4478 | 41 |
1137856 | 1137856 | 2021-03-19 | Pierce | Wisconsin | 55093 | 4471 | 41 |
1134610 | 1134610 | 2021-03-18 | Pierce | Wisconsin | 55093 | 4460 | 40 |
1131362 | 1131362 | 2021-03-17 | Pierce | Wisconsin | 55093 | 4450 | 40 |
1128115 | 1128115 | 2021-03-16 | Pierce | Wisconsin | 55093 | 4446 | 39 |
1124869 | 1124869 | 2021-03-15 | Pierce | Wisconsin | 55093 | 4438 | 39 |
1121623 | 1121623 | 2021-03-14 | Pierce | Wisconsin | 55093 | 4433 | 39 |
1118376 | 1118376 | 2021-03-13 | Pierce | Wisconsin | 55093 | 4429 | 39 |
1115129 | 1115129 | 2021-03-12 | Pierce | Wisconsin | 55093 | 4414 | 39 |
1111883 | 1111883 | 2021-03-11 | Pierce | Wisconsin | 55093 | 4410 | 39 |
1108637 | 1108637 | 2021-03-10 | Pierce | Wisconsin | 55093 | 4403 | 39 |
1105391 | 1105391 | 2021-03-09 | Pierce | Wisconsin | 55093 | 4395 | 39 |
1102145 | 1102145 | 2021-03-08 | Pierce | Wisconsin | 55093 | 4394 | 39 |
1098899 | 1098899 | 2021-03-07 | Pierce | Wisconsin | 55093 | 4390 | 39 |
1095651 | 1095651 | 2021-03-06 | Pierce | Wisconsin | 55093 | 4389 | 39 |
1092405 | 1092405 | 2021-03-05 | Pierce | Wisconsin | 55093 | 4386 | 39 |
1089159 | 1089159 | 2021-03-04 | Pierce | Wisconsin | 55093 | 4380 | 39 |
1085914 | 1085914 | 2021-03-03 | Pierce | Wisconsin | 55093 | 4377 | 39 |
1082668 | 1082668 | 2021-03-02 | Pierce | Wisconsin | 55093 | 4373 | 39 |
1079422 | 1079422 | 2021-03-01 | Pierce | Wisconsin | 55093 | 4367 | 39 |
1076177 | 1076177 | 2021-02-28 | Pierce | Wisconsin | 55093 | 4366 | 39 |
1072931 | 1072931 | 2021-02-27 | Pierce | Wisconsin | 55093 | 4361 | 39 |
1069685 | 1069685 | 2021-02-26 | Pierce | Wisconsin | 55093 | 4355 | 39 |
1066440 | 1066440 | 2021-02-25 | Pierce | Wisconsin | 55093 | 4344 | 39 |
1063195 | 1063195 | 2021-02-24 | Pierce | Wisconsin | 55093 | 4337 | 39 |
1059950 | 1059950 | 2021-02-23 | Pierce | Wisconsin | 55093 | 4325 | 39 |
1056704 | 1056704 | 2021-02-22 | Pierce | Wisconsin | 55093 | 4315 | 39 |
1053458 | 1053458 | 2021-02-21 | Pierce | Wisconsin | 55093 | 4315 | 39 |
1050211 | 1050211 | 2021-02-20 | Pierce | Wisconsin | 55093 | 4312 | 39 |
1046964 | 1046964 | 2021-02-19 | Pierce | Wisconsin | 55093 | 4310 | 39 |
1043719 | 1043719 | 2021-02-18 | Pierce | Wisconsin | 55093 | 4301 | 39 |
1040474 | 1040474 | 2021-02-17 | Pierce | Wisconsin | 55093 | 4295 | 39 |
1037229 | 1037229 | 2021-02-16 | Pierce | Wisconsin | 55093 | 4291 | 39 |
1033984 | 1033984 | 2021-02-15 | Pierce | Wisconsin | 55093 | 4284 | 39 |
1030738 | 1030738 | 2021-02-14 | Pierce | Wisconsin | 55093 | 4282 | 39 |
1027491 | 1027491 | 2021-02-13 | Pierce | Wisconsin | 55093 | 4277 | 39 |
1024246 | 1024246 | 2021-02-12 | Pierce | Wisconsin | 55093 | 4272 | 39 |
1021001 | 1021001 | 2021-02-11 | Pierce | Wisconsin | 55093 | 4263 | 39 |
1017756 | 1017756 | 2021-02-10 | Pierce | Wisconsin | 55093 | 4258 | 39 |
1014511 | 1014511 | 2021-02-09 | Pierce | Wisconsin | 55093 | 4241 | 39 |
1011266 | 1011266 | 2021-02-08 | Pierce | Wisconsin | 55093 | 4227 | 39 |
1008020 | 1008020 | 2021-02-07 | Pierce | Wisconsin | 55093 | 4227 | 39 |
1004774 | 1004774 | 2021-02-06 | Pierce | Wisconsin | 55093 | 4217 | 39 |
1001528 | 1001528 | 2021-02-05 | Pierce | Wisconsin | 55093 | 4200 | 39 |
998282 | 998282 | 2021-02-04 | Pierce | Wisconsin | 55093 | 4193 | 38 |
995036 | 995036 | 2021-02-03 | Pierce | Wisconsin | 55093 | 4178 | 38 |
991790 | 991790 | 2021-02-02 | Pierce | Wisconsin | 55093 | 4160 | 38 |
988544 | 988544 | 2021-02-01 | Pierce | Wisconsin | 55093 | 4145 | 38 |
985297 | 985297 | 2021-01-31 | Pierce | Wisconsin | 55093 | 4141 | 38 |
982050 | 982050 | 2021-01-30 | Pierce | Wisconsin | 55093 | 4134 | 38 |
978804 | 978804 | 2021-01-29 | Pierce | Wisconsin | 55093 | 4121 | 38 |
975559 | 975559 | 2021-01-28 | Pierce | Wisconsin | 55093 | 4094 | 38 |
972314 | 972314 | 2021-01-27 | Pierce | Wisconsin | 55093 | 4078 | 38 |
969069 | 969069 | 2021-01-26 | Pierce | Wisconsin | 55093 | 4066 | 37 |
965825 | 965825 | 2021-01-25 | Pierce | Wisconsin | 55093 | 4054 | 37 |
962580 | 962580 | 2021-01-24 | Pierce | Wisconsin | 55093 | 4042 | 37 |
959335 | 959335 | 2021-01-23 | Pierce | Wisconsin | 55093 | 4030 | 37 |
956089 | 956089 | 2021-01-22 | Pierce | Wisconsin | 55093 | 4011 | 37 |
952844 | 952844 | 2021-01-21 | Pierce | Wisconsin | 55093 | 4003 | 37 |
949599 | 949599 | 2021-01-20 | Pierce | Wisconsin | 55093 | 3962 | 37 |
946353 | 946353 | 2021-01-19 | Pierce | Wisconsin | 55093 | 3952 | 37 |
943106 | 943106 | 2021-01-18 | Pierce | Wisconsin | 55093 | 3941 | 37 |
939861 | 939861 | 2021-01-17 | Pierce | Wisconsin | 55093 | 3931 | 37 |
936616 | 936616 | 2021-01-16 | Pierce | Wisconsin | 55093 | 3924 | 37 |
933371 | 933371 | 2021-01-15 | Pierce | Wisconsin | 55093 | 3908 | 37 |
930126 | 930126 | 2021-01-14 | Pierce | Wisconsin | 55093 | 3890 | 35 |
926881 | 926881 | 2021-01-13 | Pierce | Wisconsin | 55093 | 3887 | 35 |
923635 | 923635 | 2021-01-12 | Pierce | Wisconsin | 55093 | 3939 | 35 |
920390 | 920390 | 2021-01-11 | Pierce | Wisconsin | 55093 | 3833 | 35 |
917145 | 917145 | 2021-01-10 | Pierce | Wisconsin | 55093 | 3823 | 35 |
913900 | 913900 | 2021-01-09 | Pierce | Wisconsin | 55093 | 3804 | 35 |
910655 | 910655 | 2021-01-08 | Pierce | Wisconsin | 55093 | 3768 | 35 |
907410 | 907410 | 2021-01-07 | Pierce | Wisconsin | 55093 | 3739 | 35 |
904164 | 904164 | 2021-01-06 | Pierce | Wisconsin | 55093 | 3695 | 35 |
900919 | 900919 | 2021-01-05 | Pierce | Wisconsin | 55093 | 3669 | 35 |
897674 | 897674 | 2021-01-04 | Pierce | Wisconsin | 55093 | 3645 | 35 |
894428 | 894428 | 2021-01-03 | Pierce | Wisconsin | 55093 | 3636 | 35 |
891182 | 891182 | 2021-01-02 | Pierce | Wisconsin | 55093 | 3620 | 35 |
887935 | 887935 | 2021-01-01 | Pierce | Wisconsin | 55093 | 3612 | 35 |
884690 | 884690 | 2020-12-31 | Pierce | Wisconsin | 55093 | 3587 | 35 |
881445 | 881445 | 2020-12-30 | Pierce | Wisconsin | 55093 | 3557 | 35 |
878200 | 878200 | 2020-12-29 | Pierce | Wisconsin | 55093 | 3538 | 34 |
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);