ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where "date" is on date 2020-05-14 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
143627 | 143627 | 2020-05-14 | Adair | Missouri | 29001 | 15 | 0 |
143628 | 143628 | 2020-05-14 | Andrew | Missouri | 29003 | 11 | 0 |
143629 | 143629 | 2020-05-14 | Atchison | Missouri | 29005 | 2 | 0 |
143630 | 143630 | 2020-05-14 | Audrain | Missouri | 29007 | 2 | 0 |
143631 | 143631 | 2020-05-14 | Barry | Missouri | 29009 | 6 | 0 |
143632 | 143632 | 2020-05-14 | Bates | Missouri | 29013 | 6 | 1 |
143633 | 143633 | 2020-05-14 | Benton | Missouri | 29015 | 9 | 0 |
143634 | 143634 | 2020-05-14 | Bollinger | Missouri | 29017 | 4 | 0 |
143635 | 143635 | 2020-05-14 | Boone | Missouri | 29019 | 100 | 1 |
143636 | 143636 | 2020-05-14 | Buchanan | Missouri | 29021 | 496 | 2 |
143637 | 143637 | 2020-05-14 | Butler | Missouri | 29023 | 27 | 0 |
143638 | 143638 | 2020-05-14 | Caldwell | Missouri | 29025 | 3 | 0 |
143639 | 143639 | 2020-05-14 | Callaway | Missouri | 29027 | 23 | 1 |
143640 | 143640 | 2020-05-14 | Camden | Missouri | 29029 | 36 | 1 |
143641 | 143641 | 2020-05-14 | Cape Girardeau | Missouri | 29031 | 51 | 1 |
143642 | 143642 | 2020-05-14 | Carroll | Missouri | 29033 | 4 | 0 |
143643 | 143643 | 2020-05-14 | Carter | Missouri | 29035 | 3 | 1 |
143644 | 143644 | 2020-05-14 | Cass | Missouri | 29037 | 73 | 8 |
143645 | 143645 | 2020-05-14 | Cedar | Missouri | 29039 | 9 | 0 |
143646 | 143646 | 2020-05-14 | Chariton | Missouri | 29041 | 6 | 0 |
143647 | 143647 | 2020-05-14 | Christian | Missouri | 29043 | 21 | 0 |
143648 | 143648 | 2020-05-14 | Clark | Missouri | 29045 | 1 | 0 |
143649 | 143649 | 2020-05-14 | Clay | Missouri | 29047 | 111 | 1 |
143650 | 143650 | 2020-05-14 | Clinton | Missouri | 29049 | 14 | 0 |
143651 | 143651 | 2020-05-14 | Cole | Missouri | 29051 | 55 | 1 |
143652 | 143652 | 2020-05-14 | Cooper | Missouri | 29053 | 9 | 0 |
143653 | 143653 | 2020-05-14 | Crawford | Missouri | 29055 | 8 | 0 |
143654 | 143654 | 2020-05-14 | Dallas | Missouri | 29059 | 2 | 0 |
143655 | 143655 | 2020-05-14 | Daviess | Missouri | 29061 | 3 | 0 |
143656 | 143656 | 2020-05-14 | DeKalb | Missouri | 29063 | 4 | 0 |
143657 | 143657 | 2020-05-14 | Dunklin | Missouri | 29069 | 24 | 2 |
143658 | 143658 | 2020-05-14 | Franklin | Missouri | 29071 | 134 | 14 |
143659 | 143659 | 2020-05-14 | Gasconade | Missouri | 29073 | 2 | 0 |
143660 | 143660 | 2020-05-14 | Gentry | Missouri | 29075 | 2 | 0 |
143661 | 143661 | 2020-05-14 | Greene | Missouri | 29077 | 105 | 8 |
143662 | 143662 | 2020-05-14 | Harrison | Missouri | 29081 | 7 | 0 |
143663 | 143663 | 2020-05-14 | Henry | Missouri | 29083 | 9 | 1 |
143664 | 143664 | 2020-05-14 | Holt | Missouri | 29087 | 1 | 0 |
143665 | 143665 | 2020-05-14 | Howard | Missouri | 29089 | 2 | 0 |
143666 | 143666 | 2020-05-14 | Howell | Missouri | 29091 | 5 | 0 |
143667 | 143667 | 2020-05-14 | Iron | Missouri | 29093 | 2 | 0 |
143668 | 143668 | 2020-05-14 | Jackson | Missouri | 29095 | 407 | 16 |
143669 | 143669 | 2020-05-14 | Jasper | Missouri | 29097 | 27 | 0 |
143670 | 143670 | 2020-05-14 | Jefferson | Missouri | 29099 | 316 | 13 |
143671 | 143671 | 2020-05-14 | Johnson | Missouri | 29101 | 69 | 0 |
143672 | 143672 | 2020-05-14 | Kansas City | Missouri | 838 | 17 | |
143673 | 143673 | 2020-05-14 | Laclede | Missouri | 29105 | 3 | 0 |
143674 | 143674 | 2020-05-14 | Lafayette | Missouri | 29107 | 67 | 1 |
143675 | 143675 | 2020-05-14 | Lawrence | Missouri | 29109 | 7 | 0 |
143676 | 143676 | 2020-05-14 | Lewis | Missouri | 29111 | 6 | 1 |
143677 | 143677 | 2020-05-14 | Lincoln | Missouri | 29113 | 76 | 1 |
143678 | 143678 | 2020-05-14 | Linn | Missouri | 29115 | 5 | 1 |
143679 | 143679 | 2020-05-14 | Livingston | Missouri | 29117 | 3 | 0 |
143680 | 143680 | 2020-05-14 | Macon | Missouri | 29121 | 2 | 0 |
143681 | 143681 | 2020-05-14 | Madison | Missouri | 29123 | 3 | 0 |
143682 | 143682 | 2020-05-14 | Maries | Missouri | 29125 | 2 | 0 |
143683 | 143683 | 2020-05-14 | Marion | Missouri | 29127 | 5 | 0 |
143684 | 143684 | 2020-05-14 | McDonald | Missouri | 29119 | 6 | 0 |
143685 | 143685 | 2020-05-14 | Miller | Missouri | 29131 | 4 | 0 |
143686 | 143686 | 2020-05-14 | Mississippi | Missouri | 29133 | 47 | 0 |
143687 | 143687 | 2020-05-14 | Moniteau | Missouri | 29135 | 44 | 0 |
143688 | 143688 | 2020-05-14 | Montgomery | Missouri | 29139 | 7 | 0 |
143689 | 143689 | 2020-05-14 | Morgan | Missouri | 29141 | 7 | 0 |
143690 | 143690 | 2020-05-14 | New Madrid | Missouri | 29143 | 13 | 0 |
143691 | 143691 | 2020-05-14 | Newton | Missouri | 29145 | 14 | 1 |
143692 | 143692 | 2020-05-14 | Nodaway | Missouri | 29147 | 5 | 0 |
143693 | 143693 | 2020-05-14 | Oregon | Missouri | 29149 | 2 | 0 |
143694 | 143694 | 2020-05-14 | Osage | Missouri | 29151 | 5 | 0 |
143695 | 143695 | 2020-05-14 | Pemiscot | Missouri | 29155 | 67 | 3 |
143696 | 143696 | 2020-05-14 | Perry | Missouri | 29157 | 46 | 0 |
143697 | 143697 | 2020-05-14 | Pettis | Missouri | 29159 | 70 | 1 |
143698 | 143698 | 2020-05-14 | Phelps | Missouri | 29161 | 2 | 0 |
143699 | 143699 | 2020-05-14 | Pike | Missouri | 29163 | 14 | 1 |
143700 | 143700 | 2020-05-14 | Platte | Missouri | 29165 | 50 | 0 |
143701 | 143701 | 2020-05-14 | Polk | Missouri | 29167 | 1 | 0 |
143702 | 143702 | 2020-05-14 | Pulaski | Missouri | 29169 | 36 | 1 |
143703 | 143703 | 2020-05-14 | Ralls | Missouri | 29173 | 2 | 0 |
143704 | 143704 | 2020-05-14 | Randolph | Missouri | 29175 | 8 | 0 |
143705 | 143705 | 2020-05-14 | Ray | Missouri | 29177 | 12 | 0 |
143706 | 143706 | 2020-05-14 | Reynolds | Missouri | 29179 | 2 | 0 |
143707 | 143707 | 2020-05-14 | Ripley | Missouri | 29181 | 6 | 0 |
143708 | 143708 | 2020-05-14 | Saline | Missouri | 29195 | 224 | 0 |
143709 | 143709 | 2020-05-14 | Scotland | Missouri | 29199 | 4 | 0 |
143710 | 143710 | 2020-05-14 | Scott | Missouri | 29201 | 84 | 6 |
143711 | 143711 | 2020-05-14 | Shelby | Missouri | 29205 | 1 | 0 |
143712 | 143712 | 2020-05-14 | St. Charles | Missouri | 29183 | 688 | 52 |
143713 | 143713 | 2020-05-14 | St. Clair | Missouri | 29185 | 2 | 0 |
143714 | 143714 | 2020-05-14 | St. Francois | Missouri | 29187 | 30 | 2 |
143715 | 143715 | 2020-05-14 | St. Louis | Missouri | 29189 | 4022 | 305 |
143716 | 143716 | 2020-05-14 | St. Louis city | Missouri | 29510 | 1596 | 95 |
143717 | 143717 | 2020-05-14 | Ste. Genevieve | Missouri | 29186 | 8 | 1 |
143718 | 143718 | 2020-05-14 | Stoddard | Missouri | 29207 | 30 | 0 |
143719 | 143719 | 2020-05-14 | Stone | Missouri | 29209 | 3 | 0 |
143720 | 143720 | 2020-05-14 | Sullivan | Missouri | 29211 | 9 | 0 |
143721 | 143721 | 2020-05-14 | Taney | Missouri | 29213 | 12 | 2 |
143722 | 143722 | 2020-05-14 | Vernon | Missouri | 29217 | 4 | 0 |
143723 | 143723 | 2020-05-14 | Warren | Missouri | 29219 | 24 | 0 |
143724 | 143724 | 2020-05-14 | Washington | Missouri | 29221 | 9 | 1 |
143725 | 143725 | 2020-05-14 | Webster | Missouri | 29225 | 16 | 0 |
143726 | 143726 | 2020-05-14 | Worth | Missouri | 29227 | 1 | 0 |
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);