ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where "date" is on date 2021-10-08 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 17
county 17
- Androscoggin 1
- Aroostook 1
- Cumberland 1
- Franklin 1
- Hancock 1
- Kennebec 1
- Knox 1
- Lincoln 1
- Oxford 1
- Penobscot 1
- Piscataquis 1
- Sagadahoc 1
- Somerset 1
- Unknown 1
- Waldo 1
- Washington 1
- York 1
state 1
- Maine · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1795057 | 1795057 | 2021-10-08 | Androscoggin | Maine | 23001 | 10026 | 95 |
1795058 | 1795058 | 2021-10-08 | Aroostook | Maine | 23003 | 3492 | 78 |
1795059 | 1795059 | 2021-10-08 | Cumberland | Maine | 23005 | 20764 | 221 |
1795060 | 1795060 | 2021-10-08 | Franklin | Maine | 23007 | 1974 | 19 |
1795061 | 1795061 | 2021-10-08 | Hancock | Maine | 23009 | 2450 | 47 |
1795062 | 1795062 | 2021-10-08 | Kennebec | Maine | 23011 | 8992 | 97 |
1795063 | 1795063 | 2021-10-08 | Knox | Maine | 23013 | 1717 | 12 |
1795064 | 1795064 | 2021-10-08 | Lincoln | Maine | 23015 | 1662 | 4 |
1795065 | 1795065 | 2021-10-08 | Oxford | Maine | 23017 | 4625 | 74 |
1795066 | 1795066 | 2021-10-08 | Penobscot | Maine | 23019 | 11195 | 163 |
1795067 | 1795067 | 2021-10-08 | Piscataquis | Maine | 23021 | 1210 | 10 |
1795068 | 1795068 | 2021-10-08 | Sagadahoc | Maine | 23023 | 1832 | 12 |
1795069 | 1795069 | 2021-10-08 | Somerset | Maine | 23025 | 3763 | 40 |
1795070 | 1795070 | 2021-10-08 | Unknown | Maine | 1 | 0 | |
1795071 | 1795071 | 2021-10-08 | Waldo | Maine | 23027 | 2156 | 31 |
1795072 | 1795072 | 2021-10-08 | Washington | Maine | 23029 | 1587 | 20 |
1795073 | 1795073 | 2021-10-08 | York | Maine | 23031 | 16902 | 147 |
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);