ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1042367 | 1042367 | 2021-02-18 | Albany | New York | 36001 | 20184 | 324 |
1042368 | 1042368 | 2021-02-18 | Allegany | New York | 36003 | 2813 | 81 |
1042369 | 1042369 | 2021-02-18 | Broome | New York | 36007 | 13967 | 325 |
1042370 | 1042370 | 2021-02-18 | Cattaraugus | New York | 36009 | 4228 | 75 |
1042371 | 1042371 | 2021-02-18 | Cayuga | New York | 36011 | 5207 | 87 |
1042372 | 1042372 | 2021-02-18 | Chautauqua | New York | 36013 | 7122 | 119 |
1042373 | 1042373 | 2021-02-18 | Chemung | New York | 36015 | 6329 | 129 |
1042374 | 1042374 | 2021-02-18 | Chenango | New York | 36017 | 2338 | 67 |
1042375 | 1042375 | 2021-02-18 | Clinton | New York | 36019 | 3297 | 23 |
1042376 | 1042376 | 2021-02-18 | Columbia | New York | 36021 | 3284 | 92 |
1042377 | 1042377 | 2021-02-18 | Cortland | New York | 36023 | 3053 | 60 |
1042378 | 1042378 | 2021-02-18 | Delaware | New York | 36025 | 1411 | 32 |
1042379 | 1042379 | 2021-02-18 | Dutchess | New York | 36027 | 21222 | 400 |
1042380 | 1042380 | 2021-02-18 | Erie | New York | 36029 | 62732 | 1562 |
1042381 | 1042381 | 2021-02-18 | Essex | New York | 36031 | 1270 | 26 |
1042382 | 1042382 | 2021-02-18 | Franklin | New York | 36033 | 1857 | 12 |
1042383 | 1042383 | 2021-02-18 | Fulton | New York | 36035 | 3107 | 80 |
1042384 | 1042384 | 2021-02-18 | Genesee | New York | 36037 | 4241 | 118 |
1042385 | 1042385 | 2021-02-18 | Greene | New York | 36039 | 2555 | 68 |
1042386 | 1042386 | 2021-02-18 | Hamilton | New York | 36041 | 275 | 2 |
1042387 | 1042387 | 2021-02-18 | Herkimer | New York | 36043 | 4476 | 104 |
1042388 | 1042388 | 2021-02-18 | Jefferson | New York | 36045 | 4545 | 61 |
1042389 | 1042389 | 2021-02-18 | Lewis | New York | 36049 | 1968 | 29 |
1042390 | 1042390 | 2021-02-18 | Livingston | New York | 36051 | 3402 | 53 |
1042391 | 1042391 | 2021-02-18 | Madison | New York | 36053 | 3735 | 82 |
1042392 | 1042392 | 2021-02-18 | Monroe | New York | 36055 | 51135 | 964 |
1042393 | 1042393 | 2021-02-18 | Montgomery | New York | 36057 | 3029 | 100 |
1042394 | 1042394 | 2021-02-18 | Nassau | New York | 36059 | 141738 | 2846 |
1042395 | 1042395 | 2021-02-18 | New York City | New York | 684864 | 28590 | |
1042396 | 1042396 | 2021-02-18 | Niagara | New York | 36063 | 14892 | 300 |
1042397 | 1042397 | 2021-02-18 | Oneida | New York | 36065 | 19283 | 466 |
1042398 | 1042398 | 2021-02-18 | Onondaga | New York | 36067 | 31718 | 612 |
1042399 | 1042399 | 2021-02-18 | Ontario | New York | 36069 | 5582 | 88 |
1042400 | 1042400 | 2021-02-18 | Orange | New York | 36071 | 35225 | 622 |
1042401 | 1042401 | 2021-02-18 | Orleans | New York | 36073 | 2381 | 80 |
1042402 | 1042402 | 2021-02-18 | Oswego | New York | 36075 | 5837 | 89 |
1042403 | 1042403 | 2021-02-18 | Otsego | New York | 36077 | 2216 | 42 |
1042404 | 1042404 | 2021-02-18 | Putnam | New York | 36079 | 8024 | 85 |
1042405 | 1042405 | 2021-02-18 | Rensselaer | New York | 36083 | 8690 | 126 |
1042406 | 1042406 | 2021-02-18 | Rockland | New York | 36087 | 37200 | 675 |
1042407 | 1042407 | 2021-02-18 | Saratoga | New York | 36091 | 11484 | 141 |
1042408 | 1042408 | 2021-02-18 | Schenectady | New York | 36093 | 10554 | 174 |
1042409 | 1042409 | 2021-02-18 | Schoharie | New York | 36095 | 1143 | 11 |
1042410 | 1042410 | 2021-02-18 | Schuyler | New York | 36097 | 846 | 11 |
1042411 | 1042411 | 2021-02-18 | Seneca | New York | 36099 | 1518 | 52 |
1042412 | 1042412 | 2021-02-18 | St. Lawrence | New York | 36089 | 5088 | 75 |
1042413 | 1042413 | 2021-02-18 | Steuben | New York | 36101 | 5383 | 137 |
1042414 | 1042414 | 2021-02-18 | Suffolk | New York | 36103 | 156200 | 3000 |
1042415 | 1042415 | 2021-02-18 | Sullivan | New York | 36105 | 4553 | 58 |
1042416 | 1042416 | 2021-02-18 | Tioga | New York | 36107 | 2705 | 56 |
1042417 | 1042417 | 2021-02-18 | Tompkins | New York | 36109 | 3350 | 42 |
1042418 | 1042418 | 2021-02-18 | Ulster | New York | 36111 | 9604 | 224 |
1042419 | 1042419 | 2021-02-18 | Warren | New York | 36113 | 2734 | 53 |
1042420 | 1042420 | 2021-02-18 | Washington | New York | 36115 | 2202 | 50 |
1042421 | 1042421 | 2021-02-18 | Wayne | New York | 36117 | 4344 | 62 |
1042422 | 1042422 | 2021-02-18 | Westchester | New York | 36119 | 103018 | 2041 |
1042423 | 1042423 | 2021-02-18 | Wyoming | New York | 36121 | 2719 | 48 |
1042424 | 1042424 | 2021-02-18 | Yates | New York | 36123 | 1004 | 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);