ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
703 rows where county = "Unknown" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631729 | 631729 | 2020-10-15 | Unknown | Alaska | 49 | 0 | |
628485 | 628485 | 2020-10-14 | Unknown | Alaska | 47 | 0 | |
625242 | 625242 | 2020-10-13 | Unknown | Alaska | 47 | 0 | |
621999 | 621999 | 2020-10-12 | Unknown | Alaska | 47 | 0 | |
618756 | 618756 | 2020-10-11 | Unknown | Alaska | 43 | 0 | |
615514 | 615514 | 2020-10-10 | Unknown | Alaska | 43 | 0 | |
612273 | 612273 | 2020-10-09 | Unknown | Alaska | 43 | 0 | |
609031 | 609031 | 2020-10-08 | Unknown | Alaska | 41 | 0 | |
605788 | 605788 | 2020-10-07 | Unknown | Alaska | 39 | 0 | |
602546 | 602546 | 2020-10-06 | Unknown | Alaska | 39 | 0 | |
599303 | 599303 | 2020-10-05 | Unknown | Alaska | 37 | 0 | |
596060 | 596060 | 2020-10-04 | Unknown | Alaska | 37 | 0 | |
592818 | 592818 | 2020-10-03 | Unknown | Alaska | 37 | 0 | |
589578 | 589578 | 2020-10-02 | Unknown | Alaska | 36 | 0 | |
586337 | 586337 | 2020-10-01 | Unknown | Alaska | 35 | 0 | |
583097 | 583097 | 2020-09-30 | Unknown | Alaska | 36 | 0 | |
579858 | 579858 | 2020-09-29 | Unknown | Alaska | 36 | 0 | |
576617 | 576617 | 2020-09-28 | Unknown | Alaska | 40 | 0 | |
573373 | 573373 | 2020-09-27 | Unknown | Alaska | 40 | 0 | |
570131 | 570131 | 2020-09-26 | Unknown | Alaska | 40 | 0 | |
566890 | 566890 | 2020-09-25 | Unknown | Alaska | 38 | 0 | |
563649 | 563649 | 2020-09-24 | Unknown | Alaska | 38 | 0 | |
560410 | 560410 | 2020-09-23 | Unknown | Alaska | 37 | 0 | |
557174 | 557174 | 2020-09-22 | Unknown | Alaska | 36 | 0 | |
553937 | 553937 | 2020-09-21 | Unknown | Alaska | 36 | 0 | |
550698 | 550698 | 2020-09-20 | Unknown | Alaska | 44 | 0 | |
547459 | 547459 | 2020-09-19 | Unknown | Alaska | 44 | 0 | |
544222 | 544222 | 2020-09-18 | Unknown | Alaska | 46 | 0 | |
540986 | 540986 | 2020-09-17 | Unknown | Alaska | 41 | 0 | |
537749 | 537749 | 2020-09-16 | Unknown | Alaska | 43 | 0 | |
534513 | 534513 | 2020-09-15 | Unknown | Alaska | 43 | 0 | |
531278 | 531278 | 2020-09-14 | Unknown | Alaska | 43 | 0 | |
528041 | 528041 | 2020-09-13 | Unknown | Alaska | 41 | 0 | |
524805 | 524805 | 2020-09-12 | Unknown | Alaska | 41 | 0 | |
521569 | 521569 | 2020-09-11 | Unknown | Alaska | 39 | 0 | |
518332 | 518332 | 2020-09-10 | Unknown | Alaska | 38 | 0 | |
515097 | 515097 | 2020-09-09 | Unknown | Alaska | 37 | 0 | |
511864 | 511864 | 2020-09-08 | Unknown | Alaska | 37 | 0 | |
508631 | 508631 | 2020-09-07 | Unknown | Alaska | 37 | 0 | |
505399 | 505399 | 2020-09-06 | Unknown | Alaska | 37 | 0 | |
502165 | 502165 | 2020-09-05 | Unknown | Alaska | 37 | 0 | |
498931 | 498931 | 2020-09-04 | Unknown | Alaska | 37 | 0 | |
495698 | 495698 | 2020-09-03 | Unknown | Alaska | 37 | 0 | |
492464 | 492464 | 2020-09-02 | Unknown | Alaska | 36 | 0 | |
489231 | 489231 | 2020-09-01 | Unknown | Alaska | 37 | 0 | |
485998 | 485998 | 2020-08-31 | Unknown | Alaska | 36 | 0 | |
482763 | 482763 | 2020-08-30 | Unknown | Alaska | 36 | 0 | |
479529 | 479529 | 2020-08-29 | Unknown | Alaska | 38 | 0 | |
476296 | 476296 | 2020-08-28 | Unknown | Alaska | 38 | 0 | |
473063 | 473063 | 2020-08-27 | Unknown | Alaska | 38 | 0 | |
469831 | 469831 | 2020-08-26 | Unknown | Alaska | 39 | 0 | |
466602 | 466602 | 2020-08-25 | Unknown | Alaska | 37 | 0 | |
463373 | 463373 | 2020-08-24 | Unknown | Alaska | 41 | 0 | |
460144 | 460144 | 2020-08-23 | Unknown | Alaska | 40 | 0 | |
456917 | 456917 | 2020-08-22 | Unknown | Alaska | 40 | 0 | |
453689 | 453689 | 2020-08-21 | Unknown | Alaska | 42 | 0 | |
450461 | 450461 | 2020-08-20 | Unknown | Alaska | 41 | 0 | |
447233 | 447233 | 2020-08-19 | Unknown | Alaska | 40 | 0 | |
444006 | 444006 | 2020-08-18 | Unknown | Alaska | 40 | 0 | |
440780 | 440780 | 2020-08-17 | Unknown | Alaska | 40 | 0 | |
437554 | 437554 | 2020-08-16 | Unknown | Alaska | 40 | 0 | |
434328 | 434328 | 2020-08-15 | Unknown | Alaska | 40 | 0 | |
431103 | 431103 | 2020-08-14 | Unknown | Alaska | 41 | 0 | |
427875 | 427875 | 2020-08-13 | Unknown | Alaska | 37 | 0 | |
424651 | 424651 | 2020-08-12 | Unknown | Alaska | 34 | 0 | |
421430 | 421430 | 2020-08-11 | Unknown | Alaska | 34 | 0 | |
418209 | 418209 | 2020-08-10 | Unknown | Alaska | 30 | 0 | |
414988 | 414988 | 2020-08-09 | Unknown | Alaska | 29 | 0 | |
411768 | 411768 | 2020-08-08 | Unknown | Alaska | 28 | 0 | |
408549 | 408549 | 2020-08-07 | Unknown | Alaska | 28 | 0 | |
405329 | 405329 | 2020-08-06 | Unknown | Alaska | 27 | 0 | |
402111 | 402111 | 2020-08-05 | Unknown | Alaska | 29 | 0 | |
398895 | 398895 | 2020-08-04 | Unknown | Alaska | 31 | 0 | |
395679 | 395679 | 2020-08-03 | Unknown | Alaska | 47 | 0 | |
392463 | 392463 | 2020-08-02 | Unknown | Alaska | 48 | 0 | |
389246 | 389246 | 2020-08-01 | Unknown | Alaska | 36 | 0 | |
386029 | 386029 | 2020-07-31 | Unknown | Alaska | 39 | 0 | |
382811 | 382811 | 2020-07-30 | Unknown | Alaska | 37 | 0 | |
379594 | 379594 | 2020-07-29 | Unknown | Alaska | 37 | 0 | |
376378 | 376378 | 2020-07-28 | Unknown | Alaska | 35 | 0 | |
373164 | 373164 | 2020-07-27 | Unknown | Alaska | 26 | 0 | |
369952 | 369952 | 2020-07-26 | Unknown | Alaska | 22 | 0 | |
366742 | 366742 | 2020-07-25 | Unknown | Alaska | 16 | 0 | |
363535 | 363535 | 2020-07-24 | Unknown | Alaska | 11 | 0 | |
360329 | 360329 | 2020-07-23 | Unknown | Alaska | 9 | 0 | |
357124 | 357124 | 2020-07-22 | Unknown | Alaska | 8 | 0 | |
353921 | 353921 | 2020-07-21 | Unknown | Alaska | 5 | 0 | |
350719 | 350719 | 2020-07-20 | Unknown | Alaska | 2 | 0 | |
347518 | 347518 | 2020-07-19 | Unknown | Alaska | 9 | 0 | |
344318 | 344318 | 2020-07-18 | Unknown | Alaska | 6 | 0 | |
341119 | 341119 | 2020-07-17 | Unknown | Alaska | 8 | 0 | |
337923 | 337923 | 2020-07-16 | Unknown | Alaska | 15 | 0 | |
334728 | 334728 | 2020-07-15 | Unknown | Alaska | 13 | 0 | |
331535 | 331535 | 2020-07-14 | Unknown | Alaska | 13 | 0 | |
328349 | 328349 | 2020-07-13 | Unknown | Alaska | 17 | 0 | |
325163 | 325163 | 2020-07-12 | Unknown | Alaska | 15 | 0 | |
321982 | 321982 | 2020-07-11 | Unknown | Alaska | 8 | 0 | |
318803 | 318803 | 2020-07-10 | Unknown | Alaska | 5 | 0 | |
315630 | 315630 | 2020-07-09 | Unknown | Alaska | 5 | 0 | |
312455 | 312455 | 2020-07-08 | Unknown | Alaska | 2 | 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);