ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where deaths = 216 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 10
- Steuben 4
- Schenectady 2
- Albany 1
- Cattaraugus 1
- Chemung 1
- Erie 1
- Oneida 1
- Onondaga 1
- Rensselaer 1
- Saratoga 1
state 1
- New York · 14 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2280109 | 2280109 | 2022-03-06 | Cattaraugus | New York | 36009 | 15225 | 216 |
2159779 | 2159779 | 2022-01-28 | Chemung | New York | 36015 | 19928 | 216 |
2078500 | 2078500 | 2022-01-03 | Rensselaer | New York | 36083 | 21915 | 216 |
2075257 | 2075257 | 2022-01-02 | Steuben | New York | 36101 | 14875 | 216 |
2072006 | 2072006 | 2022-01-01 | Steuben | New York | 36101 | 14793 | 216 |
2068755 | 2068755 | 2021-12-31 | Steuben | New York | 36101 | 14661 | 216 |
2065504 | 2065504 | 2021-12-30 | Steuben | New York | 36101 | 14558 | 216 |
1919232 | 1919232 | 2021-11-15 | Saratoga | New York | 36091 | 22448 | 216 |
1747024 | 1747024 | 2021-09-23 | Schenectady | New York | 36093 | 15325 | 216 |
1743775 | 1743775 | 2021-09-22 | Schenectady | New York | 36093 | 15293 | 216 |
899567 | 899567 | 2021-01-05 | Albany | New York | 36001 | 12852 | 216 |
850918 | 850918 | 2020-12-21 | Oneida | New York | 36065 | 9571 | 216 |
782765 | 782765 | 2020-11-30 | Onondaga | New York | 36067 | 10804 | 216 |
96984 | 96984 | 2020-04-28 | Erie | New York | 36029 | 3089 | 216 |
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);