ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 155 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Missouri · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305852 | 2305852 | 2022-03-14 | Pettis | Missouri | 29159 | 11935 | 155 |
2302601 | 2302601 | 2022-03-13 | Pettis | Missouri | 29159 | 11883 | 155 |
2299349 | 2299349 | 2022-03-12 | Pettis | Missouri | 29159 | 11883 | 155 |
2296097 | 2296097 | 2022-03-11 | Pettis | Missouri | 29159 | 11883 | 155 |
2292845 | 2292845 | 2022-03-10 | Pettis | Missouri | 29159 | 11882 | 155 |
2289593 | 2289593 | 2022-03-09 | Pettis | Missouri | 29159 | 11861 | 155 |
2286341 | 2286341 | 2022-03-08 | Pettis | Missouri | 29159 | 11860 | 155 |
2126900 | 2126900 | 2022-01-18 | Camden | Missouri | 29029 | 7896 | 155 |
2126940 | 2126940 | 2022-01-18 | Laclede | Missouri | 29105 | 6782 | 155 |
2123648 | 2123648 | 2022-01-17 | Camden | Missouri | 29029 | 7769 | 155 |
2123688 | 2123688 | 2022-01-17 | Laclede | Missouri | 29105 | 6643 | 155 |
2120396 | 2120396 | 2022-01-16 | Camden | Missouri | 29029 | 7769 | 155 |
2120436 | 2120436 | 2022-01-16 | Laclede | Missouri | 29105 | 6643 | 155 |
2117144 | 2117144 | 2022-01-15 | Camden | Missouri | 29029 | 7769 | 155 |
2117184 | 2117184 | 2022-01-15 | Laclede | Missouri | 29105 | 6643 | 155 |
2113893 | 2113893 | 2022-01-14 | Camden | Missouri | 29029 | 7681 | 155 |
2113933 | 2113933 | 2022-01-14 | Laclede | Missouri | 29105 | 6563 | 155 |
2110641 | 2110641 | 2022-01-13 | Camden | Missouri | 29029 | 7601 | 155 |
2110681 | 2110681 | 2022-01-13 | Laclede | Missouri | 29105 | 6502 | 155 |
2107390 | 2107390 | 2022-01-12 | Camden | Missouri | 29029 | 7521 | 155 |
2107430 | 2107430 | 2022-01-12 | Laclede | Missouri | 29105 | 6433 | 155 |
2104139 | 2104139 | 2022-01-11 | Camden | Missouri | 29029 | 7468 | 155 |
2104179 | 2104179 | 2022-01-11 | Laclede | Missouri | 29105 | 6363 | 155 |
1782382 | 1782382 | 2021-10-04 | Boone | Missouri | 29019 | 24712 | 155 |
1623270 | 1623270 | 2021-08-16 | Phelps | Missouri | 29161 | 5260 | 155 |
1620023 | 1620023 | 2021-08-15 | Phelps | Missouri | 29161 | 5241 | 155 |
1616775 | 1616775 | 2021-08-14 | Phelps | Missouri | 29161 | 5227 | 155 |
1613527 | 1613527 | 2021-08-13 | Phelps | Missouri | 29161 | 5200 | 155 |
1145917 | 1145917 | 2021-03-22 | Clay | Missouri | 29047 | 9838 | 155 |
1142670 | 1142670 | 2021-03-21 | Clay | Missouri | 29047 | 9809 | 155 |
1139423 | 1139423 | 2021-03-20 | Clay | Missouri | 29047 | 9809 | 155 |
1136177 | 1136177 | 2021-03-19 | Clay | Missouri | 29047 | 9809 | 155 |
1132931 | 1132931 | 2021-03-18 | Clay | Missouri | 29047 | 9792 | 155 |
1129683 | 1129683 | 2021-03-17 | Clay | Missouri | 29047 | 9792 | 155 |
736992 | 736992 | 2020-11-16 | Jackson | Missouri | 29095 | 13966 | 155 |
285502 | 285502 | 2020-06-29 | St. Louis city | Missouri | 29510 | 2453 | 155 |
282357 | 282357 | 2020-06-28 | St. Louis city | Missouri | 29510 | 2406 | 155 |
279209 | 279209 | 2020-06-27 | St. Louis city | Missouri | 29510 | 2353 | 155 |
276061 | 276061 | 2020-06-26 | St. Louis city | Missouri | 29510 | 2323 | 155 |
272918 | 272918 | 2020-06-25 | St. Louis city | Missouri | 29510 | 2310 | 155 |
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);