ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Pierce" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
874955 | 874955 | 2020-12-28 | Pierce | Wisconsin | 55093 | 3509 | 34 |
871710 | 871710 | 2020-12-27 | Pierce | Wisconsin | 55093 | 3502 | 33 |
868465 | 868465 | 2020-12-26 | Pierce | Wisconsin | 55093 | 3490 | 33 |
865220 | 865220 | 2020-12-25 | Pierce | Wisconsin | 55093 | 3488 | 33 |
861975 | 861975 | 2020-12-24 | Pierce | Wisconsin | 55093 | 3467 | 32 |
858730 | 858730 | 2020-12-23 | Pierce | Wisconsin | 55093 | 3438 | 31 |
855485 | 855485 | 2020-12-22 | Pierce | Wisconsin | 55093 | 3422 | 30 |
852240 | 852240 | 2020-12-21 | Pierce | Wisconsin | 55093 | 3395 | 30 |
848995 | 848995 | 2020-12-20 | Pierce | Wisconsin | 55093 | 3378 | 30 |
845750 | 845750 | 2020-12-19 | Pierce | Wisconsin | 55093 | 3365 | 30 |
842504 | 842504 | 2020-12-18 | Pierce | Wisconsin | 55093 | 3324 | 30 |
839259 | 839259 | 2020-12-17 | Pierce | Wisconsin | 55093 | 3283 | 28 |
836014 | 836014 | 2020-12-16 | Pierce | Wisconsin | 55093 | 3238 | 28 |
832768 | 832768 | 2020-12-15 | Pierce | Wisconsin | 55093 | 3206 | 28 |
829521 | 829521 | 2020-12-14 | Pierce | Wisconsin | 55093 | 3172 | 26 |
826275 | 826275 | 2020-12-13 | Pierce | Wisconsin | 55093 | 3156 | 26 |
823028 | 823028 | 2020-12-12 | Pierce | Wisconsin | 55093 | 3128 | 26 |
819782 | 819782 | 2020-12-11 | Pierce | Wisconsin | 55093 | 3081 | 26 |
816536 | 816536 | 2020-12-10 | Pierce | Wisconsin | 55093 | 3046 | 25 |
813290 | 813290 | 2020-12-09 | Pierce | Wisconsin | 55093 | 2963 | 24 |
810046 | 810046 | 2020-12-08 | Pierce | Wisconsin | 55093 | 2939 | 24 |
806801 | 806801 | 2020-12-07 | Pierce | Wisconsin | 55093 | 2864 | 23 |
803556 | 803556 | 2020-12-06 | Pierce | Wisconsin | 55093 | 2829 | 23 |
800311 | 800311 | 2020-12-05 | Pierce | Wisconsin | 55093 | 2792 | 23 |
797066 | 797066 | 2020-12-04 | Pierce | Wisconsin | 55093 | 2728 | 23 |
793821 | 793821 | 2020-12-03 | Pierce | Wisconsin | 55093 | 2684 | 23 |
790576 | 790576 | 2020-12-02 | Pierce | Wisconsin | 55093 | 2604 | 23 |
787331 | 787331 | 2020-12-01 | Pierce | Wisconsin | 55093 | 2548 | 22 |
784087 | 784087 | 2020-11-30 | Pierce | Wisconsin | 55093 | 2512 | 21 |
780842 | 780842 | 2020-11-29 | Pierce | Wisconsin | 55093 | 2483 | 21 |
777596 | 777596 | 2020-11-28 | Pierce | Wisconsin | 55093 | 2464 | 21 |
774351 | 774351 | 2020-11-27 | Pierce | Wisconsin | 55093 | 2429 | 21 |
771106 | 771106 | 2020-11-26 | Pierce | Wisconsin | 55093 | 2406 | 20 |
767860 | 767860 | 2020-11-25 | Pierce | Wisconsin | 55093 | 2322 | 20 |
764615 | 764615 | 2020-11-24 | Pierce | Wisconsin | 55093 | 2277 | 21 |
761370 | 761370 | 2020-11-23 | Pierce | Wisconsin | 55093 | 2245 | 21 |
758125 | 758125 | 2020-11-22 | Pierce | Wisconsin | 55093 | 2203 | 20 |
754878 | 754878 | 2020-11-21 | Pierce | Wisconsin | 55093 | 2150 | 20 |
751632 | 751632 | 2020-11-20 | Pierce | Wisconsin | 55093 | 2106 | 19 |
748386 | 748386 | 2020-11-19 | Pierce | Wisconsin | 55093 | 2019 | 15 |
745140 | 745140 | 2020-11-18 | Pierce | Wisconsin | 55093 | 1931 | 14 |
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);