ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 29077 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175731 | 2175731 | 2022-02-02 | Greene | Missouri | 29077 | 67293 | 895 |
2172478 | 2172478 | 2022-02-01 | Greene | Missouri | 29077 | 66523 | 895 |
2169225 | 2169225 | 2022-01-31 | Greene | Missouri | 29077 | 66293 | 882 |
2165970 | 2165970 | 2022-01-30 | Greene | Missouri | 29077 | 65363 | 882 |
2162715 | 2162715 | 2022-01-29 | Greene | Missouri | 29077 | 65153 | 882 |
2159460 | 2159460 | 2022-01-28 | Greene | Missouri | 29077 | 65153 | 882 |
2156206 | 2156206 | 2022-01-27 | Greene | Missouri | 29077 | 64706 | 881 |
2152953 | 2152953 | 2022-01-26 | Greene | Missouri | 29077 | 64086 | 881 |
2149701 | 2149701 | 2022-01-25 | Greene | Missouri | 29077 | 63552 | 880 |
2146449 | 2146449 | 2022-01-24 | Greene | Missouri | 29077 | 63088 | 878 |
2143194 | 2143194 | 2022-01-23 | Greene | Missouri | 29077 | 61535 | 878 |
2139939 | 2139939 | 2022-01-22 | Greene | Missouri | 29077 | 61231 | 878 |
2136683 | 2136683 | 2022-01-21 | Greene | Missouri | 29077 | 61231 | 877 |
2133431 | 2133431 | 2022-01-20 | Greene | Missouri | 29077 | 59934 | 867 |
2130178 | 2130178 | 2022-01-19 | Greene | Missouri | 29077 | 58557 | 867 |
2126924 | 2126924 | 2022-01-18 | Greene | Missouri | 29077 | 57664 | 860 |
2123672 | 2123672 | 2022-01-17 | Greene | Missouri | 29077 | 55590 | 860 |
2120420 | 2120420 | 2022-01-16 | Greene | Missouri | 29077 | 55590 | 860 |
2117168 | 2117168 | 2022-01-15 | Greene | Missouri | 29077 | 55590 | 860 |
2113917 | 2113917 | 2022-01-14 | Greene | Missouri | 29077 | 55590 | 860 |
2110665 | 2110665 | 2022-01-13 | Greene | Missouri | 29077 | 55114 | 860 |
2107414 | 2107414 | 2022-01-12 | Greene | Missouri | 29077 | 54436 | 860 |
2104163 | 2104163 | 2022-01-11 | Greene | Missouri | 29077 | 53971 | 860 |
2100912 | 2100912 | 2022-01-10 | Greene | Missouri | 29077 | 53554 | 851 |
2097661 | 2097661 | 2022-01-09 | Greene | Missouri | 29077 | 52111 | 851 |
2094409 | 2094409 | 2022-01-08 | Greene | Missouri | 29077 | 52111 | 851 |
2091157 | 2091157 | 2022-01-07 | Greene | Missouri | 29077 | 52111 | 851 |
2087906 | 2087906 | 2022-01-06 | Greene | Missouri | 29077 | 51677 | 851 |
2084654 | 2084654 | 2022-01-05 | Greene | Missouri | 29077 | 51335 | 851 |
2081402 | 2081402 | 2022-01-04 | Greene | Missouri | 29077 | 50862 | 851 |
2078150 | 2078150 | 2022-01-03 | Greene | Missouri | 29077 | 50698 | 847 |
2074899 | 2074899 | 2022-01-02 | Greene | Missouri | 29077 | 49923 | 847 |
2071648 | 2071648 | 2022-01-01 | Greene | Missouri | 29077 | 49923 | 847 |
2068397 | 2068397 | 2021-12-31 | Greene | Missouri | 29077 | 49923 | 847 |
2065146 | 2065146 | 2021-12-30 | Greene | Missouri | 29077 | 49923 | 847 |
2061896 | 2061896 | 2021-12-29 | Greene | Missouri | 29077 | 49602 | 847 |
2058647 | 2058647 | 2021-12-28 | Greene | Missouri | 29077 | 49395 | 847 |
2055398 | 2055398 | 2021-12-27 | Greene | Missouri | 29077 | 49276 | 843 |
2052148 | 2052148 | 2021-12-26 | Greene | Missouri | 29077 | 48908 | 843 |
2048898 | 2048898 | 2021-12-25 | Greene | Missouri | 29077 | 48908 | 843 |
2045648 | 2045648 | 2021-12-24 | Greene | Missouri | 29077 | 48908 | 843 |
2042398 | 2042398 | 2021-12-23 | Greene | Missouri | 29077 | 48908 | 843 |
2039149 | 2039149 | 2021-12-22 | Greene | Missouri | 29077 | 48708 | 843 |
2035899 | 2035899 | 2021-12-21 | Greene | Missouri | 29077 | 48577 | 843 |
2032649 | 2032649 | 2021-12-20 | Greene | Missouri | 29077 | 48459 | 836 |
2029398 | 2029398 | 2021-12-19 | Greene | Missouri | 29077 | 48171 | 836 |
2026147 | 2026147 | 2021-12-18 | Greene | Missouri | 29077 | 48171 | 836 |
2022896 | 2022896 | 2021-12-17 | Greene | Missouri | 29077 | 48171 | 836 |
2019645 | 2019645 | 2021-12-16 | Greene | Missouri | 29077 | 48041 | 836 |
2016395 | 2016395 | 2021-12-15 | Greene | Missouri | 29077 | 47911 | 836 |
2013144 | 2013144 | 2021-12-14 | Greene | Missouri | 29077 | 47741 | 836 |
2009893 | 2009893 | 2021-12-13 | Greene | Missouri | 29077 | 47679 | 832 |
2006642 | 2006642 | 2021-12-12 | Greene | Missouri | 29077 | 47456 | 832 |
2003391 | 2003391 | 2021-12-11 | Greene | Missouri | 29077 | 47456 | 832 |
2000141 | 2000141 | 2021-12-10 | Greene | Missouri | 29077 | 47456 | 832 |
1996890 | 1996890 | 2021-12-09 | Greene | Missouri | 29077 | 47343 | 832 |
1993639 | 1993639 | 2021-12-08 | Greene | Missouri | 29077 | 47221 | 830 |
1990388 | 1990388 | 2021-12-07 | Greene | Missouri | 29077 | 47120 | 830 |
1987138 | 1987138 | 2021-12-06 | Greene | Missouri | 29077 | 47018 | 828 |
1983888 | 1983888 | 2021-12-05 | Greene | Missouri | 29077 | 46785 | 828 |
1980638 | 1980638 | 2021-12-04 | Greene | Missouri | 29077 | 46785 | 828 |
1977388 | 1977388 | 2021-12-03 | Greene | Missouri | 29077 | 46785 | 827 |
1974138 | 1974138 | 2021-12-02 | Greene | Missouri | 29077 | 46657 | 827 |
1970889 | 1970889 | 2021-12-01 | Greene | Missouri | 29077 | 46528 | 826 |
1967639 | 1967639 | 2021-11-30 | Greene | Missouri | 29077 | 46411 | 826 |
1964387 | 1964387 | 2021-11-29 | Greene | Missouri | 29077 | 46326 | 825 |
1961136 | 1961136 | 2021-11-28 | Greene | Missouri | 29077 | 46199 | 825 |
1957885 | 1957885 | 2021-11-27 | Greene | Missouri | 29077 | 46199 | 825 |
1954634 | 1954634 | 2021-11-26 | Greene | Missouri | 29077 | 46199 | 825 |
1951383 | 1951383 | 2021-11-25 | Greene | Missouri | 29077 | 46078 | 825 |
1948132 | 1948132 | 2021-11-24 | Greene | Missouri | 29077 | 46078 | 825 |
1944881 | 1944881 | 2021-11-23 | Greene | Missouri | 29077 | 46011 | 825 |
1941630 | 1941630 | 2021-11-22 | Greene | Missouri | 29077 | 45937 | 821 |
1938380 | 1938380 | 2021-11-21 | Greene | Missouri | 29077 | 45806 | 827 |
1935130 | 1935130 | 2021-11-20 | Greene | Missouri | 29077 | 45806 | 827 |
1931880 | 1931880 | 2021-11-19 | Greene | Missouri | 29077 | 45806 | 827 |
1928629 | 1928629 | 2021-11-18 | Greene | Missouri | 29077 | 45754 | 821 |
1925379 | 1925379 | 2021-11-17 | Greene | Missouri | 29077 | 45700 | 685 |
1922130 | 1922130 | 2021-11-16 | Greene | Missouri | 29077 | 45633 | 685 |
1918880 | 1918880 | 2021-11-15 | Greene | Missouri | 29077 | 45588 | 680 |
1915630 | 1915630 | 2021-11-14 | Greene | Missouri | 29077 | 45465 | 680 |
1912380 | 1912380 | 2021-11-13 | Greene | Missouri | 29077 | 45465 | 680 |
1909130 | 1909130 | 2021-11-12 | Greene | Missouri | 29077 | 45465 | 680 |
1905881 | 1905881 | 2021-11-11 | Greene | Missouri | 29077 | 45378 | 680 |
1902632 | 1902632 | 2021-11-10 | Greene | Missouri | 29077 | 45378 | 680 |
1899382 | 1899382 | 2021-11-09 | Greene | Missouri | 29077 | 45332 | 680 |
1896132 | 1896132 | 2021-11-08 | Greene | Missouri | 29077 | 45279 | 676 |
1892882 | 1892882 | 2021-11-07 | Greene | Missouri | 29077 | 45176 | 676 |
1889632 | 1889632 | 2021-11-06 | Greene | Missouri | 29077 | 45176 | 676 |
1886382 | 1886382 | 2021-11-05 | Greene | Missouri | 29077 | 45176 | 676 |
1883133 | 1883133 | 2021-11-04 | Greene | Missouri | 29077 | 45112 | 676 |
1879884 | 1879884 | 2021-11-03 | Greene | Missouri | 29077 | 45060 | 675 |
1876635 | 1876635 | 2021-11-02 | Greene | Missouri | 29077 | 45012 | 675 |
1873386 | 1873386 | 2021-11-01 | Greene | Missouri | 29077 | 44979 | 667 |
1870137 | 1870137 | 2021-10-31 | Greene | Missouri | 29077 | 44895 | 667 |
1866888 | 1866888 | 2021-10-30 | Greene | Missouri | 29077 | 44895 | 667 |
1863639 | 1863639 | 2021-10-29 | Greene | Missouri | 29077 | 44895 | 667 |
1860390 | 1860390 | 2021-10-28 | Greene | Missouri | 29077 | 44845 | 667 |
1857141 | 1857141 | 2021-10-27 | Greene | Missouri | 29077 | 44801 | 667 |
1853892 | 1853892 | 2021-10-26 | Greene | Missouri | 29077 | 44764 | 667 |
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);