ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 203 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 8
- Montgomery 23
- Schenectady 6
- Rensselaer 4
- Steuben 2
- Chemung 1
- Niagara 1
- Onondaga 1
- Orange 1
state 1
- New York · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426551 | 2426551 | 2022-04-20 | Montgomery | New York | 36057 | 12060 | 203 |
2423295 | 2423295 | 2022-04-19 | Montgomery | New York | 36057 | 12049 | 203 |
2420038 | 2420038 | 2022-04-18 | Montgomery | New York | 36057 | 12045 | 203 |
2416783 | 2416783 | 2022-04-17 | Montgomery | New York | 36057 | 12035 | 203 |
2413527 | 2413527 | 2022-04-16 | Montgomery | New York | 36057 | 12015 | 203 |
2410271 | 2410271 | 2022-04-15 | Montgomery | New York | 36057 | 12003 | 203 |
2407015 | 2407015 | 2022-04-14 | Montgomery | New York | 36057 | 11998 | 203 |
2403759 | 2403759 | 2022-04-13 | Montgomery | New York | 36057 | 11977 | 203 |
2400504 | 2400504 | 2022-04-12 | Montgomery | New York | 36057 | 11971 | 203 |
2397249 | 2397249 | 2022-04-11 | Montgomery | New York | 36057 | 11961 | 203 |
2393994 | 2393994 | 2022-04-10 | Montgomery | New York | 36057 | 11951 | 203 |
2390738 | 2390738 | 2022-04-09 | Montgomery | New York | 36057 | 11942 | 203 |
2387482 | 2387482 | 2022-04-08 | Montgomery | New York | 36057 | 11930 | 203 |
2384227 | 2384227 | 2022-04-07 | Montgomery | New York | 36057 | 11917 | 203 |
2380972 | 2380972 | 2022-04-06 | Montgomery | New York | 36057 | 11907 | 203 |
2377717 | 2377717 | 2022-04-05 | Montgomery | New York | 36057 | 11900 | 203 |
2374464 | 2374464 | 2022-04-04 | Montgomery | New York | 36057 | 11892 | 203 |
2371212 | 2371212 | 2022-04-03 | Montgomery | New York | 36057 | 11888 | 203 |
2367959 | 2367959 | 2022-04-02 | Montgomery | New York | 36057 | 11880 | 203 |
2364706 | 2364706 | 2022-04-01 | Montgomery | New York | 36057 | 11873 | 203 |
2361452 | 2361452 | 2022-03-31 | Montgomery | New York | 36057 | 11868 | 203 |
2358198 | 2358198 | 2022-03-30 | Montgomery | New York | 36057 | 11851 | 203 |
2354944 | 2354944 | 2022-03-29 | Montgomery | New York | 36057 | 11836 | 203 |
2120739 | 2120739 | 2022-01-16 | Chemung | New York | 36015 | 18531 | 203 |
2023247 | 2023247 | 2021-12-17 | Rensselaer | New York | 36083 | 19222 | 203 |
2019996 | 2019996 | 2021-12-16 | Rensselaer | New York | 36083 | 19102 | 203 |
2016745 | 2016745 | 2021-12-15 | Rensselaer | New York | 36083 | 19015 | 203 |
2013495 | 2013495 | 2021-12-14 | Rensselaer | New York | 36083 | 18914 | 203 |
2010252 | 2010252 | 2021-12-13 | Steuben | New York | 36101 | 13684 | 203 |
2007001 | 2007001 | 2021-12-12 | Steuben | New York | 36101 | 13649 | 203 |
1393051 | 1393051 | 2021-06-06 | Schenectady | New York | 36093 | 13178 | 203 |
1389806 | 1389806 | 2021-06-05 | Schenectady | New York | 36093 | 13175 | 203 |
1386561 | 1386561 | 2021-06-04 | Schenectady | New York | 36093 | 13170 | 203 |
1383316 | 1383316 | 2021-06-03 | Schenectady | New York | 36093 | 13168 | 203 |
1380070 | 1380070 | 2021-06-02 | Schenectady | New York | 36093 | 13167 | 203 |
1376825 | 1376825 | 2021-06-01 | Schenectady | New York | 36093 | 13156 | 203 |
906087 | 906087 | 2021-01-07 | Niagara | New York | 36063 | 9806 | 203 |
763293 | 763293 | 2020-11-24 | Onondaga | New York | 36067 | 9470 | 203 |
91343 | 91343 | 2020-04-26 | Orange | New York | 36071 | 8121 | 203 |
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);