ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29029 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175707 | 2175707 | 2022-02-02 | Camden | Missouri | 29029 | 8935 | 165 |
2172454 | 2172454 | 2022-02-01 | Camden | Missouri | 29029 | 8876 | 165 |
2169201 | 2169201 | 2022-01-31 | Camden | Missouri | 29029 | 8830 | 163 |
2165946 | 2165946 | 2022-01-30 | Camden | Missouri | 29029 | 8786 | 163 |
2162691 | 2162691 | 2022-01-29 | Camden | Missouri | 29029 | 8772 | 163 |
2159436 | 2159436 | 2022-01-28 | Camden | Missouri | 29029 | 8720 | 163 |
2156182 | 2156182 | 2022-01-27 | Camden | Missouri | 29029 | 8655 | 162 |
2152929 | 2152929 | 2022-01-26 | Camden | Missouri | 29029 | 8579 | 162 |
2149677 | 2149677 | 2022-01-25 | Camden | Missouri | 29029 | 8479 | 162 |
2146425 | 2146425 | 2022-01-24 | Camden | Missouri | 29029 | 8396 | 161 |
2143170 | 2143170 | 2022-01-23 | Camden | Missouri | 29029 | 8377 | 161 |
2139915 | 2139915 | 2022-01-22 | Camden | Missouri | 29029 | 8311 | 161 |
2136659 | 2136659 | 2022-01-21 | Camden | Missouri | 29029 | 8226 | 160 |
2133407 | 2133407 | 2022-01-20 | Camden | Missouri | 29029 | 8108 | 157 |
2130154 | 2130154 | 2022-01-19 | Camden | Missouri | 29029 | 8024 | 157 |
2126900 | 2126900 | 2022-01-18 | Camden | Missouri | 29029 | 7896 | 155 |
2123648 | 2123648 | 2022-01-17 | Camden | Missouri | 29029 | 7769 | 155 |
2120396 | 2120396 | 2022-01-16 | Camden | Missouri | 29029 | 7769 | 155 |
2117144 | 2117144 | 2022-01-15 | Camden | Missouri | 29029 | 7769 | 155 |
2113893 | 2113893 | 2022-01-14 | Camden | Missouri | 29029 | 7681 | 155 |
2110641 | 2110641 | 2022-01-13 | Camden | Missouri | 29029 | 7601 | 155 |
2107390 | 2107390 | 2022-01-12 | Camden | Missouri | 29029 | 7521 | 155 |
2104139 | 2104139 | 2022-01-11 | Camden | Missouri | 29029 | 7468 | 155 |
2100888 | 2100888 | 2022-01-10 | Camden | Missouri | 29029 | 7405 | 152 |
2097637 | 2097637 | 2022-01-09 | Camden | Missouri | 29029 | 7373 | 152 |
2094385 | 2094385 | 2022-01-08 | Camden | Missouri | 29029 | 7363 | 152 |
2091133 | 2091133 | 2022-01-07 | Camden | Missouri | 29029 | 7298 | 152 |
2087882 | 2087882 | 2022-01-06 | Camden | Missouri | 29029 | 7260 | 152 |
2084630 | 2084630 | 2022-01-05 | Camden | Missouri | 29029 | 7204 | 151 |
2081378 | 2081378 | 2022-01-04 | Camden | Missouri | 29029 | 7138 | 151 |
2078126 | 2078126 | 2022-01-03 | Camden | Missouri | 29029 | 7086 | 151 |
2074875 | 2074875 | 2022-01-02 | Camden | Missouri | 29029 | 7054 | 151 |
2071624 | 2071624 | 2022-01-01 | Camden | Missouri | 29029 | 7054 | 151 |
2068373 | 2068373 | 2021-12-31 | Camden | Missouri | 29029 | 7054 | 151 |
2065122 | 2065122 | 2021-12-30 | Camden | Missouri | 29029 | 7054 | 151 |
2061872 | 2061872 | 2021-12-29 | Camden | Missouri | 29029 | 7023 | 151 |
2058623 | 2058623 | 2021-12-28 | Camden | Missouri | 29029 | 7005 | 151 |
2055374 | 2055374 | 2021-12-27 | Camden | Missouri | 29029 | 6977 | 150 |
2052124 | 2052124 | 2021-12-26 | Camden | Missouri | 29029 | 6947 | 150 |
2048874 | 2048874 | 2021-12-25 | Camden | Missouri | 29029 | 6947 | 150 |
2045624 | 2045624 | 2021-12-24 | Camden | Missouri | 29029 | 6947 | 150 |
2042374 | 2042374 | 2021-12-23 | Camden | Missouri | 29029 | 6947 | 150 |
2039125 | 2039125 | 2021-12-22 | Camden | Missouri | 29029 | 6907 | 150 |
2035875 | 2035875 | 2021-12-21 | Camden | Missouri | 29029 | 6904 | 150 |
2032625 | 2032625 | 2021-12-20 | Camden | Missouri | 29029 | 6889 | 149 |
2029374 | 2029374 | 2021-12-19 | Camden | Missouri | 29029 | 6881 | 149 |
2026123 | 2026123 | 2021-12-18 | Camden | Missouri | 29029 | 6877 | 149 |
2022872 | 2022872 | 2021-12-17 | Camden | Missouri | 29029 | 6849 | 149 |
2019621 | 2019621 | 2021-12-16 | Camden | Missouri | 29029 | 6838 | 149 |
2016371 | 2016371 | 2021-12-15 | Camden | Missouri | 29029 | 6815 | 149 |
2013120 | 2013120 | 2021-12-14 | Camden | Missouri | 29029 | 6800 | 149 |
2009869 | 2009869 | 2021-12-13 | Camden | Missouri | 29029 | 6787 | 148 |
2006618 | 2006618 | 2021-12-12 | Camden | Missouri | 29029 | 6762 | 148 |
2003367 | 2003367 | 2021-12-11 | Camden | Missouri | 29029 | 6760 | 148 |
2000117 | 2000117 | 2021-12-10 | Camden | Missouri | 29029 | 6759 | 148 |
1996866 | 1996866 | 2021-12-09 | Camden | Missouri | 29029 | 6747 | 148 |
1993615 | 1993615 | 2021-12-08 | Camden | Missouri | 29029 | 6735 | 148 |
1990364 | 1990364 | 2021-12-07 | Camden | Missouri | 29029 | 6733 | 148 |
1987114 | 1987114 | 2021-12-06 | Camden | Missouri | 29029 | 6718 | 146 |
1983864 | 1983864 | 2021-12-05 | Camden | Missouri | 29029 | 6707 | 146 |
1980614 | 1980614 | 2021-12-04 | Camden | Missouri | 29029 | 6692 | 146 |
1977364 | 1977364 | 2021-12-03 | Camden | Missouri | 29029 | 6653 | 146 |
1974114 | 1974114 | 2021-12-02 | Camden | Missouri | 29029 | 6653 | 146 |
1970865 | 1970865 | 2021-12-01 | Camden | Missouri | 29029 | 6637 | 146 |
1967615 | 1967615 | 2021-11-30 | Camden | Missouri | 29029 | 6627 | 146 |
1964363 | 1964363 | 2021-11-29 | Camden | Missouri | 29029 | 6616 | 144 |
1961112 | 1961112 | 2021-11-28 | Camden | Missouri | 29029 | 6585 | 144 |
1957861 | 1957861 | 2021-11-27 | Camden | Missouri | 29029 | 6585 | 144 |
1954610 | 1954610 | 2021-11-26 | Camden | Missouri | 29029 | 6585 | 144 |
1951359 | 1951359 | 2021-11-25 | Camden | Missouri | 29029 | 6585 | 144 |
1948108 | 1948108 | 2021-11-24 | Camden | Missouri | 29029 | 6585 | 144 |
1944857 | 1944857 | 2021-11-23 | Camden | Missouri | 29029 | 6583 | 144 |
1941606 | 1941606 | 2021-11-22 | Camden | Missouri | 29029 | 6576 | 143 |
1938356 | 1938356 | 2021-11-21 | Camden | Missouri | 29029 | 6573 | 144 |
1935106 | 1935106 | 2021-11-20 | Camden | Missouri | 29029 | 6569 | 144 |
1931856 | 1931856 | 2021-11-19 | Camden | Missouri | 29029 | 6563 | 144 |
1928605 | 1928605 | 2021-11-18 | Camden | Missouri | 29029 | 6547 | 144 |
1925355 | 1925355 | 2021-11-17 | Camden | Missouri | 29029 | 6471 | 126 |
1922106 | 1922106 | 2021-11-16 | Camden | Missouri | 29029 | 6462 | 126 |
1918856 | 1918856 | 2021-11-15 | Camden | Missouri | 29029 | 6443 | 125 |
1915606 | 1915606 | 2021-11-14 | Camden | Missouri | 29029 | 6441 | 125 |
1912356 | 1912356 | 2021-11-13 | Camden | Missouri | 29029 | 6426 | 125 |
1909106 | 1909106 | 2021-11-12 | Camden | Missouri | 29029 | 6422 | 125 |
1905857 | 1905857 | 2021-11-11 | Camden | Missouri | 29029 | 6401 | 125 |
1902608 | 1902608 | 2021-11-10 | Camden | Missouri | 29029 | 6401 | 125 |
1899358 | 1899358 | 2021-11-09 | Camden | Missouri | 29029 | 6398 | 125 |
1896108 | 1896108 | 2021-11-08 | Camden | Missouri | 29029 | 6390 | 125 |
1892858 | 1892858 | 2021-11-07 | Camden | Missouri | 29029 | 6385 | 125 |
1889608 | 1889608 | 2021-11-06 | Camden | Missouri | 29029 | 6377 | 125 |
1886358 | 1886358 | 2021-11-05 | Camden | Missouri | 29029 | 6372 | 125 |
1883109 | 1883109 | 2021-11-04 | Camden | Missouri | 29029 | 6365 | 125 |
1879860 | 1879860 | 2021-11-03 | Camden | Missouri | 29029 | 6365 | 125 |
1876611 | 1876611 | 2021-11-02 | Camden | Missouri | 29029 | 6352 | 125 |
1873362 | 1873362 | 2021-11-01 | Camden | Missouri | 29029 | 6346 | 125 |
1870113 | 1870113 | 2021-10-31 | Camden | Missouri | 29029 | 6344 | 125 |
1866864 | 1866864 | 2021-10-30 | Camden | Missouri | 29029 | 6336 | 125 |
1863615 | 1863615 | 2021-10-29 | Camden | Missouri | 29029 | 6327 | 125 |
1860366 | 1860366 | 2021-10-28 | Camden | Missouri | 29029 | 6324 | 125 |
1857117 | 1857117 | 2021-10-27 | Camden | Missouri | 29029 | 6321 | 125 |
1853868 | 1853868 | 2021-10-26 | Camden | Missouri | 29029 | 6318 | 125 |
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);