ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where deaths = 64 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
state 1
- Maine · 18 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2077805 | 2077805 | 2022-01-03 | Hancock | Maine | 23009 | 4456 | 64 |
2074554 | 2074554 | 2022-01-02 | Hancock | Maine | 23009 | 4456 | 64 |
2071303 | 2071303 | 2022-01-01 | Hancock | Maine | 23009 | 4456 | 64 |
2068052 | 2068052 | 2021-12-31 | Hancock | Maine | 23009 | 4456 | 64 |
2064801 | 2064801 | 2021-12-30 | Hancock | Maine | 23009 | 4443 | 64 |
2061551 | 2061551 | 2021-12-29 | Hancock | Maine | 23009 | 4373 | 64 |
1704092 | 1704092 | 2021-09-10 | Aroostook | Maine | 23003 | 2755 | 64 |
1346918 | 1346918 | 2021-05-23 | Oxford | Maine | 23017 | 3521 | 64 |
1343670 | 1343670 | 2021-05-22 | Oxford | Maine | 23017 | 3515 | 64 |
1340422 | 1340422 | 2021-05-21 | Oxford | Maine | 23017 | 3509 | 64 |
1337175 | 1337175 | 2021-05-20 | Oxford | Maine | 23017 | 3504 | 64 |
1333928 | 1333928 | 2021-05-19 | Oxford | Maine | 23017 | 3494 | 64 |
1330681 | 1330681 | 2021-05-18 | Oxford | Maine | 23017 | 3489 | 64 |
1246264 | 1246264 | 2021-04-22 | Kennebec | Maine | 23011 | 5339 | 64 |
892431 | 892431 | 2021-01-03 | York | Maine | 23031 | 5443 | 64 |
889185 | 889185 | 2021-01-02 | York | Maine | 23031 | 5345 | 64 |
307199 | 307199 | 2020-07-06 | Cumberland | Maine | 23005 | 1810 | 64 |
304032 | 304032 | 2020-07-05 | Cumberland | Maine | 23005 | 1805 | 64 |
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);