ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Elliott", deaths = 7 and state = "Kentucky" 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 |
---|---|---|---|---|---|---|---|
1872883 | 1872883 | 2021-11-01 | Elliott | Kentucky | 21063 | 1343 | 7 |
1869634 | 1869634 | 2021-10-31 | Elliott | Kentucky | 21063 | 1339 | 7 |
1866385 | 1866385 | 2021-10-30 | Elliott | Kentucky | 21063 | 1339 | 7 |
1863136 | 1863136 | 2021-10-29 | Elliott | Kentucky | 21063 | 1339 | 7 |
1859887 | 1859887 | 2021-10-28 | Elliott | Kentucky | 21063 | 1337 | 7 |
1856638 | 1856638 | 2021-10-27 | Elliott | Kentucky | 21063 | 1335 | 7 |
1853389 | 1853389 | 2021-10-26 | Elliott | Kentucky | 21063 | 1314 | 7 |
1850140 | 1850140 | 2021-10-25 | Elliott | Kentucky | 21063 | 1311 | 7 |
1846890 | 1846890 | 2021-10-24 | Elliott | Kentucky | 21063 | 1309 | 7 |
1843640 | 1843640 | 2021-10-23 | Elliott | Kentucky | 21063 | 1309 | 7 |
1840390 | 1840390 | 2021-10-22 | Elliott | Kentucky | 21063 | 1309 | 7 |
1837141 | 1837141 | 2021-10-21 | Elliott | Kentucky | 21063 | 1309 | 7 |
1833892 | 1833892 | 2021-10-20 | Elliott | Kentucky | 21063 | 1307 | 7 |
1830643 | 1830643 | 2021-10-19 | Elliott | Kentucky | 21063 | 1307 | 7 |
1827394 | 1827394 | 2021-10-18 | Elliott | Kentucky | 21063 | 1303 | 7 |
1824145 | 1824145 | 2021-10-17 | Elliott | Kentucky | 21063 | 1300 | 7 |
1820896 | 1820896 | 2021-10-16 | Elliott | Kentucky | 21063 | 1300 | 7 |
1817647 | 1817647 | 2021-10-15 | Elliott | Kentucky | 21063 | 1300 | 7 |
1814399 | 1814399 | 2021-10-14 | Elliott | Kentucky | 21063 | 1299 | 7 |
1811150 | 1811150 | 2021-10-13 | Elliott | Kentucky | 21063 | 1296 | 7 |
1807901 | 1807901 | 2021-10-12 | Elliott | Kentucky | 21063 | 1290 | 7 |
1804650 | 1804650 | 2021-10-11 | Elliott | Kentucky | 21063 | 1284 | 7 |
1801401 | 1801401 | 2021-10-10 | Elliott | Kentucky | 21063 | 1279 | 7 |
1798152 | 1798152 | 2021-10-09 | Elliott | Kentucky | 21063 | 1279 | 7 |
1794903 | 1794903 | 2021-10-08 | Elliott | Kentucky | 21063 | 1279 | 7 |
1791655 | 1791655 | 2021-10-07 | Elliott | Kentucky | 21063 | 1278 | 7 |
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);