ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where deaths = 108 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501161 | 2501161 | 2022-05-13 | Polk | Missouri | 29167 | 8073 | 108 |
2497903 | 2497903 | 2022-05-12 | Polk | Missouri | 29167 | 8064 | 108 |
2494645 | 2494645 | 2022-05-11 | Polk | Missouri | 29167 | 8064 | 108 |
2491387 | 2491387 | 2022-05-10 | Polk | Missouri | 29167 | 8064 | 108 |
2488129 | 2488129 | 2022-05-09 | Polk | Missouri | 29167 | 8064 | 108 |
2484872 | 2484872 | 2022-05-08 | Polk | Missouri | 29167 | 8064 | 108 |
2481614 | 2481614 | 2022-05-07 | Polk | Missouri | 29167 | 8064 | 108 |
2478356 | 2478356 | 2022-05-06 | Polk | Missouri | 29167 | 8064 | 108 |
2475098 | 2475098 | 2022-05-05 | Polk | Missouri | 29167 | 8051 | 108 |
2471841 | 2471841 | 2022-05-04 | Polk | Missouri | 29167 | 8040 | 108 |
2468585 | 2468585 | 2022-05-03 | Polk | Missouri | 29167 | 8040 | 108 |
2465329 | 2465329 | 2022-05-02 | Polk | Missouri | 29167 | 8040 | 108 |
2462074 | 2462074 | 2022-05-01 | Polk | Missouri | 29167 | 8040 | 108 |
2458818 | 2458818 | 2022-04-30 | Polk | Missouri | 29167 | 8040 | 108 |
2455562 | 2455562 | 2022-04-29 | Polk | Missouri | 29167 | 8040 | 108 |
2452306 | 2452306 | 2022-04-28 | Polk | Missouri | 29167 | 8040 | 108 |
2449050 | 2449050 | 2022-04-27 | Polk | Missouri | 29167 | 8040 | 108 |
2445793 | 2445793 | 2022-04-26 | Polk | Missouri | 29167 | 8040 | 108 |
2442538 | 2442538 | 2022-04-25 | Polk | Missouri | 29167 | 8040 | 108 |
2439282 | 2439282 | 2022-04-24 | Polk | Missouri | 29167 | 8040 | 108 |
2436026 | 2436026 | 2022-04-23 | Polk | Missouri | 29167 | 8040 | 108 |
2432770 | 2432770 | 2022-04-22 | Polk | Missouri | 29167 | 8040 | 108 |
2429514 | 2429514 | 2022-04-21 | Polk | Missouri | 29167 | 8040 | 108 |
2426258 | 2426258 | 2022-04-20 | Polk | Missouri | 29167 | 8040 | 108 |
2423002 | 2423002 | 2022-04-19 | Polk | Missouri | 29167 | 8040 | 108 |
2419745 | 2419745 | 2022-04-18 | Polk | Missouri | 29167 | 8040 | 108 |
2416490 | 2416490 | 2022-04-17 | Polk | Missouri | 29167 | 8040 | 108 |
2413234 | 2413234 | 2022-04-16 | Polk | Missouri | 29167 | 8040 | 108 |
2409978 | 2409978 | 2022-04-15 | Polk | Missouri | 29167 | 8040 | 108 |
2406722 | 2406722 | 2022-04-14 | Polk | Missouri | 29167 | 8040 | 108 |
2403466 | 2403466 | 2022-04-13 | Polk | Missouri | 29167 | 8040 | 108 |
2400211 | 2400211 | 2022-04-12 | Polk | Missouri | 29167 | 8040 | 108 |
2396956 | 2396956 | 2022-04-11 | Polk | Missouri | 29167 | 8040 | 108 |
2393701 | 2393701 | 2022-04-10 | Polk | Missouri | 29167 | 8040 | 108 |
2390445 | 2390445 | 2022-04-09 | Polk | Missouri | 29167 | 8040 | 108 |
2387189 | 2387189 | 2022-04-08 | Polk | Missouri | 29167 | 8040 | 108 |
2383934 | 2383934 | 2022-04-07 | Polk | Missouri | 29167 | 8040 | 108 |
2380679 | 2380679 | 2022-04-06 | Polk | Missouri | 29167 | 8040 | 108 |
2377424 | 2377424 | 2022-04-05 | Polk | Missouri | 29167 | 8040 | 108 |
2374171 | 2374171 | 2022-04-04 | Polk | Missouri | 29167 | 8040 | 108 |
2370919 | 2370919 | 2022-04-03 | Polk | Missouri | 29167 | 8040 | 108 |
2367666 | 2367666 | 2022-04-02 | Polk | Missouri | 29167 | 8040 | 108 |
2364413 | 2364413 | 2022-04-01 | Polk | Missouri | 29167 | 8040 | 108 |
2361159 | 2361159 | 2022-03-31 | Polk | Missouri | 29167 | 8040 | 108 |
2357905 | 2357905 | 2022-03-30 | Polk | Missouri | 29167 | 8033 | 108 |
2354652 | 2354652 | 2022-03-29 | Polk | Missouri | 29167 | 8030 | 108 |
2354677 | 2354677 | 2022-03-29 | Vernon | Missouri | 29217 | 5045 | 108 |
2260276 | 2260276 | 2022-02-28 | Dunklin | Missouri | 29069 | 7058 | 108 |
2257025 | 2257025 | 2022-02-27 | Dunklin | Missouri | 29069 | 7035 | 108 |
2253774 | 2253774 | 2022-02-26 | Dunklin | Missouri | 29069 | 7035 | 108 |
2250523 | 2250523 | 2022-02-25 | Dunklin | Missouri | 29069 | 7035 | 108 |
2247272 | 2247272 | 2022-02-24 | Dunklin | Missouri | 29069 | 7034 | 108 |
2244093 | 2244093 | 2022-02-23 | Stone | Missouri | 29209 | 5717 | 108 |
2240842 | 2240842 | 2022-02-22 | Stone | Missouri | 29209 | 5714 | 108 |
2237591 | 2237591 | 2022-02-21 | Stone | Missouri | 29209 | 5692 | 108 |
2234340 | 2234340 | 2022-02-20 | Stone | Missouri | 29209 | 5692 | 108 |
2231089 | 2231089 | 2022-02-19 | Stone | Missouri | 29209 | 5692 | 108 |
2227838 | 2227838 | 2022-02-18 | Stone | Missouri | 29209 | 5692 | 108 |
2224587 | 2224587 | 2022-02-17 | Stone | Missouri | 29209 | 5688 | 108 |
2214834 | 2214834 | 2022-02-14 | Stone | Missouri | 29209 | 5667 | 108 |
2211582 | 2211582 | 2022-02-13 | Stone | Missouri | 29209 | 5627 | 108 |
2208329 | 2208329 | 2022-02-12 | Stone | Missouri | 29209 | 5627 | 108 |
2205076 | 2205076 | 2022-02-11 | Stone | Missouri | 29209 | 5627 | 108 |
2201823 | 2201823 | 2022-02-10 | Stone | Missouri | 29209 | 5627 | 108 |
2198476 | 2198476 | 2022-02-09 | Callaway | Missouri | 29027 | 11667 | 108 |
2198569 | 2198569 | 2022-02-09 | Stone | Missouri | 29209 | 5603 | 108 |
2195222 | 2195222 | 2022-02-08 | Callaway | Missouri | 29027 | 11514 | 108 |
2195315 | 2195315 | 2022-02-08 | Stone | Missouri | 29209 | 5597 | 108 |
2182221 | 2182221 | 2022-02-04 | Clinton | Missouri | 29049 | 4483 | 108 |
2178969 | 2178969 | 2022-02-03 | Clinton | Missouri | 29049 | 4476 | 108 |
2175717 | 2175717 | 2022-02-02 | Clinton | Missouri | 29049 | 4460 | 108 |
2172464 | 2172464 | 2022-02-01 | Clinton | Missouri | 29049 | 4430 | 108 |
2152970 | 2152970 | 2022-01-26 | Lafayette | Missouri | 29107 | 7140 | 108 |
2032716 | 2032716 | 2021-12-20 | Stoddard | Missouri | 29207 | 4770 | 108 |
2029465 | 2029465 | 2021-12-19 | Stoddard | Missouri | 29207 | 4767 | 108 |
2026214 | 2026214 | 2021-12-18 | Stoddard | Missouri | 29207 | 4765 | 108 |
2022963 | 2022963 | 2021-12-17 | Stoddard | Missouri | 29207 | 4762 | 108 |
2019712 | 2019712 | 2021-12-16 | Stoddard | Missouri | 29207 | 4758 | 108 |
2016462 | 2016462 | 2021-12-15 | Stoddard | Missouri | 29207 | 4755 | 108 |
1987150 | 1987150 | 2021-12-06 | Johnson | Missouri | 29101 | 7980 | 108 |
1983900 | 1983900 | 2021-12-05 | Johnson | Missouri | 29101 | 7936 | 108 |
1980650 | 1980650 | 2021-12-04 | Johnson | Missouri | 29101 | 7924 | 108 |
1977400 | 1977400 | 2021-12-03 | Johnson | Missouri | 29101 | 7870 | 108 |
1974150 | 1974150 | 2021-12-02 | Johnson | Missouri | 29101 | 7870 | 108 |
1970901 | 1970901 | 2021-12-01 | Johnson | Missouri | 29101 | 7824 | 108 |
1967651 | 1967651 | 2021-11-30 | Johnson | Missouri | 29101 | 7799 | 108 |
1964399 | 1964399 | 2021-11-29 | Johnson | Missouri | 29101 | 7777 | 108 |
1961148 | 1961148 | 2021-11-28 | Johnson | Missouri | 29101 | 7699 | 108 |
1957897 | 1957897 | 2021-11-27 | Johnson | Missouri | 29101 | 7699 | 108 |
1954646 | 1954646 | 2021-11-26 | Johnson | Missouri | 29101 | 7699 | 108 |
1951395 | 1951395 | 2021-11-25 | Johnson | Missouri | 29101 | 7699 | 108 |
1948144 | 1948144 | 2021-11-24 | Johnson | Missouri | 29101 | 7699 | 108 |
1944893 | 1944893 | 2021-11-23 | Johnson | Missouri | 29101 | 7679 | 108 |
1931892 | 1931892 | 2021-11-19 | Johnson | Missouri | 29101 | 7614 | 108 |
1746729 | 1746729 | 2021-09-23 | Scott | Missouri | 29201 | 6796 | 108 |
1694729 | 1694729 | 2021-09-07 | Newton | Missouri | 29145 | 7343 | 108 |
1691480 | 1691480 | 2021-09-06 | Newton | Missouri | 29145 | 7342 | 108 |
1688230 | 1688230 | 2021-09-05 | Newton | Missouri | 29145 | 7339 | 108 |
1684980 | 1684980 | 2021-09-04 | Newton | Missouri | 29145 | 7337 | 108 |
1681729 | 1681729 | 2021-09-03 | Newton | Missouri | 29145 | 7326 | 108 |
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);