ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Clark" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1170291 | 1170291 | 2021-03-29 | Clark | Wisconsin | 55019 | 3559 | 62 |
1167043 | 1167043 | 2021-03-28 | Clark | Wisconsin | 55019 | 3559 | 62 |
1163795 | 1163795 | 2021-03-27 | Clark | Wisconsin | 55019 | 3558 | 62 |
1160547 | 1160547 | 2021-03-26 | Clark | Wisconsin | 55019 | 3557 | 62 |
1157299 | 1157299 | 2021-03-25 | Clark | Wisconsin | 55019 | 3557 | 62 |
1154052 | 1154052 | 2021-03-24 | Clark | Wisconsin | 55019 | 3556 | 62 |
1150805 | 1150805 | 2021-03-23 | Clark | Wisconsin | 55019 | 3554 | 62 |
1147558 | 1147558 | 2021-03-22 | Clark | Wisconsin | 55019 | 3554 | 62 |
1144311 | 1144311 | 2021-03-21 | Clark | Wisconsin | 55019 | 3554 | 62 |
1141064 | 1141064 | 2021-03-20 | Clark | Wisconsin | 55019 | 3554 | 62 |
1137818 | 1137818 | 2021-03-19 | Clark | Wisconsin | 55019 | 3553 | 62 |
1134572 | 1134572 | 2021-03-18 | Clark | Wisconsin | 55019 | 3553 | 62 |
1131324 | 1131324 | 2021-03-17 | Clark | Wisconsin | 55019 | 3553 | 62 |
1128077 | 1128077 | 2021-03-16 | Clark | Wisconsin | 55019 | 3553 | 62 |
1124831 | 1124831 | 2021-03-15 | Clark | Wisconsin | 55019 | 3553 | 63 |
1121585 | 1121585 | 2021-03-14 | Clark | Wisconsin | 55019 | 3553 | 63 |
1118338 | 1118338 | 2021-03-13 | Clark | Wisconsin | 55019 | 3552 | 63 |
1115091 | 1115091 | 2021-03-12 | Clark | Wisconsin | 55019 | 3552 | 63 |
1111845 | 1111845 | 2021-03-11 | Clark | Wisconsin | 55019 | 3552 | 63 |
1108599 | 1108599 | 2021-03-10 | Clark | Wisconsin | 55019 | 3551 | 62 |
1105353 | 1105353 | 2021-03-09 | Clark | Wisconsin | 55019 | 3553 | 63 |
1102107 | 1102107 | 2021-03-08 | Clark | Wisconsin | 55019 | 3549 | 61 |
1098861 | 1098861 | 2021-03-07 | Clark | Wisconsin | 55019 | 3549 | 61 |
1095613 | 1095613 | 2021-03-06 | Clark | Wisconsin | 55019 | 3549 | 61 |
1092367 | 1092367 | 2021-03-05 | Clark | Wisconsin | 55019 | 3547 | 61 |
1089121 | 1089121 | 2021-03-04 | Clark | Wisconsin | 55019 | 3547 | 61 |
1085876 | 1085876 | 2021-03-03 | Clark | Wisconsin | 55019 | 3546 | 61 |
1082630 | 1082630 | 2021-03-02 | Clark | Wisconsin | 55019 | 3546 | 61 |
1079384 | 1079384 | 2021-03-01 | Clark | Wisconsin | 55019 | 3543 | 61 |
1076139 | 1076139 | 2021-02-28 | Clark | Wisconsin | 55019 | 3543 | 61 |
1072893 | 1072893 | 2021-02-27 | Clark | Wisconsin | 55019 | 3543 | 61 |
1069647 | 1069647 | 2021-02-26 | Clark | Wisconsin | 55019 | 3542 | 61 |
1066402 | 1066402 | 2021-02-25 | Clark | Wisconsin | 55019 | 3542 | 61 |
1063157 | 1063157 | 2021-02-24 | Clark | Wisconsin | 55019 | 3541 | 61 |
1059912 | 1059912 | 2021-02-23 | Clark | Wisconsin | 55019 | 3539 | 61 |
1056666 | 1056666 | 2021-02-22 | Clark | Wisconsin | 55019 | 3533 | 61 |
1053420 | 1053420 | 2021-02-21 | Clark | Wisconsin | 55019 | 3533 | 61 |
1050173 | 1050173 | 2021-02-20 | Clark | Wisconsin | 55019 | 3533 | 61 |
1046926 | 1046926 | 2021-02-19 | Clark | Wisconsin | 55019 | 3533 | 61 |
1043681 | 1043681 | 2021-02-18 | Clark | Wisconsin | 55019 | 3534 | 61 |
1040436 | 1040436 | 2021-02-17 | Clark | Wisconsin | 55019 | 3529 | 61 |
1037191 | 1037191 | 2021-02-16 | Clark | Wisconsin | 55019 | 3527 | 61 |
1033946 | 1033946 | 2021-02-15 | Clark | Wisconsin | 55019 | 3526 | 61 |
1030700 | 1030700 | 2021-02-14 | Clark | Wisconsin | 55019 | 3525 | 61 |
1027453 | 1027453 | 2021-02-13 | Clark | Wisconsin | 55019 | 3522 | 60 |
1024208 | 1024208 | 2021-02-12 | Clark | Wisconsin | 55019 | 3517 | 60 |
1020963 | 1020963 | 2021-02-11 | Clark | Wisconsin | 55019 | 3511 | 60 |
1017718 | 1017718 | 2021-02-10 | Clark | Wisconsin | 55019 | 3504 | 60 |
1014473 | 1014473 | 2021-02-09 | Clark | Wisconsin | 55019 | 3504 | 60 |
1011228 | 1011228 | 2021-02-08 | Clark | Wisconsin | 55019 | 3503 | 60 |
1007982 | 1007982 | 2021-02-07 | Clark | Wisconsin | 55019 | 3502 | 60 |
1004736 | 1004736 | 2021-02-06 | Clark | Wisconsin | 55019 | 3500 | 60 |
1001490 | 1001490 | 2021-02-05 | Clark | Wisconsin | 55019 | 3494 | 60 |
998244 | 998244 | 2021-02-04 | Clark | Wisconsin | 55019 | 3482 | 60 |
994998 | 994998 | 2021-02-03 | Clark | Wisconsin | 55019 | 3478 | 60 |
991752 | 991752 | 2021-02-02 | Clark | Wisconsin | 55019 | 3473 | 60 |
988506 | 988506 | 2021-02-01 | Clark | Wisconsin | 55019 | 3471 | 60 |
985259 | 985259 | 2021-01-31 | Clark | Wisconsin | 55019 | 3471 | 60 |
982012 | 982012 | 2021-01-30 | Clark | Wisconsin | 55019 | 3462 | 60 |
978766 | 978766 | 2021-01-29 | Clark | Wisconsin | 55019 | 3453 | 60 |
975521 | 975521 | 2021-01-28 | Clark | Wisconsin | 55019 | 3446 | 60 |
972276 | 972276 | 2021-01-27 | Clark | Wisconsin | 55019 | 3435 | 60 |
969031 | 969031 | 2021-01-26 | Clark | Wisconsin | 55019 | 3425 | 60 |
965787 | 965787 | 2021-01-25 | Clark | Wisconsin | 55019 | 3413 | 61 |
962542 | 962542 | 2021-01-24 | Clark | Wisconsin | 55019 | 3409 | 61 |
959297 | 959297 | 2021-01-23 | Clark | Wisconsin | 55019 | 3405 | 61 |
956051 | 956051 | 2021-01-22 | Clark | Wisconsin | 55019 | 3397 | 60 |
952806 | 952806 | 2021-01-21 | Clark | Wisconsin | 55019 | 3385 | 60 |
949561 | 949561 | 2021-01-20 | Clark | Wisconsin | 55019 | 3368 | 59 |
946315 | 946315 | 2021-01-19 | Clark | Wisconsin | 55019 | 3351 | 58 |
943068 | 943068 | 2021-01-18 | Clark | Wisconsin | 55019 | 3344 | 58 |
939823 | 939823 | 2021-01-17 | Clark | Wisconsin | 55019 | 3331 | 58 |
936578 | 936578 | 2021-01-16 | Clark | Wisconsin | 55019 | 3323 | 58 |
933333 | 933333 | 2021-01-15 | Clark | Wisconsin | 55019 | 3313 | 58 |
930088 | 930088 | 2021-01-14 | Clark | Wisconsin | 55019 | 3298 | 58 |
926843 | 926843 | 2021-01-13 | Clark | Wisconsin | 55019 | 3285 | 58 |
923597 | 923597 | 2021-01-12 | Clark | Wisconsin | 55019 | 3277 | 58 |
920352 | 920352 | 2021-01-11 | Clark | Wisconsin | 55019 | 3257 | 58 |
917107 | 917107 | 2021-01-10 | Clark | Wisconsin | 55019 | 3251 | 58 |
913862 | 913862 | 2021-01-09 | Clark | Wisconsin | 55019 | 3244 | 58 |
910617 | 910617 | 2021-01-08 | Clark | Wisconsin | 55019 | 3236 | 58 |
907372 | 907372 | 2021-01-07 | Clark | Wisconsin | 55019 | 3213 | 57 |
904126 | 904126 | 2021-01-06 | Clark | Wisconsin | 55019 | 3190 | 57 |
900881 | 900881 | 2021-01-05 | Clark | Wisconsin | 55019 | 3181 | 55 |
897636 | 897636 | 2021-01-04 | Clark | Wisconsin | 55019 | 3167 | 55 |
894390 | 894390 | 2021-01-03 | Clark | Wisconsin | 55019 | 3162 | 55 |
891144 | 891144 | 2021-01-02 | Clark | Wisconsin | 55019 | 3156 | 55 |
887897 | 887897 | 2021-01-01 | Clark | Wisconsin | 55019 | 3122 | 55 |
884652 | 884652 | 2020-12-31 | Clark | Wisconsin | 55019 | 3114 | 55 |
881407 | 881407 | 2020-12-30 | Clark | Wisconsin | 55019 | 3083 | 55 |
878162 | 878162 | 2020-12-29 | Clark | Wisconsin | 55019 | 3040 | 54 |
874917 | 874917 | 2020-12-28 | Clark | Wisconsin | 55019 | 3027 | 53 |
871672 | 871672 | 2020-12-27 | Clark | Wisconsin | 55019 | 3025 | 53 |
868427 | 868427 | 2020-12-26 | Clark | Wisconsin | 55019 | 3010 | 52 |
865182 | 865182 | 2020-12-25 | Clark | Wisconsin | 55019 | 3010 | 52 |
861937 | 861937 | 2020-12-24 | Clark | Wisconsin | 55019 | 2984 | 52 |
858692 | 858692 | 2020-12-23 | Clark | Wisconsin | 55019 | 2965 | 51 |
855447 | 855447 | 2020-12-22 | Clark | Wisconsin | 55019 | 2939 | 51 |
852202 | 852202 | 2020-12-21 | Clark | Wisconsin | 55019 | 2927 | 50 |
848957 | 848957 | 2020-12-20 | Clark | Wisconsin | 55019 | 2913 | 50 |
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);