ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
704 rows where fips = 2013 and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050326 | 1050326 | 2021-02-21 | Aleutians East Borough | Alaska | 2013 | 355 | 1 |
1047079 | 1047079 | 2021-02-20 | Aleutians East Borough | Alaska | 2013 | 355 | 1 |
1043834 | 1043834 | 2021-02-19 | Aleutians East Borough | Alaska | 2013 | 355 | 1 |
1040589 | 1040589 | 2021-02-18 | Aleutians East Borough | Alaska | 2013 | 355 | 0 |
1037344 | 1037344 | 2021-02-17 | Aleutians East Borough | Alaska | 2013 | 351 | 0 |
1034099 | 1034099 | 2021-02-16 | Aleutians East Borough | Alaska | 2013 | 351 | 0 |
1030853 | 1030853 | 2021-02-15 | Aleutians East Borough | Alaska | 2013 | 349 | 0 |
1027606 | 1027606 | 2021-02-14 | Aleutians East Borough | Alaska | 2013 | 349 | 0 |
1024361 | 1024361 | 2021-02-13 | Aleutians East Borough | Alaska | 2013 | 349 | 0 |
1021116 | 1021116 | 2021-02-12 | Aleutians East Borough | Alaska | 2013 | 349 | 0 |
1017871 | 1017871 | 2021-02-11 | Aleutians East Borough | Alaska | 2013 | 344 | 0 |
1014626 | 1014626 | 2021-02-10 | Aleutians East Borough | Alaska | 2013 | 341 | 0 |
1011381 | 1011381 | 2021-02-09 | Aleutians East Borough | Alaska | 2013 | 327 | 0 |
1008135 | 1008135 | 2021-02-08 | Aleutians East Borough | Alaska | 2013 | 323 | 0 |
1004889 | 1004889 | 2021-02-07 | Aleutians East Borough | Alaska | 2013 | 259 | 0 |
1001643 | 1001643 | 2021-02-06 | Aleutians East Borough | Alaska | 2013 | 259 | 0 |
998397 | 998397 | 2021-02-05 | Aleutians East Borough | Alaska | 2013 | 259 | 0 |
995151 | 995151 | 2021-02-04 | Aleutians East Borough | Alaska | 2013 | 177 | 0 |
991905 | 991905 | 2021-02-03 | Aleutians East Borough | Alaska | 2013 | 151 | 0 |
988659 | 988659 | 2021-02-02 | Aleutians East Borough | Alaska | 2013 | 132 | 0 |
985412 | 985412 | 2021-02-01 | Aleutians East Borough | Alaska | 2013 | 101 | 0 |
982165 | 982165 | 2021-01-31 | Aleutians East Borough | Alaska | 2013 | 86 | 0 |
978919 | 978919 | 2021-01-30 | Aleutians East Borough | Alaska | 2013 | 85 | 0 |
975674 | 975674 | 2021-01-29 | Aleutians East Borough | Alaska | 2013 | 79 | 0 |
972429 | 972429 | 2021-01-28 | Aleutians East Borough | Alaska | 2013 | 79 | 0 |
969184 | 969184 | 2021-01-27 | Aleutians East Borough | Alaska | 2013 | 72 | 0 |
965940 | 965940 | 2021-01-26 | Aleutians East Borough | Alaska | 2013 | 70 | 0 |
962695 | 962695 | 2021-01-25 | Aleutians East Borough | Alaska | 2013 | 70 | 0 |
959450 | 959450 | 2021-01-24 | Aleutians East Borough | Alaska | 2013 | 70 | 0 |
956204 | 956204 | 2021-01-23 | Aleutians East Borough | Alaska | 2013 | 70 | 0 |
952959 | 952959 | 2021-01-22 | Aleutians East Borough | Alaska | 2013 | 63 | 0 |
949714 | 949714 | 2021-01-21 | Aleutians East Borough | Alaska | 2013 | 40 | 0 |
946468 | 946468 | 2021-01-20 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
943221 | 943221 | 2021-01-19 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
939976 | 939976 | 2021-01-18 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
936731 | 936731 | 2021-01-17 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
933486 | 933486 | 2021-01-16 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
930241 | 930241 | 2021-01-15 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
926996 | 926996 | 2021-01-14 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
923750 | 923750 | 2021-01-13 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
920505 | 920505 | 2021-01-12 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
917260 | 917260 | 2021-01-11 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
914015 | 914015 | 2021-01-10 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
910770 | 910770 | 2021-01-09 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
907525 | 907525 | 2021-01-08 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
904279 | 904279 | 2021-01-07 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
901034 | 901034 | 2021-01-06 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
897789 | 897789 | 2021-01-05 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
894543 | 894543 | 2021-01-04 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
891297 | 891297 | 2021-01-03 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
888050 | 888050 | 2021-01-02 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
884805 | 884805 | 2021-01-01 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
881560 | 881560 | 2020-12-31 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
878315 | 878315 | 2020-12-30 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
875070 | 875070 | 2020-12-29 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
871825 | 871825 | 2020-12-28 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
868580 | 868580 | 2020-12-27 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
865335 | 865335 | 2020-12-26 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
862090 | 862090 | 2020-12-25 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
858845 | 858845 | 2020-12-24 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
855600 | 855600 | 2020-12-23 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
852355 | 852355 | 2020-12-22 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
849110 | 849110 | 2020-12-21 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
845865 | 845865 | 2020-12-20 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
842619 | 842619 | 2020-12-19 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
839374 | 839374 | 2020-12-18 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
836129 | 836129 | 2020-12-17 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
832883 | 832883 | 2020-12-16 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
829636 | 829636 | 2020-12-15 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
826390 | 826390 | 2020-12-14 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
823143 | 823143 | 2020-12-13 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
819897 | 819897 | 2020-12-12 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
816651 | 816651 | 2020-12-11 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
813405 | 813405 | 2020-12-10 | Aleutians East Borough | Alaska | 2013 | 40 | 0 |
810161 | 810161 | 2020-12-09 | Aleutians East Borough | Alaska | 2013 | 42 | 0 |
806916 | 806916 | 2020-12-08 | Aleutians East Borough | Alaska | 2013 | 42 | 0 |
803671 | 803671 | 2020-12-07 | Aleutians East Borough | Alaska | 2013 | 40 | 0 |
800426 | 800426 | 2020-12-06 | Aleutians East Borough | Alaska | 2013 | 41 | 0 |
797181 | 797181 | 2020-12-05 | Aleutians East Borough | Alaska | 2013 | 41 | 0 |
793936 | 793936 | 2020-12-04 | Aleutians East Borough | Alaska | 2013 | 41 | 0 |
790691 | 790691 | 2020-12-03 | Aleutians East Borough | Alaska | 2013 | 41 | 0 |
787446 | 787446 | 2020-12-02 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
784202 | 784202 | 2020-12-01 | Aleutians East Borough | Alaska | 2013 | 37 | 0 |
780957 | 780957 | 2020-11-30 | Aleutians East Borough | Alaska | 2013 | 37 | 0 |
777711 | 777711 | 2020-11-29 | Aleutians East Borough | Alaska | 2013 | 37 | 0 |
774466 | 774466 | 2020-11-28 | Aleutians East Borough | Alaska | 2013 | 33 | 0 |
771221 | 771221 | 2020-11-27 | Aleutians East Borough | Alaska | 2013 | 33 | 0 |
767975 | 767975 | 2020-11-26 | Aleutians East Borough | Alaska | 2013 | 33 | 0 |
764730 | 764730 | 2020-11-25 | Aleutians East Borough | Alaska | 2013 | 33 | 0 |
761485 | 761485 | 2020-11-24 | Aleutians East Borough | Alaska | 2013 | 26 | 0 |
758240 | 758240 | 2020-11-23 | Aleutians East Borough | Alaska | 2013 | 24 | 0 |
754993 | 754993 | 2020-11-22 | Aleutians East Borough | Alaska | 2013 | 21 | 0 |
751747 | 751747 | 2020-11-21 | Aleutians East Borough | Alaska | 2013 | 20 | 0 |
748501 | 748501 | 2020-11-20 | Aleutians East Borough | Alaska | 2013 | 20 | 0 |
745255 | 745255 | 2020-11-19 | Aleutians East Borough | Alaska | 2013 | 20 | 0 |
742008 | 742008 | 2020-11-18 | Aleutians East Borough | Alaska | 2013 | 21 | 0 |
738761 | 738761 | 2020-11-17 | Aleutians East Borough | Alaska | 2013 | 21 | 0 |
735517 | 735517 | 2020-11-16 | Aleutians East Borough | Alaska | 2013 | 21 | 0 |
732271 | 732271 | 2020-11-15 | Aleutians East Borough | Alaska | 2013 | 21 | 0 |
729026 | 729026 | 2020-11-14 | Aleutians East Borough | Alaska | 2013 | 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);