ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,692 rows where state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- New York City 561
- Westchester 559
- Nassau 557
- Rockland 556
- Saratoga 555
- Suffolk 555
- Ulster 555
- Monroe 551
- Albany 550
- Delaware 550
- Dutchess 550
- Herkimer 550
- Orange 550
- Schenectady 549
- Tioga 549
- Tompkins 549
- Broome 548
- Erie 547
- Greene 547
- Montgomery 547
- Putnam 547
- Allegany 546
- Onondaga 546
- Ontario 546
- Sullivan 546
- Wyoming 546
- Clinton 545
- Rensselaer 545
- Warren 545
- Washington 545
- …
state 1
- New York · 31,614 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1714534 | 1714534 | 2021-09-13 | Schoharie | New York | 36095 | 2016 | 20 |
1714535 | 1714535 | 2021-09-13 | Schuyler | New York | 36097 | 1223 | 16 |
1714536 | 1714536 | 2021-09-13 | Seneca | New York | 36099 | 2364 | 58 |
1714537 | 1714537 | 2021-09-13 | St. Lawrence | New York | 36089 | 8357 | 109 |
1714538 | 1714538 | 2021-09-13 | Steuben | New York | 36101 | 7991 | 153 |
1714539 | 1714539 | 2021-09-13 | Suffolk | New York | 36103 | 222987 | 3492 |
1714540 | 1714540 | 2021-09-13 | Sullivan | New York | 36105 | 7620 | 79 |
1714541 | 1714541 | 2021-09-13 | Tioga | New York | 36107 | 4282 | 65 |
1714542 | 1714542 | 2021-09-13 | Tompkins | New York | 36109 | 5683 | 57 |
1714543 | 1714543 | 2021-09-13 | Ulster | New York | 36111 | 15968 | 268 |
1714544 | 1714544 | 2021-09-13 | Warren | New York | 36113 | 4501 | 76 |
1714545 | 1714545 | 2021-09-13 | Washington | New York | 36115 | 3743 | 59 |
1714546 | 1714546 | 2021-09-13 | Wayne | New York | 36117 | 6650 | 76 |
1714547 | 1714547 | 2021-09-13 | Westchester | New York | 36119 | 139331 | 2321 |
1714548 | 1714548 | 2021-09-13 | Wyoming | New York | 36121 | 3818 | 54 |
1714549 | 1714549 | 2021-09-13 | Yates | New York | 36123 | 1343 | 26 |
1711246 | 1711246 | 2021-09-12 | Albany | New York | 36001 | 27705 | 366 |
1711247 | 1711247 | 2021-09-12 | Allegany | New York | 36003 | 3862 | 91 |
1711248 | 1711248 | 2021-09-12 | Broome | New York | 36007 | 20961 | 377 |
1711249 | 1711249 | 2021-09-12 | Cattaraugus | New York | 36009 | 6490 | 95 |
1711250 | 1711250 | 2021-09-12 | Cayuga | New York | 36011 | 7578 | 100 |
1711251 | 1711251 | 2021-09-12 | Chautauqua | New York | 36013 | 10312 | 153 |
1711252 | 1711252 | 2021-09-12 | Chemung | New York | 36015 | 8641 | 141 |
1711253 | 1711253 | 2021-09-12 | Chenango | New York | 36017 | 4046 | 85 |
1711254 | 1711254 | 2021-09-12 | Clinton | New York | 36019 | 5329 | 33 |
1711255 | 1711255 | 2021-09-12 | Columbia | New York | 36021 | 4489 | 107 |
1711256 | 1711256 | 2021-09-12 | Cortland | New York | 36023 | 4620 | 68 |
1711257 | 1711257 | 2021-09-12 | Delaware | New York | 36025 | 2870 | 40 |
1711258 | 1711258 | 2021-09-12 | Dutchess | New York | 36027 | 33048 | 478 |
1711259 | 1711259 | 2021-09-12 | Erie | New York | 36029 | 96939 | 1866 |
1711260 | 1711260 | 2021-09-12 | Essex | New York | 36031 | 1870 | 29 |
1711261 | 1711261 | 2021-09-12 | Franklin | New York | 36033 | 3230 | 13 |
1711262 | 1711262 | 2021-09-12 | Fulton | New York | 36035 | 5095 | 97 |
1711263 | 1711263 | 2021-09-12 | Genesee | New York | 36037 | 5879 | 126 |
1711264 | 1711264 | 2021-09-12 | Greene | New York | 36039 | 3826 | 82 |
1711265 | 1711265 | 2021-09-12 | Hamilton | New York | 36041 | 396 | 3 |
1711266 | 1711266 | 2021-09-12 | Herkimer | New York | 36043 | 5819 | 114 |
1711267 | 1711267 | 2021-09-12 | Jefferson | New York | 36045 | 7085 | 70 |
1711268 | 1711268 | 2021-09-12 | Lewis | New York | 36049 | 3069 | 36 |
1711269 | 1711269 | 2021-09-12 | Livingston | New York | 36051 | 5019 | 63 |
1711270 | 1711270 | 2021-09-12 | Madison | New York | 36053 | 5223 | 93 |
1711271 | 1711271 | 2021-09-12 | Monroe | New York | 36055 | 76269 | 1146 |
1711272 | 1711272 | 2021-09-12 | Montgomery | New York | 36057 | 4891 | 133 |
1711273 | 1711273 | 2021-09-12 | Nassau | New York | 36059 | 202967 | 3235 |
1711274 | 1711274 | 2021-09-12 | New York City | New York | 1051595 | 33977 | |
1711275 | 1711275 | 2021-09-12 | Niagara | New York | 36063 | 21590 | 379 |
1711276 | 1711276 | 2021-09-12 | Oneida | New York | 36065 | 24934 | 529 |
1711277 | 1711277 | 2021-09-12 | Onondaga | New York | 36067 | 44329 | 695 |
1711278 | 1711278 | 2021-09-12 | Ontario | New York | 36069 | 8272 | 95 |
1711279 | 1711279 | 2021-09-12 | Orange | New York | 36071 | 53509 | 746 |
1711280 | 1711280 | 2021-09-12 | Orleans | New York | 36073 | 3487 | 83 |
1711281 | 1711281 | 2021-09-12 | Oswego | New York | 36075 | 9125 | 99 |
1711282 | 1711282 | 2021-09-12 | Otsego | New York | 36077 | 4026 | 50 |
1711283 | 1711283 | 2021-09-12 | Putnam | New York | 36079 | 11580 | 95 |
1711284 | 1711284 | 2021-09-12 | Rensselaer | New York | 36083 | 12874 | 154 |
1711285 | 1711285 | 2021-09-12 | Rockland | New York | 36087 | 50015 | 766 |
1711286 | 1711286 | 2021-09-12 | Saratoga | New York | 36091 | 17949 | 184 |
1711287 | 1711287 | 2021-09-12 | Schenectady | New York | 36093 | 14885 | 213 |
1711288 | 1711288 | 2021-09-12 | Schoharie | New York | 36095 | 2008 | 20 |
1711289 | 1711289 | 2021-09-12 | Schuyler | New York | 36097 | 1220 | 16 |
1711290 | 1711290 | 2021-09-12 | Seneca | New York | 36099 | 2354 | 58 |
1711291 | 1711291 | 2021-09-12 | St. Lawrence | New York | 36089 | 8297 | 109 |
1711292 | 1711292 | 2021-09-12 | Steuben | New York | 36101 | 7967 | 152 |
1711293 | 1711293 | 2021-09-12 | Suffolk | New York | 36103 | 222776 | 3490 |
1711294 | 1711294 | 2021-09-12 | Sullivan | New York | 36105 | 7602 | 79 |
1711295 | 1711295 | 2021-09-12 | Tioga | New York | 36107 | 4264 | 65 |
1711296 | 1711296 | 2021-09-12 | Tompkins | New York | 36109 | 5669 | 56 |
1711297 | 1711297 | 2021-09-12 | Ulster | New York | 36111 | 15935 | 268 |
1711298 | 1711298 | 2021-09-12 | Warren | New York | 36113 | 4479 | 76 |
1711299 | 1711299 | 2021-09-12 | Washington | New York | 36115 | 3720 | 59 |
1711300 | 1711300 | 2021-09-12 | Wayne | New York | 36117 | 6632 | 76 |
1711301 | 1711301 | 2021-09-12 | Westchester | New York | 36119 | 139197 | 2321 |
1711302 | 1711302 | 2021-09-12 | Wyoming | New York | 36121 | 3814 | 54 |
1711303 | 1711303 | 2021-09-12 | Yates | New York | 36123 | 1337 | 26 |
1707999 | 1707999 | 2021-09-11 | Albany | New York | 36001 | 27638 | 366 |
1708000 | 1708000 | 2021-09-11 | Allegany | New York | 36003 | 3843 | 91 |
1708001 | 1708001 | 2021-09-11 | Broome | New York | 36007 | 20883 | 376 |
1708002 | 1708002 | 2021-09-11 | Cattaraugus | New York | 36009 | 6467 | 95 |
1708003 | 1708003 | 2021-09-11 | Cayuga | New York | 36011 | 7527 | 100 |
1708004 | 1708004 | 2021-09-11 | Chautauqua | New York | 36013 | 10248 | 153 |
1708005 | 1708005 | 2021-09-11 | Chemung | New York | 36015 | 8591 | 141 |
1708006 | 1708006 | 2021-09-11 | Chenango | New York | 36017 | 4031 | 85 |
1708007 | 1708007 | 2021-09-11 | Clinton | New York | 36019 | 5295 | 33 |
1708008 | 1708008 | 2021-09-11 | Columbia | New York | 36021 | 4474 | 107 |
1708009 | 1708009 | 2021-09-11 | Cortland | New York | 36023 | 4585 | 68 |
1708010 | 1708010 | 2021-09-11 | Delaware | New York | 36025 | 2833 | 40 |
1708011 | 1708011 | 2021-09-11 | Dutchess | New York | 36027 | 32926 | 476 |
1708012 | 1708012 | 2021-09-11 | Erie | New York | 36029 | 96746 | 1862 |
1708013 | 1708013 | 2021-09-11 | Essex | New York | 36031 | 1866 | 29 |
1708014 | 1708014 | 2021-09-11 | Franklin | New York | 36033 | 3201 | 13 |
1708015 | 1708015 | 2021-09-11 | Fulton | New York | 36035 | 5073 | 97 |
1708016 | 1708016 | 2021-09-11 | Genesee | New York | 36037 | 5858 | 125 |
1708017 | 1708017 | 2021-09-11 | Greene | New York | 36039 | 3816 | 82 |
1708018 | 1708018 | 2021-09-11 | Hamilton | New York | 36041 | 396 | 3 |
1708019 | 1708019 | 2021-09-11 | Herkimer | New York | 36043 | 5798 | 114 |
1708020 | 1708020 | 2021-09-11 | Jefferson | New York | 36045 | 7042 | 70 |
1708021 | 1708021 | 2021-09-11 | Lewis | New York | 36049 | 3057 | 36 |
1708022 | 1708022 | 2021-09-11 | Livingston | New York | 36051 | 4992 | 63 |
1708023 | 1708023 | 2021-09-11 | Madison | New York | 36053 | 5199 | 93 |
1708024 | 1708024 | 2021-09-11 | Monroe | New York | 36055 | 76031 | 1145 |
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);