ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
713 rows where fips = 2070 and state = "Alaska" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
193851 | 193851 | 2020-05-31 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
196921 | 196921 | 2020-06-01 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
199994 | 199994 | 2020-06-02 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
203070 | 203070 | 2020-06-03 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
206150 | 206150 | 2020-06-04 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
209232 | 209232 | 2020-06-05 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
212317 | 212317 | 2020-06-06 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
215404 | 215404 | 2020-06-07 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
218494 | 218494 | 2020-06-08 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
221587 | 221587 | 2020-06-09 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
224683 | 224683 | 2020-06-10 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
227784 | 227784 | 2020-06-11 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
230888 | 230888 | 2020-06-12 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
233993 | 233993 | 2020-06-13 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
237100 | 237100 | 2020-06-14 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
240208 | 240208 | 2020-06-15 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
243319 | 243319 | 2020-06-16 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
246432 | 246432 | 2020-06-17 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
249544 | 249544 | 2020-06-18 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
252659 | 252659 | 2020-06-19 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
255778 | 255778 | 2020-06-20 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
258905 | 258905 | 2020-06-21 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
262032 | 262032 | 2020-06-22 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
265161 | 265161 | 2020-06-23 | Dillingham Census Area | Alaska | 2070 | 14 | 0 |
268290 | 268290 | 2020-06-24 | Dillingham Census Area | Alaska | 2070 | 14 | 0 |
271425 | 271425 | 2020-06-25 | Dillingham Census Area | Alaska | 2070 | 14 | 0 |
274565 | 274565 | 2020-06-26 | Dillingham Census Area | Alaska | 2070 | 14 | 0 |
277713 | 277713 | 2020-06-27 | Dillingham Census Area | Alaska | 2070 | 16 | 0 |
280861 | 280861 | 2020-06-28 | Dillingham Census Area | Alaska | 2070 | 17 | 0 |
284007 | 284007 | 2020-06-29 | Dillingham Census Area | Alaska | 2070 | 17 | 0 |
287153 | 287153 | 2020-06-30 | Dillingham Census Area | Alaska | 2070 | 18 | 0 |
290303 | 290303 | 2020-07-01 | Dillingham Census Area | Alaska | 2070 | 18 | 0 |
293456 | 293456 | 2020-07-02 | Dillingham Census Area | Alaska | 2070 | 20 | 0 |
296611 | 296611 | 2020-07-03 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
299773 | 299773 | 2020-07-04 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
302937 | 302937 | 2020-07-05 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
306101 | 306101 | 2020-07-06 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
309270 | 309270 | 2020-07-07 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
312439 | 312439 | 2020-07-08 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
315614 | 315614 | 2020-07-09 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
318787 | 318787 | 2020-07-10 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
321966 | 321966 | 2020-07-11 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
325147 | 325147 | 2020-07-12 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
328333 | 328333 | 2020-07-13 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
331519 | 331519 | 2020-07-14 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
334712 | 334712 | 2020-07-15 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
337907 | 337907 | 2020-07-16 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
341103 | 341103 | 2020-07-17 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
344302 | 344302 | 2020-07-18 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
347502 | 347502 | 2020-07-19 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
350703 | 350703 | 2020-07-20 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
353905 | 353905 | 2020-07-21 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
357108 | 357108 | 2020-07-22 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
360313 | 360313 | 2020-07-23 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
363519 | 363519 | 2020-07-24 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
366726 | 366726 | 2020-07-25 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
369936 | 369936 | 2020-07-26 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
373148 | 373148 | 2020-07-27 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
376362 | 376362 | 2020-07-28 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
379578 | 379578 | 2020-07-29 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
382795 | 382795 | 2020-07-30 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
386013 | 386013 | 2020-07-31 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
389230 | 389230 | 2020-08-01 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
392447 | 392447 | 2020-08-02 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
395663 | 395663 | 2020-08-03 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
398879 | 398879 | 2020-08-04 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
402095 | 402095 | 2020-08-05 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
405313 | 405313 | 2020-08-06 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
408533 | 408533 | 2020-08-07 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
411752 | 411752 | 2020-08-08 | Dillingham Census Area | Alaska | 2070 | 23 | 0 |
414972 | 414972 | 2020-08-09 | Dillingham Census Area | Alaska | 2070 | 23 | 0 |
418193 | 418193 | 2020-08-10 | Dillingham Census Area | Alaska | 2070 | 23 | 0 |
421414 | 421414 | 2020-08-11 | Dillingham Census Area | Alaska | 2070 | 24 | 0 |
424635 | 424635 | 2020-08-12 | Dillingham Census Area | Alaska | 2070 | 24 | 0 |
427859 | 427859 | 2020-08-13 | Dillingham Census Area | Alaska | 2070 | 24 | 0 |
431087 | 431087 | 2020-08-14 | Dillingham Census Area | Alaska | 2070 | 24 | 0 |
434312 | 434312 | 2020-08-15 | Dillingham Census Area | Alaska | 2070 | 24 | 0 |
437538 | 437538 | 2020-08-16 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
440764 | 440764 | 2020-08-17 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
443990 | 443990 | 2020-08-18 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
447217 | 447217 | 2020-08-19 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
450445 | 450445 | 2020-08-20 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
453673 | 453673 | 2020-08-21 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
456901 | 456901 | 2020-08-22 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
460128 | 460128 | 2020-08-23 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
463357 | 463357 | 2020-08-24 | Dillingham Census Area | Alaska | 2070 | 27 | 0 |
466586 | 466586 | 2020-08-25 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
469815 | 469815 | 2020-08-26 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
473047 | 473047 | 2020-08-27 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
476280 | 476280 | 2020-08-28 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
479513 | 479513 | 2020-08-29 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
482747 | 482747 | 2020-08-30 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
485982 | 485982 | 2020-08-31 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
489215 | 489215 | 2020-09-01 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
492448 | 492448 | 2020-09-02 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
495682 | 495682 | 2020-09-03 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
498915 | 498915 | 2020-09-04 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
502149 | 502149 | 2020-09-05 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
505383 | 505383 | 2020-09-06 | Dillingham Census Area | Alaska | 2070 | 26 | 0 |
508615 | 508615 | 2020-09-07 | Dillingham Census Area | Alaska | 2070 | 26 | 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);