ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
711 rows where deaths = 33 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- DeKalb 108
- Harrison 53
- Oregon 53
- Moniteau 52
- Perry 36
- Cooper 31
- Warren 27
- Benton 24
- Bates 16
- Taney 15
- Chariton 14
- Dent 14
- Nodaway 14
- Pike 14
- Randolph 14
- Iron 13
- Maries 12
- Pulaski 12
- Ste. Genevieve 12
- Gasconade 11
- Mississippi 11
- St. Clair 10
- Saline 9
- Scott 9
- Vernon 9
- Wright 9
- Audrain 8
- Stone 8
- Douglas 7
- Lawrence 7
- …
state 1
- Missouri · 711 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501116 | 2501116 | 2022-05-13 | Harrison | Missouri | 29081 | 1876 | 33 |
2501152 | 2501152 | 2022-05-13 | Oregon | Missouri | 29149 | 2024 | 33 |
2497858 | 2497858 | 2022-05-12 | Harrison | Missouri | 29081 | 1869 | 33 |
2497894 | 2497894 | 2022-05-12 | Oregon | Missouri | 29149 | 2024 | 33 |
2494600 | 2494600 | 2022-05-11 | Harrison | Missouri | 29081 | 1869 | 33 |
2494636 | 2494636 | 2022-05-11 | Oregon | Missouri | 29149 | 2024 | 33 |
2491342 | 2491342 | 2022-05-10 | Harrison | Missouri | 29081 | 1869 | 33 |
2491378 | 2491378 | 2022-05-10 | Oregon | Missouri | 29149 | 2024 | 33 |
2488084 | 2488084 | 2022-05-09 | Harrison | Missouri | 29081 | 1869 | 33 |
2488120 | 2488120 | 2022-05-09 | Oregon | Missouri | 29149 | 2024 | 33 |
2484827 | 2484827 | 2022-05-08 | Harrison | Missouri | 29081 | 1869 | 33 |
2484863 | 2484863 | 2022-05-08 | Oregon | Missouri | 29149 | 2024 | 33 |
2481569 | 2481569 | 2022-05-07 | Harrison | Missouri | 29081 | 1869 | 33 |
2481605 | 2481605 | 2022-05-07 | Oregon | Missouri | 29149 | 2024 | 33 |
2478311 | 2478311 | 2022-05-06 | Harrison | Missouri | 29081 | 1869 | 33 |
2478347 | 2478347 | 2022-05-06 | Oregon | Missouri | 29149 | 2024 | 33 |
2475053 | 2475053 | 2022-05-05 | Harrison | Missouri | 29081 | 1846 | 33 |
2475089 | 2475089 | 2022-05-05 | Oregon | Missouri | 29149 | 2024 | 33 |
2471796 | 2471796 | 2022-05-04 | Harrison | Missouri | 29081 | 1821 | 33 |
2471832 | 2471832 | 2022-05-04 | Oregon | Missouri | 29149 | 2022 | 33 |
2468540 | 2468540 | 2022-05-03 | Harrison | Missouri | 29081 | 1821 | 33 |
2468576 | 2468576 | 2022-05-03 | Oregon | Missouri | 29149 | 2022 | 33 |
2465284 | 2465284 | 2022-05-02 | Harrison | Missouri | 29081 | 1821 | 33 |
2465320 | 2465320 | 2022-05-02 | Oregon | Missouri | 29149 | 2022 | 33 |
2462029 | 2462029 | 2022-05-01 | Harrison | Missouri | 29081 | 1821 | 33 |
2462065 | 2462065 | 2022-05-01 | Oregon | Missouri | 29149 | 2022 | 33 |
2458773 | 2458773 | 2022-04-30 | Harrison | Missouri | 29081 | 1821 | 33 |
2458809 | 2458809 | 2022-04-30 | Oregon | Missouri | 29149 | 2022 | 33 |
2455517 | 2455517 | 2022-04-29 | Harrison | Missouri | 29081 | 1821 | 33 |
2455553 | 2455553 | 2022-04-29 | Oregon | Missouri | 29149 | 2022 | 33 |
2452261 | 2452261 | 2022-04-28 | Harrison | Missouri | 29081 | 1821 | 33 |
2452297 | 2452297 | 2022-04-28 | Oregon | Missouri | 29149 | 2022 | 33 |
2449005 | 2449005 | 2022-04-27 | Harrison | Missouri | 29081 | 1821 | 33 |
2449041 | 2449041 | 2022-04-27 | Oregon | Missouri | 29149 | 2022 | 33 |
2445748 | 2445748 | 2022-04-26 | Harrison | Missouri | 29081 | 1821 | 33 |
2445784 | 2445784 | 2022-04-26 | Oregon | Missouri | 29149 | 2022 | 33 |
2442493 | 2442493 | 2022-04-25 | Harrison | Missouri | 29081 | 1821 | 33 |
2442529 | 2442529 | 2022-04-25 | Oregon | Missouri | 29149 | 2022 | 33 |
2439237 | 2439237 | 2022-04-24 | Harrison | Missouri | 29081 | 1821 | 33 |
2439273 | 2439273 | 2022-04-24 | Oregon | Missouri | 29149 | 2022 | 33 |
2435981 | 2435981 | 2022-04-23 | Harrison | Missouri | 29081 | 1821 | 33 |
2436017 | 2436017 | 2022-04-23 | Oregon | Missouri | 29149 | 2022 | 33 |
2432725 | 2432725 | 2022-04-22 | Harrison | Missouri | 29081 | 1821 | 33 |
2432761 | 2432761 | 2022-04-22 | Oregon | Missouri | 29149 | 2022 | 33 |
2429469 | 2429469 | 2022-04-21 | Harrison | Missouri | 29081 | 1821 | 33 |
2429505 | 2429505 | 2022-04-21 | Oregon | Missouri | 29149 | 2022 | 33 |
2426213 | 2426213 | 2022-04-20 | Harrison | Missouri | 29081 | 1821 | 33 |
2426249 | 2426249 | 2022-04-20 | Oregon | Missouri | 29149 | 2022 | 33 |
2422957 | 2422957 | 2022-04-19 | Harrison | Missouri | 29081 | 1821 | 33 |
2422993 | 2422993 | 2022-04-19 | Oregon | Missouri | 29149 | 2022 | 33 |
2419700 | 2419700 | 2022-04-18 | Harrison | Missouri | 29081 | 1821 | 33 |
2419736 | 2419736 | 2022-04-18 | Oregon | Missouri | 29149 | 2022 | 33 |
2416445 | 2416445 | 2022-04-17 | Harrison | Missouri | 29081 | 1821 | 33 |
2416481 | 2416481 | 2022-04-17 | Oregon | Missouri | 29149 | 2022 | 33 |
2413189 | 2413189 | 2022-04-16 | Harrison | Missouri | 29081 | 1821 | 33 |
2413225 | 2413225 | 2022-04-16 | Oregon | Missouri | 29149 | 2022 | 33 |
2409933 | 2409933 | 2022-04-15 | Harrison | Missouri | 29081 | 1821 | 33 |
2409969 | 2409969 | 2022-04-15 | Oregon | Missouri | 29149 | 2022 | 33 |
2406677 | 2406677 | 2022-04-14 | Harrison | Missouri | 29081 | 1821 | 33 |
2406713 | 2406713 | 2022-04-14 | Oregon | Missouri | 29149 | 2022 | 33 |
2403421 | 2403421 | 2022-04-13 | Harrison | Missouri | 29081 | 1821 | 33 |
2403457 | 2403457 | 2022-04-13 | Oregon | Missouri | 29149 | 2022 | 33 |
2400166 | 2400166 | 2022-04-12 | Harrison | Missouri | 29081 | 1821 | 33 |
2400202 | 2400202 | 2022-04-12 | Oregon | Missouri | 29149 | 2022 | 33 |
2396911 | 2396911 | 2022-04-11 | Harrison | Missouri | 29081 | 1821 | 33 |
2396947 | 2396947 | 2022-04-11 | Oregon | Missouri | 29149 | 2022 | 33 |
2393656 | 2393656 | 2022-04-10 | Harrison | Missouri | 29081 | 1821 | 33 |
2393692 | 2393692 | 2022-04-10 | Oregon | Missouri | 29149 | 2022 | 33 |
2390400 | 2390400 | 2022-04-09 | Harrison | Missouri | 29081 | 1821 | 33 |
2390436 | 2390436 | 2022-04-09 | Oregon | Missouri | 29149 | 2022 | 33 |
2387144 | 2387144 | 2022-04-08 | Harrison | Missouri | 29081 | 1821 | 33 |
2387180 | 2387180 | 2022-04-08 | Oregon | Missouri | 29149 | 2022 | 33 |
2383889 | 2383889 | 2022-04-07 | Harrison | Missouri | 29081 | 1821 | 33 |
2383925 | 2383925 | 2022-04-07 | Oregon | Missouri | 29149 | 2022 | 33 |
2380634 | 2380634 | 2022-04-06 | Harrison | Missouri | 29081 | 1821 | 33 |
2380670 | 2380670 | 2022-04-06 | Oregon | Missouri | 29149 | 2022 | 33 |
2377379 | 2377379 | 2022-04-05 | Harrison | Missouri | 29081 | 1821 | 33 |
2377415 | 2377415 | 2022-04-05 | Oregon | Missouri | 29149 | 2022 | 33 |
2374126 | 2374126 | 2022-04-04 | Harrison | Missouri | 29081 | 1821 | 33 |
2374162 | 2374162 | 2022-04-04 | Oregon | Missouri | 29149 | 2022 | 33 |
2370874 | 2370874 | 2022-04-03 | Harrison | Missouri | 29081 | 1821 | 33 |
2370910 | 2370910 | 2022-04-03 | Oregon | Missouri | 29149 | 2022 | 33 |
2367621 | 2367621 | 2022-04-02 | Harrison | Missouri | 29081 | 1821 | 33 |
2367657 | 2367657 | 2022-04-02 | Oregon | Missouri | 29149 | 2022 | 33 |
2364368 | 2364368 | 2022-04-01 | Harrison | Missouri | 29081 | 1821 | 33 |
2364404 | 2364404 | 2022-04-01 | Oregon | Missouri | 29149 | 2022 | 33 |
2361114 | 2361114 | 2022-03-31 | Harrison | Missouri | 29081 | 1821 | 33 |
2361150 | 2361150 | 2022-03-31 | Oregon | Missouri | 29149 | 2022 | 33 |
2357860 | 2357860 | 2022-03-30 | Harrison | Missouri | 29081 | 1815 | 33 |
2357896 | 2357896 | 2022-03-30 | Oregon | Missouri | 29149 | 2022 | 33 |
2354607 | 2354607 | 2022-03-29 | Harrison | Missouri | 29081 | 1815 | 33 |
2354643 | 2354643 | 2022-03-29 | Oregon | Missouri | 29149 | 2022 | 33 |
2351354 | 2351354 | 2022-03-28 | Harrison | Missouri | 29081 | 1818 | 33 |
2351390 | 2351390 | 2022-03-28 | Oregon | Missouri | 29149 | 2022 | 33 |
2348102 | 2348102 | 2022-03-27 | Harrison | Missouri | 29081 | 1818 | 33 |
2348138 | 2348138 | 2022-03-27 | Oregon | Missouri | 29149 | 2022 | 33 |
2344849 | 2344849 | 2022-03-26 | Harrison | Missouri | 29081 | 1818 | 33 |
2344885 | 2344885 | 2022-03-26 | Oregon | Missouri | 29149 | 2022 | 33 |
2341596 | 2341596 | 2022-03-25 | Harrison | Missouri | 29081 | 1818 | 33 |
2341632 | 2341632 | 2022-03-25 | Oregon | Missouri | 29149 | 2022 | 33 |
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);