ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
705 rows where county = "Wrangell City and Borough" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050351 | 1050351 | 2021-02-21 | Wrangell City and Borough | Alaska | 2275 | 26 | 0 |
1047104 | 1047104 | 2021-02-20 | Wrangell City and Borough | Alaska | 2275 | 26 | 0 |
1043859 | 1043859 | 2021-02-19 | Wrangell City and Borough | Alaska | 2275 | 26 | 0 |
1040614 | 1040614 | 2021-02-18 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1037369 | 1037369 | 2021-02-17 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1034124 | 1034124 | 2021-02-16 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1030878 | 1030878 | 2021-02-15 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1027631 | 1027631 | 2021-02-14 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1024386 | 1024386 | 2021-02-13 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1021141 | 1021141 | 2021-02-12 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1017896 | 1017896 | 2021-02-11 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1014651 | 1014651 | 2021-02-10 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1011406 | 1011406 | 2021-02-09 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1008160 | 1008160 | 2021-02-08 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1004914 | 1004914 | 2021-02-07 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1001668 | 1001668 | 2021-02-06 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
998422 | 998422 | 2021-02-05 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
995176 | 995176 | 2021-02-04 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
991930 | 991930 | 2021-02-03 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
988684 | 988684 | 2021-02-02 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
985437 | 985437 | 2021-02-01 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
982190 | 982190 | 2021-01-31 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
978944 | 978944 | 2021-01-30 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
975699 | 975699 | 2021-01-29 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
972454 | 972454 | 2021-01-28 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
969209 | 969209 | 2021-01-27 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
965965 | 965965 | 2021-01-26 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
962720 | 962720 | 2021-01-25 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
959475 | 959475 | 2021-01-24 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
956229 | 956229 | 2021-01-23 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
952984 | 952984 | 2021-01-22 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
949739 | 949739 | 2021-01-21 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
946493 | 946493 | 2021-01-20 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
943246 | 943246 | 2021-01-19 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
940001 | 940001 | 2021-01-18 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
936756 | 936756 | 2021-01-17 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
933511 | 933511 | 2021-01-16 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
930266 | 930266 | 2021-01-15 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
927021 | 927021 | 2021-01-14 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
923775 | 923775 | 2021-01-13 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
920530 | 920530 | 2021-01-12 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
917285 | 917285 | 2021-01-11 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
914040 | 914040 | 2021-01-10 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
910795 | 910795 | 2021-01-09 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
907550 | 907550 | 2021-01-08 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
904304 | 904304 | 2021-01-07 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
901059 | 901059 | 2021-01-06 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
897814 | 897814 | 2021-01-05 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
894568 | 894568 | 2021-01-04 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
891322 | 891322 | 2021-01-03 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
888075 | 888075 | 2021-01-02 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
884830 | 884830 | 2021-01-01 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
881585 | 881585 | 2020-12-31 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
878340 | 878340 | 2020-12-30 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
875095 | 875095 | 2020-12-29 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
871850 | 871850 | 2020-12-28 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
868605 | 868605 | 2020-12-27 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
865360 | 865360 | 2020-12-26 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
862115 | 862115 | 2020-12-25 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
858870 | 858870 | 2020-12-24 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
855625 | 855625 | 2020-12-23 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
852380 | 852380 | 2020-12-22 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
849135 | 849135 | 2020-12-21 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
845890 | 845890 | 2020-12-20 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
842644 | 842644 | 2020-12-19 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
839399 | 839399 | 2020-12-18 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
836154 | 836154 | 2020-12-17 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
832908 | 832908 | 2020-12-16 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
829661 | 829661 | 2020-12-15 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
826415 | 826415 | 2020-12-14 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
823168 | 823168 | 2020-12-13 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
819922 | 819922 | 2020-12-12 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
816676 | 816676 | 2020-12-11 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
813430 | 813430 | 2020-12-10 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
810186 | 810186 | 2020-12-09 | Wrangell City and Borough | Alaska | 2275 | 21 | 0 |
806941 | 806941 | 2020-12-08 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
803696 | 803696 | 2020-12-07 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
800451 | 800451 | 2020-12-06 | Wrangell City and Borough | Alaska | 2275 | 21 | 0 |
797206 | 797206 | 2020-12-05 | Wrangell City and Borough | Alaska | 2275 | 21 | 0 |
793961 | 793961 | 2020-12-04 | Wrangell City and Borough | Alaska | 2275 | 21 | 0 |
790716 | 790716 | 2020-12-03 | Wrangell City and Borough | Alaska | 2275 | 20 | 0 |
787471 | 787471 | 2020-12-02 | Wrangell City and Borough | Alaska | 2275 | 20 | 0 |
784227 | 784227 | 2020-12-01 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
780982 | 780982 | 2020-11-30 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
777736 | 777736 | 2020-11-29 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
774491 | 774491 | 2020-11-28 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
771246 | 771246 | 2020-11-27 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
768000 | 768000 | 2020-11-26 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
764755 | 764755 | 2020-11-25 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
761510 | 761510 | 2020-11-24 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
758265 | 758265 | 2020-11-23 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
755018 | 755018 | 2020-11-22 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
751772 | 751772 | 2020-11-21 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
748526 | 748526 | 2020-11-20 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
745280 | 745280 | 2020-11-19 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
742033 | 742033 | 2020-11-18 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
738786 | 738786 | 2020-11-17 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
735542 | 735542 | 2020-11-16 | Wrangell City and Borough | Alaska | 2275 | 20 | 0 |
732296 | 732296 | 2020-11-15 | Wrangell City and Borough | Alaska | 2275 | 20 | 0 |
729051 | 729051 | 2020-11-14 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
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);