ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-08-30" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Albany 1
- Allegany 1
- Broome 1
- Cattaraugus 1
- Cayuga 1
- Chautauqua 1
- Chemung 1
- Chenango 1
- Clinton 1
- Columbia 1
- Cortland 1
- Delaware 1
- Dutchess 1
- Erie 1
- Essex 1
- Franklin 1
- Fulton 1
- Genesee 1
- Greene 1
- Hamilton 1
- Herkimer 1
- Jefferson 1
- Lewis 1
- Livingston 1
- Madison 1
- Monroe 1
- Montgomery 1
- Nassau 1
- New York City 1
- Niagara 1
- …
state 1
- New York · 58 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
484511 | 484511 | 2020-08-30 | Albany | New York | 36001 | 2764 | 122 |
484512 | 484512 | 2020-08-30 | Allegany | New York | 36003 | 89 | 2 |
484513 | 484513 | 2020-08-30 | Broome | New York | 36007 | 1295 | 82 |
484514 | 484514 | 2020-08-30 | Cattaraugus | New York | 36009 | 201 | 6 |
484515 | 484515 | 2020-08-30 | Cayuga | New York | 36011 | 177 | 2 |
484516 | 484516 | 2020-08-30 | Chautauqua | New York | 36013 | 382 | 4 |
484517 | 484517 | 2020-08-30 | Chemung | New York | 36015 | 200 | 2 |
484518 | 484518 | 2020-08-30 | Chenango | New York | 36017 | 227 | 6 |
484519 | 484519 | 2020-08-30 | Clinton | New York | 36019 | 150 | 5 |
484520 | 484520 | 2020-08-30 | Columbia | New York | 36021 | 569 | 47 |
484521 | 484521 | 2020-08-30 | Cortland | New York | 36023 | 99 | 1 |
484522 | 484522 | 2020-08-30 | Delaware | New York | 36025 | 115 | 4 |
484523 | 484523 | 2020-08-30 | Dutchess | New York | 36027 | 4852 | 153 |
484524 | 484524 | 2020-08-30 | Erie | New York | 36029 | 9807 | 606 |
484525 | 484525 | 2020-08-30 | Essex | New York | 36031 | 136 | 6 |
484526 | 484526 | 2020-08-30 | Franklin | New York | 36033 | 58 | 1 |
484527 | 484527 | 2020-08-30 | Fulton | New York | 36035 | 311 | 28 |
484528 | 484528 | 2020-08-30 | Genesee | New York | 36037 | 294 | 6 |
484529 | 484529 | 2020-08-30 | Greene | New York | 36039 | 307 | 13 |
484530 | 484530 | 2020-08-30 | Hamilton | New York | 36041 | 14 | 1 |
484531 | 484531 | 2020-08-30 | Herkimer | New York | 36043 | 297 | 10 |
484532 | 484532 | 2020-08-30 | Jefferson | New York | 36045 | 150 | 1 |
484533 | 484533 | 2020-08-30 | Lewis | New York | 36049 | 49 | 5 |
484534 | 484534 | 2020-08-30 | Livingston | New York | 36051 | 182 | 6 |
484535 | 484535 | 2020-08-30 | Madison | New York | 36053 | 461 | 9 |
484536 | 484536 | 2020-08-30 | Monroe | New York | 36055 | 5444 | 257 |
484537 | 484537 | 2020-08-30 | Montgomery | New York | 36057 | 202 | 8 |
484538 | 484538 | 2020-08-30 | Nassau | New York | 36059 | 44610 | 2198 |
484539 | 484539 | 2020-08-30 | New York City | New York | 238677 | 23689 | |
484540 | 484540 | 2020-08-30 | Niagara | New York | 36063 | 1612 | 89 |
484541 | 484541 | 2020-08-30 | Oneida | New York | 36065 | 2272 | 120 |
484542 | 484542 | 2020-08-30 | Onondaga | New York | 36067 | 3883 | 179 |
484543 | 484543 | 2020-08-30 | Ontario | New York | 36069 | 389 | 28 |
484544 | 484544 | 2020-08-30 | Orange | New York | 36071 | 11433 | 409 |
484545 | 484545 | 2020-08-30 | Orleans | New York | 36073 | 306 | 55 |
484546 | 484546 | 2020-08-30 | Oswego | New York | 36075 | 295 | 3 |
484547 | 484547 | 2020-08-30 | Otsego | New York | 36077 | 143 | 4 |
484548 | 484548 | 2020-08-30 | Putnam | New York | 36079 | 1500 | 63 |
484549 | 484549 | 2020-08-30 | Rensselaer | New York | 36083 | 833 | 41 |
484550 | 484550 | 2020-08-30 | Rockland | New York | 36087 | 14233 | 508 |
484551 | 484551 | 2020-08-30 | Saratoga | New York | 36091 | 842 | 15 |
484552 | 484552 | 2020-08-30 | Schenectady | New York | 36093 | 1260 | 43 |
484553 | 484553 | 2020-08-30 | Schoharie | New York | 36095 | 69 | 2 |
484554 | 484554 | 2020-08-30 | Schuyler | New York | 36097 | 26 | 0 |
484555 | 484555 | 2020-08-30 | Seneca | New York | 36099 | 100 | 1 |
484556 | 484556 | 2020-08-30 | St. Lawrence | New York | 36089 | 274 | 4 |
484557 | 484557 | 2020-08-30 | Steuben | New York | 36101 | 315 | 39 |
484558 | 484558 | 2020-08-30 | Suffolk | New York | 36103 | 44763 | 2002 |
484559 | 484559 | 2020-08-30 | Sullivan | New York | 36105 | 1521 | 37 |
484560 | 484560 | 2020-08-30 | Tioga | New York | 36107 | 208 | 21 |
484561 | 484561 | 2020-08-30 | Tompkins | New York | 36109 | 264 | 0 |
484562 | 484562 | 2020-08-30 | Ulster | New York | 36111 | 2168 | 82 |
484563 | 484563 | 2020-08-30 | Warren | New York | 36113 | 321 | 30 |
484564 | 484564 | 2020-08-30 | Washington | New York | 36115 | 267 | 14 |
484565 | 484565 | 2020-08-30 | Wayne | New York | 36117 | 280 | 3 |
484566 | 484566 | 2020-08-30 | Westchester | New York | 36119 | 36948 | 1451 |
484567 | 484567 | 2020-08-30 | Wyoming | New York | 36121 | 126 | 5 |
484568 | 484568 | 2020-08-30 | Yates | New York | 36123 | 61 | 6 |
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);