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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips 28
county 28
- Anchorage 793
- Fairbanks North Star Borough 789
- Ketchikan Gateway Borough 788
- Kenai Peninsula Borough 787
- Juneau City and Borough 782
- Matanuska-Susitna Borough 782
- Yukon-Koyukuk Census Area 772
- Southeast Fairbanks Census Area 771
- Petersburg Borough 768
- Bethel Census Area 767
- Prince of Wales-Hyder Census Area 763
- Nome Census Area 759
- Kodiak Island Borough 758
- Sitka City and Borough 748
- Valdez-Cordova Census Area 737
- Bristol Bay plus Lake and Peninsula 724
- Northwest Arctic Borough 724
- North Slope Borough 716
- Dillingham Census Area 713
- Aleutians West Census Area 709
- Wrangell City and Borough 705
- Aleutians East Borough 704
- Haines Borough 704
- Unknown 703
- Denali Borough 688
- Kusilvak Census Area 680
- Yakutat plus Hoonah-Angoon 659
- Skagway Municipality 575
state 1
- Alaska · 20,568 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
221582 | 221582 | 2020-06-09 | Aleutians East Borough | Alaska | 2013 | 1 | 0 |
224678 | 224678 | 2020-06-10 | Aleutians East Borough | Alaska | 2013 | 1 | 0 |
227779 | 227779 | 2020-06-11 | Aleutians East Borough | Alaska | 2013 | 1 | 0 |
230883 | 230883 | 2020-06-12 | Aleutians East Borough | Alaska | 2013 | 1 | 0 |
233988 | 233988 | 2020-06-13 | Aleutians East Borough | Alaska | 2013 | 1 | 0 |
237095 | 237095 | 2020-06-14 | Aleutians East Borough | Alaska | 2013 | 1 | 0 |
240203 | 240203 | 2020-06-15 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
243314 | 243314 | 2020-06-16 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
246427 | 246427 | 2020-06-17 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
249539 | 249539 | 2020-06-18 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
252654 | 252654 | 2020-06-19 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
255773 | 255773 | 2020-06-20 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
258900 | 258900 | 2020-06-21 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
262027 | 262027 | 2020-06-22 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
265156 | 265156 | 2020-06-23 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
268285 | 268285 | 2020-06-24 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
271419 | 271419 | 2020-06-25 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
274559 | 274559 | 2020-06-26 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
277707 | 277707 | 2020-06-27 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
280855 | 280855 | 2020-06-28 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
284001 | 284001 | 2020-06-29 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
287147 | 287147 | 2020-06-30 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
290297 | 290297 | 2020-07-01 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
293450 | 293450 | 2020-07-02 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
296605 | 296605 | 2020-07-03 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
299767 | 299767 | 2020-07-04 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
302931 | 302931 | 2020-07-05 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
306095 | 306095 | 2020-07-06 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
309264 | 309264 | 2020-07-07 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
312433 | 312433 | 2020-07-08 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
315608 | 315608 | 2020-07-09 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
318781 | 318781 | 2020-07-10 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
321960 | 321960 | 2020-07-11 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
325141 | 325141 | 2020-07-12 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
328327 | 328327 | 2020-07-13 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
331513 | 331513 | 2020-07-14 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
334706 | 334706 | 2020-07-15 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
337901 | 337901 | 2020-07-16 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
341097 | 341097 | 2020-07-17 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
344296 | 344296 | 2020-07-18 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
347496 | 347496 | 2020-07-19 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
350697 | 350697 | 2020-07-20 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
353899 | 353899 | 2020-07-21 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
357102 | 357102 | 2020-07-22 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
360307 | 360307 | 2020-07-23 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
363513 | 363513 | 2020-07-24 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
366720 | 366720 | 2020-07-25 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
369930 | 369930 | 2020-07-26 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
373142 | 373142 | 2020-07-27 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
376356 | 376356 | 2020-07-28 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
379572 | 379572 | 2020-07-29 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
382789 | 382789 | 2020-07-30 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
386007 | 386007 | 2020-07-31 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
389224 | 389224 | 2020-08-01 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
392441 | 392441 | 2020-08-02 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
395657 | 395657 | 2020-08-03 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
398873 | 398873 | 2020-08-04 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
402089 | 402089 | 2020-08-05 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
405307 | 405307 | 2020-08-06 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
408527 | 408527 | 2020-08-07 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
411746 | 411746 | 2020-08-08 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
414966 | 414966 | 2020-08-09 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
418187 | 418187 | 2020-08-10 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
421408 | 421408 | 2020-08-11 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
424629 | 424629 | 2020-08-12 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
427853 | 427853 | 2020-08-13 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
431081 | 431081 | 2020-08-14 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
434306 | 434306 | 2020-08-15 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
437532 | 437532 | 2020-08-16 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
440758 | 440758 | 2020-08-17 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
443984 | 443984 | 2020-08-18 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
447211 | 447211 | 2020-08-19 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
450439 | 450439 | 2020-08-20 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
453667 | 453667 | 2020-08-21 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
456895 | 456895 | 2020-08-22 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
460122 | 460122 | 2020-08-23 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
463351 | 463351 | 2020-08-24 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
466580 | 466580 | 2020-08-25 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
469809 | 469809 | 2020-08-26 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
473041 | 473041 | 2020-08-27 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
476274 | 476274 | 2020-08-28 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
479507 | 479507 | 2020-08-29 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
482741 | 482741 | 2020-08-30 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
485976 | 485976 | 2020-08-31 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
489209 | 489209 | 2020-09-01 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
492442 | 492442 | 2020-09-02 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
495676 | 495676 | 2020-09-03 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
498909 | 498909 | 2020-09-04 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
502143 | 502143 | 2020-09-05 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
505377 | 505377 | 2020-09-06 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
508609 | 508609 | 2020-09-07 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
511842 | 511842 | 2020-09-08 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
515075 | 515075 | 2020-09-09 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
518310 | 518310 | 2020-09-10 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
521547 | 521547 | 2020-09-11 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
524783 | 524783 | 2020-09-12 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
528019 | 528019 | 2020-09-13 | Aleutians East Borough | Alaska | 2013 | 10 | 0 |
531256 | 531256 | 2020-09-14 | Aleutians East Borough | Alaska | 2013 | 11 | 0 |
534491 | 534491 | 2020-09-15 | Aleutians East Borough | Alaska | 2013 | 11 | 0 |
537727 | 537727 | 2020-09-16 | Aleutians East Borough | Alaska | 2013 | 11 | 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);