ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Waukesha" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
874975 | 874975 | 2020-12-28 | Waukesha | Wisconsin | 55133 | 36432 | 351 |
871730 | 871730 | 2020-12-27 | Waukesha | Wisconsin | 55133 | 36079 | 351 |
868485 | 868485 | 2020-12-26 | Waukesha | Wisconsin | 55133 | 35944 | 351 |
865240 | 865240 | 2020-12-25 | Waukesha | Wisconsin | 55133 | 35944 | 351 |
861995 | 861995 | 2020-12-24 | Waukesha | Wisconsin | 55133 | 35902 | 351 |
858750 | 858750 | 2020-12-23 | Waukesha | Wisconsin | 55133 | 35573 | 336 |
855505 | 855505 | 2020-12-22 | Waukesha | Wisconsin | 55133 | 35422 | 329 |
852260 | 852260 | 2020-12-21 | Waukesha | Wisconsin | 55133 | 35107 | 324 |
849015 | 849015 | 2020-12-20 | Waukesha | Wisconsin | 55133 | 34900 | 324 |
845770 | 845770 | 2020-12-19 | Waukesha | Wisconsin | 55133 | 34814 | 324 |
842524 | 842524 | 2020-12-18 | Waukesha | Wisconsin | 55133 | 34478 | 318 |
839279 | 839279 | 2020-12-17 | Waukesha | Wisconsin | 55133 | 34176 | 314 |
836034 | 836034 | 2020-12-16 | Waukesha | Wisconsin | 55133 | 33841 | 311 |
832788 | 832788 | 2020-12-15 | Waukesha | Wisconsin | 55133 | 33676 | 308 |
829541 | 829541 | 2020-12-14 | Waukesha | Wisconsin | 55133 | 33004 | 303 |
826295 | 826295 | 2020-12-13 | Waukesha | Wisconsin | 55133 | 32730 | 301 |
823048 | 823048 | 2020-12-12 | Waukesha | Wisconsin | 55133 | 32498 | 298 |
819802 | 819802 | 2020-12-11 | Waukesha | Wisconsin | 55133 | 32217 | 292 |
816556 | 816556 | 2020-12-10 | Waukesha | Wisconsin | 55133 | 31864 | 286 |
813310 | 813310 | 2020-12-09 | Waukesha | Wisconsin | 55133 | 31473 | 278 |
810066 | 810066 | 2020-12-08 | Waukesha | Wisconsin | 55133 | 31179 | 261 |
806821 | 806821 | 2020-12-07 | Waukesha | Wisconsin | 55133 | 30776 | 247 |
803576 | 803576 | 2020-12-06 | Waukesha | Wisconsin | 55133 | 30546 | 244 |
800331 | 800331 | 2020-12-05 | Waukesha | Wisconsin | 55133 | 30414 | 243 |
797086 | 797086 | 2020-12-04 | Waukesha | Wisconsin | 55133 | 29812 | 233 |
793841 | 793841 | 2020-12-03 | Waukesha | Wisconsin | 55133 | 29460 | 226 |
790596 | 790596 | 2020-12-02 | Waukesha | Wisconsin | 55133 | 29119 | 221 |
787351 | 787351 | 2020-12-01 | Waukesha | Wisconsin | 55133 | 28790 | 214 |
784107 | 784107 | 2020-11-30 | Waukesha | Wisconsin | 55133 | 28352 | 209 |
780862 | 780862 | 2020-11-29 | Waukesha | Wisconsin | 55133 | 28054 | 205 |
777616 | 777616 | 2020-11-28 | Waukesha | Wisconsin | 55133 | 27726 | 205 |
774371 | 774371 | 2020-11-27 | Waukesha | Wisconsin | 55133 | 27464 | 202 |
771126 | 771126 | 2020-11-26 | Waukesha | Wisconsin | 55133 | 27462 | 202 |
767880 | 767880 | 2020-11-25 | Waukesha | Wisconsin | 55133 | 26938 | 196 |
764635 | 764635 | 2020-11-24 | Waukesha | Wisconsin | 55133 | 26438 | 190 |
761390 | 761390 | 2020-11-23 | Waukesha | Wisconsin | 55133 | 25738 | 188 |
758145 | 758145 | 2020-11-22 | Waukesha | Wisconsin | 55133 | 25566 | 187 |
754898 | 754898 | 2020-11-21 | Waukesha | Wisconsin | 55133 | 25542 | 187 |
751652 | 751652 | 2020-11-20 | Waukesha | Wisconsin | 55133 | 25013 | 181 |
748406 | 748406 | 2020-11-19 | Waukesha | Wisconsin | 55133 | 24298 | 173 |
745160 | 745160 | 2020-11-18 | Waukesha | Wisconsin | 55133 | 23149 | 171 |
741913 | 741913 | 2020-11-17 | Waukesha | Wisconsin | 55133 | 21758 | 169 |
738666 | 738666 | 2020-11-16 | Waukesha | Wisconsin | 55133 | 20617 | 167 |
735422 | 735422 | 2020-11-15 | Waukesha | Wisconsin | 55133 | 20329 | 167 |
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);