ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 29037 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110645 | 2110645 | 2022-01-13 | Cass | Missouri | 29037 | 20001 | 233 |
2107394 | 2107394 | 2022-01-12 | Cass | Missouri | 29037 | 19660 | 233 |
2104143 | 2104143 | 2022-01-11 | Cass | Missouri | 29037 | 19439 | 233 |
2100892 | 2100892 | 2022-01-10 | Cass | Missouri | 29037 | 19224 | 231 |
2097641 | 2097641 | 2022-01-09 | Cass | Missouri | 29037 | 19109 | 231 |
2094389 | 2094389 | 2022-01-08 | Cass | Missouri | 29037 | 19042 | 231 |
2091137 | 2091137 | 2022-01-07 | Cass | Missouri | 29037 | 18749 | 231 |
2087886 | 2087886 | 2022-01-06 | Cass | Missouri | 29037 | 18526 | 231 |
2084634 | 2084634 | 2022-01-05 | Cass | Missouri | 29037 | 18284 | 231 |
2081382 | 2081382 | 2022-01-04 | Cass | Missouri | 29037 | 18073 | 230 |
2078130 | 2078130 | 2022-01-03 | Cass | Missouri | 29037 | 17935 | 225 |
2074879 | 2074879 | 2022-01-02 | Cass | Missouri | 29037 | 17537 | 225 |
2071628 | 2071628 | 2022-01-01 | Cass | Missouri | 29037 | 17537 | 225 |
2068377 | 2068377 | 2021-12-31 | Cass | Missouri | 29037 | 17537 | 225 |
2065126 | 2065126 | 2021-12-30 | Cass | Missouri | 29037 | 17537 | 225 |
2061876 | 2061876 | 2021-12-29 | Cass | Missouri | 29037 | 17385 | 225 |
2058627 | 2058627 | 2021-12-28 | Cass | Missouri | 29037 | 17260 | 224 |
2055378 | 2055378 | 2021-12-27 | Cass | Missouri | 29037 | 17157 | 221 |
2052128 | 2052128 | 2021-12-26 | Cass | Missouri | 29037 | 17010 | 221 |
2048878 | 2048878 | 2021-12-25 | Cass | Missouri | 29037 | 17010 | 221 |
2045628 | 2045628 | 2021-12-24 | Cass | Missouri | 29037 | 17010 | 221 |
2042378 | 2042378 | 2021-12-23 | Cass | Missouri | 29037 | 17010 | 221 |
2039129 | 2039129 | 2021-12-22 | Cass | Missouri | 29037 | 16862 | 221 |
2035879 | 2035879 | 2021-12-21 | Cass | Missouri | 29037 | 16777 | 220 |
2032629 | 2032629 | 2021-12-20 | Cass | Missouri | 29037 | 16703 | 216 |
2029378 | 2029378 | 2021-12-19 | Cass | Missouri | 29037 | 16682 | 216 |
2026127 | 2026127 | 2021-12-18 | Cass | Missouri | 29037 | 16644 | 216 |
2022876 | 2022876 | 2021-12-17 | Cass | Missouri | 29037 | 16559 | 216 |
2019625 | 2019625 | 2021-12-16 | Cass | Missouri | 29037 | 16479 | 215 |
2016375 | 2016375 | 2021-12-15 | Cass | Missouri | 29037 | 16395 | 215 |
2013124 | 2013124 | 2021-12-14 | Cass | Missouri | 29037 | 16298 | 215 |
2009873 | 2009873 | 2021-12-13 | Cass | Missouri | 29037 | 16222 | 213 |
2006622 | 2006622 | 2021-12-12 | Cass | Missouri | 29037 | 16207 | 213 |
2003371 | 2003371 | 2021-12-11 | Cass | Missouri | 29037 | 16164 | 213 |
2000121 | 2000121 | 2021-12-10 | Cass | Missouri | 29037 | 16113 | 212 |
1996870 | 1996870 | 2021-12-09 | Cass | Missouri | 29037 | 16040 | 211 |
1993619 | 1993619 | 2021-12-08 | Cass | Missouri | 29037 | 15942 | 211 |
1990368 | 1990368 | 2021-12-07 | Cass | Missouri | 29037 | 15843 | 211 |
1987118 | 1987118 | 2021-12-06 | Cass | Missouri | 29037 | 15791 | 207 |
1983868 | 1983868 | 2021-12-05 | Cass | Missouri | 29037 | 15733 | 207 |
1980618 | 1980618 | 2021-12-04 | Cass | Missouri | 29037 | 15704 | 207 |
1977368 | 1977368 | 2021-12-03 | Cass | Missouri | 29037 | 15576 | 207 |
1974118 | 1974118 | 2021-12-02 | Cass | Missouri | 29037 | 15576 | 207 |
1970869 | 1970869 | 2021-12-01 | Cass | Missouri | 29037 | 15506 | 207 |
1967619 | 1967619 | 2021-11-30 | Cass | Missouri | 29037 | 15436 | 207 |
1964367 | 1964367 | 2021-11-29 | Cass | Missouri | 29037 | 15353 | 203 |
1961116 | 1961116 | 2021-11-28 | Cass | Missouri | 29037 | 15229 | 202 |
1957865 | 1957865 | 2021-11-27 | Cass | Missouri | 29037 | 15229 | 202 |
1954614 | 1954614 | 2021-11-26 | Cass | Missouri | 29037 | 15229 | 202 |
1951363 | 1951363 | 2021-11-25 | Cass | Missouri | 29037 | 15229 | 202 |
1948112 | 1948112 | 2021-11-24 | Cass | Missouri | 29037 | 15229 | 202 |
1944861 | 1944861 | 2021-11-23 | Cass | Missouri | 29037 | 15193 | 202 |
1941610 | 1941610 | 2021-11-22 | Cass | Missouri | 29037 | 15135 | 197 |
1938360 | 1938360 | 2021-11-21 | Cass | Missouri | 29037 | 15130 | 197 |
1935110 | 1935110 | 2021-11-20 | Cass | Missouri | 29037 | 15108 | 197 |
1931860 | 1931860 | 2021-11-19 | Cass | Missouri | 29037 | 15079 | 197 |
1928609 | 1928609 | 2021-11-18 | Cass | Missouri | 29037 | 15044 | 197 |
1925359 | 1925359 | 2021-11-17 | Cass | Missouri | 29037 | 14823 | 172 |
1922110 | 1922110 | 2021-11-16 | Cass | Missouri | 29037 | 14789 | 171 |
1918860 | 1918860 | 2021-11-15 | Cass | Missouri | 29037 | 14756 | 171 |
1915610 | 1915610 | 2021-11-14 | Cass | Missouri | 29037 | 14742 | 171 |
1912360 | 1912360 | 2021-11-13 | Cass | Missouri | 29037 | 14724 | 171 |
1909110 | 1909110 | 2021-11-12 | Cass | Missouri | 29037 | 14698 | 171 |
1905861 | 1905861 | 2021-11-11 | Cass | Missouri | 29037 | 14623 | 170 |
1902612 | 1902612 | 2021-11-10 | Cass | Missouri | 29037 | 14623 | 170 |
1899362 | 1899362 | 2021-11-09 | Cass | Missouri | 29037 | 14583 | 170 |
1896112 | 1896112 | 2021-11-08 | Cass | Missouri | 29037 | 14561 | 168 |
1892862 | 1892862 | 2021-11-07 | Cass | Missouri | 29037 | 14554 | 168 |
1889612 | 1889612 | 2021-11-06 | Cass | Missouri | 29037 | 14540 | 168 |
1886362 | 1886362 | 2021-11-05 | Cass | Missouri | 29037 | 14511 | 168 |
1883113 | 1883113 | 2021-11-04 | Cass | Missouri | 29037 | 14500 | 168 |
1879864 | 1879864 | 2021-11-03 | Cass | Missouri | 29037 | 14482 | 168 |
1876615 | 1876615 | 2021-11-02 | Cass | Missouri | 29037 | 14457 | 168 |
1873366 | 1873366 | 2021-11-01 | Cass | Missouri | 29037 | 14437 | 164 |
1870117 | 1870117 | 2021-10-31 | Cass | Missouri | 29037 | 14422 | 164 |
1866868 | 1866868 | 2021-10-30 | Cass | Missouri | 29037 | 14411 | 164 |
1863619 | 1863619 | 2021-10-29 | Cass | Missouri | 29037 | 14397 | 164 |
1860370 | 1860370 | 2021-10-28 | Cass | Missouri | 29037 | 14379 | 164 |
1857121 | 1857121 | 2021-10-27 | Cass | Missouri | 29037 | 14354 | 164 |
1853872 | 1853872 | 2021-10-26 | Cass | Missouri | 29037 | 14331 | 164 |
1850623 | 1850623 | 2021-10-25 | Cass | Missouri | 29037 | 14305 | 162 |
1847373 | 1847373 | 2021-10-24 | Cass | Missouri | 29037 | 14298 | 162 |
1844123 | 1844123 | 2021-10-23 | Cass | Missouri | 29037 | 14282 | 162 |
1840873 | 1840873 | 2021-10-22 | Cass | Missouri | 29037 | 14264 | 162 |
1837624 | 1837624 | 2021-10-21 | Cass | Missouri | 29037 | 14238 | 162 |
1834375 | 1834375 | 2021-10-20 | Cass | Missouri | 29037 | 14186 | 162 |
1831126 | 1831126 | 2021-10-19 | Cass | Missouri | 29037 | 14163 | 162 |
1827877 | 1827877 | 2021-10-18 | Cass | Missouri | 29037 | 14141 | 158 |
1824628 | 1824628 | 2021-10-17 | Cass | Missouri | 29037 | 14134 | 158 |
1821379 | 1821379 | 2021-10-16 | Cass | Missouri | 29037 | 14123 | 158 |
1818130 | 1818130 | 2021-10-15 | Cass | Missouri | 29037 | 14104 | 158 |
1814881 | 1814881 | 2021-10-14 | Cass | Missouri | 29037 | 14058 | 158 |
1811633 | 1811633 | 2021-10-13 | Cass | Missouri | 29037 | 14025 | 158 |
1808384 | 1808384 | 2021-10-12 | Cass | Missouri | 29037 | 13989 | 154 |
1805133 | 1805133 | 2021-10-11 | Cass | Missouri | 29037 | 13957 | 154 |
1801884 | 1801884 | 2021-10-10 | Cass | Missouri | 29037 | 13946 | 154 |
1798635 | 1798635 | 2021-10-09 | Cass | Missouri | 29037 | 13918 | 154 |
1795386 | 1795386 | 2021-10-08 | Cass | Missouri | 29037 | 13889 | 154 |
1792137 | 1792137 | 2021-10-07 | Cass | Missouri | 29037 | 13855 | 154 |
1788888 | 1788888 | 2021-10-06 | Cass | Missouri | 29037 | 13829 | 154 |
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);