ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where deaths = 129 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497831 | 2497831 | 2022-05-12 | Callaway | Missouri | 29027 | 12120 | 129 |
2494573 | 2494573 | 2022-05-11 | Callaway | Missouri | 29027 | 12120 | 129 |
2491315 | 2491315 | 2022-05-10 | Callaway | Missouri | 29027 | 12120 | 129 |
2488057 | 2488057 | 2022-05-09 | Callaway | Missouri | 29027 | 12120 | 129 |
2484800 | 2484800 | 2022-05-08 | Callaway | Missouri | 29027 | 12120 | 129 |
2481542 | 2481542 | 2022-05-07 | Callaway | Missouri | 29027 | 12120 | 129 |
2478284 | 2478284 | 2022-05-06 | Callaway | Missouri | 29027 | 12120 | 129 |
2270055 | 2270055 | 2022-03-03 | Lincoln | Missouri | 29113 | 15071 | 129 |
2179059 | 2179059 | 2022-02-03 | Webster | Missouri | 29225 | 8552 | 129 |
2175807 | 2175807 | 2022-02-02 | Webster | Missouri | 29225 | 8476 | 129 |
2172554 | 2172554 | 2022-02-01 | Webster | Missouri | 29225 | 8368 | 129 |
2169301 | 2169301 | 2022-01-31 | Webster | Missouri | 29225 | 8358 | 129 |
2166046 | 2166046 | 2022-01-30 | Webster | Missouri | 29225 | 8326 | 129 |
2162791 | 2162791 | 2022-01-29 | Webster | Missouri | 29225 | 8273 | 129 |
1925415 | 1925415 | 2021-11-17 | Newton | Missouri | 29145 | 7891 | 129 |
1922166 | 1922166 | 2021-11-16 | Newton | Missouri | 29145 | 7876 | 129 |
1918896 | 1918896 | 2021-11-15 | Laclede | Missouri | 29105 | 5334 | 129 |
1918916 | 1918916 | 2021-11-15 | Newton | Missouri | 29145 | 7861 | 129 |
1915646 | 1915646 | 2021-11-14 | Laclede | Missouri | 29105 | 5327 | 129 |
1915666 | 1915666 | 2021-11-14 | Newton | Missouri | 29145 | 7857 | 129 |
1912396 | 1912396 | 2021-11-13 | Laclede | Missouri | 29105 | 5324 | 129 |
1912416 | 1912416 | 2021-11-13 | Newton | Missouri | 29145 | 7854 | 129 |
1909146 | 1909146 | 2021-11-12 | Laclede | Missouri | 29105 | 5315 | 129 |
1909166 | 1909166 | 2021-11-12 | Newton | Missouri | 29145 | 7847 | 129 |
1905897 | 1905897 | 2021-11-11 | Laclede | Missouri | 29105 | 5306 | 129 |
1905917 | 1905917 | 2021-11-11 | Newton | Missouri | 29145 | 7831 | 129 |
1902648 | 1902648 | 2021-11-10 | Laclede | Missouri | 29105 | 5306 | 129 |
1902668 | 1902668 | 2021-11-10 | Newton | Missouri | 29145 | 7831 | 129 |
1899398 | 1899398 | 2021-11-09 | Laclede | Missouri | 29105 | 5304 | 129 |
1899418 | 1899418 | 2021-11-09 | Newton | Missouri | 29145 | 7822 | 129 |
1896148 | 1896148 | 2021-11-08 | Laclede | Missouri | 29105 | 5299 | 129 |
1892898 | 1892898 | 2021-11-07 | Laclede | Missouri | 29105 | 5299 | 129 |
1889648 | 1889648 | 2021-11-06 | Laclede | Missouri | 29105 | 5295 | 129 |
1886398 | 1886398 | 2021-11-05 | Laclede | Missouri | 29105 | 5292 | 129 |
1883149 | 1883149 | 2021-11-04 | Laclede | Missouri | 29105 | 5285 | 129 |
1879900 | 1879900 | 2021-11-03 | Laclede | Missouri | 29105 | 5281 | 129 |
1698004 | 1698004 | 2021-09-08 | St. Francois | Missouri | 29187 | 10811 | 129 |
1668772 | 1668772 | 2021-08-30 | Taney | Missouri | 29213 | 8406 | 129 |
1665525 | 1665525 | 2021-08-29 | Taney | Missouri | 29213 | 8379 | 129 |
1662277 | 1662277 | 2021-08-28 | Taney | Missouri | 29213 | 8372 | 129 |
1659029 | 1659029 | 2021-08-27 | Taney | Missouri | 29213 | 8347 | 129 |
1655780 | 1655780 | 2021-08-26 | Taney | Missouri | 29213 | 8319 | 129 |
1652533 | 1652533 | 2021-08-25 | Taney | Missouri | 29213 | 8305 | 129 |
1623197 | 1623197 | 2021-08-16 | Boone | Missouri | 29019 | 22160 | 129 |
1619950 | 1619950 | 2021-08-15 | Boone | Missouri | 29019 | 22008 | 129 |
1616702 | 1616702 | 2021-08-14 | Boone | Missouri | 29019 | 22008 | 129 |
1613454 | 1613454 | 2021-08-13 | Boone | Missouri | 29019 | 22008 | 129 |
1418650 | 1418650 | 2021-06-14 | Cole | Missouri | 29051 | 9238 | 129 |
1415405 | 1415405 | 2021-06-13 | Cole | Missouri | 29051 | 9236 | 129 |
1412159 | 1412159 | 2021-06-12 | Cole | Missouri | 29051 | 9233 | 129 |
1408914 | 1408914 | 2021-06-11 | Cole | Missouri | 29051 | 9229 | 129 |
1405669 | 1405669 | 2021-06-10 | Cole | Missouri | 29051 | 9227 | 129 |
1402423 | 1402423 | 2021-06-09 | Cole | Missouri | 29051 | 9214 | 129 |
1399178 | 1399178 | 2021-06-08 | Cole | Missouri | 29051 | 9202 | 129 |
1376483 | 1376483 | 2021-06-01 | Jasper | Missouri | 29097 | 9543 | 129 |
1373237 | 1373237 | 2021-05-31 | Jasper | Missouri | 29097 | 9540 | 129 |
1369992 | 1369992 | 2021-05-30 | Jasper | Missouri | 29097 | 9539 | 129 |
1366746 | 1366746 | 2021-05-29 | Jasper | Missouri | 29097 | 9536 | 129 |
1363500 | 1363500 | 2021-05-28 | Jasper | Missouri | 29097 | 9531 | 129 |
1360253 | 1360253 | 2021-05-27 | Jasper | Missouri | 29097 | 9524 | 129 |
1357007 | 1357007 | 2021-05-26 | Jasper | Missouri | 29097 | 9515 | 129 |
1353761 | 1353761 | 2021-05-25 | Jasper | Missouri | 29097 | 9508 | 129 |
1350515 | 1350515 | 2021-05-24 | Jasper | Missouri | 29097 | 9497 | 129 |
1347269 | 1347269 | 2021-05-23 | Jasper | Missouri | 29097 | 9497 | 129 |
1344021 | 1344021 | 2021-05-22 | Jasper | Missouri | 29097 | 9497 | 129 |
1340772 | 1340772 | 2021-05-21 | Jasper | Missouri | 29097 | 9493 | 129 |
1305093 | 1305093 | 2021-05-10 | Phelps | Missouri | 29161 | 3847 | 129 |
1301847 | 1301847 | 2021-05-09 | Phelps | Missouri | 29161 | 3847 | 129 |
1298599 | 1298599 | 2021-05-08 | Phelps | Missouri | 29161 | 3847 | 129 |
1295353 | 1295353 | 2021-05-07 | Phelps | Missouri | 29161 | 3844 | 129 |
1292107 | 1292107 | 2021-05-06 | Phelps | Missouri | 29161 | 3834 | 129 |
1288861 | 1288861 | 2021-05-05 | Phelps | Missouri | 29161 | 3833 | 129 |
1285615 | 1285615 | 2021-05-04 | Phelps | Missouri | 29161 | 3827 | 129 |
1282369 | 1282369 | 2021-05-03 | Phelps | Missouri | 29161 | 3820 | 129 |
1279122 | 1279122 | 2021-05-02 | Phelps | Missouri | 29161 | 3819 | 129 |
1275875 | 1275875 | 2021-05-01 | Phelps | Missouri | 29161 | 3811 | 129 |
1272628 | 1272628 | 2021-04-30 | Phelps | Missouri | 29161 | 3808 | 129 |
876509 | 876509 | 2020-12-29 | Buchanan | Missouri | 29021 | 8235 | 129 |
597565 | 597565 | 2020-10-04 | St. Charles | Missouri | 29183 | 8369 | 129 |
594324 | 594324 | 2020-10-03 | St. Charles | Missouri | 29183 | 8296 | 129 |
591083 | 591083 | 2020-10-02 | St. Charles | Missouri | 29183 | 8228 | 129 |
587842 | 587842 | 2020-10-01 | St. Charles | Missouri | 29183 | 8142 | 129 |
584602 | 584602 | 2020-09-30 | St. Charles | Missouri | 29183 | 8078 | 129 |
581361 | 581361 | 2020-09-29 | St. Charles | Missouri | 29183 | 8039 | 129 |
578120 | 578120 | 2020-09-28 | St. Charles | Missouri | 29183 | 7901 | 129 |
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);