ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 182 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 7
- Buchanan 7
- Phelps 4
- Clay 3
- Jasper 3
- Jefferson 2
- St. Charles 2
- St. Louis city 1
state 1
- Missouri · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850687 | 1850687 | 2021-10-25 | Phelps | Missouri | 29161 | 6188 | 182 |
1847437 | 1847437 | 2021-10-24 | Phelps | Missouri | 29161 | 6185 | 182 |
1844187 | 1844187 | 2021-10-23 | Phelps | Missouri | 29161 | 6178 | 182 |
1840937 | 1840937 | 2021-10-22 | Phelps | Missouri | 29161 | 6170 | 182 |
1759675 | 1759675 | 2021-09-27 | Jasper | Missouri | 29097 | 13375 | 182 |
1756427 | 1756427 | 2021-09-26 | Jasper | Missouri | 29097 | 13372 | 182 |
1753179 | 1753179 | 2021-09-25 | Jasper | Missouri | 29097 | 13366 | 182 |
1623211 | 1623211 | 2021-08-16 | Clay | Missouri | 29047 | 12100 | 182 |
1619964 | 1619964 | 2021-08-15 | Clay | Missouri | 29047 | 12079 | 182 |
1616716 | 1616716 | 2021-08-14 | Clay | Missouri | 29047 | 12033 | 182 |
1356969 | 1356969 | 2021-05-26 | Buchanan | Missouri | 29021 | 10554 | 182 |
1353723 | 1353723 | 2021-05-25 | Buchanan | Missouri | 29021 | 10554 | 182 |
1350477 | 1350477 | 2021-05-24 | Buchanan | Missouri | 29021 | 10548 | 182 |
1347231 | 1347231 | 2021-05-23 | Buchanan | Missouri | 29021 | 10548 | 182 |
1343983 | 1343983 | 2021-05-22 | Buchanan | Missouri | 29021 | 10548 | 182 |
1340734 | 1340734 | 2021-05-21 | Buchanan | Missouri | 29021 | 10548 | 182 |
1337487 | 1337487 | 2021-05-20 | Buchanan | Missouri | 29021 | 10548 | 182 |
999876 | 999876 | 2021-02-05 | Jefferson | Missouri | 29099 | 20918 | 182 |
996630 | 996630 | 2021-02-04 | Jefferson | Missouri | 29099 | 20857 | 182 |
740288 | 740288 | 2020-11-17 | St. Charles | Missouri | 29183 | 17809 | 182 |
737044 | 737044 | 2020-11-16 | St. Charles | Missouri | 29183 | 17327 | 182 |
455193 | 455193 | 2020-08-21 | St. Louis city | Missouri | 29510 | 5816 | 182 |
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);