ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-11-24" 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 |
---|---|---|---|---|---|---|---|
1948444 | 1948444 | 2021-11-24 | Albany | New York | 36001 | 33776 | 408 |
1948445 | 1948445 | 2021-11-24 | Allegany | New York | 36003 | 5820 | 118 |
1948446 | 1948446 | 2021-11-24 | Broome | New York | 36007 | 27729 | 431 |
1948447 | 1948447 | 2021-11-24 | Cattaraugus | New York | 36009 | 9667 | 152 |
1948448 | 1948448 | 2021-11-24 | Cayuga | New York | 36011 | 9550 | 112 |
1948449 | 1948449 | 2021-11-24 | Chautauqua | New York | 36013 | 14491 | 189 |
1948450 | 1948450 | 2021-11-24 | Chemung | New York | 36015 | 12548 | 172 |
1948451 | 1948451 | 2021-11-24 | Chenango | New York | 36017 | 5426 | 95 |
1948452 | 1948452 | 2021-11-24 | Clinton | New York | 36019 | 7853 | 45 |
1948453 | 1948453 | 2021-11-24 | Columbia | New York | 36021 | 5568 | 113 |
1948454 | 1948454 | 2021-11-24 | Cortland | New York | 36023 | 5999 | 88 |
1948455 | 1948455 | 2021-11-24 | Delaware | New York | 36025 | 4254 | 51 |
1948456 | 1948456 | 2021-11-24 | Dutchess | New York | 36027 | 37547 | 506 |
1948457 | 1948457 | 2021-11-24 | Erie | New York | 36029 | 121435 | 2026 |
1948458 | 1948458 | 2021-11-24 | Essex | New York | 36031 | 2915 | 37 |
1948459 | 1948459 | 2021-11-24 | Franklin | New York | 36033 | 5214 | 25 |
1948460 | 1948460 | 2021-11-24 | Fulton | New York | 36035 | 7639 | 109 |
1948461 | 1948461 | 2021-11-24 | Genesee | New York | 36037 | 8373 | 143 |
1948462 | 1948462 | 2021-11-24 | Greene | New York | 36039 | 4838 | 88 |
1948463 | 1948463 | 2021-11-24 | Hamilton | New York | 36041 | 508 | 3 |
1948464 | 1948464 | 2021-11-24 | Herkimer | New York | 36043 | 8085 | 141 |
1948465 | 1948465 | 2021-11-24 | Jefferson | New York | 36045 | 10998 | 105 |
1948466 | 1948466 | 2021-11-24 | Lewis | New York | 36049 | 4101 | 39 |
1948467 | 1948467 | 2021-11-24 | Livingston | New York | 36051 | 6973 | 74 |
1948468 | 1948468 | 2021-11-24 | Madison | New York | 36053 | 7179 | 108 |
1948469 | 1948469 | 2021-11-24 | Monroe | New York | 36055 | 95456 | 1243 |
1948470 | 1948470 | 2021-11-24 | Montgomery | New York | 36057 | 6997 | 159 |
1948471 | 1948471 | 2021-11-24 | Nassau | New York | 36059 | 223456 | 3324 |
1948472 | 1948472 | 2021-11-24 | New York City | New York | 1150184 | 34773 | |
1948473 | 1948473 | 2021-11-24 | Niagara | New York | 36063 | 27914 | 413 |
1948474 | 1948474 | 2021-11-24 | Oneida | New York | 36065 | 32453 | 634 |
1948475 | 1948475 | 2021-11-24 | Onondaga | New York | 36067 | 58327 | 807 |
1948476 | 1948476 | 2021-11-24 | Ontario | New York | 36069 | 11364 | 118 |
1948477 | 1948477 | 2021-11-24 | Orange | New York | 36071 | 61278 | 797 |
1948478 | 1948478 | 2021-11-24 | Orleans | New York | 36073 | 5328 | 95 |
1948479 | 1948479 | 2021-11-24 | Oswego | New York | 36075 | 13796 | 132 |
1948480 | 1948480 | 2021-11-24 | Otsego | New York | 36077 | 5202 | 61 |
1948481 | 1948481 | 2021-11-24 | Putnam | New York | 36079 | 12997 | 101 |
1948482 | 1948482 | 2021-11-24 | Rensselaer | New York | 36083 | 16941 | 190 |
1948483 | 1948483 | 2021-11-24 | Rockland | New York | 36087 | 55056 | 782 |
1948484 | 1948484 | 2021-11-24 | Saratoga | New York | 36091 | 23823 | 220 |
1948485 | 1948485 | 2021-11-24 | Schenectady | New York | 36093 | 18922 | 242 |
1948486 | 1948486 | 2021-11-24 | Schoharie | New York | 36095 | 2603 | 24 |
1948487 | 1948487 | 2021-11-24 | Schuyler | New York | 36097 | 1858 | 20 |
1948488 | 1948488 | 2021-11-24 | Seneca | New York | 36099 | 3120 | 67 |
1948489 | 1948489 | 2021-11-24 | St. Lawrence | New York | 36089 | 12474 | 143 |
1948490 | 1948490 | 2021-11-24 | Steuben | New York | 36101 | 12059 | 187 |
1948491 | 1948491 | 2021-11-24 | Suffolk | New York | 36103 | 252053 | 3673 |
1948492 | 1948492 | 2021-11-24 | Sullivan | New York | 36105 | 9324 | 90 |
1948493 | 1948493 | 2021-11-24 | Tioga | New York | 36107 | 6209 | 73 |
1948494 | 1948494 | 2021-11-24 | Tompkins | New York | 36109 | 7223 | 61 |
1948495 | 1948495 | 2021-11-24 | Ulster | New York | 36111 | 18701 | 288 |
1948496 | 1948496 | 2021-11-24 | Warren | New York | 36113 | 6984 | 94 |
1948497 | 1948497 | 2021-11-24 | Washington | New York | 36115 | 6370 | 75 |
1948498 | 1948498 | 2021-11-24 | Wayne | New York | 36117 | 9897 | 101 |
1948499 | 1948499 | 2021-11-24 | Westchester | New York | 36119 | 147176 | 2354 |
1948500 | 1948500 | 2021-11-24 | Wyoming | New York | 36121 | 5123 | 64 |
1948501 | 1948501 | 2021-11-24 | Yates | New York | 36123 | 1943 | 33 |
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);