ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where deaths = 144 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 8
- Cape Girardeau 14
- Camden 11
- St. Francois 7
- Taney 6
- Clay 5
- Joplin 4
- Jackson 3
- Phelps 2
state 1
- Missouri · 52 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1964363 | 1964363 | 2021-11-29 | Camden | Missouri | 29029 | 6616 | 144 |
1961112 | 1961112 | 2021-11-28 | Camden | Missouri | 29029 | 6585 | 144 |
1957861 | 1957861 | 2021-11-27 | Camden | Missouri | 29029 | 6585 | 144 |
1954610 | 1954610 | 2021-11-26 | Camden | Missouri | 29029 | 6585 | 144 |
1951359 | 1951359 | 2021-11-25 | Camden | Missouri | 29029 | 6585 | 144 |
1948108 | 1948108 | 2021-11-24 | Camden | Missouri | 29029 | 6585 | 144 |
1944857 | 1944857 | 2021-11-23 | Camden | Missouri | 29029 | 6583 | 144 |
1938356 | 1938356 | 2021-11-21 | Camden | Missouri | 29029 | 6573 | 144 |
1935106 | 1935106 | 2021-11-20 | Camden | Missouri | 29029 | 6569 | 144 |
1931856 | 1931856 | 2021-11-19 | Camden | Missouri | 29029 | 6563 | 144 |
1928605 | 1928605 | 2021-11-18 | Camden | Missouri | 29029 | 6547 | 144 |
1782481 | 1782481 | 2021-10-04 | Taney | Missouri | 29213 | 8854 | 144 |
1779231 | 1779231 | 2021-10-03 | Taney | Missouri | 29213 | 8850 | 144 |
1775981 | 1775981 | 2021-10-02 | Taney | Missouri | 29213 | 8846 | 144 |
1772731 | 1772731 | 2021-10-01 | Taney | Missouri | 29213 | 8841 | 144 |
1769482 | 1769482 | 2021-09-30 | Taney | Missouri | 29213 | 8835 | 144 |
1766233 | 1766233 | 2021-09-29 | Taney | Missouri | 29213 | 8816 | 144 |
1759728 | 1759728 | 2021-09-27 | St. Francois | Missouri | 29187 | 11590 | 144 |
1756480 | 1756480 | 2021-09-26 | St. Francois | Missouri | 29187 | 11572 | 144 |
1753232 | 1753232 | 2021-09-25 | St. Francois | Missouri | 29187 | 11562 | 144 |
1749984 | 1749984 | 2021-09-24 | St. Francois | Missouri | 29187 | 11508 | 144 |
1746734 | 1746734 | 2021-09-23 | St. Francois | Missouri | 29187 | 11485 | 144 |
1743485 | 1743485 | 2021-09-22 | St. Francois | Missouri | 29187 | 11442 | 144 |
1740236 | 1740236 | 2021-09-21 | St. Francois | Missouri | 29187 | 11402 | 144 |
1736937 | 1736937 | 2021-09-20 | Joplin | Missouri | 8456 | 144 | |
1733687 | 1733687 | 2021-09-19 | Joplin | Missouri | 8445 | 144 | |
1730437 | 1730437 | 2021-09-18 | Joplin | Missouri | 8437 | 144 | |
1727187 | 1727187 | 2021-09-17 | Joplin | Missouri | 8430 | 144 | |
1668679 | 1668679 | 2021-08-30 | Cape Girardeau | Missouri | 29031 | 11169 | 144 |
1665432 | 1665432 | 2021-08-29 | Cape Girardeau | Missouri | 29031 | 11077 | 144 |
1662184 | 1662184 | 2021-08-28 | Cape Girardeau | Missouri | 29031 | 11077 | 144 |
1658936 | 1658936 | 2021-08-27 | Cape Girardeau | Missouri | 29031 | 11077 | 144 |
1655687 | 1655687 | 2021-08-26 | Cape Girardeau | Missouri | 29031 | 10967 | 144 |
1652440 | 1652440 | 2021-08-25 | Cape Girardeau | Missouri | 29031 | 10967 | 144 |
1649192 | 1649192 | 2021-08-24 | Cape Girardeau | Missouri | 29031 | 10843 | 144 |
1645943 | 1645943 | 2021-08-23 | Cape Girardeau | Missouri | 29031 | 10843 | 144 |
1642694 | 1642694 | 2021-08-22 | Cape Girardeau | Missouri | 29031 | 10769 | 144 |
1639444 | 1639444 | 2021-08-21 | Cape Girardeau | Missouri | 29031 | 10769 | 144 |
1636194 | 1636194 | 2021-08-20 | Cape Girardeau | Missouri | 29031 | 10769 | 144 |
1632944 | 1632944 | 2021-08-19 | Cape Girardeau | Missouri | 29031 | 10651 | 144 |
1629697 | 1629697 | 2021-08-18 | Cape Girardeau | Missouri | 29031 | 10651 | 144 |
1626450 | 1626450 | 2021-08-17 | Cape Girardeau | Missouri | 29031 | 10535 | 144 |
1590786 | 1590786 | 2021-08-06 | Phelps | Missouri | 29161 | 4985 | 144 |
1587537 | 1587537 | 2021-08-05 | Phelps | Missouri | 29161 | 4956 | 144 |
1080990 | 1080990 | 2021-03-02 | Clay | Missouri | 29047 | 9550 | 144 |
1077744 | 1077744 | 2021-03-01 | Clay | Missouri | 29047 | 9533 | 144 |
1074498 | 1074498 | 2021-02-28 | Clay | Missouri | 29047 | 9502 | 144 |
1071252 | 1071252 | 2021-02-27 | Clay | Missouri | 29047 | 9502 | 144 |
1068007 | 1068007 | 2021-02-26 | Clay | Missouri | 29047 | 9502 | 144 |
704554 | 704554 | 2020-11-06 | Jackson | Missouri | 29095 | 11493 | 144 |
701312 | 701312 | 2020-11-05 | Jackson | Missouri | 29095 | 11224 | 144 |
698068 | 698068 | 2020-11-04 | Jackson | Missouri | 29095 | 11002 | 144 |
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);