ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

20,568 rows where state = "Alaska" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 28

state 1

  • Alaska · 20,568 ✖
Link rowid date ▲ county state fips cases deaths
2499642 2499642 2022-05-13 Aleutians East Borough Alaska 2013 1101 3
2499643 2499643 2022-05-13 Aleutians West Census Area Alaska 2016 1685 1
2499644 2499644 2022-05-13 Anchorage Alaska 2020 105418 526
2499645 2499645 2022-05-13 Bethel Census Area Alaska 2050 10362 41
2499646 2499646 2022-05-13 Bristol Bay plus Lake and Peninsula Alaska 2997 870 1
2499647 2499647 2022-05-13 Denali Borough Alaska 2068 424 1
2499648 2499648 2022-05-13 Dillingham Census Area Alaska 2070 1932 11
2499649 2499649 2022-05-13 Fairbanks North Star Borough Alaska 2090 27763 142
2499650 2499650 2022-05-13 Haines Borough Alaska 2100 624 1
2499651 2499651 2022-05-13 Juneau City and Borough Alaska 2110 8798 19
2499652 2499652 2022-05-13 Kenai Peninsula Borough Alaska 2122 18091 101
2499653 2499653 2022-05-13 Ketchikan Gateway Borough Alaska 2130 4154 17
2499654 2499654 2022-05-13 Kodiak Island Borough Alaska 2150 4992 12
2499655 2499655 2022-05-13 Kusilvak Census Area Alaska 2158 4084 14
2499656 2499656 2022-05-13 Matanuska-Susitna Borough Alaska 2170 34981 236
2499657 2499657 2022-05-13 Nome Census Area Alaska 2180 6245 5
2499658 2499658 2022-05-13 North Slope Borough Alaska 2185 4468 11
2499659 2499659 2022-05-13 Northwest Arctic Borough Alaska 2188 4837 13
2499660 2499660 2022-05-13 Petersburg Borough Alaska 2195 785 4
2499661 2499661 2022-05-13 Prince of Wales-Hyder Census Area Alaska 2198 1454 8
2499662 2499662 2022-05-13 Sitka City and Borough Alaska 2220 2681 5
2499663 2499663 2022-05-13 Skagway Municipality Alaska 2230 187 0
2499664 2499664 2022-05-13 Southeast Fairbanks Census Area Alaska 2240 2052 20
2499665 2499665 2022-05-13 Unknown Alaska   958 1
2499666 2499666 2022-05-13 Valdez-Cordova Census Area Alaska 2261 2948 19
2499667 2499667 2022-05-13 Wrangell City and Borough Alaska 2275 579 1
2499668 2499668 2022-05-13 Yakutat plus Hoonah-Angoon Alaska 2998 556 5
2499669 2499669 2022-05-13 Yukon-Koyukuk Census Area Alaska 2290 1438 10
2496384 2496384 2022-05-12 Aleutians East Borough Alaska 2013 1101 3
2496385 2496385 2022-05-12 Aleutians West Census Area Alaska 2016 1685 1
2496386 2496386 2022-05-12 Anchorage Alaska 2020 105418 526
2496387 2496387 2022-05-12 Bethel Census Area Alaska 2050 10362 41
2496388 2496388 2022-05-12 Bristol Bay plus Lake and Peninsula Alaska 2997 870 1
2496389 2496389 2022-05-12 Denali Borough Alaska 2068 424 1
2496390 2496390 2022-05-12 Dillingham Census Area Alaska 2070 1932 11
2496391 2496391 2022-05-12 Fairbanks North Star Borough Alaska 2090 27763 142
2496392 2496392 2022-05-12 Haines Borough Alaska 2100 624 1
2496393 2496393 2022-05-12 Juneau City and Borough Alaska 2110 8798 19
2496394 2496394 2022-05-12 Kenai Peninsula Borough Alaska 2122 18091 101
2496395 2496395 2022-05-12 Ketchikan Gateway Borough Alaska 2130 4154 17
2496396 2496396 2022-05-12 Kodiak Island Borough Alaska 2150 4992 12
2496397 2496397 2022-05-12 Kusilvak Census Area Alaska 2158 4084 14
2496398 2496398 2022-05-12 Matanuska-Susitna Borough Alaska 2170 34981 236
2496399 2496399 2022-05-12 Nome Census Area Alaska 2180 6245 5
2496400 2496400 2022-05-12 North Slope Borough Alaska 2185 4468 11
2496401 2496401 2022-05-12 Northwest Arctic Borough Alaska 2188 4837 13
2496402 2496402 2022-05-12 Petersburg Borough Alaska 2195 785 4
2496403 2496403 2022-05-12 Prince of Wales-Hyder Census Area Alaska 2198 1454 8
2496404 2496404 2022-05-12 Sitka City and Borough Alaska 2220 2681 5
2496405 2496405 2022-05-12 Skagway Municipality Alaska 2230 187 0
2496406 2496406 2022-05-12 Southeast Fairbanks Census Area Alaska 2240 2052 20
2496407 2496407 2022-05-12 Unknown Alaska   958 1
2496408 2496408 2022-05-12 Valdez-Cordova Census Area Alaska 2261 2948 19
2496409 2496409 2022-05-12 Wrangell City and Borough Alaska 2275 579 1
2496410 2496410 2022-05-12 Yakutat plus Hoonah-Angoon Alaska 2998 556 5
2496411 2496411 2022-05-12 Yukon-Koyukuk Census Area Alaska 2290 1438 10
2493126 2493126 2022-05-11 Aleutians East Borough Alaska 2013 1101 3
2493127 2493127 2022-05-11 Aleutians West Census Area Alaska 2016 1685 1
2493128 2493128 2022-05-11 Anchorage Alaska 2020 105418 526
2493129 2493129 2022-05-11 Bethel Census Area Alaska 2050 10362 41
2493130 2493130 2022-05-11 Bristol Bay plus Lake and Peninsula Alaska 2997 870 1
2493131 2493131 2022-05-11 Denali Borough Alaska 2068 424 1
2493132 2493132 2022-05-11 Dillingham Census Area Alaska 2070 1932 11
2493133 2493133 2022-05-11 Fairbanks North Star Borough Alaska 2090 27763 142
2493134 2493134 2022-05-11 Haines Borough Alaska 2100 624 1
2493135 2493135 2022-05-11 Juneau City and Borough Alaska 2110 8798 19
2493136 2493136 2022-05-11 Kenai Peninsula Borough Alaska 2122 18091 101
2493137 2493137 2022-05-11 Ketchikan Gateway Borough Alaska 2130 4154 17
2493138 2493138 2022-05-11 Kodiak Island Borough Alaska 2150 4992 12
2493139 2493139 2022-05-11 Kusilvak Census Area Alaska 2158 4084 14
2493140 2493140 2022-05-11 Matanuska-Susitna Borough Alaska 2170 34981 236
2493141 2493141 2022-05-11 Nome Census Area Alaska 2180 6245 5
2493142 2493142 2022-05-11 North Slope Borough Alaska 2185 4468 11
2493143 2493143 2022-05-11 Northwest Arctic Borough Alaska 2188 4837 13
2493144 2493144 2022-05-11 Petersburg Borough Alaska 2195 785 4
2493145 2493145 2022-05-11 Prince of Wales-Hyder Census Area Alaska 2198 1454 8
2493146 2493146 2022-05-11 Sitka City and Borough Alaska 2220 2681 5
2493147 2493147 2022-05-11 Skagway Municipality Alaska 2230 187 0
2493148 2493148 2022-05-11 Southeast Fairbanks Census Area Alaska 2240 2052 20
2493149 2493149 2022-05-11 Unknown Alaska   958 1
2493150 2493150 2022-05-11 Valdez-Cordova Census Area Alaska 2261 2948 19
2493151 2493151 2022-05-11 Wrangell City and Borough Alaska 2275 579 1
2493152 2493152 2022-05-11 Yakutat plus Hoonah-Angoon Alaska 2998 556 5
2493153 2493153 2022-05-11 Yukon-Koyukuk Census Area Alaska 2290 1438 10
2489868 2489868 2022-05-10 Aleutians East Borough Alaska 2013 1099 3
2489869 2489869 2022-05-10 Aleutians West Census Area Alaska 2016 1683 1
2489870 2489870 2022-05-10 Anchorage Alaska 2020 104774 521
2489871 2489871 2022-05-10 Bethel Census Area Alaska 2050 10295 41
2489872 2489872 2022-05-10 Bristol Bay plus Lake and Peninsula Alaska 2997 866 1
2489873 2489873 2022-05-10 Denali Borough Alaska 2068 415 1
2489874 2489874 2022-05-10 Dillingham Census Area Alaska 2070 1929 11
2489875 2489875 2022-05-10 Fairbanks North Star Borough Alaska 2090 27635 140
2489876 2489876 2022-05-10 Haines Borough Alaska 2100 619 1
2489877 2489877 2022-05-10 Juneau City and Borough Alaska 2110 8622 19
2489878 2489878 2022-05-10 Kenai Peninsula Borough Alaska 2122 18007 100
2489879 2489879 2022-05-10 Ketchikan Gateway Borough Alaska 2130 4091 17
2489880 2489880 2022-05-10 Kodiak Island Borough Alaska 2150 4983 12
2489881 2489881 2022-05-10 Kusilvak Census Area Alaska 2158 4073 12
2489882 2489882 2022-05-10 Matanuska-Susitna Borough Alaska 2170 34817 232
2489883 2489883 2022-05-10 Nome Census Area Alaska 2180 6235 5

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);