ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
187 rows where county = "Cedar" and deaths = 23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1648491 | 1648491 | 2021-08-24 | Cedar | Iowa | 19031 | 2011 | 23 |
1645243 | 1645243 | 2021-08-23 | Cedar | Iowa | 19031 | 2011 | 23 |
1645947 | 1645947 | 2021-08-23 | Cedar | Missouri | 29039 | 1534 | 23 |
1641994 | 1641994 | 2021-08-22 | Cedar | Iowa | 19031 | 2011 | 23 |
1642698 | 1642698 | 2021-08-22 | Cedar | Missouri | 29039 | 1532 | 23 |
1638744 | 1638744 | 2021-08-21 | Cedar | Iowa | 19031 | 2011 | 23 |
1639448 | 1639448 | 2021-08-21 | Cedar | Missouri | 29039 | 1528 | 23 |
1635494 | 1635494 | 2021-08-20 | Cedar | Iowa | 19031 | 2011 | 23 |
1636198 | 1636198 | 2021-08-20 | Cedar | Missouri | 29039 | 1525 | 23 |
1632244 | 1632244 | 2021-08-19 | Cedar | Iowa | 19031 | 2011 | 23 |
1632948 | 1632948 | 2021-08-19 | Cedar | Missouri | 29039 | 1522 | 23 |
1628997 | 1628997 | 2021-08-18 | Cedar | Iowa | 19031 | 2011 | 23 |
1629701 | 1629701 | 2021-08-18 | Cedar | Missouri | 29039 | 1511 | 23 |
1625750 | 1625750 | 2021-08-17 | Cedar | Iowa | 19031 | 1973 | 23 |
1626454 | 1626454 | 2021-08-17 | Cedar | Missouri | 29039 | 1505 | 23 |
1622503 | 1622503 | 2021-08-16 | Cedar | Iowa | 19031 | 1973 | 23 |
1619256 | 1619256 | 2021-08-15 | Cedar | Iowa | 19031 | 1973 | 23 |
1616008 | 1616008 | 2021-08-14 | Cedar | Iowa | 19031 | 1973 | 23 |
1612759 | 1612759 | 2021-08-13 | Cedar | Iowa | 19031 | 1973 | 23 |
1609511 | 1609511 | 2021-08-12 | Cedar | Iowa | 19031 | 1973 | 23 |
1606262 | 1606262 | 2021-08-11 | Cedar | Iowa | 19031 | 1973 | 23 |
1603013 | 1603013 | 2021-08-10 | Cedar | Iowa | 19031 | 1954 | 23 |
1599764 | 1599764 | 2021-08-09 | Cedar | Iowa | 19031 | 1954 | 23 |
1596516 | 1596516 | 2021-08-08 | Cedar | Iowa | 19031 | 1954 | 23 |
1593267 | 1593267 | 2021-08-07 | Cedar | Iowa | 19031 | 1954 | 23 |
1590018 | 1590018 | 2021-08-06 | Cedar | Iowa | 19031 | 1954 | 23 |
1586769 | 1586769 | 2021-08-05 | Cedar | Iowa | 19031 | 1954 | 23 |
1583519 | 1583519 | 2021-08-04 | Cedar | Iowa | 19031 | 1954 | 23 |
1580269 | 1580269 | 2021-08-03 | Cedar | Iowa | 19031 | 1943 | 23 |
1577020 | 1577020 | 2021-08-02 | Cedar | Iowa | 19031 | 1943 | 23 |
1573772 | 1573772 | 2021-08-01 | Cedar | Iowa | 19031 | 1943 | 23 |
1570524 | 1570524 | 2021-07-31 | Cedar | Iowa | 19031 | 1943 | 23 |
1567276 | 1567276 | 2021-07-30 | Cedar | Iowa | 19031 | 1943 | 23 |
1564028 | 1564028 | 2021-07-29 | Cedar | Iowa | 19031 | 1943 | 23 |
1560780 | 1560780 | 2021-07-28 | Cedar | Iowa | 19031 | 1943 | 23 |
1557533 | 1557533 | 2021-07-27 | Cedar | Iowa | 19031 | 1929 | 23 |
1554286 | 1554286 | 2021-07-26 | Cedar | Iowa | 19031 | 1929 | 23 |
1551039 | 1551039 | 2021-07-25 | Cedar | Iowa | 19031 | 1929 | 23 |
1547792 | 1547792 | 2021-07-24 | Cedar | Iowa | 19031 | 1929 | 23 |
1544545 | 1544545 | 2021-07-23 | Cedar | Iowa | 19031 | 1929 | 23 |
1541297 | 1541297 | 2021-07-22 | Cedar | Iowa | 19031 | 1929 | 23 |
1538050 | 1538050 | 2021-07-21 | Cedar | Iowa | 19031 | 1929 | 23 |
1534802 | 1534802 | 2021-07-20 | Cedar | Iowa | 19031 | 1926 | 23 |
1531555 | 1531555 | 2021-07-19 | Cedar | Iowa | 19031 | 1926 | 23 |
1528308 | 1528308 | 2021-07-18 | Cedar | Iowa | 19031 | 1926 | 23 |
1525061 | 1525061 | 2021-07-17 | Cedar | Iowa | 19031 | 1926 | 23 |
1521813 | 1521813 | 2021-07-16 | Cedar | Iowa | 19031 | 1926 | 23 |
1518565 | 1518565 | 2021-07-15 | Cedar | Iowa | 19031 | 1926 | 23 |
1515318 | 1515318 | 2021-07-14 | Cedar | Iowa | 19031 | 1926 | 23 |
1512072 | 1512072 | 2021-07-13 | Cedar | Iowa | 19031 | 1923 | 23 |
1508825 | 1508825 | 2021-07-12 | Cedar | Iowa | 19031 | 1923 | 23 |
1505579 | 1505579 | 2021-07-11 | Cedar | Iowa | 19031 | 1923 | 23 |
1502333 | 1502333 | 2021-07-10 | Cedar | Iowa | 19031 | 1923 | 23 |
1499087 | 1499087 | 2021-07-09 | Cedar | Iowa | 19031 | 1923 | 23 |
1495840 | 1495840 | 2021-07-08 | Cedar | Iowa | 19031 | 1923 | 23 |
1492594 | 1492594 | 2021-07-07 | Cedar | Iowa | 19031 | 1923 | 23 |
1489347 | 1489347 | 2021-07-06 | Cedar | Iowa | 19031 | 1925 | 23 |
1486100 | 1486100 | 2021-07-05 | Cedar | Iowa | 19031 | 1925 | 23 |
1482854 | 1482854 | 2021-07-04 | Cedar | Iowa | 19031 | 1925 | 23 |
1479607 | 1479607 | 2021-07-03 | Cedar | Iowa | 19031 | 1925 | 23 |
1476361 | 1476361 | 2021-07-02 | Cedar | Iowa | 19031 | 1925 | 23 |
1473115 | 1473115 | 2021-07-01 | Cedar | Iowa | 19031 | 1924 | 23 |
1469869 | 1469869 | 2021-06-30 | Cedar | Iowa | 19031 | 1924 | 23 |
1466624 | 1466624 | 2021-06-29 | Cedar | Iowa | 19031 | 1924 | 23 |
1463379 | 1463379 | 2021-06-28 | Cedar | Iowa | 19031 | 1925 | 23 |
1460134 | 1460134 | 2021-06-27 | Cedar | Iowa | 19031 | 1924 | 23 |
1456889 | 1456889 | 2021-06-26 | Cedar | Iowa | 19031 | 1924 | 23 |
1453644 | 1453644 | 2021-06-25 | Cedar | Iowa | 19031 | 1924 | 23 |
1450398 | 1450398 | 2021-06-24 | Cedar | Iowa | 19031 | 1924 | 23 |
1447153 | 1447153 | 2021-06-23 | Cedar | Iowa | 19031 | 1923 | 23 |
1443908 | 1443908 | 2021-06-22 | Cedar | Iowa | 19031 | 1923 | 23 |
1440663 | 1440663 | 2021-06-21 | Cedar | Iowa | 19031 | 1923 | 23 |
1437416 | 1437416 | 2021-06-20 | Cedar | Iowa | 19031 | 1924 | 23 |
1434169 | 1434169 | 2021-06-19 | Cedar | Iowa | 19031 | 1924 | 23 |
1430923 | 1430923 | 2021-06-18 | Cedar | Iowa | 19031 | 1923 | 23 |
1427678 | 1427678 | 2021-06-17 | Cedar | Iowa | 19031 | 1921 | 23 |
1424433 | 1424433 | 2021-06-16 | Cedar | Iowa | 19031 | 1922 | 23 |
1421185 | 1421185 | 2021-06-15 | Cedar | Iowa | 19031 | 1922 | 23 |
1417940 | 1417940 | 2021-06-14 | Cedar | Iowa | 19031 | 1921 | 23 |
1414694 | 1414694 | 2021-06-13 | Cedar | Iowa | 19031 | 1920 | 23 |
1411449 | 1411449 | 2021-06-12 | Cedar | Iowa | 19031 | 1919 | 23 |
1408204 | 1408204 | 2021-06-11 | Cedar | Iowa | 19031 | 1918 | 23 |
1404958 | 1404958 | 2021-06-10 | Cedar | Iowa | 19031 | 1918 | 23 |
1401713 | 1401713 | 2021-06-09 | Cedar | Iowa | 19031 | 1917 | 23 |
1398468 | 1398468 | 2021-06-08 | Cedar | Iowa | 19031 | 1914 | 23 |
1395221 | 1395221 | 2021-06-07 | Cedar | Iowa | 19031 | 1914 | 23 |
1391976 | 1391976 | 2021-06-06 | Cedar | Iowa | 19031 | 1914 | 23 |
1388731 | 1388731 | 2021-06-05 | Cedar | Iowa | 19031 | 1914 | 23 |
1385486 | 1385486 | 2021-06-04 | Cedar | Iowa | 19031 | 1914 | 23 |
1382240 | 1382240 | 2021-06-03 | Cedar | Iowa | 19031 | 1914 | 23 |
1378995 | 1378995 | 2021-06-02 | Cedar | Iowa | 19031 | 1913 | 23 |
1375749 | 1375749 | 2021-06-01 | Cedar | Iowa | 19031 | 1913 | 23 |
1372504 | 1372504 | 2021-05-31 | Cedar | Iowa | 19031 | 1914 | 23 |
1369259 | 1369259 | 2021-05-30 | Cedar | Iowa | 19031 | 1913 | 23 |
1366013 | 1366013 | 2021-05-29 | Cedar | Iowa | 19031 | 1913 | 23 |
1362767 | 1362767 | 2021-05-28 | Cedar | Iowa | 19031 | 1913 | 23 |
1359520 | 1359520 | 2021-05-27 | Cedar | Iowa | 19031 | 1913 | 23 |
1356274 | 1356274 | 2021-05-26 | Cedar | Iowa | 19031 | 1913 | 23 |
1353028 | 1353028 | 2021-05-25 | Cedar | Iowa | 19031 | 1911 | 23 |
1349782 | 1349782 | 2021-05-24 | Cedar | Iowa | 19031 | 1910 | 23 |
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);