ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where deaths = 105 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2328627 | 2328627 | 2022-03-21 | Polk | Missouri | 29167 | 8014 | 105 |
2328652 | 2328652 | 2022-03-21 | Vernon | Missouri | 29217 | 5041 | 105 |
2325375 | 2325375 | 2022-03-20 | Polk | Missouri | 29167 | 8013 | 105 |
2325400 | 2325400 | 2022-03-20 | Vernon | Missouri | 29217 | 5039 | 105 |
2322121 | 2322121 | 2022-03-19 | Polk | Missouri | 29167 | 8013 | 105 |
2322146 | 2322146 | 2022-03-19 | Vernon | Missouri | 29217 | 5039 | 105 |
2318867 | 2318867 | 2022-03-18 | Polk | Missouri | 29167 | 8013 | 105 |
2318892 | 2318892 | 2022-03-18 | Vernon | Missouri | 29217 | 5039 | 105 |
2315614 | 2315614 | 2022-03-17 | Polk | Missouri | 29167 | 8012 | 105 |
2315639 | 2315639 | 2022-03-17 | Vernon | Missouri | 29217 | 5039 | 105 |
2312361 | 2312361 | 2022-03-16 | Polk | Missouri | 29167 | 8010 | 105 |
2312386 | 2312386 | 2022-03-16 | Vernon | Missouri | 29217 | 5039 | 105 |
2309108 | 2309108 | 2022-03-15 | Polk | Missouri | 29167 | 8010 | 105 |
2309133 | 2309133 | 2022-03-15 | Vernon | Missouri | 29217 | 5039 | 105 |
2247241 | 2247241 | 2022-02-24 | Audrain | Missouri | 29007 | 5660 | 105 |
2214732 | 2214732 | 2022-02-14 | Barry | Missouri | 29009 | 6506 | 105 |
2211480 | 2211480 | 2022-02-13 | Barry | Missouri | 29009 | 6472 | 105 |
2208227 | 2208227 | 2022-02-12 | Barry | Missouri | 29009 | 6472 | 105 |
2204974 | 2204974 | 2022-02-11 | Barry | Missouri | 29009 | 6472 | 105 |
2201721 | 2201721 | 2022-02-10 | Barry | Missouri | 29009 | 6472 | 105 |
2198467 | 2198467 | 2022-02-09 | Barry | Missouri | 29009 | 6442 | 105 |
2195213 | 2195213 | 2022-02-08 | Barry | Missouri | 29009 | 6431 | 105 |
2191959 | 2191959 | 2022-02-07 | Barry | Missouri | 29009 | 6424 | 105 |
2191968 | 2191968 | 2022-02-07 | Callaway | Missouri | 29027 | 11490 | 105 |
2192022 | 2192022 | 2022-02-07 | Miller | Missouri | 29131 | 5890 | 105 |
2188706 | 2188706 | 2022-02-06 | Barry | Missouri | 29009 | 6418 | 105 |
2188715 | 2188715 | 2022-02-06 | Callaway | Missouri | 29027 | 11473 | 105 |
2188769 | 2188769 | 2022-02-06 | Miller | Missouri | 29131 | 5878 | 105 |
2185453 | 2185453 | 2022-02-05 | Barry | Missouri | 29009 | 6405 | 105 |
2185462 | 2185462 | 2022-02-05 | Callaway | Missouri | 29027 | 11453 | 105 |
2185516 | 2185516 | 2022-02-05 | Miller | Missouri | 29131 | 5871 | 105 |
2182201 | 2182201 | 2022-02-04 | Barry | Missouri | 29009 | 6383 | 105 |
2182210 | 2182210 | 2022-02-04 | Callaway | Missouri | 29027 | 11424 | 105 |
2182264 | 2182264 | 2022-02-04 | Miller | Missouri | 29131 | 5864 | 105 |
2178949 | 2178949 | 2022-02-03 | Barry | Missouri | 29009 | 6346 | 105 |
2178958 | 2178958 | 2022-02-03 | Callaway | Missouri | 29027 | 11406 | 105 |
2179012 | 2179012 | 2022-02-03 | Miller | Missouri | 29131 | 5861 | 105 |
2175697 | 2175697 | 2022-02-02 | Barry | Missouri | 29009 | 6322 | 105 |
2175706 | 2175706 | 2022-02-02 | Callaway | Missouri | 29027 | 11369 | 105 |
2175760 | 2175760 | 2022-02-02 | Miller | Missouri | 29131 | 5850 | 105 |
2172453 | 2172453 | 2022-02-01 | Callaway | Missouri | 29027 | 11304 | 105 |
2172507 | 2172507 | 2022-02-01 | Miller | Missouri | 29131 | 5821 | 105 |
2172526 | 2172526 | 2022-02-01 | Pulaski | Missouri | 29169 | 8380 | 105 |
2172546 | 2172546 | 2022-02-01 | Stone | Missouri | 29209 | 5455 | 105 |
2169245 | 2169245 | 2022-01-31 | Lincoln | Missouri | 29113 | 14550 | 105 |
2169254 | 2169254 | 2022-01-31 | Miller | Missouri | 29131 | 5797 | 105 |
2165990 | 2165990 | 2022-01-30 | Lincoln | Missouri | 29113 | 14540 | 105 |
2165999 | 2165999 | 2022-01-30 | Miller | Missouri | 29131 | 5772 | 105 |
2162735 | 2162735 | 2022-01-29 | Lincoln | Missouri | 29113 | 14524 | 105 |
2162744 | 2162744 | 2022-01-29 | Miller | Missouri | 29131 | 5757 | 105 |
2159480 | 2159480 | 2022-01-28 | Lincoln | Missouri | 29113 | 14490 | 105 |
2159489 | 2159489 | 2022-01-28 | Miller | Missouri | 29131 | 5715 | 105 |
2156226 | 2156226 | 2022-01-27 | Lincoln | Missouri | 29113 | 14436 | 105 |
2156235 | 2156235 | 2022-01-27 | Miller | Missouri | 29131 | 5683 | 105 |
2152973 | 2152973 | 2022-01-26 | Lincoln | Missouri | 29113 | 14367 | 105 |
2152982 | 2152982 | 2022-01-26 | Miller | Missouri | 29131 | 5619 | 105 |
2149730 | 2149730 | 2022-01-25 | Miller | Missouri | 29131 | 5557 | 105 |
2146466 | 2146466 | 2022-01-24 | Lafayette | Missouri | 29107 | 7053 | 105 |
2146478 | 2146478 | 2022-01-24 | Miller | Missouri | 29131 | 5504 | 105 |
2143211 | 2143211 | 2022-01-23 | Lafayette | Missouri | 29107 | 7029 | 105 |
2143223 | 2143223 | 2022-01-23 | Miller | Missouri | 29131 | 5490 | 105 |
2139956 | 2139956 | 2022-01-22 | Lafayette | Missouri | 29107 | 6974 | 105 |
2139968 | 2139968 | 2022-01-22 | Miller | Missouri | 29131 | 5437 | 105 |
2136700 | 2136700 | 2022-01-21 | Lafayette | Missouri | 29107 | 6909 | 105 |
2136712 | 2136712 | 2022-01-21 | Miller | Missouri | 29131 | 5390 | 105 |
2133448 | 2133448 | 2022-01-20 | Lafayette | Missouri | 29107 | 6809 | 105 |
2133460 | 2133460 | 2022-01-20 | Miller | Missouri | 29131 | 5319 | 105 |
2130207 | 2130207 | 2022-01-19 | Miller | Missouri | 29131 | 5212 | 105 |
2126953 | 2126953 | 2022-01-18 | Miller | Missouri | 29131 | 5140 | 105 |
2123701 | 2123701 | 2022-01-17 | Miller | Missouri | 29131 | 4981 | 105 |
2120449 | 2120449 | 2022-01-16 | Miller | Missouri | 29131 | 4981 | 105 |
2117197 | 2117197 | 2022-01-15 | Miller | Missouri | 29131 | 4981 | 105 |
2113946 | 2113946 | 2022-01-14 | Miller | Missouri | 29131 | 4909 | 105 |
2110694 | 2110694 | 2022-01-13 | Miller | Missouri | 29131 | 4862 | 105 |
2107443 | 2107443 | 2022-01-12 | Miller | Missouri | 29131 | 4802 | 105 |
2104192 | 2104192 | 2022-01-11 | Miller | Missouri | 29131 | 4764 | 105 |
2100938 | 2100938 | 2022-01-10 | Marion | Missouri | 29127 | 6457 | 105 |
2097687 | 2097687 | 2022-01-09 | Marion | Missouri | 29127 | 6451 | 105 |
2094435 | 2094435 | 2022-01-08 | Marion | Missouri | 29127 | 6450 | 105 |
2091183 | 2091183 | 2022-01-07 | Marion | Missouri | 29127 | 6410 | 105 |
2087932 | 2087932 | 2022-01-06 | Marion | Missouri | 29127 | 6352 | 105 |
2084680 | 2084680 | 2022-01-05 | Marion | Missouri | 29127 | 6328 | 105 |
1941697 | 1941697 | 2021-11-22 | Stoddard | Missouri | 29207 | 4623 | 105 |
1928696 | 1928696 | 2021-11-18 | Stoddard | Missouri | 29207 | 4600 | 105 |
1918923 | 1918923 | 2021-11-15 | Pettis | Missouri | 29159 | 7531 | 105 |
1915673 | 1915673 | 2021-11-14 | Pettis | Missouri | 29159 | 7524 | 105 |
1912423 | 1912423 | 2021-11-13 | Pettis | Missouri | 29159 | 7518 | 105 |
1909173 | 1909173 | 2021-11-12 | Pettis | Missouri | 29159 | 7510 | 105 |
1905924 | 1905924 | 2021-11-11 | Pettis | Missouri | 29159 | 7467 | 105 |
1902675 | 1902675 | 2021-11-10 | Pettis | Missouri | 29159 | 7467 | 105 |
1899425 | 1899425 | 2021-11-09 | Pettis | Missouri | 29159 | 7463 | 105 |
1600464 | 1600464 | 2021-08-09 | Camden | Missouri | 29029 | 5289 | 105 |
1597216 | 1597216 | 2021-08-08 | Camden | Missouri | 29029 | 5272 | 105 |
1593967 | 1593967 | 2021-08-07 | Camden | Missouri | 29029 | 5260 | 105 |
1590718 | 1590718 | 2021-08-06 | Camden | Missouri | 29029 | 5240 | 105 |
1512865 | 1512865 | 2021-07-13 | Taney | Missouri | 29213 | 6588 | 105 |
1214147 | 1214147 | 2021-04-12 | Joplin | Missouri | 6010 | 105 | |
1210899 | 1210899 | 2021-04-11 | Joplin | Missouri | 6008 | 105 | |
1207650 | 1207650 | 2021-04-10 | Joplin | Missouri | 6006 | 105 | |
1204402 | 1204402 | 2021-04-09 | Joplin | Missouri | 6002 | 105 |
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);