ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
164 rows where deaths = 81 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471788 | 2471788 | 2022-05-04 | Dent | Missouri | 29065 | 3261 | 81 |
2468532 | 2468532 | 2022-05-03 | Dent | Missouri | 29065 | 3261 | 81 |
2465276 | 2465276 | 2022-05-02 | Dent | Missouri | 29065 | 3261 | 81 |
2462021 | 2462021 | 2022-05-01 | Dent | Missouri | 29065 | 3261 | 81 |
2458765 | 2458765 | 2022-04-30 | Dent | Missouri | 29065 | 3261 | 81 |
2455509 | 2455509 | 2022-04-29 | Dent | Missouri | 29065 | 3261 | 81 |
2452253 | 2452253 | 2022-04-28 | Dent | Missouri | 29065 | 3261 | 81 |
2448997 | 2448997 | 2022-04-27 | Dent | Missouri | 29065 | 3261 | 81 |
2445740 | 2445740 | 2022-04-26 | Dent | Missouri | 29065 | 3261 | 81 |
2442485 | 2442485 | 2022-04-25 | Dent | Missouri | 29065 | 3261 | 81 |
2439229 | 2439229 | 2022-04-24 | Dent | Missouri | 29065 | 3261 | 81 |
2435973 | 2435973 | 2022-04-23 | Dent | Missouri | 29065 | 3261 | 81 |
2432717 | 2432717 | 2022-04-22 | Dent | Missouri | 29065 | 3261 | 81 |
2429461 | 2429461 | 2022-04-21 | Dent | Missouri | 29065 | 3261 | 81 |
2426205 | 2426205 | 2022-04-20 | Dent | Missouri | 29065 | 3261 | 81 |
2422949 | 2422949 | 2022-04-19 | Dent | Missouri | 29065 | 3261 | 81 |
2419692 | 2419692 | 2022-04-18 | Dent | Missouri | 29065 | 3261 | 81 |
2416437 | 2416437 | 2022-04-17 | Dent | Missouri | 29065 | 3261 | 81 |
2413181 | 2413181 | 2022-04-16 | Dent | Missouri | 29065 | 3261 | 81 |
2409925 | 2409925 | 2022-04-15 | Dent | Missouri | 29065 | 3261 | 81 |
2406669 | 2406669 | 2022-04-14 | Dent | Missouri | 29065 | 3261 | 81 |
2403413 | 2403413 | 2022-04-13 | Dent | Missouri | 29065 | 3261 | 81 |
2400158 | 2400158 | 2022-04-12 | Dent | Missouri | 29065 | 3261 | 81 |
2396903 | 2396903 | 2022-04-11 | Dent | Missouri | 29065 | 3261 | 81 |
2393648 | 2393648 | 2022-04-10 | Dent | Missouri | 29065 | 3261 | 81 |
2390392 | 2390392 | 2022-04-09 | Dent | Missouri | 29065 | 3261 | 81 |
2387136 | 2387136 | 2022-04-08 | Dent | Missouri | 29065 | 3261 | 81 |
2383881 | 2383881 | 2022-04-07 | Dent | Missouri | 29065 | 3261 | 81 |
2380626 | 2380626 | 2022-04-06 | Dent | Missouri | 29065 | 3261 | 81 |
2377371 | 2377371 | 2022-04-05 | Dent | Missouri | 29065 | 3261 | 81 |
2374118 | 2374118 | 2022-04-04 | Dent | Missouri | 29065 | 3261 | 81 |
2370866 | 2370866 | 2022-04-03 | Dent | Missouri | 29065 | 3261 | 81 |
2367613 | 2367613 | 2022-04-02 | Dent | Missouri | 29065 | 3261 | 81 |
2364360 | 2364360 | 2022-04-01 | Dent | Missouri | 29065 | 3261 | 81 |
2361106 | 2361106 | 2022-03-31 | Dent | Missouri | 29065 | 3261 | 81 |
2357852 | 2357852 | 2022-03-30 | Dent | Missouri | 29065 | 3260 | 81 |
2354599 | 2354599 | 2022-03-29 | Dent | Missouri | 29065 | 3260 | 81 |
2270070 | 2270070 | 2022-03-03 | New Madrid | Missouri | 29143 | 5004 | 81 |
2266817 | 2266817 | 2022-03-02 | New Madrid | Missouri | 29143 | 5002 | 81 |
2263566 | 2263566 | 2022-03-01 | New Madrid | Missouri | 29143 | 5001 | 81 |
2211585 | 2211585 | 2022-02-13 | Texas | Missouri | 29215 | 4531 | 81 |
2208332 | 2208332 | 2022-02-12 | Texas | Missouri | 29215 | 4531 | 81 |
2205079 | 2205079 | 2022-02-11 | Texas | Missouri | 29215 | 4531 | 81 |
2201826 | 2201826 | 2022-02-10 | Texas | Missouri | 29215 | 4530 | 81 |
2198572 | 2198572 | 2022-02-09 | Texas | Missouri | 29215 | 4458 | 81 |
2195318 | 2195318 | 2022-02-08 | Texas | Missouri | 29215 | 4444 | 81 |
2166022 | 2166022 | 2022-01-30 | Ray | Missouri | 29177 | 4777 | 81 |
2162767 | 2162767 | 2022-01-29 | Ray | Missouri | 29177 | 4764 | 81 |
2159512 | 2159512 | 2022-01-28 | Ray | Missouri | 29177 | 4722 | 81 |
2156258 | 2156258 | 2022-01-27 | Ray | Missouri | 29177 | 4630 | 81 |
2153005 | 2153005 | 2022-01-26 | Ray | Missouri | 29177 | 4600 | 81 |
2149753 | 2149753 | 2022-01-25 | Ray | Missouri | 29177 | 4572 | 81 |
2146501 | 2146501 | 2022-01-24 | Ray | Missouri | 29177 | 4546 | 81 |
2104209 | 2104209 | 2022-01-11 | Platte | Missouri | 29165 | 8015 | 81 |
2100934 | 2100934 | 2022-01-10 | Livingston | Missouri | 29117 | 2983 | 81 |
2097683 | 2097683 | 2022-01-09 | Livingston | Missouri | 29117 | 2979 | 81 |
2094431 | 2094431 | 2022-01-08 | Livingston | Missouri | 29117 | 2975 | 81 |
2091179 | 2091179 | 2022-01-07 | Livingston | Missouri | 29117 | 2956 | 81 |
2087928 | 2087928 | 2022-01-06 | Livingston | Missouri | 29117 | 2930 | 81 |
2084676 | 2084676 | 2022-01-05 | Livingston | Missouri | 29117 | 2914 | 81 |
2081424 | 2081424 | 2022-01-04 | Livingston | Missouri | 29117 | 2896 | 81 |
2078172 | 2078172 | 2022-01-03 | Livingston | Missouri | 29117 | 2885 | 81 |
2074921 | 2074921 | 2022-01-02 | Livingston | Missouri | 29117 | 2856 | 81 |
2071670 | 2071670 | 2022-01-01 | Livingston | Missouri | 29117 | 2856 | 81 |
2068419 | 2068419 | 2021-12-31 | Livingston | Missouri | 29117 | 2856 | 81 |
2065168 | 2065168 | 2021-12-30 | Livingston | Missouri | 29117 | 2856 | 81 |
2061918 | 2061918 | 2021-12-29 | Livingston | Missouri | 29117 | 2832 | 81 |
2058669 | 2058669 | 2021-12-28 | Livingston | Missouri | 29117 | 2804 | 81 |
2055445 | 2055445 | 2021-12-27 | Polk | Missouri | 29167 | 5809 | 81 |
2052195 | 2052195 | 2021-12-26 | Polk | Missouri | 29167 | 5754 | 81 |
2048945 | 2048945 | 2021-12-25 | Polk | Missouri | 29167 | 5754 | 81 |
2045695 | 2045695 | 2021-12-24 | Polk | Missouri | 29167 | 5754 | 81 |
2042445 | 2042445 | 2021-12-23 | Polk | Missouri | 29167 | 5754 | 81 |
2039196 | 2039196 | 2021-12-22 | Polk | Missouri | 29167 | 5731 | 81 |
2035946 | 2035946 | 2021-12-21 | Polk | Missouri | 29167 | 5707 | 81 |
2032614 | 2032614 | 2021-12-20 | Audrain | Missouri | 29007 | 4346 | 81 |
2032696 | 2032696 | 2021-12-20 | Polk | Missouri | 29167 | 5682 | 81 |
2029363 | 2029363 | 2021-12-19 | Audrain | Missouri | 29007 | 4340 | 81 |
2029445 | 2029445 | 2021-12-19 | Polk | Missouri | 29167 | 5679 | 81 |
2026112 | 2026112 | 2021-12-18 | Audrain | Missouri | 29007 | 4326 | 81 |
2026194 | 2026194 | 2021-12-18 | Polk | Missouri | 29167 | 5677 | 81 |
2022861 | 2022861 | 2021-12-17 | Audrain | Missouri | 29007 | 4318 | 81 |
2019610 | 2019610 | 2021-12-16 | Audrain | Missouri | 29007 | 4309 | 81 |
2016360 | 2016360 | 2021-12-15 | Audrain | Missouri | 29007 | 4293 | 81 |
2013109 | 2013109 | 2021-12-14 | Audrain | Missouri | 29007 | 4282 | 81 |
2013195 | 2013195 | 2021-12-14 | Randolph | Missouri | 29175 | 4077 | 81 |
2009891 | 2009891 | 2021-12-13 | Gasconade | Missouri | 29073 | 2469 | 81 |
2006640 | 2006640 | 2021-12-12 | Gasconade | Missouri | 29073 | 2469 | 81 |
2003389 | 2003389 | 2021-12-11 | Gasconade | Missouri | 29073 | 2467 | 81 |
2000139 | 2000139 | 2021-12-10 | Gasconade | Missouri | 29073 | 2464 | 81 |
1996888 | 1996888 | 2021-12-09 | Gasconade | Missouri | 29073 | 2459 | 81 |
1961208 | 1961208 | 2021-11-28 | Vernon | Missouri | 29217 | 3279 | 81 |
1957957 | 1957957 | 2021-11-27 | Vernon | Missouri | 29217 | 3279 | 81 |
1954706 | 1954706 | 2021-11-26 | Vernon | Missouri | 29217 | 3279 | 81 |
1951455 | 1951455 | 2021-11-25 | Vernon | Missouri | 29217 | 3279 | 81 |
1948204 | 1948204 | 2021-11-24 | Vernon | Missouri | 29217 | 3279 | 81 |
1944953 | 1944953 | 2021-11-23 | Vernon | Missouri | 29217 | 3271 | 81 |
1938435 | 1938435 | 2021-11-21 | Saline | Missouri | 29195 | 4225 | 81 |
1935185 | 1935185 | 2021-11-20 | Saline | Missouri | 29195 | 4217 | 81 |
1931935 | 1931935 | 2021-11-19 | Saline | Missouri | 29195 | 4216 | 81 |
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);