ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where deaths = 139 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2328592 | 2328592 | 2022-03-21 | Johnson | Missouri | 29101 | 12129 | 139 |
2325340 | 2325340 | 2022-03-20 | Johnson | Missouri | 29101 | 12118 | 139 |
2322086 | 2322086 | 2022-03-19 | Johnson | Missouri | 29101 | 12118 | 139 |
2318832 | 2318832 | 2022-03-18 | Johnson | Missouri | 29101 | 12118 | 139 |
2315579 | 2315579 | 2022-03-17 | Johnson | Missouri | 29101 | 12114 | 139 |
2312326 | 2312326 | 2022-03-16 | Johnson | Missouri | 29101 | 12114 | 139 |
2309073 | 2309073 | 2022-03-15 | Johnson | Missouri | 29101 | 12108 | 139 |
2305821 | 2305821 | 2022-03-14 | Johnson | Missouri | 29101 | 12106 | 139 |
2302570 | 2302570 | 2022-03-13 | Johnson | Missouri | 29101 | 12099 | 139 |
2299318 | 2299318 | 2022-03-12 | Johnson | Missouri | 29101 | 12099 | 139 |
2296066 | 2296066 | 2022-03-11 | Johnson | Missouri | 29101 | 12099 | 139 |
2292814 | 2292814 | 2022-03-10 | Johnson | Missouri | 29101 | 12091 | 139 |
2289562 | 2289562 | 2022-03-09 | Johnson | Missouri | 29101 | 12065 | 139 |
2286310 | 2286310 | 2022-03-08 | Johnson | Missouri | 29101 | 12052 | 139 |
2283058 | 2283058 | 2022-03-07 | Johnson | Missouri | 29101 | 12043 | 139 |
2283122 | 2283122 | 2022-03-07 | Webster | Missouri | 29225 | 8974 | 139 |
2279805 | 2279805 | 2022-03-06 | Johnson | Missouri | 29101 | 12025 | 139 |
2279869 | 2279869 | 2022-03-06 | Webster | Missouri | 29225 | 8973 | 139 |
2276552 | 2276552 | 2022-03-05 | Johnson | Missouri | 29101 | 12025 | 139 |
2276616 | 2276616 | 2022-03-05 | Webster | Missouri | 29225 | 8973 | 139 |
2273299 | 2273299 | 2022-03-04 | Johnson | Missouri | 29101 | 12025 | 139 |
2273363 | 2273363 | 2022-03-04 | Webster | Missouri | 29225 | 8973 | 139 |
2270047 | 2270047 | 2022-03-03 | Johnson | Missouri | 29101 | 12011 | 139 |
2270111 | 2270111 | 2022-03-03 | Webster | Missouri | 29225 | 8970 | 139 |
2266794 | 2266794 | 2022-03-02 | Johnson | Missouri | 29101 | 12007 | 139 |
2266858 | 2266858 | 2022-03-02 | Webster | Missouri | 29225 | 8965 | 139 |
2263607 | 2263607 | 2022-03-01 | Webster | Missouri | 29225 | 8964 | 139 |
2172521 | 2172521 | 2022-02-01 | Pettis | Missouri | 29159 | 11241 | 139 |
2146422 | 2146422 | 2022-01-24 | Butler | Missouri | 29023 | 8924 | 139 |
2126982 | 2126982 | 2022-01-18 | Scott | Missouri | 29201 | 9268 | 139 |
2123730 | 2123730 | 2022-01-17 | Scott | Missouri | 29201 | 9084 | 139 |
2120478 | 2120478 | 2022-01-16 | Scott | Missouri | 29201 | 9084 | 139 |
2117226 | 2117226 | 2022-01-15 | Scott | Missouri | 29201 | 9084 | 139 |
2113975 | 2113975 | 2022-01-14 | Scott | Missouri | 29201 | 8863 | 139 |
2078168 | 2078168 | 2022-01-03 | Lawrence | Missouri | 29109 | 5887 | 139 |
2074917 | 2074917 | 2022-01-02 | Lawrence | Missouri | 29109 | 5820 | 139 |
2071666 | 2071666 | 2022-01-01 | Lawrence | Missouri | 29109 | 5820 | 139 |
2068415 | 2068415 | 2021-12-31 | Lawrence | Missouri | 29109 | 5820 | 139 |
2065164 | 2065164 | 2021-12-30 | Lawrence | Missouri | 29109 | 5820 | 139 |
2061914 | 2061914 | 2021-12-29 | Lawrence | Missouri | 29109 | 5770 | 139 |
2058665 | 2058665 | 2021-12-28 | Lawrence | Missouri | 29109 | 5758 | 139 |
1714160 | 1714160 | 2021-09-13 | Cass | Missouri | 29037 | 12913 | 139 |
1710914 | 1710914 | 2021-09-12 | Cass | Missouri | 29037 | 12896 | 139 |
1707667 | 1707667 | 2021-09-11 | Cass | Missouri | 29037 | 12857 | 139 |
1704420 | 1704420 | 2021-09-10 | Cass | Missouri | 29037 | 12805 | 139 |
1704510 | 1704510 | 2021-09-10 | Taney | Missouri | 29213 | 8562 | 139 |
1701170 | 1701170 | 2021-09-09 | Cass | Missouri | 29037 | 12735 | 139 |
1701260 | 1701260 | 2021-09-09 | Taney | Missouri | 29213 | 8545 | 139 |
1668685 | 1668685 | 2021-08-30 | Christian | Missouri | 29043 | 12567 | 139 |
1665438 | 1665438 | 2021-08-29 | Christian | Missouri | 29043 | 12567 | 139 |
1662190 | 1662190 | 2021-08-28 | Christian | Missouri | 29043 | 12567 | 139 |
1658942 | 1658942 | 2021-08-27 | Christian | Missouri | 29043 | 12567 | 139 |
1655693 | 1655693 | 2021-08-26 | Christian | Missouri | 29043 | 12385 | 139 |
1652446 | 1652446 | 2021-08-25 | Christian | Missouri | 29043 | 12385 | 139 |
1649198 | 1649198 | 2021-08-24 | Christian | Missouri | 29043 | 12385 | 139 |
1623213 | 1623213 | 2021-08-16 | Cole | Missouri | 29051 | 11483 | 139 |
1619966 | 1619966 | 2021-08-15 | Cole | Missouri | 29051 | 11475 | 139 |
1616718 | 1616718 | 2021-08-14 | Cole | Missouri | 29051 | 11461 | 139 |
1613470 | 1613470 | 2021-08-13 | Cole | Missouri | 29051 | 11429 | 139 |
1610221 | 1610221 | 2021-08-12 | Cole | Missouri | 29051 | 11377 | 139 |
1606973 | 1606973 | 2021-08-11 | Cole | Missouri | 29051 | 11330 | 139 |
1603724 | 1603724 | 2021-08-10 | Cole | Missouri | 29051 | 11265 | 139 |
1555053 | 1555053 | 2021-07-26 | Phelps | Missouri | 29161 | 4641 | 139 |
1551806 | 1551806 | 2021-07-25 | Phelps | Missouri | 29161 | 4621 | 139 |
1548559 | 1548559 | 2021-07-24 | Phelps | Missouri | 29161 | 4603 | 139 |
1545312 | 1545312 | 2021-07-23 | Phelps | Missouri | 29161 | 4561 | 139 |
1542064 | 1542064 | 2021-07-22 | Phelps | Missouri | 29161 | 4508 | 139 |
1538817 | 1538817 | 2021-07-21 | Phelps | Missouri | 29161 | 4461 | 139 |
1535570 | 1535570 | 2021-07-20 | Phelps | Missouri | 29161 | 4423 | 139 |
1509525 | 1509525 | 2021-07-12 | Cape Girardeau | Missouri | 29031 | 9616 | 139 |
1506279 | 1506279 | 2021-07-11 | Cape Girardeau | Missouri | 29031 | 9616 | 139 |
1503033 | 1503033 | 2021-07-10 | Cape Girardeau | Missouri | 29031 | 9616 | 139 |
1499787 | 1499787 | 2021-07-09 | Cape Girardeau | Missouri | 29031 | 9616 | 139 |
1496541 | 1496541 | 2021-07-08 | Cape Girardeau | Missouri | 29031 | 9616 | 139 |
1493294 | 1493294 | 2021-07-07 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1490047 | 1490047 | 2021-07-06 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1486800 | 1486800 | 2021-07-05 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1483554 | 1483554 | 2021-07-04 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1480308 | 1480308 | 2021-07-03 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1477061 | 1477061 | 2021-07-02 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1473815 | 1473815 | 2021-07-01 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1470569 | 1470569 | 2021-06-30 | Cape Girardeau | Missouri | 29031 | 9607 | 139 |
1467324 | 1467324 | 2021-06-29 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1464079 | 1464079 | 2021-06-28 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1460834 | 1460834 | 2021-06-27 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1457589 | 1457589 | 2021-06-26 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1454344 | 1454344 | 2021-06-25 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1451099 | 1451099 | 2021-06-24 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1447853 | 1447853 | 2021-06-23 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1444608 | 1444608 | 2021-06-22 | Cape Girardeau | Missouri | 29031 | 9579 | 139 |
1441363 | 1441363 | 2021-06-21 | Cape Girardeau | Missouri | 29031 | 9579 | 139 |
1438117 | 1438117 | 2021-06-20 | Cape Girardeau | Missouri | 29031 | 9579 | 139 |
1434870 | 1434870 | 2021-06-19 | Cape Girardeau | Missouri | 29031 | 9579 | 139 |
1431623 | 1431623 | 2021-06-18 | Cape Girardeau | Missouri | 29031 | 9579 | 139 |
1428378 | 1428378 | 2021-06-17 | Cape Girardeau | Missouri | 29031 | 9579 | 139 |
1425133 | 1425133 | 2021-06-16 | Cape Girardeau | Missouri | 29031 | 9579 | 139 |
1421885 | 1421885 | 2021-06-15 | Cape Girardeau | Missouri | 29031 | 9571 | 139 |
668871 | 668871 | 2020-10-26 | Greene | Missouri | 29077 | 9599 | 139 |
229266 | 229266 | 2020-06-11 | St. Louis city | Missouri | 29510 | 2162 | 139 |
226163 | 226163 | 2020-06-10 | St. Louis city | Missouri | 29510 | 2145 | 139 |
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);