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

18,084 rows where state = "New York" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • New York · 18,084 ✖
Link rowid date ▲ county state fips cases deaths
954817 954817 2021-01-22 Albany New York 36001 17045 266
954818 954818 2021-01-22 Allegany New York 36003 2413 75
954819 954819 2021-01-22 Broome New York 36007 11657 269
954820 954820 2021-01-22 Cattaraugus New York 36009 3528 62
954821 954821 2021-01-22 Cayuga New York 36011 4608 74
954822 954822 2021-01-22 Chautauqua New York 36013 5844 70
954823 954823 2021-01-22 Chemung New York 36015 5739 109
954824 954824 2021-01-22 Chenango New York 36017 1850 44
954825 954825 2021-01-22 Clinton New York 36019 2317 18
954826 954826 2021-01-22 Columbia New York 36021 2645 73
954827 954827 2021-01-22 Cortland New York 36023 2710 54
954828 954828 2021-01-22 Delaware New York 36025 1067 27
954829 954829 2021-01-22 Dutchess New York 36027 17424 330
954830 954830 2021-01-22 Erie New York 36029 53605 1407
954831 954831 2021-01-22 Essex New York 36031 1025 21
954832 954832 2021-01-22 Franklin New York 36033 1269 9
954833 954833 2021-01-22 Fulton New York 36035 2241 55
954834 954834 2021-01-22 Genesee New York 36037 3803 101
954835 954835 2021-01-22 Greene New York 36039 2140 63
954836 954836 2021-01-22 Hamilton New York 36041 161 1
954837 954837 2021-01-22 Herkimer New York 36043 3839 67
954838 954838 2021-01-22 Jefferson New York 36045 3388 27
954839 954839 2021-01-22 Lewis New York 36049 1582 24
954840 954840 2021-01-22 Livingston New York 36051 2815 42
954841 954841 2021-01-22 Madison New York 36053 3243 76
954842 954842 2021-01-22 Monroe New York 36055 45401 804
954843 954843 2021-01-22 Montgomery New York 36057 2342 77
954844 954844 2021-01-22 Nassau New York 36059 118735 2597
954845 954845 2021-01-22 New York City New York   558262 26398
954846 954846 2021-01-22 Niagara New York 36063 12602 251
954847 954847 2021-01-22 Oneida New York 36065 17346 369
954848 954848 2021-01-22 Onondaga New York 36067 28476 541
954849 954849 2021-01-22 Ontario New York 36069 4855 83
954850 954850 2021-01-22 Orange New York 36071 29768 575
954851 954851 2021-01-22 Orleans New York 36073 2003 71
954852 954852 2021-01-22 Oswego New York 36075 5059 74
954853 954853 2021-01-22 Otsego New York 36077 1803 24
954854 954854 2021-01-22 Putnam New York 36079 6748 75
954855 954855 2021-01-22 Rensselaer New York 36083 7262 109
954856 954856 2021-01-22 Rockland New York 36087 32660 631
954857 954857 2021-01-22 Saratoga New York 36091 9689 86
954858 954858 2021-01-22 Schenectady New York 36093 9021 135
954859 954859 2021-01-22 Schoharie New York 36095 943 6
954860 954860 2021-01-22 Schuyler New York 36097 745 10
954861 954861 2021-01-22 Seneca New York 36099 1276 47
954862 954862 2021-01-22 St. Lawrence New York 36089 3855 63
954863 954863 2021-01-22 Steuben New York 36101 4719 131
954864 954864 2021-01-22 Suffolk New York 36103 132748 2661
954865 954865 2021-01-22 Sullivan New York 36105 3954 49
954866 954866 2021-01-22 Tioga New York 36107 2294 54
954867 954867 2021-01-22 Tompkins New York 36109 2779 25
954868 954868 2021-01-22 Ulster New York 36111 8017 199
954869 954869 2021-01-22 Warren New York 36113 2201 42
954870 954870 2021-01-22 Washington New York 36115 1612 27
954871 954871 2021-01-22 Wayne New York 36117 3811 56
954872 954872 2021-01-22 Westchester New York 36119 87569 1832
954873 954873 2021-01-22 Wyoming New York 36121 2284 44
954874 954874 2021-01-22 Yates New York 36123 863 20
951572 951572 2021-01-21 Albany New York 36001 16788 263
951573 951573 2021-01-21 Allegany New York 36003 2394 75
951574 951574 2021-01-21 Broome New York 36007 11467 263
951575 951575 2021-01-21 Cattaraugus New York 36009 3462 61
951576 951576 2021-01-21 Cayuga New York 36011 4558 74
951577 951577 2021-01-21 Chautauqua New York 36013 5742 66
951578 951578 2021-01-21 Chemung New York 36015 5689 109
951579 951579 2021-01-21 Chenango New York 36017 1821 44
951580 951580 2021-01-21 Clinton New York 36019 2264 18
951581 951581 2021-01-21 Columbia New York 36021 2578 73
951582 951582 2021-01-21 Cortland New York 36023 2696 54
951583 951583 2021-01-21 Delaware New York 36025 1044 25
951584 951584 2021-01-21 Dutchess New York 36027 17182 324
951585 951585 2021-01-21 Erie New York 36029 53064 1401
951586 951586 2021-01-21 Essex New York 36031 1005 19
951587 951587 2021-01-21 Franklin New York 36033 1202 9
951588 951588 2021-01-21 Fulton New York 36035 2190 54
951589 951589 2021-01-21 Genesee New York 36037 3752 101
951590 951590 2021-01-21 Greene New York 36039 2097 61
951591 951591 2021-01-21 Hamilton New York 36041 150 1
951592 951592 2021-01-21 Herkimer New York 36043 3743 64
951593 951593 2021-01-21 Jefferson New York 36045 3331 25
951594 951594 2021-01-21 Lewis New York 36049 1558 24
951595 951595 2021-01-21 Livingston New York 36051 2767 42
951596 951596 2021-01-21 Madison New York 36053 3209 76
951597 951597 2021-01-21 Monroe New York 36055 45003 791
951598 951598 2021-01-21 Montgomery New York 36057 2298 77
951599 951599 2021-01-21 Nassau New York 36059 117371 2589
951600 951600 2021-01-21 New York City New York   551415 26331
951601 951601 2021-01-21 Niagara New York 36063 12410 251
951602 951602 2021-01-21 Oneida New York 36065 17167 358
951603 951603 2021-01-21 Onondaga New York 36067 28226 537
951604 951604 2021-01-21 Ontario New York 36069 4815 83
951605 951605 2021-01-21 Orange New York 36071 29421 574
951606 951606 2021-01-21 Orleans New York 36073 1968 71
951607 951607 2021-01-21 Oswego New York 36075 5012 71
951608 951608 2021-01-21 Otsego New York 36077 1779 23
951609 951609 2021-01-21 Putnam New York 36079 6670 75
951610 951610 2021-01-21 Rensselaer New York 36083 7112 108
951611 951611 2021-01-21 Rockland New York 36087 32407 629
951612 951612 2021-01-21 Saratoga New York 36091 9527 84
951613 951613 2021-01-21 Schenectady New York 36093 8869 134

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