ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 29083 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175734 | 2175734 | 2022-02-02 | Henry | Missouri | 29083 | 5442 | 74 |
2172481 | 2172481 | 2022-02-01 | Henry | Missouri | 29083 | 5403 | 74 |
2169228 | 2169228 | 2022-01-31 | Henry | Missouri | 29083 | 5379 | 68 |
2165973 | 2165973 | 2022-01-30 | Henry | Missouri | 29083 | 5374 | 68 |
2162718 | 2162718 | 2022-01-29 | Henry | Missouri | 29083 | 5352 | 68 |
2159463 | 2159463 | 2022-01-28 | Henry | Missouri | 29083 | 5298 | 68 |
2156209 | 2156209 | 2022-01-27 | Henry | Missouri | 29083 | 5259 | 68 |
2152956 | 2152956 | 2022-01-26 | Henry | Missouri | 29083 | 5167 | 68 |
2149704 | 2149704 | 2022-01-25 | Henry | Missouri | 29083 | 5111 | 68 |
2146452 | 2146452 | 2022-01-24 | Henry | Missouri | 29083 | 5038 | 68 |
2143197 | 2143197 | 2022-01-23 | Henry | Missouri | 29083 | 5005 | 68 |
2139942 | 2139942 | 2022-01-22 | Henry | Missouri | 29083 | 4974 | 68 |
2136686 | 2136686 | 2022-01-21 | Henry | Missouri | 29083 | 4927 | 68 |
2133434 | 2133434 | 2022-01-20 | Henry | Missouri | 29083 | 4856 | 66 |
2130181 | 2130181 | 2022-01-19 | Henry | Missouri | 29083 | 4744 | 66 |
2126927 | 2126927 | 2022-01-18 | Henry | Missouri | 29083 | 4655 | 66 |
2123675 | 2123675 | 2022-01-17 | Henry | Missouri | 29083 | 4572 | 66 |
2120423 | 2120423 | 2022-01-16 | Henry | Missouri | 29083 | 4572 | 66 |
2117171 | 2117171 | 2022-01-15 | Henry | Missouri | 29083 | 4572 | 66 |
2113920 | 2113920 | 2022-01-14 | Henry | Missouri | 29083 | 4526 | 66 |
2110668 | 2110668 | 2022-01-13 | Henry | Missouri | 29083 | 4482 | 66 |
2107417 | 2107417 | 2022-01-12 | Henry | Missouri | 29083 | 4435 | 66 |
2104166 | 2104166 | 2022-01-11 | Henry | Missouri | 29083 | 4412 | 66 |
2100915 | 2100915 | 2022-01-10 | Henry | Missouri | 29083 | 4381 | 67 |
2097664 | 2097664 | 2022-01-09 | Henry | Missouri | 29083 | 4357 | 67 |
2094412 | 2094412 | 2022-01-08 | Henry | Missouri | 29083 | 4350 | 67 |
2091160 | 2091160 | 2022-01-07 | Henry | Missouri | 29083 | 4282 | 67 |
2087909 | 2087909 | 2022-01-06 | Henry | Missouri | 29083 | 4234 | 67 |
2084657 | 2084657 | 2022-01-05 | Henry | Missouri | 29083 | 4202 | 67 |
2081405 | 2081405 | 2022-01-04 | Henry | Missouri | 29083 | 4159 | 67 |
2078153 | 2078153 | 2022-01-03 | Henry | Missouri | 29083 | 4139 | 66 |
2074902 | 2074902 | 2022-01-02 | Henry | Missouri | 29083 | 4053 | 66 |
2071651 | 2071651 | 2022-01-01 | Henry | Missouri | 29083 | 4053 | 66 |
2068400 | 2068400 | 2021-12-31 | Henry | Missouri | 29083 | 4053 | 66 |
2065149 | 2065149 | 2021-12-30 | Henry | Missouri | 29083 | 4053 | 66 |
2061899 | 2061899 | 2021-12-29 | Henry | Missouri | 29083 | 4015 | 66 |
2058650 | 2058650 | 2021-12-28 | Henry | Missouri | 29083 | 4004 | 66 |
2055401 | 2055401 | 2021-12-27 | Henry | Missouri | 29083 | 3987 | 66 |
2052151 | 2052151 | 2021-12-26 | Henry | Missouri | 29083 | 3955 | 66 |
2048901 | 2048901 | 2021-12-25 | Henry | Missouri | 29083 | 3955 | 66 |
2045651 | 2045651 | 2021-12-24 | Henry | Missouri | 29083 | 3955 | 66 |
2042401 | 2042401 | 2021-12-23 | Henry | Missouri | 29083 | 3955 | 66 |
2039152 | 2039152 | 2021-12-22 | Henry | Missouri | 29083 | 3916 | 66 |
2035902 | 2035902 | 2021-12-21 | Henry | Missouri | 29083 | 3896 | 66 |
2032652 | 2032652 | 2021-12-20 | Henry | Missouri | 29083 | 3890 | 65 |
2029401 | 2029401 | 2021-12-19 | Henry | Missouri | 29083 | 3882 | 65 |
2026150 | 2026150 | 2021-12-18 | Henry | Missouri | 29083 | 3878 | 65 |
2022899 | 2022899 | 2021-12-17 | Henry | Missouri | 29083 | 3858 | 65 |
2019648 | 2019648 | 2021-12-16 | Henry | Missouri | 29083 | 3836 | 65 |
2016398 | 2016398 | 2021-12-15 | Henry | Missouri | 29083 | 3798 | 65 |
2013147 | 2013147 | 2021-12-14 | Henry | Missouri | 29083 | 3777 | 64 |
2009896 | 2009896 | 2021-12-13 | Henry | Missouri | 29083 | 3770 | 64 |
2006645 | 2006645 | 2021-12-12 | Henry | Missouri | 29083 | 3768 | 64 |
2003394 | 2003394 | 2021-12-11 | Henry | Missouri | 29083 | 3759 | 64 |
2000144 | 2000144 | 2021-12-10 | Henry | Missouri | 29083 | 3731 | 64 |
1996893 | 1996893 | 2021-12-09 | Henry | Missouri | 29083 | 3710 | 64 |
1993642 | 1993642 | 2021-12-08 | Henry | Missouri | 29083 | 3703 | 64 |
1990391 | 1990391 | 2021-12-07 | Henry | Missouri | 29083 | 3678 | 64 |
1987141 | 1987141 | 2021-12-06 | Henry | Missouri | 29083 | 3673 | 63 |
1983891 | 1983891 | 2021-12-05 | Henry | Missouri | 29083 | 3664 | 63 |
1980641 | 1980641 | 2021-12-04 | Henry | Missouri | 29083 | 3657 | 63 |
1977391 | 1977391 | 2021-12-03 | Henry | Missouri | 29083 | 3628 | 63 |
1974141 | 1974141 | 2021-12-02 | Henry | Missouri | 29083 | 3628 | 63 |
1970892 | 1970892 | 2021-12-01 | Henry | Missouri | 29083 | 3604 | 63 |
1967642 | 1967642 | 2021-11-30 | Henry | Missouri | 29083 | 3592 | 63 |
1964390 | 1964390 | 2021-11-29 | Henry | Missouri | 29083 | 3575 | 62 |
1961139 | 1961139 | 2021-11-28 | Henry | Missouri | 29083 | 3541 | 62 |
1957888 | 1957888 | 2021-11-27 | Henry | Missouri | 29083 | 3541 | 62 |
1954637 | 1954637 | 2021-11-26 | Henry | Missouri | 29083 | 3541 | 62 |
1951386 | 1951386 | 2021-11-25 | Henry | Missouri | 29083 | 3541 | 62 |
1948135 | 1948135 | 2021-11-24 | Henry | Missouri | 29083 | 3541 | 62 |
1944884 | 1944884 | 2021-11-23 | Henry | Missouri | 29083 | 3537 | 62 |
1941633 | 1941633 | 2021-11-22 | Henry | Missouri | 29083 | 3515 | 62 |
1938383 | 1938383 | 2021-11-21 | Henry | Missouri | 29083 | 3515 | 62 |
1935133 | 1935133 | 2021-11-20 | Henry | Missouri | 29083 | 3511 | 62 |
1931883 | 1931883 | 2021-11-19 | Henry | Missouri | 29083 | 3507 | 62 |
1928632 | 1928632 | 2021-11-18 | Henry | Missouri | 29083 | 3501 | 62 |
1925382 | 1925382 | 2021-11-17 | Henry | Missouri | 29083 | 3457 | 51 |
1922133 | 1922133 | 2021-11-16 | Henry | Missouri | 29083 | 3441 | 51 |
1918883 | 1918883 | 2021-11-15 | Henry | Missouri | 29083 | 3433 | 51 |
1915633 | 1915633 | 2021-11-14 | Henry | Missouri | 29083 | 3429 | 51 |
1912383 | 1912383 | 2021-11-13 | Henry | Missouri | 29083 | 3413 | 51 |
1909133 | 1909133 | 2021-11-12 | Henry | Missouri | 29083 | 3395 | 51 |
1905884 | 1905884 | 2021-11-11 | Henry | Missouri | 29083 | 3371 | 51 |
1902635 | 1902635 | 2021-11-10 | Henry | Missouri | 29083 | 3371 | 51 |
1899385 | 1899385 | 2021-11-09 | Henry | Missouri | 29083 | 3361 | 51 |
1896135 | 1896135 | 2021-11-08 | Henry | Missouri | 29083 | 3352 | 51 |
1892885 | 1892885 | 2021-11-07 | Henry | Missouri | 29083 | 3346 | 51 |
1889635 | 1889635 | 2021-11-06 | Henry | Missouri | 29083 | 3344 | 51 |
1886385 | 1886385 | 2021-11-05 | Henry | Missouri | 29083 | 3340 | 51 |
1883136 | 1883136 | 2021-11-04 | Henry | Missouri | 29083 | 3336 | 51 |
1879887 | 1879887 | 2021-11-03 | Henry | Missouri | 29083 | 3331 | 51 |
1876638 | 1876638 | 2021-11-02 | Henry | Missouri | 29083 | 3325 | 51 |
1873389 | 1873389 | 2021-11-01 | Henry | Missouri | 29083 | 3321 | 50 |
1870140 | 1870140 | 2021-10-31 | Henry | Missouri | 29083 | 3319 | 50 |
1866891 | 1866891 | 2021-10-30 | Henry | Missouri | 29083 | 3316 | 50 |
1863642 | 1863642 | 2021-10-29 | Henry | Missouri | 29083 | 3312 | 50 |
1860393 | 1860393 | 2021-10-28 | Henry | Missouri | 29083 | 3300 | 50 |
1857144 | 1857144 | 2021-10-27 | Henry | Missouri | 29083 | 3291 | 50 |
1853895 | 1853895 | 2021-10-26 | Henry | Missouri | 29083 | 3288 | 50 |
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);