ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 305 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 13
county 13
- Greene 4
- Hamilton 4
- Fulton 3
- Orleans 2
- Albany 1
- Broome 1
- Chautauqua 1
- Chemung 1
- Franklin 1
- Herkimer 1
- Livingston 1
- Washington 1
- Wayne 1
state 1
- New York · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1311873 | 1311873 | 2021-05-12 | Hamilton | New York | 36041 | 305 | 2 |
1308626 | 1308626 | 2021-05-11 | Hamilton | New York | 36041 | 305 | 2 |
1305380 | 1305380 | 2021-05-10 | Hamilton | New York | 36041 | 305 | 2 |
1302134 | 1302134 | 2021-05-09 | Hamilton | New York | 36041 | 305 | 2 |
798973 | 798973 | 2020-12-05 | Franklin | New York | 36033 | 305 | 8 |
675689 | 675689 | 2020-10-28 | Livingston | New York | 36051 | 305 | 6 |
591384 | 591384 | 2020-10-02 | Washington | New York | 36115 | 305 | 14 |
545977 | 545977 | 2020-09-18 | Chemung | New York | 36015 | 305 | 3 |
542788 | 542788 | 2020-09-17 | Wayne | New York | 36117 | 305 | 3 |
497464 | 497464 | 2020-09-03 | Herkimer | New York | 36043 | 305 | 10 |
474844 | 474844 | 2020-08-27 | Orleans | New York | 36073 | 305 | 55 |
471610 | 471610 | 2020-08-26 | Orleans | New York | 36073 | 305 | 55 |
468349 | 468349 | 2020-08-25 | Chautauqua | New York | 36013 | 305 | 4 |
468362 | 468362 | 2020-08-25 | Greene | New York | 36039 | 305 | 13 |
465134 | 465134 | 2020-08-24 | Greene | New York | 36039 | 305 | 13 |
461905 | 461905 | 2020-08-23 | Greene | New York | 36039 | 305 | 13 |
458677 | 458677 | 2020-08-22 | Greene | New York | 36039 | 305 | 13 |
452219 | 452219 | 2020-08-20 | Fulton | New York | 36035 | 305 | 28 |
448991 | 448991 | 2020-08-19 | Fulton | New York | 36035 | 305 | 28 |
445763 | 445763 | 2020-08-18 | Fulton | New York | 36035 | 305 | 28 |
108402 | 108402 | 2020-05-02 | Broome | New York | 36007 | 305 | 18 |
34580 | 34580 | 2020-04-05 | Albany | New York | 36001 | 305 | 8 |
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);