ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

39 rows where county = "Runnels", deaths = 54 and state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases, date (date)

state 1

  • Texas · 39 ✖

fips 1

county 1

  • Runnels · 39 ✖
Link rowid date ▲ county state fips cases deaths
1968928 1968928 2021-11-30 Runnels Texas 48399 1738 54
1965677 1965677 2021-11-29 Runnels Texas 48399 1735 54
1962425 1962425 2021-11-28 Runnels Texas 48399 1733 54
1959174 1959174 2021-11-27 Runnels Texas 48399 1733 54
1955923 1955923 2021-11-26 Runnels Texas 48399 1733 54
1952672 1952672 2021-11-25 Runnels Texas 48399 1733 54
1949421 1949421 2021-11-24 Runnels Texas 48399 1733 54
1946170 1946170 2021-11-23 Runnels Texas 48399 1732 54
1942919 1942919 2021-11-22 Runnels Texas 48399 1731 54
1939669 1939669 2021-11-21 Runnels Texas 48399 1731 54
1936419 1936419 2021-11-20 Runnels Texas 48399 1731 54
1933169 1933169 2021-11-19 Runnels Texas 48399 1731 54
1929918 1929918 2021-11-18 Runnels Texas 48399 1731 54
1926668 1926668 2021-11-17 Runnels Texas 48399 1731 54
1923418 1923418 2021-11-16 Runnels Texas 48399 1730 54
1920169 1920169 2021-11-15 Runnels Texas 48399 1727 54
1916919 1916919 2021-11-14 Runnels Texas 48399 1727 54
1913669 1913669 2021-11-13 Runnels Texas 48399 1727 54
1910419 1910419 2021-11-12 Runnels Texas 48399 1727 54
1907170 1907170 2021-11-11 Runnels Texas 48399 1727 54
1903921 1903921 2021-11-10 Runnels Texas 48399 1717 54
1900671 1900671 2021-11-09 Runnels Texas 48399 1717 54
1897421 1897421 2021-11-08 Runnels Texas 48399 1715 54
1894171 1894171 2021-11-07 Runnels Texas 48399 1715 54
1890921 1890921 2021-11-06 Runnels Texas 48399 1715 54
1887671 1887671 2021-11-05 Runnels Texas 48399 1715 54
1884421 1884421 2021-11-04 Runnels Texas 48399 1715 54
1881172 1881172 2021-11-03 Runnels Texas 48399 1715 54
1877923 1877923 2021-11-02 Runnels Texas 48399 1715 54
1874674 1874674 2021-11-01 Runnels Texas 48399 1707 54
1871425 1871425 2021-10-31 Runnels Texas 48399 1707 54
1868176 1868176 2021-10-30 Runnels Texas 48399 1707 54
1864927 1864927 2021-10-29 Runnels Texas 48399 1706 54
1861678 1861678 2021-10-28 Runnels Texas 48399 1704 54
1858429 1858429 2021-10-27 Runnels Texas 48399 1703 54
1855180 1855180 2021-10-26 Runnels Texas 48399 1702 54
1851931 1851931 2021-10-25 Runnels Texas 48399 1701 54
1848681 1848681 2021-10-24 Runnels Texas 48399 1701 54
1845431 1845431 2021-10-23 Runnels Texas 48399 1701 54

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);