ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 290 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
county 10
state 1
- New York · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1143015 | 1143015 | 2021-03-21 | Hamilton | New York | 36041 | 290 | 2 |
1139768 | 1139768 | 2021-03-20 | Hamilton | New York | 36041 | 290 | 2 |
1136522 | 1136522 | 2021-03-19 | Hamilton | New York | 36041 | 290 | 2 |
1133276 | 1133276 | 2021-03-18 | Hamilton | New York | 36041 | 290 | 2 |
1130028 | 1130028 | 2021-03-17 | Hamilton | New York | 36041 | 290 | 2 |
1126781 | 1126781 | 2021-03-16 | Hamilton | New York | 36041 | 290 | 2 |
1123535 | 1123535 | 2021-03-15 | Hamilton | New York | 36041 | 290 | 2 |
630246 | 630246 | 2020-10-14 | Chenango | New York | 36017 | 290 | 6 |
591334 | 591334 | 2020-10-02 | Cattaraugus | New York | 36009 | 290 | 9 |
468364 | 468364 | 2020-08-25 | Herkimer | New York | 36043 | 290 | 10 |
465133 | 465133 | 2020-08-24 | Genesee | New York | 36037 | 290 | 6 |
461904 | 461904 | 2020-08-23 | Genesee | New York | 36037 | 290 | 6 |
458676 | 458676 | 2020-08-22 | Genesee | New York | 36037 | 290 | 6 |
455448 | 455448 | 2020-08-21 | Genesee | New York | 36037 | 290 | 6 |
452220 | 452220 | 2020-08-20 | Genesee | New York | 36037 | 290 | 6 |
407083 | 407083 | 2020-08-06 | Greene | New York | 36039 | 290 | 13 |
391026 | 391026 | 2020-08-01 | Steuben | New York | 36101 | 290 | 29 |
387809 | 387809 | 2020-07-31 | Steuben | New York | 36101 | 290 | 19 |
384592 | 384592 | 2020-07-30 | Steuben | New York | 36101 | 290 | 19 |
381374 | 381374 | 2020-07-29 | Steuben | New York | 36101 | 290 | 19 |
378145 | 378145 | 2020-07-28 | Orleans | New York | 36073 | 290 | 41 |
374929 | 374929 | 2020-07-27 | Orleans | New York | 36073 | 290 | 41 |
371717 | 371717 | 2020-07-26 | Orleans | New York | 36073 | 290 | 41 |
362108 | 362108 | 2020-07-23 | Warren | New York | 36113 | 290 | 31 |
317366 | 317366 | 2020-07-09 | Ontario | New York | 36069 | 290 | 25 |
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);