ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where deaths = 8, fips = 23025 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 |
---|---|---|---|---|---|---|---|
704208 | 704208 | 2020-11-06 | Somerset | Maine | 23025 | 262 | 8 |
700966 | 700966 | 2020-11-05 | Somerset | Maine | 23025 | 249 | 8 |
697722 | 697722 | 2020-11-04 | Somerset | Maine | 23025 | 236 | 8 |
694479 | 694479 | 2020-11-03 | Somerset | Maine | 23025 | 220 | 8 |
691237 | 691237 | 2020-11-02 | Somerset | Maine | 23025 | 208 | 8 |
687992 | 687992 | 2020-11-01 | Somerset | Maine | 23025 | 199 | 8 |
684748 | 684748 | 2020-10-31 | Somerset | Maine | 23025 | 193 | 8 |
681505 | 681505 | 2020-10-30 | Somerset | Maine | 23025 | 183 | 8 |
678261 | 678261 | 2020-10-29 | Somerset | Maine | 23025 | 172 | 8 |
675019 | 675019 | 2020-10-28 | Somerset | Maine | 23025 | 153 | 8 |
671776 | 671776 | 2020-10-27 | Somerset | Maine | 23025 | 146 | 8 |
668534 | 668534 | 2020-10-26 | Somerset | Maine | 23025 | 141 | 8 |
665290 | 665290 | 2020-10-25 | Somerset | Maine | 23025 | 137 | 8 |
662045 | 662045 | 2020-10-24 | Somerset | Maine | 23025 | 133 | 8 |
658801 | 658801 | 2020-10-23 | Somerset | Maine | 23025 | 129 | 8 |
655556 | 655556 | 2020-10-22 | Somerset | Maine | 23025 | 129 | 8 |
652311 | 652311 | 2020-10-21 | Somerset | Maine | 23025 | 127 | 8 |
649066 | 649066 | 2020-10-20 | Somerset | Maine | 23025 | 126 | 8 |
645822 | 645822 | 2020-10-19 | Somerset | Maine | 23025 | 126 | 8 |
642575 | 642575 | 2020-10-18 | Somerset | Maine | 23025 | 127 | 8 |
639328 | 639328 | 2020-10-17 | Somerset | Maine | 23025 | 127 | 8 |
636082 | 636082 | 2020-10-16 | Somerset | Maine | 23025 | 125 | 8 |
632836 | 632836 | 2020-10-15 | Somerset | Maine | 23025 | 125 | 8 |
629592 | 629592 | 2020-10-14 | Somerset | Maine | 23025 | 128 | 8 |
626348 | 626348 | 2020-10-13 | Somerset | Maine | 23025 | 123 | 8 |
623106 | 623106 | 2020-10-12 | Somerset | Maine | 23025 | 118 | 8 |
619862 | 619862 | 2020-10-11 | Somerset | Maine | 23025 | 112 | 8 |
616620 | 616620 | 2020-10-10 | Somerset | Maine | 23025 | 108 | 8 |
613379 | 613379 | 2020-10-09 | Somerset | Maine | 23025 | 103 | 8 |
610137 | 610137 | 2020-10-08 | Somerset | Maine | 23025 | 99 | 8 |
606895 | 606895 | 2020-10-07 | Somerset | Maine | 23025 | 96 | 8 |
603653 | 603653 | 2020-10-06 | Somerset | Maine | 23025 | 92 | 8 |
600410 | 600410 | 2020-10-05 | Somerset | Maine | 23025 | 88 | 8 |
597168 | 597168 | 2020-10-04 | Somerset | Maine | 23025 | 86 | 8 |
593926 | 593926 | 2020-10-03 | Somerset | Maine | 23025 | 86 | 8 |
590685 | 590685 | 2020-10-02 | Somerset | Maine | 23025 | 86 | 8 |
587444 | 587444 | 2020-10-01 | Somerset | Maine | 23025 | 86 | 8 |
584204 | 584204 | 2020-09-30 | Somerset | Maine | 23025 | 86 | 8 |
580964 | 580964 | 2020-09-29 | Somerset | Maine | 23025 | 86 | 8 |
577723 | 577723 | 2020-09-28 | Somerset | Maine | 23025 | 86 | 8 |
574481 | 574481 | 2020-09-27 | Somerset | Maine | 23025 | 86 | 8 |
571238 | 571238 | 2020-09-26 | Somerset | Maine | 23025 | 85 | 8 |
567996 | 567996 | 2020-09-25 | Somerset | Maine | 23025 | 84 | 8 |
564756 | 564756 | 2020-09-24 | Somerset | Maine | 23025 | 85 | 8 |
561516 | 561516 | 2020-09-23 | Somerset | Maine | 23025 | 85 | 8 |
558280 | 558280 | 2020-09-22 | Somerset | Maine | 23025 | 86 | 8 |
555043 | 555043 | 2020-09-21 | Somerset | Maine | 23025 | 86 | 8 |
551804 | 551804 | 2020-09-20 | Somerset | Maine | 23025 | 86 | 8 |
548565 | 548565 | 2020-09-19 | Somerset | Maine | 23025 | 85 | 8 |
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);