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 |
---|---|---|---|---|---|---|---|
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 |
845712 | 845712 | 2020-12-19 | Clark | Wisconsin | 55019 | 2903 | 50 |
842466 | 842466 | 2020-12-18 | Clark | Wisconsin | 55019 | 2848 | 50 |
839221 | 839221 | 2020-12-17 | Clark | Wisconsin | 55019 | 2828 | 50 |
835976 | 835976 | 2020-12-16 | Clark | Wisconsin | 55019 | 2792 | 49 |
832730 | 832730 | 2020-12-15 | Clark | Wisconsin | 55019 | 2764 | 48 |
829483 | 829483 | 2020-12-14 | Clark | Wisconsin | 55019 | 2742 | 48 |
826237 | 826237 | 2020-12-13 | Clark | Wisconsin | 55019 | 2740 | 48 |
822990 | 822990 | 2020-12-12 | Clark | Wisconsin | 55019 | 2724 | 48 |
819744 | 819744 | 2020-12-11 | Clark | Wisconsin | 55019 | 2699 | 48 |
816498 | 816498 | 2020-12-10 | Clark | Wisconsin | 55019 | 2666 | 47 |
813252 | 813252 | 2020-12-09 | Clark | Wisconsin | 55019 | 2612 | 47 |
810008 | 810008 | 2020-12-08 | Clark | Wisconsin | 55019 | 2582 | 47 |
806763 | 806763 | 2020-12-07 | Clark | Wisconsin | 55019 | 2558 | 47 |
803518 | 803518 | 2020-12-06 | Clark | Wisconsin | 55019 | 2540 | 47 |
800273 | 800273 | 2020-12-05 | Clark | Wisconsin | 55019 | 2528 | 47 |
797028 | 797028 | 2020-12-04 | Clark | Wisconsin | 55019 | 2489 | 47 |
793783 | 793783 | 2020-12-03 | Clark | Wisconsin | 55019 | 2429 | 45 |
790538 | 790538 | 2020-12-02 | Clark | Wisconsin | 55019 | 2407 | 45 |
787293 | 787293 | 2020-12-01 | Clark | Wisconsin | 55019 | 2362 | 44 |
784049 | 784049 | 2020-11-30 | Clark | Wisconsin | 55019 | 2326 | 41 |
780804 | 780804 | 2020-11-29 | Clark | Wisconsin | 55019 | 2317 | 41 |
777558 | 777558 | 2020-11-28 | Clark | Wisconsin | 55019 | 2292 | 40 |
774313 | 774313 | 2020-11-27 | Clark | Wisconsin | 55019 | 2273 | 40 |
771068 | 771068 | 2020-11-26 | Clark | Wisconsin | 55019 | 2251 | 40 |
767822 | 767822 | 2020-11-25 | Clark | Wisconsin | 55019 | 2219 | 39 |
764577 | 764577 | 2020-11-24 | Clark | Wisconsin | 55019 | 2163 | 37 |
761332 | 761332 | 2020-11-23 | Clark | Wisconsin | 55019 | 2121 | 36 |
758087 | 758087 | 2020-11-22 | Clark | Wisconsin | 55019 | 2106 | 36 |
754840 | 754840 | 2020-11-21 | Clark | Wisconsin | 55019 | 2059 | 36 |
751594 | 751594 | 2020-11-20 | Clark | Wisconsin | 55019 | 2015 | 35 |
748348 | 748348 | 2020-11-19 | Clark | Wisconsin | 55019 | 1965 | 34 |
745102 | 745102 | 2020-11-18 | Clark | Wisconsin | 55019 | 1923 | 33 |
741855 | 741855 | 2020-11-17 | Clark | Wisconsin | 55019 | 1873 | 33 |
738608 | 738608 | 2020-11-16 | Clark | Wisconsin | 55019 | 1823 | 27 |
735364 | 735364 | 2020-11-15 | Clark | Wisconsin | 55019 | 1805 | 27 |
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);