ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where deaths = 70 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 6
- Cumberland 91
- Oxford 29
- Somerset 6
- Hancock 4
- Androscoggin 3
- Penobscot 2
state 1
- Maine · 135 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2168880 | 2168880 | 2022-01-31 | Hancock | Maine | 23009 | 5124 | 70 |
2165625 | 2165625 | 2022-01-30 | Hancock | Maine | 23009 | 5124 | 70 |
2162370 | 2162370 | 2022-01-29 | Hancock | Maine | 23009 | 5124 | 70 |
2159115 | 2159115 | 2022-01-28 | Hancock | Maine | 23009 | 5104 | 70 |
2038812 | 2038812 | 2021-12-22 | Somerset | Maine | 23025 | 6144 | 70 |
2035562 | 2035562 | 2021-12-21 | Somerset | Maine | 23025 | 6096 | 70 |
2032312 | 2032312 | 2021-12-20 | Somerset | Maine | 23025 | 6029 | 70 |
2029061 | 2029061 | 2021-12-19 | Somerset | Maine | 23025 | 6029 | 70 |
2025810 | 2025810 | 2021-12-18 | Somerset | Maine | 23025 | 6029 | 70 |
2022559 | 2022559 | 2021-12-17 | Somerset | Maine | 23025 | 5958 | 70 |
1629380 | 1629380 | 2021-08-18 | Oxford | Maine | 23017 | 3796 | 70 |
1626133 | 1626133 | 2021-08-17 | Oxford | Maine | 23017 | 3792 | 70 |
1622886 | 1622886 | 2021-08-16 | Oxford | Maine | 23017 | 3771 | 70 |
1619639 | 1619639 | 2021-08-15 | Oxford | Maine | 23017 | 3771 | 70 |
1616391 | 1616391 | 2021-08-14 | Oxford | Maine | 23017 | 3771 | 70 |
1613142 | 1613142 | 2021-08-13 | Oxford | Maine | 23017 | 3766 | 70 |
1609894 | 1609894 | 2021-08-12 | Oxford | Maine | 23017 | 3755 | 70 |
1606645 | 1606645 | 2021-08-11 | Oxford | Maine | 23017 | 3743 | 70 |
1603396 | 1603396 | 2021-08-10 | Oxford | Maine | 23017 | 3734 | 70 |
1600147 | 1600147 | 2021-08-09 | Oxford | Maine | 23017 | 3724 | 70 |
1596899 | 1596899 | 2021-08-08 | Oxford | Maine | 23017 | 3724 | 70 |
1593650 | 1593650 | 2021-08-07 | Oxford | Maine | 23017 | 3724 | 70 |
1590401 | 1590401 | 2021-08-06 | Oxford | Maine | 23017 | 3718 | 70 |
1587152 | 1587152 | 2021-08-05 | Oxford | Maine | 23017 | 3712 | 70 |
1583902 | 1583902 | 2021-08-04 | Oxford | Maine | 23017 | 3706 | 70 |
1580652 | 1580652 | 2021-08-03 | Oxford | Maine | 23017 | 3703 | 70 |
1577403 | 1577403 | 2021-08-02 | Oxford | Maine | 23017 | 3697 | 70 |
1574155 | 1574155 | 2021-08-01 | Oxford | Maine | 23017 | 3697 | 70 |
1570907 | 1570907 | 2021-07-31 | Oxford | Maine | 23017 | 3697 | 70 |
1567659 | 1567659 | 2021-07-30 | Oxford | Maine | 23017 | 3693 | 70 |
1564411 | 1564411 | 2021-07-29 | Oxford | Maine | 23017 | 3689 | 70 |
1561163 | 1561163 | 2021-07-28 | Oxford | Maine | 23017 | 3685 | 70 |
1557916 | 1557916 | 2021-07-27 | Oxford | Maine | 23017 | 3683 | 70 |
1554669 | 1554669 | 2021-07-26 | Oxford | Maine | 23017 | 3676 | 70 |
1551422 | 1551422 | 2021-07-25 | Oxford | Maine | 23017 | 3676 | 70 |
1548175 | 1548175 | 2021-07-24 | Oxford | Maine | 23017 | 3676 | 70 |
1544928 | 1544928 | 2021-07-23 | Oxford | Maine | 23017 | 3673 | 70 |
1541680 | 1541680 | 2021-07-22 | Oxford | Maine | 23017 | 3670 | 70 |
1538433 | 1538433 | 2021-07-21 | Oxford | Maine | 23017 | 3667 | 70 |
1278729 | 1278729 | 2021-05-02 | Androscoggin | Maine | 23001 | 7289 | 70 |
1275482 | 1275482 | 2021-05-01 | Androscoggin | Maine | 23001 | 7208 | 70 |
1272235 | 1272235 | 2021-04-30 | Androscoggin | Maine | 23001 | 7148 | 70 |
996279 | 996279 | 2021-02-04 | Penobscot | Maine | 23019 | 3512 | 70 |
993033 | 993033 | 2021-02-03 | Penobscot | Maine | 23019 | 3490 | 70 |
749620 | 749620 | 2020-11-20 | Cumberland | Maine | 23005 | 3458 | 70 |
746374 | 746374 | 2020-11-19 | Cumberland | Maine | 23005 | 3415 | 70 |
743127 | 743127 | 2020-11-18 | Cumberland | Maine | 23005 | 3361 | 70 |
739880 | 739880 | 2020-11-17 | Cumberland | Maine | 23005 | 3330 | 70 |
736636 | 736636 | 2020-11-16 | Cumberland | Maine | 23005 | 3270 | 70 |
733390 | 733390 | 2020-11-15 | Cumberland | Maine | 23005 | 3219 | 70 |
730145 | 730145 | 2020-11-14 | Cumberland | Maine | 23005 | 3172 | 70 |
726902 | 726902 | 2020-11-13 | Cumberland | Maine | 23005 | 3138 | 70 |
723659 | 723659 | 2020-11-12 | Cumberland | Maine | 23005 | 3098 | 70 |
720416 | 720416 | 2020-11-11 | Cumberland | Maine | 23005 | 3067 | 70 |
717173 | 717173 | 2020-11-10 | Cumberland | Maine | 23005 | 3039 | 70 |
713929 | 713929 | 2020-11-09 | Cumberland | Maine | 23005 | 2998 | 70 |
710685 | 710685 | 2020-11-08 | Cumberland | Maine | 23005 | 2942 | 70 |
707441 | 707441 | 2020-11-07 | Cumberland | Maine | 23005 | 2921 | 70 |
704198 | 704198 | 2020-11-06 | Cumberland | Maine | 23005 | 2872 | 70 |
700956 | 700956 | 2020-11-05 | Cumberland | Maine | 23005 | 2814 | 70 |
697712 | 697712 | 2020-11-04 | Cumberland | Maine | 23005 | 2768 | 70 |
694469 | 694469 | 2020-11-03 | Cumberland | Maine | 23005 | 2706 | 70 |
691227 | 691227 | 2020-11-02 | Cumberland | Maine | 23005 | 2660 | 70 |
687982 | 687982 | 2020-11-01 | Cumberland | Maine | 23005 | 2638 | 70 |
684738 | 684738 | 2020-10-31 | Cumberland | Maine | 23005 | 2621 | 70 |
681495 | 681495 | 2020-10-30 | Cumberland | Maine | 23005 | 2589 | 70 |
678251 | 678251 | 2020-10-29 | Cumberland | Maine | 23005 | 2545 | 70 |
675009 | 675009 | 2020-10-28 | Cumberland | Maine | 23005 | 2523 | 70 |
671766 | 671766 | 2020-10-27 | Cumberland | Maine | 23005 | 2507 | 70 |
668524 | 668524 | 2020-10-26 | Cumberland | Maine | 23005 | 2494 | 70 |
665280 | 665280 | 2020-10-25 | Cumberland | Maine | 23005 | 2481 | 70 |
662035 | 662035 | 2020-10-24 | Cumberland | Maine | 23005 | 2463 | 70 |
658791 | 658791 | 2020-10-23 | Cumberland | Maine | 23005 | 2445 | 70 |
655546 | 655546 | 2020-10-22 | Cumberland | Maine | 23005 | 2436 | 70 |
652301 | 652301 | 2020-10-21 | Cumberland | Maine | 23005 | 2431 | 70 |
649056 | 649056 | 2020-10-20 | Cumberland | Maine | 23005 | 2427 | 70 |
645812 | 645812 | 2020-10-19 | Cumberland | Maine | 23005 | 2427 | 70 |
642565 | 642565 | 2020-10-18 | Cumberland | Maine | 23005 | 2425 | 70 |
639318 | 639318 | 2020-10-17 | Cumberland | Maine | 23005 | 2421 | 70 |
636072 | 636072 | 2020-10-16 | Cumberland | Maine | 23005 | 2403 | 70 |
632826 | 632826 | 2020-10-15 | Cumberland | Maine | 23005 | 2399 | 70 |
629582 | 629582 | 2020-10-14 | Cumberland | Maine | 23005 | 2396 | 70 |
626338 | 626338 | 2020-10-13 | Cumberland | Maine | 23005 | 2392 | 70 |
623096 | 623096 | 2020-10-12 | Cumberland | Maine | 23005 | 2387 | 70 |
619852 | 619852 | 2020-10-11 | Cumberland | Maine | 23005 | 2386 | 70 |
616610 | 616610 | 2020-10-10 | Cumberland | Maine | 23005 | 2383 | 70 |
613369 | 613369 | 2020-10-09 | Cumberland | Maine | 23005 | 2377 | 70 |
610127 | 610127 | 2020-10-08 | Cumberland | Maine | 23005 | 2374 | 70 |
606885 | 606885 | 2020-10-07 | Cumberland | Maine | 23005 | 2361 | 70 |
603643 | 603643 | 2020-10-06 | Cumberland | Maine | 23005 | 2361 | 70 |
600400 | 600400 | 2020-10-05 | Cumberland | Maine | 23005 | 2357 | 70 |
597158 | 597158 | 2020-10-04 | Cumberland | Maine | 23005 | 2350 | 70 |
593916 | 593916 | 2020-10-03 | Cumberland | Maine | 23005 | 2344 | 70 |
590675 | 590675 | 2020-10-02 | Cumberland | Maine | 23005 | 2340 | 70 |
587434 | 587434 | 2020-10-01 | Cumberland | Maine | 23005 | 2333 | 70 |
584194 | 584194 | 2020-09-30 | Cumberland | Maine | 23005 | 2332 | 70 |
580954 | 580954 | 2020-09-29 | Cumberland | Maine | 23005 | 2316 | 70 |
577713 | 577713 | 2020-09-28 | Cumberland | Maine | 23005 | 2308 | 70 |
574471 | 574471 | 2020-09-27 | Cumberland | Maine | 23005 | 2307 | 70 |
571228 | 571228 | 2020-09-26 | Cumberland | Maine | 23005 | 2306 | 70 |
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);