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)
county 59
- New York City 471
- Westchester 468
- Nassau 467
- Rockland 466
- Saratoga 465
- Suffolk 464
- Ulster 464
- Monroe 461
- Albany 460
- Delaware 460
- Dutchess 460
- Herkimer 460
- Orange 460
- Schenectady 459
- Broome 458
- Tioga 458
- Tompkins 458
- Erie 457
- Greene 457
- Montgomery 457
- Putnam 457
- Allegany 456
- Onondaga 456
- Ontario 456
- Clinton 455
- Rensselaer 455
- Sullivan 455
- Wyoming 455
- Chenango 454
- Essex 454
- Hamilton 454
- Jefferson 454
- Livingston 454
- Warren 454
- Washington 454
- Schoharie 453
- Wayne 453
- Columbia 452
- Fulton 452
- Genesee 452
- Niagara 452
- Oneida 452
- Steuben 451
- Cortland 450
- Madison 450
- St. Lawrence 450
- Cayuga 449
- Oswego 449
- Otsego 449
- Chemung 448
- Orleans 448
- Chautauqua 447
- Franklin 447
- Cattaraugus 444
- Schuyler 444
- Lewis 443
- Seneca 441
- Yates 439
- Unknown 10
fips 58
- - 481
- 36119 468
- 36059 467
- 36087 466
- 36091 465
- 36103 464
- 36111 464
- 36055 461
- 36001 460
- 36025 460
- 36027 460
- 36043 460
- 36071 460
- 36093 459
- 36007 458
- 36107 458
- 36109 458
- 36029 457
- 36039 457
- 36057 457
- 36079 457
- 36003 456
- 36067 456
- 36069 456
- 36019 455
- 36083 455
- 36105 455
- 36121 455
- 36017 454
- 36031 454
- 36041 454
- 36045 454
- 36051 454
- 36113 454
- 36115 454
- 36095 453
- 36117 453
- 36021 452
- 36035 452
- 36037 452
- 36063 452
- 36065 452
- 36101 451
- 36023 450
- 36053 450
- 36089 450
- 36011 449
- 36075 449
- 36077 449
- 36015 448
- 36073 448
- 36013 447
- 36033 447
- 36009 444
- 36097 444
- 36049 443
- 36099 441
- 36123 439
state 1
- New York · 26,378 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418974 | 1418974 | 2021-06-14 | Albany | New York | 36001 | 24696 | 356 |
1418975 | 1418975 | 2021-06-14 | Allegany | New York | 36003 | 3555 | 87 |
1418976 | 1418976 | 2021-06-14 | Broome | New York | 36007 | 18619 | 366 |
1418977 | 1418977 | 2021-06-14 | Cattaraugus | New York | 36009 | 5720 | 91 |
1418978 | 1418978 | 2021-06-14 | Cayuga | New York | 36011 | 6337 | 92 |
1418979 | 1418979 | 2021-06-14 | Chautauqua | New York | 36013 | 8951 | 145 |
1418980 | 1418980 | 2021-06-14 | Chemung | New York | 36015 | 7759 | 136 |
1418981 | 1418981 | 2021-06-14 | Chenango | New York | 36017 | 3498 | 76 |
1418982 | 1418982 | 2021-06-14 | Clinton | New York | 36019 | 4835 | 33 |
1418983 | 1418983 | 2021-06-14 | Columbia | New York | 36021 | 4064 | 104 |
1418984 | 1418984 | 2021-06-14 | Cortland | New York | 36023 | 3925 | 62 |
1418985 | 1418985 | 2021-06-14 | Delaware | New York | 36025 | 2379 | 38 |
1418986 | 1418986 | 2021-06-14 | Dutchess | New York | 36027 | 29470 | 445 |
1418987 | 1418987 | 2021-06-14 | Erie | New York | 36029 | 89572 | 1806 |
1418988 | 1418988 | 2021-06-14 | Essex | New York | 36031 | 1601 | 26 |
1418989 | 1418989 | 2021-06-14 | Franklin | New York | 36033 | 2563 | 12 |
1418990 | 1418990 | 2021-06-14 | Fulton | New York | 36035 | 4421 | 91 |
1418991 | 1418991 | 2021-06-14 | Genesee | New York | 36037 | 5435 | 124 |
1418992 | 1418992 | 2021-06-14 | Greene | New York | 36039 | 3403 | 79 |
1418993 | 1418993 | 2021-06-14 | Hamilton | New York | 36041 | 313 | 2 |
1418994 | 1418994 | 2021-06-14 | Herkimer | New York | 36043 | 5186 | 109 |
1418995 | 1418995 | 2021-06-14 | Jefferson | New York | 36045 | 6131 | 68 |
1418996 | 1418996 | 2021-06-14 | Lewis | New York | 36049 | 2808 | 36 |
1418997 | 1418997 | 2021-06-14 | Livingston | New York | 36051 | 4520 | 60 |
1418998 | 1418998 | 2021-06-14 | Madison | New York | 36053 | 4562 | 89 |
1418999 | 1418999 | 2021-06-14 | Monroe | New York | 36055 | 68960 | 1110 |
1419000 | 1419000 | 2021-06-14 | Montgomery | New York | 36057 | 4254 | 126 |
1419001 | 1419001 | 2021-06-14 | Nassau | New York | 36059 | 183624 | 3175 |
1419002 | 1419002 | 2021-06-14 | New York City | New York | 952772 | 33348 | |
1419003 | 1419003 | 2021-06-14 | Niagara | New York | 36063 | 20033 | 372 |
1419004 | 1419004 | 2021-06-14 | Oneida | New York | 36065 | 22614 | 514 |
1419005 | 1419005 | 2021-06-14 | Onondaga | New York | 36067 | 38928 | 677 |
1419006 | 1419006 | 2021-06-14 | Ontario | New York | 36069 | 7405 | 93 |
1419007 | 1419007 | 2021-06-14 | Orange | New York | 36071 | 48323 | 720 |
1419008 | 1419008 | 2021-06-14 | Orleans | New York | 36073 | 3118 | 83 |
1419009 | 1419009 | 2021-06-14 | Oswego | New York | 36075 | 7622 | 92 |
1419010 | 1419010 | 2021-06-14 | Otsego | New York | 36077 | 3461 | 47 |
1419011 | 1419011 | 2021-06-14 | Putnam | New York | 36079 | 10605 | 92 |
1419012 | 1419012 | 2021-06-14 | Rensselaer | New York | 36083 | 11228 | 142 |
1419013 | 1419013 | 2021-06-14 | Rockland | New York | 36087 | 46936 | 754 |
1419014 | 1419014 | 2021-06-14 | Saratoga | New York | 36091 | 15362 | 168 |
1419015 | 1419015 | 2021-06-14 | Schenectady | New York | 36093 | 13200 | 205 |
1419016 | 1419016 | 2021-06-14 | Schoharie | New York | 36095 | 1692 | 17 |
1419017 | 1419017 | 2021-06-14 | Schuyler | New York | 36097 | 1074 | 14 |
1419018 | 1419018 | 2021-06-14 | Seneca | New York | 36099 | 2011 | 56 |
1419019 | 1419019 | 2021-06-14 | St. Lawrence | New York | 36089 | 6637 | 96 |
1419020 | 1419020 | 2021-06-14 | Steuben | New York | 36101 | 6952 | 144 |
1419021 | 1419021 | 2021-06-14 | Suffolk | New York | 36103 | 201008 | 3400 |
1419022 | 1419022 | 2021-06-14 | Sullivan | New York | 36105 | 6672 | 76 |
1419023 | 1419023 | 2021-06-14 | Tioga | New York | 36107 | 3829 | 63 |
1419024 | 1419024 | 2021-06-14 | Tompkins | New York | 36109 | 4346 | 52 |
1419025 | 1419025 | 2021-06-14 | Ulster | New York | 36111 | 13907 | 257 |
1419026 | 1419026 | 2021-06-14 | Warren | New York | 36113 | 3658 | 57 |
1419027 | 1419027 | 2021-06-14 | Washington | New York | 36115 | 3161 | 55 |
1419028 | 1419028 | 2021-06-14 | Wayne | New York | 36117 | 5782 | 70 |
1419029 | 1419029 | 2021-06-14 | Westchester | New York | 36119 | 129656 | 2290 |
1419030 | 1419030 | 2021-06-14 | Wyoming | New York | 36121 | 3581 | 53 |
1419031 | 1419031 | 2021-06-14 | Yates | New York | 36123 | 1178 | 26 |
1415729 | 1415729 | 2021-06-13 | Albany | New York | 36001 | 24694 | 356 |
1415730 | 1415730 | 2021-06-13 | Allegany | New York | 36003 | 3555 | 87 |
1415731 | 1415731 | 2021-06-13 | Broome | New York | 36007 | 18616 | 366 |
1415732 | 1415732 | 2021-06-13 | Cattaraugus | New York | 36009 | 5720 | 91 |
1415733 | 1415733 | 2021-06-13 | Cayuga | New York | 36011 | 6337 | 92 |
1415734 | 1415734 | 2021-06-13 | Chautauqua | New York | 36013 | 8950 | 145 |
1415735 | 1415735 | 2021-06-13 | Chemung | New York | 36015 | 7758 | 136 |
1415736 | 1415736 | 2021-06-13 | Chenango | New York | 36017 | 3498 | 76 |
1415737 | 1415737 | 2021-06-13 | Clinton | New York | 36019 | 4835 | 33 |
1415738 | 1415738 | 2021-06-13 | Columbia | New York | 36021 | 4064 | 104 |
1415739 | 1415739 | 2021-06-13 | Cortland | New York | 36023 | 3925 | 62 |
1415740 | 1415740 | 2021-06-13 | Delaware | New York | 36025 | 2379 | 38 |
1415741 | 1415741 | 2021-06-13 | Dutchess | New York | 36027 | 29468 | 445 |
1415742 | 1415742 | 2021-06-13 | Erie | New York | 36029 | 89564 | 1806 |
1415743 | 1415743 | 2021-06-13 | Essex | New York | 36031 | 1601 | 26 |
1415744 | 1415744 | 2021-06-13 | Franklin | New York | 36033 | 2561 | 12 |
1415745 | 1415745 | 2021-06-13 | Fulton | New York | 36035 | 4421 | 91 |
1415746 | 1415746 | 2021-06-13 | Genesee | New York | 36037 | 5435 | 124 |
1415747 | 1415747 | 2021-06-13 | Greene | New York | 36039 | 3402 | 79 |
1415748 | 1415748 | 2021-06-13 | Hamilton | New York | 36041 | 313 | 2 |
1415749 | 1415749 | 2021-06-13 | Herkimer | New York | 36043 | 5182 | 109 |
1415750 | 1415750 | 2021-06-13 | Jefferson | New York | 36045 | 6130 | 68 |
1415751 | 1415751 | 2021-06-13 | Lewis | New York | 36049 | 2807 | 36 |
1415752 | 1415752 | 2021-06-13 | Livingston | New York | 36051 | 4520 | 60 |
1415753 | 1415753 | 2021-06-13 | Madison | New York | 36053 | 4562 | 89 |
1415754 | 1415754 | 2021-06-13 | Monroe | New York | 36055 | 68930 | 1110 |
1415755 | 1415755 | 2021-06-13 | Montgomery | New York | 36057 | 4254 | 125 |
1415756 | 1415756 | 2021-06-13 | Nassau | New York | 36059 | 183601 | 3174 |
1415757 | 1415757 | 2021-06-13 | New York City | New York | 952559 | 33344 | |
1415758 | 1415758 | 2021-06-13 | Niagara | New York | 36063 | 20032 | 372 |
1415759 | 1415759 | 2021-06-13 | Oneida | New York | 36065 | 22609 | 513 |
1415760 | 1415760 | 2021-06-13 | Onondaga | New York | 36067 | 38913 | 677 |
1415761 | 1415761 | 2021-06-13 | Ontario | New York | 36069 | 7403 | 93 |
1415762 | 1415762 | 2021-06-13 | Orange | New York | 36071 | 48318 | 719 |
1415763 | 1415763 | 2021-06-13 | Orleans | New York | 36073 | 3118 | 83 |
1415764 | 1415764 | 2021-06-13 | Oswego | New York | 36075 | 7619 | 92 |
1415765 | 1415765 | 2021-06-13 | Otsego | New York | 36077 | 3460 | 47 |
1415766 | 1415766 | 2021-06-13 | Putnam | New York | 36079 | 10605 | 92 |
1415767 | 1415767 | 2021-06-13 | Rensselaer | New York | 36083 | 11225 | 142 |
1415768 | 1415768 | 2021-06-13 | Rockland | New York | 36087 | 46935 | 754 |
1415769 | 1415769 | 2021-06-13 | Saratoga | New York | 36091 | 15359 | 168 |
1415770 | 1415770 | 2021-06-13 | Schenectady | New York | 36093 | 13197 | 205 |
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);