ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "Dallam", deaths = 29 and state = "Texas" 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 |
---|---|---|---|---|---|---|---|
1998036 | 1998036 | 2021-12-09 | Dallam | Texas | 48111 | 1334 | 29 |
1994785 | 1994785 | 2021-12-08 | Dallam | Texas | 48111 | 1334 | 29 |
1991534 | 1991534 | 2021-12-07 | Dallam | Texas | 48111 | 1332 | 29 |
1988283 | 1988283 | 2021-12-06 | Dallam | Texas | 48111 | 1331 | 29 |
1985033 | 1985033 | 2021-12-05 | Dallam | Texas | 48111 | 1331 | 29 |
1981783 | 1981783 | 2021-12-04 | Dallam | Texas | 48111 | 1331 | 29 |
1978533 | 1978533 | 2021-12-03 | Dallam | Texas | 48111 | 1331 | 29 |
1975283 | 1975283 | 2021-12-02 | Dallam | Texas | 48111 | 1327 | 29 |
1972034 | 1972034 | 2021-12-01 | Dallam | Texas | 48111 | 1323 | 29 |
1968784 | 1968784 | 2021-11-30 | Dallam | Texas | 48111 | 1302 | 29 |
1965533 | 1965533 | 2021-11-29 | Dallam | Texas | 48111 | 1300 | 29 |
1962281 | 1962281 | 2021-11-28 | Dallam | Texas | 48111 | 1287 | 29 |
1959030 | 1959030 | 2021-11-27 | Dallam | Texas | 48111 | 1287 | 29 |
1955779 | 1955779 | 2021-11-26 | Dallam | Texas | 48111 | 1287 | 29 |
1952528 | 1952528 | 2021-11-25 | Dallam | Texas | 48111 | 1287 | 29 |
1949277 | 1949277 | 2021-11-24 | Dallam | Texas | 48111 | 1287 | 29 |
1946026 | 1946026 | 2021-11-23 | Dallam | Texas | 48111 | 1287 | 29 |
1942775 | 1942775 | 2021-11-22 | Dallam | Texas | 48111 | 1286 | 29 |
1939525 | 1939525 | 2021-11-21 | Dallam | Texas | 48111 | 1286 | 29 |
1936275 | 1936275 | 2021-11-20 | Dallam | Texas | 48111 | 1286 | 29 |
1933025 | 1933025 | 2021-11-19 | Dallam | Texas | 48111 | 1286 | 29 |
1929774 | 1929774 | 2021-11-18 | Dallam | Texas | 48111 | 1276 | 29 |
1926524 | 1926524 | 2021-11-17 | Dallam | Texas | 48111 | 1276 | 29 |
1923274 | 1923274 | 2021-11-16 | Dallam | Texas | 48111 | 1267 | 29 |
1920025 | 1920025 | 2021-11-15 | Dallam | Texas | 48111 | 1254 | 29 |
1916775 | 1916775 | 2021-11-14 | Dallam | Texas | 48111 | 1254 | 29 |
1913525 | 1913525 | 2021-11-13 | Dallam | Texas | 48111 | 1254 | 29 |
1910275 | 1910275 | 2021-11-12 | Dallam | Texas | 48111 | 1251 | 29 |
1907026 | 1907026 | 2021-11-11 | Dallam | Texas | 48111 | 1251 | 29 |
1838788 | 1838788 | 2021-10-21 | Dallam | Texas | 48111 | 1205 | 29 |
1835539 | 1835539 | 2021-10-20 | Dallam | Texas | 48111 | 1204 | 29 |
1832290 | 1832290 | 2021-10-19 | Dallam | Texas | 48111 | 1204 | 29 |
1829041 | 1829041 | 2021-10-18 | Dallam | Texas | 48111 | 1192 | 29 |
1825792 | 1825792 | 2021-10-17 | Dallam | Texas | 48111 | 1192 | 29 |
1822543 | 1822543 | 2021-10-16 | Dallam | Texas | 48111 | 1192 | 29 |
1819294 | 1819294 | 2021-10-15 | Dallam | Texas | 48111 | 1191 | 29 |
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);