ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where deaths = 185 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Missouri · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1977401 | 1977401 | 2021-12-03 | Joplin | Missouri | 9181 | 185 | |
1974151 | 1974151 | 2021-12-02 | Joplin | Missouri | 9181 | 185 | |
1970902 | 1970902 | 2021-12-01 | Joplin | Missouri | 9158 | 185 | |
1967652 | 1967652 | 2021-11-30 | Joplin | Missouri | 9133 | 185 | |
1905925 | 1905925 | 2021-11-11 | Phelps | Missouri | 29161 | 6317 | 185 |
1902676 | 1902676 | 2021-11-10 | Phelps | Missouri | 29161 | 6317 | 185 |
1899426 | 1899426 | 2021-11-09 | Phelps | Missouri | 29161 | 6307 | 185 |
1896176 | 1896176 | 2021-11-08 | Phelps | Missouri | 29161 | 6296 | 185 |
1892926 | 1892926 | 2021-11-07 | Phelps | Missouri | 29161 | 6290 | 185 |
1889676 | 1889676 | 2021-11-06 | Phelps | Missouri | 29161 | 6289 | 185 |
1782421 | 1782421 | 2021-10-04 | Jasper | Missouri | 29097 | 13458 | 185 |
1779171 | 1779171 | 2021-10-03 | Jasper | Missouri | 29097 | 13452 | 185 |
1775921 | 1775921 | 2021-10-02 | Jasper | Missouri | 29097 | 13445 | 185 |
1668687 | 1668687 | 2021-08-30 | Clay | Missouri | 29047 | 12797 | 185 |
1665440 | 1665440 | 2021-08-29 | Clay | Missouri | 29047 | 12771 | 185 |
1662192 | 1662192 | 2021-08-28 | Clay | Missouri | 29047 | 12740 | 185 |
1658944 | 1658944 | 2021-08-27 | Clay | Missouri | 29047 | 12699 | 185 |
1655695 | 1655695 | 2021-08-26 | Clay | Missouri | 29047 | 12638 | 185 |
1652448 | 1652448 | 2021-08-25 | Clay | Missouri | 29047 | 12579 | 185 |
1649200 | 1649200 | 2021-08-24 | Clay | Missouri | 29047 | 12524 | 185 |
1460829 | 1460829 | 2021-06-27 | Buchanan | Missouri | 29021 | 10914 | 185 |
1457584 | 1457584 | 2021-06-26 | Buchanan | Missouri | 29021 | 10914 | 185 |
1454339 | 1454339 | 2021-06-25 | Buchanan | Missouri | 29021 | 10914 | 185 |
1451094 | 1451094 | 2021-06-24 | Buchanan | Missouri | 29021 | 10914 | 185 |
1447848 | 1447848 | 2021-06-23 | Buchanan | Missouri | 29021 | 10808 | 185 |
1444603 | 1444603 | 2021-06-22 | Buchanan | Missouri | 29021 | 10808 | 185 |
1441358 | 1441358 | 2021-06-21 | Buchanan | Missouri | 29021 | 10808 | 185 |
1438112 | 1438112 | 2021-06-20 | Buchanan | Missouri | 29021 | 10762 | 185 |
1434865 | 1434865 | 2021-06-19 | Buchanan | Missouri | 29021 | 10762 | 185 |
1431618 | 1431618 | 2021-06-18 | Buchanan | Missouri | 29021 | 10762 | 185 |
1428373 | 1428373 | 2021-06-17 | Buchanan | Missouri | 29021 | 10762 | 185 |
1418660 | 1418660 | 2021-06-14 | Franklin | Missouri | 29071 | 10802 | 185 |
1415415 | 1415415 | 2021-06-13 | Franklin | Missouri | 29071 | 10798 | 185 |
1412169 | 1412169 | 2021-06-12 | Franklin | Missouri | 29071 | 10790 | 185 |
1408924 | 1408924 | 2021-06-11 | Franklin | Missouri | 29071 | 10784 | 185 |
1405679 | 1405679 | 2021-06-10 | Franklin | Missouri | 29071 | 10777 | 185 |
1402433 | 1402433 | 2021-06-09 | Franklin | Missouri | 29071 | 10764 | 185 |
1399188 | 1399188 | 2021-06-08 | Franklin | Missouri | 29071 | 10761 | 185 |
1395942 | 1395942 | 2021-06-07 | Franklin | Missouri | 29071 | 10757 | 185 |
1392696 | 1392696 | 2021-06-06 | Franklin | Missouri | 29071 | 10754 | 185 |
1389451 | 1389451 | 2021-06-05 | Franklin | Missouri | 29071 | 10754 | 185 |
1386206 | 1386206 | 2021-06-04 | Franklin | Missouri | 29071 | 10749 | 185 |
1382961 | 1382961 | 2021-06-03 | Franklin | Missouri | 29071 | 10744 | 185 |
1379715 | 1379715 | 2021-06-02 | Franklin | Missouri | 29071 | 10740 | 185 |
792166 | 792166 | 2020-12-03 | Jackson | Missouri | 29095 | 18081 | 185 |
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);