ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 90 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 7
- Penobscot 15
- Aroostook 6
- Oxford 6
- Androscoggin 4
- Cumberland 4
- Kennebec 4
- Somerset 2
state 1
- Maine · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2227433 | 2227433 | 2022-02-18 | Somerset | Maine | 23025 | 8403 | 90 |
2224182 | 2224182 | 2022-02-17 | Somerset | Maine | 23025 | 8263 | 90 |
2016047 | 2016047 | 2021-12-15 | Aroostook | Maine | 23003 | 6493 | 90 |
2016054 | 2016054 | 2021-12-15 | Oxford | Maine | 23017 | 7046 | 90 |
2012796 | 2012796 | 2021-12-14 | Aroostook | Maine | 23003 | 6416 | 90 |
2012803 | 2012803 | 2021-12-14 | Oxford | Maine | 23017 | 6913 | 90 |
2009545 | 2009545 | 2021-12-13 | Aroostook | Maine | 23003 | 6287 | 90 |
2009552 | 2009552 | 2021-12-13 | Oxford | Maine | 23017 | 6864 | 90 |
2006294 | 2006294 | 2021-12-12 | Aroostook | Maine | 23003 | 6286 | 90 |
2006301 | 2006301 | 2021-12-12 | Oxford | Maine | 23017 | 6864 | 90 |
2003043 | 2003043 | 2021-12-11 | Aroostook | Maine | 23003 | 6282 | 90 |
2003050 | 2003050 | 2021-12-11 | Oxford | Maine | 23017 | 6864 | 90 |
1999793 | 1999793 | 2021-12-10 | Aroostook | Maine | 23003 | 6201 | 90 |
1999800 | 1999800 | 2021-12-10 | Oxford | Maine | 23017 | 6785 | 90 |
1749577 | 1749577 | 2021-09-24 | Kennebec | Maine | 23011 | 8035 | 90 |
1746327 | 1746327 | 2021-09-23 | Kennebec | Maine | 23011 | 7979 | 90 |
1743078 | 1743078 | 2021-09-22 | Kennebec | Maine | 23011 | 7946 | 90 |
1739829 | 1739829 | 2021-09-21 | Kennebec | Maine | 23011 | 7880 | 90 |
1736575 | 1736575 | 2021-09-20 | Androscoggin | Maine | 23001 | 9288 | 90 |
1733325 | 1733325 | 2021-09-19 | Androscoggin | Maine | 23001 | 9287 | 90 |
1730075 | 1730075 | 2021-09-18 | Androscoggin | Maine | 23001 | 9286 | 90 |
1726825 | 1726825 | 2021-09-17 | Androscoggin | Maine | 23001 | 9256 | 90 |
1320943 | 1320943 | 2021-05-15 | Penobscot | Maine | 23019 | 5789 | 90 |
1317696 | 1317696 | 2021-05-14 | Penobscot | Maine | 23019 | 5768 | 90 |
1314449 | 1314449 | 2021-05-13 | Penobscot | Maine | 23019 | 5723 | 90 |
1311202 | 1311202 | 2021-05-12 | Penobscot | Maine | 23019 | 5700 | 90 |
1307956 | 1307956 | 2021-05-11 | Penobscot | Maine | 23019 | 5674 | 90 |
1304710 | 1304710 | 2021-05-10 | Penobscot | Maine | 23019 | 5643 | 90 |
1301463 | 1301463 | 2021-05-09 | Penobscot | Maine | 23019 | 5613 | 90 |
1298216 | 1298216 | 2021-05-08 | Penobscot | Maine | 23019 | 5588 | 90 |
1294970 | 1294970 | 2021-05-07 | Penobscot | Maine | 23019 | 5547 | 90 |
1291724 | 1291724 | 2021-05-06 | Penobscot | Maine | 23019 | 5522 | 90 |
1288478 | 1288478 | 2021-05-05 | Penobscot | Maine | 23019 | 5496 | 90 |
1285232 | 1285232 | 2021-05-04 | Penobscot | Maine | 23019 | 5481 | 90 |
1281985 | 1281985 | 2021-05-03 | Penobscot | Maine | 23019 | 5451 | 90 |
1278738 | 1278738 | 2021-05-02 | Penobscot | Maine | 23019 | 5421 | 90 |
1275491 | 1275491 | 2021-05-01 | Penobscot | Maine | 23019 | 5408 | 90 |
866455 | 866455 | 2020-12-26 | Cumberland | Maine | 23005 | 6472 | 90 |
863210 | 863210 | 2020-12-25 | Cumberland | Maine | 23005 | 6472 | 90 |
859965 | 859965 | 2020-12-24 | Cumberland | Maine | 23005 | 6313 | 90 |
856720 | 856720 | 2020-12-23 | Cumberland | Maine | 23005 | 6110 | 90 |
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);