ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where county = "Rensselaer", deaths = 248 and fips = 36083 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2400516 | 2400516 | 2022-04-12 | Rensselaer | New York | 36083 | 31704 | 248 |
2397261 | 2397261 | 2022-04-11 | Rensselaer | New York | 36083 | 31674 | 248 |
2394006 | 2394006 | 2022-04-10 | Rensselaer | New York | 36083 | 31650 | 248 |
2390750 | 2390750 | 2022-04-09 | Rensselaer | New York | 36083 | 31559 | 248 |
2387494 | 2387494 | 2022-04-08 | Rensselaer | New York | 36083 | 31526 | 248 |
2384239 | 2384239 | 2022-04-07 | Rensselaer | New York | 36083 | 31492 | 248 |
2380984 | 2380984 | 2022-04-06 | Rensselaer | New York | 36083 | 31457 | 248 |
2377729 | 2377729 | 2022-04-05 | Rensselaer | New York | 36083 | 31420 | 248 |
2374476 | 2374476 | 2022-04-04 | Rensselaer | New York | 36083 | 31408 | 248 |
2371224 | 2371224 | 2022-04-03 | Rensselaer | New York | 36083 | 31395 | 248 |
2367971 | 2367971 | 2022-04-02 | Rensselaer | New York | 36083 | 31345 | 248 |
2364718 | 2364718 | 2022-04-01 | Rensselaer | New York | 36083 | 31313 | 248 |
2361464 | 2361464 | 2022-03-31 | Rensselaer | New York | 36083 | 31291 | 248 |
2358210 | 2358210 | 2022-03-30 | Rensselaer | New York | 36083 | 31274 | 248 |
2354956 | 2354956 | 2022-03-29 | Rensselaer | New York | 36083 | 31230 | 248 |
2351703 | 2351703 | 2022-03-28 | Rensselaer | New York | 36083 | 31219 | 248 |
2348451 | 2348451 | 2022-03-27 | Rensselaer | New York | 36083 | 31210 | 248 |
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);