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-04-28 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 |
---|---|---|---|---|---|---|---|
2452573 | 2452573 | 2022-04-28 | Albany | New York | 36001 | 61276 | 518 |
2452574 | 2452574 | 2022-04-28 | Allegany | New York | 36003 | 9077 | 154 |
2452575 | 2452575 | 2022-04-28 | Broome | New York | 36007 | 47559 | 517 |
2452576 | 2452576 | 2022-04-28 | Cattaraugus | New York | 36009 | 15757 | 221 |
2452577 | 2452577 | 2022-04-28 | Cayuga | New York | 36011 | 17031 | 150 |
2452578 | 2452578 | 2022-04-28 | Chautauqua | New York | 36013 | 23907 | 300 |
2452579 | 2452579 | 2022-04-28 | Chemung | New York | 36015 | 21998 | 231 |
2452580 | 2452580 | 2022-04-28 | Chenango | New York | 36017 | 9607 | 120 |
2452581 | 2452581 | 2022-04-28 | Clinton | New York | 36019 | 17457 | 88 |
2452582 | 2452582 | 2022-04-28 | Columbia | New York | 36021 | 10381 | 140 |
2452583 | 2452583 | 2022-04-28 | Cortland | New York | 36023 | 11123 | 118 |
2452584 | 2452584 | 2022-04-28 | Delaware | New York | 36025 | 8058 | 72 |
2452585 | 2452585 | 2022-04-28 | Dutchess | New York | 36027 | 65438 | 657 |
2452586 | 2452586 | 2022-04-28 | Erie | New York | 36029 | 218133 | 2624 |
2452587 | 2452587 | 2022-04-28 | Essex | New York | 36031 | 5914 | 59 |
2452588 | 2452588 | 2022-04-28 | Franklin | New York | 36033 | 9798 | 45 |
2452589 | 2452589 | 2022-04-28 | Fulton | New York | 36035 | 13098 | 169 |
2452590 | 2452590 | 2022-04-28 | Genesee | New York | 36037 | 14038 | 186 |
2452591 | 2452591 | 2022-04-28 | Greene | New York | 36039 | 8869 | 125 |
2452592 | 2452592 | 2022-04-28 | Hamilton | New York | 36041 | 904 | 5 |
2452593 | 2452593 | 2022-04-28 | Herkimer | New York | 36043 | 14447 | 190 |
2452594 | 2452594 | 2022-04-28 | Jefferson | New York | 36045 | 20760 | 137 |
2452595 | 2452595 | 2022-04-28 | Lewis | New York | 36049 | 6275 | 49 |
2452596 | 2452596 | 2022-04-28 | Livingston | New York | 36051 | 11995 | 116 |
2452597 | 2452597 | 2022-04-28 | Madison | New York | 36053 | 13950 | 127 |
2452598 | 2452598 | 2022-04-28 | Monroe | New York | 36055 | 158863 | 1566 |
2452599 | 2452599 | 2022-04-28 | Montgomery | New York | 36057 | 12199 | 204 |
2452600 | 2452600 | 2022-04-28 | Nassau | New York | 36059 | 414671 | 3835 |
2452601 | 2452601 | 2022-04-28 | New York City | New York | 2367263 | 40193 | |
2452602 | 2452602 | 2022-04-28 | Niagara | New York | 36063 | 49406 | 577 |
2452603 | 2452603 | 2022-04-28 | Oneida | New York | 36065 | 56495 | 793 |
2452604 | 2452604 | 2022-04-28 | Onondaga | New York | 36067 | 118997 | 1060 |
2452605 | 2452605 | 2022-04-28 | Ontario | New York | 36069 | 20965 | 178 |
2452606 | 2452606 | 2022-04-28 | Orange | New York | 36071 | 108902 | 953 |
2452607 | 2452607 | 2022-04-28 | Orleans | New York | 36073 | 8855 | 113 |
2452608 | 2452608 | 2022-04-28 | Oswego | New York | 36075 | 28074 | 190 |
2452609 | 2452609 | 2022-04-28 | Otsego | New York | 36077 | 10337 | 88 |
2452610 | 2452610 | 2022-04-28 | Putnam | New York | 36079 | 24267 | 122 |
2452611 | 2452611 | 2022-04-28 | Rensselaer | New York | 36083 | 32679 | 252 |
2452612 | 2452612 | 2022-04-28 | Rockland | New York | 36087 | 94229 | 893 |
2452613 | 2452613 | 2022-04-28 | Saratoga | New York | 36091 | 48038 | 330 |
2452614 | 2452614 | 2022-04-28 | Schenectady | New York | 36093 | 34034 | 301 |
2452615 | 2452615 | 2022-04-28 | Schoharie | New York | 36095 | 5177 | 36 |
2452616 | 2452616 | 2022-04-28 | Schuyler | New York | 36097 | 3656 | 25 |
2452617 | 2452617 | 2022-04-28 | Seneca | New York | 36099 | 6240 | 91 |
2452618 | 2452618 | 2022-04-28 | St. Lawrence | New York | 36089 | 22072 | 189 |
2452619 | 2452619 | 2022-04-28 | Steuben | New York | 36101 | 20538 | 250 |
2452620 | 2452620 | 2022-04-28 | Suffolk | New York | 36103 | 435366 | 4380 |
2452621 | 2452621 | 2022-04-28 | Sullivan | New York | 36105 | 18830 | 130 |
2452622 | 2452622 | 2022-04-28 | Tioga | New York | 36107 | 11310 | 83 |
2452623 | 2452623 | 2022-04-28 | Tompkins | New York | 36109 | 20178 | 84 |
2452624 | 2452624 | 2022-04-28 | Ulster | New York | 36111 | 32827 | 363 |
2452625 | 2452625 | 2022-04-28 | Warren | New York | 36113 | 14138 | 127 |
2452626 | 2452626 | 2022-04-28 | Washington | New York | 36115 | 12415 | 113 |
2452627 | 2452627 | 2022-04-28 | Wayne | New York | 36117 | 17971 | 174 |
2452628 | 2452628 | 2022-04-28 | Westchester | New York | 36119 | 258177 | 2715 |
2452629 | 2452629 | 2022-04-28 | Wyoming | New York | 36121 | 8494 | 82 |
2452630 | 2452630 | 2022-04-28 | Yates | New York | 36123 | 3570 | 40 |
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);