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

93 rows where county = "Choctaw", deaths = 27 and fips = 28019 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 28019 · 93 ✖

county 1

  • Choctaw · 93 ✖
Link rowid date ▲ county state fips cases deaths
2152842 2152842 2022-01-26 Choctaw Mississippi 28019 1780 27
2149590 2149590 2022-01-25 Choctaw Mississippi 28019 1765 27
2146338 2146338 2022-01-24 Choctaw Mississippi 28019 1743 27
2143083 2143083 2022-01-23 Choctaw Mississippi 28019 1714 27
2139828 2139828 2022-01-22 Choctaw Mississippi 28019 1714 27
2136572 2136572 2022-01-21 Choctaw Mississippi 28019 1714 27
2133320 2133320 2022-01-20 Choctaw Mississippi 28019 1694 27
2130067 2130067 2022-01-19 Choctaw Mississippi 28019 1667 27
2126813 2126813 2022-01-18 Choctaw Mississippi 28019 1629 27
2123561 2123561 2022-01-17 Choctaw Mississippi 28019 1583 27
2120309 2120309 2022-01-16 Choctaw Mississippi 28019 1583 27
2117057 2117057 2022-01-15 Choctaw Mississippi 28019 1583 27
2113806 2113806 2022-01-14 Choctaw Mississippi 28019 1583 27
2110554 2110554 2022-01-13 Choctaw Mississippi 28019 1572 27
2107303 2107303 2022-01-12 Choctaw Mississippi 28019 1552 27
2104052 2104052 2022-01-11 Choctaw Mississippi 28019 1509 27
2100801 2100801 2022-01-10 Choctaw Mississippi 28019 1493 27
2097550 2097550 2022-01-09 Choctaw Mississippi 28019 1473 27
2094298 2094298 2022-01-08 Choctaw Mississippi 28019 1473 27
2091046 2091046 2022-01-07 Choctaw Mississippi 28019 1473 27
2087795 2087795 2022-01-06 Choctaw Mississippi 28019 1469 27
2084543 2084543 2022-01-05 Choctaw Mississippi 28019 1458 27
2081291 2081291 2022-01-04 Choctaw Mississippi 28019 1447 27
2078039 2078039 2022-01-03 Choctaw Mississippi 28019 1438 27
2074788 2074788 2022-01-02 Choctaw Mississippi 28019 1413 27
2071537 2071537 2022-01-01 Choctaw Mississippi 28019 1413 27
2068286 2068286 2021-12-31 Choctaw Mississippi 28019 1413 27
2065035 2065035 2021-12-30 Choctaw Mississippi 28019 1413 27
2061785 2061785 2021-12-29 Choctaw Mississippi 28019 1407 27
2058536 2058536 2021-12-28 Choctaw Mississippi 28019 1403 27
2055287 2055287 2021-12-27 Choctaw Mississippi 28019 1400 27
2052037 2052037 2021-12-26 Choctaw Mississippi 28019 1394 27
2048787 2048787 2021-12-25 Choctaw Mississippi 28019 1394 27
2045537 2045537 2021-12-24 Choctaw Mississippi 28019 1394 27
2042287 2042287 2021-12-23 Choctaw Mississippi 28019 1394 27
2039038 2039038 2021-12-22 Choctaw Mississippi 28019 1394 27
2035788 2035788 2021-12-21 Choctaw Mississippi 28019 1393 27
2032538 2032538 2021-12-20 Choctaw Mississippi 28019 1392 27
2029287 2029287 2021-12-19 Choctaw Mississippi 28019 1391 27
2026036 2026036 2021-12-18 Choctaw Mississippi 28019 1391 27
2022785 2022785 2021-12-17 Choctaw Mississippi 28019 1391 27
2019534 2019534 2021-12-16 Choctaw Mississippi 28019 1390 27
2016284 2016284 2021-12-15 Choctaw Mississippi 28019 1387 27
2013033 2013033 2021-12-14 Choctaw Mississippi 28019 1385 27
2009782 2009782 2021-12-13 Choctaw Mississippi 28019 1385 27
2006531 2006531 2021-12-12 Choctaw Mississippi 28019 1384 27
2003280 2003280 2021-12-11 Choctaw Mississippi 28019 1384 27
2000030 2000030 2021-12-10 Choctaw Mississippi 28019 1384 27
1996779 1996779 2021-12-09 Choctaw Mississippi 28019 1384 27
1993528 1993528 2021-12-08 Choctaw Mississippi 28019 1380 27
1990277 1990277 2021-12-07 Choctaw Mississippi 28019 1380 27
1987027 1987027 2021-12-06 Choctaw Mississippi 28019 1378 27
1983777 1983777 2021-12-05 Choctaw Mississippi 28019 1370 27
1980527 1980527 2021-12-04 Choctaw Mississippi 28019 1370 27
1977277 1977277 2021-12-03 Choctaw Mississippi 28019 1370 27
1974027 1974027 2021-12-02 Choctaw Mississippi 28019 1370 27
1970778 1970778 2021-12-01 Choctaw Mississippi 28019 1369 27
1967528 1967528 2021-11-30 Choctaw Mississippi 28019 1367 27
1964276 1964276 2021-11-29 Choctaw Mississippi 28019 1367 27
1961025 1961025 2021-11-28 Choctaw Mississippi 28019 1365 27
1957774 1957774 2021-11-27 Choctaw Mississippi 28019 1365 27
1954523 1954523 2021-11-26 Choctaw Mississippi 28019 1365 27
1951272 1951272 2021-11-25 Choctaw Mississippi 28019 1365 27
1948021 1948021 2021-11-24 Choctaw Mississippi 28019 1365 27
1944770 1944770 2021-11-23 Choctaw Mississippi 28019 1364 27
1941519 1941519 2021-11-22 Choctaw Mississippi 28019 1364 27
1938269 1938269 2021-11-21 Choctaw Mississippi 28019 1364 27
1935019 1935019 2021-11-20 Choctaw Mississippi 28019 1364 27
1931769 1931769 2021-11-19 Choctaw Mississippi 28019 1364 27
1928518 1928518 2021-11-18 Choctaw Mississippi 28019 1359 27
1925268 1925268 2021-11-17 Choctaw Mississippi 28019 1358 27
1922019 1922019 2021-11-16 Choctaw Mississippi 28019 1359 27
1918769 1918769 2021-11-15 Choctaw Mississippi 28019 1357 27
1915519 1915519 2021-11-14 Choctaw Mississippi 28019 1356 27
1912269 1912269 2021-11-13 Choctaw Mississippi 28019 1356 27
1909019 1909019 2021-11-12 Choctaw Mississippi 28019 1356 27
1905770 1905770 2021-11-11 Choctaw Mississippi 28019 1356 27
1902521 1902521 2021-11-10 Choctaw Mississippi 28019 1356 27
1899271 1899271 2021-11-09 Choctaw Mississippi 28019 1355 27
1896021 1896021 2021-11-08 Choctaw Mississippi 28019 1353 27
1892771 1892771 2021-11-07 Choctaw Mississippi 28019 1352 27
1889521 1889521 2021-11-06 Choctaw Mississippi 28019 1352 27
1886271 1886271 2021-11-05 Choctaw Mississippi 28019 1352 27
1883022 1883022 2021-11-04 Choctaw Mississippi 28019 1349 27
1879773 1879773 2021-11-03 Choctaw Mississippi 28019 1346 27
1876524 1876524 2021-11-02 Choctaw Mississippi 28019 1347 27
1873275 1873275 2021-11-01 Choctaw Mississippi 28019 1347 27
1870026 1870026 2021-10-31 Choctaw Mississippi 28019 1347 27
1866777 1866777 2021-10-30 Choctaw Mississippi 28019 1347 27
1863528 1863528 2021-10-29 Choctaw Mississippi 28019 1347 27
1860279 1860279 2021-10-28 Choctaw Mississippi 28019 1347 27
1857030 1857030 2021-10-27 Choctaw Mississippi 28019 1345 27
1853781 1853781 2021-10-26 Choctaw Mississippi 28019 1346 27

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