ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 298 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 10
- Orleans 5
- Steuben 3
- Warren 3
- Greene 2
- Genesee 1
- Hamilton 1
- Herkimer 1
- Livingston 1
- Rensselaer 1
- Wayne 1
state 1
- New York · 19 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1217712 | 1217712 | 2021-04-13 | Hamilton | New York | 36041 | 298 | 2 |
669204 | 669204 | 2020-10-26 | Livingston | New York | 36051 | 298 | 6 |
520135 | 520135 | 2020-09-10 | Wayne | New York | 36117 | 298 | 3 |
497461 | 497461 | 2020-09-03 | Genesee | New York | 36037 | 298 | 6 |
490997 | 490997 | 2020-09-01 | Herkimer | New York | 36043 | 298 | 10 |
442539 | 442539 | 2020-08-17 | Greene | New York | 36039 | 298 | 13 |
439312 | 439312 | 2020-08-16 | Greene | New York | 36039 | 298 | 13 |
426426 | 426426 | 2020-08-12 | Orleans | New York | 36073 | 298 | 55 |
423203 | 423203 | 2020-08-11 | Orleans | New York | 36073 | 298 | 55 |
419980 | 419980 | 2020-08-10 | Orleans | New York | 36073 | 298 | 55 |
419992 | 419992 | 2020-08-10 | Steuben | New York | 36101 | 298 | 39 |
416760 | 416760 | 2020-08-09 | Orleans | New York | 36073 | 298 | 55 |
416772 | 416772 | 2020-08-09 | Steuben | New York | 36101 | 298 | 39 |
413539 | 413539 | 2020-08-08 | Orleans | New York | 36073 | 298 | 55 |
413551 | 413551 | 2020-08-08 | Steuben | New York | 36101 | 298 | 39 |
384598 | 384598 | 2020-07-30 | Warren | New York | 36113 | 298 | 31 |
381380 | 381380 | 2020-07-29 | Warren | New York | 36113 | 298 | 31 |
378163 | 378163 | 2020-07-28 | Warren | New York | 36113 | 298 | 31 |
105571 | 105571 | 2020-05-01 | Rensselaer | New York | 36083 | 298 | 20 |
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);