ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20,568 rows where state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 28
county 28
- Anchorage 347
- Fairbanks North Star Borough 343
- Ketchikan Gateway Borough 342
- Kenai Peninsula Borough 341
- Juneau City and Borough 336
- Matanuska-Susitna Borough 336
- Yukon-Koyukuk Census Area 326
- Southeast Fairbanks Census Area 325
- Petersburg Borough 322
- Bethel Census Area 321
- Prince of Wales-Hyder Census Area 317
- Nome Census Area 313
- Kodiak Island Borough 312
- Sitka City and Borough 302
- Valdez-Cordova Census Area 291
- Bristol Bay plus Lake and Peninsula 278
- Northwest Arctic Borough 278
- North Slope Borough 270
- Dillingham Census Area 267
- Aleutians West Census Area 263
- Unknown 259
- Wrangell City and Borough 259
- Aleutians East Borough 258
- Haines Borough 258
- Denali Borough 242
- Kusilvak Census Area 234
- Yakutat plus Hoonah-Angoon 213
- Skagway Municipality 129
state 1
- Alaska · 8,082 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050326 | 1050326 | 2021-02-21 | Aleutians East Borough | Alaska | 2013 | 355 | 1 |
1050327 | 1050327 | 2021-02-21 | Aleutians West Census Area | Alaska | 2016 | 489 | 0 |
1050328 | 1050328 | 2021-02-21 | Anchorage | Alaska | 2020 | 26184 | 151 |
1050329 | 1050329 | 2021-02-21 | Bethel Census Area | Alaska | 2050 | 3527 | 18 |
1050330 | 1050330 | 2021-02-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1050331 | 1050331 | 2021-02-21 | Denali Borough | Alaska | 2068 | 68 | 0 |
1050332 | 1050332 | 2021-02-21 | Dillingham Census Area | Alaska | 2070 | 196 | 1 |
1050333 | 1050333 | 2021-02-21 | Fairbanks North Star Borough | Alaska | 2090 | 6058 | 26 |
1050334 | 1050334 | 2021-02-21 | Haines Borough | Alaska | 2100 | 24 | 0 |
1050335 | 1050335 | 2021-02-21 | Juneau City and Borough | Alaska | 2110 | 1192 | 3 |
1050336 | 1050336 | 2021-02-21 | Kenai Peninsula Borough | Alaska | 2122 | 3942 | 19 |
1050337 | 1050337 | 2021-02-21 | Ketchikan Gateway Borough | Alaska | 2130 | 330 | 2 |
1050338 | 1050338 | 2021-02-21 | Kodiak Island Borough | Alaska | 2150 | 1051 | 5 |
1050339 | 1050339 | 2021-02-21 | Kusilvak Census Area | Alaska | 2158 | 1186 | 3 |
1050340 | 1050340 | 2021-02-21 | Matanuska-Susitna Borough | Alaska | 2170 | 8284 | 33 |
1050341 | 1050341 | 2021-02-21 | Nome Census Area | Alaska | 2180 | 322 | 0 |
1050342 | 1050342 | 2021-02-21 | North Slope Borough | Alaska | 2185 | 998 | 4 |
1050343 | 1050343 | 2021-02-21 | Northwest Arctic Borough | Alaska | 2188 | 584 | 1 |
1050344 | 1050344 | 2021-02-21 | Petersburg Borough | Alaska | 2195 | 48 | 0 |
1050345 | 1050345 | 2021-02-21 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 70 | 1 |
1050346 | 1050346 | 2021-02-21 | Sitka City and Borough | Alaska | 2220 | 303 | 0 |
1050347 | 1050347 | 2021-02-21 | Skagway Municipality | Alaska | 2230 | 18 | 0 |
1050348 | 1050348 | 2021-02-21 | Southeast Fairbanks Census Area | Alaska | 2240 | 443 | 3 |
1050349 | 1050349 | 2021-02-21 | Unknown | Alaska | 253 | 0 | |
1050350 | 1050350 | 2021-02-21 | Valdez-Cordova Census Area | Alaska | 2261 | 461 | 2 |
1050351 | 1050351 | 2021-02-21 | Wrangell City and Borough | Alaska | 2275 | 26 | 0 |
1050352 | 1050352 | 2021-02-21 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 64 | 1 |
1050353 | 1050353 | 2021-02-21 | Yukon-Koyukuk Census Area | Alaska | 2290 | 327 | 4 |
1047079 | 1047079 | 2021-02-20 | Aleutians East Borough | Alaska | 2013 | 355 | 1 |
1047080 | 1047080 | 2021-02-20 | Aleutians West Census Area | Alaska | 2016 | 489 | 0 |
1047081 | 1047081 | 2021-02-20 | Anchorage | Alaska | 2020 | 26184 | 151 |
1047082 | 1047082 | 2021-02-20 | Bethel Census Area | Alaska | 2050 | 3527 | 18 |
1047083 | 1047083 | 2021-02-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1047084 | 1047084 | 2021-02-20 | Denali Borough | Alaska | 2068 | 68 | 0 |
1047085 | 1047085 | 2021-02-20 | Dillingham Census Area | Alaska | 2070 | 196 | 1 |
1047086 | 1047086 | 2021-02-20 | Fairbanks North Star Borough | Alaska | 2090 | 6058 | 26 |
1047087 | 1047087 | 2021-02-20 | Haines Borough | Alaska | 2100 | 24 | 0 |
1047088 | 1047088 | 2021-02-20 | Juneau City and Borough | Alaska | 2110 | 1192 | 3 |
1047089 | 1047089 | 2021-02-20 | Kenai Peninsula Borough | Alaska | 2122 | 3942 | 19 |
1047090 | 1047090 | 2021-02-20 | Ketchikan Gateway Borough | Alaska | 2130 | 330 | 2 |
1047091 | 1047091 | 2021-02-20 | Kodiak Island Borough | Alaska | 2150 | 1051 | 5 |
1047092 | 1047092 | 2021-02-20 | Kusilvak Census Area | Alaska | 2158 | 1186 | 3 |
1047093 | 1047093 | 2021-02-20 | Matanuska-Susitna Borough | Alaska | 2170 | 8284 | 33 |
1047094 | 1047094 | 2021-02-20 | Nome Census Area | Alaska | 2180 | 322 | 0 |
1047095 | 1047095 | 2021-02-20 | North Slope Borough | Alaska | 2185 | 998 | 4 |
1047096 | 1047096 | 2021-02-20 | Northwest Arctic Borough | Alaska | 2188 | 584 | 1 |
1047097 | 1047097 | 2021-02-20 | Petersburg Borough | Alaska | 2195 | 48 | 0 |
1047098 | 1047098 | 2021-02-20 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 70 | 1 |
1047099 | 1047099 | 2021-02-20 | Sitka City and Borough | Alaska | 2220 | 303 | 0 |
1047100 | 1047100 | 2021-02-20 | Skagway Municipality | Alaska | 2230 | 18 | 0 |
1047101 | 1047101 | 2021-02-20 | Southeast Fairbanks Census Area | Alaska | 2240 | 443 | 3 |
1047102 | 1047102 | 2021-02-20 | Unknown | Alaska | 253 | 0 | |
1047103 | 1047103 | 2021-02-20 | Valdez-Cordova Census Area | Alaska | 2261 | 461 | 2 |
1047104 | 1047104 | 2021-02-20 | Wrangell City and Borough | Alaska | 2275 | 26 | 0 |
1047105 | 1047105 | 2021-02-20 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 64 | 1 |
1047106 | 1047106 | 2021-02-20 | Yukon-Koyukuk Census Area | Alaska | 2290 | 327 | 4 |
1043834 | 1043834 | 2021-02-19 | Aleutians East Borough | Alaska | 2013 | 355 | 1 |
1043835 | 1043835 | 2021-02-19 | Aleutians West Census Area | Alaska | 2016 | 489 | 0 |
1043836 | 1043836 | 2021-02-19 | Anchorage | Alaska | 2020 | 26184 | 151 |
1043837 | 1043837 | 2021-02-19 | Bethel Census Area | Alaska | 2050 | 3527 | 18 |
1043838 | 1043838 | 2021-02-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1043839 | 1043839 | 2021-02-19 | Denali Borough | Alaska | 2068 | 68 | 0 |
1043840 | 1043840 | 2021-02-19 | Dillingham Census Area | Alaska | 2070 | 196 | 1 |
1043841 | 1043841 | 2021-02-19 | Fairbanks North Star Borough | Alaska | 2090 | 6058 | 26 |
1043842 | 1043842 | 2021-02-19 | Haines Borough | Alaska | 2100 | 24 | 0 |
1043843 | 1043843 | 2021-02-19 | Juneau City and Borough | Alaska | 2110 | 1192 | 3 |
1043844 | 1043844 | 2021-02-19 | Kenai Peninsula Borough | Alaska | 2122 | 3942 | 19 |
1043845 | 1043845 | 2021-02-19 | Ketchikan Gateway Borough | Alaska | 2130 | 330 | 2 |
1043846 | 1043846 | 2021-02-19 | Kodiak Island Borough | Alaska | 2150 | 1051 | 5 |
1043847 | 1043847 | 2021-02-19 | Kusilvak Census Area | Alaska | 2158 | 1186 | 3 |
1043848 | 1043848 | 2021-02-19 | Matanuska-Susitna Borough | Alaska | 2170 | 8284 | 33 |
1043849 | 1043849 | 2021-02-19 | Nome Census Area | Alaska | 2180 | 322 | 0 |
1043850 | 1043850 | 2021-02-19 | North Slope Borough | Alaska | 2185 | 998 | 4 |
1043851 | 1043851 | 2021-02-19 | Northwest Arctic Borough | Alaska | 2188 | 584 | 1 |
1043852 | 1043852 | 2021-02-19 | Petersburg Borough | Alaska | 2195 | 48 | 0 |
1043853 | 1043853 | 2021-02-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 70 | 1 |
1043854 | 1043854 | 2021-02-19 | Sitka City and Borough | Alaska | 2220 | 303 | 0 |
1043855 | 1043855 | 2021-02-19 | Skagway Municipality | Alaska | 2230 | 18 | 0 |
1043856 | 1043856 | 2021-02-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 443 | 3 |
1043857 | 1043857 | 2021-02-19 | Unknown | Alaska | 253 | 0 | |
1043858 | 1043858 | 2021-02-19 | Valdez-Cordova Census Area | Alaska | 2261 | 461 | 2 |
1043859 | 1043859 | 2021-02-19 | Wrangell City and Borough | Alaska | 2275 | 26 | 0 |
1043860 | 1043860 | 2021-02-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 64 | 1 |
1043861 | 1043861 | 2021-02-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 327 | 4 |
1040589 | 1040589 | 2021-02-18 | Aleutians East Borough | Alaska | 2013 | 355 | 0 |
1040590 | 1040590 | 2021-02-18 | Aleutians West Census Area | Alaska | 2016 | 466 | 0 |
1040591 | 1040591 | 2021-02-18 | Anchorage | Alaska | 2020 | 26118 | 151 |
1040592 | 1040592 | 2021-02-18 | Bethel Census Area | Alaska | 2050 | 3518 | 18 |
1040593 | 1040593 | 2021-02-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 176 | 0 |
1040594 | 1040594 | 2021-02-18 | Denali Borough | Alaska | 2068 | 68 | 0 |
1040595 | 1040595 | 2021-02-18 | Dillingham Census Area | Alaska | 2070 | 195 | 1 |
1040596 | 1040596 | 2021-02-18 | Fairbanks North Star Borough | Alaska | 2090 | 6038 | 26 |
1040597 | 1040597 | 2021-02-18 | Haines Borough | Alaska | 2100 | 24 | 0 |
1040598 | 1040598 | 2021-02-18 | Juneau City and Borough | Alaska | 2110 | 1185 | 3 |
1040599 | 1040599 | 2021-02-18 | Kenai Peninsula Borough | Alaska | 2122 | 3939 | 19 |
1040600 | 1040600 | 2021-02-18 | Ketchikan Gateway Borough | Alaska | 2130 | 315 | 2 |
1040601 | 1040601 | 2021-02-18 | Kodiak Island Borough | Alaska | 2150 | 1050 | 5 |
1040602 | 1040602 | 2021-02-18 | Kusilvak Census Area | Alaska | 2158 | 1186 | 3 |
1040603 | 1040603 | 2021-02-18 | Matanuska-Susitna Borough | Alaska | 2170 | 8233 | 33 |
1040604 | 1040604 | 2021-02-18 | Nome Census Area | Alaska | 2180 | 322 | 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);