ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 29019 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717399 | 1717399 | 2021-09-14 | Boone | Missouri | 29019 | 23900 | 149 |
1714151 | 1714151 | 2021-09-13 | Boone | Missouri | 29019 | 23831 | 149 |
1710905 | 1710905 | 2021-09-12 | Boone | Missouri | 29019 | 23671 | 149 |
1707658 | 1707658 | 2021-09-11 | Boone | Missouri | 29019 | 23671 | 149 |
1704411 | 1704411 | 2021-09-10 | Boone | Missouri | 29019 | 23671 | 149 |
1701161 | 1701161 | 2021-09-09 | Boone | Missouri | 29019 | 23581 | 146 |
1697912 | 1697912 | 2021-09-08 | Boone | Missouri | 29019 | 23474 | 146 |
1694664 | 1694664 | 2021-09-07 | Boone | Missouri | 29019 | 23399 | 145 |
1691415 | 1691415 | 2021-09-06 | Boone | Missouri | 29019 | 23176 | 141 |
1688165 | 1688165 | 2021-09-05 | Boone | Missouri | 29019 | 23176 | 141 |
1684915 | 1684915 | 2021-09-04 | Boone | Missouri | 29019 | 23176 | 141 |
1681664 | 1681664 | 2021-09-03 | Boone | Missouri | 29019 | 23176 | 141 |
1678416 | 1678416 | 2021-09-02 | Boone | Missouri | 29019 | 22991 | 140 |
1675168 | 1675168 | 2021-09-01 | Boone | Missouri | 29019 | 22991 | 140 |
1671920 | 1671920 | 2021-08-31 | Boone | Missouri | 29019 | 22991 | 140 |
1668673 | 1668673 | 2021-08-30 | Boone | Missouri | 29019 | 22931 | 140 |
1665426 | 1665426 | 2021-08-29 | Boone | Missouri | 29019 | 22803 | 137 |
1662178 | 1662178 | 2021-08-28 | Boone | Missouri | 29019 | 22803 | 137 |
1658930 | 1658930 | 2021-08-27 | Boone | Missouri | 29019 | 22803 | 137 |
1655681 | 1655681 | 2021-08-26 | Boone | Missouri | 29019 | 22749 | 137 |
1652434 | 1652434 | 2021-08-25 | Boone | Missouri | 29019 | 22684 | 136 |
1649186 | 1649186 | 2021-08-24 | Boone | Missouri | 29019 | 22623 | 135 |
1645937 | 1645937 | 2021-08-23 | Boone | Missouri | 29019 | 22549 | 134 |
1642688 | 1642688 | 2021-08-22 | Boone | Missouri | 29019 | 22440 | 133 |
1639438 | 1639438 | 2021-08-21 | Boone | Missouri | 29019 | 22440 | 133 |
1636188 | 1636188 | 2021-08-20 | Boone | Missouri | 29019 | 22440 | 133 |
1632938 | 1632938 | 2021-08-19 | Boone | Missouri | 29019 | 22361 | 131 |
1629691 | 1629691 | 2021-08-18 | Boone | Missouri | 29019 | 22293 | 131 |
1626444 | 1626444 | 2021-08-17 | Boone | Missouri | 29019 | 22200 | 130 |
1623197 | 1623197 | 2021-08-16 | Boone | Missouri | 29019 | 22160 | 129 |
1619950 | 1619950 | 2021-08-15 | Boone | Missouri | 29019 | 22008 | 129 |
1616702 | 1616702 | 2021-08-14 | Boone | Missouri | 29019 | 22008 | 129 |
1613454 | 1613454 | 2021-08-13 | Boone | Missouri | 29019 | 22008 | 129 |
1610205 | 1610205 | 2021-08-12 | Boone | Missouri | 29019 | 21849 | 128 |
1606957 | 1606957 | 2021-08-11 | Boone | Missouri | 29019 | 21849 | 128 |
1603708 | 1603708 | 2021-08-10 | Boone | Missouri | 29019 | 21769 | 127 |
1600459 | 1600459 | 2021-08-09 | Boone | Missouri | 29019 | 21679 | 126 |
1597211 | 1597211 | 2021-08-08 | Boone | Missouri | 29019 | 21501 | 123 |
1593962 | 1593962 | 2021-08-07 | Boone | Missouri | 29019 | 21501 | 123 |
1590713 | 1590713 | 2021-08-06 | Boone | Missouri | 29019 | 21501 | 123 |
1587464 | 1587464 | 2021-08-05 | Boone | Missouri | 29019 | 21424 | 123 |
1584213 | 1584213 | 2021-08-04 | Boone | Missouri | 29019 | 21325 | 121 |
1580964 | 1580964 | 2021-08-03 | Boone | Missouri | 29019 | 21205 | 120 |
1577715 | 1577715 | 2021-08-02 | Boone | Missouri | 29019 | 21120 | 119 |
1574467 | 1574467 | 2021-08-01 | Boone | Missouri | 29019 | 20996 | 119 |
1571219 | 1571219 | 2021-07-31 | Boone | Missouri | 29019 | 20996 | 119 |
1567971 | 1567971 | 2021-07-30 | Boone | Missouri | 29019 | 20996 | 119 |
1564723 | 1564723 | 2021-07-29 | Boone | Missouri | 29019 | 20918 | 118 |
1561475 | 1561475 | 2021-07-28 | Boone | Missouri | 29019 | 20788 | 118 |
1558227 | 1558227 | 2021-07-27 | Boone | Missouri | 29019 | 20673 | 118 |
1554980 | 1554980 | 2021-07-26 | Boone | Missouri | 29019 | 20618 | 118 |
1551733 | 1551733 | 2021-07-25 | Boone | Missouri | 29019 | 20451 | 118 |
1548486 | 1548486 | 2021-07-24 | Boone | Missouri | 29019 | 20451 | 118 |
1545239 | 1545239 | 2021-07-23 | Boone | Missouri | 29019 | 20451 | 118 |
1541991 | 1541991 | 2021-07-22 | Boone | Missouri | 29019 | 20381 | 118 |
1538744 | 1538744 | 2021-07-21 | Boone | Missouri | 29019 | 20292 | 118 |
1535497 | 1535497 | 2021-07-20 | Boone | Missouri | 29019 | 20198 | 118 |
1532249 | 1532249 | 2021-07-19 | Boone | Missouri | 29019 | 20027 | 118 |
1529002 | 1529002 | 2021-07-18 | Boone | Missouri | 29019 | 19898 | 118 |
1525755 | 1525755 | 2021-07-17 | Boone | Missouri | 29019 | 19898 | 118 |
1522508 | 1522508 | 2021-07-16 | Boone | Missouri | 29019 | 19898 | 118 |
1519259 | 1519259 | 2021-07-15 | Boone | Missouri | 29019 | 19779 | 118 |
1516012 | 1516012 | 2021-07-14 | Boone | Missouri | 29019 | 19686 | 118 |
1512766 | 1512766 | 2021-07-13 | Boone | Missouri | 29019 | 19615 | 118 |
1509519 | 1509519 | 2021-07-12 | Boone | Missouri | 29019 | 19514 | 118 |
1506273 | 1506273 | 2021-07-11 | Boone | Missouri | 29019 | 19383 | 118 |
1503027 | 1503027 | 2021-07-10 | Boone | Missouri | 29019 | 19383 | 118 |
1499781 | 1499781 | 2021-07-09 | Boone | Missouri | 29019 | 19383 | 118 |
1496535 | 1496535 | 2021-07-08 | Boone | Missouri | 29019 | 19341 | 118 |
1493288 | 1493288 | 2021-07-07 | Boone | Missouri | 29019 | 19283 | 118 |
1490041 | 1490041 | 2021-07-06 | Boone | Missouri | 29019 | 19227 | 118 |
1486794 | 1486794 | 2021-07-05 | Boone | Missouri | 29019 | 19074 | 117 |
1483548 | 1483548 | 2021-07-04 | Boone | Missouri | 29019 | 19074 | 117 |
1480302 | 1480302 | 2021-07-03 | Boone | Missouri | 29019 | 19074 | 117 |
1477055 | 1477055 | 2021-07-02 | Boone | Missouri | 29019 | 19074 | 117 |
1473809 | 1473809 | 2021-07-01 | Boone | Missouri | 29019 | 19037 | 117 |
1470563 | 1470563 | 2021-06-30 | Boone | Missouri | 29019 | 18992 | 117 |
1467318 | 1467318 | 2021-06-29 | Boone | Missouri | 29019 | 18957 | 117 |
1464073 | 1464073 | 2021-06-28 | Boone | Missouri | 29019 | 18899 | 117 |
1460828 | 1460828 | 2021-06-27 | Boone | Missouri | 29019 | 18820 | 117 |
1457583 | 1457583 | 2021-06-26 | Boone | Missouri | 29019 | 18820 | 117 |
1454338 | 1454338 | 2021-06-25 | Boone | Missouri | 29019 | 18820 | 117 |
1451093 | 1451093 | 2021-06-24 | Boone | Missouri | 29019 | 18785 | 117 |
1447847 | 1447847 | 2021-06-23 | Boone | Missouri | 29019 | 18762 | 117 |
1444602 | 1444602 | 2021-06-22 | Boone | Missouri | 29019 | 18737 | 117 |
1441357 | 1441357 | 2021-06-21 | Boone | Missouri | 29019 | 18712 | 117 |
1438111 | 1438111 | 2021-06-20 | Boone | Missouri | 29019 | 18683 | 117 |
1434864 | 1434864 | 2021-06-19 | Boone | Missouri | 29019 | 18683 | 117 |
1431617 | 1431617 | 2021-06-18 | Boone | Missouri | 29019 | 18683 | 117 |
1428372 | 1428372 | 2021-06-17 | Boone | Missouri | 29019 | 18673 | 117 |
1425127 | 1425127 | 2021-06-16 | Boone | Missouri | 29019 | 18655 | 117 |
1421879 | 1421879 | 2021-06-15 | Boone | Missouri | 29019 | 18644 | 117 |
1418634 | 1418634 | 2021-06-14 | Boone | Missouri | 29019 | 18634 | 116 |
1415389 | 1415389 | 2021-06-13 | Boone | Missouri | 29019 | 18615 | 116 |
1412143 | 1412143 | 2021-06-12 | Boone | Missouri | 29019 | 18615 | 116 |
1408898 | 1408898 | 2021-06-11 | Boone | Missouri | 29019 | 18615 | 116 |
1405653 | 1405653 | 2021-06-10 | Boone | Missouri | 29019 | 18609 | 116 |
1402407 | 1402407 | 2021-06-09 | Boone | Missouri | 29019 | 18605 | 116 |
1399162 | 1399162 | 2021-06-08 | Boone | Missouri | 29019 | 18595 | 116 |
1395916 | 1395916 | 2021-06-07 | Boone | Missouri | 29019 | 18584 | 116 |
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);