ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
709 rows where fips = 2016 and state = "Alaska" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
206146 | 206146 | 2020-06-04 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
209228 | 209228 | 2020-06-05 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
212313 | 212313 | 2020-06-06 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
215400 | 215400 | 2020-06-07 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
218490 | 218490 | 2020-06-08 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
221583 | 221583 | 2020-06-09 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
224679 | 224679 | 2020-06-10 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
227780 | 227780 | 2020-06-11 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
230884 | 230884 | 2020-06-12 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
233989 | 233989 | 2020-06-13 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
237096 | 237096 | 2020-06-14 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
240204 | 240204 | 2020-06-15 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
243315 | 243315 | 2020-06-16 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
246428 | 246428 | 2020-06-17 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
249540 | 249540 | 2020-06-18 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
252655 | 252655 | 2020-06-19 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
255774 | 255774 | 2020-06-20 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
258901 | 258901 | 2020-06-21 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
262028 | 262028 | 2020-06-22 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
265157 | 265157 | 2020-06-23 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
268286 | 268286 | 2020-06-24 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
271420 | 271420 | 2020-06-25 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
274560 | 274560 | 2020-06-26 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
277708 | 277708 | 2020-06-27 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
280856 | 280856 | 2020-06-28 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
284002 | 284002 | 2020-06-29 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
287148 | 287148 | 2020-06-30 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
290298 | 290298 | 2020-07-01 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
293451 | 293451 | 2020-07-02 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
296606 | 296606 | 2020-07-03 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
299768 | 299768 | 2020-07-04 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
302932 | 302932 | 2020-07-05 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
306096 | 306096 | 2020-07-06 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
309265 | 309265 | 2020-07-07 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
312434 | 312434 | 2020-07-08 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
315609 | 315609 | 2020-07-09 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
318782 | 318782 | 2020-07-10 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
321961 | 321961 | 2020-07-11 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
325142 | 325142 | 2020-07-12 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
328328 | 328328 | 2020-07-13 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
331514 | 331514 | 2020-07-14 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
334707 | 334707 | 2020-07-15 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
337902 | 337902 | 2020-07-16 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
341098 | 341098 | 2020-07-17 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
344297 | 344297 | 2020-07-18 | Aleutians West Census Area | Alaska | 2016 | 12 | 0 |
347497 | 347497 | 2020-07-19 | Aleutians West Census Area | Alaska | 2016 | 48 | 0 |
350698 | 350698 | 2020-07-20 | Aleutians West Census Area | Alaska | 2016 | 84 | 0 |
353900 | 353900 | 2020-07-21 | Aleutians West Census Area | Alaska | 2016 | 85 | 0 |
357103 | 357103 | 2020-07-22 | Aleutians West Census Area | Alaska | 2016 | 85 | 0 |
360308 | 360308 | 2020-07-23 | Aleutians West Census Area | Alaska | 2016 | 85 | 0 |
363514 | 363514 | 2020-07-24 | Aleutians West Census Area | Alaska | 2016 | 85 | 0 |
366721 | 366721 | 2020-07-25 | Aleutians West Census Area | Alaska | 2016 | 86 | 0 |
369931 | 369931 | 2020-07-26 | Aleutians West Census Area | Alaska | 2016 | 87 | 0 |
373143 | 373143 | 2020-07-27 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
376357 | 376357 | 2020-07-28 | Aleutians West Census Area | Alaska | 2016 | 87 | 0 |
379573 | 379573 | 2020-07-29 | Aleutians West Census Area | Alaska | 2016 | 87 | 0 |
382790 | 382790 | 2020-07-30 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
386008 | 386008 | 2020-07-31 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
389225 | 389225 | 2020-08-01 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
392442 | 392442 | 2020-08-02 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
395658 | 395658 | 2020-08-03 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
398874 | 398874 | 2020-08-04 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
402090 | 402090 | 2020-08-05 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
405308 | 405308 | 2020-08-06 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
408528 | 408528 | 2020-08-07 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
411747 | 411747 | 2020-08-08 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
414967 | 414967 | 2020-08-09 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
418188 | 418188 | 2020-08-10 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
421409 | 421409 | 2020-08-11 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
424630 | 424630 | 2020-08-12 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
427854 | 427854 | 2020-08-13 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
431082 | 431082 | 2020-08-14 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
434307 | 434307 | 2020-08-15 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
437533 | 437533 | 2020-08-16 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
440759 | 440759 | 2020-08-17 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
443985 | 443985 | 2020-08-18 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
447212 | 447212 | 2020-08-19 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
450440 | 450440 | 2020-08-20 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
453668 | 453668 | 2020-08-21 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
456896 | 456896 | 2020-08-22 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
460123 | 460123 | 2020-08-23 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
463352 | 463352 | 2020-08-24 | Aleutians West Census Area | Alaska | 2016 | 89 | 0 |
466581 | 466581 | 2020-08-25 | Aleutians West Census Area | Alaska | 2016 | 90 | 0 |
469810 | 469810 | 2020-08-26 | Aleutians West Census Area | Alaska | 2016 | 91 | 0 |
473042 | 473042 | 2020-08-27 | Aleutians West Census Area | Alaska | 2016 | 91 | 0 |
476275 | 476275 | 2020-08-28 | Aleutians West Census Area | Alaska | 2016 | 91 | 0 |
479508 | 479508 | 2020-08-29 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
482742 | 482742 | 2020-08-30 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
485977 | 485977 | 2020-08-31 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
489210 | 489210 | 2020-09-01 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
492443 | 492443 | 2020-09-02 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
495677 | 495677 | 2020-09-03 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
498910 | 498910 | 2020-09-04 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
502144 | 502144 | 2020-09-05 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
505378 | 505378 | 2020-09-06 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
508610 | 508610 | 2020-09-07 | Aleutians West Census Area | Alaska | 2016 | 92 | 0 |
511843 | 511843 | 2020-09-08 | Aleutians West Census Area | Alaska | 2016 | 93 | 0 |
515076 | 515076 | 2020-09-09 | Aleutians West Census Area | Alaska | 2016 | 93 | 0 |
518311 | 518311 | 2020-09-10 | Aleutians West Census Area | Alaska | 2016 | 93 | 0 |
521548 | 521548 | 2020-09-11 | Aleutians West Census Area | Alaska | 2016 | 93 | 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);