ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29169 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840941 | 1840941 | 2021-10-22 | Pulaski | Missouri | 29169 | 5183 | 79 |
1837692 | 1837692 | 2021-10-21 | Pulaski | Missouri | 29169 | 5177 | 79 |
1834443 | 1834443 | 2021-10-20 | Pulaski | Missouri | 29169 | 5168 | 79 |
1831194 | 1831194 | 2021-10-19 | Pulaski | Missouri | 29169 | 5148 | 79 |
1827945 | 1827945 | 2021-10-18 | Pulaski | Missouri | 29169 | 5128 | 78 |
1824696 | 1824696 | 2021-10-17 | Pulaski | Missouri | 29169 | 5126 | 78 |
1821447 | 1821447 | 2021-10-16 | Pulaski | Missouri | 29169 | 5114 | 78 |
1818198 | 1818198 | 2021-10-15 | Pulaski | Missouri | 29169 | 5111 | 76 |
1814949 | 1814949 | 2021-10-14 | Pulaski | Missouri | 29169 | 5102 | 76 |
1811701 | 1811701 | 2021-10-13 | Pulaski | Missouri | 29169 | 5094 | 76 |
1808452 | 1808452 | 2021-10-12 | Pulaski | Missouri | 29169 | 5084 | 75 |
1805201 | 1805201 | 2021-10-11 | Pulaski | Missouri | 29169 | 5081 | 75 |
1801952 | 1801952 | 2021-10-10 | Pulaski | Missouri | 29169 | 5079 | 75 |
1798703 | 1798703 | 2021-10-09 | Pulaski | Missouri | 29169 | 5066 | 75 |
1795454 | 1795454 | 2021-10-08 | Pulaski | Missouri | 29169 | 5058 | 75 |
1792205 | 1792205 | 2021-10-07 | Pulaski | Missouri | 29169 | 5044 | 75 |
1788956 | 1788956 | 2021-10-06 | Pulaski | Missouri | 29169 | 5026 | 75 |
1785708 | 1785708 | 2021-10-05 | Pulaski | Missouri | 29169 | 5003 | 75 |
1782459 | 1782459 | 2021-10-04 | Pulaski | Missouri | 29169 | 5000 | 74 |
1779209 | 1779209 | 2021-10-03 | Pulaski | Missouri | 29169 | 4998 | 74 |
1775959 | 1775959 | 2021-10-02 | Pulaski | Missouri | 29169 | 4995 | 74 |
1772709 | 1772709 | 2021-10-01 | Pulaski | Missouri | 29169 | 4982 | 74 |
1769460 | 1769460 | 2021-09-30 | Pulaski | Missouri | 29169 | 4964 | 72 |
1766211 | 1766211 | 2021-09-29 | Pulaski | Missouri | 29169 | 4950 | 72 |
1762962 | 1762962 | 2021-09-28 | Pulaski | Missouri | 29169 | 4905 | 72 |
1759713 | 1759713 | 2021-09-27 | Pulaski | Missouri | 29169 | 4899 | 69 |
1756465 | 1756465 | 2021-09-26 | Pulaski | Missouri | 29169 | 4891 | 69 |
1753217 | 1753217 | 2021-09-25 | Pulaski | Missouri | 29169 | 4884 | 69 |
1749969 | 1749969 | 2021-09-24 | Pulaski | Missouri | 29169 | 4863 | 69 |
1746719 | 1746719 | 2021-09-23 | Pulaski | Missouri | 29169 | 4848 | 69 |
1743470 | 1743470 | 2021-09-22 | Pulaski | Missouri | 29169 | 4837 | 69 |
1740221 | 1740221 | 2021-09-21 | Pulaski | Missouri | 29169 | 4822 | 69 |
1736972 | 1736972 | 2021-09-20 | Pulaski | Missouri | 29169 | 4812 | 69 |
1733722 | 1733722 | 2021-09-19 | Pulaski | Missouri | 29169 | 4804 | 69 |
1730472 | 1730472 | 2021-09-18 | Pulaski | Missouri | 29169 | 4797 | 69 |
1727222 | 1727222 | 2021-09-17 | Pulaski | Missouri | 29169 | 4787 | 68 |
1723973 | 1723973 | 2021-09-16 | Pulaski | Missouri | 29169 | 4777 | 68 |
1720724 | 1720724 | 2021-09-15 | Pulaski | Missouri | 29169 | 4763 | 68 |
1717476 | 1717476 | 2021-09-14 | Pulaski | Missouri | 29169 | 4746 | 68 |
1714228 | 1714228 | 2021-09-13 | Pulaski | Missouri | 29169 | 4742 | 67 |
1710982 | 1710982 | 2021-09-12 | Pulaski | Missouri | 29169 | 4739 | 67 |
1707735 | 1707735 | 2021-09-11 | Pulaski | Missouri | 29169 | 4728 | 67 |
1704488 | 1704488 | 2021-09-10 | Pulaski | Missouri | 29169 | 4720 | 67 |
1701238 | 1701238 | 2021-09-09 | Pulaski | Missouri | 29169 | 4711 | 67 |
1697989 | 1697989 | 2021-09-08 | Pulaski | Missouri | 29169 | 4700 | 67 |
1694741 | 1694741 | 2021-09-07 | Pulaski | Missouri | 29169 | 4693 | 65 |
1691492 | 1691492 | 2021-09-06 | Pulaski | Missouri | 29169 | 4690 | 65 |
1688242 | 1688242 | 2021-09-05 | Pulaski | Missouri | 29169 | 4681 | 65 |
1684992 | 1684992 | 2021-09-04 | Pulaski | Missouri | 29169 | 4670 | 65 |
1681741 | 1681741 | 2021-09-03 | Pulaski | Missouri | 29169 | 4656 | 65 |
1678493 | 1678493 | 2021-09-02 | Pulaski | Missouri | 29169 | 4641 | 65 |
1675245 | 1675245 | 2021-09-01 | Pulaski | Missouri | 29169 | 4629 | 65 |
1671997 | 1671997 | 2021-08-31 | Pulaski | Missouri | 29169 | 4622 | 64 |
1668750 | 1668750 | 2021-08-30 | Pulaski | Missouri | 29169 | 4613 | 62 |
1665503 | 1665503 | 2021-08-29 | Pulaski | Missouri | 29169 | 4602 | 62 |
1662255 | 1662255 | 2021-08-28 | Pulaski | Missouri | 29169 | 4581 | 62 |
1659007 | 1659007 | 2021-08-27 | Pulaski | Missouri | 29169 | 4577 | 62 |
1655758 | 1655758 | 2021-08-26 | Pulaski | Missouri | 29169 | 4568 | 62 |
1652511 | 1652511 | 2021-08-25 | Pulaski | Missouri | 29169 | 4558 | 62 |
1649263 | 1649263 | 2021-08-24 | Pulaski | Missouri | 29169 | 4550 | 61 |
1646014 | 1646014 | 2021-08-23 | Pulaski | Missouri | 29169 | 4540 | 61 |
1642765 | 1642765 | 2021-08-22 | Pulaski | Missouri | 29169 | 4532 | 61 |
1639515 | 1639515 | 2021-08-21 | Pulaski | Missouri | 29169 | 4501 | 61 |
1636265 | 1636265 | 2021-08-20 | Pulaski | Missouri | 29169 | 4494 | 61 |
1633015 | 1633015 | 2021-08-19 | Pulaski | Missouri | 29169 | 4482 | 61 |
1629768 | 1629768 | 2021-08-18 | Pulaski | Missouri | 29169 | 4469 | 60 |
1626521 | 1626521 | 2021-08-17 | Pulaski | Missouri | 29169 | 4459 | 60 |
1623274 | 1623274 | 2021-08-16 | Pulaski | Missouri | 29169 | 4448 | 60 |
1620027 | 1620027 | 2021-08-15 | Pulaski | Missouri | 29169 | 4445 | 60 |
1616779 | 1616779 | 2021-08-14 | Pulaski | Missouri | 29169 | 4436 | 60 |
1613531 | 1613531 | 2021-08-13 | Pulaski | Missouri | 29169 | 4431 | 60 |
1610282 | 1610282 | 2021-08-12 | Pulaski | Missouri | 29169 | 4405 | 60 |
1607034 | 1607034 | 2021-08-11 | Pulaski | Missouri | 29169 | 4393 | 60 |
1603785 | 1603785 | 2021-08-10 | Pulaski | Missouri | 29169 | 4374 | 60 |
1600536 | 1600536 | 2021-08-09 | Pulaski | Missouri | 29169 | 4361 | 59 |
1597288 | 1597288 | 2021-08-08 | Pulaski | Missouri | 29169 | 4356 | 59 |
1594039 | 1594039 | 2021-08-07 | Pulaski | Missouri | 29169 | 4348 | 59 |
1590790 | 1590790 | 2021-08-06 | Pulaski | Missouri | 29169 | 4338 | 59 |
1587541 | 1587541 | 2021-08-05 | Pulaski | Missouri | 29169 | 4324 | 59 |
1584290 | 1584290 | 2021-08-04 | Pulaski | Missouri | 29169 | 4296 | 58 |
1581041 | 1581041 | 2021-08-03 | Pulaski | Missouri | 29169 | 4261 | 58 |
1577792 | 1577792 | 2021-08-02 | Pulaski | Missouri | 29169 | 4244 | 57 |
1574544 | 1574544 | 2021-08-01 | Pulaski | Missouri | 29169 | 4234 | 57 |
1571296 | 1571296 | 2021-07-31 | Pulaski | Missouri | 29169 | 4222 | 57 |
1568048 | 1568048 | 2021-07-30 | Pulaski | Missouri | 29169 | 4201 | 57 |
1564800 | 1564800 | 2021-07-29 | Pulaski | Missouri | 29169 | 4174 | 56 |
1561552 | 1561552 | 2021-07-28 | Pulaski | Missouri | 29169 | 4151 | 56 |
1558304 | 1558304 | 2021-07-27 | Pulaski | Missouri | 29169 | 4120 | 56 |
1555057 | 1555057 | 2021-07-26 | Pulaski | Missouri | 29169 | 4090 | 56 |
1551810 | 1551810 | 2021-07-25 | Pulaski | Missouri | 29169 | 4079 | 56 |
1548563 | 1548563 | 2021-07-24 | Pulaski | Missouri | 29169 | 4055 | 56 |
1545316 | 1545316 | 2021-07-23 | Pulaski | Missouri | 29169 | 4039 | 56 |
1542068 | 1542068 | 2021-07-22 | Pulaski | Missouri | 29169 | 4020 | 56 |
1538821 | 1538821 | 2021-07-21 | Pulaski | Missouri | 29169 | 3985 | 56 |
1535574 | 1535574 | 2021-07-20 | Pulaski | Missouri | 29169 | 3967 | 56 |
1532326 | 1532326 | 2021-07-19 | Pulaski | Missouri | 29169 | 3923 | 56 |
1529079 | 1529079 | 2021-07-18 | Pulaski | Missouri | 29169 | 3913 | 56 |
1525832 | 1525832 | 2021-07-17 | Pulaski | Missouri | 29169 | 3899 | 56 |
1522585 | 1522585 | 2021-07-16 | Pulaski | Missouri | 29169 | 3866 | 56 |
1519336 | 1519336 | 2021-07-15 | Pulaski | Missouri | 29169 | 3843 | 56 |
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);