ny_times_us_counties

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

6,310 rows where state = "New York" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • New York · 6,310 ✖
Link rowid date ▲ county state fips cases deaths
293551 293551 2020-07-03 Albany New York 36001 2130 160
293552 293552 2020-07-03 Allegany New York 36003 63 0
293553 293553 2020-07-03 Broome New York 36007 736 62
293554 293554 2020-07-03 Cattaraugus New York 36009 124 5
293555 293555 2020-07-03 Cayuga New York 36011 120 1
293556 293556 2020-07-03 Chautauqua New York 36013 129 4
293557 293557 2020-07-03 Chemung New York 36015 145 5
293558 293558 2020-07-03 Chenango New York 36017 148 3
293559 293559 2020-07-03 Clinton New York 36019 101 4
293560 293560 2020-07-03 Columbia New York 36021 474 43
293561 293561 2020-07-03 Cortland New York 36023 48 0
293562 293562 2020-07-03 Delaware New York 36025 91 0
293563 293563 2020-07-03 Dutchess New York 36027 4231 159
293564 293564 2020-07-03 Erie New York 36029 7427 598
293565 293565 2020-07-03 Essex New York 36031 54 0
293566 293566 2020-07-03 Franklin New York 36033 33 0
293567 293567 2020-07-03 Fulton New York 36035 261 18
293568 293568 2020-07-03 Genesee New York 36037 239 6
293569 293569 2020-07-03 Greene New York 36039 263 5
293570 293570 2020-07-03 Hamilton New York 36041 6 0
293571 293571 2020-07-03 Herkimer New York 36043 172 1
293572 293572 2020-07-03 Jefferson New York 36045 93 0
293573 293573 2020-07-03 Lewis New York 36049 30 0
293574 293574 2020-07-03 Livingston New York 36051 130 4
293575 293575 2020-07-03 Madison New York 36053 360 4
293576 293576 2020-07-03 Monroe New York 36055 3886 262
293577 293577 2020-07-03 Montgomery New York 36057 119 5
293578 293578 2020-07-03 Nassau New York 36059 41947 2697
293579 293579 2020-07-03 New York City New York   221028 22610
293580 293580 2020-07-03 Niagara New York 36063 1262 66
293581 293581 2020-07-03 Oneida New York 36065 1708 96
293582 293582 2020-07-03 Onondaga New York 36067 2909 178
293583 293583 2020-07-03 Ontario New York 36069 275 25
293584 293584 2020-07-03 Orange New York 36071 10774 401
293585 293585 2020-07-03 Orleans New York 36073 282 41
293586 293586 2020-07-03 Oswego New York 36075 206 0
293587 293587 2020-07-03 Otsego New York 36077 84 6
293588 293588 2020-07-03 Putnam New York 36079 1333 61
293589 293589 2020-07-03 Rensselaer New York 36083 559 37
293590 293590 2020-07-03 Rockland New York 36087 13623 469
293591 293591 2020-07-03 Saratoga New York 36091 561 5
293592 293592 2020-07-03 Schenectady New York 36093 824 34
293593 293593 2020-07-03 Schoharie New York 36095 58 0
293594 293594 2020-07-03 Schuyler New York 36097 13 0
293595 293595 2020-07-03 Seneca New York 36099 70 0
293596 293596 2020-07-03 St. Lawrence New York 36089 222 3
293597 293597 2020-07-03 Steuben New York 36101 268 19
293598 293598 2020-07-03 Suffolk New York 36103 41538 2029
293599 293599 2020-07-03 Sullivan New York 36105 1455 31
293600 293600 2020-07-03 Tioga New York 36107 143 18
293601 293601 2020-07-03 Tompkins New York 36109 178 2
293602 293602 2020-07-03 Ulster New York 36111 1815 49
293603 293603 2020-07-03 Warren New York 36113 266 31
293604 293604 2020-07-03 Washington New York 36115 246 11
293605 293605 2020-07-03 Wayne New York 36117 181 1
293606 293606 2020-07-03 Westchester New York 36119 34979 1558
293607 293607 2020-07-03 Wyoming New York 36121 95 3
293608 293608 2020-07-03 Yates New York 36123 46 6
290470 290470 2020-07-02 Albany New York 36001 2125 160
290471 290471 2020-07-02 Allegany New York 36003 62 0
290472 290472 2020-07-02 Broome New York 36007 729 62
290473 290473 2020-07-02 Cattaraugus New York 36009 124 5
290474 290474 2020-07-02 Cayuga New York 36011 119 1
290475 290475 2020-07-02 Chautauqua New York 36013 127 4
290476 290476 2020-07-02 Chemung New York 36015 144 5
290477 290477 2020-07-02 Chenango New York 36017 148 3
290478 290478 2020-07-02 Clinton New York 36019 101 4
290479 290479 2020-07-02 Columbia New York 36021 472 43
290480 290480 2020-07-02 Cortland New York 36023 47 0
290481 290481 2020-07-02 Delaware New York 36025 91 0
290482 290482 2020-07-02 Dutchess New York 36027 4225 159
290483 290483 2020-07-02 Erie New York 36029 7370 598
290484 290484 2020-07-02 Essex New York 36031 50 0
290485 290485 2020-07-02 Franklin New York 36033 32 0
290486 290486 2020-07-02 Fulton New York 36035 260 18
290487 290487 2020-07-02 Genesee New York 36037 238 6
290488 290488 2020-07-02 Greene New York 36039 260 5
290489 290489 2020-07-02 Hamilton New York 36041 6 0
290490 290490 2020-07-02 Herkimer New York 36043 164 1
290491 290491 2020-07-02 Jefferson New York 36045 90 0
290492 290492 2020-07-02 Lewis New York 36049 30 0
290493 290493 2020-07-02 Livingston New York 36051 130 4
290494 290494 2020-07-02 Madison New York 36053 359 4
290495 290495 2020-07-02 Monroe New York 36055 3834 262
290496 290496 2020-07-02 Montgomery New York 36057 119 5
290497 290497 2020-07-02 Nassau New York 36059 41910 2695
290498 290498 2020-07-02 New York City New York   220567 22593
290499 290499 2020-07-02 Niagara New York 36063 1248 66
290500 290500 2020-07-02 Oneida New York 36065 1672 93
290501 290501 2020-07-02 Onondaga New York 36067 2897 178
290502 290502 2020-07-02 Ontario New York 36069 268 25
290503 290503 2020-07-02 Orange New York 36071 10759 401
290504 290504 2020-07-02 Orleans New York 36073 282 41
290505 290505 2020-07-02 Oswego New York 36075 206 0
290506 290506 2020-07-02 Otsego New York 36077 84 6
290507 290507 2020-07-02 Putnam New York 36079 1332 61
290508 290508 2020-07-02 Rensselaer New York 36083 556 37
290509 290509 2020-07-02 Rockland New York 36087 13612 469
290510 290510 2020-07-02 Saratoga New York 36091 555 5
290511 290511 2020-07-02 Schenectady New York 36093 816 34

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
);
Powered by Datasette · Query took 965.481ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette