ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 55133 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199578 | 1199578 | 2021-04-07 | Waukesha | Wisconsin | 55133 | 47160 | 551 |
1196329 | 1196329 | 2021-04-06 | Waukesha | Wisconsin | 55133 | 47062 | 551 |
1193081 | 1193081 | 2021-04-05 | Waukesha | Wisconsin | 55133 | 46887 | 551 |
1189831 | 1189831 | 2021-04-04 | Waukesha | Wisconsin | 55133 | 46887 | 551 |
1186584 | 1186584 | 2021-04-03 | Waukesha | Wisconsin | 55133 | 46885 | 551 |
1183337 | 1183337 | 2021-04-02 | Waukesha | Wisconsin | 55133 | 46790 | 551 |
1180090 | 1180090 | 2021-04-01 | Waukesha | Wisconsin | 55133 | 46715 | 549 |
1176843 | 1176843 | 2021-03-31 | Waukesha | Wisconsin | 55133 | 46635 | 549 |
1173596 | 1173596 | 2021-03-30 | Waukesha | Wisconsin | 55133 | 46552 | 545 |
1170349 | 1170349 | 2021-03-29 | Waukesha | Wisconsin | 55133 | 46389 | 543 |
1167101 | 1167101 | 2021-03-28 | Waukesha | Wisconsin | 55133 | 46388 | 543 |
1163853 | 1163853 | 2021-03-27 | Waukesha | Wisconsin | 55133 | 46388 | 543 |
1160605 | 1160605 | 2021-03-26 | Waukesha | Wisconsin | 55133 | 46289 | 543 |
1157357 | 1157357 | 2021-03-25 | Waukesha | Wisconsin | 55133 | 46205 | 543 |
1154110 | 1154110 | 2021-03-24 | Waukesha | Wisconsin | 55133 | 46120 | 543 |
1150863 | 1150863 | 2021-03-23 | Waukesha | Wisconsin | 55133 | 45970 | 541 |
1147616 | 1147616 | 2021-03-22 | Waukesha | Wisconsin | 55133 | 45970 | 541 |
1144369 | 1144369 | 2021-03-21 | Waukesha | Wisconsin | 55133 | 45923 | 541 |
1141122 | 1141122 | 2021-03-20 | Waukesha | Wisconsin | 55133 | 45882 | 541 |
1137876 | 1137876 | 2021-03-19 | Waukesha | Wisconsin | 55133 | 45829 | 539 |
1134630 | 1134630 | 2021-03-18 | Waukesha | Wisconsin | 55133 | 45740 | 537 |
1131382 | 1131382 | 2021-03-17 | Waukesha | Wisconsin | 55133 | 45664 | 537 |
1128135 | 1128135 | 2021-03-16 | Waukesha | Wisconsin | 55133 | 45570 | 535 |
1124889 | 1124889 | 2021-03-15 | Waukesha | Wisconsin | 55133 | 45501 | 535 |
1121643 | 1121643 | 2021-03-14 | Waukesha | Wisconsin | 55133 | 45456 | 535 |
1118396 | 1118396 | 2021-03-13 | Waukesha | Wisconsin | 55133 | 45442 | 535 |
1115149 | 1115149 | 2021-03-12 | Waukesha | Wisconsin | 55133 | 45385 | 534 |
1111903 | 1111903 | 2021-03-11 | Waukesha | Wisconsin | 55133 | 45322 | 534 |
1108657 | 1108657 | 2021-03-10 | Waukesha | Wisconsin | 55133 | 45269 | 534 |
1105411 | 1105411 | 2021-03-09 | Waukesha | Wisconsin | 55133 | 45214 | 532 |
1102165 | 1102165 | 2021-03-08 | Waukesha | Wisconsin | 55133 | 45147 | 532 |
1098919 | 1098919 | 2021-03-07 | Waukesha | Wisconsin | 55133 | 45147 | 532 |
1095671 | 1095671 | 2021-03-06 | Waukesha | Wisconsin | 55133 | 45136 | 531 |
1092425 | 1092425 | 2021-03-05 | Waukesha | Wisconsin | 55133 | 45088 | 527 |
1089179 | 1089179 | 2021-03-04 | Waukesha | Wisconsin | 55133 | 45031 | 527 |
1085934 | 1085934 | 2021-03-03 | Waukesha | Wisconsin | 55133 | 44937 | 527 |
1082688 | 1082688 | 2021-03-02 | Waukesha | Wisconsin | 55133 | 44867 | 527 |
1079442 | 1079442 | 2021-03-01 | Waukesha | Wisconsin | 55133 | 44813 | 525 |
1076197 | 1076197 | 2021-02-28 | Waukesha | Wisconsin | 55133 | 44784 | 525 |
1072951 | 1072951 | 2021-02-27 | Waukesha | Wisconsin | 55133 | 44743 | 525 |
1069705 | 1069705 | 2021-02-26 | Waukesha | Wisconsin | 55133 | 44677 | 525 |
1066460 | 1066460 | 2021-02-25 | Waukesha | Wisconsin | 55133 | 44637 | 525 |
1063215 | 1063215 | 2021-02-24 | Waukesha | Wisconsin | 55133 | 44574 | 523 |
1059970 | 1059970 | 2021-02-23 | Waukesha | Wisconsin | 55133 | 44508 | 521 |
1056724 | 1056724 | 2021-02-22 | Waukesha | Wisconsin | 55133 | 44449 | 514 |
1053478 | 1053478 | 2021-02-21 | Waukesha | Wisconsin | 55133 | 44382 | 514 |
1050231 | 1050231 | 2021-02-20 | Waukesha | Wisconsin | 55133 | 44363 | 514 |
1046984 | 1046984 | 2021-02-19 | Waukesha | Wisconsin | 55133 | 44289 | 513 |
1043739 | 1043739 | 2021-02-18 | Waukesha | Wisconsin | 55133 | 44243 | 511 |
1040494 | 1040494 | 2021-02-17 | Waukesha | Wisconsin | 55133 | 44187 | 510 |
1037249 | 1037249 | 2021-02-16 | Waukesha | Wisconsin | 55133 | 44118 | 510 |
1034004 | 1034004 | 2021-02-15 | Waukesha | Wisconsin | 55133 | 44068 | 509 |
1030758 | 1030758 | 2021-02-14 | Waukesha | Wisconsin | 55133 | 44016 | 509 |
1027511 | 1027511 | 2021-02-13 | Waukesha | Wisconsin | 55133 | 43999 | 509 |
1024266 | 1024266 | 2021-02-12 | Waukesha | Wisconsin | 55133 | 43922 | 509 |
1021021 | 1021021 | 2021-02-11 | Waukesha | Wisconsin | 55133 | 43820 | 509 |
1017776 | 1017776 | 2021-02-10 | Waukesha | Wisconsin | 55133 | 43704 | 505 |
1014531 | 1014531 | 2021-02-09 | Waukesha | Wisconsin | 55133 | 43699 | 501 |
1011286 | 1011286 | 2021-02-08 | Waukesha | Wisconsin | 55133 | 43623 | 498 |
1008040 | 1008040 | 2021-02-07 | Waukesha | Wisconsin | 55133 | 43566 | 498 |
1004794 | 1004794 | 2021-02-06 | Waukesha | Wisconsin | 55133 | 43515 | 498 |
1001548 | 1001548 | 2021-02-05 | Waukesha | Wisconsin | 55133 | 43430 | 494 |
998302 | 998302 | 2021-02-04 | Waukesha | Wisconsin | 55133 | 43323 | 492 |
995056 | 995056 | 2021-02-03 | Waukesha | Wisconsin | 55133 | 43201 | 490 |
991810 | 991810 | 2021-02-02 | Waukesha | Wisconsin | 55133 | 43103 | 488 |
988564 | 988564 | 2021-02-01 | Waukesha | Wisconsin | 55133 | 42997 | 485 |
985317 | 985317 | 2021-01-31 | Waukesha | Wisconsin | 55133 | 42919 | 485 |
982070 | 982070 | 2021-01-30 | Waukesha | Wisconsin | 55133 | 42861 | 485 |
978824 | 978824 | 2021-01-29 | Waukesha | Wisconsin | 55133 | 42748 | 482 |
975579 | 975579 | 2021-01-28 | Waukesha | Wisconsin | 55133 | 42626 | 475 |
972334 | 972334 | 2021-01-27 | Waukesha | Wisconsin | 55133 | 42495 | 469 |
969089 | 969089 | 2021-01-26 | Waukesha | Wisconsin | 55133 | 42402 | 465 |
965845 | 965845 | 2021-01-25 | Waukesha | Wisconsin | 55133 | 42303 | 457 |
962600 | 962600 | 2021-01-24 | Waukesha | Wisconsin | 55133 | 42223 | 455 |
959355 | 959355 | 2021-01-23 | Waukesha | Wisconsin | 55133 | 42157 | 455 |
956109 | 956109 | 2021-01-22 | Waukesha | Wisconsin | 55133 | 42066 | 449 |
952864 | 952864 | 2021-01-21 | Waukesha | Wisconsin | 55133 | 41881 | 443 |
949619 | 949619 | 2021-01-20 | Waukesha | Wisconsin | 55133 | 41689 | 438 |
946373 | 946373 | 2021-01-19 | Waukesha | Wisconsin | 55133 | 41567 | 431 |
943126 | 943126 | 2021-01-18 | Waukesha | Wisconsin | 55133 | 41414 | 424 |
939881 | 939881 | 2021-01-17 | Waukesha | Wisconsin | 55133 | 41264 | 424 |
936636 | 936636 | 2021-01-16 | Waukesha | Wisconsin | 55133 | 41121 | 424 |
933391 | 933391 | 2021-01-15 | Waukesha | Wisconsin | 55133 | 40939 | 415 |
930146 | 930146 | 2021-01-14 | Waukesha | Wisconsin | 55133 | 40764 | 410 |
926901 | 926901 | 2021-01-13 | Waukesha | Wisconsin | 55133 | 40520 | 410 |
923655 | 923655 | 2021-01-12 | Waukesha | Wisconsin | 55133 | 40300 | 407 |
920410 | 920410 | 2021-01-11 | Waukesha | Wisconsin | 55133 | 40018 | 403 |
917165 | 917165 | 2021-01-10 | Waukesha | Wisconsin | 55133 | 39783 | 403 |
913920 | 913920 | 2021-01-09 | Waukesha | Wisconsin | 55133 | 39704 | 403 |
910675 | 910675 | 2021-01-08 | Waukesha | Wisconsin | 55133 | 39420 | 402 |
907430 | 907430 | 2021-01-07 | Waukesha | Wisconsin | 55133 | 39107 | 396 |
904184 | 904184 | 2021-01-06 | Waukesha | Wisconsin | 55133 | 38572 | 393 |
900939 | 900939 | 2021-01-05 | Waukesha | Wisconsin | 55133 | 38233 | 384 |
897694 | 897694 | 2021-01-04 | Waukesha | Wisconsin | 55133 | 37600 | 370 |
894448 | 894448 | 2021-01-03 | Waukesha | Wisconsin | 55133 | 37389 | 370 |
891202 | 891202 | 2021-01-02 | Waukesha | Wisconsin | 55133 | 37255 | 370 |
887955 | 887955 | 2021-01-01 | Waukesha | Wisconsin | 55133 | 37254 | 370 |
884710 | 884710 | 2020-12-31 | Waukesha | Wisconsin | 55133 | 37252 | 370 |
881465 | 881465 | 2020-12-30 | Waukesha | Wisconsin | 55133 | 36894 | 364 |
878220 | 878220 | 2020-12-29 | Waukesha | Wisconsin | 55133 | 36771 | 354 |
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);