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 428
- Westchester 425
- Nassau 424
- Rockland 423
- Saratoga 422
- Suffolk 421
- Ulster 421
- Monroe 418
- Albany 417
- Delaware 417
- Dutchess 417
- Herkimer 417
- Orange 417
- Schenectady 416
- Broome 415
- Tioga 415
- Tompkins 415
- Erie 414
- Greene 414
- Montgomery 414
- Putnam 414
- Allegany 413
- Onondaga 413
- Ontario 413
- Clinton 412
- Rensselaer 412
- Sullivan 412
- Wyoming 412
- Chenango 411
- Essex 411
- …
state 1
- New York · 23,884 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279390 | 1279390 | 2021-05-02 | Albany | New York | 36001 | 24180 | 347 |
1279391 | 1279391 | 2021-05-02 | Allegany | New York | 36003 | 3309 | 84 |
1279392 | 1279392 | 2021-05-02 | Broome | New York | 36007 | 17997 | 354 |
1279393 | 1279393 | 2021-05-02 | Cattaraugus | New York | 36009 | 5411 | 84 |
1279394 | 1279394 | 2021-05-02 | Cayuga | New York | 36011 | 6062 | 92 |
1279395 | 1279395 | 2021-05-02 | Chautauqua | New York | 36013 | 8641 | 137 |
1279396 | 1279396 | 2021-05-02 | Chemung | New York | 36015 | 7385 | 133 |
1279397 | 1279397 | 2021-05-02 | Chenango | New York | 36017 | 3298 | 75 |
1279398 | 1279398 | 2021-05-02 | Clinton | New York | 36019 | 4701 | 33 |
1279399 | 1279399 | 2021-05-02 | Columbia | New York | 36021 | 3898 | 100 |
1279400 | 1279400 | 2021-05-02 | Cortland | New York | 36023 | 3636 | 60 |
1279401 | 1279401 | 2021-05-02 | Delaware | New York | 36025 | 2271 | 37 |
1279402 | 1279402 | 2021-05-02 | Dutchess | New York | 36027 | 28744 | 442 |
1279403 | 1279403 | 2021-05-02 | Erie | New York | 36029 | 86606 | 1752 |
1279404 | 1279404 | 2021-05-02 | Essex | New York | 36031 | 1553 | 26 |
1279405 | 1279405 | 2021-05-02 | Franklin | New York | 36033 | 2488 | 12 |
1279406 | 1279406 | 2021-05-02 | Fulton | New York | 36035 | 4219 | 90 |
1279407 | 1279407 | 2021-05-02 | Genesee | New York | 36037 | 5228 | 121 |
1279408 | 1279408 | 2021-05-02 | Greene | New York | 36039 | 3266 | 74 |
1279409 | 1279409 | 2021-05-02 | Hamilton | New York | 36041 | 303 | 2 |
1279410 | 1279410 | 2021-05-02 | Herkimer | New York | 36043 | 5003 | 107 |
1279411 | 1279411 | 2021-05-02 | Jefferson | New York | 36045 | 5676 | 65 |
1279412 | 1279412 | 2021-05-02 | Lewis | New York | 36049 | 2561 | 34 |
1279413 | 1279413 | 2021-05-02 | Livingston | New York | 36051 | 4199 | 58 |
1279414 | 1279414 | 2021-05-02 | Madison | New York | 36053 | 4396 | 88 |
1279415 | 1279415 | 2021-05-02 | Monroe | New York | 36055 | 64207 | 1050 |
1279416 | 1279416 | 2021-05-02 | Montgomery | New York | 36057 | 4092 | 120 |
1279417 | 1279417 | 2021-05-02 | Nassau | New York | 36059 | 180730 | 3144 |
1279418 | 1279418 | 2021-05-02 | New York City | New York | 930132 | 32626 | |
1279419 | 1279419 | 2021-05-02 | Niagara | New York | 36063 | 19190 | 340 |
1279420 | 1279420 | 2021-05-02 | Oneida | New York | 36065 | 21915 | 501 |
1279421 | 1279421 | 2021-05-02 | Onondaga | New York | 36067 | 37316 | 667 |
1279422 | 1279422 | 2021-05-02 | Ontario | New York | 36069 | 7154 | 92 |
1279423 | 1279423 | 2021-05-02 | Orange | New York | 36071 | 47332 | 706 |
1279424 | 1279424 | 2021-05-02 | Orleans | New York | 36073 | 2941 | 83 |
1279425 | 1279425 | 2021-05-02 | Oswego | New York | 36075 | 7237 | 90 |
1279426 | 1279426 | 2021-05-02 | Otsego | New York | 36077 | 3320 | 47 |
1279427 | 1279427 | 2021-05-02 | Putnam | New York | 36079 | 10433 | 91 |
1279428 | 1279428 | 2021-05-02 | Rensselaer | New York | 36083 | 10942 | 139 |
1279429 | 1279429 | 2021-05-02 | Rockland | New York | 36087 | 46347 | 747 |
1279430 | 1279430 | 2021-05-02 | Saratoga | New York | 36091 | 14806 | 164 |
1279431 | 1279431 | 2021-05-02 | Schenectady | New York | 36093 | 12743 | 194 |
1279432 | 1279432 | 2021-05-02 | Schoharie | New York | 36095 | 1614 | 16 |
1279433 | 1279433 | 2021-05-02 | Schuyler | New York | 36097 | 1019 | 14 |
1279434 | 1279434 | 2021-05-02 | Seneca | New York | 36099 | 1938 | 56 |
1279435 | 1279435 | 2021-05-02 | St. Lawrence | New York | 36089 | 6370 | 96 |
1279436 | 1279436 | 2021-05-02 | Steuben | New York | 36101 | 6564 | 143 |
1279437 | 1279437 | 2021-05-02 | Suffolk | New York | 36103 | 197546 | 3352 |
1279438 | 1279438 | 2021-05-02 | Sullivan | New York | 36105 | 6415 | 71 |
1279439 | 1279439 | 2021-05-02 | Tioga | New York | 36107 | 3589 | 61 |
1279440 | 1279440 | 2021-05-02 | Tompkins | New York | 36109 | 4158 | 50 |
1279441 | 1279441 | 2021-05-02 | Ulster | New York | 36111 | 13537 | 249 |
1279442 | 1279442 | 2021-05-02 | Warren | New York | 36113 | 3488 | 57 |
1279443 | 1279443 | 2021-05-02 | Washington | New York | 36115 | 2981 | 55 |
1279444 | 1279444 | 2021-05-02 | Wayne | New York | 36117 | 5471 | 67 |
1279445 | 1279445 | 2021-05-02 | Westchester | New York | 36119 | 127912 | 2258 |
1279446 | 1279446 | 2021-05-02 | Wyoming | New York | 36121 | 3415 | 51 |
1279447 | 1279447 | 2021-05-02 | Yates | New York | 36123 | 1142 | 26 |
1276143 | 1276143 | 2021-05-01 | Albany | New York | 36001 | 24159 | 347 |
1276144 | 1276144 | 2021-05-01 | Allegany | New York | 36003 | 3299 | 84 |
1276145 | 1276145 | 2021-05-01 | Broome | New York | 36007 | 17975 | 354 |
1276146 | 1276146 | 2021-05-01 | Cattaraugus | New York | 36009 | 5399 | 84 |
1276147 | 1276147 | 2021-05-01 | Cayuga | New York | 36011 | 6049 | 92 |
1276148 | 1276148 | 2021-05-01 | Chautauqua | New York | 36013 | 8635 | 137 |
1276149 | 1276149 | 2021-05-01 | Chemung | New York | 36015 | 7361 | 133 |
1276150 | 1276150 | 2021-05-01 | Chenango | New York | 36017 | 3288 | 75 |
1276151 | 1276151 | 2021-05-01 | Clinton | New York | 36019 | 4693 | 33 |
1276152 | 1276152 | 2021-05-01 | Columbia | New York | 36021 | 3894 | 100 |
1276153 | 1276153 | 2021-05-01 | Cortland | New York | 36023 | 3624 | 60 |
1276154 | 1276154 | 2021-05-01 | Delaware | New York | 36025 | 2266 | 37 |
1276155 | 1276155 | 2021-05-01 | Dutchess | New York | 36027 | 28698 | 442 |
1276156 | 1276156 | 2021-05-01 | Erie | New York | 36029 | 86439 | 1750 |
1276157 | 1276157 | 2021-05-01 | Essex | New York | 36031 | 1545 | 26 |
1276158 | 1276158 | 2021-05-01 | Franklin | New York | 36033 | 2483 | 12 |
1276159 | 1276159 | 2021-05-01 | Fulton | New York | 36035 | 4215 | 90 |
1276160 | 1276160 | 2021-05-01 | Genesee | New York | 36037 | 5221 | 121 |
1276161 | 1276161 | 2021-05-01 | Greene | New York | 36039 | 3255 | 74 |
1276162 | 1276162 | 2021-05-01 | Hamilton | New York | 36041 | 303 | 2 |
1276163 | 1276163 | 2021-05-01 | Herkimer | New York | 36043 | 4994 | 107 |
1276164 | 1276164 | 2021-05-01 | Jefferson | New York | 36045 | 5668 | 65 |
1276165 | 1276165 | 2021-05-01 | Lewis | New York | 36049 | 2557 | 34 |
1276166 | 1276166 | 2021-05-01 | Livingston | New York | 36051 | 4189 | 58 |
1276167 | 1276167 | 2021-05-01 | Madison | New York | 36053 | 4385 | 88 |
1276168 | 1276168 | 2021-05-01 | Monroe | New York | 36055 | 63999 | 1050 |
1276169 | 1276169 | 2021-05-01 | Montgomery | New York | 36057 | 4079 | 120 |
1276170 | 1276170 | 2021-05-01 | Nassau | New York | 36059 | 180605 | 3144 |
1276171 | 1276171 | 2021-05-01 | New York City | New York | 928840 | 32596 | |
1276172 | 1276172 | 2021-05-01 | Niagara | New York | 36063 | 19138 | 340 |
1276173 | 1276173 | 2021-05-01 | Oneida | New York | 36065 | 21892 | 501 |
1276174 | 1276174 | 2021-05-01 | Onondaga | New York | 36067 | 37232 | 666 |
1276175 | 1276175 | 2021-05-01 | Ontario | New York | 36069 | 7129 | 92 |
1276176 | 1276176 | 2021-05-01 | Orange | New York | 36071 | 47264 | 705 |
1276177 | 1276177 | 2021-05-01 | Orleans | New York | 36073 | 2932 | 83 |
1276178 | 1276178 | 2021-05-01 | Oswego | New York | 36075 | 7221 | 90 |
1276179 | 1276179 | 2021-05-01 | Otsego | New York | 36077 | 3312 | 47 |
1276180 | 1276180 | 2021-05-01 | Putnam | New York | 36079 | 10427 | 91 |
1276181 | 1276181 | 2021-05-01 | Rensselaer | New York | 36083 | 10928 | 139 |
1276182 | 1276182 | 2021-05-01 | Rockland | New York | 36087 | 46319 | 746 |
1276183 | 1276183 | 2021-05-01 | Saratoga | New York | 36091 | 14789 | 164 |
1276184 | 1276184 | 2021-05-01 | Schenectady | New York | 36093 | 12717 | 194 |
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);