ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 117 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 5
- Aroostook 5
- York 5
- Androscoggin 4
- Cumberland 1
- Penobscot 1
state 1
- Maine · 16 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2194899 | 2194899 | 2022-02-08 | Aroostook | Maine | 23003 | 8695 | 117 |
2191645 | 2191645 | 2022-02-07 | Aroostook | Maine | 23003 | 8615 | 117 |
2188392 | 2188392 | 2022-02-06 | Aroostook | Maine | 23003 | 8615 | 117 |
2185139 | 2185139 | 2022-02-05 | Aroostook | Maine | 23003 | 8615 | 117 |
2181887 | 2181887 | 2022-02-04 | Aroostook | Maine | 23003 | 8561 | 117 |
1941282 | 1941282 | 2021-11-22 | Androscoggin | Maine | 23001 | 12436 | 117 |
1938032 | 1938032 | 2021-11-21 | Androscoggin | Maine | 23001 | 12436 | 117 |
1934782 | 1934782 | 2021-11-20 | Androscoggin | Maine | 23001 | 12436 | 117 |
1931531 | 1931531 | 2021-11-19 | Androscoggin | Maine | 23001 | 12298 | 117 |
1700850 | 1700850 | 2021-09-09 | Penobscot | Maine | 23019 | 8229 | 117 |
1080672 | 1080672 | 2021-03-02 | York | Maine | 23031 | 9567 | 117 |
1077426 | 1077426 | 2021-03-01 | York | Maine | 23031 | 9534 | 117 |
1074180 | 1074180 | 2021-02-28 | York | Maine | 23031 | 9521 | 117 |
1070934 | 1070934 | 2021-02-27 | York | Maine | 23031 | 9501 | 117 |
1067689 | 1067689 | 2021-02-26 | York | Maine | 23031 | 9464 | 117 |
928116 | 928116 | 2021-01-14 | Cumberland | Maine | 23005 | 9436 | 117 |
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);