ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
342 rows where deaths = 54 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Miller 50
- Webster 34
- Johnson 21
- Lincoln 21
- Wright 16
- Pike 15
- Platte 15
- Cooper 14
- Hickory 12
- Ripley 9
- Adair 8
- Laclede 8
- McDonald 8
- Vernon 8
- Andrew 7
- Jasper 7
- Livingston 7
- Marion 7
- Montgomery 7
- Stoddard 7
- Audrain 6
- Moniteau 6
- St. Charles 6
- Stone 6
- Washington 6
- Buchanan 5
- Jefferson 5
- Butler 4
- Lafayette 4
- Cass 3
- …
state 1
- Missouri · 342 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2283009 | 2283009 | 2022-03-07 | Andrew | Missouri | 29003 | 4691 | 54 |
2283050 | 2283050 | 2022-03-07 | Hickory | Missouri | 29085 | 1820 | 54 |
2283079 | 2283079 | 2022-03-07 | Montgomery | Missouri | 29139 | 2457 | 54 |
2279756 | 2279756 | 2022-03-06 | Andrew | Missouri | 29003 | 4689 | 54 |
2279797 | 2279797 | 2022-03-06 | Hickory | Missouri | 29085 | 1819 | 54 |
2279826 | 2279826 | 2022-03-06 | Montgomery | Missouri | 29139 | 2456 | 54 |
2276503 | 2276503 | 2022-03-05 | Andrew | Missouri | 29003 | 4689 | 54 |
2276544 | 2276544 | 2022-03-05 | Hickory | Missouri | 29085 | 1819 | 54 |
2276573 | 2276573 | 2022-03-05 | Montgomery | Missouri | 29139 | 2456 | 54 |
2273250 | 2273250 | 2022-03-04 | Andrew | Missouri | 29003 | 4689 | 54 |
2273291 | 2273291 | 2022-03-04 | Hickory | Missouri | 29085 | 1819 | 54 |
2273320 | 2273320 | 2022-03-04 | Montgomery | Missouri | 29139 | 2456 | 54 |
2269998 | 2269998 | 2022-03-03 | Andrew | Missouri | 29003 | 4687 | 54 |
2270039 | 2270039 | 2022-03-03 | Hickory | Missouri | 29085 | 1817 | 54 |
2270068 | 2270068 | 2022-03-03 | Montgomery | Missouri | 29139 | 2455 | 54 |
2266745 | 2266745 | 2022-03-02 | Andrew | Missouri | 29003 | 4687 | 54 |
2266786 | 2266786 | 2022-03-02 | Hickory | Missouri | 29085 | 1817 | 54 |
2266815 | 2266815 | 2022-03-02 | Montgomery | Missouri | 29139 | 2452 | 54 |
2263494 | 2263494 | 2022-03-01 | Andrew | Missouri | 29003 | 4683 | 54 |
2263535 | 2263535 | 2022-03-01 | Hickory | Missouri | 29085 | 1814 | 54 |
2263562 | 2263562 | 2022-03-01 | Moniteau | Missouri | 29135 | 3797 | 54 |
2263564 | 2263564 | 2022-03-01 | Montgomery | Missouri | 29139 | 2452 | 54 |
2260284 | 2260284 | 2022-02-28 | Hickory | Missouri | 29085 | 1814 | 54 |
2260311 | 2260311 | 2022-02-28 | Moniteau | Missouri | 29135 | 3789 | 54 |
2257033 | 2257033 | 2022-02-27 | Hickory | Missouri | 29085 | 1814 | 54 |
2257060 | 2257060 | 2022-02-27 | Moniteau | Missouri | 29135 | 3787 | 54 |
2253782 | 2253782 | 2022-02-26 | Hickory | Missouri | 29085 | 1814 | 54 |
2253809 | 2253809 | 2022-02-26 | Moniteau | Missouri | 29135 | 3787 | 54 |
2250531 | 2250531 | 2022-02-25 | Hickory | Missouri | 29085 | 1814 | 54 |
2250558 | 2250558 | 2022-02-25 | Moniteau | Missouri | 29135 | 3787 | 54 |
2247280 | 2247280 | 2022-02-24 | Hickory | Missouri | 29085 | 1814 | 54 |
2247307 | 2247307 | 2022-02-24 | Moniteau | Missouri | 29135 | 3785 | 54 |
2198555 | 2198555 | 2022-02-09 | Ripley | Missouri | 29181 | 2621 | 54 |
2195301 | 2195301 | 2022-02-08 | Ripley | Missouri | 29181 | 2612 | 54 |
2192047 | 2192047 | 2022-02-07 | Ripley | Missouri | 29181 | 2605 | 54 |
2188794 | 2188794 | 2022-02-06 | Ripley | Missouri | 29181 | 2604 | 54 |
2185541 | 2185541 | 2022-02-05 | Ripley | Missouri | 29181 | 2601 | 54 |
2182289 | 2182289 | 2022-02-04 | Ripley | Missouri | 29181 | 2592 | 54 |
2179037 | 2179037 | 2022-02-03 | Ripley | Missouri | 29181 | 2585 | 54 |
2175785 | 2175785 | 2022-02-02 | Ripley | Missouri | 29181 | 2574 | 54 |
2172532 | 2172532 | 2022-02-01 | Ripley | Missouri | 29181 | 2554 | 54 |
2126886 | 2126886 | 2022-01-18 | Adair | Missouri | 29001 | 4927 | 54 |
2126969 | 2126969 | 2022-01-18 | Pike | Missouri | 29163 | 3579 | 54 |
2123634 | 2123634 | 2022-01-17 | Adair | Missouri | 29001 | 4927 | 54 |
2123717 | 2123717 | 2022-01-17 | Pike | Missouri | 29163 | 3514 | 54 |
2120382 | 2120382 | 2022-01-16 | Adair | Missouri | 29001 | 4927 | 54 |
2120465 | 2120465 | 2022-01-16 | Pike | Missouri | 29163 | 3514 | 54 |
2117130 | 2117130 | 2022-01-15 | Adair | Missouri | 29001 | 4927 | 54 |
2117213 | 2117213 | 2022-01-15 | Pike | Missouri | 29163 | 3514 | 54 |
2113879 | 2113879 | 2022-01-14 | Adair | Missouri | 29001 | 4927 | 54 |
2113962 | 2113962 | 2022-01-14 | Pike | Missouri | 29163 | 3465 | 54 |
2110627 | 2110627 | 2022-01-13 | Adair | Missouri | 29001 | 4761 | 54 |
2110710 | 2110710 | 2022-01-13 | Pike | Missouri | 29163 | 3428 | 54 |
2107376 | 2107376 | 2022-01-12 | Adair | Missouri | 29001 | 4761 | 54 |
2107459 | 2107459 | 2022-01-12 | Pike | Missouri | 29163 | 3405 | 54 |
2104125 | 2104125 | 2022-01-11 | Adair | Missouri | 29001 | 4703 | 54 |
2104208 | 2104208 | 2022-01-11 | Pike | Missouri | 29163 | 3370 | 54 |
2100957 | 2100957 | 2022-01-10 | Pike | Missouri | 29163 | 3326 | 54 |
2097706 | 2097706 | 2022-01-09 | Pike | Missouri | 29163 | 3319 | 54 |
2094454 | 2094454 | 2022-01-08 | Pike | Missouri | 29163 | 3319 | 54 |
2091202 | 2091202 | 2022-01-07 | Pike | Missouri | 29163 | 3299 | 54 |
2087951 | 2087951 | 2022-01-06 | Pike | Missouri | 29163 | 3273 | 54 |
2084699 | 2084699 | 2022-01-05 | Pike | Missouri | 29163 | 3260 | 54 |
2081447 | 2081447 | 2022-01-04 | Pike | Missouri | 29163 | 3247 | 54 |
2055386 | 2055386 | 2021-12-27 | Cooper | Missouri | 29053 | 3207 | 54 |
2052136 | 2052136 | 2021-12-26 | Cooper | Missouri | 29053 | 3188 | 54 |
2048886 | 2048886 | 2021-12-25 | Cooper | Missouri | 29053 | 3188 | 54 |
2045636 | 2045636 | 2021-12-24 | Cooper | Missouri | 29053 | 3188 | 54 |
2042386 | 2042386 | 2021-12-23 | Cooper | Missouri | 29053 | 3188 | 54 |
2039137 | 2039137 | 2021-12-22 | Cooper | Missouri | 29053 | 3182 | 54 |
2035887 | 2035887 | 2021-12-21 | Cooper | Missouri | 29053 | 3171 | 54 |
2032637 | 2032637 | 2021-12-20 | Cooper | Missouri | 29053 | 3164 | 54 |
2029386 | 2029386 | 2021-12-19 | Cooper | Missouri | 29053 | 3157 | 54 |
2026135 | 2026135 | 2021-12-18 | Cooper | Missouri | 29053 | 3155 | 54 |
2022884 | 2022884 | 2021-12-17 | Cooper | Missouri | 29053 | 3142 | 54 |
2019633 | 2019633 | 2021-12-16 | Cooper | Missouri | 29053 | 3114 | 54 |
2016383 | 2016383 | 2021-12-15 | Cooper | Missouri | 29053 | 3105 | 54 |
2013132 | 2013132 | 2021-12-14 | Cooper | Missouri | 29053 | 3095 | 54 |
1925457 | 1925457 | 2021-11-17 | Wright | Missouri | 29229 | 2637 | 54 |
1922208 | 1922208 | 2021-11-16 | Wright | Missouri | 29229 | 2635 | 54 |
1918958 | 1918958 | 2021-11-15 | Wright | Missouri | 29229 | 2631 | 54 |
1915708 | 1915708 | 2021-11-14 | Wright | Missouri | 29229 | 2629 | 54 |
1912458 | 1912458 | 2021-11-13 | Wright | Missouri | 29229 | 2628 | 54 |
1909208 | 1909208 | 2021-11-12 | Wright | Missouri | 29229 | 2616 | 54 |
1905959 | 1905959 | 2021-11-11 | Wright | Missouri | 29229 | 2609 | 54 |
1902710 | 1902710 | 2021-11-10 | Wright | Missouri | 29229 | 2609 | 54 |
1899460 | 1899460 | 2021-11-09 | Wright | Missouri | 29229 | 2605 | 54 |
1896210 | 1896210 | 2021-11-08 | Wright | Missouri | 29229 | 2600 | 54 |
1892960 | 1892960 | 2021-11-07 | Wright | Missouri | 29229 | 2597 | 54 |
1889710 | 1889710 | 2021-11-06 | Wright | Missouri | 29229 | 2597 | 54 |
1886460 | 1886460 | 2021-11-05 | Wright | Missouri | 29229 | 2593 | 54 |
1883211 | 1883211 | 2021-11-04 | Wright | Missouri | 29229 | 2587 | 54 |
1879962 | 1879962 | 2021-11-03 | Wright | Missouri | 29229 | 2580 | 54 |
1876713 | 1876713 | 2021-11-02 | Wright | Missouri | 29229 | 2573 | 54 |
1785695 | 1785695 | 2021-10-05 | New Madrid | Missouri | 29143 | 3241 | 54 |
1782438 | 1782438 | 2021-10-04 | McDonald | Missouri | 29119 | 3894 | 54 |
1779188 | 1779188 | 2021-10-03 | McDonald | Missouri | 29119 | 3894 | 54 |
1775938 | 1775938 | 2021-10-02 | McDonald | Missouri | 29119 | 3894 | 54 |
1772688 | 1772688 | 2021-10-01 | McDonald | Missouri | 29119 | 3894 | 54 |
1769439 | 1769439 | 2021-09-30 | McDonald | Missouri | 29119 | 3889 | 54 |
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);