ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where county = "Jewell", deaths = 6 and state = "Kansas" 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 |
---|---|---|---|---|---|---|---|
1768817 | 1768817 | 2021-09-30 | Jewell | Kansas | 20089 | 315 | 6 |
1765568 | 1765568 | 2021-09-29 | Jewell | Kansas | 20089 | 315 | 6 |
1762319 | 1762319 | 2021-09-28 | Jewell | Kansas | 20089 | 303 | 6 |
1759071 | 1759071 | 2021-09-27 | Jewell | Kansas | 20089 | 303 | 6 |
1755823 | 1755823 | 2021-09-26 | Jewell | Kansas | 20089 | 296 | 6 |
1752575 | 1752575 | 2021-09-25 | Jewell | Kansas | 20089 | 296 | 6 |
1749326 | 1749326 | 2021-09-24 | Jewell | Kansas | 20089 | 296 | 6 |
1746076 | 1746076 | 2021-09-23 | Jewell | Kansas | 20089 | 289 | 6 |
1742827 | 1742827 | 2021-09-22 | Jewell | Kansas | 20089 | 289 | 6 |
1739578 | 1739578 | 2021-09-21 | Jewell | Kansas | 20089 | 278 | 6 |
1736329 | 1736329 | 2021-09-20 | Jewell | Kansas | 20089 | 278 | 6 |
1733079 | 1733079 | 2021-09-19 | Jewell | Kansas | 20089 | 275 | 6 |
1729829 | 1729829 | 2021-09-18 | Jewell | Kansas | 20089 | 275 | 6 |
1726579 | 1726579 | 2021-09-17 | Jewell | Kansas | 20089 | 275 | 6 |
1723330 | 1723330 | 2021-09-16 | Jewell | Kansas | 20089 | 268 | 6 |
1720081 | 1720081 | 2021-09-15 | Jewell | Kansas | 20089 | 268 | 6 |
1716833 | 1716833 | 2021-09-14 | Jewell | Kansas | 20089 | 265 | 6 |
1713587 | 1713587 | 2021-09-13 | Jewell | Kansas | 20089 | 265 | 6 |
1710340 | 1710340 | 2021-09-12 | Jewell | Kansas | 20089 | 262 | 6 |
1707093 | 1707093 | 2021-09-11 | Jewell | Kansas | 20089 | 262 | 6 |
1703845 | 1703845 | 2021-09-10 | Jewell | Kansas | 20089 | 262 | 6 |
1700595 | 1700595 | 2021-09-09 | Jewell | Kansas | 20089 | 249 | 6 |
1697346 | 1697346 | 2021-09-08 | Jewell | Kansas | 20089 | 249 | 6 |
1694098 | 1694098 | 2021-09-07 | Jewell | Kansas | 20089 | 233 | 6 |
1690849 | 1690849 | 2021-09-06 | Jewell | Kansas | 20089 | 233 | 6 |
1687599 | 1687599 | 2021-09-05 | Jewell | Kansas | 20089 | 233 | 6 |
1684349 | 1684349 | 2021-09-04 | Jewell | Kansas | 20089 | 233 | 6 |
1681098 | 1681098 | 2021-09-03 | Jewell | Kansas | 20089 | 233 | 6 |
1677850 | 1677850 | 2021-09-02 | Jewell | Kansas | 20089 | 230 | 6 |
1674603 | 1674603 | 2021-09-01 | Jewell | Kansas | 20089 | 230 | 6 |
1671354 | 1671354 | 2021-08-31 | Jewell | Kansas | 20089 | 225 | 6 |
1668107 | 1668107 | 2021-08-30 | Jewell | Kansas | 20089 | 225 | 6 |
1664860 | 1664860 | 2021-08-29 | Jewell | Kansas | 20089 | 223 | 6 |
1661612 | 1661612 | 2021-08-28 | Jewell | Kansas | 20089 | 223 | 6 |
1658364 | 1658364 | 2021-08-27 | Jewell | Kansas | 20089 | 223 | 6 |
1655116 | 1655116 | 2021-08-26 | Jewell | Kansas | 20089 | 221 | 6 |
1651869 | 1651869 | 2021-08-25 | Jewell | Kansas | 20089 | 221 | 6 |
1648620 | 1648620 | 2021-08-24 | Jewell | Kansas | 20089 | 221 | 6 |
1645372 | 1645372 | 2021-08-23 | Jewell | Kansas | 20089 | 221 | 6 |
1642123 | 1642123 | 2021-08-22 | Jewell | Kansas | 20089 | 219 | 6 |
1638873 | 1638873 | 2021-08-21 | Jewell | Kansas | 20089 | 219 | 6 |
1635623 | 1635623 | 2021-08-20 | Jewell | Kansas | 20089 | 219 | 6 |
1632373 | 1632373 | 2021-08-19 | Jewell | Kansas | 20089 | 219 | 6 |
1629126 | 1629126 | 2021-08-18 | Jewell | Kansas | 20089 | 219 | 6 |
1625879 | 1625879 | 2021-08-17 | Jewell | Kansas | 20089 | 218 | 6 |
1622632 | 1622632 | 2021-08-16 | Jewell | Kansas | 20089 | 218 | 6 |
1619385 | 1619385 | 2021-08-15 | Jewell | Kansas | 20089 | 216 | 6 |
1616137 | 1616137 | 2021-08-14 | Jewell | Kansas | 20089 | 216 | 6 |
1612888 | 1612888 | 2021-08-13 | Jewell | Kansas | 20089 | 216 | 6 |
1609640 | 1609640 | 2021-08-12 | Jewell | Kansas | 20089 | 216 | 6 |
1606391 | 1606391 | 2021-08-11 | Jewell | Kansas | 20089 | 216 | 6 |
1603142 | 1603142 | 2021-08-10 | Jewell | Kansas | 20089 | 215 | 6 |
1599893 | 1599893 | 2021-08-09 | Jewell | Kansas | 20089 | 215 | 6 |
1596645 | 1596645 | 2021-08-08 | Jewell | Kansas | 20089 | 215 | 6 |
1593396 | 1593396 | 2021-08-07 | Jewell | Kansas | 20089 | 215 | 6 |
1590147 | 1590147 | 2021-08-06 | Jewell | Kansas | 20089 | 215 | 6 |
1586898 | 1586898 | 2021-08-05 | Jewell | Kansas | 20089 | 215 | 6 |
1583648 | 1583648 | 2021-08-04 | Jewell | Kansas | 20089 | 215 | 6 |
1580398 | 1580398 | 2021-08-03 | Jewell | Kansas | 20089 | 217 | 6 |
1577149 | 1577149 | 2021-08-02 | Jewell | Kansas | 20089 | 217 | 6 |
1573901 | 1573901 | 2021-08-01 | Jewell | Kansas | 20089 | 217 | 6 |
1570653 | 1570653 | 2021-07-31 | Jewell | Kansas | 20089 | 217 | 6 |
1567405 | 1567405 | 2021-07-30 | Jewell | Kansas | 20089 | 217 | 6 |
1564157 | 1564157 | 2021-07-29 | Jewell | Kansas | 20089 | 217 | 6 |
1560909 | 1560909 | 2021-07-28 | Jewell | Kansas | 20089 | 217 | 6 |
1557662 | 1557662 | 2021-07-27 | Jewell | Kansas | 20089 | 217 | 6 |
1554415 | 1554415 | 2021-07-26 | Jewell | Kansas | 20089 | 217 | 6 |
1551168 | 1551168 | 2021-07-25 | Jewell | Kansas | 20089 | 217 | 6 |
1547921 | 1547921 | 2021-07-24 | Jewell | Kansas | 20089 | 217 | 6 |
1544674 | 1544674 | 2021-07-23 | Jewell | Kansas | 20089 | 217 | 6 |
1541426 | 1541426 | 2021-07-22 | Jewell | Kansas | 20089 | 217 | 6 |
1538179 | 1538179 | 2021-07-21 | Jewell | Kansas | 20089 | 217 | 6 |
1534931 | 1534931 | 2021-07-20 | Jewell | Kansas | 20089 | 215 | 6 |
1531684 | 1531684 | 2021-07-19 | Jewell | Kansas | 20089 | 215 | 6 |
1528437 | 1528437 | 2021-07-18 | Jewell | Kansas | 20089 | 215 | 6 |
1525190 | 1525190 | 2021-07-17 | Jewell | Kansas | 20089 | 215 | 6 |
1521942 | 1521942 | 2021-07-16 | Jewell | Kansas | 20089 | 215 | 6 |
1518694 | 1518694 | 2021-07-15 | Jewell | Kansas | 20089 | 215 | 6 |
1515447 | 1515447 | 2021-07-14 | Jewell | Kansas | 20089 | 215 | 6 |
1512201 | 1512201 | 2021-07-13 | Jewell | Kansas | 20089 | 215 | 6 |
1508954 | 1508954 | 2021-07-12 | Jewell | Kansas | 20089 | 215 | 6 |
1505708 | 1505708 | 2021-07-11 | Jewell | Kansas | 20089 | 215 | 6 |
1502462 | 1502462 | 2021-07-10 | Jewell | Kansas | 20089 | 215 | 6 |
1499216 | 1499216 | 2021-07-09 | Jewell | Kansas | 20089 | 215 | 6 |
1495969 | 1495969 | 2021-07-08 | Jewell | Kansas | 20089 | 215 | 6 |
1492723 | 1492723 | 2021-07-07 | Jewell | Kansas | 20089 | 215 | 6 |
1489476 | 1489476 | 2021-07-06 | Jewell | Kansas | 20089 | 216 | 6 |
1486229 | 1486229 | 2021-07-05 | Jewell | Kansas | 20089 | 216 | 6 |
1482983 | 1482983 | 2021-07-04 | Jewell | Kansas | 20089 | 216 | 6 |
1479736 | 1479736 | 2021-07-03 | Jewell | Kansas | 20089 | 216 | 6 |
1476490 | 1476490 | 2021-07-02 | Jewell | Kansas | 20089 | 216 | 6 |
1473244 | 1473244 | 2021-07-01 | Jewell | Kansas | 20089 | 216 | 6 |
1469998 | 1469998 | 2021-06-30 | Jewell | Kansas | 20089 | 216 | 6 |
1466753 | 1466753 | 2021-06-29 | Jewell | Kansas | 20089 | 216 | 6 |
1463508 | 1463508 | 2021-06-28 | Jewell | Kansas | 20089 | 216 | 6 |
1460263 | 1460263 | 2021-06-27 | Jewell | Kansas | 20089 | 216 | 6 |
1457018 | 1457018 | 2021-06-26 | Jewell | Kansas | 20089 | 216 | 6 |
1453773 | 1453773 | 2021-06-25 | Jewell | Kansas | 20089 | 216 | 6 |
1450527 | 1450527 | 2021-06-24 | Jewell | Kansas | 20089 | 215 | 6 |
1447282 | 1447282 | 2021-06-23 | Jewell | Kansas | 20089 | 215 | 6 |
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);