ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where deaths = 85 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 18
county 18
- New Madrid 44
- Camden 14
- Livingston 8
- Benton 7
- Morgan 7
- Randolph 7
- Saline 7
- Scott 4
- Warren 4
- Jackson 3
- Phelps 3
- Joplin 2
- Stone 2
- Webster 2
- Boone 1
- Christian 1
- St. Charles 1
- St. Louis city 1
state 1
- Missouri · 118 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471829 | 2471829 | 2022-05-04 | New Madrid | Missouri | 29143 | 5030 | 85 |
2468573 | 2468573 | 2022-05-03 | New Madrid | Missouri | 29143 | 5030 | 85 |
2465317 | 2465317 | 2022-05-02 | New Madrid | Missouri | 29143 | 5030 | 85 |
2462062 | 2462062 | 2022-05-01 | New Madrid | Missouri | 29143 | 5030 | 85 |
2458806 | 2458806 | 2022-04-30 | New Madrid | Missouri | 29143 | 5030 | 85 |
2455550 | 2455550 | 2022-04-29 | New Madrid | Missouri | 29143 | 5030 | 85 |
2452294 | 2452294 | 2022-04-28 | New Madrid | Missouri | 29143 | 5030 | 85 |
2449038 | 2449038 | 2022-04-27 | New Madrid | Missouri | 29143 | 5030 | 85 |
2445781 | 2445781 | 2022-04-26 | New Madrid | Missouri | 29143 | 5030 | 85 |
2442526 | 2442526 | 2022-04-25 | New Madrid | Missouri | 29143 | 5030 | 85 |
2439270 | 2439270 | 2022-04-24 | New Madrid | Missouri | 29143 | 5030 | 85 |
2436014 | 2436014 | 2022-04-23 | New Madrid | Missouri | 29143 | 5030 | 85 |
2432758 | 2432758 | 2022-04-22 | New Madrid | Missouri | 29143 | 5030 | 85 |
2429502 | 2429502 | 2022-04-21 | New Madrid | Missouri | 29143 | 5030 | 85 |
2426246 | 2426246 | 2022-04-20 | New Madrid | Missouri | 29143 | 5030 | 85 |
2422990 | 2422990 | 2022-04-19 | New Madrid | Missouri | 29143 | 5030 | 85 |
2419733 | 2419733 | 2022-04-18 | New Madrid | Missouri | 29143 | 5030 | 85 |
2416478 | 2416478 | 2022-04-17 | New Madrid | Missouri | 29143 | 5030 | 85 |
2413222 | 2413222 | 2022-04-16 | New Madrid | Missouri | 29143 | 5030 | 85 |
2409966 | 2409966 | 2022-04-15 | New Madrid | Missouri | 29143 | 5030 | 85 |
2406710 | 2406710 | 2022-04-14 | New Madrid | Missouri | 29143 | 5030 | 85 |
2403454 | 2403454 | 2022-04-13 | New Madrid | Missouri | 29143 | 5030 | 85 |
2400199 | 2400199 | 2022-04-12 | New Madrid | Missouri | 29143 | 5030 | 85 |
2396944 | 2396944 | 2022-04-11 | New Madrid | Missouri | 29143 | 5030 | 85 |
2393689 | 2393689 | 2022-04-10 | New Madrid | Missouri | 29143 | 5030 | 85 |
2390433 | 2390433 | 2022-04-09 | New Madrid | Missouri | 29143 | 5030 | 85 |
2387177 | 2387177 | 2022-04-08 | New Madrid | Missouri | 29143 | 5030 | 85 |
2383922 | 2383922 | 2022-04-07 | New Madrid | Missouri | 29143 | 5030 | 85 |
2380667 | 2380667 | 2022-04-06 | New Madrid | Missouri | 29143 | 5030 | 85 |
2377412 | 2377412 | 2022-04-05 | New Madrid | Missouri | 29143 | 5030 | 85 |
2374159 | 2374159 | 2022-04-04 | New Madrid | Missouri | 29143 | 5030 | 85 |
2370907 | 2370907 | 2022-04-03 | New Madrid | Missouri | 29143 | 5030 | 85 |
2367654 | 2367654 | 2022-04-02 | New Madrid | Missouri | 29143 | 5030 | 85 |
2364401 | 2364401 | 2022-04-01 | New Madrid | Missouri | 29143 | 5030 | 85 |
2361147 | 2361147 | 2022-03-31 | New Madrid | Missouri | 29143 | 5030 | 85 |
2357893 | 2357893 | 2022-03-30 | New Madrid | Missouri | 29143 | 5028 | 85 |
2354640 | 2354640 | 2022-03-29 | New Madrid | Missouri | 29143 | 5028 | 85 |
2351387 | 2351387 | 2022-03-28 | New Madrid | Missouri | 29143 | 5028 | 85 |
2348135 | 2348135 | 2022-03-27 | New Madrid | Missouri | 29143 | 5028 | 85 |
2344882 | 2344882 | 2022-03-26 | New Madrid | Missouri | 29143 | 5028 | 85 |
2341629 | 2341629 | 2022-03-25 | New Madrid | Missouri | 29143 | 5028 | 85 |
2338376 | 2338376 | 2022-03-24 | New Madrid | Missouri | 29143 | 5023 | 85 |
2335122 | 2335122 | 2022-03-23 | New Madrid | Missouri | 29143 | 5022 | 85 |
2331868 | 2331868 | 2022-03-22 | New Madrid | Missouri | 29143 | 5022 | 85 |
2191962 | 2191962 | 2022-02-07 | Benton | Missouri | 29015 | 3959 | 85 |
2188709 | 2188709 | 2022-02-06 | Benton | Missouri | 29015 | 3952 | 85 |
2185456 | 2185456 | 2022-02-05 | Benton | Missouri | 29015 | 3937 | 85 |
2182204 | 2182204 | 2022-02-04 | Benton | Missouri | 29015 | 3925 | 85 |
2178952 | 2178952 | 2022-02-03 | Benton | Missouri | 29015 | 3922 | 85 |
2175700 | 2175700 | 2022-02-02 | Benton | Missouri | 29015 | 3898 | 85 |
2172447 | 2172447 | 2022-02-01 | Benton | Missouri | 29015 | 3849 | 85 |
2169259 | 2169259 | 2022-01-31 | Morgan | Missouri | 29141 | 3814 | 85 |
2166004 | 2166004 | 2022-01-30 | Morgan | Missouri | 29141 | 3803 | 85 |
2162749 | 2162749 | 2022-01-29 | Morgan | Missouri | 29141 | 3798 | 85 |
2159482 | 2159482 | 2022-01-28 | Livingston | Missouri | 29117 | 3433 | 85 |
2159494 | 2159494 | 2022-01-28 | Morgan | Missouri | 29141 | 3786 | 85 |
2156228 | 2156228 | 2022-01-27 | Livingston | Missouri | 29117 | 3403 | 85 |
2156240 | 2156240 | 2022-01-27 | Morgan | Missouri | 29141 | 3752 | 85 |
2152975 | 2152975 | 2022-01-26 | Livingston | Missouri | 29117 | 3373 | 85 |
2152987 | 2152987 | 2022-01-26 | Morgan | Missouri | 29141 | 3710 | 85 |
2149723 | 2149723 | 2022-01-25 | Livingston | Missouri | 29117 | 3337 | 85 |
2149735 | 2149735 | 2022-01-25 | Morgan | Missouri | 29141 | 3673 | 85 |
2146471 | 2146471 | 2022-01-24 | Livingston | Missouri | 29117 | 3274 | 85 |
2143216 | 2143216 | 2022-01-23 | Livingston | Missouri | 29117 | 3267 | 85 |
2139961 | 2139961 | 2022-01-22 | Livingston | Missouri | 29117 | 3244 | 85 |
2136705 | 2136705 | 2022-01-21 | Livingston | Missouri | 29117 | 3206 | 85 |
2126997 | 2126997 | 2022-01-18 | Warren | Missouri | 29219 | 7250 | 85 |
2123745 | 2123745 | 2022-01-17 | Warren | Missouri | 29219 | 7064 | 85 |
2120493 | 2120493 | 2022-01-16 | Warren | Missouri | 29219 | 7064 | 85 |
2117241 | 2117241 | 2022-01-15 | Warren | Missouri | 29219 | 7064 | 85 |
2078201 | 2078201 | 2022-01-03 | Randolph | Missouri | 29175 | 4356 | 85 |
2074950 | 2074950 | 2022-01-02 | Randolph | Missouri | 29175 | 4298 | 85 |
2071699 | 2071699 | 2022-01-01 | Randolph | Missouri | 29175 | 4298 | 85 |
2068448 | 2068448 | 2021-12-31 | Randolph | Missouri | 29175 | 4298 | 85 |
2065197 | 2065197 | 2021-12-30 | Randolph | Missouri | 29175 | 4298 | 85 |
2061947 | 2061947 | 2021-12-29 | Randolph | Missouri | 29175 | 4266 | 85 |
2058698 | 2058698 | 2021-12-28 | Randolph | Missouri | 29175 | 4248 | 85 |
2055453 | 2055453 | 2021-12-27 | Saline | Missouri | 29195 | 4638 | 85 |
2052203 | 2052203 | 2021-12-26 | Saline | Missouri | 29195 | 4615 | 85 |
2048953 | 2048953 | 2021-12-25 | Saline | Missouri | 29195 | 4615 | 85 |
2045703 | 2045703 | 2021-12-24 | Saline | Missouri | 29195 | 4615 | 85 |
2042453 | 2042453 | 2021-12-23 | Saline | Missouri | 29195 | 4615 | 85 |
2039204 | 2039204 | 2021-12-22 | Saline | Missouri | 29195 | 4592 | 85 |
2035954 | 2035954 | 2021-12-21 | Saline | Missouri | 29195 | 4577 | 85 |
1814969 | 1814969 | 2021-10-14 | Stone | Missouri | 29209 | 3905 | 85 |
1811721 | 1811721 | 2021-10-13 | Stone | Missouri | 29209 | 3902 | 85 |
1746747 | 1746747 | 2021-09-23 | Webster | Missouri | 29225 | 5487 | 85 |
1743498 | 1743498 | 2021-09-22 | Webster | Missouri | 29225 | 5476 | 85 |
1350563 | 1350563 | 2021-05-24 | Scott | Missouri | 29201 | 4714 | 85 |
1347317 | 1347317 | 2021-05-23 | Scott | Missouri | 29201 | 4714 | 85 |
1344069 | 1344069 | 2021-05-22 | Scott | Missouri | 29201 | 4714 | 85 |
1340820 | 1340820 | 2021-05-21 | Scott | Missouri | 29201 | 4714 | 85 |
1214110 | 1214110 | 2021-04-12 | Camden | Missouri | 29029 | 4045 | 85 |
1210862 | 1210862 | 2021-04-11 | Camden | Missouri | 29029 | 4044 | 85 |
1207613 | 1207613 | 2021-04-10 | Camden | Missouri | 29029 | 4044 | 85 |
1204365 | 1204365 | 2021-04-09 | Camden | Missouri | 29029 | 4037 | 85 |
1201117 | 1201117 | 2021-04-08 | Camden | Missouri | 29029 | 4028 | 85 |
1197868 | 1197868 | 2021-04-07 | Camden | Missouri | 29029 | 4022 | 85 |
1194619 | 1194619 | 2021-04-06 | Camden | Missouri | 29029 | 4019 | 85 |
1191370 | 1191370 | 2021-04-05 | Camden | Missouri | 29029 | 4012 | 85 |
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);