ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Perry" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840935 | 1840935 | 2021-10-22 | Perry | Missouri | 29157 | 3099 | 33 |
1837686 | 1837686 | 2021-10-21 | Perry | Missouri | 29157 | 3092 | 33 |
1834437 | 1834437 | 2021-10-20 | Perry | Missouri | 29157 | 3082 | 33 |
1831188 | 1831188 | 2021-10-19 | Perry | Missouri | 29157 | 3071 | 33 |
1827939 | 1827939 | 2021-10-18 | Perry | Missouri | 29157 | 3063 | 33 |
1824690 | 1824690 | 2021-10-17 | Perry | Missouri | 29157 | 3062 | 33 |
1821441 | 1821441 | 2021-10-16 | Perry | Missouri | 29157 | 3059 | 33 |
1818192 | 1818192 | 2021-10-15 | Perry | Missouri | 29157 | 3052 | 33 |
1814943 | 1814943 | 2021-10-14 | Perry | Missouri | 29157 | 3044 | 33 |
1811695 | 1811695 | 2021-10-13 | Perry | Missouri | 29157 | 3036 | 33 |
1808446 | 1808446 | 2021-10-12 | Perry | Missouri | 29157 | 3029 | 32 |
1805195 | 1805195 | 2021-10-11 | Perry | Missouri | 29157 | 3024 | 32 |
1801946 | 1801946 | 2021-10-10 | Perry | Missouri | 29157 | 3021 | 32 |
1798697 | 1798697 | 2021-10-09 | Perry | Missouri | 29157 | 3018 | 32 |
1795448 | 1795448 | 2021-10-08 | Perry | Missouri | 29157 | 3014 | 32 |
1792199 | 1792199 | 2021-10-07 | Perry | Missouri | 29157 | 3000 | 32 |
1788950 | 1788950 | 2021-10-06 | Perry | Missouri | 29157 | 2993 | 32 |
1785702 | 1785702 | 2021-10-05 | Perry | Missouri | 29157 | 2987 | 32 |
1782453 | 1782453 | 2021-10-04 | Perry | Missouri | 29157 | 2976 | 32 |
1779203 | 1779203 | 2021-10-03 | Perry | Missouri | 29157 | 2974 | 32 |
1775953 | 1775953 | 2021-10-02 | Perry | Missouri | 29157 | 2973 | 32 |
1772703 | 1772703 | 2021-10-01 | Perry | Missouri | 29157 | 2965 | 32 |
1769454 | 1769454 | 2021-09-30 | Perry | Missouri | 29157 | 2952 | 32 |
1766205 | 1766205 | 2021-09-29 | Perry | Missouri | 29157 | 2937 | 32 |
1762956 | 1762956 | 2021-09-28 | Perry | Missouri | 29157 | 2922 | 32 |
1759707 | 1759707 | 2021-09-27 | Perry | Missouri | 29157 | 2907 | 32 |
1756459 | 1756459 | 2021-09-26 | Perry | Missouri | 29157 | 2907 | 32 |
1753211 | 1753211 | 2021-09-25 | Perry | Missouri | 29157 | 2906 | 32 |
1749963 | 1749963 | 2021-09-24 | Perry | Missouri | 29157 | 2902 | 32 |
1746713 | 1746713 | 2021-09-23 | Perry | Missouri | 29157 | 2890 | 32 |
1743464 | 1743464 | 2021-09-22 | Perry | Missouri | 29157 | 2869 | 32 |
1740215 | 1740215 | 2021-09-21 | Perry | Missouri | 29157 | 2855 | 32 |
1736966 | 1736966 | 2021-09-20 | Perry | Missouri | 29157 | 2848 | 32 |
1733716 | 1733716 | 2021-09-19 | Perry | Missouri | 29157 | 2843 | 32 |
1730466 | 1730466 | 2021-09-18 | Perry | Missouri | 29157 | 2834 | 32 |
1727216 | 1727216 | 2021-09-17 | Perry | Missouri | 29157 | 2822 | 32 |
1723967 | 1723967 | 2021-09-16 | Perry | Missouri | 29157 | 2798 | 32 |
1720718 | 1720718 | 2021-09-15 | Perry | Missouri | 29157 | 2786 | 32 |
1717470 | 1717470 | 2021-09-14 | Perry | Missouri | 29157 | 2770 | 32 |
1714222 | 1714222 | 2021-09-13 | Perry | Missouri | 29157 | 2764 | 32 |
1710976 | 1710976 | 2021-09-12 | Perry | Missouri | 29157 | 2755 | 32 |
1707729 | 1707729 | 2021-09-11 | Perry | Missouri | 29157 | 2750 | 32 |
1704482 | 1704482 | 2021-09-10 | Perry | Missouri | 29157 | 2735 | 32 |
1701232 | 1701232 | 2021-09-09 | Perry | Missouri | 29157 | 2696 | 32 |
1697983 | 1697983 | 2021-09-08 | Perry | Missouri | 29157 | 2689 | 32 |
1694735 | 1694735 | 2021-09-07 | Perry | Missouri | 29157 | 2678 | 32 |
1691486 | 1691486 | 2021-09-06 | Perry | Missouri | 29157 | 2675 | 32 |
1688236 | 1688236 | 2021-09-05 | Perry | Missouri | 29157 | 2669 | 32 |
1684986 | 1684986 | 2021-09-04 | Perry | Missouri | 29157 | 2663 | 32 |
1681735 | 1681735 | 2021-09-03 | Perry | Missouri | 29157 | 2653 | 32 |
1678487 | 1678487 | 2021-09-02 | Perry | Missouri | 29157 | 2640 | 32 |
1675239 | 1675239 | 2021-09-01 | Perry | Missouri | 29157 | 2615 | 32 |
1671991 | 1671991 | 2021-08-31 | Perry | Missouri | 29157 | 2605 | 32 |
1668744 | 1668744 | 2021-08-30 | Perry | Missouri | 29157 | 2599 | 32 |
1665497 | 1665497 | 2021-08-29 | Perry | Missouri | 29157 | 2597 | 32 |
1662249 | 1662249 | 2021-08-28 | Perry | Missouri | 29157 | 2587 | 32 |
1659001 | 1659001 | 2021-08-27 | Perry | Missouri | 29157 | 2577 | 31 |
1655752 | 1655752 | 2021-08-26 | Perry | Missouri | 29157 | 2571 | 30 |
1652505 | 1652505 | 2021-08-25 | Perry | Missouri | 29157 | 2548 | 30 |
1649257 | 1649257 | 2021-08-24 | Perry | Missouri | 29157 | 2546 | 30 |
1646008 | 1646008 | 2021-08-23 | Perry | Missouri | 29157 | 2530 | 30 |
1642759 | 1642759 | 2021-08-22 | Perry | Missouri | 29157 | 2528 | 30 |
1639509 | 1639509 | 2021-08-21 | Perry | Missouri | 29157 | 2514 | 30 |
1636259 | 1636259 | 2021-08-20 | Perry | Missouri | 29157 | 2501 | 30 |
1633009 | 1633009 | 2021-08-19 | Perry | Missouri | 29157 | 2499 | 30 |
1629762 | 1629762 | 2021-08-18 | Perry | Missouri | 29157 | 2483 | 30 |
1626515 | 1626515 | 2021-08-17 | Perry | Missouri | 29157 | 2471 | 30 |
1623268 | 1623268 | 2021-08-16 | Perry | Missouri | 29157 | 2460 | 30 |
1620021 | 1620021 | 2021-08-15 | Perry | Missouri | 29157 | 2460 | 30 |
1616773 | 1616773 | 2021-08-14 | Perry | Missouri | 29157 | 2457 | 30 |
1613525 | 1613525 | 2021-08-13 | Perry | Missouri | 29157 | 2444 | 30 |
1610276 | 1610276 | 2021-08-12 | Perry | Missouri | 29157 | 2434 | 30 |
1607028 | 1607028 | 2021-08-11 | Perry | Missouri | 29157 | 2428 | 30 |
1603779 | 1603779 | 2021-08-10 | Perry | Missouri | 29157 | 2407 | 30 |
1600530 | 1600530 | 2021-08-09 | Perry | Missouri | 29157 | 2400 | 30 |
1597282 | 1597282 | 2021-08-08 | Perry | Missouri | 29157 | 2400 | 30 |
1594033 | 1594033 | 2021-08-07 | Perry | Missouri | 29157 | 2399 | 30 |
1590784 | 1590784 | 2021-08-06 | Perry | Missouri | 29157 | 2388 | 30 |
1587535 | 1587535 | 2021-08-05 | Perry | Missouri | 29157 | 2379 | 30 |
1584284 | 1584284 | 2021-08-04 | Perry | Missouri | 29157 | 2375 | 30 |
1581035 | 1581035 | 2021-08-03 | Perry | Missouri | 29157 | 2358 | 30 |
1577786 | 1577786 | 2021-08-02 | Perry | Missouri | 29157 | 2354 | 30 |
1574538 | 1574538 | 2021-08-01 | Perry | Missouri | 29157 | 2354 | 30 |
1571290 | 1571290 | 2021-07-31 | Perry | Missouri | 29157 | 2351 | 30 |
1568042 | 1568042 | 2021-07-30 | Perry | Missouri | 29157 | 2347 | 30 |
1564794 | 1564794 | 2021-07-29 | Perry | Missouri | 29157 | 2334 | 30 |
1561546 | 1561546 | 2021-07-28 | Perry | Missouri | 29157 | 2325 | 30 |
1558298 | 1558298 | 2021-07-27 | Perry | Missouri | 29157 | 2323 | 30 |
1555051 | 1555051 | 2021-07-26 | Perry | Missouri | 29157 | 2314 | 30 |
1551804 | 1551804 | 2021-07-25 | Perry | Missouri | 29157 | 2314 | 30 |
1548557 | 1548557 | 2021-07-24 | Perry | Missouri | 29157 | 2313 | 30 |
1545310 | 1545310 | 2021-07-23 | Perry | Missouri | 29157 | 2310 | 30 |
1542062 | 1542062 | 2021-07-22 | Perry | Missouri | 29157 | 2308 | 30 |
1538815 | 1538815 | 2021-07-21 | Perry | Missouri | 29157 | 2305 | 30 |
1535568 | 1535568 | 2021-07-20 | Perry | Missouri | 29157 | 2304 | 30 |
1532320 | 1532320 | 2021-07-19 | Perry | Missouri | 29157 | 2302 | 30 |
1529073 | 1529073 | 2021-07-18 | Perry | Missouri | 29157 | 2302 | 30 |
1525826 | 1525826 | 2021-07-17 | Perry | Missouri | 29157 | 2301 | 30 |
1522579 | 1522579 | 2021-07-16 | Perry | Missouri | 29157 | 2300 | 30 |
1519330 | 1519330 | 2021-07-15 | Perry | Missouri | 29157 | 2301 | 30 |
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);