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 2022-02-28 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2260242 | 2260242 | 2022-02-28 | Adair | Missouri | 29001 | 6010 | 61 |
2260243 | 2260243 | 2022-02-28 | Andrew | Missouri | 29003 | 4682 | 53 |
2260244 | 2260244 | 2022-02-28 | Atchison | Missouri | 29005 | 1374 | 19 |
2260245 | 2260245 | 2022-02-28 | Audrain | Missouri | 29007 | 5664 | 106 |
2260246 | 2260246 | 2022-02-28 | Barry | Missouri | 29009 | 6567 | 116 |
2260247 | 2260247 | 2022-02-28 | Barton | Missouri | 29011 | 2799 | 48 |
2260248 | 2260248 | 2022-02-28 | Bates | Missouri | 29013 | 3717 | 82 |
2260249 | 2260249 | 2022-02-28 | Benton | Missouri | 29015 | 4109 | 90 |
2260250 | 2260250 | 2022-02-28 | Bollinger | Missouri | 29017 | 2489 | 36 |
2260251 | 2260251 | 2022-02-28 | Boone | Missouri | 29019 | 43043 | 239 |
2260252 | 2260252 | 2022-02-28 | Buchanan | Missouri | 29021 | 24552 | 292 |
2260253 | 2260253 | 2022-02-28 | Butler | Missouri | 29023 | 9903 | 153 |
2260254 | 2260254 | 2022-02-28 | Caldwell | Missouri | 29025 | 1669 | 34 |
2260255 | 2260255 | 2022-02-28 | Callaway | Missouri | 29027 | 11910 | 117 |
2260256 | 2260256 | 2022-02-28 | Camden | Missouri | 29029 | 9209 | 171 |
2260257 | 2260257 | 2022-02-28 | Cape Girardeau | Missouri | 29031 | 18423 | 228 |
2260258 | 2260258 | 2022-02-28 | Carroll | Missouri | 29033 | 2215 | 42 |
2260259 | 2260259 | 2022-02-28 | Carter | Missouri | 29035 | 1486 | 20 |
2260260 | 2260260 | 2022-02-28 | Cass | Missouri | 29037 | 24589 | 283 |
2260261 | 2260261 | 2022-02-28 | Cedar | Missouri | 29039 | 2898 | 48 |
2260262 | 2260262 | 2022-02-28 | Chariton | Missouri | 29041 | 1683 | 34 |
2260263 | 2260263 | 2022-02-28 | Christian | Missouri | 29043 | 20715 | 242 |
2260264 | 2260264 | 2022-02-28 | Clark | Missouri | 29045 | 1575 | 32 |
2260265 | 2260265 | 2022-02-28 | Clay | Missouri | 29047 | 26872 | 346 |
2260266 | 2260266 | 2022-02-28 | Clinton | Missouri | 29049 | 4694 | 111 |
2260267 | 2260267 | 2022-02-28 | Cole | Missouri | 29051 | 19979 | 268 |
2260268 | 2260268 | 2022-02-28 | Cooper | Missouri | 29053 | 4125 | 74 |
2260269 | 2260269 | 2022-02-28 | Crawford | Missouri | 29055 | 5356 | 96 |
2260270 | 2260270 | 2022-02-28 | Dade | Missouri | 29057 | 1415 | 40 |
2260271 | 2260271 | 2022-02-28 | Dallas | Missouri | 29059 | 3770 | 70 |
2260272 | 2260272 | 2022-02-28 | Daviess | Missouri | 29061 | 1663 | 26 |
2260273 | 2260273 | 2022-02-28 | DeKalb | Missouri | 29063 | 2132 | 45 |
2260274 | 2260274 | 2022-02-28 | Dent | Missouri | 29065 | 3227 | 73 |
2260275 | 2260275 | 2022-02-28 | Douglas | Missouri | 29067 | 2529 | 75 |
2260276 | 2260276 | 2022-02-28 | Dunklin | Missouri | 29069 | 7058 | 108 |
2260277 | 2260277 | 2022-02-28 | Franklin | Missouri | 29071 | 22512 | 320 |
2260278 | 2260278 | 2022-02-28 | Gasconade | Missouri | 29073 | 3299 | 93 |
2260279 | 2260279 | 2022-02-28 | Gentry | Missouri | 29075 | 2121 | 29 |
2260280 | 2260280 | 2022-02-28 | Greene | Missouri | 29077 | 70549 | 949 |
2260281 | 2260281 | 2022-02-28 | Grundy | Missouri | 29079 | 2384 | 64 |
2260282 | 2260282 | 2022-02-28 | Harrison | Missouri | 29081 | 1795 | 30 |
2260283 | 2260283 | 2022-02-28 | Henry | Missouri | 29083 | 5705 | 78 |
2260284 | 2260284 | 2022-02-28 | Hickory | Missouri | 29085 | 1814 | 54 |
2260285 | 2260285 | 2022-02-28 | Holt | Missouri | 29087 | 1041 | 27 |
2260286 | 2260286 | 2022-02-28 | Howard | Missouri | 29089 | 2150 | 24 |
2260287 | 2260287 | 2022-02-28 | Howell | Missouri | 29091 | 8778 | 199 |
2260288 | 2260288 | 2022-02-28 | Iron | Missouri | 29093 | 2171 | 36 |
2260289 | 2260289 | 2022-02-28 | Jackson | Missouri | 29095 | 95486 | 1142 |
2260290 | 2260290 | 2022-02-28 | Jasper | Missouri | 29097 | 20731 | 297 |
2260291 | 2260291 | 2022-02-28 | Jefferson | Missouri | 29099 | 53608 | 593 |
2260292 | 2260292 | 2022-02-28 | Johnson | Missouri | 29101 | 11987 | 138 |
2260293 | 2260293 | 2022-02-28 | Joplin | Missouri | 13674 | 211 | |
2260294 | 2260294 | 2022-02-28 | Kansas City | Missouri | 111255 | 1180 | |
2260295 | 2260295 | 2022-02-28 | Knox | Missouri | 29103 | 953 | 12 |
2260296 | 2260296 | 2022-02-28 | Laclede | Missouri | 29105 | 8056 | 166 |
2260297 | 2260297 | 2022-02-28 | Lafayette | Missouri | 29107 | 7703 | 122 |
2260298 | 2260298 | 2022-02-28 | Lawrence | Missouri | 29109 | 7689 | 150 |
2260299 | 2260299 | 2022-02-28 | Lewis | Missouri | 29111 | 2687 | 34 |
2260300 | 2260300 | 2022-02-28 | Lincoln | Missouri | 29113 | 15057 | 126 |
2260301 | 2260301 | 2022-02-28 | Linn | Missouri | 29115 | 2496 | 62 |
2260302 | 2260302 | 2022-02-28 | Livingston | Missouri | 29117 | 3702 | 88 |
2260303 | 2260303 | 2022-02-28 | Macon | Missouri | 29121 | 3599 | 49 |
2260304 | 2260304 | 2022-02-28 | Madison | Missouri | 29123 | 3550 | 49 |
2260305 | 2260305 | 2022-02-28 | Maries | Missouri | 29125 | 1585 | 33 |
2260306 | 2260306 | 2022-02-28 | Marion | Missouri | 29127 | 7916 | 113 |
2260307 | 2260307 | 2022-02-28 | McDonald | Missouri | 29119 | 5765 | 66 |
2260308 | 2260308 | 2022-02-28 | Mercer | Missouri | 29129 | 687 | 12 |
2260309 | 2260309 | 2022-02-28 | Miller | Missouri | 29131 | 6050 | 114 |
2260310 | 2260310 | 2022-02-28 | Mississippi | Missouri | 29133 | 3241 | 55 |
2260311 | 2260311 | 2022-02-28 | Moniteau | Missouri | 29135 | 3789 | 54 |
2260312 | 2260312 | 2022-02-28 | Monroe | Missouri | 29137 | 2151 | 40 |
2260313 | 2260313 | 2022-02-28 | Montgomery | Missouri | 29139 | 2452 | 53 |
2260314 | 2260314 | 2022-02-28 | Morgan | Missouri | 29141 | 3985 | 101 |
2260315 | 2260315 | 2022-02-28 | New Madrid | Missouri | 29143 | 4995 | 79 |
2260316 | 2260316 | 2022-02-28 | Newton | Missouri | 29145 | 11632 | 189 |
2260317 | 2260317 | 2022-02-28 | Nodaway | Missouri | 29147 | 5972 | 42 |
2260318 | 2260318 | 2022-02-28 | Oregon | Missouri | 29149 | 2009 | 31 |
2260319 | 2260319 | 2022-02-28 | Osage | Missouri | 29151 | 3183 | 39 |
2260320 | 2260320 | 2022-02-28 | Ozark | Missouri | 29153 | 1681 | 53 |
2260321 | 2260321 | 2022-02-28 | Pemiscot | Missouri | 29155 | 2946 | 72 |
2260322 | 2260322 | 2022-02-28 | Perry | Missouri | 29157 | 4856 | 44 |
2260323 | 2260323 | 2022-02-28 | Pettis | Missouri | 29159 | 11804 | 151 |
2260324 | 2260324 | 2022-02-28 | Phelps | Missouri | 29161 | 9951 | 229 |
2260325 | 2260325 | 2022-02-28 | Pike | Missouri | 29163 | 4207 | 57 |
2260326 | 2260326 | 2022-02-28 | Platte | Missouri | 29165 | 10214 | 98 |
2260327 | 2260327 | 2022-02-28 | Polk | Missouri | 29167 | 7995 | 103 |
2260328 | 2260328 | 2022-02-28 | Pulaski | Missouri | 29169 | 8761 | 110 |
2260329 | 2260329 | 2022-02-28 | Putnam | Missouri | 29171 | 975 | 22 |
2260330 | 2260330 | 2022-02-28 | Ralls | Missouri | 29173 | 2422 | 24 |
2260331 | 2260331 | 2022-02-28 | Randolph | Missouri | 29175 | 5975 | 100 |
2260332 | 2260332 | 2022-02-28 | Ray | Missouri | 29177 | 5104 | 89 |
2260333 | 2260333 | 2022-02-28 | Reynolds | Missouri | 29179 | 1141 | 23 |
2260334 | 2260334 | 2022-02-28 | Ripley | Missouri | 29181 | 2668 | 58 |
2260335 | 2260335 | 2022-02-28 | Saline | Missouri | 29195 | 6237 | 98 |
2260336 | 2260336 | 2022-02-28 | Schuyler | Missouri | 29197 | 720 | 25 |
2260337 | 2260337 | 2022-02-28 | Scotland | Missouri | 29199 | 682 | 18 |
2260338 | 2260338 | 2022-02-28 | Scott | Missouri | 29201 | 11020 | 152 |
2260339 | 2260339 | 2022-02-28 | Shannon | Missouri | 29203 | 1584 | 35 |
2260340 | 2260340 | 2022-02-28 | Shelby | Missouri | 29205 | 1501 | 15 |
2260341 | 2260341 | 2022-02-28 | St. Charles | Missouri | 29183 | 100923 | 883 |
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);