ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • New York · 45,692 ✖
Link rowid date ▲ county state fips cases deaths
2501428 2501428 2022-05-13 Albany New York 36001 63461 523
2501429 2501429 2022-05-13 Allegany New York 36003 9275 155
2501430 2501430 2022-05-13 Broome New York 36007 48947 520
2501431 2501431 2022-05-13 Cattaraugus New York 36009 16113 222
2501432 2501432 2022-05-13 Cayuga New York 36011 17375 152
2501433 2501433 2022-05-13 Chautauqua New York 36013 24556 302
2501434 2501434 2022-05-13 Chemung New York 36015 22603 233
2501435 2501435 2022-05-13 Chenango New York 36017 9858 121
2501436 2501436 2022-05-13 Clinton New York 36019 18034 90
2501437 2501437 2022-05-13 Columbia New York 36021 10772 141
2501438 2501438 2022-05-13 Cortland New York 36023 11365 120
2501439 2501439 2022-05-13 Delaware New York 36025 8261 72
2501440 2501440 2022-05-13 Dutchess New York 36027 66962 659
2501441 2501441 2022-05-13 Erie New York 36029 227059 2651
2501442 2501442 2022-05-13 Essex New York 36031 6124 61
2501443 2501443 2022-05-13 Franklin New York 36033 10059 46
2501444 2501444 2022-05-13 Fulton New York 36035 13428 169
2501445 2501445 2022-05-13 Genesee New York 36037 14395 187
2501446 2501446 2022-05-13 Greene New York 36039 9055 130
2501447 2501447 2022-05-13 Hamilton New York 36041 919 5
2501448 2501448 2022-05-13 Herkimer New York 36043 14827 193
2501449 2501449 2022-05-13 Jefferson New York 36045 21422 138
2501450 2501450 2022-05-13 Lewis New York 36049 6417 49
2501451 2501451 2022-05-13 Livingston New York 36051 12324 118
2501452 2501452 2022-05-13 Madison New York 36053 14319 127
2501453 2501453 2022-05-13 Monroe New York 36055 163464 1587
2501454 2501454 2022-05-13 Montgomery New York 36057 12471 205
2501455 2501455 2022-05-13 Nassau New York 36059 425386 3853
2501456 2501456 2022-05-13 New York City New York   2422658 40267
2501457 2501457 2022-05-13 Niagara New York 36063 51069 585
2501458 2501458 2022-05-13 Oneida New York 36065 58360 803
2501459 2501459 2022-05-13 Onondaga New York 36067 121727 1073
2501460 2501460 2022-05-13 Ontario New York 36069 21586 180
2501461 2501461 2022-05-13 Orange New York 36071 111228 954
2501462 2501462 2022-05-13 Orleans New York 36073 9116 117
2501463 2501463 2022-05-13 Oswego New York 36075 28826 194
2501464 2501464 2022-05-13 Otsego New York 36077 10667 88
2501465 2501465 2022-05-13 Putnam New York 36079 24875 125
2501466 2501466 2022-05-13 Rensselaer New York 36083 33850 259
2501467 2501467 2022-05-13 Rockland New York 36087 96142 897
2501468 2501468 2022-05-13 Saratoga New York 36091 49890 335
2501469 2501469 2022-05-13 Schenectady New York 36093 35317 305
2501470 2501470 2022-05-13 Schoharie New York 36095 5336 36
2501471 2501471 2022-05-13 Schuyler New York 36097 3724 25
2501472 2501472 2022-05-13 Seneca New York 36099 6391 91
2501473 2501473 2022-05-13 St. Lawrence New York 36089 22454 191
2501474 2501474 2022-05-13 Steuben New York 36101 21216 253
2501475 2501475 2022-05-13 Suffolk New York 36103 444799 4399
2501476 2501476 2022-05-13 Sullivan New York 36105 19217 130
2501477 2501477 2022-05-13 Tioga New York 36107 11719 85
2501478 2501478 2022-05-13 Tompkins New York 36109 21144 85
2501479 2501479 2022-05-13 Ulster New York 36111 33856 365
2501480 2501480 2022-05-13 Warren New York 36113 14739 129
2501481 2501481 2022-05-13 Washington New York 36115 12875 115
2501482 2501482 2022-05-13 Wayne New York 36117 18503 179
2501483 2501483 2022-05-13 Westchester New York 36119 264447 2720
2501484 2501484 2022-05-13 Wyoming New York 36121 8692 84
2501485 2501485 2022-05-13 Yates New York 36123 3704 40
2498170 2498170 2022-05-12 Albany New York 36001 63461 523
2498171 2498171 2022-05-12 Allegany New York 36003 9275 154
2498172 2498172 2022-05-12 Broome New York 36007 48947 520
2498173 2498173 2022-05-12 Cattaraugus New York 36009 16113 222
2498174 2498174 2022-05-12 Cayuga New York 36011 17375 152
2498175 2498175 2022-05-12 Chautauqua New York 36013 24556 302
2498176 2498176 2022-05-12 Chemung New York 36015 22603 233
2498177 2498177 2022-05-12 Chenango New York 36017 9858 120
2498178 2498178 2022-05-12 Clinton New York 36019 18034 90
2498179 2498179 2022-05-12 Columbia New York 36021 10772 140
2498180 2498180 2022-05-12 Cortland New York 36023 11365 120
2498181 2498181 2022-05-12 Delaware New York 36025 8261 72
2498182 2498182 2022-05-12 Dutchess New York 36027 66962 659
2498183 2498183 2022-05-12 Erie New York 36029 227059 2648
2498184 2498184 2022-05-12 Essex New York 36031 6124 61
2498185 2498185 2022-05-12 Franklin New York 36033 10059 46
2498186 2498186 2022-05-12 Fulton New York 36035 13428 169
2498187 2498187 2022-05-12 Genesee New York 36037 14395 187
2498188 2498188 2022-05-12 Greene New York 36039 9055 129
2498189 2498189 2022-05-12 Hamilton New York 36041 919 5
2498190 2498190 2022-05-12 Herkimer New York 36043 14827 193
2498191 2498191 2022-05-12 Jefferson New York 36045 21422 138
2498192 2498192 2022-05-12 Lewis New York 36049 6417 49
2498193 2498193 2022-05-12 Livingston New York 36051 12324 118
2498194 2498194 2022-05-12 Madison New York 36053 14319 127
2498195 2498195 2022-05-12 Monroe New York 36055 163464 1586
2498196 2498196 2022-05-12 Montgomery New York 36057 12471 205
2498197 2498197 2022-05-12 Nassau New York 36059 425386 3852
2498198 2498198 2022-05-12 New York City New York   2417909 40261
2498199 2498199 2022-05-12 Niagara New York 36063 51069 584
2498200 2498200 2022-05-12 Oneida New York 36065 58360 802
2498201 2498201 2022-05-12 Onondaga New York 36067 121727 1073
2498202 2498202 2022-05-12 Ontario New York 36069 21586 180
2498203 2498203 2022-05-12 Orange New York 36071 111228 953
2498204 2498204 2022-05-12 Orleans New York 36073 9116 116
2498205 2498205 2022-05-12 Oswego New York 36075 28826 194
2498206 2498206 2022-05-12 Otsego New York 36077 10667 88
2498207 2498207 2022-05-12 Putnam New York 36079 24875 125
2498208 2498208 2022-05-12 Rensselaer New York 36083 33850 257
2498209 2498209 2022-05-12 Rockland New York 36087 96142 897
2498210 2498210 2022-05-12 Saratoga New York 36091 49890 335
2498211 2498211 2022-05-12 Schenectady New York 36093 35317 305

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);