ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where county = "Rensselaer", deaths = 144, fips = 36083 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1548865 | 1548865 | 2021-07-24 | Rensselaer | New York | 36083 | 11333 | 144 |
1545618 | 1545618 | 2021-07-23 | Rensselaer | New York | 36083 | 11329 | 144 |
1542371 | 1542371 | 2021-07-22 | Rensselaer | New York | 36083 | 11320 | 144 |
1539123 | 1539123 | 2021-07-21 | Rensselaer | New York | 36083 | 11314 | 144 |
1535876 | 1535876 | 2021-07-20 | Rensselaer | New York | 36083 | 11311 | 144 |
1532628 | 1532628 | 2021-07-19 | Rensselaer | New York | 36083 | 11305 | 144 |
1529381 | 1529381 | 2021-07-18 | Rensselaer | New York | 36083 | 11302 | 144 |
1526134 | 1526134 | 2021-07-17 | Rensselaer | New York | 36083 | 11293 | 144 |
1522887 | 1522887 | 2021-07-16 | Rensselaer | New York | 36083 | 11288 | 144 |
1519639 | 1519639 | 2021-07-15 | Rensselaer | New York | 36083 | 11282 | 144 |
1516391 | 1516391 | 2021-07-14 | Rensselaer | New York | 36083 | 11277 | 144 |
1513144 | 1513144 | 2021-07-13 | Rensselaer | New York | 36083 | 11273 | 144 |
1509898 | 1509898 | 2021-07-12 | Rensselaer | New York | 36083 | 11271 | 144 |
1506651 | 1506651 | 2021-07-11 | Rensselaer | New York | 36083 | 11264 | 144 |
1503405 | 1503405 | 2021-07-10 | Rensselaer | New York | 36083 | 11262 | 144 |
1500159 | 1500159 | 2021-07-09 | Rensselaer | New York | 36083 | 11259 | 144 |
1496913 | 1496913 | 2021-07-08 | Rensselaer | New York | 36083 | 11254 | 144 |
1493666 | 1493666 | 2021-07-07 | Rensselaer | New York | 36083 | 11253 | 144 |
1490419 | 1490419 | 2021-07-06 | Rensselaer | New York | 36083 | 11253 | 144 |
1487172 | 1487172 | 2021-07-05 | Rensselaer | New York | 36083 | 11253 | 144 |
1483926 | 1483926 | 2021-07-04 | Rensselaer | New York | 36083 | 11252 | 144 |
1480680 | 1480680 | 2021-07-03 | Rensselaer | New York | 36083 | 11252 | 144 |
1477433 | 1477433 | 2021-07-02 | Rensselaer | New York | 36083 | 11252 | 144 |
1474187 | 1474187 | 2021-07-01 | Rensselaer | New York | 36083 | 11251 | 144 |
1470941 | 1470941 | 2021-06-30 | Rensselaer | New York | 36083 | 11249 | 144 |
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);