ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2022-03-12 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
2299618 | 2299618 | 2022-03-12 | Albany | New York | 36001 | 58269 | 504 |
2299619 | 2299619 | 2022-03-12 | Allegany | New York | 36003 | 8851 | 151 |
2299620 | 2299620 | 2022-03-12 | Broome | New York | 36007 | 44636 | 508 |
2299621 | 2299621 | 2022-03-12 | Cattaraugus | New York | 36009 | 15281 | 218 |
2299622 | 2299622 | 2022-03-12 | Cayuga | New York | 36011 | 15739 | 144 |
2299623 | 2299623 | 2022-03-12 | Chautauqua | New York | 36013 | 23410 | 292 |
2299624 | 2299624 | 2022-03-12 | Chemung | New York | 36015 | 21095 | 227 |
2299625 | 2299625 | 2022-03-12 | Chenango | New York | 36017 | 9191 | 118 |
2299626 | 2299626 | 2022-03-12 | Clinton | New York | 36019 | 16467 | 84 |
2299627 | 2299627 | 2022-03-12 | Columbia | New York | 36021 | 9935 | 140 |
2299628 | 2299628 | 2022-03-12 | Cortland | New York | 36023 | 10353 | 114 |
2299629 | 2299629 | 2022-03-12 | Delaware | New York | 36025 | 7595 | 68 |
2299630 | 2299630 | 2022-03-12 | Dutchess | New York | 36027 | 63417 | 651 |
2299631 | 2299631 | 2022-03-12 | Erie | New York | 36029 | 206530 | 2596 |
2299632 | 2299632 | 2022-03-12 | Essex | New York | 36031 | 5508 | 57 |
2299633 | 2299633 | 2022-03-12 | Franklin | New York | 36033 | 9228 | 44 |
2299634 | 2299634 | 2022-03-12 | Fulton | New York | 36035 | 12361 | 166 |
2299635 | 2299635 | 2022-03-12 | Genesee | New York | 36037 | 13559 | 184 |
2299636 | 2299636 | 2022-03-12 | Greene | New York | 36039 | 8478 | 123 |
2299637 | 2299637 | 2022-03-12 | Hamilton | New York | 36041 | 846 | 5 |
2299638 | 2299638 | 2022-03-12 | Herkimer | New York | 36043 | 13596 | 189 |
2299639 | 2299639 | 2022-03-12 | Jefferson | New York | 36045 | 19741 | 131 |
2299640 | 2299640 | 2022-03-12 | Lewis | New York | 36049 | 6113 | 48 |
2299641 | 2299641 | 2022-03-12 | Livingston | New York | 36051 | 11521 | 113 |
2299642 | 2299642 | 2022-03-12 | Madison | New York | 36053 | 12787 | 125 |
2299643 | 2299643 | 2022-03-12 | Monroe | New York | 36055 | 149801 | 1543 |
2299644 | 2299644 | 2022-03-12 | Montgomery | New York | 36057 | 11731 | 199 |
2299645 | 2299645 | 2022-03-12 | Nassau | New York | 36059 | 399571 | 3814 |
2299646 | 2299646 | 2022-03-12 | New York City | New York | 2285170 | 39925 | |
2299647 | 2299647 | 2022-03-12 | Niagara | New York | 36063 | 47403 | 565 |
2299648 | 2299648 | 2022-03-12 | Oneida | New York | 36065 | 52458 | 780 |
2299649 | 2299649 | 2022-03-12 | Onondaga | New York | 36067 | 108353 | 1036 |
2299650 | 2299650 | 2022-03-12 | Ontario | New York | 36069 | 19605 | 172 |
2299651 | 2299651 | 2022-03-12 | Orange | New York | 36071 | 105731 | 943 |
2299652 | 2299652 | 2022-03-12 | Orleans | New York | 36073 | 8543 | 113 |
2299653 | 2299653 | 2022-03-12 | Oswego | New York | 36075 | 25259 | 182 |
2299654 | 2299654 | 2022-03-12 | Otsego | New York | 36077 | 9723 | 88 |
2299655 | 2299655 | 2022-03-12 | Putnam | New York | 36079 | 23374 | 121 |
2299656 | 2299656 | 2022-03-12 | Rensselaer | New York | 36083 | 31026 | 245 |
2299657 | 2299657 | 2022-03-12 | Rockland | New York | 36087 | 91442 | 891 |
2299658 | 2299658 | 2022-03-12 | Saratoga | New York | 36091 | 45444 | 322 |
2299659 | 2299659 | 2022-03-12 | Schenectady | New York | 36093 | 32508 | 296 |
2299660 | 2299660 | 2022-03-12 | Schoharie | New York | 36095 | 4931 | 34 |
2299661 | 2299661 | 2022-03-12 | Schuyler | New York | 36097 | 3401 | 25 |
2299662 | 2299662 | 2022-03-12 | Seneca | New York | 36099 | 5801 | 89 |
2299663 | 2299663 | 2022-03-12 | St. Lawrence | New York | 36089 | 20716 | 180 |
2299664 | 2299664 | 2022-03-12 | Steuben | New York | 36101 | 19648 | 242 |
2299665 | 2299665 | 2022-03-12 | Suffolk | New York | 36103 | 423673 | 4353 |
2299666 | 2299666 | 2022-03-12 | Sullivan | New York | 36105 | 18249 | 128 |
2299667 | 2299667 | 2022-03-12 | Tioga | New York | 36107 | 10561 | 82 |
2299668 | 2299668 | 2022-03-12 | Tompkins | New York | 36109 | 17730 | 82 |
2299669 | 2299669 | 2022-03-12 | Ulster | New York | 36111 | 31028 | 360 |
2299670 | 2299670 | 2022-03-12 | Warren | New York | 36113 | 13373 | 123 |
2299671 | 2299671 | 2022-03-12 | Washington | New York | 36115 | 11925 | 113 |
2299672 | 2299672 | 2022-03-12 | Wayne | New York | 36117 | 16989 | 168 |
2299673 | 2299673 | 2022-03-12 | Westchester | New York | 36119 | 247737 | 2692 |
2299674 | 2299674 | 2022-03-12 | Wyoming | New York | 36121 | 8240 | 82 |
2299675 | 2299675 | 2022-03-12 | Yates | New York | 36123 | 3329 | 39 |
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);