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 402
- Westchester 399
- Nassau 398
- Rockland 397
- Saratoga 396
- Suffolk 395
- Ulster 395
- Monroe 392
- Albany 391
- Delaware 391
- Dutchess 391
- Herkimer 391
- Orange 391
- Schenectady 390
- Broome 389
- Tioga 389
- Tompkins 389
- Erie 388
- Greene 388
- Montgomery 388
- Putnam 388
- Allegany 387
- Onondaga 387
- Ontario 387
- Clinton 386
- Rensselaer 386
- Sullivan 386
- Wyoming 386
- Chenango 385
- Essex 385
- …
state 1
- New York · 22,376 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194955 | 1194955 | 2021-04-06 | Albany | New York | 36001 | 22965 | 340 |
1194956 | 1194956 | 2021-04-06 | Allegany | New York | 36003 | 3076 | 82 |
1194957 | 1194957 | 2021-04-06 | Broome | New York | 36007 | 16842 | 346 |
1194958 | 1194958 | 2021-04-06 | Cattaraugus | New York | 36009 | 4903 | 79 |
1194959 | 1194959 | 2021-04-06 | Cayuga | New York | 36011 | 5681 | 90 |
1194960 | 1194960 | 2021-04-06 | Chautauqua | New York | 36013 | 8059 | 131 |
1194961 | 1194961 | 2021-04-06 | Chemung | New York | 36015 | 6924 | 131 |
1194962 | 1194962 | 2021-04-06 | Chenango | New York | 36017 | 2900 | 72 |
1194963 | 1194963 | 2021-04-06 | Clinton | New York | 36019 | 4319 | 31 |
1194964 | 1194964 | 2021-04-06 | Columbia | New York | 36021 | 3737 | 99 |
1194965 | 1194965 | 2021-04-06 | Cortland | New York | 36023 | 3453 | 60 |
1194966 | 1194966 | 2021-04-06 | Delaware | New York | 36025 | 2028 | 34 |
1194967 | 1194967 | 2021-04-06 | Dutchess | New York | 36027 | 26776 | 426 |
1194968 | 1194968 | 2021-04-06 | Erie | New York | 36029 | 76665 | 1666 |
1194969 | 1194969 | 2021-04-06 | Essex | New York | 36031 | 1474 | 26 |
1194970 | 1194970 | 2021-04-06 | Franklin | New York | 36033 | 2341 | 12 |
1194971 | 1194971 | 2021-04-06 | Fulton | New York | 36035 | 3860 | 85 |
1194972 | 1194972 | 2021-04-06 | Genesee | New York | 36037 | 4878 | 121 |
1194973 | 1194973 | 2021-04-06 | Greene | New York | 36039 | 3016 | 73 |
1194974 | 1194974 | 2021-04-06 | Hamilton | New York | 36041 | 294 | 2 |
1194975 | 1194975 | 2021-04-06 | Herkimer | New York | 36043 | 4814 | 107 |
1194976 | 1194976 | 2021-04-06 | Jefferson | New York | 36045 | 5289 | 63 |
1194977 | 1194977 | 2021-04-06 | Lewis | New York | 36049 | 2365 | 33 |
1194978 | 1194978 | 2021-04-06 | Livingston | New York | 36051 | 3856 | 58 |
1194979 | 1194979 | 2021-04-06 | Madison | New York | 36053 | 4161 | 85 |
1194980 | 1194980 | 2021-04-06 | Monroe | New York | 36055 | 57912 | 1023 |
1194981 | 1194981 | 2021-04-06 | Montgomery | New York | 36057 | 3699 | 114 |
1194982 | 1194982 | 2021-04-06 | Nassau | New York | 36059 | 171185 | 3069 |
1194983 | 1194983 | 2021-04-06 | New York City | New York | 867989 | 31531 | |
1194984 | 1194984 | 2021-04-06 | Niagara | New York | 36063 | 17076 | 331 |
1194985 | 1194985 | 2021-04-06 | Oneida | New York | 36065 | 20983 | 495 |
1194986 | 1194986 | 2021-04-06 | Onondaga | New York | 36067 | 34773 | 657 |
1194987 | 1194987 | 2021-04-06 | Ontario | New York | 36069 | 6490 | 91 |
1194988 | 1194988 | 2021-04-06 | Orange | New York | 36071 | 44385 | 683 |
1194989 | 1194989 | 2021-04-06 | Orleans | New York | 36073 | 2641 | 83 |
1194990 | 1194990 | 2021-04-06 | Oswego | New York | 36075 | 6728 | 90 |
1194991 | 1194991 | 2021-04-06 | Otsego | New York | 36077 | 3007 | 46 |
1194992 | 1194992 | 2021-04-06 | Putnam | New York | 36079 | 9786 | 90 |
1194993 | 1194993 | 2021-04-06 | Rensselaer | New York | 36083 | 10248 | 135 |
1194994 | 1194994 | 2021-04-06 | Rockland | New York | 36087 | 44384 | 725 |
1194995 | 1194995 | 2021-04-06 | Saratoga | New York | 36091 | 13752 | 157 |
1194996 | 1194996 | 2021-04-06 | Schenectady | New York | 36093 | 11998 | 189 |
1194997 | 1194997 | 2021-04-06 | Schoharie | New York | 36095 | 1453 | 15 |
1194998 | 1194998 | 2021-04-06 | Schuyler | New York | 36097 | 957 | 13 |
1194999 | 1194999 | 2021-04-06 | Seneca | New York | 36099 | 1811 | 56 |
1195000 | 1195000 | 2021-04-06 | St. Lawrence | New York | 36089 | 6008 | 94 |
1195001 | 1195001 | 2021-04-06 | Steuben | New York | 36101 | 6049 | 140 |
1195002 | 1195002 | 2021-04-06 | Suffolk | New York | 36103 | 186487 | 3277 |
1195003 | 1195003 | 2021-04-06 | Sullivan | New York | 36105 | 5733 | 67 |
1195004 | 1195004 | 2021-04-06 | Tioga | New York | 36107 | 3213 | 58 |
1195005 | 1195005 | 2021-04-06 | Tompkins | New York | 36109 | 3956 | 49 |
1195006 | 1195006 | 2021-04-06 | Ulster | New York | 36111 | 12378 | 239 |
1195007 | 1195007 | 2021-04-06 | Warren | New York | 36113 | 3251 | 55 |
1195008 | 1195008 | 2021-04-06 | Washington | New York | 36115 | 2739 | 55 |
1195009 | 1195009 | 2021-04-06 | Wayne | New York | 36117 | 4957 | 66 |
1195010 | 1195010 | 2021-04-06 | Westchester | New York | 36119 | 122065 | 2218 |
1195011 | 1195011 | 2021-04-06 | Wyoming | New York | 36121 | 3128 | 50 |
1195012 | 1195012 | 2021-04-06 | Yates | New York | 36123 | 1067 | 26 |
1191707 | 1191707 | 2021-04-05 | Albany | New York | 36001 | 22925 | 340 |
1191708 | 1191708 | 2021-04-05 | Allegany | New York | 36003 | 3071 | 82 |
1191709 | 1191709 | 2021-04-05 | Broome | New York | 36007 | 16806 | 346 |
1191710 | 1191710 | 2021-04-05 | Cattaraugus | New York | 36009 | 4897 | 79 |
1191711 | 1191711 | 2021-04-05 | Cayuga | New York | 36011 | 5679 | 90 |
1191712 | 1191712 | 2021-04-05 | Chautauqua | New York | 36013 | 8050 | 131 |
1191713 | 1191713 | 2021-04-05 | Chemung | New York | 36015 | 6918 | 131 |
1191714 | 1191714 | 2021-04-05 | Chenango | New York | 36017 | 2893 | 72 |
1191715 | 1191715 | 2021-04-05 | Clinton | New York | 36019 | 4296 | 30 |
1191716 | 1191716 | 2021-04-05 | Columbia | New York | 36021 | 3734 | 98 |
1191717 | 1191717 | 2021-04-05 | Cortland | New York | 36023 | 3446 | 60 |
1191718 | 1191718 | 2021-04-05 | Delaware | New York | 36025 | 2021 | 34 |
1191719 | 1191719 | 2021-04-05 | Dutchess | New York | 36027 | 26680 | 426 |
1191720 | 1191720 | 2021-04-05 | Erie | New York | 36029 | 76365 | 1666 |
1191721 | 1191721 | 2021-04-05 | Essex | New York | 36031 | 1469 | 26 |
1191722 | 1191722 | 2021-04-05 | Franklin | New York | 36033 | 2333 | 12 |
1191723 | 1191723 | 2021-04-05 | Fulton | New York | 36035 | 3850 | 85 |
1191724 | 1191724 | 2021-04-05 | Genesee | New York | 36037 | 4871 | 121 |
1191725 | 1191725 | 2021-04-05 | Greene | New York | 36039 | 3014 | 73 |
1191726 | 1191726 | 2021-04-05 | Hamilton | New York | 36041 | 294 | 2 |
1191727 | 1191727 | 2021-04-05 | Herkimer | New York | 36043 | 4810 | 107 |
1191728 | 1191728 | 2021-04-05 | Jefferson | New York | 36045 | 5279 | 63 |
1191729 | 1191729 | 2021-04-05 | Lewis | New York | 36049 | 2358 | 33 |
1191730 | 1191730 | 2021-04-05 | Livingston | New York | 36051 | 3851 | 58 |
1191731 | 1191731 | 2021-04-05 | Madison | New York | 36053 | 4155 | 85 |
1191732 | 1191732 | 2021-04-05 | Monroe | New York | 36055 | 57781 | 1023 |
1191733 | 1191733 | 2021-04-05 | Montgomery | New York | 36057 | 3685 | 114 |
1191734 | 1191734 | 2021-04-05 | Nassau | New York | 36059 | 170680 | 3066 |
1191735 | 1191735 | 2021-04-05 | New York City | New York | 864732 | 31500 | |
1191736 | 1191736 | 2021-04-05 | Niagara | New York | 36063 | 17014 | 331 |
1191737 | 1191737 | 2021-04-05 | Oneida | New York | 36065 | 20971 | 495 |
1191738 | 1191738 | 2021-04-05 | Onondaga | New York | 36067 | 34741 | 657 |
1191739 | 1191739 | 2021-04-05 | Ontario | New York | 36069 | 6476 | 91 |
1191740 | 1191740 | 2021-04-05 | Orange | New York | 36071 | 44200 | 682 |
1191741 | 1191741 | 2021-04-05 | Orleans | New York | 36073 | 2637 | 83 |
1191742 | 1191742 | 2021-04-05 | Oswego | New York | 36075 | 6717 | 90 |
1191743 | 1191743 | 2021-04-05 | Otsego | New York | 36077 | 2995 | 46 |
1191744 | 1191744 | 2021-04-05 | Putnam | New York | 36079 | 9757 | 90 |
1191745 | 1191745 | 2021-04-05 | Rensselaer | New York | 36083 | 10217 | 135 |
1191746 | 1191746 | 2021-04-05 | Rockland | New York | 36087 | 44234 | 724 |
1191747 | 1191747 | 2021-04-05 | Saratoga | New York | 36091 | 13713 | 157 |
1191748 | 1191748 | 2021-04-05 | Schenectady | New York | 36093 | 11987 | 188 |
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);