ny_times_us_counties
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
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
fips
county
- New York City 328
- Westchester 325
- Nassau 324
- Rockland 323
- Saratoga 322
- Suffolk 321
- Ulster 321
- Monroe 318
- Albany 317
- Delaware 317
- Dutchess 317
- Herkimer 317
- Orange 317
- Schenectady 316
- Broome 315
- Tioga 315
- Tompkins 315
- Erie 314
- Greene 314
- Montgomery 314
- Putnam 314
- Allegany 313
- Onondaga 313
- Ontario 313
- Clinton 312
- Rensselaer 312
- Sullivan 312
- Wyoming 312
- Chenango 311
- Essex 311
- ...
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]);