ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where deaths = 154 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283019 | 2283019 | 2022-03-07 | Butler | Missouri | 29023 | 9919 | 154 |
2283089 | 2283089 | 2022-03-07 | Pettis | Missouri | 29159 | 11845 | 154 |
2279766 | 2279766 | 2022-03-06 | Butler | Missouri | 29023 | 9917 | 154 |
2279836 | 2279836 | 2022-03-06 | Pettis | Missouri | 29159 | 11843 | 154 |
2276513 | 2276513 | 2022-03-05 | Butler | Missouri | 29023 | 9917 | 154 |
2276583 | 2276583 | 2022-03-05 | Pettis | Missouri | 29159 | 11843 | 154 |
2273260 | 2273260 | 2022-03-04 | Butler | Missouri | 29023 | 9917 | 154 |
2273330 | 2273330 | 2022-03-04 | Pettis | Missouri | 29159 | 11843 | 154 |
2270008 | 2270008 | 2022-03-03 | Butler | Missouri | 29023 | 9912 | 154 |
2270078 | 2270078 | 2022-03-03 | Pettis | Missouri | 29159 | 11842 | 154 |
2266755 | 2266755 | 2022-03-02 | Butler | Missouri | 29023 | 9907 | 154 |
2266825 | 2266825 | 2022-03-02 | Pettis | Missouri | 29159 | 11835 | 154 |
2263504 | 2263504 | 2022-03-01 | Butler | Missouri | 29023 | 9904 | 154 |
2263574 | 2263574 | 2022-03-01 | Pettis | Missouri | 29159 | 11821 | 154 |
2100928 | 2100928 | 2022-01-10 | Laclede | Missouri | 29105 | 6320 | 154 |
2097677 | 2097677 | 2022-01-09 | Laclede | Missouri | 29105 | 6303 | 154 |
2094425 | 2094425 | 2022-01-08 | Laclede | Missouri | 29105 | 6287 | 154 |
2091173 | 2091173 | 2022-01-07 | Laclede | Missouri | 29105 | 6245 | 154 |
2087922 | 2087922 | 2022-01-06 | Laclede | Missouri | 29105 | 6193 | 154 |
2084670 | 2084670 | 2022-01-05 | Laclede | Missouri | 29105 | 6147 | 154 |
2081418 | 2081418 | 2022-01-04 | Laclede | Missouri | 29105 | 6106 | 154 |
1925449 | 1925449 | 2021-11-17 | Taney | Missouri | 29213 | 9113 | 154 |
1922200 | 1922200 | 2021-11-16 | Taney | Missouri | 29213 | 9106 | 154 |
1808384 | 1808384 | 2021-10-12 | Cass | Missouri | 29037 | 13989 | 154 |
1805133 | 1805133 | 2021-10-11 | Cass | Missouri | 29037 | 13957 | 154 |
1801884 | 1801884 | 2021-10-10 | Cass | Missouri | 29037 | 13946 | 154 |
1798635 | 1798635 | 2021-10-09 | Cass | Missouri | 29037 | 13918 | 154 |
1795386 | 1795386 | 2021-10-08 | Cass | Missouri | 29037 | 13889 | 154 |
1792137 | 1792137 | 2021-10-07 | Cass | Missouri | 29037 | 13855 | 154 |
1788888 | 1788888 | 2021-10-06 | Cass | Missouri | 29037 | 13829 | 154 |
1785640 | 1785640 | 2021-10-05 | Cass | Missouri | 29037 | 13787 | 154 |
1782394 | 1782394 | 2021-10-04 | Christian | Missouri | 29043 | 12651 | 154 |
1779132 | 1779132 | 2021-10-03 | Boone | Missouri | 29019 | 24620 | 154 |
1779144 | 1779144 | 2021-10-03 | Christian | Missouri | 29043 | 12642 | 154 |
1775882 | 1775882 | 2021-10-02 | Boone | Missouri | 29019 | 24620 | 154 |
1775894 | 1775894 | 2021-10-02 | Christian | Missouri | 29043 | 12636 | 154 |
1772632 | 1772632 | 2021-10-01 | Boone | Missouri | 29019 | 24620 | 154 |
1772644 | 1772644 | 2021-10-01 | Christian | Missouri | 29043 | 12617 | 154 |
1769395 | 1769395 | 2021-09-30 | Christian | Missouri | 29043 | 12604 | 154 |
1766146 | 1766146 | 2021-09-29 | Christian | Missouri | 29043 | 12582 | 154 |
1675184 | 1675184 | 2021-09-01 | Cole | Missouri | 29051 | 12017 | 154 |
1671936 | 1671936 | 2021-08-31 | Cole | Missouri | 29051 | 11978 | 154 |
1636227 | 1636227 | 2021-08-20 | Jasper | Missouri | 29097 | 12449 | 154 |
1632977 | 1632977 | 2021-08-19 | Jasper | Missouri | 29097 | 12418 | 154 |
1629730 | 1629730 | 2021-08-18 | Jasper | Missouri | 29097 | 12363 | 154 |
1626483 | 1626483 | 2021-08-17 | Jasper | Missouri | 29097 | 12327 | 154 |
1610278 | 1610278 | 2021-08-12 | Phelps | Missouri | 29161 | 5171 | 154 |
1607030 | 1607030 | 2021-08-11 | Phelps | Missouri | 29161 | 5122 | 154 |
1126436 | 1126436 | 2021-03-16 | Clay | Missouri | 29047 | 9750 | 154 |
1081002 | 1081002 | 2021-03-02 | Franklin | Missouri | 29071 | 8427 | 154 |
1077756 | 1077756 | 2021-03-01 | Franklin | Missouri | 29071 | 8423 | 154 |
1074510 | 1074510 | 2021-02-28 | Franklin | Missouri | 29071 | 8418 | 154 |
1071264 | 1071264 | 2021-02-27 | Franklin | Missouri | 29071 | 8415 | 154 |
1068019 | 1068019 | 2021-02-26 | Franklin | Missouri | 29071 | 8409 | 154 |
1064774 | 1064774 | 2021-02-25 | Franklin | Missouri | 29071 | 8402 | 154 |
1061530 | 1061530 | 2021-02-24 | Franklin | Missouri | 29071 | 8388 | 154 |
1058284 | 1058284 | 2021-02-23 | Franklin | Missouri | 29071 | 8380 | 154 |
983605 | 983605 | 2021-01-31 | Buchanan | Missouri | 29021 | 9687 | 154 |
980359 | 980359 | 2021-01-30 | Buchanan | Missouri | 29021 | 9687 | 154 |
977113 | 977113 | 2021-01-29 | Buchanan | Missouri | 29021 | 9687 | 154 |
938209 | 938209 | 2021-01-17 | Jefferson | Missouri | 29099 | 19041 | 154 |
934964 | 934964 | 2021-01-16 | Jefferson | Missouri | 29099 | 19041 | 154 |
931719 | 931719 | 2021-01-15 | Jefferson | Missouri | 29099 | 19041 | 154 |
688329 | 688329 | 2020-11-01 | Greene | Missouri | 29077 | 9999 | 154 |
685085 | 685085 | 2020-10-31 | Greene | Missouri | 29077 | 9999 | 154 |
681842 | 681842 | 2020-10-30 | Greene | Missouri | 29077 | 9999 | 154 |
269779 | 269779 | 2020-06-24 | St. Louis city | Missouri | 29510 | 2319 | 154 |
266646 | 266646 | 2020-06-23 | St. Louis city | Missouri | 29510 | 2319 | 154 |
263520 | 263520 | 2020-06-22 | St. Louis city | Missouri | 29510 | 2319 | 154 |
260392 | 260392 | 2020-06-21 | St. Louis city | Missouri | 29510 | 2319 | 154 |
257266 | 257266 | 2020-06-20 | St. Louis city | Missouri | 29510 | 2319 | 154 |
254145 | 254145 | 2020-06-19 | St. Louis city | Missouri | 29510 | 2319 | 154 |
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);