ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89,600 rows where state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- St. Louis 595
- Greene 589
- Henry 588
- Cass 585
- Boone 584
- Cole 584
- Jackson 584
- St. Charles 584
- St. Louis city 584
- Pulaski 582
- Scott 582
- Christian 581
- Dunklin 581
- Kansas City 581
- Bates 580
- Jasper 580
- Johnson 580
- St. Francois 579
- Taney 579
- Adair 578
- Callaway 578
- Camden 578
- Clay 578
- Clinton 578
- Lafayette 578
- Moniteau 578
- Perry 578
- Cape Girardeau 577
- Franklin 577
- Jefferson 577
- …
state 1
- Missouri · 65,766 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1840938 | 1840938 | 2021-10-22 | Pike | Missouri | 29163 | 2502 | 37 |
1840939 | 1840939 | 2021-10-22 | Platte | Missouri | 29165 | 5923 | 61 |
1840940 | 1840940 | 2021-10-22 | Polk | Missouri | 29167 | 5097 | 52 |
1840941 | 1840941 | 2021-10-22 | Pulaski | Missouri | 29169 | 5183 | 79 |
1840942 | 1840942 | 2021-10-22 | Putnam | Missouri | 29171 | 622 | 10 |
1840943 | 1840943 | 2021-10-22 | Ralls | Missouri | 29173 | 1530 | 14 |
1840944 | 1840944 | 2021-10-22 | Randolph | Missouri | 29175 | 3598 | 36 |
1840945 | 1840945 | 2021-10-22 | Ray | Missouri | 29177 | 2925 | 50 |
1840946 | 1840946 | 2021-10-22 | Reynolds | Missouri | 29179 | 779 | 7 |
1840947 | 1840947 | 2021-10-22 | Ripley | Missouri | 29181 | 1916 | 24 |
1840948 | 1840948 | 2021-10-22 | Saline | Missouri | 29195 | 4071 | 46 |
1840949 | 1840949 | 2021-10-22 | Schuyler | Missouri | 29197 | 412 | 9 |
1840950 | 1840950 | 2021-10-22 | Scotland | Missouri | 29199 | 393 | 4 |
1840951 | 1840951 | 2021-10-22 | Scott | Missouri | 29201 | 7137 | 113 |
1840952 | 1840952 | 2021-10-22 | Shannon | Missouri | 29203 | 983 | 17 |
1840953 | 1840953 | 2021-10-22 | Shelby | Missouri | 29205 | 927 | 9 |
1840954 | 1840954 | 2021-10-22 | St. Charles | Missouri | 29183 | 61409 | 679 |
1840955 | 1840955 | 2021-10-22 | St. Clair | Missouri | 29185 | 1251 | 14 |
1840956 | 1840956 | 2021-10-22 | St. Francois | Missouri | 29187 | 11922 | 164 |
1840957 | 1840957 | 2021-10-22 | St. Louis | Missouri | 29189 | 128725 | 2540 |
1840958 | 1840958 | 2021-10-22 | St. Louis city | Missouri | 29510 | 32322 | 601 |
1840959 | 1840959 | 2021-10-22 | Ste. Genevieve | Missouri | 29186 | 2389 | 29 |
1840960 | 1840960 | 2021-10-22 | Stoddard | Missouri | 29207 | 4365 | 69 |
1840961 | 1840961 | 2021-10-22 | Stone | Missouri | 29209 | 3946 | 84 |
1840962 | 1840962 | 2021-10-22 | Sullivan | Missouri | 29211 | 1200 | 14 |
1840963 | 1840963 | 2021-10-22 | Taney | Missouri | 29213 | 8965 | 151 |
1840964 | 1840964 | 2021-10-22 | Texas | Missouri | 29215 | 2948 | 42 |
1840965 | 1840965 | 2021-10-22 | Vernon | Missouri | 29217 | 3022 | 64 |
1840966 | 1840966 | 2021-10-22 | Warren | Missouri | 29219 | 4969 | 45 |
1840967 | 1840967 | 2021-10-22 | Washington | Missouri | 29221 | 3913 | 66 |
1840968 | 1840968 | 2021-10-22 | Wayne | Missouri | 29223 | 1583 | 18 |
1840969 | 1840969 | 2021-10-22 | Webster | Missouri | 29225 | 5710 | 89 |
1840970 | 1840970 | 2021-10-22 | Worth | Missouri | 29227 | 222 | 2 |
1840971 | 1840971 | 2021-10-22 | Wright | Missouri | 29229 | 2539 | 49 |
1837606 | 1837606 | 2021-10-21 | Adair | Missouri | 29001 | 3605 | 34 |
1837607 | 1837607 | 2021-10-21 | Andrew | Missouri | 29003 | 2746 | 24 |
1837608 | 1837608 | 2021-10-21 | Atchison | Missouri | 29005 | 666 | 7 |
1837609 | 1837609 | 2021-10-21 | Audrain | Missouri | 29007 | 3715 | 64 |
1837610 | 1837610 | 2021-10-21 | Barry | Missouri | 29009 | 4281 | 60 |
1837611 | 1837611 | 2021-10-21 | Barton | Missouri | 29011 | 1775 | 27 |
1837612 | 1837612 | 2021-10-21 | Bates | Missouri | 29013 | 2290 | 43 |
1837613 | 1837613 | 2021-10-21 | Benton | Missouri | 29015 | 2593 | 45 |
1837614 | 1837614 | 2021-10-21 | Bollinger | Missouri | 29017 | 1753 | 20 |
1837615 | 1837615 | 2021-10-21 | Boone | Missouri | 29019 | 25313 | 169 |
1837616 | 1837616 | 2021-10-21 | Buchanan | Missouri | 29021 | 15135 | 222 |
1837617 | 1837617 | 2021-10-21 | Butler | Missouri | 29023 | 6661 | 71 |
1837618 | 1837618 | 2021-10-21 | Caldwell | Missouri | 29025 | 1125 | 20 |
1837619 | 1837619 | 2021-10-21 | Callaway | Missouri | 29027 | 7397 | 69 |
1837620 | 1837620 | 2021-10-21 | Camden | Missouri | 29029 | 6292 | 123 |
1837621 | 1837621 | 2021-10-21 | Cape Girardeau | Missouri | 29031 | 13041 | 153 |
1837622 | 1837622 | 2021-10-21 | Carroll | Missouri | 29033 | 1373 | 27 |
1837623 | 1837623 | 2021-10-21 | Carter | Missouri | 29035 | 1073 | 14 |
1837624 | 1837624 | 2021-10-21 | Cass | Missouri | 29037 | 14238 | 162 |
1837625 | 1837625 | 2021-10-21 | Cedar | Missouri | 29039 | 1668 | 30 |
1837626 | 1837626 | 2021-10-21 | Chariton | Missouri | 29041 | 1032 | 8 |
1837627 | 1837627 | 2021-10-21 | Christian | Missouri | 29043 | 12854 | 157 |
1837628 | 1837628 | 2021-10-21 | Clark | Missouri | 29045 | 981 | 12 |
1837629 | 1837629 | 2021-10-21 | Clay | Missouri | 29047 | 14817 | 215 |
1837630 | 1837630 | 2021-10-21 | Clinton | Missouri | 29049 | 2839 | 77 |
1837631 | 1837631 | 2021-10-21 | Cole | Missouri | 29051 | 12834 | 171 |
1837632 | 1837632 | 2021-10-21 | Cooper | Missouri | 29053 | 2733 | 33 |
1837633 | 1837633 | 2021-10-21 | Crawford | Missouri | 29055 | 3587 | 57 |
1837634 | 1837634 | 2021-10-21 | Dade | Missouri | 29057 | 865 | 17 |
1837635 | 1837635 | 2021-10-21 | Dallas | Missouri | 29059 | 2254 | 42 |
1837636 | 1837636 | 2021-10-21 | Daviess | Missouri | 29061 | 1022 | 14 |
1837637 | 1837637 | 2021-10-21 | DeKalb | Missouri | 29063 | 1464 | 33 |
1837638 | 1837638 | 2021-10-21 | Dent | Missouri | 29065 | 1923 | 41 |
1837639 | 1837639 | 2021-10-21 | Douglas | Missouri | 29067 | 1627 | 46 |
1837640 | 1837640 | 2021-10-21 | Dunklin | Missouri | 29069 | 4317 | 61 |
1837641 | 1837641 | 2021-10-21 | Franklin | Missouri | 29071 | 14348 | 219 |
1837642 | 1837642 | 2021-10-21 | Gasconade | Missouri | 29073 | 2172 | 50 |
1837643 | 1837643 | 2021-10-21 | Gentry | Missouri | 29075 | 1283 | 26 |
1837644 | 1837644 | 2021-10-21 | Greene | Missouri | 29077 | 44586 | 665 |
1837645 | 1837645 | 2021-10-21 | Grundy | Missouri | 29079 | 1571 | 47 |
1837646 | 1837646 | 2021-10-21 | Harrison | Missouri | 29081 | 1106 | 17 |
1837647 | 1837647 | 2021-10-21 | Henry | Missouri | 29083 | 3256 | 49 |
1837648 | 1837648 | 2021-10-21 | Hickory | Missouri | 29085 | 1087 | 21 |
1837649 | 1837649 | 2021-10-21 | Holt | Missouri | 29087 | 610 | 16 |
1837650 | 1837650 | 2021-10-21 | Howard | Missouri | 29089 | 1413 | 12 |
1837651 | 1837651 | 2021-10-21 | Howell | Missouri | 29091 | 5686 | 74 |
1837652 | 1837652 | 2021-10-21 | Iron | Missouri | 29093 | 1353 | 14 |
1837653 | 1837653 | 2021-10-21 | Jackson | Missouri | 29095 | 55452 | 683 |
1837654 | 1837654 | 2021-10-21 | Jasper | Missouri | 29097 | 13646 | 196 |
1837655 | 1837655 | 2021-10-21 | Jefferson | Missouri | 29099 | 31972 | 324 |
1837656 | 1837656 | 2021-10-21 | Johnson | Missouri | 29101 | 7123 | 73 |
1837657 | 1837657 | 2021-10-21 | Joplin | Missouri | 8675 | 150 | |
1837658 | 1837658 | 2021-10-21 | Kansas City | Missouri | 62898 | 817 | |
1837659 | 1837659 | 2021-10-21 | Knox | Missouri | 29103 | 512 | 3 |
1837660 | 1837660 | 2021-10-21 | Laclede | Missouri | 29105 | 5252 | 127 |
1837661 | 1837661 | 2021-10-21 | Lafayette | Missouri | 29107 | 4602 | 73 |
1837662 | 1837662 | 2021-10-21 | Lawrence | Missouri | 29109 | 5169 | 104 |
1837663 | 1837663 | 2021-10-21 | Lewis | Missouri | 29111 | 1664 | 22 |
1837664 | 1837664 | 2021-10-21 | Lincoln | Missouri | 29113 | 9203 | 68 |
1837665 | 1837665 | 2021-10-21 | Linn | Missouri | 29115 | 1831 | 26 |
1837666 | 1837666 | 2021-10-21 | Livingston | Missouri | 29117 | 2555 | 62 |
1837667 | 1837667 | 2021-10-21 | Macon | Missouri | 29121 | 2178 | 20 |
1837668 | 1837668 | 2021-10-21 | Madison | Missouri | 29123 | 2315 | 25 |
1837669 | 1837669 | 2021-10-21 | Maries | Missouri | 29125 | 980 | 19 |
1837670 | 1837670 | 2021-10-21 | Marion | Missouri | 29127 | 5139 | 63 |
1837671 | 1837671 | 2021-10-21 | McDonald | Missouri | 29119 | 3995 | 58 |
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);