ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
637 rows where deaths = 32 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clark 70
- DeKalb 60
- Moniteau 52
- Perry 46
- Chariton 35
- Bates 30
- Monroe 26
- Shannon 25
- Wright 23
- Oregon 21
- St. Clair 19
- Livingston 15
- Nodaway 14
- Kansas City 12
- Benton 11
- Caldwell 9
- Franklin 9
- Iron 8
- Marion 8
- McDonald 8
- Harrison 7
- Lawrence 7
- Maries 7
- Pettis 7
- Cape Girardeau 6
- Crawford 6
- Gasconade 6
- Grundy 6
- Joplin 6
- Ray 6
- …
state 1
- Missouri · 637 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471778 | 2471778 | 2022-05-04 | Clark | Missouri | 29045 | 1590 | 32 |
2468522 | 2468522 | 2022-05-03 | Clark | Missouri | 29045 | 1590 | 32 |
2465266 | 2465266 | 2022-05-02 | Clark | Missouri | 29045 | 1590 | 32 |
2462011 | 2462011 | 2022-05-01 | Clark | Missouri | 29045 | 1590 | 32 |
2458755 | 2458755 | 2022-04-30 | Clark | Missouri | 29045 | 1590 | 32 |
2455499 | 2455499 | 2022-04-29 | Clark | Missouri | 29045 | 1590 | 32 |
2452243 | 2452243 | 2022-04-28 | Clark | Missouri | 29045 | 1590 | 32 |
2448987 | 2448987 | 2022-04-27 | Clark | Missouri | 29045 | 1590 | 32 |
2445730 | 2445730 | 2022-04-26 | Clark | Missouri | 29045 | 1590 | 32 |
2442475 | 2442475 | 2022-04-25 | Clark | Missouri | 29045 | 1590 | 32 |
2439219 | 2439219 | 2022-04-24 | Clark | Missouri | 29045 | 1590 | 32 |
2435963 | 2435963 | 2022-04-23 | Clark | Missouri | 29045 | 1590 | 32 |
2432707 | 2432707 | 2022-04-22 | Clark | Missouri | 29045 | 1590 | 32 |
2429451 | 2429451 | 2022-04-21 | Clark | Missouri | 29045 | 1590 | 32 |
2426195 | 2426195 | 2022-04-20 | Clark | Missouri | 29045 | 1590 | 32 |
2422939 | 2422939 | 2022-04-19 | Clark | Missouri | 29045 | 1590 | 32 |
2419682 | 2419682 | 2022-04-18 | Clark | Missouri | 29045 | 1590 | 32 |
2416427 | 2416427 | 2022-04-17 | Clark | Missouri | 29045 | 1590 | 32 |
2413171 | 2413171 | 2022-04-16 | Clark | Missouri | 29045 | 1590 | 32 |
2409915 | 2409915 | 2022-04-15 | Clark | Missouri | 29045 | 1590 | 32 |
2406659 | 2406659 | 2022-04-14 | Clark | Missouri | 29045 | 1590 | 32 |
2403403 | 2403403 | 2022-04-13 | Clark | Missouri | 29045 | 1590 | 32 |
2400148 | 2400148 | 2022-04-12 | Clark | Missouri | 29045 | 1590 | 32 |
2396893 | 2396893 | 2022-04-11 | Clark | Missouri | 29045 | 1590 | 32 |
2393638 | 2393638 | 2022-04-10 | Clark | Missouri | 29045 | 1590 | 32 |
2390382 | 2390382 | 2022-04-09 | Clark | Missouri | 29045 | 1590 | 32 |
2387126 | 2387126 | 2022-04-08 | Clark | Missouri | 29045 | 1590 | 32 |
2383871 | 2383871 | 2022-04-07 | Clark | Missouri | 29045 | 1590 | 32 |
2380616 | 2380616 | 2022-04-06 | Clark | Missouri | 29045 | 1590 | 32 |
2377361 | 2377361 | 2022-04-05 | Clark | Missouri | 29045 | 1590 | 32 |
2374108 | 2374108 | 2022-04-04 | Clark | Missouri | 29045 | 1590 | 32 |
2370856 | 2370856 | 2022-04-03 | Clark | Missouri | 29045 | 1590 | 32 |
2367603 | 2367603 | 2022-04-02 | Clark | Missouri | 29045 | 1590 | 32 |
2364350 | 2364350 | 2022-04-01 | Clark | Missouri | 29045 | 1590 | 32 |
2361096 | 2361096 | 2022-03-31 | Clark | Missouri | 29045 | 1590 | 32 |
2357842 | 2357842 | 2022-03-30 | Clark | Missouri | 29045 | 1585 | 32 |
2354589 | 2354589 | 2022-03-29 | Clark | Missouri | 29045 | 1585 | 32 |
2351336 | 2351336 | 2022-03-28 | Clark | Missouri | 29045 | 1585 | 32 |
2348084 | 2348084 | 2022-03-27 | Clark | Missouri | 29045 | 1585 | 32 |
2344831 | 2344831 | 2022-03-26 | Clark | Missouri | 29045 | 1585 | 32 |
2341578 | 2341578 | 2022-03-25 | Clark | Missouri | 29045 | 1585 | 32 |
2338325 | 2338325 | 2022-03-24 | Clark | Missouri | 29045 | 1585 | 32 |
2335071 | 2335071 | 2022-03-23 | Clark | Missouri | 29045 | 1583 | 32 |
2331817 | 2331817 | 2022-03-22 | Clark | Missouri | 29045 | 1582 | 32 |
2328564 | 2328564 | 2022-03-21 | Clark | Missouri | 29045 | 1582 | 32 |
2328582 | 2328582 | 2022-03-21 | Harrison | Missouri | 29081 | 1813 | 32 |
2328618 | 2328618 | 2022-03-21 | Oregon | Missouri | 29149 | 2019 | 32 |
2325312 | 2325312 | 2022-03-20 | Clark | Missouri | 29045 | 1582 | 32 |
2325330 | 2325330 | 2022-03-20 | Harrison | Missouri | 29081 | 1813 | 32 |
2325366 | 2325366 | 2022-03-20 | Oregon | Missouri | 29149 | 2018 | 32 |
2322058 | 2322058 | 2022-03-19 | Clark | Missouri | 29045 | 1582 | 32 |
2322076 | 2322076 | 2022-03-19 | Harrison | Missouri | 29081 | 1813 | 32 |
2322112 | 2322112 | 2022-03-19 | Oregon | Missouri | 29149 | 2018 | 32 |
2318804 | 2318804 | 2022-03-18 | Clark | Missouri | 29045 | 1582 | 32 |
2318822 | 2318822 | 2022-03-18 | Harrison | Missouri | 29081 | 1813 | 32 |
2318858 | 2318858 | 2022-03-18 | Oregon | Missouri | 29149 | 2018 | 32 |
2315551 | 2315551 | 2022-03-17 | Clark | Missouri | 29045 | 1582 | 32 |
2315569 | 2315569 | 2022-03-17 | Harrison | Missouri | 29081 | 1813 | 32 |
2315605 | 2315605 | 2022-03-17 | Oregon | Missouri | 29149 | 2018 | 32 |
2312298 | 2312298 | 2022-03-16 | Clark | Missouri | 29045 | 1581 | 32 |
2312316 | 2312316 | 2022-03-16 | Harrison | Missouri | 29081 | 1813 | 32 |
2312352 | 2312352 | 2022-03-16 | Oregon | Missouri | 29149 | 2017 | 32 |
2309045 | 2309045 | 2022-03-15 | Clark | Missouri | 29045 | 1581 | 32 |
2309063 | 2309063 | 2022-03-15 | Harrison | Missouri | 29081 | 1813 | 32 |
2309099 | 2309099 | 2022-03-15 | Oregon | Missouri | 29149 | 2017 | 32 |
2305793 | 2305793 | 2022-03-14 | Clark | Missouri | 29045 | 1581 | 32 |
2305847 | 2305847 | 2022-03-14 | Oregon | Missouri | 29149 | 2016 | 32 |
2305871 | 2305871 | 2022-03-14 | St. Clair | Missouri | 29185 | 2096 | 32 |
2302542 | 2302542 | 2022-03-13 | Clark | Missouri | 29045 | 1581 | 32 |
2302596 | 2302596 | 2022-03-13 | Oregon | Missouri | 29149 | 2015 | 32 |
2302620 | 2302620 | 2022-03-13 | St. Clair | Missouri | 29185 | 2096 | 32 |
2299290 | 2299290 | 2022-03-12 | Clark | Missouri | 29045 | 1581 | 32 |
2299344 | 2299344 | 2022-03-12 | Oregon | Missouri | 29149 | 2015 | 32 |
2299368 | 2299368 | 2022-03-12 | St. Clair | Missouri | 29185 | 2096 | 32 |
2296038 | 2296038 | 2022-03-11 | Clark | Missouri | 29045 | 1581 | 32 |
2296092 | 2296092 | 2022-03-11 | Oregon | Missouri | 29149 | 2015 | 32 |
2296116 | 2296116 | 2022-03-11 | St. Clair | Missouri | 29185 | 2096 | 32 |
2292786 | 2292786 | 2022-03-10 | Clark | Missouri | 29045 | 1581 | 32 |
2292840 | 2292840 | 2022-03-10 | Oregon | Missouri | 29149 | 2017 | 32 |
2292864 | 2292864 | 2022-03-10 | St. Clair | Missouri | 29185 | 2096 | 32 |
2289534 | 2289534 | 2022-03-09 | Clark | Missouri | 29045 | 1579 | 32 |
2289588 | 2289588 | 2022-03-09 | Oregon | Missouri | 29149 | 2016 | 32 |
2289612 | 2289612 | 2022-03-09 | St. Clair | Missouri | 29185 | 2096 | 32 |
2286282 | 2286282 | 2022-03-08 | Clark | Missouri | 29045 | 1579 | 32 |
2286336 | 2286336 | 2022-03-08 | Oregon | Missouri | 29149 | 2015 | 32 |
2286360 | 2286360 | 2022-03-08 | St. Clair | Missouri | 29185 | 2096 | 32 |
2283030 | 2283030 | 2022-03-07 | Clark | Missouri | 29045 | 1577 | 32 |
2283084 | 2283084 | 2022-03-07 | Oregon | Missouri | 29149 | 2014 | 32 |
2283108 | 2283108 | 2022-03-07 | St. Clair | Missouri | 29185 | 2096 | 32 |
2279777 | 2279777 | 2022-03-06 | Clark | Missouri | 29045 | 1576 | 32 |
2279831 | 2279831 | 2022-03-06 | Oregon | Missouri | 29149 | 2013 | 32 |
2279855 | 2279855 | 2022-03-06 | St. Clair | Missouri | 29185 | 2094 | 32 |
2276524 | 2276524 | 2022-03-05 | Clark | Missouri | 29045 | 1576 | 32 |
2276578 | 2276578 | 2022-03-05 | Oregon | Missouri | 29149 | 2013 | 32 |
2276602 | 2276602 | 2022-03-05 | St. Clair | Missouri | 29185 | 2094 | 32 |
2273271 | 2273271 | 2022-03-04 | Clark | Missouri | 29045 | 1576 | 32 |
2273325 | 2273325 | 2022-03-04 | Oregon | Missouri | 29149 | 2013 | 32 |
2273349 | 2273349 | 2022-03-04 | St. Clair | Missouri | 29185 | 2094 | 32 |
2270019 | 2270019 | 2022-03-03 | Clark | Missouri | 29045 | 1575 | 32 |
2270073 | 2270073 | 2022-03-03 | Oregon | Missouri | 29149 | 2012 | 32 |
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);