ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 38, fips = 48069 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 |
---|---|---|---|---|---|---|---|
1975262 | 1975262 | 2021-12-02 | Castro | Texas | 48069 | 1386 | 38 |
1972013 | 1972013 | 2021-12-01 | Castro | Texas | 48069 | 1385 | 38 |
1968763 | 1968763 | 2021-11-30 | Castro | Texas | 48069 | 1385 | 38 |
1965512 | 1965512 | 2021-11-29 | Castro | Texas | 48069 | 1384 | 38 |
1962260 | 1962260 | 2021-11-28 | Castro | Texas | 48069 | 1370 | 38 |
1959009 | 1959009 | 2021-11-27 | Castro | Texas | 48069 | 1370 | 38 |
1955758 | 1955758 | 2021-11-26 | Castro | Texas | 48069 | 1370 | 38 |
1952507 | 1952507 | 2021-11-25 | Castro | Texas | 48069 | 1370 | 38 |
1949256 | 1949256 | 2021-11-24 | Castro | Texas | 48069 | 1370 | 38 |
1946005 | 1946005 | 2021-11-23 | Castro | Texas | 48069 | 1370 | 38 |
1942754 | 1942754 | 2021-11-22 | Castro | Texas | 48069 | 1364 | 38 |
1939504 | 1939504 | 2021-11-21 | Castro | Texas | 48069 | 1364 | 38 |
1936254 | 1936254 | 2021-11-20 | Castro | Texas | 48069 | 1364 | 38 |
1933004 | 1933004 | 2021-11-19 | Castro | Texas | 48069 | 1362 | 38 |
1929753 | 1929753 | 2021-11-18 | Castro | Texas | 48069 | 1358 | 38 |
1926503 | 1926503 | 2021-11-17 | Castro | Texas | 48069 | 1358 | 38 |
1923253 | 1923253 | 2021-11-16 | Castro | Texas | 48069 | 1356 | 38 |
1920004 | 1920004 | 2021-11-15 | Castro | Texas | 48069 | 1355 | 38 |
1916754 | 1916754 | 2021-11-14 | Castro | Texas | 48069 | 1355 | 38 |
1913504 | 1913504 | 2021-11-13 | Castro | Texas | 48069 | 1355 | 38 |
1910254 | 1910254 | 2021-11-12 | Castro | Texas | 48069 | 1350 | 38 |
1907005 | 1907005 | 2021-11-11 | Castro | Texas | 48069 | 1350 | 38 |
1903756 | 1903756 | 2021-11-10 | Castro | Texas | 48069 | 1349 | 38 |
1900506 | 1900506 | 2021-11-09 | Castro | Texas | 48069 | 1349 | 38 |
1897256 | 1897256 | 2021-11-08 | Castro | Texas | 48069 | 1348 | 38 |
1894006 | 1894006 | 2021-11-07 | Castro | Texas | 48069 | 1348 | 38 |
1890756 | 1890756 | 2021-11-06 | Castro | Texas | 48069 | 1348 | 38 |
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);