ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
580 rows where deaths = 45 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Barry 76
- DeKalb 63
- Howell 45
- Perry 44
- New Madrid 34
- Gasconade 28
- Benton 21
- Hickory 21
- Marion 21
- Johnson 14
- Livingston 14
- Miller 14
- Platte 12
- Washington 12
- Webster 11
- Grundy 10
- Madison 10
- Crawford 8
- Mississippi 8
- Warren 8
- Adair 7
- Camden 7
- Saline 7
- Stoddard 7
- Callaway 6
- Douglas 6
- Lafayette 6
- Morgan 6
- Christian 5
- Jasper 5
- …
state 1
- Missouri · 580 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471787 | 2471787 | 2022-05-04 | DeKalb | Missouri | 29063 | 2204 | 45 |
2471836 | 2471836 | 2022-05-04 | Perry | Missouri | 29157 | 4989 | 45 |
2468531 | 2468531 | 2022-05-03 | DeKalb | Missouri | 29063 | 2204 | 45 |
2468580 | 2468580 | 2022-05-03 | Perry | Missouri | 29157 | 4989 | 45 |
2465275 | 2465275 | 2022-05-02 | DeKalb | Missouri | 29063 | 2204 | 45 |
2465324 | 2465324 | 2022-05-02 | Perry | Missouri | 29157 | 4989 | 45 |
2462020 | 2462020 | 2022-05-01 | DeKalb | Missouri | 29063 | 2204 | 45 |
2462069 | 2462069 | 2022-05-01 | Perry | Missouri | 29157 | 4989 | 45 |
2458764 | 2458764 | 2022-04-30 | DeKalb | Missouri | 29063 | 2204 | 45 |
2458813 | 2458813 | 2022-04-30 | Perry | Missouri | 29157 | 4989 | 45 |
2455508 | 2455508 | 2022-04-29 | DeKalb | Missouri | 29063 | 2204 | 45 |
2455557 | 2455557 | 2022-04-29 | Perry | Missouri | 29157 | 4989 | 45 |
2452252 | 2452252 | 2022-04-28 | DeKalb | Missouri | 29063 | 2204 | 45 |
2452301 | 2452301 | 2022-04-28 | Perry | Missouri | 29157 | 4989 | 45 |
2448996 | 2448996 | 2022-04-27 | DeKalb | Missouri | 29063 | 2204 | 45 |
2449045 | 2449045 | 2022-04-27 | Perry | Missouri | 29157 | 4989 | 45 |
2445739 | 2445739 | 2022-04-26 | DeKalb | Missouri | 29063 | 2204 | 45 |
2445788 | 2445788 | 2022-04-26 | Perry | Missouri | 29157 | 4989 | 45 |
2442484 | 2442484 | 2022-04-25 | DeKalb | Missouri | 29063 | 2204 | 45 |
2442533 | 2442533 | 2022-04-25 | Perry | Missouri | 29157 | 4989 | 45 |
2439228 | 2439228 | 2022-04-24 | DeKalb | Missouri | 29063 | 2204 | 45 |
2439277 | 2439277 | 2022-04-24 | Perry | Missouri | 29157 | 4989 | 45 |
2435972 | 2435972 | 2022-04-23 | DeKalb | Missouri | 29063 | 2204 | 45 |
2436021 | 2436021 | 2022-04-23 | Perry | Missouri | 29157 | 4989 | 45 |
2432716 | 2432716 | 2022-04-22 | DeKalb | Missouri | 29063 | 2204 | 45 |
2432765 | 2432765 | 2022-04-22 | Perry | Missouri | 29157 | 4989 | 45 |
2429460 | 2429460 | 2022-04-21 | DeKalb | Missouri | 29063 | 2204 | 45 |
2429509 | 2429509 | 2022-04-21 | Perry | Missouri | 29157 | 4989 | 45 |
2426204 | 2426204 | 2022-04-20 | DeKalb | Missouri | 29063 | 2204 | 45 |
2426253 | 2426253 | 2022-04-20 | Perry | Missouri | 29157 | 4989 | 45 |
2422948 | 2422948 | 2022-04-19 | DeKalb | Missouri | 29063 | 2204 | 45 |
2422997 | 2422997 | 2022-04-19 | Perry | Missouri | 29157 | 4989 | 45 |
2419691 | 2419691 | 2022-04-18 | DeKalb | Missouri | 29063 | 2204 | 45 |
2419740 | 2419740 | 2022-04-18 | Perry | Missouri | 29157 | 4989 | 45 |
2416436 | 2416436 | 2022-04-17 | DeKalb | Missouri | 29063 | 2204 | 45 |
2416485 | 2416485 | 2022-04-17 | Perry | Missouri | 29157 | 4989 | 45 |
2413180 | 2413180 | 2022-04-16 | DeKalb | Missouri | 29063 | 2204 | 45 |
2413229 | 2413229 | 2022-04-16 | Perry | Missouri | 29157 | 4989 | 45 |
2409924 | 2409924 | 2022-04-15 | DeKalb | Missouri | 29063 | 2204 | 45 |
2409973 | 2409973 | 2022-04-15 | Perry | Missouri | 29157 | 4989 | 45 |
2406668 | 2406668 | 2022-04-14 | DeKalb | Missouri | 29063 | 2204 | 45 |
2406717 | 2406717 | 2022-04-14 | Perry | Missouri | 29157 | 4989 | 45 |
2403412 | 2403412 | 2022-04-13 | DeKalb | Missouri | 29063 | 2204 | 45 |
2403461 | 2403461 | 2022-04-13 | Perry | Missouri | 29157 | 4989 | 45 |
2400157 | 2400157 | 2022-04-12 | DeKalb | Missouri | 29063 | 2204 | 45 |
2400206 | 2400206 | 2022-04-12 | Perry | Missouri | 29157 | 4989 | 45 |
2396902 | 2396902 | 2022-04-11 | DeKalb | Missouri | 29063 | 2204 | 45 |
2396951 | 2396951 | 2022-04-11 | Perry | Missouri | 29157 | 4989 | 45 |
2393647 | 2393647 | 2022-04-10 | DeKalb | Missouri | 29063 | 2204 | 45 |
2393696 | 2393696 | 2022-04-10 | Perry | Missouri | 29157 | 4989 | 45 |
2390391 | 2390391 | 2022-04-09 | DeKalb | Missouri | 29063 | 2204 | 45 |
2390440 | 2390440 | 2022-04-09 | Perry | Missouri | 29157 | 4989 | 45 |
2387135 | 2387135 | 2022-04-08 | DeKalb | Missouri | 29063 | 2204 | 45 |
2387184 | 2387184 | 2022-04-08 | Perry | Missouri | 29157 | 4989 | 45 |
2383880 | 2383880 | 2022-04-07 | DeKalb | Missouri | 29063 | 2204 | 45 |
2383929 | 2383929 | 2022-04-07 | Perry | Missouri | 29157 | 4989 | 45 |
2380625 | 2380625 | 2022-04-06 | DeKalb | Missouri | 29063 | 2204 | 45 |
2380674 | 2380674 | 2022-04-06 | Perry | Missouri | 29157 | 4989 | 45 |
2377370 | 2377370 | 2022-04-05 | DeKalb | Missouri | 29063 | 2204 | 45 |
2377419 | 2377419 | 2022-04-05 | Perry | Missouri | 29157 | 4989 | 45 |
2374117 | 2374117 | 2022-04-04 | DeKalb | Missouri | 29063 | 2204 | 45 |
2374166 | 2374166 | 2022-04-04 | Perry | Missouri | 29157 | 4989 | 45 |
2370865 | 2370865 | 2022-04-03 | DeKalb | Missouri | 29063 | 2204 | 45 |
2370914 | 2370914 | 2022-04-03 | Perry | Missouri | 29157 | 4989 | 45 |
2367612 | 2367612 | 2022-04-02 | DeKalb | Missouri | 29063 | 2204 | 45 |
2367661 | 2367661 | 2022-04-02 | Perry | Missouri | 29157 | 4989 | 45 |
2364359 | 2364359 | 2022-04-01 | DeKalb | Missouri | 29063 | 2204 | 45 |
2364408 | 2364408 | 2022-04-01 | Perry | Missouri | 29157 | 4989 | 45 |
2361105 | 2361105 | 2022-03-31 | DeKalb | Missouri | 29063 | 2204 | 45 |
2361154 | 2361154 | 2022-03-31 | Perry | Missouri | 29157 | 4989 | 45 |
2357851 | 2357851 | 2022-03-30 | DeKalb | Missouri | 29063 | 2204 | 45 |
2357900 | 2357900 | 2022-03-30 | Perry | Missouri | 29157 | 4984 | 45 |
2354598 | 2354598 | 2022-03-29 | DeKalb | Missouri | 29063 | 2203 | 45 |
2354647 | 2354647 | 2022-03-29 | Perry | Missouri | 29157 | 4980 | 45 |
2351345 | 2351345 | 2022-03-28 | DeKalb | Missouri | 29063 | 2203 | 45 |
2351394 | 2351394 | 2022-03-28 | Perry | Missouri | 29157 | 4970 | 45 |
2348093 | 2348093 | 2022-03-27 | DeKalb | Missouri | 29063 | 2203 | 45 |
2348142 | 2348142 | 2022-03-27 | Perry | Missouri | 29157 | 4963 | 45 |
2344840 | 2344840 | 2022-03-26 | DeKalb | Missouri | 29063 | 2203 | 45 |
2344889 | 2344889 | 2022-03-26 | Perry | Missouri | 29157 | 4963 | 45 |
2341587 | 2341587 | 2022-03-25 | DeKalb | Missouri | 29063 | 2203 | 45 |
2341636 | 2341636 | 2022-03-25 | Perry | Missouri | 29157 | 4963 | 45 |
2338334 | 2338334 | 2022-03-24 | DeKalb | Missouri | 29063 | 2204 | 45 |
2338383 | 2338383 | 2022-03-24 | Perry | Missouri | 29157 | 4948 | 45 |
2335080 | 2335080 | 2022-03-23 | DeKalb | Missouri | 29063 | 2192 | 45 |
2335129 | 2335129 | 2022-03-23 | Perry | Missouri | 29157 | 4945 | 45 |
2331826 | 2331826 | 2022-03-22 | DeKalb | Missouri | 29063 | 2190 | 45 |
2331875 | 2331875 | 2022-03-22 | Perry | Missouri | 29157 | 4942 | 45 |
2328573 | 2328573 | 2022-03-21 | DeKalb | Missouri | 29063 | 2187 | 45 |
2325321 | 2325321 | 2022-03-20 | DeKalb | Missouri | 29063 | 2177 | 45 |
2322067 | 2322067 | 2022-03-19 | DeKalb | Missouri | 29063 | 2177 | 45 |
2318813 | 2318813 | 2022-03-18 | DeKalb | Missouri | 29063 | 2177 | 45 |
2315560 | 2315560 | 2022-03-17 | DeKalb | Missouri | 29063 | 2176 | 45 |
2312307 | 2312307 | 2022-03-16 | DeKalb | Missouri | 29063 | 2175 | 45 |
2309054 | 2309054 | 2022-03-15 | DeKalb | Missouri | 29063 | 2174 | 45 |
2305802 | 2305802 | 2022-03-14 | DeKalb | Missouri | 29063 | 2174 | 45 |
2279786 | 2279786 | 2022-03-06 | DeKalb | Missouri | 29063 | 2135 | 45 |
2276533 | 2276533 | 2022-03-05 | DeKalb | Missouri | 29063 | 2135 | 45 |
2273280 | 2273280 | 2022-03-04 | DeKalb | Missouri | 29063 | 2135 | 45 |
2270028 | 2270028 | 2022-03-03 | DeKalb | Missouri | 29063 | 2135 | 45 |
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);