ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 27 and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 13
- Juneau City and Borough 20
- Dillingham Census Area 11
- Haines Borough 4
- Nome Census Area 4
- Petersburg Borough 4
- Sitka City and Borough 4
- Valdez-Cordova Census Area 4
- Prince of Wales-Hyder Census Area 3
- Southeast Fairbanks Census Area 2
- Yakutat plus Hoonah-Angoon 2
- Ketchikan Gateway Borough 1
- North Slope Borough 1
- Unknown 1
state 1
- Alaska · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1267878 | 1267878 | 2021-04-29 | Haines Borough | Alaska | 2100 | 27 | 0 |
1264631 | 1264631 | 2021-04-28 | Haines Borough | Alaska | 2100 | 27 | 0 |
1261384 | 1261384 | 2021-04-27 | Haines Borough | Alaska | 2100 | 27 | 0 |
1258137 | 1258137 | 2021-04-26 | Haines Borough | Alaska | 2100 | 27 | 0 |
891315 | 891315 | 2021-01-03 | Petersburg Borough | Alaska | 2195 | 27 | 0 |
888068 | 888068 | 2021-01-02 | Petersburg Borough | Alaska | 2195 | 27 | 0 |
884823 | 884823 | 2021-01-01 | Petersburg Borough | Alaska | 2195 | 27 | 0 |
881578 | 881578 | 2020-12-31 | Petersburg Borough | Alaska | 2195 | 27 | 0 |
547462 | 547462 | 2020-09-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 27 | 0 |
544225 | 544225 | 2020-09-18 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 27 | 0 |
537733 | 537733 | 2020-09-16 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
534497 | 534497 | 2020-09-15 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
531262 | 531262 | 2020-09-14 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
528025 | 528025 | 2020-09-13 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
524789 | 524789 | 2020-09-12 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
505396 | 505396 | 2020-09-06 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 27 | 0 |
502162 | 502162 | 2020-09-05 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 27 | 0 |
498928 | 498928 | 2020-09-04 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 27 | 0 |
463357 | 463357 | 2020-08-24 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
460128 | 460128 | 2020-08-23 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
456901 | 456901 | 2020-08-22 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
453673 | 453673 | 2020-08-21 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
450445 | 450445 | 2020-08-20 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
447217 | 447217 | 2020-08-19 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
437547 | 437547 | 2020-08-16 | Nome Census Area | Alaska | 2180 | 27 | 0 |
434321 | 434321 | 2020-08-15 | Nome Census Area | Alaska | 2180 | 27 | 0 |
434322 | 434322 | 2020-08-15 | North Slope Borough | Alaska | 2185 | 27 | 0 |
431096 | 431096 | 2020-08-14 | Nome Census Area | Alaska | 2180 | 27 | 0 |
427868 | 427868 | 2020-08-13 | Nome Census Area | Alaska | 2180 | 27 | 0 |
405328 | 405328 | 2020-08-06 | Southeast Fairbanks Census Area | Alaska | 2240 | 27 | 0 |
405329 | 405329 | 2020-08-06 | Unknown | Alaska | 27 | 0 | |
402110 | 402110 | 2020-08-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 27 | 0 |
366740 | 366740 | 2020-07-25 | Sitka City and Borough | Alaska | 2220 | 27 | 0 |
363533 | 363533 | 2020-07-24 | Sitka City and Borough | Alaska | 2220 | 27 | 0 |
360327 | 360327 | 2020-07-23 | Sitka City and Borough | Alaska | 2220 | 27 | 0 |
357122 | 357122 | 2020-07-22 | Sitka City and Borough | Alaska | 2220 | 27 | 0 |
321983 | 321983 | 2020-07-11 | Valdez-Cordova Census Area | Alaska | 2261 | 27 | 0 |
318804 | 318804 | 2020-07-10 | Valdez-Cordova Census Area | Alaska | 2261 | 27 | 0 |
315631 | 315631 | 2020-07-09 | Valdez-Cordova Census Area | Alaska | 2261 | 27 | 0 |
312456 | 312456 | 2020-07-08 | Valdez-Cordova Census Area | Alaska | 2261 | 27 | 0 |
265166 | 265166 | 2020-06-23 | Ketchikan Gateway Borough | Alaska | 2130 | 27 | 0 |
133303 | 133303 | 2020-05-11 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
130313 | 130313 | 2020-05-10 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
127323 | 127323 | 2020-05-09 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
124338 | 124338 | 2020-05-08 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
121358 | 121358 | 2020-05-07 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
118392 | 118392 | 2020-05-06 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
115433 | 115433 | 2020-05-05 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
112550 | 112550 | 2020-05-04 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
109675 | 109675 | 2020-05-03 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
106806 | 106806 | 2020-05-02 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
103941 | 103941 | 2020-05-01 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
101086 | 101086 | 2020-04-30 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
98236 | 98236 | 2020-04-29 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
95391 | 95391 | 2020-04-28 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
92561 | 92561 | 2020-04-27 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
89743 | 89743 | 2020-04-26 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
86927 | 86927 | 2020-04-25 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
84119 | 84119 | 2020-04-24 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
81318 | 81318 | 2020-04-23 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
78525 | 78525 | 2020-04-22 | Juneau City and Borough | Alaska | 2110 | 27 | 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);