ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 2020 and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050328 | 1050328 | 2021-02-21 | Anchorage | Alaska | 2020 | 26184 | 151 |
1047081 | 1047081 | 2021-02-20 | Anchorage | Alaska | 2020 | 26184 | 151 |
1043836 | 1043836 | 2021-02-19 | Anchorage | Alaska | 2020 | 26184 | 151 |
1040591 | 1040591 | 2021-02-18 | Anchorage | Alaska | 2020 | 26118 | 151 |
1037346 | 1037346 | 2021-02-17 | Anchorage | Alaska | 2020 | 26062 | 151 |
1034101 | 1034101 | 2021-02-16 | Anchorage | Alaska | 2020 | 26053 | 150 |
1030855 | 1030855 | 2021-02-15 | Anchorage | Alaska | 2020 | 25898 | 150 |
1027608 | 1027608 | 2021-02-14 | Anchorage | Alaska | 2020 | 25898 | 150 |
1024363 | 1024363 | 2021-02-13 | Anchorage | Alaska | 2020 | 25898 | 150 |
1021118 | 1021118 | 2021-02-12 | Anchorage | Alaska | 2020 | 25898 | 150 |
1017873 | 1017873 | 2021-02-11 | Anchorage | Alaska | 2020 | 25846 | 149 |
1014628 | 1014628 | 2021-02-10 | Anchorage | Alaska | 2020 | 25782 | 149 |
1011383 | 1011383 | 2021-02-09 | Anchorage | Alaska | 2020 | 25732 | 149 |
1008137 | 1008137 | 2021-02-08 | Anchorage | Alaska | 2020 | 25683 | 149 |
1004891 | 1004891 | 2021-02-07 | Anchorage | Alaska | 2020 | 25568 | 149 |
1001645 | 1001645 | 2021-02-06 | Anchorage | Alaska | 2020 | 25568 | 149 |
998399 | 998399 | 2021-02-05 | Anchorage | Alaska | 2020 | 25568 | 149 |
995153 | 995153 | 2021-02-04 | Anchorage | Alaska | 2020 | 25522 | 149 |
991907 | 991907 | 2021-02-03 | Anchorage | Alaska | 2020 | 25490 | 149 |
988661 | 988661 | 2021-02-02 | Anchorage | Alaska | 2020 | 25418 | 149 |
985414 | 985414 | 2021-02-01 | Anchorage | Alaska | 2020 | 25360 | 139 |
982167 | 982167 | 2021-01-31 | Anchorage | Alaska | 2020 | 25336 | 139 |
978921 | 978921 | 2021-01-30 | Anchorage | Alaska | 2020 | 25294 | 139 |
975676 | 975676 | 2021-01-29 | Anchorage | Alaska | 2020 | 25235 | 139 |
972431 | 972431 | 2021-01-28 | Anchorage | Alaska | 2020 | 25157 | 139 |
969186 | 969186 | 2021-01-27 | Anchorage | Alaska | 2020 | 25104 | 139 |
965942 | 965942 | 2021-01-26 | Anchorage | Alaska | 2020 | 25034 | 139 |
962697 | 962697 | 2021-01-25 | Anchorage | Alaska | 2020 | 25012 | 139 |
959452 | 959452 | 2021-01-24 | Anchorage | Alaska | 2020 | 24959 | 139 |
956206 | 956206 | 2021-01-23 | Anchorage | Alaska | 2020 | 24911 | 139 |
952961 | 952961 | 2021-01-22 | Anchorage | Alaska | 2020 | 24838 | 138 |
949716 | 949716 | 2021-01-21 | Anchorage | Alaska | 2020 | 24729 | 138 |
946470 | 946470 | 2021-01-20 | Anchorage | Alaska | 2020 | 24676 | 137 |
943223 | 943223 | 2021-01-19 | Anchorage | Alaska | 2020 | 24618 | 127 |
939978 | 939978 | 2021-01-18 | Anchorage | Alaska | 2020 | 24587 | 127 |
936733 | 936733 | 2021-01-17 | Anchorage | Alaska | 2020 | 24533 | 127 |
933488 | 933488 | 2021-01-16 | Anchorage | Alaska | 2020 | 24467 | 127 |
930243 | 930243 | 2021-01-15 | Anchorage | Alaska | 2020 | 24408 | 127 |
926998 | 926998 | 2021-01-14 | Anchorage | Alaska | 2020 | 24319 | 127 |
923752 | 923752 | 2021-01-13 | Anchorage | Alaska | 2020 | 24193 | 126 |
920507 | 920507 | 2021-01-12 | Anchorage | Alaska | 2020 | 24066 | 125 |
917262 | 917262 | 2021-01-11 | Anchorage | Alaska | 2020 | 24066 | 124 |
914017 | 914017 | 2021-01-10 | Anchorage | Alaska | 2020 | 23980 | 124 |
910772 | 910772 | 2021-01-09 | Anchorage | Alaska | 2020 | 23885 | 124 |
907527 | 907527 | 2021-01-08 | Anchorage | Alaska | 2020 | 23751 | 124 |
904281 | 904281 | 2021-01-07 | Anchorage | Alaska | 2020 | 23622 | 124 |
901036 | 901036 | 2021-01-06 | Anchorage | Alaska | 2020 | 23463 | 123 |
897791 | 897791 | 2021-01-05 | Anchorage | Alaska | 2020 | 23328 | 121 |
894545 | 894545 | 2021-01-04 | Anchorage | Alaska | 2020 | 23276 | 121 |
891299 | 891299 | 2021-01-03 | Anchorage | Alaska | 2020 | 23179 | 121 |
888052 | 888052 | 2021-01-02 | Anchorage | Alaska | 2020 | 23131 | 121 |
884807 | 884807 | 2021-01-01 | Anchorage | Alaska | 2020 | 22820 | 118 |
881562 | 881562 | 2020-12-31 | Anchorage | Alaska | 2020 | 22820 | 118 |
878317 | 878317 | 2020-12-30 | Anchorage | Alaska | 2020 | 22677 | 117 |
875072 | 875072 | 2020-12-29 | Anchorage | Alaska | 2020 | 22538 | 117 |
871827 | 871827 | 2020-12-28 | Anchorage | Alaska | 2020 | 22441 | 116 |
868582 | 868582 | 2020-12-27 | Anchorage | Alaska | 2020 | 22370 | 116 |
865337 | 865337 | 2020-12-26 | Anchorage | Alaska | 2020 | 22268 | 116 |
862092 | 862092 | 2020-12-25 | Anchorage | Alaska | 2020 | 22124 | 116 |
858847 | 858847 | 2020-12-24 | Anchorage | Alaska | 2020 | 22124 | 116 |
855602 | 855602 | 2020-12-23 | Anchorage | Alaska | 2020 | 22013 | 115 |
852357 | 852357 | 2020-12-22 | Anchorage | Alaska | 2020 | 21857 | 112 |
849112 | 849112 | 2020-12-21 | Anchorage | Alaska | 2020 | 21645 | 104 |
845867 | 845867 | 2020-12-20 | Anchorage | Alaska | 2020 | 21554 | 104 |
842621 | 842621 | 2020-12-19 | Anchorage | Alaska | 2020 | 21429 | 104 |
839376 | 839376 | 2020-12-18 | Anchorage | Alaska | 2020 | 21283 | 103 |
836131 | 836131 | 2020-12-17 | Anchorage | Alaska | 2020 | 21084 | 103 |
832885 | 832885 | 2020-12-16 | Anchorage | Alaska | 2020 | 20883 | 101 |
829638 | 829638 | 2020-12-15 | Anchorage | Alaska | 2020 | 20616 | 99 |
826392 | 826392 | 2020-12-14 | Anchorage | Alaska | 2020 | 20474 | 96 |
823145 | 823145 | 2020-12-13 | Anchorage | Alaska | 2020 | 20259 | 96 |
819899 | 819899 | 2020-12-12 | Anchorage | Alaska | 2020 | 19961 | 96 |
816653 | 816653 | 2020-12-11 | Anchorage | Alaska | 2020 | 19737 | 86 |
813407 | 813407 | 2020-12-10 | Anchorage | Alaska | 2020 | 19461 | 85 |
810163 | 810163 | 2020-12-09 | Anchorage | Alaska | 2020 | 19187 | 81 |
806918 | 806918 | 2020-12-08 | Anchorage | Alaska | 2020 | 18960 | 80 |
803673 | 803673 | 2020-12-07 | Anchorage | Alaska | 2020 | 18726 | 80 |
800428 | 800428 | 2020-12-06 | Anchorage | Alaska | 2020 | 18478 | 78 |
797183 | 797183 | 2020-12-05 | Anchorage | Alaska | 2020 | 18105 | 78 |
793938 | 793938 | 2020-12-04 | Anchorage | Alaska | 2020 | 17774 | 77 |
790693 | 790693 | 2020-12-03 | Anchorage | Alaska | 2020 | 17515 | 73 |
787448 | 787448 | 2020-12-02 | Anchorage | Alaska | 2020 | 17195 | 68 |
784204 | 784204 | 2020-12-01 | Anchorage | Alaska | 2020 | 16951 | 68 |
780959 | 780959 | 2020-11-30 | Anchorage | Alaska | 2020 | 16781 | 67 |
777713 | 777713 | 2020-11-29 | Anchorage | Alaska | 2020 | 16588 | 67 |
774468 | 774468 | 2020-11-28 | Anchorage | Alaska | 2020 | 16356 | 67 |
771223 | 771223 | 2020-11-27 | Anchorage | Alaska | 2020 | 16069 | 65 |
767977 | 767977 | 2020-11-26 | Anchorage | Alaska | 2020 | 15944 | 65 |
764732 | 764732 | 2020-11-25 | Anchorage | Alaska | 2020 | 15699 | 65 |
761487 | 761487 | 2020-11-24 | Anchorage | Alaska | 2020 | 15305 | 65 |
758242 | 758242 | 2020-11-23 | Anchorage | Alaska | 2020 | 14932 | 63 |
754995 | 754995 | 2020-11-22 | Anchorage | Alaska | 2020 | 14637 | 63 |
751749 | 751749 | 2020-11-21 | Anchorage | Alaska | 2020 | 14331 | 61 |
748503 | 748503 | 2020-11-20 | Anchorage | Alaska | 2020 | 13999 | 61 |
745257 | 745257 | 2020-11-19 | Anchorage | Alaska | 2020 | 13750 | 61 |
742010 | 742010 | 2020-11-18 | Anchorage | Alaska | 2020 | 13501 | 60 |
738763 | 738763 | 2020-11-17 | Anchorage | Alaska | 2020 | 13216 | 60 |
735519 | 735519 | 2020-11-16 | Anchorage | Alaska | 2020 | 12713 | 59 |
732273 | 732273 | 2020-11-15 | Anchorage | Alaska | 2020 | 12305 | 59 |
729028 | 729028 | 2020-11-14 | Anchorage | Alaska | 2020 | 11924 | 59 |
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);