ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Crawford" and fips = 29055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175720 | 2175720 | 2022-02-02 | Crawford | Missouri | 29055 | 5209 | 91 |
2172467 | 2172467 | 2022-02-01 | Crawford | Missouri | 29055 | 5151 | 91 |
2169214 | 2169214 | 2022-01-31 | Crawford | Missouri | 29055 | 5134 | 87 |
2165959 | 2165959 | 2022-01-30 | Crawford | Missouri | 29055 | 5129 | 88 |
2162704 | 2162704 | 2022-01-29 | Crawford | Missouri | 29055 | 5118 | 88 |
2159449 | 2159449 | 2022-01-28 | Crawford | Missouri | 29055 | 5089 | 87 |
2156195 | 2156195 | 2022-01-27 | Crawford | Missouri | 29055 | 5048 | 87 |
2152942 | 2152942 | 2022-01-26 | Crawford | Missouri | 29055 | 5018 | 87 |
2149690 | 2149690 | 2022-01-25 | Crawford | Missouri | 29055 | 4970 | 87 |
2146438 | 2146438 | 2022-01-24 | Crawford | Missouri | 29055 | 4938 | 87 |
2143183 | 2143183 | 2022-01-23 | Crawford | Missouri | 29055 | 4917 | 87 |
2139928 | 2139928 | 2022-01-22 | Crawford | Missouri | 29055 | 4885 | 87 |
2136672 | 2136672 | 2022-01-21 | Crawford | Missouri | 29055 | 4841 | 87 |
2133420 | 2133420 | 2022-01-20 | Crawford | Missouri | 29055 | 4783 | 84 |
2130167 | 2130167 | 2022-01-19 | Crawford | Missouri | 29055 | 4707 | 84 |
2126913 | 2126913 | 2022-01-18 | Crawford | Missouri | 29055 | 4661 | 83 |
2123661 | 2123661 | 2022-01-17 | Crawford | Missouri | 29055 | 4600 | 83 |
2120409 | 2120409 | 2022-01-16 | Crawford | Missouri | 29055 | 4600 | 83 |
2117157 | 2117157 | 2022-01-15 | Crawford | Missouri | 29055 | 4599 | 83 |
2113906 | 2113906 | 2022-01-14 | Crawford | Missouri | 29055 | 4544 | 83 |
2110654 | 2110654 | 2022-01-13 | Crawford | Missouri | 29055 | 4520 | 83 |
2107403 | 2107403 | 2022-01-12 | Crawford | Missouri | 29055 | 4478 | 83 |
2104152 | 2104152 | 2022-01-11 | Crawford | Missouri | 29055 | 4443 | 82 |
2100901 | 2100901 | 2022-01-10 | Crawford | Missouri | 29055 | 4406 | 80 |
2097650 | 2097650 | 2022-01-09 | Crawford | Missouri | 29055 | 4387 | 80 |
2094398 | 2094398 | 2022-01-08 | Crawford | Missouri | 29055 | 4383 | 80 |
2091146 | 2091146 | 2022-01-07 | Crawford | Missouri | 29055 | 4332 | 80 |
2087895 | 2087895 | 2022-01-06 | Crawford | Missouri | 29055 | 4286 | 80 |
2084643 | 2084643 | 2022-01-05 | Crawford | Missouri | 29055 | 4255 | 80 |
2081391 | 2081391 | 2022-01-04 | Crawford | Missouri | 29055 | 4215 | 80 |
2078139 | 2078139 | 2022-01-03 | Crawford | Missouri | 29055 | 4197 | 78 |
2074888 | 2074888 | 2022-01-02 | Crawford | Missouri | 29055 | 4140 | 78 |
2071637 | 2071637 | 2022-01-01 | Crawford | Missouri | 29055 | 4140 | 78 |
2068386 | 2068386 | 2021-12-31 | Crawford | Missouri | 29055 | 4140 | 78 |
2065135 | 2065135 | 2021-12-30 | Crawford | Missouri | 29055 | 4140 | 78 |
2061885 | 2061885 | 2021-12-29 | Crawford | Missouri | 29055 | 4130 | 78 |
2058636 | 2058636 | 2021-12-28 | Crawford | Missouri | 29055 | 4110 | 78 |
2055387 | 2055387 | 2021-12-27 | Crawford | Missouri | 29055 | 4104 | 78 |
2052137 | 2052137 | 2021-12-26 | Crawford | Missouri | 29055 | 4082 | 78 |
2048887 | 2048887 | 2021-12-25 | Crawford | Missouri | 29055 | 4082 | 78 |
2045637 | 2045637 | 2021-12-24 | Crawford | Missouri | 29055 | 4082 | 78 |
2042387 | 2042387 | 2021-12-23 | Crawford | Missouri | 29055 | 4082 | 78 |
2039138 | 2039138 | 2021-12-22 | Crawford | Missouri | 29055 | 4062 | 78 |
2035888 | 2035888 | 2021-12-21 | Crawford | Missouri | 29055 | 4044 | 78 |
2032638 | 2032638 | 2021-12-20 | Crawford | Missouri | 29055 | 4035 | 76 |
2029387 | 2029387 | 2021-12-19 | Crawford | Missouri | 29055 | 4028 | 76 |
2026136 | 2026136 | 2021-12-18 | Crawford | Missouri | 29055 | 4022 | 76 |
2022885 | 2022885 | 2021-12-17 | Crawford | Missouri | 29055 | 3997 | 76 |
2019634 | 2019634 | 2021-12-16 | Crawford | Missouri | 29055 | 3987 | 76 |
2016384 | 2016384 | 2021-12-15 | Crawford | Missouri | 29055 | 3969 | 76 |
2013133 | 2013133 | 2021-12-14 | Crawford | Missouri | 29055 | 3949 | 76 |
2009882 | 2009882 | 2021-12-13 | Crawford | Missouri | 29055 | 3941 | 76 |
2006631 | 2006631 | 2021-12-12 | Crawford | Missouri | 29055 | 3936 | 76 |
2003380 | 2003380 | 2021-12-11 | Crawford | Missouri | 29055 | 3928 | 76 |
2000130 | 2000130 | 2021-12-10 | Crawford | Missouri | 29055 | 3912 | 76 |
1996879 | 1996879 | 2021-12-09 | Crawford | Missouri | 29055 | 3890 | 76 |
1993628 | 1993628 | 2021-12-08 | Crawford | Missouri | 29055 | 3871 | 76 |
1990377 | 1990377 | 2021-12-07 | Crawford | Missouri | 29055 | 3858 | 75 |
1987127 | 1987127 | 2021-12-06 | Crawford | Missouri | 29055 | 3853 | 74 |
1983877 | 1983877 | 2021-12-05 | Crawford | Missouri | 29055 | 3844 | 74 |
1980627 | 1980627 | 2021-12-04 | Crawford | Missouri | 29055 | 3843 | 74 |
1977377 | 1977377 | 2021-12-03 | Crawford | Missouri | 29055 | 3825 | 74 |
1974127 | 1974127 | 2021-12-02 | Crawford | Missouri | 29055 | 3825 | 74 |
1970878 | 1970878 | 2021-12-01 | Crawford | Missouri | 29055 | 3809 | 74 |
1967628 | 1967628 | 2021-11-30 | Crawford | Missouri | 29055 | 3803 | 74 |
1964376 | 1964376 | 2021-11-29 | Crawford | Missouri | 29055 | 3793 | 74 |
1961125 | 1961125 | 2021-11-28 | Crawford | Missouri | 29055 | 3781 | 74 |
1957874 | 1957874 | 2021-11-27 | Crawford | Missouri | 29055 | 3781 | 74 |
1954623 | 1954623 | 2021-11-26 | Crawford | Missouri | 29055 | 3781 | 74 |
1951372 | 1951372 | 2021-11-25 | Crawford | Missouri | 29055 | 3781 | 74 |
1948121 | 1948121 | 2021-11-24 | Crawford | Missouri | 29055 | 3781 | 74 |
1944870 | 1944870 | 2021-11-23 | Crawford | Missouri | 29055 | 3778 | 74 |
1941619 | 1941619 | 2021-11-22 | Crawford | Missouri | 29055 | 3776 | 73 |
1938369 | 1938369 | 2021-11-21 | Crawford | Missouri | 29055 | 3774 | 73 |
1935119 | 1935119 | 2021-11-20 | Crawford | Missouri | 29055 | 3773 | 73 |
1931869 | 1931869 | 2021-11-19 | Crawford | Missouri | 29055 | 3768 | 73 |
1928618 | 1928618 | 2021-11-18 | Crawford | Missouri | 29055 | 3766 | 73 |
1925368 | 1925368 | 2021-11-17 | Crawford | Missouri | 29055 | 3719 | 62 |
1922119 | 1922119 | 2021-11-16 | Crawford | Missouri | 29055 | 3717 | 62 |
1918869 | 1918869 | 2021-11-15 | Crawford | Missouri | 29055 | 3711 | 61 |
1915619 | 1915619 | 2021-11-14 | Crawford | Missouri | 29055 | 3710 | 61 |
1912369 | 1912369 | 2021-11-13 | Crawford | Missouri | 29055 | 3704 | 61 |
1909119 | 1909119 | 2021-11-12 | Crawford | Missouri | 29055 | 3698 | 61 |
1905870 | 1905870 | 2021-11-11 | Crawford | Missouri | 29055 | 3684 | 61 |
1902621 | 1902621 | 2021-11-10 | Crawford | Missouri | 29055 | 3684 | 61 |
1899371 | 1899371 | 2021-11-09 | Crawford | Missouri | 29055 | 3672 | 61 |
1896121 | 1896121 | 2021-11-08 | Crawford | Missouri | 29055 | 3668 | 59 |
1892871 | 1892871 | 2021-11-07 | Crawford | Missouri | 29055 | 3668 | 59 |
1889621 | 1889621 | 2021-11-06 | Crawford | Missouri | 29055 | 3667 | 59 |
1886371 | 1886371 | 2021-11-05 | Crawford | Missouri | 29055 | 3658 | 59 |
1883122 | 1883122 | 2021-11-04 | Crawford | Missouri | 29055 | 3650 | 59 |
1879873 | 1879873 | 2021-11-03 | Crawford | Missouri | 29055 | 3644 | 59 |
1876624 | 1876624 | 2021-11-02 | Crawford | Missouri | 29055 | 3642 | 59 |
1873375 | 1873375 | 2021-11-01 | Crawford | Missouri | 29055 | 3638 | 57 |
1870126 | 1870126 | 2021-10-31 | Crawford | Missouri | 29055 | 3635 | 57 |
1866877 | 1866877 | 2021-10-30 | Crawford | Missouri | 29055 | 3634 | 57 |
1863628 | 1863628 | 2021-10-29 | Crawford | Missouri | 29055 | 3626 | 57 |
1860379 | 1860379 | 2021-10-28 | Crawford | Missouri | 29055 | 3620 | 57 |
1857130 | 1857130 | 2021-10-27 | Crawford | Missouri | 29055 | 3615 | 57 |
1853881 | 1853881 | 2021-10-26 | Crawford | Missouri | 29055 | 3605 | 57 |
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);