ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-03-23" 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 |
---|---|---|---|---|---|---|---|
1149490 | 1149490 | 2021-03-23 | Albany | New York | 36001 | 22078 | 339 |
1149491 | 1149491 | 2021-03-23 | Allegany | New York | 36003 | 2988 | 82 |
1149492 | 1149492 | 2021-03-23 | Broome | New York | 36007 | 16211 | 342 |
1149493 | 1149493 | 2021-03-23 | Cattaraugus | New York | 36009 | 4669 | 79 |
1149494 | 1149494 | 2021-03-23 | Cayuga | New York | 36011 | 5538 | 90 |
1149495 | 1149495 | 2021-03-23 | Chautauqua | New York | 36013 | 7742 | 130 |
1149496 | 1149496 | 2021-03-23 | Chemung | New York | 36015 | 6663 | 131 |
1149497 | 1149497 | 2021-03-23 | Chenango | New York | 36017 | 2671 | 72 |
1149498 | 1149498 | 2021-03-23 | Clinton | New York | 36019 | 4031 | 30 |
1149499 | 1149499 | 2021-03-23 | Columbia | New York | 36021 | 3606 | 97 |
1149500 | 1149500 | 2021-03-23 | Cortland | New York | 36023 | 3346 | 60 |
1149501 | 1149501 | 2021-03-23 | Delaware | New York | 36025 | 1805 | 34 |
1149502 | 1149502 | 2021-03-23 | Dutchess | New York | 36027 | 24977 | 421 |
1149503 | 1149503 | 2021-03-23 | Erie | New York | 36029 | 70826 | 1640 |
1149504 | 1149504 | 2021-03-23 | Essex | New York | 36031 | 1422 | 26 |
1149505 | 1149505 | 2021-03-23 | Franklin | New York | 36033 | 2258 | 12 |
1149506 | 1149506 | 2021-03-23 | Fulton | New York | 36035 | 3653 | 85 |
1149507 | 1149507 | 2021-03-23 | Genesee | New York | 36037 | 4680 | 120 |
1149508 | 1149508 | 2021-03-23 | Greene | New York | 36039 | 2865 | 73 |
1149509 | 1149509 | 2021-03-23 | Hamilton | New York | 36041 | 291 | 2 |
1149510 | 1149510 | 2021-03-23 | Herkimer | New York | 36043 | 4715 | 107 |
1149511 | 1149511 | 2021-03-23 | Jefferson | New York | 36045 | 5121 | 63 |
1149512 | 1149512 | 2021-03-23 | Lewis | New York | 36049 | 2225 | 33 |
1149513 | 1149513 | 2021-03-23 | Livingston | New York | 36051 | 3734 | 58 |
1149514 | 1149514 | 2021-03-23 | Madison | New York | 36053 | 4001 | 85 |
1149515 | 1149515 | 2021-03-23 | Monroe | New York | 36055 | 55336 | 1013 |
1149516 | 1149516 | 2021-03-23 | Montgomery | New York | 36057 | 3434 | 109 |
1149517 | 1149517 | 2021-03-23 | Nassau | New York | 36059 | 162481 | 3021 |
1149518 | 1149518 | 2021-03-23 | New York City | New York | 799865 | 30564 | |
1149519 | 1149519 | 2021-03-23 | Niagara | New York | 36063 | 16086 | 326 |
1149520 | 1149520 | 2021-03-23 | Oneida | New York | 36065 | 20527 | 490 |
1149521 | 1149521 | 2021-03-23 | Onondaga | New York | 36067 | 33689 | 648 |
1149522 | 1149522 | 2021-03-23 | Ontario | New York | 36069 | 6171 | 90 |
1149523 | 1149523 | 2021-03-23 | Orange | New York | 36071 | 41385 | 664 |
1149524 | 1149524 | 2021-03-23 | Orleans | New York | 36073 | 2549 | 82 |
1149525 | 1149525 | 2021-03-23 | Oswego | New York | 36075 | 6441 | 89 |
1149526 | 1149526 | 2021-03-23 | Otsego | New York | 36077 | 2762 | 44 |
1149527 | 1149527 | 2021-03-23 | Putnam | New York | 36079 | 9146 | 89 |
1149528 | 1149528 | 2021-03-23 | Rensselaer | New York | 36083 | 9705 | 133 |
1149529 | 1149529 | 2021-03-23 | Rockland | New York | 36087 | 42250 | 711 |
1149530 | 1149530 | 2021-03-23 | Saratoga | New York | 36091 | 12924 | 154 |
1149531 | 1149531 | 2021-03-23 | Schenectady | New York | 36093 | 11470 | 186 |
1149532 | 1149532 | 2021-03-23 | Schoharie | New York | 36095 | 1368 | 13 |
1149533 | 1149533 | 2021-03-23 | Schuyler | New York | 36097 | 905 | 12 |
1149534 | 1149534 | 2021-03-23 | Seneca | New York | 36099 | 1751 | 56 |
1149535 | 1149535 | 2021-03-23 | St. Lawrence | New York | 36089 | 5854 | 93 |
1149536 | 1149536 | 2021-03-23 | Steuben | New York | 36101 | 5772 | 140 |
1149537 | 1149537 | 2021-03-23 | Suffolk | New York | 36103 | 176669 | 3209 |
1149538 | 1149538 | 2021-03-23 | Sullivan | New York | 36105 | 5268 | 64 |
1149539 | 1149539 | 2021-03-23 | Tioga | New York | 36107 | 3031 | 56 |
1149540 | 1149540 | 2021-03-23 | Tompkins | New York | 36109 | 3742 | 48 |
1149541 | 1149541 | 2021-03-23 | Ulster | New York | 36111 | 11354 | 236 |
1149542 | 1149542 | 2021-03-23 | Warren | New York | 36113 | 3068 | 55 |
1149543 | 1149543 | 2021-03-23 | Washington | New York | 36115 | 2557 | 54 |
1149544 | 1149544 | 2021-03-23 | Wayne | New York | 36117 | 4717 | 66 |
1149545 | 1149545 | 2021-03-23 | Westchester | New York | 36119 | 116288 | 2176 |
1149546 | 1149546 | 2021-03-23 | Wyoming | New York | 36121 | 3014 | 49 |
1149547 | 1149547 | 2021-03-23 | Yates | New York | 36123 | 1040 | 26 |
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);