ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where county = "Marshall", deaths = 28 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1853310 | 1853310 | 2021-10-26 | Marshall | Kansas | 20117 | 1451 | 28 |
1850061 | 1850061 | 2021-10-25 | Marshall | Kansas | 20117 | 1451 | 28 |
1846811 | 1846811 | 2021-10-24 | Marshall | Kansas | 20117 | 1442 | 28 |
1843561 | 1843561 | 2021-10-23 | Marshall | Kansas | 20117 | 1442 | 28 |
1840311 | 1840311 | 2021-10-22 | Marshall | Kansas | 20117 | 1442 | 28 |
1837062 | 1837062 | 2021-10-21 | Marshall | Kansas | 20117 | 1436 | 28 |
1833813 | 1833813 | 2021-10-20 | Marshall | Kansas | 20117 | 1436 | 28 |
1830564 | 1830564 | 2021-10-19 | Marshall | Kansas | 20117 | 1430 | 28 |
1827315 | 1827315 | 2021-10-18 | Marshall | Kansas | 20117 | 1430 | 28 |
1824066 | 1824066 | 2021-10-17 | Marshall | Kansas | 20117 | 1425 | 28 |
1820817 | 1820817 | 2021-10-16 | Marshall | Kansas | 20117 | 1425 | 28 |
1817568 | 1817568 | 2021-10-15 | Marshall | Kansas | 20117 | 1425 | 28 |
1814320 | 1814320 | 2021-10-14 | Marshall | Kansas | 20117 | 1420 | 28 |
1811071 | 1811071 | 2021-10-13 | Marshall | Kansas | 20117 | 1420 | 28 |
1807822 | 1807822 | 2021-10-12 | Marshall | Kansas | 20117 | 1414 | 28 |
1804571 | 1804571 | 2021-10-11 | Marshall | Kansas | 20117 | 1414 | 28 |
1801322 | 1801322 | 2021-10-10 | Marshall | Kansas | 20117 | 1408 | 28 |
1798073 | 1798073 | 2021-10-09 | Marshall | Kansas | 20117 | 1408 | 28 |
1794824 | 1794824 | 2021-10-08 | Marshall | Kansas | 20117 | 1408 | 28 |
1791576 | 1791576 | 2021-10-07 | Marshall | Kansas | 20117 | 1399 | 28 |
1788327 | 1788327 | 2021-10-06 | Marshall | Kansas | 20117 | 1399 | 28 |
1785078 | 1785078 | 2021-10-05 | Marshall | Kansas | 20117 | 1393 | 28 |
1781829 | 1781829 | 2021-10-04 | Marshall | Kansas | 20117 | 1393 | 28 |
1778579 | 1778579 | 2021-10-03 | Marshall | Kansas | 20117 | 1391 | 28 |
1775329 | 1775329 | 2021-10-02 | Marshall | Kansas | 20117 | 1391 | 28 |
1772079 | 1772079 | 2021-10-01 | Marshall | Kansas | 20117 | 1391 | 28 |
1768830 | 1768830 | 2021-09-30 | Marshall | Kansas | 20117 | 1391 | 28 |
1765581 | 1765581 | 2021-09-29 | Marshall | Kansas | 20117 | 1391 | 28 |
1762332 | 1762332 | 2021-09-28 | Marshall | Kansas | 20117 | 1386 | 28 |
1759084 | 1759084 | 2021-09-27 | Marshall | Kansas | 20117 | 1386 | 28 |
1755836 | 1755836 | 2021-09-26 | Marshall | Kansas | 20117 | 1382 | 28 |
1752588 | 1752588 | 2021-09-25 | Marshall | Kansas | 20117 | 1382 | 28 |
1749339 | 1749339 | 2021-09-24 | Marshall | Kansas | 20117 | 1382 | 28 |
1746089 | 1746089 | 2021-09-23 | Marshall | Kansas | 20117 | 1378 | 28 |
1742840 | 1742840 | 2021-09-22 | Marshall | Kansas | 20117 | 1378 | 28 |
1739591 | 1739591 | 2021-09-21 | Marshall | Kansas | 20117 | 1372 | 28 |
1736342 | 1736342 | 2021-09-20 | Marshall | Kansas | 20117 | 1372 | 28 |
1733092 | 1733092 | 2021-09-19 | Marshall | Kansas | 20117 | 1368 | 28 |
1729842 | 1729842 | 2021-09-18 | Marshall | Kansas | 20117 | 1368 | 28 |
1726592 | 1726592 | 2021-09-17 | Marshall | Kansas | 20117 | 1368 | 28 |
1723343 | 1723343 | 2021-09-16 | Marshall | Kansas | 20117 | 1361 | 28 |
1720094 | 1720094 | 2021-09-15 | Marshall | Kansas | 20117 | 1361 | 28 |
1716846 | 1716846 | 2021-09-14 | Marshall | Kansas | 20117 | 1352 | 28 |
1713600 | 1713600 | 2021-09-13 | Marshall | Kansas | 20117 | 1352 | 28 |
1710353 | 1710353 | 2021-09-12 | Marshall | Kansas | 20117 | 1348 | 28 |
1707106 | 1707106 | 2021-09-11 | Marshall | Kansas | 20117 | 1348 | 28 |
1703858 | 1703858 | 2021-09-10 | Marshall | Kansas | 20117 | 1348 | 28 |
1700608 | 1700608 | 2021-09-09 | Marshall | Kansas | 20117 | 1343 | 28 |
1697359 | 1697359 | 2021-09-08 | Marshall | Kansas | 20117 | 1343 | 28 |
1694111 | 1694111 | 2021-09-07 | Marshall | Kansas | 20117 | 1327 | 28 |
1690862 | 1690862 | 2021-09-06 | Marshall | Kansas | 20117 | 1327 | 28 |
1687612 | 1687612 | 2021-09-05 | Marshall | Kansas | 20117 | 1327 | 28 |
1684362 | 1684362 | 2021-09-04 | Marshall | Kansas | 20117 | 1327 | 28 |
1681111 | 1681111 | 2021-09-03 | Marshall | Kansas | 20117 | 1327 | 28 |
1677863 | 1677863 | 2021-09-02 | Marshall | Kansas | 20117 | 1316 | 28 |
1674616 | 1674616 | 2021-09-01 | Marshall | Kansas | 20117 | 1316 | 28 |
1671367 | 1671367 | 2021-08-31 | Marshall | Kansas | 20117 | 1302 | 28 |
1668120 | 1668120 | 2021-08-30 | Marshall | Kansas | 20117 | 1302 | 28 |
1664873 | 1664873 | 2021-08-29 | Marshall | Kansas | 20117 | 1299 | 28 |
1661625 | 1661625 | 2021-08-28 | Marshall | Kansas | 20117 | 1299 | 28 |
1658377 | 1658377 | 2021-08-27 | Marshall | Kansas | 20117 | 1299 | 28 |
1655129 | 1655129 | 2021-08-26 | Marshall | Kansas | 20117 | 1289 | 28 |
1651882 | 1651882 | 2021-08-25 | Marshall | Kansas | 20117 | 1289 | 28 |
1648633 | 1648633 | 2021-08-24 | Marshall | Kansas | 20117 | 1269 | 28 |
1645385 | 1645385 | 2021-08-23 | Marshall | Kansas | 20117 | 1269 | 28 |
1642136 | 1642136 | 2021-08-22 | Marshall | Kansas | 20117 | 1256 | 28 |
1638886 | 1638886 | 2021-08-21 | Marshall | Kansas | 20117 | 1256 | 28 |
1635636 | 1635636 | 2021-08-20 | Marshall | Kansas | 20117 | 1256 | 28 |
1632386 | 1632386 | 2021-08-19 | Marshall | Kansas | 20117 | 1250 | 28 |
1629139 | 1629139 | 2021-08-18 | Marshall | Kansas | 20117 | 1250 | 28 |
1625892 | 1625892 | 2021-08-17 | Marshall | Kansas | 20117 | 1245 | 28 |
1622645 | 1622645 | 2021-08-16 | Marshall | Kansas | 20117 | 1245 | 28 |
1619398 | 1619398 | 2021-08-15 | Marshall | Kansas | 20117 | 1242 | 28 |
1616150 | 1616150 | 2021-08-14 | Marshall | Kansas | 20117 | 1242 | 28 |
1612901 | 1612901 | 2021-08-13 | Marshall | Kansas | 20117 | 1242 | 28 |
1609653 | 1609653 | 2021-08-12 | Marshall | Kansas | 20117 | 1235 | 28 |
1606404 | 1606404 | 2021-08-11 | Marshall | Kansas | 20117 | 1235 | 28 |
1603155 | 1603155 | 2021-08-10 | Marshall | Kansas | 20117 | 1225 | 28 |
1599906 | 1599906 | 2021-08-09 | Marshall | Kansas | 20117 | 1225 | 28 |
1596658 | 1596658 | 2021-08-08 | Marshall | Kansas | 20117 | 1217 | 28 |
1593409 | 1593409 | 2021-08-07 | Marshall | Kansas | 20117 | 1217 | 28 |
1590160 | 1590160 | 2021-08-06 | Marshall | Kansas | 20117 | 1217 | 28 |
1586911 | 1586911 | 2021-08-05 | Marshall | Kansas | 20117 | 1209 | 28 |
1583661 | 1583661 | 2021-08-04 | Marshall | Kansas | 20117 | 1209 | 28 |
1580411 | 1580411 | 2021-08-03 | Marshall | Kansas | 20117 | 1195 | 28 |
1577162 | 1577162 | 2021-08-02 | Marshall | Kansas | 20117 | 1195 | 28 |
1573914 | 1573914 | 2021-08-01 | Marshall | Kansas | 20117 | 1190 | 28 |
1570666 | 1570666 | 2021-07-31 | Marshall | Kansas | 20117 | 1190 | 28 |
1567418 | 1567418 | 2021-07-30 | Marshall | Kansas | 20117 | 1190 | 28 |
1564170 | 1564170 | 2021-07-29 | Marshall | Kansas | 20117 | 1185 | 28 |
1560922 | 1560922 | 2021-07-28 | Marshall | Kansas | 20117 | 1185 | 28 |
1557675 | 1557675 | 2021-07-27 | Marshall | Kansas | 20117 | 1171 | 28 |
1554428 | 1554428 | 2021-07-26 | Marshall | Kansas | 20117 | 1171 | 28 |
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);