ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
227 rows where deaths = 117 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 20
county 20
- Dunklin 60
- Clinton 38
- Boone 21
- Newton 14
- Washington 14
- Webster 12
- Johnson 7
- Marion 7
- Phelps 7
- Scott 7
- St. Francois 7
- Stone 7
- Cass 6
- Miller 6
- Callaway 5
- Joplin 5
- Clay 1
- Jackson 1
- St. Charles 1
- St. Louis city 1
state 1
- Missouri · 227 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501110 | 2501110 | 2022-05-13 | Dunklin | Missouri | 29069 | 7824 | 117 |
2497852 | 2497852 | 2022-05-12 | Dunklin | Missouri | 29069 | 7763 | 117 |
2494594 | 2494594 | 2022-05-11 | Dunklin | Missouri | 29069 | 7763 | 117 |
2491336 | 2491336 | 2022-05-10 | Dunklin | Missouri | 29069 | 7763 | 117 |
2488078 | 2488078 | 2022-05-09 | Dunklin | Missouri | 29069 | 7763 | 117 |
2484821 | 2484821 | 2022-05-08 | Dunklin | Missouri | 29069 | 7763 | 117 |
2481563 | 2481563 | 2022-05-07 | Dunklin | Missouri | 29069 | 7763 | 117 |
2478305 | 2478305 | 2022-05-06 | Dunklin | Missouri | 29069 | 7763 | 117 |
2475047 | 2475047 | 2022-05-05 | Dunklin | Missouri | 29069 | 7691 | 117 |
2471780 | 2471780 | 2022-05-04 | Clinton | Missouri | 29049 | 4804 | 117 |
2471790 | 2471790 | 2022-05-04 | Dunklin | Missouri | 29069 | 7456 | 117 |
2468524 | 2468524 | 2022-05-03 | Clinton | Missouri | 29049 | 4804 | 117 |
2468534 | 2468534 | 2022-05-03 | Dunklin | Missouri | 29069 | 7456 | 117 |
2465268 | 2465268 | 2022-05-02 | Clinton | Missouri | 29049 | 4804 | 117 |
2465278 | 2465278 | 2022-05-02 | Dunklin | Missouri | 29069 | 7456 | 117 |
2462013 | 2462013 | 2022-05-01 | Clinton | Missouri | 29049 | 4804 | 117 |
2462023 | 2462023 | 2022-05-01 | Dunklin | Missouri | 29069 | 7456 | 117 |
2458757 | 2458757 | 2022-04-30 | Clinton | Missouri | 29049 | 4804 | 117 |
2458767 | 2458767 | 2022-04-30 | Dunklin | Missouri | 29069 | 7456 | 117 |
2455501 | 2455501 | 2022-04-29 | Clinton | Missouri | 29049 | 4804 | 117 |
2455511 | 2455511 | 2022-04-29 | Dunklin | Missouri | 29069 | 7456 | 117 |
2452245 | 2452245 | 2022-04-28 | Clinton | Missouri | 29049 | 4804 | 117 |
2452255 | 2452255 | 2022-04-28 | Dunklin | Missouri | 29069 | 7456 | 117 |
2448989 | 2448989 | 2022-04-27 | Clinton | Missouri | 29049 | 4804 | 117 |
2448999 | 2448999 | 2022-04-27 | Dunklin | Missouri | 29069 | 7456 | 117 |
2445732 | 2445732 | 2022-04-26 | Clinton | Missouri | 29049 | 4804 | 117 |
2445742 | 2445742 | 2022-04-26 | Dunklin | Missouri | 29069 | 7456 | 117 |
2442477 | 2442477 | 2022-04-25 | Clinton | Missouri | 29049 | 4804 | 117 |
2442487 | 2442487 | 2022-04-25 | Dunklin | Missouri | 29069 | 7456 | 117 |
2439221 | 2439221 | 2022-04-24 | Clinton | Missouri | 29049 | 4804 | 117 |
2439231 | 2439231 | 2022-04-24 | Dunklin | Missouri | 29069 | 7456 | 117 |
2435965 | 2435965 | 2022-04-23 | Clinton | Missouri | 29049 | 4804 | 117 |
2435975 | 2435975 | 2022-04-23 | Dunklin | Missouri | 29069 | 7456 | 117 |
2432709 | 2432709 | 2022-04-22 | Clinton | Missouri | 29049 | 4804 | 117 |
2432719 | 2432719 | 2022-04-22 | Dunklin | Missouri | 29069 | 7456 | 117 |
2429453 | 2429453 | 2022-04-21 | Clinton | Missouri | 29049 | 4804 | 117 |
2429463 | 2429463 | 2022-04-21 | Dunklin | Missouri | 29069 | 7456 | 117 |
2426197 | 2426197 | 2022-04-20 | Clinton | Missouri | 29049 | 4804 | 117 |
2426207 | 2426207 | 2022-04-20 | Dunklin | Missouri | 29069 | 7456 | 117 |
2422941 | 2422941 | 2022-04-19 | Clinton | Missouri | 29049 | 4804 | 117 |
2422951 | 2422951 | 2022-04-19 | Dunklin | Missouri | 29069 | 7456 | 117 |
2419684 | 2419684 | 2022-04-18 | Clinton | Missouri | 29049 | 4804 | 117 |
2419694 | 2419694 | 2022-04-18 | Dunklin | Missouri | 29069 | 7456 | 117 |
2416429 | 2416429 | 2022-04-17 | Clinton | Missouri | 29049 | 4804 | 117 |
2416439 | 2416439 | 2022-04-17 | Dunklin | Missouri | 29069 | 7456 | 117 |
2413173 | 2413173 | 2022-04-16 | Clinton | Missouri | 29049 | 4804 | 117 |
2413183 | 2413183 | 2022-04-16 | Dunklin | Missouri | 29069 | 7456 | 117 |
2409917 | 2409917 | 2022-04-15 | Clinton | Missouri | 29049 | 4804 | 117 |
2409927 | 2409927 | 2022-04-15 | Dunklin | Missouri | 29069 | 7456 | 117 |
2406661 | 2406661 | 2022-04-14 | Clinton | Missouri | 29049 | 4804 | 117 |
2406671 | 2406671 | 2022-04-14 | Dunklin | Missouri | 29069 | 7456 | 117 |
2403405 | 2403405 | 2022-04-13 | Clinton | Missouri | 29049 | 4804 | 117 |
2403415 | 2403415 | 2022-04-13 | Dunklin | Missouri | 29069 | 7456 | 117 |
2400150 | 2400150 | 2022-04-12 | Clinton | Missouri | 29049 | 4804 | 117 |
2400160 | 2400160 | 2022-04-12 | Dunklin | Missouri | 29069 | 7456 | 117 |
2396895 | 2396895 | 2022-04-11 | Clinton | Missouri | 29049 | 4804 | 117 |
2396905 | 2396905 | 2022-04-11 | Dunklin | Missouri | 29069 | 7456 | 117 |
2393640 | 2393640 | 2022-04-10 | Clinton | Missouri | 29049 | 4804 | 117 |
2393650 | 2393650 | 2022-04-10 | Dunklin | Missouri | 29069 | 7456 | 117 |
2390384 | 2390384 | 2022-04-09 | Clinton | Missouri | 29049 | 4804 | 117 |
2390394 | 2390394 | 2022-04-09 | Dunklin | Missouri | 29069 | 7456 | 117 |
2387128 | 2387128 | 2022-04-08 | Clinton | Missouri | 29049 | 4804 | 117 |
2387138 | 2387138 | 2022-04-08 | Dunklin | Missouri | 29069 | 7456 | 117 |
2383873 | 2383873 | 2022-04-07 | Clinton | Missouri | 29049 | 4804 | 117 |
2383883 | 2383883 | 2022-04-07 | Dunklin | Missouri | 29069 | 7456 | 117 |
2380618 | 2380618 | 2022-04-06 | Clinton | Missouri | 29049 | 4804 | 117 |
2380628 | 2380628 | 2022-04-06 | Dunklin | Missouri | 29069 | 7456 | 117 |
2377363 | 2377363 | 2022-04-05 | Clinton | Missouri | 29049 | 4804 | 117 |
2377373 | 2377373 | 2022-04-05 | Dunklin | Missouri | 29069 | 7456 | 117 |
2374110 | 2374110 | 2022-04-04 | Clinton | Missouri | 29049 | 4804 | 117 |
2374120 | 2374120 | 2022-04-04 | Dunklin | Missouri | 29069 | 7456 | 117 |
2370858 | 2370858 | 2022-04-03 | Clinton | Missouri | 29049 | 4804 | 117 |
2370868 | 2370868 | 2022-04-03 | Dunklin | Missouri | 29069 | 7456 | 117 |
2367605 | 2367605 | 2022-04-02 | Clinton | Missouri | 29049 | 4804 | 117 |
2367615 | 2367615 | 2022-04-02 | Dunklin | Missouri | 29069 | 7456 | 117 |
2364352 | 2364352 | 2022-04-01 | Clinton | Missouri | 29049 | 4804 | 117 |
2364362 | 2364362 | 2022-04-01 | Dunklin | Missouri | 29069 | 7456 | 117 |
2361098 | 2361098 | 2022-03-31 | Clinton | Missouri | 29049 | 4804 | 117 |
2361108 | 2361108 | 2022-03-31 | Dunklin | Missouri | 29069 | 7456 | 117 |
2357844 | 2357844 | 2022-03-30 | Clinton | Missouri | 29049 | 4801 | 117 |
2357854 | 2357854 | 2022-03-30 | Dunklin | Missouri | 29069 | 7435 | 117 |
2354591 | 2354591 | 2022-03-29 | Clinton | Missouri | 29049 | 4798 | 117 |
2354601 | 2354601 | 2022-03-29 | Dunklin | Missouri | 29069 | 7416 | 117 |
2351338 | 2351338 | 2022-03-28 | Clinton | Missouri | 29049 | 4797 | 117 |
2351348 | 2351348 | 2022-03-28 | Dunklin | Missouri | 29069 | 7408 | 117 |
2351381 | 2351381 | 2022-03-28 | Miller | Missouri | 29131 | 6095 | 117 |
2348096 | 2348096 | 2022-03-27 | Dunklin | Missouri | 29069 | 7401 | 117 |
2348129 | 2348129 | 2022-03-27 | Miller | Missouri | 29131 | 6095 | 117 |
2344843 | 2344843 | 2022-03-26 | Dunklin | Missouri | 29069 | 7401 | 117 |
2344876 | 2344876 | 2022-03-26 | Miller | Missouri | 29131 | 6095 | 117 |
2341590 | 2341590 | 2022-03-25 | Dunklin | Missouri | 29069 | 7401 | 117 |
2341623 | 2341623 | 2022-03-25 | Miller | Missouri | 29131 | 6095 | 117 |
2338337 | 2338337 | 2022-03-24 | Dunklin | Missouri | 29069 | 7387 | 117 |
2338370 | 2338370 | 2022-03-24 | Miller | Missouri | 29131 | 6090 | 117 |
2335083 | 2335083 | 2022-03-23 | Dunklin | Missouri | 29069 | 7320 | 117 |
2335116 | 2335116 | 2022-03-23 | Miller | Missouri | 29131 | 6088 | 117 |
2331829 | 2331829 | 2022-03-22 | Dunklin | Missouri | 29069 | 7298 | 117 |
2328576 | 2328576 | 2022-03-21 | Dunklin | Missouri | 29069 | 7284 | 117 |
2328606 | 2328606 | 2022-03-21 | Marion | Missouri | 29127 | 7957 | 117 |
2325324 | 2325324 | 2022-03-20 | Dunklin | Missouri | 29069 | 7283 | 117 |
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);