ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-12-13" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Albany 1
- Allegany 1
- Broome 1
- Cattaraugus 1
- Cayuga 1
- Chautauqua 1
- Chemung 1
- Chenango 1
- Clinton 1
- Columbia 1
- Cortland 1
- Delaware 1
- Dutchess 1
- Erie 1
- Essex 1
- Franklin 1
- Fulton 1
- Genesee 1
- Greene 1
- Hamilton 1
- Herkimer 1
- Jefferson 1
- Lewis 1
- Livingston 1
- Madison 1
- Monroe 1
- Montgomery 1
- Nassau 1
- New York City 1
- Niagara 1
- …
state 1
- New York · 58 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
824922 | 824922 | 2020-12-13 | Albany | New York | 36001 | 7888 | 167 |
824923 | 824923 | 2020-12-13 | Allegany | New York | 36003 | 1395 | 64 |
824924 | 824924 | 2020-12-13 | Broome | New York | 36007 | 6460 | 176 |
824925 | 824925 | 2020-12-13 | Cattaraugus | New York | 36009 | 1762 | 29 |
824926 | 824926 | 2020-12-13 | Cayuga | New York | 36011 | 1544 | 13 |
824927 | 824927 | 2020-12-13 | Chautauqua | New York | 36013 | 2323 | 11 |
824928 | 824928 | 2020-12-13 | Chemung | New York | 36015 | 3743 | 70 |
824929 | 824929 | 2020-12-13 | Chenango | New York | 36017 | 868 | 13 |
824930 | 824930 | 2020-12-13 | Clinton | New York | 36019 | 657 | 5 |
824931 | 824931 | 2020-12-13 | Columbia | New York | 36021 | 1204 | 58 |
824932 | 824932 | 2020-12-13 | Cortland | New York | 36023 | 1478 | 6 |
824933 | 824933 | 2020-12-13 | Delaware | New York | 36025 | 512 | 7 |
824934 | 824934 | 2020-12-13 | Dutchess | New York | 36027 | 9146 | 206 |
824935 | 824935 | 2020-12-13 | Erie | New York | 36029 | 33009 | 965 |
824936 | 824936 | 2020-12-13 | Essex | New York | 36031 | 381 | 14 |
824937 | 824937 | 2020-12-13 | Franklin | New York | 36033 | 443 | 9 |
824938 | 824938 | 2020-12-13 | Fulton | New York | 36035 | 825 | 29 |
824939 | 824939 | 2020-12-13 | Genesee | New York | 36037 | 1602 | 19 |
824940 | 824940 | 2020-12-13 | Greene | New York | 36039 | 870 | 18 |
824941 | 824941 | 2020-12-13 | Hamilton | New York | 36041 | 68 | 1 |
824942 | 824942 | 2020-12-13 | Herkimer | New York | 36043 | 1163 | 13 |
824943 | 824943 | 2020-12-13 | Jefferson | New York | 36045 | 1010 | 5 |
824944 | 824944 | 2020-12-13 | Lewis | New York | 36049 | 567 | 9 |
824945 | 824945 | 2020-12-13 | Livingston | New York | 36051 | 1111 | 19 |
824946 | 824946 | 2020-12-13 | Madison | New York | 36053 | 1572 | 23 |
824947 | 824947 | 2020-12-13 | Monroe | New York | 36055 | 23204 | 363 |
824948 | 824948 | 2020-12-13 | Montgomery | New York | 36057 | 766 | 20 |
824949 | 824949 | 2020-12-13 | Nassau | New York | 36059 | 70475 | 2297 |
824950 | 824950 | 2020-12-13 | New York City | New York | 360700 | 24501 | |
824951 | 824951 | 2020-12-13 | Niagara | New York | 36063 | 5906 | 134 |
824952 | 824952 | 2020-12-13 | Oneida | New York | 36065 | 7844 | 188 |
824953 | 824953 | 2020-12-13 | Onondaga | New York | 36067 | 15182 | 277 |
824954 | 824954 | 2020-12-13 | Ontario | New York | 36069 | 2053 | 36 |
824955 | 824955 | 2020-12-13 | Orange | New York | 36071 | 19551 | 464 |
824956 | 824956 | 2020-12-13 | Orleans | New York | 36073 | 860 | 59 |
824957 | 824957 | 2020-12-13 | Oswego | New York | 36075 | 2389 | 19 |
824958 | 824958 | 2020-12-13 | Otsego | New York | 36077 | 882 | 5 |
824959 | 824959 | 2020-12-13 | Putnam | New York | 36079 | 3743 | 66 |
824960 | 824960 | 2020-12-13 | Rensselaer | New York | 36083 | 2569 | 67 |
824961 | 824961 | 2020-12-13 | Rockland | New York | 36087 | 23991 | 547 |
824962 | 824962 | 2020-12-13 | Saratoga | New York | 36091 | 3366 | 24 |
824963 | 824963 | 2020-12-13 | Schenectady | New York | 36093 | 3668 | 62 |
824964 | 824964 | 2020-12-13 | Schoharie | New York | 36095 | 326 | 2 |
824965 | 824965 | 2020-12-13 | Schuyler | New York | 36097 | 383 | 5 |
824966 | 824966 | 2020-12-13 | Seneca | New York | 36099 | 482 | 12 |
824967 | 824967 | 2020-12-13 | St. Lawrence | New York | 36089 | 1339 | 25 |
824968 | 824968 | 2020-12-13 | Steuben | New York | 36101 | 2408 | 99 |
824969 | 824969 | 2020-12-13 | Suffolk | New York | 36103 | 74367 | 2113 |
824970 | 824970 | 2020-12-13 | Sullivan | New York | 36105 | 2455 | 40 |
824971 | 824971 | 2020-12-13 | Tioga | New York | 36107 | 1367 | 52 |
824972 | 824972 | 2020-12-13 | Tompkins | New York | 36109 | 1556 | 6 |
824973 | 824973 | 2020-12-13 | Ulster | New York | 36111 | 4327 | 116 |
824974 | 824974 | 2020-12-13 | Warren | New York | 36113 | 754 | 30 |
824975 | 824975 | 2020-12-13 | Washington | New York | 36115 | 574 | 14 |
824976 | 824976 | 2020-12-13 | Wayne | New York | 36117 | 1662 | 25 |
824977 | 824977 | 2020-12-13 | Westchester | New York | 36119 | 58836 | 1562 |
824978 | 824978 | 2020-12-13 | Wyoming | New York | 36121 | 883 | 12 |
824979 | 824979 | 2020-12-13 | Yates | New York | 36123 | 362 | 7 |
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]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);