ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where deaths = 149 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Laclede 13
- Joplin 8
- Camden 7
- Cape Girardeau 7
- Boone 6
- Franklin 6
- Buchanan 4
- Cass 4
- St. Charles 4
state 1
- Missouri · 59 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2032625 | 2032625 | 2021-12-20 | Camden | Missouri | 29029 | 6889 | 149 |
2029374 | 2029374 | 2021-12-19 | Camden | Missouri | 29029 | 6881 | 149 |
2026123 | 2026123 | 2021-12-18 | Camden | Missouri | 29029 | 6877 | 149 |
2022872 | 2022872 | 2021-12-17 | Camden | Missouri | 29029 | 6849 | 149 |
2019621 | 2019621 | 2021-12-16 | Camden | Missouri | 29029 | 6838 | 149 |
2016371 | 2016371 | 2021-12-15 | Camden | Missouri | 29029 | 6815 | 149 |
2013120 | 2013120 | 2021-12-14 | Camden | Missouri | 29029 | 6800 | 149 |
2009909 | 2009909 | 2021-12-13 | Laclede | Missouri | 29105 | 5764 | 149 |
2006658 | 2006658 | 2021-12-12 | Laclede | Missouri | 29105 | 5734 | 149 |
2003407 | 2003407 | 2021-12-11 | Laclede | Missouri | 29105 | 5722 | 149 |
2000157 | 2000157 | 2021-12-10 | Laclede | Missouri | 29105 | 5709 | 149 |
1996906 | 1996906 | 2021-12-09 | Laclede | Missouri | 29105 | 5692 | 149 |
1993655 | 1993655 | 2021-12-08 | Laclede | Missouri | 29105 | 5667 | 149 |
1990404 | 1990404 | 2021-12-07 | Laclede | Missouri | 29105 | 5649 | 149 |
1987154 | 1987154 | 2021-12-06 | Laclede | Missouri | 29105 | 5623 | 149 |
1983904 | 1983904 | 2021-12-05 | Laclede | Missouri | 29105 | 5609 | 149 |
1980654 | 1980654 | 2021-12-04 | Laclede | Missouri | 29105 | 5602 | 149 |
1977404 | 1977404 | 2021-12-03 | Laclede | Missouri | 29105 | 5574 | 149 |
1974154 | 1974154 | 2021-12-02 | Laclede | Missouri | 29105 | 5574 | 149 |
1970905 | 1970905 | 2021-12-01 | Laclede | Missouri | 29105 | 5562 | 149 |
1808417 | 1808417 | 2021-10-12 | Joplin | Missouri | 8605 | 149 | |
1805166 | 1805166 | 2021-10-11 | Joplin | Missouri | 8606 | 149 | |
1801917 | 1801917 | 2021-10-10 | Joplin | Missouri | 8599 | 149 | |
1798668 | 1798668 | 2021-10-09 | Joplin | Missouri | 8594 | 149 | |
1795419 | 1795419 | 2021-10-08 | Joplin | Missouri | 8581 | 149 | |
1792170 | 1792170 | 2021-10-07 | Joplin | Missouri | 8573 | 149 | |
1788921 | 1788921 | 2021-10-06 | Joplin | Missouri | 8571 | 149 | |
1785673 | 1785673 | 2021-10-05 | Joplin | Missouri | 8565 | 149 | |
1782391 | 1782391 | 2021-10-04 | Cass | Missouri | 29037 | 13750 | 149 |
1779141 | 1779141 | 2021-10-03 | Cass | Missouri | 29037 | 13738 | 149 |
1775891 | 1775891 | 2021-10-02 | Cass | Missouri | 29037 | 13705 | 149 |
1772641 | 1772641 | 2021-10-01 | Cass | Missouri | 29037 | 13650 | 149 |
1736901 | 1736901 | 2021-09-20 | Cape Girardeau | Missouri | 29031 | 12168 | 149 |
1733651 | 1733651 | 2021-09-19 | Cape Girardeau | Missouri | 29031 | 12093 | 149 |
1730401 | 1730401 | 2021-09-18 | Cape Girardeau | Missouri | 29031 | 12093 | 149 |
1727151 | 1727151 | 2021-09-17 | Cape Girardeau | Missouri | 29031 | 12093 | 149 |
1723902 | 1723902 | 2021-09-16 | Cape Girardeau | Missouri | 29031 | 12004 | 149 |
1720647 | 1720647 | 2021-09-15 | Boone | Missouri | 29019 | 23900 | 149 |
1720653 | 1720653 | 2021-09-15 | Cape Girardeau | Missouri | 29031 | 12004 | 149 |
1717399 | 1717399 | 2021-09-14 | Boone | Missouri | 29019 | 23900 | 149 |
1717405 | 1717405 | 2021-09-14 | Cape Girardeau | Missouri | 29031 | 11872 | 149 |
1714151 | 1714151 | 2021-09-13 | Boone | Missouri | 29019 | 23831 | 149 |
1710905 | 1710905 | 2021-09-12 | Boone | Missouri | 29019 | 23671 | 149 |
1707658 | 1707658 | 2021-09-11 | Boone | Missouri | 29019 | 23671 | 149 |
1704411 | 1704411 | 2021-09-10 | Boone | Missouri | 29019 | 23671 | 149 |
1038808 | 1038808 | 2021-02-17 | Franklin | Missouri | 29071 | 8305 | 149 |
1035563 | 1035563 | 2021-02-16 | Franklin | Missouri | 29071 | 8301 | 149 |
1032318 | 1032318 | 2021-02-15 | Franklin | Missouri | 29071 | 8291 | 149 |
1029071 | 1029071 | 2021-02-14 | Franklin | Missouri | 29071 | 8272 | 149 |
1025825 | 1025825 | 2021-02-13 | Franklin | Missouri | 29071 | 8264 | 149 |
1022580 | 1022580 | 2021-02-12 | Franklin | Missouri | 29071 | 8253 | 149 |
941415 | 941415 | 2021-01-18 | Buchanan | Missouri | 29021 | 9255 | 149 |
938170 | 938170 | 2021-01-17 | Buchanan | Missouri | 29021 | 9255 | 149 |
934925 | 934925 | 2021-01-16 | Buchanan | Missouri | 29021 | 9255 | 149 |
931680 | 931680 | 2021-01-15 | Buchanan | Missouri | 29021 | 9255 | 149 |
665688 | 665688 | 2020-10-25 | St. Charles | Missouri | 29183 | 10883 | 149 |
662443 | 662443 | 2020-10-24 | St. Charles | Missouri | 29183 | 10877 | 149 |
659199 | 659199 | 2020-10-23 | St. Charles | Missouri | 29183 | 10817 | 149 |
655954 | 655954 | 2020-10-22 | St. Charles | Missouri | 29183 | 10509 | 149 |
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);