ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where deaths = 174 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Missouri · 51 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351368 | 2351368 | 2022-03-28 | Laclede | Missouri | 29105 | 8097 | 174 |
2348116 | 2348116 | 2022-03-27 | Laclede | Missouri | 29105 | 8095 | 174 |
2344863 | 2344863 | 2022-03-26 | Laclede | Missouri | 29105 | 8095 | 174 |
2341610 | 2341610 | 2022-03-25 | Laclede | Missouri | 29105 | 8095 | 174 |
2338357 | 2338357 | 2022-03-24 | Laclede | Missouri | 29105 | 8095 | 174 |
2335103 | 2335103 | 2022-03-23 | Laclede | Missouri | 29105 | 8092 | 174 |
2331849 | 2331849 | 2022-03-22 | Laclede | Missouri | 29105 | 8092 | 174 |
2328596 | 2328596 | 2022-03-21 | Laclede | Missouri | 29105 | 8090 | 174 |
2325344 | 2325344 | 2022-03-20 | Laclede | Missouri | 29105 | 8087 | 174 |
2322090 | 2322090 | 2022-03-19 | Laclede | Missouri | 29105 | 8087 | 174 |
2318836 | 2318836 | 2022-03-18 | Laclede | Missouri | 29105 | 8087 | 174 |
2315583 | 2315583 | 2022-03-17 | Laclede | Missouri | 29105 | 8085 | 174 |
2312330 | 2312330 | 2022-03-16 | Laclede | Missouri | 29105 | 8087 | 174 |
2309077 | 2309077 | 2022-03-15 | Laclede | Missouri | 29105 | 8083 | 174 |
2133467 | 2133467 | 2022-01-20 | Newton | Missouri | 29145 | 9969 | 174 |
2130214 | 2130214 | 2022-01-19 | Newton | Missouri | 29145 | 9844 | 174 |
2055405 | 2055405 | 2021-12-27 | Howell | Missouri | 29091 | 6491 | 174 |
2052155 | 2052155 | 2021-12-26 | Howell | Missouri | 29091 | 6482 | 174 |
2048905 | 2048905 | 2021-12-25 | Howell | Missouri | 29091 | 6482 | 174 |
2045655 | 2045655 | 2021-12-24 | Howell | Missouri | 29091 | 6482 | 174 |
2042405 | 2042405 | 2021-12-23 | Howell | Missouri | 29091 | 6482 | 174 |
2039156 | 2039156 | 2021-12-22 | Howell | Missouri | 29091 | 6472 | 174 |
2035906 | 2035906 | 2021-12-21 | Howell | Missouri | 29091 | 6468 | 174 |
2032656 | 2032656 | 2021-12-20 | Howell | Missouri | 29091 | 6446 | 174 |
2029405 | 2029405 | 2021-12-19 | Howell | Missouri | 29091 | 6443 | 174 |
2026154 | 2026154 | 2021-12-18 | Howell | Missouri | 29091 | 6436 | 174 |
2022903 | 2022903 | 2021-12-17 | Howell | Missouri | 29091 | 6426 | 174 |
2019652 | 2019652 | 2021-12-16 | Howell | Missouri | 29091 | 6413 | 174 |
2016402 | 2016402 | 2021-12-15 | Howell | Missouri | 29091 | 6390 | 174 |
1918851 | 1918851 | 2021-11-15 | Boone | Missouri | 29019 | 26010 | 174 |
1915601 | 1915601 | 2021-11-14 | Boone | Missouri | 29019 | 25909 | 174 |
1912351 | 1912351 | 2021-11-13 | Boone | Missouri | 29019 | 25909 | 174 |
1909101 | 1909101 | 2021-11-12 | Boone | Missouri | 29019 | 25909 | 174 |
1905852 | 1905852 | 2021-11-11 | Boone | Missouri | 29019 | 25875 | 174 |
1902603 | 1902603 | 2021-11-10 | Boone | Missouri | 29019 | 25850 | 174 |
1899353 | 1899353 | 2021-11-09 | Boone | Missouri | 29019 | 25792 | 174 |
1896103 | 1896103 | 2021-11-08 | Boone | Missouri | 29019 | 25757 | 174 |
1892853 | 1892853 | 2021-11-07 | Boone | Missouri | 29019 | 25702 | 174 |
1889603 | 1889603 | 2021-11-06 | Boone | Missouri | 29019 | 25702 | 174 |
1886353 | 1886353 | 2021-11-05 | Boone | Missouri | 29019 | 25702 | 174 |
1769456 | 1769456 | 2021-09-30 | Phelps | Missouri | 29161 | 5992 | 174 |
1490055 | 1490055 | 2021-07-06 | Clay | Missouri | 29047 | 10559 | 174 |
1486808 | 1486808 | 2021-07-05 | Clay | Missouri | 29047 | 10550 | 174 |
1483562 | 1483562 | 2021-07-04 | Clay | Missouri | 29047 | 10540 | 174 |
1480316 | 1480316 | 2021-07-03 | Clay | Missouri | 29047 | 10531 | 174 |
1477069 | 1477069 | 2021-07-02 | Clay | Missouri | 29047 | 10528 | 174 |
1473823 | 1473823 | 2021-07-01 | Clay | Missouri | 29047 | 10508 | 174 |
1470577 | 1470577 | 2021-06-30 | Clay | Missouri | 29047 | 10490 | 174 |
1467332 | 1467332 | 2021-06-29 | Clay | Missouri | 29047 | 10467 | 174 |
416491 | 416491 | 2020-08-09 | St. Louis city | Missouri | 29510 | 5200 | 174 |
413271 | 413271 | 2020-08-08 | St. Louis city | Missouri | 29510 | 5139 | 174 |
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);