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

33,976 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 · 33,976 ✖
Link rowid date ▲ county state fips cases deaths
1844455 1844455 2021-10-23 Albany New York 36001 31020 390
1844456 1844456 2021-10-23 Allegany New York 36003 4661 98
1844457 1844457 2021-10-23 Broome New York 36007 24657 408
1844458 1844458 2021-10-23 Cattaraugus New York 36009 7817 116
1844459 1844459 2021-10-23 Cayuga New York 36011 8702 107
1844460 1844460 2021-10-23 Chautauqua New York 36013 12500 175
1844461 1844461 2021-10-23 Chemung New York 36015 11021 156
1844462 1844462 2021-10-23 Chenango New York 36017 4715 88
1844463 1844463 2021-10-23 Clinton New York 36019 6787 40
1844464 1844464 2021-10-23 Columbia New York 36021 5037 111
1844465 1844465 2021-10-23 Cortland New York 36023 5380 80
1844466 1844466 2021-10-23 Delaware New York 36025 3585 48
1844467 1844467 2021-10-23 Dutchess New York 36027 35740 499
1844468 1844468 2021-10-23 Erie New York 36029 106959 1953
1844469 1844469 2021-10-23 Essex New York 36031 2355 31
1844470 1844470 2021-10-23 Franklin New York 36033 4328 22
1844471 1844471 2021-10-23 Fulton New York 36035 6412 104
1844472 1844472 2021-10-23 Genesee New York 36037 7082 132
1844473 1844473 2021-10-23 Greene New York 36039 4410 87
1844474 1844474 2021-10-23 Hamilton New York 36041 439 3
1844475 1844475 2021-10-23 Herkimer New York 36043 6861 128
1844476 1844476 2021-10-23 Jefferson New York 36045 8983 76
1844477 1844477 2021-10-23 Lewis New York 36049 3636 38
1844478 1844478 2021-10-23 Livingston New York 36051 5780 71
1844479 1844479 2021-10-23 Madison New York 36053 6251 102
1844480 1844480 2021-10-23 Monroe New York 36055 84785 1189
1844481 1844481 2021-10-23 Montgomery New York 36057 6022 142
1844482 1844482 2021-10-23 Nassau New York 36059 214772 3299
1844483 1844483 2021-10-23 New York City New York   1113762 34502
1844484 1844484 2021-10-23 Niagara New York 36063 24170 398
1844485 1844485 2021-10-23 Oneida New York 36065 28822 589
1844486 1844486 2021-10-23 Onondaga New York 36067 52355 765
1844487 1844487 2021-10-23 Ontario New York 36069 9423 110
1844488 1844488 2021-10-23 Orange New York 36071 57727 772
1844489 1844489 2021-10-23 Orleans New York 36073 4384 88
1844490 1844490 2021-10-23 Oswego New York 36075 11764 115
1844491 1844491 2021-10-23 Otsego New York 36077 4606 55
1844492 1844492 2021-10-23 Putnam New York 36079 12529 98
1844493 1844493 2021-10-23 Rensselaer New York 36083 14902 169
1844494 1844494 2021-10-23 Rockland New York 36087 53233 779
1844495 1844495 2021-10-23 Saratoga New York 36091 20424 202
1844496 1844496 2021-10-23 Schenectady New York 36093 16876 229
1844497 1844497 2021-10-23 Schoharie New York 36095 2322 21
1844498 1844498 2021-10-23 Schuyler New York 36097 1546 17
1844499 1844499 2021-10-23 Seneca New York 36099 2757 63
1844500 1844500 2021-10-23 St. Lawrence New York 36089 10664 127
1844501 1844501 2021-10-23 Steuben New York 36101 10245 173
1844502 1844502 2021-10-23 Suffolk New York 36103 240189 3611
1844503 1844503 2021-10-23 Sullivan New York 36105 8511 83
1844504 1844504 2021-10-23 Tioga New York 36107 5162 72
1844505 1844505 2021-10-23 Tompkins New York 36109 6549 59
1844506 1844506 2021-10-23 Ulster New York 36111 17327 280
1844507 1844507 2021-10-23 Warren New York 36113 5542 84
1844508 1844508 2021-10-23 Washington New York 36115 4667 67
1844509 1844509 2021-10-23 Wayne New York 36117 8251 84
1844510 1844510 2021-10-23 Westchester New York 36119 143775 2341
1844511 1844511 2021-10-23 Wyoming New York 36121 4418 58
1844512 1844512 2021-10-23 Yates New York 36123 1667 28
1841205 1841205 2021-10-22 Albany New York 36001 30915 390
1841206 1841206 2021-10-22 Allegany New York 36003 4641 97
1841207 1841207 2021-10-22 Broome New York 36007 24552 407
1841208 1841208 2021-10-22 Cattaraugus New York 36009 7752 115
1841209 1841209 2021-10-22 Cayuga New York 36011 8674 107
1841210 1841210 2021-10-22 Chautauqua New York 36013 12449 175
1841211 1841211 2021-10-22 Chemung New York 36015 10966 156
1841212 1841212 2021-10-22 Chenango New York 36017 4706 86
1841213 1841213 2021-10-22 Clinton New York 36019 6750 40
1841214 1841214 2021-10-22 Columbia New York 36021 5025 111
1841215 1841215 2021-10-22 Cortland New York 36023 5357 80
1841216 1841216 2021-10-22 Delaware New York 36025 3574 48
1841217 1841217 2021-10-22 Dutchess New York 36027 35671 499
1841218 1841218 2021-10-22 Erie New York 36029 106578 1950
1841219 1841219 2021-10-22 Essex New York 36031 2335 31
1841220 1841220 2021-10-22 Franklin New York 36033 4300 21
1841221 1841221 2021-10-22 Fulton New York 36035 6365 104
1841222 1841222 2021-10-22 Genesee New York 36037 7038 132
1841223 1841223 2021-10-22 Greene New York 36039 4401 86
1841224 1841224 2021-10-22 Hamilton New York 36041 438 3
1841225 1841225 2021-10-22 Herkimer New York 36043 6831 128
1841226 1841226 2021-10-22 Jefferson New York 36045 8924 76
1841227 1841227 2021-10-22 Lewis New York 36049 3621 38
1841228 1841228 2021-10-22 Livingston New York 36051 5755 71
1841229 1841229 2021-10-22 Madison New York 36053 6220 102
1841230 1841230 2021-10-22 Monroe New York 36055 84533 1188
1841231 1841231 2021-10-22 Montgomery New York 36057 5993 141
1841232 1841232 2021-10-22 Nassau New York 36059 214570 3296
1841233 1841233 2021-10-22 New York City New York   1113762 34502
1841234 1841234 2021-10-22 Niagara New York 36063 24076 397
1841235 1841235 2021-10-22 Oneida New York 36065 28720 589
1841236 1841236 2021-10-22 Onondaga New York 36067 52166 762
1841237 1841237 2021-10-22 Ontario New York 36069 9378 110
1841238 1841238 2021-10-22 Orange New York 36071 57635 771
1841239 1841239 2021-10-22 Orleans New York 36073 4355 87
1841240 1841240 2021-10-22 Oswego New York 36075 11708 113
1841241 1841241 2021-10-22 Otsego New York 36077 4592 55
1841242 1841242 2021-10-22 Putnam New York 36079 12509 98
1841243 1841243 2021-10-22 Rensselaer New York 36083 14839 167
1841244 1841244 2021-10-22 Rockland New York 36087 53178 779
1841245 1841245 2021-10-22 Saratoga New York 36091 20342 201
1841246 1841246 2021-10-22 Schenectady New York 36093 16779 228

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