ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where county = "Texas" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948203 | 1948203 | 2021-11-24 | Texas | Missouri | 29215 | 3199 | 63 |
1944952 | 1944952 | 2021-11-23 | Texas | Missouri | 29215 | 3192 | 63 |
1941701 | 1941701 | 2021-11-22 | Texas | Missouri | 29215 | 3181 | 63 |
1938451 | 1938451 | 2021-11-21 | Texas | Missouri | 29215 | 3175 | 63 |
1935201 | 1935201 | 2021-11-20 | Texas | Missouri | 29215 | 3170 | 63 |
1931951 | 1931951 | 2021-11-19 | Texas | Missouri | 29215 | 3164 | 63 |
1928700 | 1928700 | 2021-11-18 | Texas | Missouri | 29215 | 3158 | 63 |
1925450 | 1925450 | 2021-11-17 | Texas | Missouri | 29215 | 3101 | 43 |
1922201 | 1922201 | 2021-11-16 | Texas | Missouri | 29215 | 3100 | 43 |
1918951 | 1918951 | 2021-11-15 | Texas | Missouri | 29215 | 3088 | 43 |
1915701 | 1915701 | 2021-11-14 | Texas | Missouri | 29215 | 3088 | 43 |
1912451 | 1912451 | 2021-11-13 | Texas | Missouri | 29215 | 3086 | 43 |
1909201 | 1909201 | 2021-11-12 | Texas | Missouri | 29215 | 3079 | 43 |
1905952 | 1905952 | 2021-11-11 | Texas | Missouri | 29215 | 3064 | 43 |
1902703 | 1902703 | 2021-11-10 | Texas | Missouri | 29215 | 3064 | 43 |
1899453 | 1899453 | 2021-11-09 | Texas | Missouri | 29215 | 3045 | 43 |
1896203 | 1896203 | 2021-11-08 | Texas | Missouri | 29215 | 3031 | 43 |
1892953 | 1892953 | 2021-11-07 | Texas | Missouri | 29215 | 3030 | 43 |
1889703 | 1889703 | 2021-11-06 | Texas | Missouri | 29215 | 3028 | 43 |
1886453 | 1886453 | 2021-11-05 | Texas | Missouri | 29215 | 3019 | 43 |
1883204 | 1883204 | 2021-11-04 | Texas | Missouri | 29215 | 3015 | 43 |
1879955 | 1879955 | 2021-11-03 | Texas | Missouri | 29215 | 3008 | 43 |
1876706 | 1876706 | 2021-11-02 | Texas | Missouri | 29215 | 2999 | 43 |
1873457 | 1873457 | 2021-11-01 | Texas | Missouri | 29215 | 2991 | 42 |
1870208 | 1870208 | 2021-10-31 | Texas | Missouri | 29215 | 2990 | 42 |
1866959 | 1866959 | 2021-10-30 | Texas | Missouri | 29215 | 2988 | 42 |
1863710 | 1863710 | 2021-10-29 | Texas | Missouri | 29215 | 2982 | 42 |
1860461 | 1860461 | 2021-10-28 | Texas | Missouri | 29215 | 2971 | 42 |
1857212 | 1857212 | 2021-10-27 | Texas | Missouri | 29215 | 2967 | 42 |
1853963 | 1853963 | 2021-10-26 | Texas | Missouri | 29215 | 2957 | 42 |
1850714 | 1850714 | 2021-10-25 | Texas | Missouri | 29215 | 2954 | 42 |
1847464 | 1847464 | 2021-10-24 | Texas | Missouri | 29215 | 2954 | 42 |
1844214 | 1844214 | 2021-10-23 | Texas | Missouri | 29215 | 2953 | 42 |
1840964 | 1840964 | 2021-10-22 | Texas | Missouri | 29215 | 2948 | 42 |
1837715 | 1837715 | 2021-10-21 | Texas | Missouri | 29215 | 2946 | 42 |
1834466 | 1834466 | 2021-10-20 | Texas | Missouri | 29215 | 2943 | 42 |
1831217 | 1831217 | 2021-10-19 | Texas | Missouri | 29215 | 2943 | 42 |
1827968 | 1827968 | 2021-10-18 | Texas | Missouri | 29215 | 2942 | 42 |
1824719 | 1824719 | 2021-10-17 | Texas | Missouri | 29215 | 2942 | 42 |
1821470 | 1821470 | 2021-10-16 | Texas | Missouri | 29215 | 2942 | 42 |
1818221 | 1818221 | 2021-10-15 | Texas | Missouri | 29215 | 2940 | 42 |
1814972 | 1814972 | 2021-10-14 | Texas | Missouri | 29215 | 2939 | 42 |
1811724 | 1811724 | 2021-10-13 | Texas | Missouri | 29215 | 2936 | 42 |
1808475 | 1808475 | 2021-10-12 | Texas | Missouri | 29215 | 2933 | 42 |
1805224 | 1805224 | 2021-10-11 | Texas | Missouri | 29215 | 2929 | 42 |
1801975 | 1801975 | 2021-10-10 | Texas | Missouri | 29215 | 2925 | 42 |
1798726 | 1798726 | 2021-10-09 | Texas | Missouri | 29215 | 2925 | 42 |
1795477 | 1795477 | 2021-10-08 | Texas | Missouri | 29215 | 2924 | 42 |
1792228 | 1792228 | 2021-10-07 | Texas | Missouri | 29215 | 2922 | 41 |
1788979 | 1788979 | 2021-10-06 | Texas | Missouri | 29215 | 2917 | 41 |
1785731 | 1785731 | 2021-10-05 | Texas | Missouri | 29215 | 2916 | 41 |
1782482 | 1782482 | 2021-10-04 | Texas | Missouri | 29215 | 2915 | 40 |
1779232 | 1779232 | 2021-10-03 | Texas | Missouri | 29215 | 2915 | 40 |
1775982 | 1775982 | 2021-10-02 | Texas | Missouri | 29215 | 2910 | 40 |
1772732 | 1772732 | 2021-10-01 | Texas | Missouri | 29215 | 2906 | 40 |
1769483 | 1769483 | 2021-09-30 | Texas | Missouri | 29215 | 2900 | 40 |
1766234 | 1766234 | 2021-09-29 | Texas | Missouri | 29215 | 2896 | 40 |
1762985 | 1762985 | 2021-09-28 | Texas | Missouri | 29215 | 2890 | 40 |
1759736 | 1759736 | 2021-09-27 | Texas | Missouri | 29215 | 2885 | 40 |
1756488 | 1756488 | 2021-09-26 | Texas | Missouri | 29215 | 2885 | 40 |
1753240 | 1753240 | 2021-09-25 | Texas | Missouri | 29215 | 2882 | 40 |
1749992 | 1749992 | 2021-09-24 | Texas | Missouri | 29215 | 2876 | 39 |
1746742 | 1746742 | 2021-09-23 | Texas | Missouri | 29215 | 2874 | 39 |
1743493 | 1743493 | 2021-09-22 | Texas | Missouri | 29215 | 2870 | 39 |
1740244 | 1740244 | 2021-09-21 | Texas | Missouri | 29215 | 2861 | 39 |
1736995 | 1736995 | 2021-09-20 | Texas | Missouri | 29215 | 2855 | 37 |
1733745 | 1733745 | 2021-09-19 | Texas | Missouri | 29215 | 2850 | 37 |
1730495 | 1730495 | 2021-09-18 | Texas | Missouri | 29215 | 2849 | 37 |
1727245 | 1727245 | 2021-09-17 | Texas | Missouri | 29215 | 2844 | 37 |
1723996 | 1723996 | 2021-09-16 | Texas | Missouri | 29215 | 2839 | 37 |
1720747 | 1720747 | 2021-09-15 | Texas | Missouri | 29215 | 2826 | 37 |
1717499 | 1717499 | 2021-09-14 | Texas | Missouri | 29215 | 2816 | 37 |
1714251 | 1714251 | 2021-09-13 | Texas | Missouri | 29215 | 2808 | 36 |
1711005 | 1711005 | 2021-09-12 | Texas | Missouri | 29215 | 2807 | 36 |
1707758 | 1707758 | 2021-09-11 | Texas | Missouri | 29215 | 2805 | 36 |
1704511 | 1704511 | 2021-09-10 | Texas | Missouri | 29215 | 2796 | 36 |
1701261 | 1701261 | 2021-09-09 | Texas | Missouri | 29215 | 2783 | 36 |
1698012 | 1698012 | 2021-09-08 | Texas | Missouri | 29215 | 2780 | 35 |
1694764 | 1694764 | 2021-09-07 | Texas | Missouri | 29215 | 2771 | 34 |
1691515 | 1691515 | 2021-09-06 | Texas | Missouri | 29215 | 2770 | 34 |
1688265 | 1688265 | 2021-09-05 | Texas | Missouri | 29215 | 2767 | 34 |
1685015 | 1685015 | 2021-09-04 | Texas | Missouri | 29215 | 2766 | 34 |
1681764 | 1681764 | 2021-09-03 | Texas | Missouri | 29215 | 2744 | 34 |
1678516 | 1678516 | 2021-09-02 | Texas | Missouri | 29215 | 2734 | 33 |
1675268 | 1675268 | 2021-09-01 | Texas | Missouri | 29215 | 2726 | 33 |
1672020 | 1672020 | 2021-08-31 | Texas | Missouri | 29215 | 2721 | 33 |
1668773 | 1668773 | 2021-08-30 | Texas | Missouri | 29215 | 2720 | 32 |
1665526 | 1665526 | 2021-08-29 | Texas | Missouri | 29215 | 2718 | 32 |
1662278 | 1662278 | 2021-08-28 | Texas | Missouri | 29215 | 2712 | 32 |
1659030 | 1659030 | 2021-08-27 | Texas | Missouri | 29215 | 2706 | 32 |
1655781 | 1655781 | 2021-08-26 | Texas | Missouri | 29215 | 2700 | 32 |
1652534 | 1652534 | 2021-08-25 | Texas | Missouri | 29215 | 2695 | 31 |
1649286 | 1649286 | 2021-08-24 | Texas | Missouri | 29215 | 2685 | 31 |
1646037 | 1646037 | 2021-08-23 | Texas | Missouri | 29215 | 2668 | 31 |
1642788 | 1642788 | 2021-08-22 | Texas | Missouri | 29215 | 2663 | 31 |
1639538 | 1639538 | 2021-08-21 | Texas | Missouri | 29215 | 2654 | 31 |
1636288 | 1636288 | 2021-08-20 | Texas | Missouri | 29215 | 2621 | 31 |
1633038 | 1633038 | 2021-08-19 | Texas | Missouri | 29215 | 2614 | 31 |
1629791 | 1629791 | 2021-08-18 | Texas | Missouri | 29215 | 2598 | 31 |
1626544 | 1626544 | 2021-08-17 | Texas | Missouri | 29215 | 2584 | 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);