ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where county = "Grand" and deaths = 10 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 |
---|---|---|---|---|---|---|---|
1810387 | 1810387 | 2021-10-13 | Grand | Colorado | 8049 | 2093 | 10 |
1807138 | 1807138 | 2021-10-12 | Grand | Colorado | 8049 | 2083 | 10 |
1803887 | 1803887 | 2021-10-11 | Grand | Colorado | 8049 | 2078 | 10 |
1800638 | 1800638 | 2021-10-10 | Grand | Colorado | 8049 | 2065 | 10 |
1797389 | 1797389 | 2021-10-09 | Grand | Colorado | 8049 | 2065 | 10 |
1794140 | 1794140 | 2021-10-08 | Grand | Colorado | 8049 | 2065 | 10 |
1790892 | 1790892 | 2021-10-07 | Grand | Colorado | 8049 | 2059 | 10 |
1787643 | 1787643 | 2021-10-06 | Grand | Colorado | 8049 | 2053 | 10 |
1784394 | 1784394 | 2021-10-05 | Grand | Colorado | 8049 | 2044 | 10 |
1781145 | 1781145 | 2021-10-04 | Grand | Colorado | 8049 | 2041 | 10 |
1777895 | 1777895 | 2021-10-03 | Grand | Colorado | 8049 | 2025 | 10 |
1774645 | 1774645 | 2021-10-02 | Grand | Colorado | 8049 | 2025 | 10 |
1771395 | 1771395 | 2021-10-01 | Grand | Colorado | 8049 | 2025 | 10 |
1768146 | 1768146 | 2021-09-30 | Grand | Colorado | 8049 | 2012 | 10 |
1764897 | 1764897 | 2021-09-29 | Grand | Colorado | 8049 | 1999 | 10 |
1761648 | 1761648 | 2021-09-28 | Grand | Colorado | 8049 | 1993 | 10 |
1755152 | 1755152 | 2021-09-26 | Grand | Colorado | 8049 | 1939 | 10 |
1751904 | 1751904 | 2021-09-25 | Grand | Colorado | 8049 | 1939 | 10 |
1748655 | 1748655 | 2021-09-24 | Grand | Colorado | 8049 | 1939 | 10 |
1745405 | 1745405 | 2021-09-23 | Grand | Colorado | 8049 | 1924 | 10 |
1742156 | 1742156 | 2021-09-22 | Grand | Colorado | 8049 | 1907 | 10 |
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);