ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193 rows where deaths = 1, fips = 23007 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
694470 | 694470 | 2020-11-03 | Franklin | Maine | 23007 | 96 | 1 |
691228 | 691228 | 2020-11-02 | Franklin | Maine | 23007 | 90 | 1 |
687983 | 687983 | 2020-11-01 | Franklin | Maine | 23007 | 86 | 1 |
684739 | 684739 | 2020-10-31 | Franklin | Maine | 23007 | 82 | 1 |
681496 | 681496 | 2020-10-30 | Franklin | Maine | 23007 | 80 | 1 |
678252 | 678252 | 2020-10-29 | Franklin | Maine | 23007 | 79 | 1 |
675010 | 675010 | 2020-10-28 | Franklin | Maine | 23007 | 77 | 1 |
671767 | 671767 | 2020-10-27 | Franklin | Maine | 23007 | 74 | 1 |
668525 | 668525 | 2020-10-26 | Franklin | Maine | 23007 | 74 | 1 |
665281 | 665281 | 2020-10-25 | Franklin | Maine | 23007 | 74 | 1 |
662036 | 662036 | 2020-10-24 | Franklin | Maine | 23007 | 74 | 1 |
658792 | 658792 | 2020-10-23 | Franklin | Maine | 23007 | 74 | 1 |
655547 | 655547 | 2020-10-22 | Franklin | Maine | 23007 | 74 | 1 |
652302 | 652302 | 2020-10-21 | Franklin | Maine | 23007 | 74 | 1 |
649057 | 649057 | 2020-10-20 | Franklin | Maine | 23007 | 73 | 1 |
645813 | 645813 | 2020-10-19 | Franklin | Maine | 23007 | 73 | 1 |
642566 | 642566 | 2020-10-18 | Franklin | Maine | 23007 | 73 | 1 |
639319 | 639319 | 2020-10-17 | Franklin | Maine | 23007 | 73 | 1 |
636073 | 636073 | 2020-10-16 | Franklin | Maine | 23007 | 73 | 1 |
632827 | 632827 | 2020-10-15 | Franklin | Maine | 23007 | 73 | 1 |
629583 | 629583 | 2020-10-14 | Franklin | Maine | 23007 | 71 | 1 |
626339 | 626339 | 2020-10-13 | Franklin | Maine | 23007 | 72 | 1 |
623097 | 623097 | 2020-10-12 | Franklin | Maine | 23007 | 71 | 1 |
619853 | 619853 | 2020-10-11 | Franklin | Maine | 23007 | 69 | 1 |
616611 | 616611 | 2020-10-10 | Franklin | Maine | 23007 | 67 | 1 |
613370 | 613370 | 2020-10-09 | Franklin | Maine | 23007 | 66 | 1 |
610128 | 610128 | 2020-10-08 | Franklin | Maine | 23007 | 64 | 1 |
606886 | 606886 | 2020-10-07 | Franklin | Maine | 23007 | 64 | 1 |
603644 | 603644 | 2020-10-06 | Franklin | Maine | 23007 | 64 | 1 |
600401 | 600401 | 2020-10-05 | Franklin | Maine | 23007 | 63 | 1 |
597159 | 597159 | 2020-10-04 | Franklin | Maine | 23007 | 63 | 1 |
593917 | 593917 | 2020-10-03 | Franklin | Maine | 23007 | 62 | 1 |
590676 | 590676 | 2020-10-02 | Franklin | Maine | 23007 | 62 | 1 |
587435 | 587435 | 2020-10-01 | Franklin | Maine | 23007 | 62 | 1 |
584195 | 584195 | 2020-09-30 | Franklin | Maine | 23007 | 62 | 1 |
580955 | 580955 | 2020-09-29 | Franklin | Maine | 23007 | 62 | 1 |
577714 | 577714 | 2020-09-28 | Franklin | Maine | 23007 | 62 | 1 |
574472 | 574472 | 2020-09-27 | Franklin | Maine | 23007 | 61 | 1 |
571229 | 571229 | 2020-09-26 | Franklin | Maine | 23007 | 62 | 1 |
567987 | 567987 | 2020-09-25 | Franklin | Maine | 23007 | 61 | 1 |
564747 | 564747 | 2020-09-24 | Franklin | Maine | 23007 | 60 | 1 |
561507 | 561507 | 2020-09-23 | Franklin | Maine | 23007 | 60 | 1 |
558271 | 558271 | 2020-09-22 | Franklin | Maine | 23007 | 60 | 1 |
555034 | 555034 | 2020-09-21 | Franklin | Maine | 23007 | 59 | 1 |
551795 | 551795 | 2020-09-20 | Franklin | Maine | 23007 | 59 | 1 |
548556 | 548556 | 2020-09-19 | Franklin | Maine | 23007 | 58 | 1 |
545318 | 545318 | 2020-09-18 | Franklin | Maine | 23007 | 56 | 1 |
542082 | 542082 | 2020-09-17 | Franklin | Maine | 23007 | 54 | 1 |
538846 | 538846 | 2020-09-16 | Franklin | Maine | 23007 | 53 | 1 |
535609 | 535609 | 2020-09-15 | Franklin | Maine | 23007 | 53 | 1 |
532374 | 532374 | 2020-09-14 | Franklin | Maine | 23007 | 54 | 1 |
529137 | 529137 | 2020-09-13 | Franklin | Maine | 23007 | 54 | 1 |
525901 | 525901 | 2020-09-12 | Franklin | Maine | 23007 | 54 | 1 |
522665 | 522665 | 2020-09-11 | Franklin | Maine | 23007 | 53 | 1 |
519428 | 519428 | 2020-09-10 | Franklin | Maine | 23007 | 53 | 1 |
516193 | 516193 | 2020-09-09 | Franklin | Maine | 23007 | 53 | 1 |
512960 | 512960 | 2020-09-08 | Franklin | Maine | 23007 | 53 | 1 |
509728 | 509728 | 2020-09-07 | Franklin | Maine | 23007 | 53 | 1 |
506495 | 506495 | 2020-09-06 | Franklin | Maine | 23007 | 53 | 1 |
503261 | 503261 | 2020-09-05 | Franklin | Maine | 23007 | 53 | 1 |
500028 | 500028 | 2020-09-04 | Franklin | Maine | 23007 | 53 | 1 |
496794 | 496794 | 2020-09-03 | Franklin | Maine | 23007 | 53 | 1 |
493561 | 493561 | 2020-09-02 | Franklin | Maine | 23007 | 53 | 1 |
490327 | 490327 | 2020-09-01 | Franklin | Maine | 23007 | 52 | 1 |
487094 | 487094 | 2020-08-31 | Franklin | Maine | 23007 | 53 | 1 |
483859 | 483859 | 2020-08-30 | Franklin | Maine | 23007 | 53 | 1 |
480625 | 480625 | 2020-08-29 | Franklin | Maine | 23007 | 50 | 1 |
477392 | 477392 | 2020-08-28 | Franklin | Maine | 23007 | 50 | 1 |
474159 | 474159 | 2020-08-27 | Franklin | Maine | 23007 | 50 | 1 |
470927 | 470927 | 2020-08-26 | Franklin | Maine | 23007 | 48 | 1 |
467698 | 467698 | 2020-08-25 | Franklin | Maine | 23007 | 48 | 1 |
464469 | 464469 | 2020-08-24 | Franklin | Maine | 23007 | 48 | 1 |
461238 | 461238 | 2020-08-23 | Franklin | Maine | 23007 | 48 | 1 |
458011 | 458011 | 2020-08-22 | Franklin | Maine | 23007 | 47 | 1 |
454783 | 454783 | 2020-08-21 | Franklin | Maine | 23007 | 47 | 1 |
451555 | 451555 | 2020-08-20 | Franklin | Maine | 23007 | 47 | 1 |
448327 | 448327 | 2020-08-19 | Franklin | Maine | 23007 | 47 | 1 |
445100 | 445100 | 2020-08-18 | Franklin | Maine | 23007 | 47 | 1 |
441874 | 441874 | 2020-08-17 | Franklin | Maine | 23007 | 47 | 1 |
438647 | 438647 | 2020-08-16 | Franklin | Maine | 23007 | 47 | 1 |
435422 | 435422 | 2020-08-15 | Franklin | Maine | 23007 | 47 | 1 |
432197 | 432197 | 2020-08-14 | Franklin | Maine | 23007 | 47 | 1 |
428969 | 428969 | 2020-08-13 | Franklin | Maine | 23007 | 45 | 1 |
425745 | 425745 | 2020-08-12 | Franklin | Maine | 23007 | 45 | 1 |
422524 | 422524 | 2020-08-11 | Franklin | Maine | 23007 | 45 | 1 |
419302 | 419302 | 2020-08-10 | Franklin | Maine | 23007 | 45 | 1 |
416081 | 416081 | 2020-08-09 | Franklin | Maine | 23007 | 45 | 1 |
412861 | 412861 | 2020-08-08 | Franklin | Maine | 23007 | 45 | 1 |
409641 | 409641 | 2020-08-07 | Franklin | Maine | 23007 | 45 | 1 |
406421 | 406421 | 2020-08-06 | Franklin | Maine | 23007 | 45 | 1 |
403203 | 403203 | 2020-08-05 | Franklin | Maine | 23007 | 45 | 1 |
399986 | 399986 | 2020-08-04 | Franklin | Maine | 23007 | 45 | 1 |
396771 | 396771 | 2020-08-03 | Franklin | Maine | 23007 | 45 | 1 |
393555 | 393555 | 2020-08-02 | Franklin | Maine | 23007 | 45 | 1 |
390338 | 390338 | 2020-08-01 | Franklin | Maine | 23007 | 45 | 1 |
387121 | 387121 | 2020-07-31 | Franklin | Maine | 23007 | 45 | 1 |
383903 | 383903 | 2020-07-30 | Franklin | Maine | 23007 | 45 | 1 |
380686 | 380686 | 2020-07-29 | Franklin | Maine | 23007 | 45 | 1 |
377469 | 377469 | 2020-07-28 | Franklin | Maine | 23007 | 45 | 1 |
374254 | 374254 | 2020-07-27 | Franklin | Maine | 23007 | 45 | 1 |
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);