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

20,114 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

county

state

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