ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 29035 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840872 | 1840872 | 2021-10-22 | Carter | Missouri | 29035 | 1073 | 14 |
1837623 | 1837623 | 2021-10-21 | Carter | Missouri | 29035 | 1073 | 14 |
1834374 | 1834374 | 2021-10-20 | Carter | Missouri | 29035 | 1073 | 14 |
1831125 | 1831125 | 2021-10-19 | Carter | Missouri | 29035 | 1068 | 14 |
1827876 | 1827876 | 2021-10-18 | Carter | Missouri | 29035 | 1068 | 14 |
1824627 | 1824627 | 2021-10-17 | Carter | Missouri | 29035 | 1068 | 14 |
1821378 | 1821378 | 2021-10-16 | Carter | Missouri | 29035 | 1068 | 14 |
1818129 | 1818129 | 2021-10-15 | Carter | Missouri | 29035 | 1068 | 14 |
1814880 | 1814880 | 2021-10-14 | Carter | Missouri | 29035 | 1064 | 14 |
1811632 | 1811632 | 2021-10-13 | Carter | Missouri | 29035 | 1064 | 14 |
1808383 | 1808383 | 2021-10-12 | Carter | Missouri | 29035 | 1061 | 14 |
1805132 | 1805132 | 2021-10-11 | Carter | Missouri | 29035 | 1061 | 14 |
1801883 | 1801883 | 2021-10-10 | Carter | Missouri | 29035 | 1061 | 14 |
1798634 | 1798634 | 2021-10-09 | Carter | Missouri | 29035 | 1061 | 14 |
1795385 | 1795385 | 2021-10-08 | Carter | Missouri | 29035 | 1059 | 14 |
1792136 | 1792136 | 2021-10-07 | Carter | Missouri | 29035 | 1057 | 14 |
1788887 | 1788887 | 2021-10-06 | Carter | Missouri | 29035 | 1051 | 14 |
1785639 | 1785639 | 2021-10-05 | Carter | Missouri | 29035 | 1048 | 14 |
1782390 | 1782390 | 2021-10-04 | Carter | Missouri | 29035 | 1049 | 14 |
1779140 | 1779140 | 2021-10-03 | Carter | Missouri | 29035 | 1049 | 14 |
1775890 | 1775890 | 2021-10-02 | Carter | Missouri | 29035 | 1048 | 14 |
1772640 | 1772640 | 2021-10-01 | Carter | Missouri | 29035 | 1046 | 14 |
1769391 | 1769391 | 2021-09-30 | Carter | Missouri | 29035 | 1040 | 14 |
1766142 | 1766142 | 2021-09-29 | Carter | Missouri | 29035 | 1037 | 14 |
1762893 | 1762893 | 2021-09-28 | Carter | Missouri | 29035 | 1037 | 14 |
1759644 | 1759644 | 2021-09-27 | Carter | Missouri | 29035 | 1038 | 13 |
1756396 | 1756396 | 2021-09-26 | Carter | Missouri | 29035 | 1035 | 13 |
1753148 | 1753148 | 2021-09-25 | Carter | Missouri | 29035 | 1032 | 13 |
1749900 | 1749900 | 2021-09-24 | Carter | Missouri | 29035 | 1033 | 13 |
1746650 | 1746650 | 2021-09-23 | Carter | Missouri | 29035 | 1027 | 13 |
1743401 | 1743401 | 2021-09-22 | Carter | Missouri | 29035 | 1025 | 13 |
1740152 | 1740152 | 2021-09-21 | Carter | Missouri | 29035 | 1020 | 13 |
1736903 | 1736903 | 2021-09-20 | Carter | Missouri | 29035 | 1016 | 13 |
1733653 | 1733653 | 2021-09-19 | Carter | Missouri | 29035 | 1016 | 13 |
1730403 | 1730403 | 2021-09-18 | Carter | Missouri | 29035 | 1015 | 13 |
1727153 | 1727153 | 2021-09-17 | Carter | Missouri | 29035 | 1013 | 13 |
1723904 | 1723904 | 2021-09-16 | Carter | Missouri | 29035 | 1009 | 13 |
1720655 | 1720655 | 2021-09-15 | Carter | Missouri | 29035 | 1007 | 13 |
1717407 | 1717407 | 2021-09-14 | Carter | Missouri | 29035 | 992 | 13 |
1714159 | 1714159 | 2021-09-13 | Carter | Missouri | 29035 | 977 | 12 |
1710913 | 1710913 | 2021-09-12 | Carter | Missouri | 29035 | 974 | 12 |
1707666 | 1707666 | 2021-09-11 | Carter | Missouri | 29035 | 974 | 12 |
1704419 | 1704419 | 2021-09-10 | Carter | Missouri | 29035 | 968 | 12 |
1701169 | 1701169 | 2021-09-09 | Carter | Missouri | 29035 | 953 | 12 |
1697920 | 1697920 | 2021-09-08 | Carter | Missouri | 29035 | 942 | 12 |
1694672 | 1694672 | 2021-09-07 | Carter | Missouri | 29035 | 930 | 12 |
1691423 | 1691423 | 2021-09-06 | Carter | Missouri | 29035 | 929 | 12 |
1688173 | 1688173 | 2021-09-05 | Carter | Missouri | 29035 | 923 | 12 |
1684923 | 1684923 | 2021-09-04 | Carter | Missouri | 29035 | 920 | 12 |
1681672 | 1681672 | 2021-09-03 | Carter | Missouri | 29035 | 913 | 12 |
1678424 | 1678424 | 2021-09-02 | Carter | Missouri | 29035 | 900 | 12 |
1675176 | 1675176 | 2021-09-01 | Carter | Missouri | 29035 | 880 | 12 |
1671928 | 1671928 | 2021-08-31 | Carter | Missouri | 29035 | 843 | 12 |
1668681 | 1668681 | 2021-08-30 | Carter | Missouri | 29035 | 827 | 11 |
1665434 | 1665434 | 2021-08-29 | Carter | Missouri | 29035 | 827 | 11 |
1662186 | 1662186 | 2021-08-28 | Carter | Missouri | 29035 | 827 | 11 |
1658938 | 1658938 | 2021-08-27 | Carter | Missouri | 29035 | 821 | 11 |
1655689 | 1655689 | 2021-08-26 | Carter | Missouri | 29035 | 802 | 11 |
1652442 | 1652442 | 2021-08-25 | Carter | Missouri | 29035 | 778 | 11 |
1649194 | 1649194 | 2021-08-24 | Carter | Missouri | 29035 | 773 | 11 |
1645945 | 1645945 | 2021-08-23 | Carter | Missouri | 29035 | 764 | 11 |
1642696 | 1642696 | 2021-08-22 | Carter | Missouri | 29035 | 763 | 11 |
1639446 | 1639446 | 2021-08-21 | Carter | Missouri | 29035 | 759 | 11 |
1636196 | 1636196 | 2021-08-20 | Carter | Missouri | 29035 | 754 | 11 |
1632946 | 1632946 | 2021-08-19 | Carter | Missouri | 29035 | 723 | 11 |
1629699 | 1629699 | 2021-08-18 | Carter | Missouri | 29035 | 714 | 11 |
1626452 | 1626452 | 2021-08-17 | Carter | Missouri | 29035 | 708 | 11 |
1623205 | 1623205 | 2021-08-16 | Carter | Missouri | 29035 | 706 | 11 |
1619958 | 1619958 | 2021-08-15 | Carter | Missouri | 29035 | 701 | 11 |
1616710 | 1616710 | 2021-08-14 | Carter | Missouri | 29035 | 700 | 11 |
1613462 | 1613462 | 2021-08-13 | Carter | Missouri | 29035 | 687 | 11 |
1610213 | 1610213 | 2021-08-12 | Carter | Missouri | 29035 | 678 | 11 |
1606965 | 1606965 | 2021-08-11 | Carter | Missouri | 29035 | 673 | 11 |
1603716 | 1603716 | 2021-08-10 | Carter | Missouri | 29035 | 663 | 11 |
1600467 | 1600467 | 2021-08-09 | Carter | Missouri | 29035 | 661 | 11 |
1597219 | 1597219 | 2021-08-08 | Carter | Missouri | 29035 | 659 | 11 |
1593970 | 1593970 | 2021-08-07 | Carter | Missouri | 29035 | 658 | 11 |
1590721 | 1590721 | 2021-08-06 | Carter | Missouri | 29035 | 648 | 11 |
1587472 | 1587472 | 2021-08-05 | Carter | Missouri | 29035 | 642 | 11 |
1584221 | 1584221 | 2021-08-04 | Carter | Missouri | 29035 | 633 | 11 |
1580972 | 1580972 | 2021-08-03 | Carter | Missouri | 29035 | 623 | 11 |
1577723 | 1577723 | 2021-08-02 | Carter | Missouri | 29035 | 623 | 11 |
1574475 | 1574475 | 2021-08-01 | Carter | Missouri | 29035 | 622 | 11 |
1571227 | 1571227 | 2021-07-31 | Carter | Missouri | 29035 | 619 | 11 |
1567979 | 1567979 | 2021-07-30 | Carter | Missouri | 29035 | 616 | 11 |
1564731 | 1564731 | 2021-07-29 | Carter | Missouri | 29035 | 612 | 11 |
1561483 | 1561483 | 2021-07-28 | Carter | Missouri | 29035 | 611 | 11 |
1558235 | 1558235 | 2021-07-27 | Carter | Missouri | 29035 | 609 | 11 |
1554988 | 1554988 | 2021-07-26 | Carter | Missouri | 29035 | 608 | 11 |
1551741 | 1551741 | 2021-07-25 | Carter | Missouri | 29035 | 608 | 11 |
1548494 | 1548494 | 2021-07-24 | Carter | Missouri | 29035 | 606 | 11 |
1545247 | 1545247 | 2021-07-23 | Carter | Missouri | 29035 | 603 | 11 |
1541999 | 1541999 | 2021-07-22 | Carter | Missouri | 29035 | 602 | 11 |
1538752 | 1538752 | 2021-07-21 | Carter | Missouri | 29035 | 596 | 11 |
1535505 | 1535505 | 2021-07-20 | Carter | Missouri | 29035 | 594 | 11 |
1532257 | 1532257 | 2021-07-19 | Carter | Missouri | 29035 | 593 | 11 |
1529010 | 1529010 | 2021-07-18 | Carter | Missouri | 29035 | 592 | 11 |
1525763 | 1525763 | 2021-07-17 | Carter | Missouri | 29035 | 584 | 11 |
1522516 | 1522516 | 2021-07-16 | Carter | Missouri | 29035 | 580 | 11 |
1519267 | 1519267 | 2021-07-15 | Carter | Missouri | 29035 | 578 | 11 |
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);