ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where "date" is on date 2020-08-01 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
390646 | 390646 | 2020-08-01 | Adair | Missouri | 29001 | 134 | 0 |
390647 | 390647 | 2020-08-01 | Andrew | Missouri | 29003 | 83 | 1 |
390648 | 390648 | 2020-08-01 | Atchison | Missouri | 29005 | 11 | 0 |
390649 | 390649 | 2020-08-01 | Audrain | Missouri | 29007 | 192 | 1 |
390650 | 390650 | 2020-08-01 | Barry | Missouri | 29009 | 227 | 0 |
390651 | 390651 | 2020-08-01 | Barton | Missouri | 29011 | 65 | 0 |
390652 | 390652 | 2020-08-01 | Bates | Missouri | 29013 | 39 | 1 |
390653 | 390653 | 2020-08-01 | Benton | Missouri | 29015 | 71 | 1 |
390654 | 390654 | 2020-08-01 | Bollinger | Missouri | 29017 | 56 | 0 |
390655 | 390655 | 2020-08-01 | Boone | Missouri | 29019 | 1235 | 4 |
390656 | 390656 | 2020-08-01 | Buchanan | Missouri | 29021 | 1083 | 10 |
390657 | 390657 | 2020-08-01 | Butler | Missouri | 29023 | 239 | 2 |
390658 | 390658 | 2020-08-01 | Caldwell | Missouri | 29025 | 30 | 1 |
390659 | 390659 | 2020-08-01 | Callaway | Missouri | 29027 | 123 | 1 |
390660 | 390660 | 2020-08-01 | Camden | Missouri | 29029 | 294 | 4 |
390661 | 390661 | 2020-08-01 | Cape Girardeau | Missouri | 29031 | 596 | 3 |
390662 | 390662 | 2020-08-01 | Carroll | Missouri | 29033 | 98 | 0 |
390663 | 390663 | 2020-08-01 | Carter | Missouri | 29035 | 19 | 1 |
390664 | 390664 | 2020-08-01 | Cass | Missouri | 29037 | 661 | 12 |
390665 | 390665 | 2020-08-01 | Cedar | Missouri | 29039 | 34 | 0 |
390666 | 390666 | 2020-08-01 | Chariton | Missouri | 29041 | 14 | 0 |
390667 | 390667 | 2020-08-01 | Christian | Missouri | 29043 | 278 | 1 |
390668 | 390668 | 2020-08-01 | Clark | Missouri | 29045 | 13 | 0 |
390669 | 390669 | 2020-08-01 | Clay | Missouri | 29047 | 896 | 22 |
390670 | 390670 | 2020-08-01 | Clinton | Missouri | 29049 | 61 | 0 |
390671 | 390671 | 2020-08-01 | Cole | Missouri | 29051 | 307 | 2 |
390672 | 390672 | 2020-08-01 | Cooper | Missouri | 29053 | 91 | 0 |
390673 | 390673 | 2020-08-01 | Crawford | Missouri | 29055 | 52 | 0 |
390674 | 390674 | 2020-08-01 | Dade | Missouri | 29057 | 14 | 0 |
390675 | 390675 | 2020-08-01 | Dallas | Missouri | 29059 | 48 | 1 |
390676 | 390676 | 2020-08-01 | Daviess | Missouri | 29061 | 17 | 0 |
390677 | 390677 | 2020-08-01 | DeKalb | Missouri | 29063 | 32 | 1 |
390678 | 390678 | 2020-08-01 | Dent | Missouri | 29065 | 9 | 0 |
390679 | 390679 | 2020-08-01 | Douglas | Missouri | 29067 | 73 | 2 |
390680 | 390680 | 2020-08-01 | Dunklin | Missouri | 29069 | 242 | 4 |
390681 | 390681 | 2020-08-01 | Franklin | Missouri | 29071 | 516 | 18 |
390682 | 390682 | 2020-08-01 | Gasconade | Missouri | 29073 | 20 | 0 |
390683 | 390683 | 2020-08-01 | Gentry | Missouri | 29075 | 79 | 9 |
390684 | 390684 | 2020-08-01 | Greene | Missouri | 29077 | 1250 | 11 |
390685 | 390685 | 2020-08-01 | Grundy | Missouri | 29079 | 24 | 1 |
390686 | 390686 | 2020-08-01 | Harrison | Missouri | 29081 | 60 | 1 |
390687 | 390687 | 2020-08-01 | Henry | Missouri | 29083 | 69 | 3 |
390688 | 390688 | 2020-08-01 | Hickory | Missouri | 29085 | 16 | 0 |
390689 | 390689 | 2020-08-01 | Holt | Missouri | 29087 | 6 | 0 |
390690 | 390690 | 2020-08-01 | Howard | Missouri | 29089 | 45 | 0 |
390691 | 390691 | 2020-08-01 | Howell | Missouri | 29091 | 133 | 2 |
390692 | 390692 | 2020-08-01 | Iron | Missouri | 29093 | 14 | 0 |
390693 | 390693 | 2020-08-01 | Jackson | Missouri | 29095 | 3396 | 59 |
390694 | 390694 | 2020-08-01 | Jasper | Missouri | 29097 | 1201 | 5 |
390695 | 390695 | 2020-08-01 | Jefferson | Missouri | 29099 | 1417 | 25 |
390696 | 390696 | 2020-08-01 | Johnson | Missouri | 29101 | 463 | 2 |
390697 | 390697 | 2020-08-01 | Joplin | Missouri | 445 | 20 | |
390698 | 390698 | 2020-08-01 | Kansas City | Missouri | 5865 | 69 | |
390699 | 390699 | 2020-08-01 | Knox | Missouri | 29103 | 11 | 0 |
390700 | 390700 | 2020-08-01 | Laclede | Missouri | 29105 | 194 | 1 |
390701 | 390701 | 2020-08-01 | Lafayette | Missouri | 29107 | 151 | 2 |
390702 | 390702 | 2020-08-01 | Lawrence | Missouri | 29109 | 184 | 2 |
390703 | 390703 | 2020-08-01 | Lewis | Missouri | 29111 | 32 | 1 |
390704 | 390704 | 2020-08-01 | Lincoln | Missouri | 29113 | 293 | 1 |
390705 | 390705 | 2020-08-01 | Linn | Missouri | 29115 | 30 | 1 |
390706 | 390706 | 2020-08-01 | Livingston | Missouri | 29117 | 53 | 0 |
390707 | 390707 | 2020-08-01 | Macon | Missouri | 29121 | 53 | 0 |
390708 | 390708 | 2020-08-01 | Madison | Missouri | 29123 | 17 | 0 |
390709 | 390709 | 2020-08-01 | Maries | Missouri | 29125 | 14 | 0 |
390710 | 390710 | 2020-08-01 | Marion | Missouri | 29127 | 150 | 1 |
390711 | 390711 | 2020-08-01 | McDonald | Missouri | 29119 | 988 | 7 |
390712 | 390712 | 2020-08-01 | Mercer | Missouri | 29129 | 8 | 0 |
390713 | 390713 | 2020-08-01 | Miller | Missouri | 29131 | 93 | 0 |
390714 | 390714 | 2020-08-01 | Mississippi | Missouri | 29133 | 129 | 0 |
390715 | 390715 | 2020-08-01 | Moniteau | Missouri | 29135 | 121 | 2 |
390716 | 390716 | 2020-08-01 | Monroe | Missouri | 29137 | 17 | 0 |
390717 | 390717 | 2020-08-01 | Montgomery | Missouri | 29139 | 33 | 0 |
390718 | 390718 | 2020-08-01 | Morgan | Missouri | 29141 | 62 | 0 |
390719 | 390719 | 2020-08-01 | New Madrid | Missouri | 29143 | 179 | 1 |
390720 | 390720 | 2020-08-01 | Newton | Missouri | 29145 | 799 | 6 |
390721 | 390721 | 2020-08-01 | Nodaway | Missouri | 29147 | 153 | 0 |
390722 | 390722 | 2020-08-01 | Oregon | Missouri | 29149 | 13 | 0 |
390723 | 390723 | 2020-08-01 | Osage | Missouri | 29151 | 37 | 0 |
390724 | 390724 | 2020-08-01 | Ozark | Missouri | 29153 | 6 | 0 |
390725 | 390725 | 2020-08-01 | Pemiscot | Missouri | 29155 | 204 | 8 |
390726 | 390726 | 2020-08-01 | Perry | Missouri | 29157 | 202 | 4 |
390727 | 390727 | 2020-08-01 | Pettis | Missouri | 29159 | 407 | 4 |
390728 | 390728 | 2020-08-01 | Phelps | Missouri | 29161 | 75 | 0 |
390729 | 390729 | 2020-08-01 | Pike | Missouri | 29163 | 69 | 1 |
390730 | 390730 | 2020-08-01 | Platte | Missouri | 29165 | 318 | 10 |
390731 | 390731 | 2020-08-01 | Polk | Missouri | 29167 | 189 | 0 |
390732 | 390732 | 2020-08-01 | Pulaski | Missouri | 29169 | 179 | 1 |
390733 | 390733 | 2020-08-01 | Putnam | Missouri | 29171 | 10 | 1 |
390734 | 390734 | 2020-08-01 | Ralls | Missouri | 29173 | 21 | 0 |
390735 | 390735 | 2020-08-01 | Randolph | Missouri | 29175 | 55 | 1 |
390736 | 390736 | 2020-08-01 | Ray | Missouri | 29177 | 90 | 0 |
390737 | 390737 | 2020-08-01 | Reynolds | Missouri | 29179 | 16 | 0 |
390738 | 390738 | 2020-08-01 | Ripley | Missouri | 29181 | 41 | 0 |
390739 | 390739 | 2020-08-01 | Saline | Missouri | 29195 | 409 | 7 |
390740 | 390740 | 2020-08-01 | Schuyler | Missouri | 29197 | 9 | 0 |
390741 | 390741 | 2020-08-01 | Scotland | Missouri | 29199 | 12 | 1 |
390742 | 390742 | 2020-08-01 | Scott | Missouri | 29201 | 341 | 13 |
390743 | 390743 | 2020-08-01 | Shannon | Missouri | 29203 | 43 | 1 |
390744 | 390744 | 2020-08-01 | Shelby | Missouri | 29205 | 28 | 0 |
390745 | 390745 | 2020-08-01 | St. Charles | Missouri | 29183 | 3590 | 97 |
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);