ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
847294 | 847294 | 2020-12-20 | Adair | Missouri | 29001 | 1560 | 4 |
847295 | 847295 | 2020-12-20 | Andrew | Missouri | 29003 | 1011 | 13 |
847296 | 847296 | 2020-12-20 | Atchison | Missouri | 29005 | 255 | 4 |
847297 | 847297 | 2020-12-20 | Audrain | Missouri | 29007 | 1692 | 31 |
847298 | 847298 | 2020-12-20 | Barry | Missouri | 29009 | 1706 | 35 |
847299 | 847299 | 2020-12-20 | Barton | Missouri | 29011 | 725 | 7 |
847300 | 847300 | 2020-12-20 | Bates | Missouri | 29013 | 723 | 10 |
847301 | 847301 | 2020-12-20 | Benton | Missouri | 29015 | 1134 | 15 |
847302 | 847302 | 2020-12-20 | Bollinger | Missouri | 29017 | 928 | 11 |
847303 | 847303 | 2020-12-20 | Boone | Missouri | 29019 | 12580 | 43 |
847304 | 847304 | 2020-12-20 | Buchanan | Missouri | 29021 | 7758 | 118 |
847305 | 847305 | 2020-12-20 | Butler | Missouri | 29023 | 2646 | 12 |
847306 | 847306 | 2020-12-20 | Caldwell | Missouri | 29025 | 495 | 3 |
847307 | 847307 | 2020-12-20 | Callaway | Missouri | 29027 | 3495 | 17 |
847308 | 847308 | 2020-12-20 | Camden | Missouri | 29029 | 2922 | 58 |
847309 | 847309 | 2020-12-20 | Cape Girardeau | Missouri | 29031 | 7089 | 105 |
847310 | 847310 | 2020-12-20 | Carroll | Missouri | 29033 | 593 | 9 |
847311 | 847311 | 2020-12-20 | Carter | Missouri | 29035 | 354 | 6 |
847312 | 847312 | 2020-12-20 | Cass | Missouri | 29037 | 5060 | 48 |
847313 | 847313 | 2020-12-20 | Cedar | Missouri | 29039 | 483 | 8 |
847314 | 847314 | 2020-12-20 | Chariton | Missouri | 29041 | 298 | 2 |
847315 | 847315 | 2020-12-20 | Christian | Missouri | 29043 | 5498 | 35 |
847316 | 847316 | 2020-12-20 | Clark | Missouri | 29045 | 344 | 4 |
847317 | 847317 | 2020-12-20 | Clay | Missouri | 29047 | 6360 | 87 |
847318 | 847318 | 2020-12-20 | Clinton | Missouri | 29049 | 1156 | 50 |
847319 | 847319 | 2020-12-20 | Cole | Missouri | 29051 | 7192 | 84 |
847320 | 847320 | 2020-12-20 | Cooper | Missouri | 29053 | 1414 | 17 |
847321 | 847321 | 2020-12-20 | Crawford | Missouri | 29055 | 1494 | 15 |
847322 | 847322 | 2020-12-20 | Dade | Missouri | 29057 | 518 | 29 |
847323 | 847323 | 2020-12-20 | Dallas | Missouri | 29059 | 669 | 14 |
847324 | 847324 | 2020-12-20 | Daviess | Missouri | 29061 | 429 | 9 |
847325 | 847325 | 2020-12-20 | DeKalb | Missouri | 29063 | 719 | 17 |
847326 | 847326 | 2020-12-20 | Dent | Missouri | 29065 | 648 | 6 |
847327 | 847327 | 2020-12-20 | Douglas | Missouri | 29067 | 557 | 19 |
847328 | 847328 | 2020-12-20 | Dunklin | Missouri | 29069 | 1984 | 14 |
847329 | 847329 | 2020-12-20 | Franklin | Missouri | 29071 | 5993 | 106 |
847330 | 847330 | 2020-12-20 | Gasconade | Missouri | 29073 | 613 | 29 |
847331 | 847331 | 2020-12-20 | Gentry | Missouri | 29075 | 563 | 15 |
847332 | 847332 | 2020-12-20 | Greene | Missouri | 29077 | 19046 | 260 |
847333 | 847333 | 2020-12-20 | Grundy | Missouri | 29079 | 628 | 19 |
847334 | 847334 | 2020-12-20 | Harrison | Missouri | 29081 | 579 | 7 |
847335 | 847335 | 2020-12-20 | Henry | Missouri | 29083 | 1349 | 19 |
847336 | 847336 | 2020-12-20 | Hickory | Missouri | 29085 | 410 | 6 |
847337 | 847337 | 2020-12-20 | Holt | Missouri | 29087 | 316 | 7 |
847338 | 847338 | 2020-12-20 | Howard | Missouri | 29089 | 592 | 2 |
847339 | 847339 | 2020-12-20 | Howell | Missouri | 29091 | 2144 | 35 |
847340 | 847340 | 2020-12-20 | Iron | Missouri | 29093 | 329 | 1 |
847341 | 847341 | 2020-12-20 | Jackson | Missouri | 29095 | 21519 | 207 |
847342 | 847342 | 2020-12-20 | Jasper | Missouri | 29097 | 5704 | 80 |
847343 | 847343 | 2020-12-20 | Jefferson | Missouri | 29099 | 15307 | 121 |
847344 | 847344 | 2020-12-20 | Johnson | Missouri | 29101 | 3039 | 25 |
847345 | 847345 | 2020-12-20 | Joplin | Missouri | 3736 | 65 | |
847346 | 847346 | 2020-12-20 | Kansas City | Missouri | 28006 | 327 | |
847347 | 847347 | 2020-12-20 | Knox | Missouri | 29103 | 146 | 1 |
847348 | 847348 | 2020-12-20 | Laclede | Missouri | 29105 | 2329 | 39 |
847349 | 847349 | 2020-12-20 | Lafayette | Missouri | 29107 | 1879 | 36 |
847350 | 847350 | 2020-12-20 | Lawrence | Missouri | 29109 | 2190 | 41 |
847351 | 847351 | 2020-12-20 | Lewis | Missouri | 29111 | 501 | 2 |
847352 | 847352 | 2020-12-20 | Lincoln | Missouri | 29113 | 3246 | 17 |
847353 | 847353 | 2020-12-20 | Linn | Missouri | 29115 | 392 | 11 |
847354 | 847354 | 2020-12-20 | Livingston | Missouri | 29117 | 953 | 19 |
847355 | 847355 | 2020-12-20 | Macon | Missouri | 29121 | 851 | 5 |
847356 | 847356 | 2020-12-20 | Madison | Missouri | 29123 | 1097 | 10 |
847357 | 847357 | 2020-12-20 | Maries | Missouri | 29125 | 433 | 6 |
847358 | 847358 | 2020-12-20 | Marion | Missouri | 29127 | 2197 | 23 |
847359 | 847359 | 2020-12-20 | McDonald | Missouri | 29119 | 1864 | 24 |
847360 | 847360 | 2020-12-20 | Mercer | Missouri | 29129 | 119 | 1 |
847361 | 847361 | 2020-12-20 | Miller | Missouri | 29131 | 1902 | 42 |
847362 | 847362 | 2020-12-20 | Mississippi | Missouri | 29133 | 1088 | 10 |
847363 | 847363 | 2020-12-20 | Moniteau | Missouri | 29135 | 1422 | 16 |
847364 | 847364 | 2020-12-20 | Monroe | Missouri | 29137 | 473 | 5 |
847365 | 847365 | 2020-12-20 | Montgomery | Missouri | 29139 | 452 | 6 |
847366 | 847366 | 2020-12-20 | Morgan | Missouri | 29141 | 1374 | 16 |
847367 | 847367 | 2020-12-20 | New Madrid | Missouri | 29143 | 1532 | 26 |
847368 | 847368 | 2020-12-20 | Newton | Missouri | 29145 | 3266 | 40 |
847369 | 847369 | 2020-12-20 | Nodaway | Missouri | 29147 | 2253 | 18 |
847370 | 847370 | 2020-12-20 | Oregon | Missouri | 29149 | 495 | 3 |
847371 | 847371 | 2020-12-20 | Osage | Missouri | 29151 | 1110 | 6 |
847372 | 847372 | 2020-12-20 | Ozark | Missouri | 29153 | 349 | 4 |
847373 | 847373 | 2020-12-20 | Pemiscot | Missouri | 29155 | 1231 | 20 |
847374 | 847374 | 2020-12-20 | Perry | Missouri | 29157 | 1771 | 15 |
847375 | 847375 | 2020-12-20 | Pettis | Missouri | 29159 | 3902 | 50 |
847376 | 847376 | 2020-12-20 | Phelps | Missouri | 29161 | 2256 | 76 |
847377 | 847377 | 2020-12-20 | Pike | Missouri | 29163 | 1178 | 11 |
847378 | 847378 | 2020-12-20 | Platte | Missouri | 29165 | 2138 | 19 |
847379 | 847379 | 2020-12-20 | Polk | Missouri | 29167 | 2281 | 36 |
847380 | 847380 | 2020-12-20 | Pulaski | Missouri | 29169 | 2262 | 26 |
847381 | 847381 | 2020-12-20 | Putnam | Missouri | 29171 | 188 | 1 |
847382 | 847382 | 2020-12-20 | Ralls | Missouri | 29173 | 599 | 4 |
847383 | 847383 | 2020-12-20 | Randolph | Missouri | 29175 | 1503 | 15 |
847384 | 847384 | 2020-12-20 | Ray | Missouri | 29177 | 977 | 7 |
847385 | 847385 | 2020-12-20 | Reynolds | Missouri | 29179 | 364 | 2 |
847386 | 847386 | 2020-12-20 | Ripley | Missouri | 29181 | 627 | 8 |
847387 | 847387 | 2020-12-20 | Saline | Missouri | 29195 | 1857 | 16 |
847388 | 847388 | 2020-12-20 | Schuyler | Missouri | 29197 | 178 | 1 |
847389 | 847389 | 2020-12-20 | Scotland | Missouri | 29199 | 217 | 3 |
847390 | 847390 | 2020-12-20 | Scott | Missouri | 29201 | 3167 | 53 |
847391 | 847391 | 2020-12-20 | Shannon | Missouri | 29203 | 395 | 9 |
847392 | 847392 | 2020-12-20 | Shelby | Missouri | 29205 | 279 | 1 |
847393 | 847393 | 2020-12-20 | St. Charles | Missouri | 29183 | 27417 | 299 |
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);