ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where deaths = 115 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501148 | 2501148 | 2022-05-13 | Morgan | Missouri | 29141 | 4053 | 115 |
2497890 | 2497890 | 2022-05-12 | Morgan | Missouri | 29141 | 4048 | 115 |
2494632 | 2494632 | 2022-05-11 | Morgan | Missouri | 29141 | 4048 | 115 |
2491374 | 2491374 | 2022-05-10 | Morgan | Missouri | 29141 | 4048 | 115 |
2488116 | 2488116 | 2022-05-09 | Morgan | Missouri | 29141 | 4048 | 115 |
2484859 | 2484859 | 2022-05-08 | Morgan | Missouri | 29141 | 4048 | 115 |
2481601 | 2481601 | 2022-05-07 | Morgan | Missouri | 29141 | 4048 | 115 |
2478343 | 2478343 | 2022-05-06 | Morgan | Missouri | 29141 | 4048 | 115 |
2475085 | 2475085 | 2022-05-05 | Morgan | Missouri | 29141 | 4042 | 115 |
2357906 | 2357906 | 2022-03-30 | Pulaski | Missouri | 29169 | 8814 | 115 |
2354653 | 2354653 | 2022-03-29 | Pulaski | Missouri | 29169 | 8808 | 115 |
2351400 | 2351400 | 2022-03-28 | Pulaski | Missouri | 29169 | 8808 | 115 |
2348148 | 2348148 | 2022-03-27 | Pulaski | Missouri | 29169 | 8806 | 115 |
2344895 | 2344895 | 2022-03-26 | Pulaski | Missouri | 29169 | 8806 | 115 |
2341642 | 2341642 | 2022-03-25 | Pulaski | Missouri | 29169 | 8806 | 115 |
2338389 | 2338389 | 2022-03-24 | Pulaski | Missouri | 29169 | 8800 | 115 |
2335135 | 2335135 | 2022-03-23 | Pulaski | Missouri | 29169 | 8792 | 115 |
2331881 | 2331881 | 2022-03-22 | Pulaski | Missouri | 29169 | 8791 | 115 |
2325357 | 2325357 | 2022-03-20 | Miller | Missouri | 29131 | 6080 | 115 |
2322103 | 2322103 | 2022-03-19 | Miller | Missouri | 29131 | 6080 | 115 |
2318849 | 2318849 | 2022-03-18 | Miller | Missouri | 29131 | 6080 | 115 |
2315596 | 2315596 | 2022-03-17 | Miller | Missouri | 29131 | 6075 | 115 |
2312343 | 2312343 | 2022-03-16 | Miller | Missouri | 29131 | 6074 | 115 |
2309090 | 2309090 | 2022-03-15 | Miller | Missouri | 29131 | 6072 | 115 |
2305795 | 2305795 | 2022-03-14 | Clinton | Missouri | 29049 | 4753 | 115 |
2305835 | 2305835 | 2022-03-14 | Marion | Missouri | 29127 | 7945 | 115 |
2302544 | 2302544 | 2022-03-13 | Clinton | Missouri | 29049 | 4735 | 115 |
2302584 | 2302584 | 2022-03-13 | Marion | Missouri | 29127 | 7945 | 115 |
2299292 | 2299292 | 2022-03-12 | Clinton | Missouri | 29049 | 4735 | 115 |
2299332 | 2299332 | 2022-03-12 | Marion | Missouri | 29127 | 7945 | 115 |
2296040 | 2296040 | 2022-03-11 | Clinton | Missouri | 29049 | 4735 | 115 |
2296080 | 2296080 | 2022-03-11 | Marion | Missouri | 29127 | 7945 | 115 |
2292788 | 2292788 | 2022-03-10 | Clinton | Missouri | 29049 | 4732 | 115 |
2292828 | 2292828 | 2022-03-10 | Marion | Missouri | 29127 | 7938 | 115 |
2289536 | 2289536 | 2022-03-09 | Clinton | Missouri | 29049 | 4730 | 115 |
2289576 | 2289576 | 2022-03-09 | Marion | Missouri | 29127 | 7937 | 115 |
2286284 | 2286284 | 2022-03-08 | Clinton | Missouri | 29049 | 4725 | 115 |
2286324 | 2286324 | 2022-03-08 | Marion | Missouri | 29127 | 7933 | 115 |
2214783 | 2214783 | 2022-02-14 | Lafayette | Missouri | 29107 | 7629 | 115 |
2214833 | 2214833 | 2022-02-14 | Stoddard | Missouri | 29207 | 5948 | 115 |
2211531 | 2211531 | 2022-02-13 | Lafayette | Missouri | 29107 | 7594 | 115 |
2211581 | 2211581 | 2022-02-13 | Stoddard | Missouri | 29207 | 5912 | 115 |
2208278 | 2208278 | 2022-02-12 | Lafayette | Missouri | 29107 | 7594 | 115 |
2208328 | 2208328 | 2022-02-12 | Stoddard | Missouri | 29207 | 5912 | 115 |
2205025 | 2205025 | 2022-02-11 | Lafayette | Missouri | 29107 | 7594 | 115 |
2205075 | 2205075 | 2022-02-11 | Stoddard | Missouri | 29207 | 5912 | 115 |
2201772 | 2201772 | 2022-02-10 | Lafayette | Missouri | 29107 | 7594 | 115 |
2201822 | 2201822 | 2022-02-10 | Stoddard | Missouri | 29207 | 5912 | 115 |
2198518 | 2198518 | 2022-02-09 | Lafayette | Missouri | 29107 | 7572 | 115 |
2198568 | 2198568 | 2022-02-09 | Stoddard | Missouri | 29207 | 5900 | 115 |
2195264 | 2195264 | 2022-02-08 | Lafayette | Missouri | 29107 | 7553 | 115 |
2195314 | 2195314 | 2022-02-08 | Stoddard | Missouri | 29207 | 5894 | 115 |
1944957 | 1944957 | 2021-11-23 | Webster | Missouri | 29225 | 5946 | 115 |
1876693 | 1876693 | 2021-11-02 | Scott | Missouri | 29201 | 7191 | 115 |
1736900 | 1736900 | 2021-09-20 | Camden | Missouri | 29029 | 6000 | 115 |
1733650 | 1733650 | 2021-09-19 | Camden | Missouri | 29029 | 5999 | 115 |
1730400 | 1730400 | 2021-09-18 | Camden | Missouri | 29029 | 5998 | 115 |
1727150 | 1727150 | 2021-09-17 | Camden | Missouri | 29029 | 5981 | 115 |
1723901 | 1723901 | 2021-09-16 | Camden | Missouri | 29029 | 5958 | 115 |
1720652 | 1720652 | 2021-09-15 | Camden | Missouri | 29029 | 5926 | 115 |
1717404 | 1717404 | 2021-09-14 | Camden | Missouri | 29029 | 5889 | 115 |
1714156 | 1714156 | 2021-09-13 | Camden | Missouri | 29029 | 5871 | 115 |
1710910 | 1710910 | 2021-09-12 | Camden | Missouri | 29029 | 5869 | 115 |
1678461 | 1678461 | 2021-09-02 | Laclede | Missouri | 29105 | 4937 | 115 |
1512808 | 1512808 | 2021-07-13 | Joplin | Missouri | 7043 | 115 | |
1396008 | 1396008 | 2021-06-07 | St. Francois | Missouri | 29187 | 8903 | 115 |
1392762 | 1392762 | 2021-06-06 | St. Francois | Missouri | 29187 | 8901 | 115 |
1389517 | 1389517 | 2021-06-05 | St. Francois | Missouri | 29187 | 8901 | 115 |
1386272 | 1386272 | 2021-06-04 | St. Francois | Missouri | 29187 | 8896 | 115 |
1383027 | 1383027 | 2021-06-03 | St. Francois | Missouri | 29187 | 8877 | 115 |
1379781 | 1379781 | 2021-06-02 | St. Francois | Missouri | 29187 | 8871 | 115 |
1376536 | 1376536 | 2021-06-01 | St. Francois | Missouri | 29187 | 8869 | 115 |
1373290 | 1373290 | 2021-05-31 | St. Francois | Missouri | 29187 | 8867 | 115 |
1370045 | 1370045 | 2021-05-30 | St. Francois | Missouri | 29187 | 8863 | 115 |
1366799 | 1366799 | 2021-05-29 | St. Francois | Missouri | 29187 | 8863 | 115 |
1363553 | 1363553 | 2021-05-28 | St. Francois | Missouri | 29187 | 8860 | 115 |
1360306 | 1360306 | 2021-05-27 | St. Francois | Missouri | 29187 | 8857 | 115 |
1357060 | 1357060 | 2021-05-26 | St. Francois | Missouri | 29187 | 8854 | 115 |
1353814 | 1353814 | 2021-05-25 | St. Francois | Missouri | 29187 | 8854 | 115 |
1350568 | 1350568 | 2021-05-24 | St. Francois | Missouri | 29187 | 8850 | 115 |
1347322 | 1347322 | 2021-05-23 | St. Francois | Missouri | 29187 | 8846 | 115 |
1344074 | 1344074 | 2021-05-22 | St. Francois | Missouri | 29187 | 8842 | 115 |
1340825 | 1340825 | 2021-05-21 | St. Francois | Missouri | 29187 | 8839 | 115 |
1337578 | 1337578 | 2021-05-20 | St. Francois | Missouri | 29187 | 8836 | 115 |
1334331 | 1334331 | 2021-05-19 | St. Francois | Missouri | 29187 | 8830 | 115 |
1331084 | 1331084 | 2021-05-18 | St. Francois | Missouri | 29187 | 8830 | 115 |
1327837 | 1327837 | 2021-05-17 | St. Francois | Missouri | 29187 | 8826 | 115 |
1324591 | 1324591 | 2021-05-16 | St. Francois | Missouri | 29187 | 8824 | 115 |
1321345 | 1321345 | 2021-05-15 | St. Francois | Missouri | 29187 | 8816 | 115 |
1318099 | 1318099 | 2021-05-14 | St. Francois | Missouri | 29187 | 8811 | 115 |
1314851 | 1314851 | 2021-05-13 | St. Francois | Missouri | 29187 | 8809 | 115 |
1311605 | 1311605 | 2021-05-12 | St. Francois | Missouri | 29187 | 8806 | 115 |
1308358 | 1308358 | 2021-05-11 | St. Francois | Missouri | 29187 | 8800 | 115 |
1305112 | 1305112 | 2021-05-10 | St. Francois | Missouri | 29187 | 8797 | 115 |
1301866 | 1301866 | 2021-05-09 | St. Francois | Missouri | 29187 | 8794 | 115 |
1298618 | 1298618 | 2021-05-08 | St. Francois | Missouri | 29187 | 8791 | 115 |
1295372 | 1295372 | 2021-05-07 | St. Francois | Missouri | 29187 | 8785 | 115 |
1292126 | 1292126 | 2021-05-06 | St. Francois | Missouri | 29187 | 8778 | 115 |
1288880 | 1288880 | 2021-05-05 | St. Francois | Missouri | 29187 | 8772 | 115 |
1285634 | 1285634 | 2021-05-04 | St. Francois | Missouri | 29187 | 8767 | 115 |
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);