ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,692 rows where state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- New York City 704
- Westchester 702
- Nassau 700
- Rockland 699
- Saratoga 698
- Ulster 698
- Suffolk 697
- Monroe 694
- Albany 693
- Delaware 693
- Dutchess 693
- Herkimer 693
- Orange 693
- Schenectady 692
- Tioga 692
- Tompkins 692
- Broome 691
- Erie 690
- Greene 690
- Montgomery 690
- Putnam 690
- Allegany 689
- Onondaga 689
- Ontario 689
- Wyoming 689
- Clinton 688
- Rensselaer 688
- Sullivan 688
- Warren 688
- Washington 688
- …
state 1
- New York · 39,901 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179344 | 2179344 | 2022-02-03 | Tioga | New York | 36107 | 10119 | 81 |
2179345 | 2179345 | 2022-02-03 | Tompkins | New York | 36109 | 16534 | 77 |
2179346 | 2179346 | 2022-02-03 | Ulster | New York | 36111 | 29926 | 347 |
2179347 | 2179347 | 2022-02-03 | Warren | New York | 36113 | 12743 | 116 |
2179348 | 2179348 | 2022-02-03 | Washington | New York | 36115 | 11388 | 107 |
2179349 | 2179349 | 2022-02-03 | Wayne | New York | 36117 | 16306 | 159 |
2179350 | 2179350 | 2022-02-03 | Westchester | New York | 36119 | 242887 | 2632 |
2179351 | 2179351 | 2022-02-03 | Wyoming | New York | 36121 | 8038 | 80 |
2179352 | 2179352 | 2022-02-03 | Yates | New York | 36123 | 3170 | 37 |
2176044 | 2176044 | 2022-02-02 | Albany | New York | 36001 | 55897 | 484 |
2176045 | 2176045 | 2022-02-02 | Allegany | New York | 36003 | 8362 | 144 |
2176046 | 2176046 | 2022-02-02 | Broome | New York | 36007 | 42592 | 493 |
2176047 | 2176047 | 2022-02-02 | Cattaraugus | New York | 36009 | 14575 | 206 |
2176048 | 2176048 | 2022-02-02 | Cayuga | New York | 36011 | 15089 | 133 |
2176049 | 2176049 | 2022-02-02 | Chautauqua | New York | 36013 | 22553 | 255 |
2176050 | 2176050 | 2022-02-02 | Chemung | New York | 36015 | 20254 | 220 |
2176051 | 2176051 | 2022-02-02 | Chenango | New York | 36017 | 8685 | 114 |
2176052 | 2176052 | 2022-02-02 | Clinton | New York | 36019 | 15012 | 68 |
2176053 | 2176053 | 2022-02-02 | Columbia | New York | 36021 | 9486 | 135 |
2176054 | 2176054 | 2022-02-02 | Cortland | New York | 36023 | 9855 | 108 |
2176055 | 2176055 | 2022-02-02 | Delaware | New York | 36025 | 7245 | 67 |
2176056 | 2176056 | 2022-02-02 | Dutchess | New York | 36027 | 61839 | 615 |
2176057 | 2176057 | 2022-02-02 | Erie | New York | 36029 | 200898 | 2481 |
2176058 | 2176058 | 2022-02-02 | Essex | New York | 36031 | 5147 | 52 |
2176059 | 2176059 | 2022-02-02 | Franklin | New York | 36033 | 8474 | 40 |
2176060 | 2176060 | 2022-02-02 | Fulton | New York | 36035 | 11740 | 154 |
2176061 | 2176061 | 2022-02-02 | Genesee | New York | 36037 | 13207 | 177 |
2176062 | 2176062 | 2022-02-02 | Greene | New York | 36039 | 8167 | 112 |
2176063 | 2176063 | 2022-02-02 | Hamilton | New York | 36041 | 791 | 5 |
2176064 | 2176064 | 2022-02-02 | Herkimer | New York | 36043 | 13071 | 181 |
2176065 | 2176065 | 2022-02-02 | Jefferson | New York | 36045 | 18626 | 125 |
2176066 | 2176066 | 2022-02-02 | Lewis | New York | 36049 | 5893 | 45 |
2176067 | 2176067 | 2022-02-02 | Livingston | New York | 36051 | 11062 | 104 |
2176068 | 2176068 | 2022-02-02 | Madison | New York | 36053 | 12115 | 120 |
2176069 | 2176069 | 2022-02-02 | Monroe | New York | 36055 | 145885 | 1481 |
2176070 | 2176070 | 2022-02-02 | Montgomery | New York | 36057 | 11198 | 187 |
2176071 | 2176071 | 2022-02-02 | Nassau | New York | 36059 | 392191 | 3727 |
2176072 | 2176072 | 2022-02-02 | New York City | New York | 2239366 | 38569 | |
2176073 | 2176073 | 2022-02-02 | Niagara | New York | 36063 | 46080 | 539 |
2176074 | 2176074 | 2022-02-02 | Oneida | New York | 36065 | 50346 | 750 |
2176075 | 2176075 | 2022-02-02 | Onondaga | New York | 36067 | 102848 | 980 |
2176076 | 2176076 | 2022-02-02 | Ontario | New York | 36069 | 18688 | 166 |
2176077 | 2176077 | 2022-02-02 | Orange | New York | 36071 | 103350 | 916 |
2176078 | 2176078 | 2022-02-02 | Orleans | New York | 36073 | 8314 | 107 |
2176079 | 2176079 | 2022-02-02 | Oswego | New York | 36075 | 23537 | 162 |
2176080 | 2176080 | 2022-02-02 | Otsego | New York | 36077 | 9155 | 81 |
2176081 | 2176081 | 2022-02-02 | Putnam | New York | 36079 | 22878 | 118 |
2176082 | 2176082 | 2022-02-02 | Rensselaer | New York | 36083 | 29572 | 237 |
2176083 | 2176083 | 2022-02-02 | Rockland | New York | 36087 | 89813 | 881 |
2176084 | 2176084 | 2022-02-02 | Saratoga | New York | 36091 | 43365 | 306 |
2176085 | 2176085 | 2022-02-02 | Schenectady | New York | 36093 | 31226 | 286 |
2176086 | 2176086 | 2022-02-02 | Schoharie | New York | 36095 | 4688 | 33 |
2176087 | 2176087 | 2022-02-02 | Schuyler | New York | 36097 | 3243 | 23 |
2176088 | 2176088 | 2022-02-02 | Seneca | New York | 36099 | 5449 | 88 |
2176089 | 2176089 | 2022-02-02 | St. Lawrence | New York | 36089 | 19243 | 167 |
2176090 | 2176090 | 2022-02-02 | Steuben | New York | 36101 | 18629 | 233 |
2176091 | 2176091 | 2022-02-02 | Suffolk | New York | 36103 | 416562 | 4224 |
2176092 | 2176092 | 2022-02-02 | Sullivan | New York | 36105 | 17676 | 119 |
2176093 | 2176093 | 2022-02-02 | Tioga | New York | 36107 | 10079 | 81 |
2176094 | 2176094 | 2022-02-02 | Tompkins | New York | 36109 | 16468 | 77 |
2176095 | 2176095 | 2022-02-02 | Ulster | New York | 36111 | 29820 | 346 |
2176096 | 2176096 | 2022-02-02 | Warren | New York | 36113 | 12684 | 116 |
2176097 | 2176097 | 2022-02-02 | Washington | New York | 36115 | 11325 | 106 |
2176098 | 2176098 | 2022-02-02 | Wayne | New York | 36117 | 16252 | 158 |
2176099 | 2176099 | 2022-02-02 | Westchester | New York | 36119 | 242592 | 2627 |
2176100 | 2176100 | 2022-02-02 | Wyoming | New York | 36121 | 8018 | 80 |
2176101 | 2176101 | 2022-02-02 | Yates | New York | 36123 | 3153 | 37 |
2172791 | 2172791 | 2022-02-01 | Albany | New York | 36001 | 55698 | 481 |
2172792 | 2172792 | 2022-02-01 | Allegany | New York | 36003 | 8337 | 144 |
2172793 | 2172793 | 2022-02-01 | Broome | New York | 36007 | 42441 | 492 |
2172794 | 2172794 | 2022-02-01 | Cattaraugus | New York | 36009 | 14517 | 205 |
2172795 | 2172795 | 2022-02-01 | Cayuga | New York | 36011 | 15043 | 132 |
2172796 | 2172796 | 2022-02-01 | Chautauqua | New York | 36013 | 22476 | 255 |
2172797 | 2172797 | 2022-02-01 | Chemung | New York | 36015 | 20183 | 219 |
2172798 | 2172798 | 2022-02-01 | Chenango | New York | 36017 | 8644 | 113 |
2172799 | 2172799 | 2022-02-01 | Clinton | New York | 36019 | 14918 | 67 |
2172800 | 2172800 | 2022-02-01 | Columbia | New York | 36021 | 9460 | 132 |
2172801 | 2172801 | 2022-02-01 | Cortland | New York | 36023 | 9821 | 106 |
2172802 | 2172802 | 2022-02-01 | Delaware | New York | 36025 | 7223 | 66 |
2172803 | 2172803 | 2022-02-01 | Dutchess | New York | 36027 | 61735 | 611 |
2172804 | 2172804 | 2022-02-01 | Erie | New York | 36029 | 200464 | 2471 |
2172805 | 2172805 | 2022-02-01 | Essex | New York | 36031 | 5133 | 52 |
2172806 | 2172806 | 2022-02-01 | Franklin | New York | 36033 | 8426 | 40 |
2172807 | 2172807 | 2022-02-01 | Fulton | New York | 36035 | 11689 | 154 |
2172808 | 2172808 | 2022-02-01 | Genesee | New York | 36037 | 13179 | 177 |
2172809 | 2172809 | 2022-02-01 | Greene | New York | 36039 | 8147 | 112 |
2172810 | 2172810 | 2022-02-01 | Hamilton | New York | 36041 | 787 | 5 |
2172811 | 2172811 | 2022-02-01 | Herkimer | New York | 36043 | 13010 | 179 |
2172812 | 2172812 | 2022-02-01 | Jefferson | New York | 36045 | 18526 | 125 |
2172813 | 2172813 | 2022-02-01 | Lewis | New York | 36049 | 5869 | 45 |
2172814 | 2172814 | 2022-02-01 | Livingston | New York | 36051 | 11030 | 102 |
2172815 | 2172815 | 2022-02-01 | Madison | New York | 36053 | 12058 | 120 |
2172816 | 2172816 | 2022-02-01 | Monroe | New York | 36055 | 145576 | 1476 |
2172817 | 2172817 | 2022-02-01 | Montgomery | New York | 36057 | 11151 | 187 |
2172818 | 2172818 | 2022-02-01 | Nassau | New York | 36059 | 391526 | 3715 |
2172819 | 2172819 | 2022-02-01 | New York City | New York | 2237114 | 38469 | |
2172820 | 2172820 | 2022-02-01 | Niagara | New York | 36063 | 45951 | 535 |
2172821 | 2172821 | 2022-02-01 | Oneida | New York | 36065 | 50172 | 750 |
2172822 | 2172822 | 2022-02-01 | Onondaga | New York | 36067 | 102348 | 975 |
2172823 | 2172823 | 2022-02-01 | Ontario | New York | 36069 | 18622 | 166 |
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);