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 2021-06-23 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
1448187 | 1448187 | 2021-06-23 | Albany | New York | 36001 | 24722 | 357 |
1448188 | 1448188 | 2021-06-23 | Allegany | New York | 36003 | 3561 | 87 |
1448189 | 1448189 | 2021-06-23 | Broome | New York | 36007 | 18641 | 366 |
1448190 | 1448190 | 2021-06-23 | Cattaraugus | New York | 36009 | 5723 | 91 |
1448191 | 1448191 | 2021-06-23 | Cayuga | New York | 36011 | 6338 | 92 |
1448192 | 1448192 | 2021-06-23 | Chautauqua | New York | 36013 | 8959 | 145 |
1448193 | 1448193 | 2021-06-23 | Chemung | New York | 36015 | 7776 | 136 |
1448194 | 1448194 | 2021-06-23 | Chenango | New York | 36017 | 3507 | 76 |
1448195 | 1448195 | 2021-06-23 | Clinton | New York | 36019 | 4839 | 33 |
1448196 | 1448196 | 2021-06-23 | Columbia | New York | 36021 | 4068 | 104 |
1448197 | 1448197 | 2021-06-23 | Cortland | New York | 36023 | 3931 | 63 |
1448198 | 1448198 | 2021-06-23 | Delaware | New York | 36025 | 2388 | 39 |
1448199 | 1448199 | 2021-06-23 | Dutchess | New York | 36027 | 29493 | 446 |
1448200 | 1448200 | 2021-06-23 | Erie | New York | 36029 | 89620 | 1811 |
1448201 | 1448201 | 2021-06-23 | Essex | New York | 36031 | 1601 | 26 |
1448202 | 1448202 | 2021-06-23 | Franklin | New York | 36033 | 2563 | 12 |
1448203 | 1448203 | 2021-06-23 | Fulton | New York | 36035 | 4425 | 92 |
1448204 | 1448204 | 2021-06-23 | Genesee | New York | 36037 | 5439 | 124 |
1448205 | 1448205 | 2021-06-23 | Greene | New York | 36039 | 3405 | 79 |
1448206 | 1448206 | 2021-06-23 | Hamilton | New York | 36041 | 315 | 2 |
1448207 | 1448207 | 2021-06-23 | Herkimer | New York | 36043 | 5196 | 109 |
1448208 | 1448208 | 2021-06-23 | Jefferson | New York | 36045 | 6159 | 68 |
1448209 | 1448209 | 2021-06-23 | Lewis | New York | 36049 | 2811 | 36 |
1448210 | 1448210 | 2021-06-23 | Livingston | New York | 36051 | 4527 | 60 |
1448211 | 1448211 | 2021-06-23 | Madison | New York | 36053 | 4567 | 89 |
1448212 | 1448212 | 2021-06-23 | Monroe | New York | 36055 | 69091 | 1114 |
1448213 | 1448213 | 2021-06-23 | Montgomery | New York | 36057 | 4254 | 127 |
1448214 | 1448214 | 2021-06-23 | Nassau | New York | 36059 | 183825 | 3178 |
1448215 | 1448215 | 2021-06-23 | New York City | New York | 954353 | 33390 | |
1448216 | 1448216 | 2021-06-23 | Niagara | New York | 36063 | 20051 | 374 |
1448217 | 1448217 | 2021-06-23 | Oneida | New York | 36065 | 22644 | 516 |
1448218 | 1448218 | 2021-06-23 | Onondaga | New York | 36067 | 38998 | 678 |
1448219 | 1448219 | 2021-06-23 | Ontario | New York | 36069 | 7410 | 93 |
1448220 | 1448220 | 2021-06-23 | Orange | New York | 36071 | 48380 | 723 |
1448221 | 1448221 | 2021-06-23 | Orleans | New York | 36073 | 3121 | 83 |
1448222 | 1448222 | 2021-06-23 | Oswego | New York | 36075 | 7633 | 92 |
1448223 | 1448223 | 2021-06-23 | Otsego | New York | 36077 | 3465 | 47 |
1448224 | 1448224 | 2021-06-23 | Putnam | New York | 36079 | 10623 | 93 |
1448225 | 1448225 | 2021-06-23 | Rensselaer | New York | 36083 | 11242 | 143 |
1448226 | 1448226 | 2021-06-23 | Rockland | New York | 36087 | 46986 | 755 |
1448227 | 1448227 | 2021-06-23 | Saratoga | New York | 36091 | 15398 | 168 |
1448228 | 1448228 | 2021-06-23 | Schenectady | New York | 36093 | 13213 | 205 |
1448229 | 1448229 | 2021-06-23 | Schoharie | New York | 36095 | 1694 | 17 |
1448230 | 1448230 | 2021-06-23 | Schuyler | New York | 36097 | 1081 | 14 |
1448231 | 1448231 | 2021-06-23 | Seneca | New York | 36099 | 2011 | 57 |
1448232 | 1448232 | 2021-06-23 | St. Lawrence | New York | 36089 | 6654 | 97 |
1448233 | 1448233 | 2021-06-23 | Steuben | New York | 36101 | 6961 | 146 |
1448234 | 1448234 | 2021-06-23 | Suffolk | New York | 36103 | 201261 | 3401 |
1448235 | 1448235 | 2021-06-23 | Sullivan | New York | 36105 | 6686 | 76 |
1448236 | 1448236 | 2021-06-23 | Tioga | New York | 36107 | 3838 | 63 |
1448237 | 1448237 | 2021-06-23 | Tompkins | New York | 36109 | 4353 | 52 |
1448238 | 1448238 | 2021-06-23 | Ulster | New York | 36111 | 13918 | 257 |
1448239 | 1448239 | 2021-06-23 | Warren | New York | 36113 | 3668 | 57 |
1448240 | 1448240 | 2021-06-23 | Washington | New York | 36115 | 3165 | 55 |
1448241 | 1448241 | 2021-06-23 | Wayne | New York | 36117 | 5791 | 71 |
1448242 | 1448242 | 2021-06-23 | Westchester | New York | 36119 | 129756 | 2292 |
1448243 | 1448243 | 2021-06-23 | Wyoming | New York | 36121 | 3585 | 53 |
1448244 | 1448244 | 2021-06-23 | Yates | New York | 36123 | 1179 | 26 |
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);