ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where deaths = 78 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305812 | 2305812 | 2022-03-14 | Henry | Missouri | 29083 | 5728 | 78 |
2302561 | 2302561 | 2022-03-13 | Henry | Missouri | 29083 | 5728 | 78 |
2299309 | 2299309 | 2022-03-12 | Henry | Missouri | 29083 | 5728 | 78 |
2296057 | 2296057 | 2022-03-11 | Henry | Missouri | 29083 | 5728 | 78 |
2292805 | 2292805 | 2022-03-10 | Henry | Missouri | 29083 | 5725 | 78 |
2289553 | 2289553 | 2022-03-09 | Henry | Missouri | 29083 | 5725 | 78 |
2286301 | 2286301 | 2022-03-08 | Henry | Missouri | 29083 | 5724 | 78 |
2283049 | 2283049 | 2022-03-07 | Henry | Missouri | 29083 | 5719 | 78 |
2279796 | 2279796 | 2022-03-06 | Henry | Missouri | 29083 | 5716 | 78 |
2276543 | 2276543 | 2022-03-05 | Henry | Missouri | 29083 | 5716 | 78 |
2273290 | 2273290 | 2022-03-04 | Henry | Missouri | 29083 | 5716 | 78 |
2270038 | 2270038 | 2022-03-03 | Henry | Missouri | 29083 | 5715 | 78 |
2266785 | 2266785 | 2022-03-02 | Henry | Missouri | 29083 | 5711 | 78 |
2263534 | 2263534 | 2022-03-01 | Henry | Missouri | 29083 | 5708 | 78 |
2260283 | 2260283 | 2022-02-28 | Henry | Missouri | 29083 | 5705 | 78 |
2257032 | 2257032 | 2022-02-27 | Henry | Missouri | 29083 | 5697 | 78 |
2253781 | 2253781 | 2022-02-26 | Henry | Missouri | 29083 | 5697 | 78 |
2250530 | 2250530 | 2022-02-25 | Henry | Missouri | 29083 | 5697 | 78 |
2247279 | 2247279 | 2022-02-24 | Henry | Missouri | 29083 | 5695 | 78 |
2136735 | 2136735 | 2022-01-21 | Ray | Missouri | 29177 | 4454 | 78 |
2133502 | 2133502 | 2022-01-20 | Texas | Missouri | 29215 | 4008 | 78 |
2126893 | 2126893 | 2022-01-18 | Benton | Missouri | 29015 | 3381 | 78 |
2123641 | 2123641 | 2022-01-17 | Benton | Missouri | 29015 | 3331 | 78 |
2120389 | 2120389 | 2022-01-16 | Benton | Missouri | 29015 | 3331 | 78 |
2117137 | 2117137 | 2022-01-15 | Benton | Missouri | 29015 | 3331 | 78 |
2113886 | 2113886 | 2022-01-14 | Benton | Missouri | 29015 | 3284 | 78 |
2110634 | 2110634 | 2022-01-13 | Benton | Missouri | 29015 | 3263 | 78 |
2107383 | 2107383 | 2022-01-12 | Benton | Missouri | 29015 | 3246 | 78 |
2104132 | 2104132 | 2022-01-11 | Benton | Missouri | 29015 | 3225 | 78 |
2104197 | 2104197 | 2022-01-11 | Morgan | Missouri | 29141 | 3229 | 78 |
2100958 | 2100958 | 2022-01-10 | Platte | Missouri | 29165 | 7917 | 78 |
2097707 | 2097707 | 2022-01-09 | Platte | Missouri | 29165 | 7880 | 78 |
2094455 | 2094455 | 2022-01-08 | Platte | Missouri | 29165 | 7856 | 78 |
2091203 | 2091203 | 2022-01-07 | Platte | Missouri | 29165 | 7765 | 78 |
2087952 | 2087952 | 2022-01-06 | Platte | Missouri | 29165 | 7685 | 78 |
2087979 | 2087979 | 2022-01-06 | Warren | Missouri | 29219 | 6360 | 78 |
2084700 | 2084700 | 2022-01-05 | Platte | Missouri | 29165 | 7591 | 78 |
2084727 | 2084727 | 2022-01-05 | Warren | Missouri | 29219 | 6278 | 78 |
2081448 | 2081448 | 2022-01-04 | Platte | Missouri | 29165 | 7500 | 78 |
2081475 | 2081475 | 2022-01-04 | Warren | Missouri | 29219 | 6193 | 78 |
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 |
1941702 | 1941702 | 2021-11-22 | Vernon | Missouri | 29217 | 3267 | 78 |
1938452 | 1938452 | 2021-11-21 | Vernon | Missouri | 29217 | 3266 | 78 |
1935202 | 1935202 | 2021-11-20 | Vernon | Missouri | 29217 | 3264 | 78 |
1931952 | 1931952 | 2021-11-19 | Vernon | Missouri | 29217 | 3257 | 78 |
1928701 | 1928701 | 2021-11-18 | Vernon | Missouri | 29217 | 3253 | 78 |
1925386 | 1925386 | 2021-11-17 | Howell | Missouri | 29091 | 5904 | 78 |
1922137 | 1922137 | 2021-11-16 | Howell | Missouri | 29091 | 5881 | 78 |
1918887 | 1918887 | 2021-11-15 | Howell | Missouri | 29091 | 5852 | 78 |
1915637 | 1915637 | 2021-11-14 | Howell | Missouri | 29091 | 5849 | 78 |
1912387 | 1912387 | 2021-11-13 | Howell | Missouri | 29091 | 5843 | 78 |
1909137 | 1909137 | 2021-11-12 | Howell | Missouri | 29091 | 5832 | 78 |
1905888 | 1905888 | 2021-11-11 | Howell | Missouri | 29091 | 5799 | 78 |
1902639 | 1902639 | 2021-11-10 | Howell | Missouri | 29091 | 5799 | 78 |
1899389 | 1899389 | 2021-11-09 | Howell | Missouri | 29091 | 5797 | 78 |
1896139 | 1896139 | 2021-11-08 | Howell | Missouri | 29091 | 5782 | 78 |
1892889 | 1892889 | 2021-11-07 | Howell | Missouri | 29091 | 5777 | 78 |
1889639 | 1889639 | 2021-11-06 | Howell | Missouri | 29091 | 5777 | 78 |
1886389 | 1886389 | 2021-11-05 | Howell | Missouri | 29091 | 5769 | 78 |
1883140 | 1883140 | 2021-11-04 | Howell | Missouri | 29091 | 5762 | 78 |
1879891 | 1879891 | 2021-11-03 | Howell | Missouri | 29091 | 5757 | 78 |
1827945 | 1827945 | 2021-10-18 | Pulaski | Missouri | 29169 | 5128 | 78 |
1824696 | 1824696 | 2021-10-17 | Pulaski | Missouri | 29169 | 5126 | 78 |
1821447 | 1821447 | 2021-10-16 | Pulaski | Missouri | 29169 | 5114 | 78 |
1759733 | 1759733 | 2021-09-27 | Stone | Missouri | 29209 | 3823 | 78 |
1756485 | 1756485 | 2021-09-26 | Stone | Missouri | 29209 | 3821 | 78 |
1753237 | 1753237 | 2021-09-25 | Stone | Missouri | 29209 | 3817 | 78 |
1749989 | 1749989 | 2021-09-24 | Stone | Missouri | 29209 | 3809 | 78 |
1746739 | 1746739 | 2021-09-23 | Stone | Missouri | 29209 | 3795 | 78 |
1743490 | 1743490 | 2021-09-22 | Stone | Missouri | 29209 | 3778 | 78 |
1740241 | 1740241 | 2021-09-21 | Stone | Missouri | 29209 | 3773 | 78 |
1646042 | 1646042 | 2021-08-23 | Webster | Missouri | 29225 | 5121 | 78 |
1642793 | 1642793 | 2021-08-22 | Webster | Missouri | 29225 | 5118 | 78 |
1639543 | 1639543 | 2021-08-21 | Webster | Missouri | 29225 | 5112 | 78 |
1636293 | 1636293 | 2021-08-20 | Webster | Missouri | 29225 | 5109 | 78 |
1633043 | 1633043 | 2021-08-19 | Webster | Missouri | 29225 | 5102 | 78 |
1629796 | 1629796 | 2021-08-18 | Webster | Missouri | 29225 | 5083 | 78 |
1626549 | 1626549 | 2021-08-17 | Webster | Missouri | 29225 | 5061 | 78 |
1538816 | 1538816 | 2021-07-21 | Pettis | Missouri | 29159 | 5515 | 78 |
1516057 | 1516057 | 2021-07-14 | Laclede | Missouri | 29105 | 3939 | 78 |
1512811 | 1512811 | 2021-07-13 | Laclede | Missouri | 29105 | 3922 | 78 |
1353787 | 1353787 | 2021-05-25 | Newton | Missouri | 29145 | 5387 | 78 |
1350541 | 1350541 | 2021-05-24 | Newton | Missouri | 29145 | 5373 | 78 |
1347295 | 1347295 | 2021-05-23 | Newton | Missouri | 29145 | 5373 | 78 |
1344047 | 1344047 | 2021-05-22 | Newton | Missouri | 29145 | 5372 | 78 |
1340798 | 1340798 | 2021-05-21 | Newton | Missouri | 29145 | 5363 | 78 |
1337551 | 1337551 | 2021-05-20 | Newton | Missouri | 29145 | 5354 | 78 |
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);