ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 29095 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175740 | 2175740 | 2022-02-02 | Jackson | Missouri | 29095 | 90644 | 1024 |
2172487 | 2172487 | 2022-02-01 | Jackson | Missouri | 29095 | 90119 | 1021 |
2169234 | 2169234 | 2022-01-31 | Jackson | Missouri | 29095 | 89741 | 992 |
2165979 | 2165979 | 2022-01-30 | Jackson | Missouri | 29095 | 89573 | 992 |
2162724 | 2162724 | 2022-01-29 | Jackson | Missouri | 29095 | 89304 | 992 |
2159469 | 2159469 | 2022-01-28 | Jackson | Missouri | 29095 | 88601 | 990 |
2156215 | 2156215 | 2022-01-27 | Jackson | Missouri | 29095 | 88068 | 990 |
2152962 | 2152962 | 2022-01-26 | Jackson | Missouri | 29095 | 87431 | 990 |
2149710 | 2149710 | 2022-01-25 | Jackson | Missouri | 29095 | 86916 | 986 |
2146458 | 2146458 | 2022-01-24 | Jackson | Missouri | 29095 | 86236 | 981 |
2143203 | 2143203 | 2022-01-23 | Jackson | Missouri | 29095 | 85856 | 981 |
2139948 | 2139948 | 2022-01-22 | Jackson | Missouri | 29095 | 85252 | 981 |
2136692 | 2136692 | 2022-01-21 | Jackson | Missouri | 29095 | 84541 | 981 |
2133440 | 2133440 | 2022-01-20 | Jackson | Missouri | 29095 | 83431 | 961 |
2130187 | 2130187 | 2022-01-19 | Jackson | Missouri | 29095 | 82435 | 960 |
2126933 | 2126933 | 2022-01-18 | Jackson | Missouri | 29095 | 81503 | 943 |
2123681 | 2123681 | 2022-01-17 | Jackson | Missouri | 29095 | 79995 | 942 |
2120429 | 2120429 | 2022-01-16 | Jackson | Missouri | 29095 | 79995 | 942 |
2117177 | 2117177 | 2022-01-15 | Jackson | Missouri | 29095 | 79995 | 942 |
2113926 | 2113926 | 2022-01-14 | Jackson | Missouri | 29095 | 78474 | 942 |
2110674 | 2110674 | 2022-01-13 | Jackson | Missouri | 29095 | 77654 | 938 |
2107423 | 2107423 | 2022-01-12 | Jackson | Missouri | 29095 | 76473 | 929 |
2104172 | 2104172 | 2022-01-11 | Jackson | Missouri | 29095 | 75646 | 925 |
2100921 | 2100921 | 2022-01-10 | Jackson | Missouri | 29095 | 74638 | 906 |
2097670 | 2097670 | 2022-01-09 | Jackson | Missouri | 29095 | 74157 | 906 |
2094418 | 2094418 | 2022-01-08 | Jackson | Missouri | 29095 | 73877 | 906 |
2091166 | 2091166 | 2022-01-07 | Jackson | Missouri | 29095 | 72717 | 904 |
2087915 | 2087915 | 2022-01-06 | Jackson | Missouri | 29095 | 71820 | 903 |
2084663 | 2084663 | 2022-01-05 | Jackson | Missouri | 29095 | 70830 | 901 |
2081411 | 2081411 | 2022-01-04 | Jackson | Missouri | 29095 | 70048 | 899 |
2078159 | 2078159 | 2022-01-03 | Jackson | Missouri | 29095 | 69549 | 883 |
2074908 | 2074908 | 2022-01-02 | Jackson | Missouri | 29095 | 67362 | 883 |
2071657 | 2071657 | 2022-01-01 | Jackson | Missouri | 29095 | 67362 | 883 |
2068406 | 2068406 | 2021-12-31 | Jackson | Missouri | 29095 | 67362 | 883 |
2065155 | 2065155 | 2021-12-30 | Jackson | Missouri | 29095 | 67362 | 883 |
2061905 | 2061905 | 2021-12-29 | Jackson | Missouri | 29095 | 66818 | 882 |
2058656 | 2058656 | 2021-12-28 | Jackson | Missouri | 29095 | 66298 | 881 |
2055407 | 2055407 | 2021-12-27 | Jackson | Missouri | 29095 | 65939 | 863 |
2052157 | 2052157 | 2021-12-26 | Jackson | Missouri | 29095 | 65207 | 860 |
2048907 | 2048907 | 2021-12-25 | Jackson | Missouri | 29095 | 65207 | 860 |
2045657 | 2045657 | 2021-12-24 | Jackson | Missouri | 29095 | 65207 | 860 |
2042407 | 2042407 | 2021-12-23 | Jackson | Missouri | 29095 | 65207 | 860 |
2039158 | 2039158 | 2021-12-22 | Jackson | Missouri | 29095 | 64660 | 860 |
2035908 | 2035908 | 2021-12-21 | Jackson | Missouri | 29095 | 64395 | 859 |
2032658 | 2032658 | 2021-12-20 | Jackson | Missouri | 29095 | 64133 | 857 |
2029407 | 2029407 | 2021-12-19 | Jackson | Missouri | 29095 | 63983 | 857 |
2026156 | 2026156 | 2021-12-18 | Jackson | Missouri | 29095 | 63775 | 857 |
2022905 | 2022905 | 2021-12-17 | Jackson | Missouri | 29095 | 63450 | 856 |
2019654 | 2019654 | 2021-12-16 | Jackson | Missouri | 29095 | 63154 | 854 |
2016404 | 2016404 | 2021-12-15 | Jackson | Missouri | 29095 | 62801 | 853 |
2013153 | 2013153 | 2021-12-14 | Jackson | Missouri | 29095 | 62512 | 852 |
2009902 | 2009902 | 2021-12-13 | Jackson | Missouri | 29095 | 62224 | 844 |
2006651 | 2006651 | 2021-12-12 | Jackson | Missouri | 29095 | 62111 | 844 |
2003400 | 2003400 | 2021-12-11 | Jackson | Missouri | 29095 | 61909 | 844 |
2000150 | 2000150 | 2021-12-10 | Jackson | Missouri | 29095 | 61677 | 844 |
1996899 | 1996899 | 2021-12-09 | Jackson | Missouri | 29095 | 61370 | 843 |
1993648 | 1993648 | 2021-12-08 | Jackson | Missouri | 29095 | 61099 | 843 |
1990397 | 1990397 | 2021-12-07 | Jackson | Missouri | 29095 | 60838 | 843 |
1987147 | 1987147 | 2021-12-06 | Jackson | Missouri | 29095 | 60645 | 841 |
1983897 | 1983897 | 2021-12-05 | Jackson | Missouri | 29095 | 60347 | 841 |
1980647 | 1980647 | 2021-12-04 | Jackson | Missouri | 29095 | 60255 | 841 |
1977397 | 1977397 | 2021-12-03 | Jackson | Missouri | 29095 | 59805 | 840 |
1974147 | 1974147 | 2021-12-02 | Jackson | Missouri | 29095 | 59805 | 840 |
1970898 | 1970898 | 2021-12-01 | Jackson | Missouri | 29095 | 59560 | 839 |
1967648 | 1967648 | 2021-11-30 | Jackson | Missouri | 29095 | 59371 | 838 |
1964396 | 1964396 | 2021-11-29 | Jackson | Missouri | 29095 | 59165 | 832 |
1961145 | 1961145 | 2021-11-28 | Jackson | Missouri | 29095 | 58729 | 831 |
1957894 | 1957894 | 2021-11-27 | Jackson | Missouri | 29095 | 58729 | 831 |
1954643 | 1954643 | 2021-11-26 | Jackson | Missouri | 29095 | 58729 | 831 |
1951392 | 1951392 | 2021-11-25 | Jackson | Missouri | 29095 | 58729 | 831 |
1948141 | 1948141 | 2021-11-24 | Jackson | Missouri | 29095 | 58729 | 831 |
1944890 | 1944890 | 2021-11-23 | Jackson | Missouri | 29095 | 58549 | 831 |
1941639 | 1941639 | 2021-11-22 | Jackson | Missouri | 29095 | 58436 | 827 |
1938389 | 1938389 | 2021-11-21 | Jackson | Missouri | 29095 | 58390 | 834 |
1935139 | 1935139 | 2021-11-20 | Jackson | Missouri | 29095 | 58339 | 834 |
1931889 | 1931889 | 2021-11-19 | Jackson | Missouri | 29095 | 58204 | 833 |
1928638 | 1928638 | 2021-11-18 | Jackson | Missouri | 29095 | 58098 | 826 |
1925388 | 1925388 | 2021-11-17 | Jackson | Missouri | 29095 | 57427 | 720 |
1922139 | 1922139 | 2021-11-16 | Jackson | Missouri | 29095 | 57347 | 717 |
1918889 | 1918889 | 2021-11-15 | Jackson | Missouri | 29095 | 57261 | 714 |
1915639 | 1915639 | 2021-11-14 | Jackson | Missouri | 29095 | 57219 | 714 |
1912389 | 1912389 | 2021-11-13 | Jackson | Missouri | 29095 | 57166 | 714 |
1909139 | 1909139 | 2021-11-12 | Jackson | Missouri | 29095 | 57067 | 713 |
1905890 | 1905890 | 2021-11-11 | Jackson | Missouri | 29095 | 56856 | 713 |
1902641 | 1902641 | 2021-11-10 | Jackson | Missouri | 29095 | 56856 | 713 |
1899391 | 1899391 | 2021-11-09 | Jackson | Missouri | 29095 | 56758 | 710 |
1896141 | 1896141 | 2021-11-08 | Jackson | Missouri | 29095 | 56670 | 709 |
1892891 | 1892891 | 2021-11-07 | Jackson | Missouri | 29095 | 56626 | 709 |
1889641 | 1889641 | 2021-11-06 | Jackson | Missouri | 29095 | 56572 | 709 |
1886391 | 1886391 | 2021-11-05 | Jackson | Missouri | 29095 | 56478 | 709 |
1883142 | 1883142 | 2021-11-04 | Jackson | Missouri | 29095 | 56413 | 707 |
1879893 | 1879893 | 2021-11-03 | Jackson | Missouri | 29095 | 56308 | 707 |
1876644 | 1876644 | 2021-11-02 | Jackson | Missouri | 29095 | 56248 | 707 |
1873395 | 1873395 | 2021-11-01 | Jackson | Missouri | 29095 | 56176 | 698 |
1870146 | 1870146 | 2021-10-31 | Jackson | Missouri | 29095 | 56143 | 698 |
1866897 | 1866897 | 2021-10-30 | Jackson | Missouri | 29095 | 56089 | 698 |
1863648 | 1863648 | 2021-10-29 | Jackson | Missouri | 29095 | 56007 | 696 |
1860399 | 1860399 | 2021-10-28 | Jackson | Missouri | 29095 | 55932 | 695 |
1857150 | 1857150 | 2021-10-27 | Jackson | Missouri | 29095 | 55851 | 693 |
1853901 | 1853901 | 2021-10-26 | Jackson | Missouri | 29095 | 55775 | 690 |
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);