ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where county = "Texas" and deaths = 23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1509619 | 1509619 | 2021-07-12 | Texas | Missouri | 29215 | 2098 | 23 |
1506373 | 1506373 | 2021-07-11 | Texas | Missouri | 29215 | 2098 | 23 |
1503127 | 1503127 | 2021-07-10 | Texas | Missouri | 29215 | 2093 | 23 |
1499881 | 1499881 | 2021-07-09 | Texas | Missouri | 29215 | 2082 | 23 |
1496635 | 1496635 | 2021-07-08 | Texas | Missouri | 29215 | 2071 | 23 |
1493388 | 1493388 | 2021-07-07 | Texas | Missouri | 29215 | 2056 | 23 |
1490141 | 1490141 | 2021-07-06 | Texas | Missouri | 29215 | 2052 | 23 |
1486894 | 1486894 | 2021-07-05 | Texas | Missouri | 29215 | 2051 | 23 |
1483648 | 1483648 | 2021-07-04 | Texas | Missouri | 29215 | 2048 | 23 |
1480402 | 1480402 | 2021-07-03 | Texas | Missouri | 29215 | 2037 | 23 |
1477155 | 1477155 | 2021-07-02 | Texas | Missouri | 29215 | 2036 | 23 |
1473909 | 1473909 | 2021-07-01 | Texas | Missouri | 29215 | 2026 | 23 |
1470663 | 1470663 | 2021-06-30 | Texas | Missouri | 29215 | 2024 | 23 |
1467418 | 1467418 | 2021-06-29 | Texas | Missouri | 29215 | 2016 | 23 |
1464173 | 1464173 | 2021-06-28 | Texas | Missouri | 29215 | 2014 | 23 |
1460928 | 1460928 | 2021-06-27 | Texas | Missouri | 29215 | 2014 | 23 |
1457683 | 1457683 | 2021-06-26 | Texas | Missouri | 29215 | 2010 | 23 |
1454438 | 1454438 | 2021-06-25 | Texas | Missouri | 29215 | 2007 | 23 |
1451193 | 1451193 | 2021-06-24 | Texas | Missouri | 29215 | 2003 | 23 |
1447947 | 1447947 | 2021-06-23 | Texas | Missouri | 29215 | 2000 | 23 |
1444702 | 1444702 | 2021-06-22 | Texas | Missouri | 29215 | 1993 | 23 |
1441457 | 1441457 | 2021-06-21 | Texas | Missouri | 29215 | 1984 | 23 |
1438211 | 1438211 | 2021-06-20 | Texas | Missouri | 29215 | 1980 | 23 |
1434964 | 1434964 | 2021-06-19 | Texas | Missouri | 29215 | 1976 | 23 |
1431717 | 1431717 | 2021-06-18 | Texas | Missouri | 29215 | 1972 | 23 |
1428472 | 1428472 | 2021-06-17 | Texas | Missouri | 29215 | 1962 | 23 |
1425227 | 1425227 | 2021-06-16 | Texas | Missouri | 29215 | 1955 | 23 |
1421979 | 1421979 | 2021-06-15 | Texas | Missouri | 29215 | 1936 | 23 |
1418734 | 1418734 | 2021-06-14 | Texas | Missouri | 29215 | 1935 | 23 |
1415489 | 1415489 | 2021-06-13 | Texas | Missouri | 29215 | 1931 | 23 |
1412243 | 1412243 | 2021-06-12 | Texas | Missouri | 29215 | 1928 | 23 |
1408998 | 1408998 | 2021-06-11 | Texas | Missouri | 29215 | 1926 | 23 |
1405753 | 1405753 | 2021-06-10 | Texas | Missouri | 29215 | 1915 | 23 |
1402507 | 1402507 | 2021-06-09 | Texas | Missouri | 29215 | 1909 | 23 |
1399262 | 1399262 | 2021-06-08 | Texas | Missouri | 29215 | 1900 | 23 |
1396016 | 1396016 | 2021-06-07 | Texas | Missouri | 29215 | 1899 | 23 |
1392770 | 1392770 | 2021-06-06 | Texas | Missouri | 29215 | 1899 | 23 |
1389525 | 1389525 | 2021-06-05 | Texas | Missouri | 29215 | 1899 | 23 |
1386280 | 1386280 | 2021-06-04 | Texas | Missouri | 29215 | 1896 | 23 |
1383035 | 1383035 | 2021-06-03 | Texas | Missouri | 29215 | 1887 | 23 |
1379789 | 1379789 | 2021-06-02 | Texas | Missouri | 29215 | 1880 | 23 |
1376544 | 1376544 | 2021-06-01 | Texas | Missouri | 29215 | 1871 | 23 |
1373298 | 1373298 | 2021-05-31 | Texas | Missouri | 29215 | 1870 | 23 |
1370053 | 1370053 | 2021-05-30 | Texas | Missouri | 29215 | 1869 | 23 |
1366807 | 1366807 | 2021-05-29 | Texas | Missouri | 29215 | 1868 | 23 |
1363561 | 1363561 | 2021-05-28 | Texas | Missouri | 29215 | 1865 | 23 |
1360314 | 1360314 | 2021-05-27 | Texas | Missouri | 29215 | 1860 | 23 |
1357068 | 1357068 | 2021-05-26 | Texas | Missouri | 29215 | 1856 | 23 |
1353822 | 1353822 | 2021-05-25 | Texas | Missouri | 29215 | 1855 | 23 |
1350576 | 1350576 | 2021-05-24 | Texas | Missouri | 29215 | 1843 | 23 |
1347330 | 1347330 | 2021-05-23 | Texas | Missouri | 29215 | 1843 | 23 |
1344082 | 1344082 | 2021-05-22 | Texas | Missouri | 29215 | 1842 | 23 |
1340833 | 1340833 | 2021-05-21 | Texas | Missouri | 29215 | 1840 | 23 |
1337586 | 1337586 | 2021-05-20 | Texas | Missouri | 29215 | 1840 | 23 |
1334339 | 1334339 | 2021-05-19 | Texas | Missouri | 29215 | 1840 | 23 |
1331092 | 1331092 | 2021-05-18 | Texas | Missouri | 29215 | 1839 | 23 |
1327845 | 1327845 | 2021-05-17 | Texas | Missouri | 29215 | 1839 | 23 |
1324599 | 1324599 | 2021-05-16 | Texas | Missouri | 29215 | 1839 | 23 |
1321353 | 1321353 | 2021-05-15 | Texas | Missouri | 29215 | 1838 | 23 |
1318107 | 1318107 | 2021-05-14 | Texas | Missouri | 29215 | 1838 | 23 |
1314859 | 1314859 | 2021-05-13 | Texas | Missouri | 29215 | 1838 | 23 |
1311613 | 1311613 | 2021-05-12 | Texas | Missouri | 29215 | 1835 | 23 |
1308366 | 1308366 | 2021-05-11 | Texas | Missouri | 29215 | 1835 | 23 |
1305120 | 1305120 | 2021-05-10 | Texas | Missouri | 29215 | 1832 | 23 |
1301874 | 1301874 | 2021-05-09 | Texas | Missouri | 29215 | 1832 | 23 |
1298626 | 1298626 | 2021-05-08 | Texas | Missouri | 29215 | 1831 | 23 |
1295380 | 1295380 | 2021-05-07 | Texas | Missouri | 29215 | 1831 | 23 |
1292134 | 1292134 | 2021-05-06 | Texas | Missouri | 29215 | 1830 | 23 |
1288888 | 1288888 | 2021-05-05 | Texas | Missouri | 29215 | 1828 | 23 |
1285642 | 1285642 | 2021-05-04 | Texas | Missouri | 29215 | 1826 | 23 |
1282396 | 1282396 | 2021-05-03 | Texas | Missouri | 29215 | 1825 | 23 |
1279149 | 1279149 | 2021-05-02 | Texas | Missouri | 29215 | 1825 | 23 |
1275902 | 1275902 | 2021-05-01 | Texas | Missouri | 29215 | 1823 | 23 |
1272655 | 1272655 | 2021-04-30 | Texas | Missouri | 29215 | 1822 | 23 |
1269408 | 1269408 | 2021-04-29 | Texas | Missouri | 29215 | 1822 | 23 |
1266161 | 1266161 | 2021-04-28 | Texas | Missouri | 29215 | 1821 | 23 |
1262914 | 1262914 | 2021-04-27 | Texas | Missouri | 29215 | 1817 | 23 |
1259667 | 1259667 | 2021-04-26 | Texas | Missouri | 29215 | 1817 | 23 |
1256420 | 1256420 | 2021-04-25 | Texas | Missouri | 29215 | 1817 | 23 |
1253173 | 1253173 | 2021-04-24 | Texas | Missouri | 29215 | 1817 | 23 |
1249926 | 1249926 | 2021-04-23 | Texas | Missouri | 29215 | 1817 | 23 |
1246679 | 1246679 | 2021-04-22 | Texas | Missouri | 29215 | 1816 | 23 |
1243432 | 1243432 | 2021-04-21 | Texas | Missouri | 29215 | 1815 | 23 |
1240185 | 1240185 | 2021-04-20 | Texas | Missouri | 29215 | 1812 | 23 |
1236938 | 1236938 | 2021-04-19 | Texas | Missouri | 29215 | 1812 | 23 |
1233691 | 1233691 | 2021-04-18 | Texas | Missouri | 29215 | 1812 | 23 |
1230443 | 1230443 | 2021-04-17 | Texas | Missouri | 29215 | 1812 | 23 |
1227195 | 1227195 | 2021-04-16 | Texas | Missouri | 29215 | 1836 | 23 |
1223947 | 1223947 | 2021-04-15 | Texas | Missouri | 29215 | 1836 | 23 |
1220700 | 1220700 | 2021-04-14 | Texas | Missouri | 29215 | 1836 | 23 |
1217452 | 1217452 | 2021-04-13 | Texas | Missouri | 29215 | 1834 | 23 |
1214205 | 1214205 | 2021-04-12 | Texas | Missouri | 29215 | 1830 | 23 |
1210957 | 1210957 | 2021-04-11 | Texas | Missouri | 29215 | 1830 | 23 |
1207708 | 1207708 | 2021-04-10 | Texas | Missouri | 29215 | 1830 | 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);