⚠️ 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

20,114 rows where state = "New York" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • New York · 20,114
Link rowid date ▲ county state fips cases deaths
1068333 2021-02-26 Albany New York 36001 20683 331
1068334 2021-02-26 Allegany New York 36003 2878 81
1068335 2021-02-26 Broome New York 36007 14637 336
1068336 2021-02-26 Cattaraugus New York 36009 4363 76
1068337 2021-02-26 Cayuga New York 36011 5345 88
1068338 2021-02-26 Chautauqua New York 36013 7268 122
1068339 2021-02-26 Chemung New York 36015 6420 130
1068340 2021-02-26 Chenango New York 36017 2410 69
1068341 2021-02-26 Clinton New York 36019 3530 26
1068342 2021-02-26 Columbia New York 36021 3368 94
1068343 2021-02-26 Cortland New York 36023 3140 60
1068344 2021-02-26 Delaware New York 36025 1486 33
1068345 2021-02-26 Dutchess New York 36027 22088 407
1068346 2021-02-26 Erie New York 36029 64689 1596
1068347 2021-02-26 Essex New York 36031 1340 26
1068348 2021-02-26 Franklin New York 36033 2027 12
1068349 2021-02-26 Fulton New York 36035 3289 82
1068350 2021-02-26 Genesee New York 36037 4378 118
1068351 2021-02-26 Greene New York 36039 2622 70
1068352 2021-02-26 Hamilton New York 36041 281 2
1068353 2021-02-26 Herkimer New York 36043 4539 106
1068354 2021-02-26 Jefferson New York 36045 4743 63
1068355 2021-02-26 Lewis New York 36049 2050 30
1068356 2021-02-26 Livingston New York 36051 3515 56
1068357 2021-02-26 Madison New York 36053 3817 85
1068358 2021-02-26 Monroe New York 36055 52246 982
1068359 2021-02-26 Montgomery New York 36057 3149 106
1068360 2021-02-26 Nassau New York 36059 146727 2903
1068361 2021-02-26 New York City New York   716678 29173
1068362 2021-02-26 Niagara New York 36063 15194 311
1068363 2021-02-26 Oneida New York 36065 19629 475
1068364 2021-02-26 Onondaga New York 36067 32224 626
1068365 2021-02-26 Ontario New York 36069 5750 88
1068366 2021-02-26 Orange New York 36071 36571 637
1068367 2021-02-26 Orleans New York 36073 2439 81
1068368 2021-02-26 Oswego New York 36075 5969 89
1068369 2021-02-26 Otsego New York 36077 2311 43
1068370 2021-02-26 Putnam New York 36079 8271 86
1068371 2021-02-26 Rensselaer New York 36083 8935 131
1068372 2021-02-26 Rockland New York 36087 38265 687
1068373 2021-02-26 Saratoga New York 36091 11844 145
1068374 2021-02-26 Schenectady New York 36093 10765 177
1068375 2021-02-26 Schoharie New York 36095 1187 12
1068376 2021-02-26 Schuyler New York 36097 859 12
1068377 2021-02-26 Seneca New York 36099 1589 53
1068378 2021-02-26 St. Lawrence New York 36089 5439 83
1068379 2021-02-26 Steuben New York 36101 5478 137
1068380 2021-02-26 Suffolk New York 36103 160967 3061
1068381 2021-02-26 Sullivan New York 36105 4715 59
1068382 2021-02-26 Tioga New York 36107 2788 56
1068383 2021-02-26 Tompkins New York 36109 3435 42
1068384 2021-02-26 Ulster New York 36111 9940 227
1068385 2021-02-26 Warren New York 36113 2819 55
1068386 2021-02-26 Washington New York 36115 2320 52
1068387 2021-02-26 Wayne New York 36117 4433 64
1068388 2021-02-26 Westchester New York 36119 106610 2087
1068389 2021-02-26 Wyoming New York 36121 2792 49
1068390 2021-02-26 Yates New York 36123 1011 26
1065088 2021-02-25 Albany New York 36001 20620 328
1065089 2021-02-25 Allegany New York 36003 2869 81
1065090 2021-02-25 Broome New York 36007 14521 335
1065091 2021-02-25 Cattaraugus New York 36009 4351 76
1065092 2021-02-25 Cayuga New York 36011 5333 88
1065093 2021-02-25 Chautauqua New York 36013 7257 122
1065094 2021-02-25 Chemung New York 36015 6408 130
1065095 2021-02-25 Chenango New York 36017 2397 69
1065096 2021-02-25 Clinton New York 36019 3507 26
1065097 2021-02-25 Columbia New York 36021 3360 94
1065098 2021-02-25 Cortland New York 36023 3112 60
1065099 2021-02-25 Delaware New York 36025 1478 33
1065100 2021-02-25 Dutchess New York 36027 21968 406
1065101 2021-02-25 Erie New York 36029 64414 1594
1065102 2021-02-25 Essex New York 36031 1336 26
1065103 2021-02-25 Franklin New York 36033 2008 12
1065104 2021-02-25 Fulton New York 36035 3272 81
1065105 2021-02-25 Genesee New York 36037 4372 118
1065106 2021-02-25 Greene New York 36039 2609 70
1065107 2021-02-25 Hamilton New York 36041 279 2
1065108 2021-02-25 Herkimer New York 36043 4534 106
1065109 2021-02-25 Jefferson New York 36045 4724 63
1065110 2021-02-25 Lewis New York 36049 2046 30
1065111 2021-02-25 Livingston New York 36051 3484 55
1065112 2021-02-25 Madison New York 36053 3806 84
1065113 2021-02-25 Monroe New York 36055 52123 980
1065114 2021-02-25 Montgomery New York 36057 3137 105
1065115 2021-02-25 Nassau New York 36059 145985 2896
1065116 2021-02-25 New York City New York   712389 29088
1065117 2021-02-25 Niagara New York 36063 15156 313
1065118 2021-02-25 Oneida New York 36065 19583 475
1065119 2021-02-25 Onondaga New York 36067 32151 622
1065120 2021-02-25 Ontario New York 36069 5731 88
1065121 2021-02-25 Orange New York 36071 36349 635
1065122 2021-02-25 Orleans New York 36073 2433 80
1065123 2021-02-25 Oswego New York 36075 5956 89
1065124 2021-02-25 Otsego New York 36077 2307 43
1065125 2021-02-25 Putnam New York 36079 8244 86
1065126 2021-02-25 Rensselaer New York 36083 8902 131
1065127 2021-02-25 Rockland New York 36087 38138 688
1065128 2021-02-25 Saratoga New York 36091 11796 145
1065129 2021-02-25 Schenectady New York 36093 10740 177

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