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-07-15 and state = "Missouri" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
336122 | 336122 | 2020-07-15 | Adair | Missouri | 29001 | 109 | 0 |
336123 | 336123 | 2020-07-15 | Andrew | Missouri | 29003 | 55 | 1 |
336124 | 336124 | 2020-07-15 | Atchison | Missouri | 29005 | 6 | 0 |
336125 | 336125 | 2020-07-15 | Audrain | Missouri | 29007 | 143 | 1 |
336126 | 336126 | 2020-07-15 | Barry | Missouri | 29009 | 125 | 0 |
336127 | 336127 | 2020-07-15 | Barton | Missouri | 29011 | 41 | 0 |
336128 | 336128 | 2020-07-15 | Bates | Missouri | 29013 | 16 | 1 |
336129 | 336129 | 2020-07-15 | Benton | Missouri | 29015 | 26 | 0 |
336130 | 336130 | 2020-07-15 | Bollinger | Missouri | 29017 | 30 | 0 |
336131 | 336131 | 2020-07-15 | Boone | Missouri | 29019 | 800 | 3 |
336132 | 336132 | 2020-07-15 | Buchanan | Missouri | 29021 | 955 | 6 |
336133 | 336133 | 2020-07-15 | Butler | Missouri | 29023 | 122 | 0 |
336134 | 336134 | 2020-07-15 | Caldwell | Missouri | 29025 | 15 | 1 |
336135 | 336135 | 2020-07-15 | Callaway | Missouri | 29027 | 64 | 1 |
336136 | 336136 | 2020-07-15 | Camden | Missouri | 29029 | 92 | 2 |
336137 | 336137 | 2020-07-15 | Cape Girardeau | Missouri | 29031 | 375 | 3 |
336138 | 336138 | 2020-07-15 | Carroll | Missouri | 29033 | 41 | 0 |
336139 | 336139 | 2020-07-15 | Carter | Missouri | 29035 | 8 | 1 |
336140 | 336140 | 2020-07-15 | Cass | Missouri | 29037 | 316 | 9 |
336141 | 336141 | 2020-07-15 | Cedar | Missouri | 29039 | 15 | 0 |
336142 | 336142 | 2020-07-15 | Chariton | Missouri | 29041 | 7 | 0 |
336143 | 336143 | 2020-07-15 | Christian | Missouri | 29043 | 120 | 1 |
336144 | 336144 | 2020-07-15 | Clark | Missouri | 29045 | 2 | 0 |
336145 | 336145 | 2020-07-15 | Clay | Missouri | 29047 | 589 | 20 |
336146 | 336146 | 2020-07-15 | Clinton | Missouri | 29049 | 36 | 0 |
336147 | 336147 | 2020-07-15 | Cole | Missouri | 29051 | 164 | 2 |
336148 | 336148 | 2020-07-15 | Cooper | Missouri | 29053 | 32 | 0 |
336149 | 336149 | 2020-07-15 | Crawford | Missouri | 29055 | 24 | 0 |
336150 | 336150 | 2020-07-15 | Dade | Missouri | 29057 | 2 | 0 |
336151 | 336151 | 2020-07-15 | Dallas | Missouri | 29059 | 22 | 1 |
336152 | 336152 | 2020-07-15 | Daviess | Missouri | 29061 | 11 | 0 |
336153 | 336153 | 2020-07-15 | DeKalb | Missouri | 29063 | 19 | 0 |
336154 | 336154 | 2020-07-15 | Dent | Missouri | 29065 | 9 | 0 |
336155 | 336155 | 2020-07-15 | Douglas | Missouri | 29067 | 17 | 0 |
336156 | 336156 | 2020-07-15 | Dunklin | Missouri | 29069 | 138 | 3 |
336157 | 336157 | 2020-07-15 | Franklin | Missouri | 29071 | 317 | 18 |
336158 | 336158 | 2020-07-15 | Gasconade | Missouri | 29073 | 18 | 0 |
336159 | 336159 | 2020-07-15 | Gentry | Missouri | 29075 | 68 | 9 |
336160 | 336160 | 2020-07-15 | Greene | Missouri | 29077 | 635 | 9 |
336161 | 336161 | 2020-07-15 | Grundy | Missouri | 29079 | 22 | 1 |
336162 | 336162 | 2020-07-15 | Harrison | Missouri | 29081 | 33 | 0 |
336163 | 336163 | 2020-07-15 | Henry | Missouri | 29083 | 27 | 3 |
336164 | 336164 | 2020-07-15 | Hickory | Missouri | 29085 | 1 | 0 |
336165 | 336165 | 2020-07-15 | Holt | Missouri | 29087 | 1 | 0 |
336166 | 336166 | 2020-07-15 | Howard | Missouri | 29089 | 8 | 0 |
336167 | 336167 | 2020-07-15 | Howell | Missouri | 29091 | 54 | 0 |
336168 | 336168 | 2020-07-15 | Iron | Missouri | 29093 | 3 | 0 |
336169 | 336169 | 2020-07-15 | Jackson | Missouri | 29095 | 1936 | 46 |
336170 | 336170 | 2020-07-15 | Jasper | Missouri | 29097 | 823 | 1 |
336171 | 336171 | 2020-07-15 | Jefferson | Missouri | 29099 | 834 | 23 |
336172 | 336172 | 2020-07-15 | Johnson | Missouri | 29101 | 309 | 2 |
336173 | 336173 | 2020-07-15 | Joplin | Missouri | 293 | 15 | |
336174 | 336174 | 2020-07-15 | Kansas City | Missouri | 3294 | 43 | |
336175 | 336175 | 2020-07-15 | Knox | Missouri | 29103 | 2 | 0 |
336176 | 336176 | 2020-07-15 | Laclede | Missouri | 29105 | 115 | 1 |
336177 | 336177 | 2020-07-15 | Lafayette | Missouri | 29107 | 104 | 2 |
336178 | 336178 | 2020-07-15 | Lawrence | Missouri | 29109 | 65 | 2 |
336179 | 336179 | 2020-07-15 | Lewis | Missouri | 29111 | 8 | 1 |
336180 | 336180 | 2020-07-15 | Lincoln | Missouri | 29113 | 127 | 1 |
336181 | 336181 | 2020-07-15 | Linn | Missouri | 29115 | 22 | 1 |
336182 | 336182 | 2020-07-15 | Livingston | Missouri | 29117 | 27 | 0 |
336183 | 336183 | 2020-07-15 | Macon | Missouri | 29121 | 32 | 0 |
336184 | 336184 | 2020-07-15 | Madison | Missouri | 29123 | 7 | 0 |
336185 | 336185 | 2020-07-15 | Maries | Missouri | 29125 | 6 | 0 |
336186 | 336186 | 2020-07-15 | Marion | Missouri | 29127 | 38 | 0 |
336187 | 336187 | 2020-07-15 | McDonald | Missouri | 29119 | 900 | 1 |
336188 | 336188 | 2020-07-15 | Mercer | Missouri | 29129 | 8 | 0 |
336189 | 336189 | 2020-07-15 | Miller | Missouri | 29131 | 29 | 0 |
336190 | 336190 | 2020-07-15 | Mississippi | Missouri | 29133 | 98 | 0 |
336191 | 336191 | 2020-07-15 | Moniteau | Missouri | 29135 | 72 | 2 |
336192 | 336192 | 2020-07-15 | Monroe | Missouri | 29137 | 7 | 0 |
336193 | 336193 | 2020-07-15 | Montgomery | Missouri | 29139 | 23 | 0 |
336194 | 336194 | 2020-07-15 | Morgan | Missouri | 29141 | 28 | 0 |
336195 | 336195 | 2020-07-15 | New Madrid | Missouri | 29143 | 79 | 1 |
336196 | 336196 | 2020-07-15 | Newton | Missouri | 29145 | 607 | 2 |
336197 | 336197 | 2020-07-15 | Nodaway | Missouri | 29147 | 26 | 0 |
336198 | 336198 | 2020-07-15 | Oregon | Missouri | 29149 | 9 | 0 |
336199 | 336199 | 2020-07-15 | Osage | Missouri | 29151 | 15 | 0 |
336200 | 336200 | 2020-07-15 | Ozark | Missouri | 29153 | 2 | 0 |
336201 | 336201 | 2020-07-15 | Pemiscot | Missouri | 29155 | 141 | 6 |
336202 | 336202 | 2020-07-15 | Perry | Missouri | 29157 | 176 | 3 |
336203 | 336203 | 2020-07-15 | Pettis | Missouri | 29159 | 188 | 2 |
336204 | 336204 | 2020-07-15 | Phelps | Missouri | 29161 | 52 | 0 |
336205 | 336205 | 2020-07-15 | Pike | Missouri | 29163 | 44 | 1 |
336206 | 336206 | 2020-07-15 | Platte | Missouri | 29165 | 184 | 6 |
336207 | 336207 | 2020-07-15 | Polk | Missouri | 29167 | 23 | 0 |
336208 | 336208 | 2020-07-15 | Pulaski | Missouri | 29169 | 146 | 1 |
336209 | 336209 | 2020-07-15 | Putnam | Missouri | 29171 | 3 | 0 |
336210 | 336210 | 2020-07-15 | Ralls | Missouri | 29173 | 10 | 0 |
336211 | 336211 | 2020-07-15 | Randolph | Missouri | 29175 | 21 | 0 |
336212 | 336212 | 2020-07-15 | Ray | Missouri | 29177 | 31 | 0 |
336213 | 336213 | 2020-07-15 | Reynolds | Missouri | 29179 | 10 | 0 |
336214 | 336214 | 2020-07-15 | Ripley | Missouri | 29181 | 22 | 0 |
336215 | 336215 | 2020-07-15 | Saline | Missouri | 29195 | 324 | 5 |
336216 | 336216 | 2020-07-15 | Schuyler | Missouri | 29197 | 5 | 0 |
336217 | 336217 | 2020-07-15 | Scotland | Missouri | 29199 | 11 | 1 |
336218 | 336218 | 2020-07-15 | Scott | Missouri | 29201 | 235 | 13 |
336219 | 336219 | 2020-07-15 | Shannon | Missouri | 29203 | 29 | 0 |
336220 | 336220 | 2020-07-15 | Shelby | Missouri | 29205 | 5 | 0 |
336221 | 336221 | 2020-07-15 | St. Charles | Missouri | 29183 | 1988 | 80 |
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);