ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Morgan" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175765 | 2175765 | 2022-02-02 | Morgan | Missouri | 29141 | 3847 | 93 |
2172512 | 2172512 | 2022-02-01 | Morgan | Missouri | 29141 | 3829 | 93 |
2169259 | 2169259 | 2022-01-31 | Morgan | Missouri | 29141 | 3814 | 85 |
2166004 | 2166004 | 2022-01-30 | Morgan | Missouri | 29141 | 3803 | 85 |
2162749 | 2162749 | 2022-01-29 | Morgan | Missouri | 29141 | 3798 | 85 |
2159494 | 2159494 | 2022-01-28 | Morgan | Missouri | 29141 | 3786 | 85 |
2156240 | 2156240 | 2022-01-27 | Morgan | Missouri | 29141 | 3752 | 85 |
2152987 | 2152987 | 2022-01-26 | Morgan | Missouri | 29141 | 3710 | 85 |
2149735 | 2149735 | 2022-01-25 | Morgan | Missouri | 29141 | 3673 | 85 |
2146483 | 2146483 | 2022-01-24 | Morgan | Missouri | 29141 | 3640 | 84 |
2143228 | 2143228 | 2022-01-23 | Morgan | Missouri | 29141 | 3636 | 84 |
2139973 | 2139973 | 2022-01-22 | Morgan | Missouri | 29141 | 3620 | 84 |
2136717 | 2136717 | 2022-01-21 | Morgan | Missouri | 29141 | 3590 | 84 |
2133465 | 2133465 | 2022-01-20 | Morgan | Missouri | 29141 | 3567 | 80 |
2130212 | 2130212 | 2022-01-19 | Morgan | Missouri | 29141 | 3506 | 80 |
2126958 | 2126958 | 2022-01-18 | Morgan | Missouri | 29141 | 3452 | 79 |
2123706 | 2123706 | 2022-01-17 | Morgan | Missouri | 29141 | 3362 | 79 |
2120454 | 2120454 | 2022-01-16 | Morgan | Missouri | 29141 | 3362 | 79 |
2117202 | 2117202 | 2022-01-15 | Morgan | Missouri | 29141 | 3362 | 79 |
2113951 | 2113951 | 2022-01-14 | Morgan | Missouri | 29141 | 3317 | 79 |
2110699 | 2110699 | 2022-01-13 | Morgan | Missouri | 29141 | 3297 | 79 |
2107448 | 2107448 | 2022-01-12 | Morgan | Missouri | 29141 | 3270 | 79 |
2104197 | 2104197 | 2022-01-11 | Morgan | Missouri | 29141 | 3229 | 78 |
2100946 | 2100946 | 2022-01-10 | Morgan | Missouri | 29141 | 3204 | 76 |
2097695 | 2097695 | 2022-01-09 | Morgan | Missouri | 29141 | 3192 | 76 |
2094443 | 2094443 | 2022-01-08 | Morgan | Missouri | 29141 | 3189 | 76 |
2091191 | 2091191 | 2022-01-07 | Morgan | Missouri | 29141 | 3163 | 76 |
2087940 | 2087940 | 2022-01-06 | Morgan | Missouri | 29141 | 3145 | 75 |
2084688 | 2084688 | 2022-01-05 | Morgan | Missouri | 29141 | 3131 | 75 |
2081436 | 2081436 | 2022-01-04 | Morgan | Missouri | 29141 | 3113 | 75 |
2078184 | 2078184 | 2022-01-03 | Morgan | Missouri | 29141 | 3098 | 75 |
2074933 | 2074933 | 2022-01-02 | Morgan | Missouri | 29141 | 3090 | 75 |
2071682 | 2071682 | 2022-01-01 | Morgan | Missouri | 29141 | 3090 | 75 |
2068431 | 2068431 | 2021-12-31 | Morgan | Missouri | 29141 | 3090 | 75 |
2065180 | 2065180 | 2021-12-30 | Morgan | Missouri | 29141 | 3090 | 75 |
2061930 | 2061930 | 2021-12-29 | Morgan | Missouri | 29141 | 3073 | 75 |
2058681 | 2058681 | 2021-12-28 | Morgan | Missouri | 29141 | 3062 | 75 |
2055432 | 2055432 | 2021-12-27 | Morgan | Missouri | 29141 | 3041 | 75 |
2052182 | 2052182 | 2021-12-26 | Morgan | Missouri | 29141 | 3024 | 75 |
2048932 | 2048932 | 2021-12-25 | Morgan | Missouri | 29141 | 3024 | 75 |
2045682 | 2045682 | 2021-12-24 | Morgan | Missouri | 29141 | 3024 | 75 |
2042432 | 2042432 | 2021-12-23 | Morgan | Missouri | 29141 | 3024 | 75 |
2039183 | 2039183 | 2021-12-22 | Morgan | Missouri | 29141 | 3005 | 75 |
2035933 | 2035933 | 2021-12-21 | Morgan | Missouri | 29141 | 2993 | 75 |
2032683 | 2032683 | 2021-12-20 | Morgan | Missouri | 29141 | 2981 | 75 |
2029432 | 2029432 | 2021-12-19 | Morgan | Missouri | 29141 | 2974 | 75 |
2026181 | 2026181 | 2021-12-18 | Morgan | Missouri | 29141 | 2971 | 75 |
2022930 | 2022930 | 2021-12-17 | Morgan | Missouri | 29141 | 2963 | 75 |
2019679 | 2019679 | 2021-12-16 | Morgan | Missouri | 29141 | 2952 | 75 |
2016429 | 2016429 | 2021-12-15 | Morgan | Missouri | 29141 | 2935 | 74 |
2013178 | 2013178 | 2021-12-14 | Morgan | Missouri | 29141 | 2917 | 74 |
2009927 | 2009927 | 2021-12-13 | Morgan | Missouri | 29141 | 2893 | 73 |
2006676 | 2006676 | 2021-12-12 | Morgan | Missouri | 29141 | 2882 | 73 |
2003425 | 2003425 | 2021-12-11 | Morgan | Missouri | 29141 | 2876 | 73 |
2000175 | 2000175 | 2021-12-10 | Morgan | Missouri | 29141 | 2873 | 73 |
1996924 | 1996924 | 2021-12-09 | Morgan | Missouri | 29141 | 2864 | 73 |
1993673 | 1993673 | 2021-12-08 | Morgan | Missouri | 29141 | 2846 | 73 |
1990422 | 1990422 | 2021-12-07 | Morgan | Missouri | 29141 | 2835 | 73 |
1987172 | 1987172 | 2021-12-06 | Morgan | Missouri | 29141 | 2827 | 73 |
1983922 | 1983922 | 2021-12-05 | Morgan | Missouri | 29141 | 2815 | 73 |
1980672 | 1980672 | 2021-12-04 | Morgan | Missouri | 29141 | 2804 | 73 |
1977422 | 1977422 | 2021-12-03 | Morgan | Missouri | 29141 | 2788 | 73 |
1974172 | 1974172 | 2021-12-02 | Morgan | Missouri | 29141 | 2788 | 73 |
1970923 | 1970923 | 2021-12-01 | Morgan | Missouri | 29141 | 2778 | 73 |
1967673 | 1967673 | 2021-11-30 | Morgan | Missouri | 29141 | 2769 | 73 |
1964421 | 1964421 | 2021-11-29 | Morgan | Missouri | 29141 | 2766 | 72 |
1961170 | 1961170 | 2021-11-28 | Morgan | Missouri | 29141 | 2744 | 72 |
1957919 | 1957919 | 2021-11-27 | Morgan | Missouri | 29141 | 2744 | 72 |
1954668 | 1954668 | 2021-11-26 | Morgan | Missouri | 29141 | 2744 | 72 |
1951417 | 1951417 | 2021-11-25 | Morgan | Missouri | 29141 | 2744 | 72 |
1948166 | 1948166 | 2021-11-24 | Morgan | Missouri | 29141 | 2744 | 72 |
1944915 | 1944915 | 2021-11-23 | Morgan | Missouri | 29141 | 2741 | 72 |
1941664 | 1941664 | 2021-11-22 | Morgan | Missouri | 29141 | 2738 | 71 |
1938414 | 1938414 | 2021-11-21 | Morgan | Missouri | 29141 | 2736 | 71 |
1935164 | 1935164 | 2021-11-20 | Morgan | Missouri | 29141 | 2736 | 71 |
1931914 | 1931914 | 2021-11-19 | Morgan | Missouri | 29141 | 2730 | 71 |
1928663 | 1928663 | 2021-11-18 | Morgan | Missouri | 29141 | 2721 | 71 |
1925413 | 1925413 | 2021-11-17 | Morgan | Missouri | 29141 | 2699 | 59 |
1922164 | 1922164 | 2021-11-16 | Morgan | Missouri | 29141 | 2693 | 59 |
1918914 | 1918914 | 2021-11-15 | Morgan | Missouri | 29141 | 2688 | 59 |
1915664 | 1915664 | 2021-11-14 | Morgan | Missouri | 29141 | 2687 | 59 |
1912414 | 1912414 | 2021-11-13 | Morgan | Missouri | 29141 | 2686 | 59 |
1909164 | 1909164 | 2021-11-12 | Morgan | Missouri | 29141 | 2685 | 59 |
1905915 | 1905915 | 2021-11-11 | Morgan | Missouri | 29141 | 2672 | 59 |
1902666 | 1902666 | 2021-11-10 | Morgan | Missouri | 29141 | 2672 | 59 |
1899416 | 1899416 | 2021-11-09 | Morgan | Missouri | 29141 | 2667 | 59 |
1896166 | 1896166 | 2021-11-08 | Morgan | Missouri | 29141 | 2665 | 59 |
1892916 | 1892916 | 2021-11-07 | Morgan | Missouri | 29141 | 2665 | 59 |
1889666 | 1889666 | 2021-11-06 | Morgan | Missouri | 29141 | 2664 | 59 |
1886416 | 1886416 | 2021-11-05 | Morgan | Missouri | 29141 | 2661 | 58 |
1883167 | 1883167 | 2021-11-04 | Morgan | Missouri | 29141 | 2655 | 58 |
1879918 | 1879918 | 2021-11-03 | Morgan | Missouri | 29141 | 2655 | 58 |
1876669 | 1876669 | 2021-11-02 | Morgan | Missouri | 29141 | 2650 | 58 |
1873420 | 1873420 | 2021-11-01 | Morgan | Missouri | 29141 | 2628 | 58 |
1870171 | 1870171 | 2021-10-31 | Morgan | Missouri | 29141 | 2626 | 58 |
1866922 | 1866922 | 2021-10-30 | Morgan | Missouri | 29141 | 2625 | 58 |
1863673 | 1863673 | 2021-10-29 | Morgan | Missouri | 29141 | 2623 | 58 |
1860424 | 1860424 | 2021-10-28 | Morgan | Missouri | 29141 | 2622 | 58 |
1857175 | 1857175 | 2021-10-27 | Morgan | Missouri | 29141 | 2620 | 58 |
1853926 | 1853926 | 2021-10-26 | Morgan | Missouri | 29141 | 2617 | 58 |
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);