ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 194 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
- Montgomery 11
- Schenectady 9
- Chemung 5
- Oswego 5
- Cattaraugus 2
- Onondaga 2
- Saratoga 2
- Albany 1
- Orange 1
- Steuben 1
state 1
- New York · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501463 | 2501463 | 2022-05-13 | Oswego | New York | 36075 | 28826 | 194 |
2498205 | 2498205 | 2022-05-12 | Oswego | New York | 36075 | 28826 | 194 |
2494947 | 2494947 | 2022-05-11 | Oswego | New York | 36075 | 28774 | 194 |
2491689 | 2491689 | 2022-05-10 | Oswego | New York | 36075 | 28719 | 194 |
2488431 | 2488431 | 2022-05-09 | Oswego | New York | 36075 | 28687 | 194 |
2234610 | 2234610 | 2022-02-20 | Montgomery | New York | 36057 | 11603 | 194 |
2231359 | 2231359 | 2022-02-19 | Montgomery | New York | 36057 | 11589 | 194 |
2228108 | 2228108 | 2022-02-18 | Montgomery | New York | 36057 | 11565 | 194 |
2224857 | 2224857 | 2022-02-17 | Montgomery | New York | 36057 | 11546 | 194 |
2221606 | 2221606 | 2022-02-16 | Montgomery | New York | 36057 | 11532 | 194 |
2218355 | 2218355 | 2022-02-15 | Montgomery | New York | 36057 | 11516 | 194 |
2215104 | 2215104 | 2022-02-14 | Montgomery | New York | 36057 | 11504 | 194 |
2211853 | 2211853 | 2022-02-13 | Montgomery | New York | 36057 | 11493 | 194 |
2208600 | 2208600 | 2022-02-12 | Montgomery | New York | 36057 | 11486 | 194 |
2205347 | 2205347 | 2022-02-11 | Montgomery | New York | 36057 | 11460 | 194 |
2202094 | 2202094 | 2022-02-10 | Montgomery | New York | 36057 | 11433 | 194 |
2101227 | 2101227 | 2022-01-10 | Cattaraugus | New York | 36009 | 12410 | 194 |
2097976 | 2097976 | 2022-01-09 | Cattaraugus | New York | 36009 | 12346 | 194 |
2081720 | 2081720 | 2022-01-04 | Chemung | New York | 36015 | 15583 | 194 |
2078468 | 2078468 | 2022-01-03 | Chemung | New York | 36015 | 15492 | 194 |
2075217 | 2075217 | 2022-01-02 | Chemung | New York | 36015 | 15384 | 194 |
2071966 | 2071966 | 2022-01-01 | Chemung | New York | 36015 | 15282 | 194 |
2068715 | 2068715 | 2021-12-31 | Chemung | New York | 36015 | 15092 | 194 |
1980996 | 1980996 | 2021-12-04 | Steuben | New York | 36101 | 12958 | 194 |
1802256 | 1802256 | 2021-10-10 | Saratoga | New York | 36091 | 19549 | 194 |
1799007 | 1799007 | 2021-10-09 | Saratoga | New York | 36091 | 19498 | 194 |
1282678 | 1282678 | 2021-05-03 | Schenectady | New York | 36093 | 12754 | 194 |
1279431 | 1279431 | 2021-05-02 | Schenectady | New York | 36093 | 12743 | 194 |
1276184 | 1276184 | 2021-05-01 | Schenectady | New York | 36093 | 12717 | 194 |
1272937 | 1272937 | 2021-04-30 | Schenectady | New York | 36093 | 12688 | 194 |
1269690 | 1269690 | 2021-04-29 | Schenectady | New York | 36093 | 12670 | 194 |
1266443 | 1266443 | 2021-04-28 | Schenectady | New York | 36093 | 12646 | 194 |
1263196 | 1263196 | 2021-04-27 | Schenectady | New York | 36093 | 12622 | 194 |
1259949 | 1259949 | 2021-04-26 | Schenectady | New York | 36093 | 12598 | 194 |
1256702 | 1256702 | 2021-04-25 | Schenectady | New York | 36093 | 12575 | 194 |
863868 | 863868 | 2020-12-25 | Albany | New York | 36001 | 10274 | 194 |
730835 | 730835 | 2020-11-14 | Onondaga | New York | 36067 | 7650 | 194 |
727591 | 727591 | 2020-11-13 | Onondaga | New York | 36067 | 7421 | 194 |
85716 | 85716 | 2020-04-24 | Orange | New York | 36071 | 7170 | 194 |
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);