ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29213 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717498 | 1717498 | 2021-09-14 | Taney | Missouri | 29213 | 8608 | 143 |
1714250 | 1714250 | 2021-09-13 | Taney | Missouri | 29213 | 8598 | 138 |
1711004 | 1711004 | 2021-09-12 | Taney | Missouri | 29213 | 8584 | 138 |
1707757 | 1707757 | 2021-09-11 | Taney | Missouri | 29213 | 8576 | 138 |
1704510 | 1704510 | 2021-09-10 | Taney | Missouri | 29213 | 8562 | 139 |
1701260 | 1701260 | 2021-09-09 | Taney | Missouri | 29213 | 8545 | 139 |
1698011 | 1698011 | 2021-09-08 | Taney | Missouri | 29213 | 8533 | 136 |
1694763 | 1694763 | 2021-09-07 | Taney | Missouri | 29213 | 8522 | 132 |
1691514 | 1691514 | 2021-09-06 | Taney | Missouri | 29213 | 8513 | 132 |
1688264 | 1688264 | 2021-09-05 | Taney | Missouri | 29213 | 8495 | 132 |
1685014 | 1685014 | 2021-09-04 | Taney | Missouri | 29213 | 8476 | 132 |
1681763 | 1681763 | 2021-09-03 | Taney | Missouri | 29213 | 8466 | 132 |
1678515 | 1678515 | 2021-09-02 | Taney | Missouri | 29213 | 8448 | 132 |
1675267 | 1675267 | 2021-09-01 | Taney | Missouri | 29213 | 8431 | 132 |
1672019 | 1672019 | 2021-08-31 | Taney | Missouri | 29213 | 8416 | 132 |
1668772 | 1668772 | 2021-08-30 | Taney | Missouri | 29213 | 8406 | 129 |
1665525 | 1665525 | 2021-08-29 | Taney | Missouri | 29213 | 8379 | 129 |
1662277 | 1662277 | 2021-08-28 | Taney | Missouri | 29213 | 8372 | 129 |
1659029 | 1659029 | 2021-08-27 | Taney | Missouri | 29213 | 8347 | 129 |
1655780 | 1655780 | 2021-08-26 | Taney | Missouri | 29213 | 8319 | 129 |
1652533 | 1652533 | 2021-08-25 | Taney | Missouri | 29213 | 8305 | 129 |
1649285 | 1649285 | 2021-08-24 | Taney | Missouri | 29213 | 8283 | 125 |
1646036 | 1646036 | 2021-08-23 | Taney | Missouri | 29213 | 8264 | 121 |
1642787 | 1642787 | 2021-08-22 | Taney | Missouri | 29213 | 8249 | 121 |
1639537 | 1639537 | 2021-08-21 | Taney | Missouri | 29213 | 8222 | 121 |
1636287 | 1636287 | 2021-08-20 | Taney | Missouri | 29213 | 8205 | 121 |
1633037 | 1633037 | 2021-08-19 | Taney | Missouri | 29213 | 8183 | 121 |
1629790 | 1629790 | 2021-08-18 | Taney | Missouri | 29213 | 8130 | 121 |
1626543 | 1626543 | 2021-08-17 | Taney | Missouri | 29213 | 8092 | 121 |
1623296 | 1623296 | 2021-08-16 | Taney | Missouri | 29213 | 8078 | 118 |
1620049 | 1620049 | 2021-08-15 | Taney | Missouri | 29213 | 8049 | 118 |
1616801 | 1616801 | 2021-08-14 | Taney | Missouri | 29213 | 8030 | 118 |
1613553 | 1613553 | 2021-08-13 | Taney | Missouri | 29213 | 7982 | 114 |
1610304 | 1610304 | 2021-08-12 | Taney | Missouri | 29213 | 7946 | 114 |
1607056 | 1607056 | 2021-08-11 | Taney | Missouri | 29213 | 7916 | 114 |
1603807 | 1603807 | 2021-08-10 | Taney | Missouri | 29213 | 7862 | 114 |
1600558 | 1600558 | 2021-08-09 | Taney | Missouri | 29213 | 7836 | 113 |
1597310 | 1597310 | 2021-08-08 | Taney | Missouri | 29213 | 7817 | 113 |
1594061 | 1594061 | 2021-08-07 | Taney | Missouri | 29213 | 7791 | 113 |
1590812 | 1590812 | 2021-08-06 | Taney | Missouri | 29213 | 7762 | 113 |
1587563 | 1587563 | 2021-08-05 | Taney | Missouri | 29213 | 7733 | 113 |
1584312 | 1584312 | 2021-08-04 | Taney | Missouri | 29213 | 7684 | 113 |
1581063 | 1581063 | 2021-08-03 | Taney | Missouri | 29213 | 7647 | 112 |
1577814 | 1577814 | 2021-08-02 | Taney | Missouri | 29213 | 7616 | 106 |
1574566 | 1574566 | 2021-08-01 | Taney | Missouri | 29213 | 7587 | 106 |
1571318 | 1571318 | 2021-07-31 | Taney | Missouri | 29213 | 7552 | 106 |
1568070 | 1568070 | 2021-07-30 | Taney | Missouri | 29213 | 7554 | 106 |
1564822 | 1564822 | 2021-07-29 | Taney | Missouri | 29213 | 7487 | 106 |
1561574 | 1561574 | 2021-07-28 | Taney | Missouri | 29213 | 7448 | 106 |
1558326 | 1558326 | 2021-07-27 | Taney | Missouri | 29213 | 7390 | 106 |
1555079 | 1555079 | 2021-07-26 | Taney | Missouri | 29213 | 7344 | 106 |
1551832 | 1551832 | 2021-07-25 | Taney | Missouri | 29213 | 7302 | 106 |
1548585 | 1548585 | 2021-07-24 | Taney | Missouri | 29213 | 7249 | 106 |
1545338 | 1545338 | 2021-07-23 | Taney | Missouri | 29213 | 7194 | 106 |
1542090 | 1542090 | 2021-07-22 | Taney | Missouri | 29213 | 7103 | 106 |
1538843 | 1538843 | 2021-07-21 | Taney | Missouri | 29213 | 7029 | 106 |
1535596 | 1535596 | 2021-07-20 | Taney | Missouri | 29213 | 6964 | 106 |
1532348 | 1532348 | 2021-07-19 | Taney | Missouri | 29213 | 6919 | 106 |
1529101 | 1529101 | 2021-07-18 | Taney | Missouri | 29213 | 6886 | 106 |
1525854 | 1525854 | 2021-07-17 | Taney | Missouri | 29213 | 6846 | 106 |
1522607 | 1522607 | 2021-07-16 | Taney | Missouri | 29213 | 6794 | 106 |
1519358 | 1519358 | 2021-07-15 | Taney | Missouri | 29213 | 6738 | 106 |
1516111 | 1516111 | 2021-07-14 | Taney | Missouri | 29213 | 6641 | 106 |
1512865 | 1512865 | 2021-07-13 | Taney | Missouri | 29213 | 6588 | 105 |
1509618 | 1509618 | 2021-07-12 | Taney | Missouri | 29213 | 6499 | 104 |
1506372 | 1506372 | 2021-07-11 | Taney | Missouri | 29213 | 6498 | 104 |
1503126 | 1503126 | 2021-07-10 | Taney | Missouri | 29213 | 6448 | 104 |
1499880 | 1499880 | 2021-07-09 | Taney | Missouri | 29213 | 6392 | 103 |
1496634 | 1496634 | 2021-07-08 | Taney | Missouri | 29213 | 6322 | 103 |
1493387 | 1493387 | 2021-07-07 | Taney | Missouri | 29213 | 6290 | 103 |
1490140 | 1490140 | 2021-07-06 | Taney | Missouri | 29213 | 6237 | 102 |
1486893 | 1486893 | 2021-07-05 | Taney | Missouri | 29213 | 6215 | 102 |
1483647 | 1483647 | 2021-07-04 | Taney | Missouri | 29213 | 6168 | 102 |
1480401 | 1480401 | 2021-07-03 | Taney | Missouri | 29213 | 6134 | 102 |
1477154 | 1477154 | 2021-07-02 | Taney | Missouri | 29213 | 6132 | 102 |
1473908 | 1473908 | 2021-07-01 | Taney | Missouri | 29213 | 6097 | 102 |
1470662 | 1470662 | 2021-06-30 | Taney | Missouri | 29213 | 6061 | 102 |
1467417 | 1467417 | 2021-06-29 | Taney | Missouri | 29213 | 6033 | 102 |
1464172 | 1464172 | 2021-06-28 | Taney | Missouri | 29213 | 6011 | 99 |
1460927 | 1460927 | 2021-06-27 | Taney | Missouri | 29213 | 5995 | 99 |
1457682 | 1457682 | 2021-06-26 | Taney | Missouri | 29213 | 5963 | 99 |
1454437 | 1454437 | 2021-06-25 | Taney | Missouri | 29213 | 5935 | 99 |
1451192 | 1451192 | 2021-06-24 | Taney | Missouri | 29213 | 5910 | 99 |
1447946 | 1447946 | 2021-06-23 | Taney | Missouri | 29213 | 5853 | 99 |
1444701 | 1444701 | 2021-06-22 | Taney | Missouri | 29213 | 5821 | 99 |
1441456 | 1441456 | 2021-06-21 | Taney | Missouri | 29213 | 5796 | 97 |
1438210 | 1438210 | 2021-06-20 | Taney | Missouri | 29213 | 5784 | 97 |
1434963 | 1434963 | 2021-06-19 | Taney | Missouri | 29213 | 5774 | 97 |
1431716 | 1431716 | 2021-06-18 | Taney | Missouri | 29213 | 5760 | 97 |
1428471 | 1428471 | 2021-06-17 | Taney | Missouri | 29213 | 5726 | 97 |
1425226 | 1425226 | 2021-06-16 | Taney | Missouri | 29213 | 5699 | 97 |
1421978 | 1421978 | 2021-06-15 | Taney | Missouri | 29213 | 5674 | 97 |
1418733 | 1418733 | 2021-06-14 | Taney | Missouri | 29213 | 5660 | 97 |
1415488 | 1415488 | 2021-06-13 | Taney | Missouri | 29213 | 5645 | 97 |
1412242 | 1412242 | 2021-06-12 | Taney | Missouri | 29213 | 5625 | 97 |
1408997 | 1408997 | 2021-06-11 | Taney | Missouri | 29213 | 5610 | 97 |
1405752 | 1405752 | 2021-06-10 | Taney | Missouri | 29213 | 5577 | 97 |
1402506 | 1402506 | 2021-06-09 | Taney | Missouri | 29213 | 5555 | 97 |
1399261 | 1399261 | 2021-06-08 | Taney | Missouri | 29213 | 5539 | 97 |
1396015 | 1396015 | 2021-06-07 | Taney | Missouri | 29213 | 5492 | 97 |
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);