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 2021-12-07 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1990350 | 1990350 | 2021-12-07 | Adair | Missouri | 29001 | 3953 | 43 |
1990351 | 1990351 | 2021-12-07 | Andrew | Missouri | 29003 | 3180 | 39 |
1990352 | 1990352 | 2021-12-07 | Atchison | Missouri | 29005 | 865 | 17 |
1990353 | 1990353 | 2021-12-07 | Audrain | Missouri | 29007 | 4193 | 79 |
1990354 | 1990354 | 2021-12-07 | Barry | Missouri | 29009 | 4678 | 91 |
1990355 | 1990355 | 2021-12-07 | Barton | Missouri | 29011 | 1891 | 40 |
1990356 | 1990356 | 2021-12-07 | Bates | Missouri | 29013 | 2555 | 59 |
1990357 | 1990357 | 2021-12-07 | Benton | Missouri | 29015 | 2798 | 70 |
1990358 | 1990358 | 2021-12-07 | Bollinger | Missouri | 29017 | 1942 | 31 |
1990359 | 1990359 | 2021-12-07 | Boone | Missouri | 29019 | 27070 | 190 |
1990360 | 1990360 | 2021-12-07 | Buchanan | Missouri | 29021 | 16694 | 244 |
1990361 | 1990361 | 2021-12-07 | Butler | Missouri | 29023 | 7140 | 127 |
1990362 | 1990362 | 2021-12-07 | Caldwell | Missouri | 29025 | 1263 | 26 |
1990363 | 1990363 | 2021-12-07 | Callaway | Missouri | 29027 | 8184 | 96 |
1990364 | 1990364 | 2021-12-07 | Camden | Missouri | 29029 | 6733 | 148 |
1990365 | 1990365 | 2021-12-07 | Cape Girardeau | Missouri | 29031 | 13815 | 201 |
1990366 | 1990366 | 2021-12-07 | Carroll | Missouri | 29033 | 1521 | 39 |
1990367 | 1990367 | 2021-12-07 | Carter | Missouri | 29035 | 1126 | 18 |
1990368 | 1990368 | 2021-12-07 | Cass | Missouri | 29037 | 15843 | 211 |
1990369 | 1990369 | 2021-12-07 | Cedar | Missouri | 29039 | 1915 | 42 |
1990370 | 1990370 | 2021-12-07 | Chariton | Missouri | 29041 | 1195 | 30 |
1990371 | 1990371 | 2021-12-07 | Christian | Missouri | 29043 | 14061 | 203 |
1990372 | 1990372 | 2021-12-07 | Clark | Missouri | 29045 | 1166 | 27 |
1990373 | 1990373 | 2021-12-07 | Clay | Missouri | 29047 | 16903 | 261 |
1990374 | 1990374 | 2021-12-07 | Clinton | Missouri | 29049 | 3252 | 95 |
1990375 | 1990375 | 2021-12-07 | Cole | Missouri | 29051 | 14010 | 233 |
1990376 | 1990376 | 2021-12-07 | Cooper | Missouri | 29053 | 3032 | 53 |
1990377 | 1990377 | 2021-12-07 | Crawford | Missouri | 29055 | 3858 | 75 |
1990378 | 1990378 | 2021-12-07 | Dade | Missouri | 29057 | 926 | 38 |
1990379 | 1990379 | 2021-12-07 | Dallas | Missouri | 29059 | 2465 | 57 |
1990380 | 1990380 | 2021-12-07 | Daviess | Missouri | 29061 | 1173 | 17 |
1990381 | 1990381 | 2021-12-07 | DeKalb | Missouri | 29063 | 1618 | 37 |
1990382 | 1990382 | 2021-12-07 | Dent | Missouri | 29065 | 2150 | 62 |
1990383 | 1990383 | 2021-12-07 | Douglas | Missouri | 29067 | 1794 | 63 |
1990384 | 1990384 | 2021-12-07 | Dunklin | Missouri | 29069 | 4699 | 93 |
1990385 | 1990385 | 2021-12-07 | Franklin | Missouri | 29071 | 16001 | 263 |
1990386 | 1990386 | 2021-12-07 | Gasconade | Missouri | 29073 | 2445 | 80 |
1990387 | 1990387 | 2021-12-07 | Gentry | Missouri | 29075 | 1553 | 28 |
1990388 | 1990388 | 2021-12-07 | Greene | Missouri | 29077 | 47120 | 830 |
1990389 | 1990389 | 2021-12-07 | Grundy | Missouri | 29079 | 1759 | 55 |
1990390 | 1990390 | 2021-12-07 | Harrison | Missouri | 29081 | 1327 | 21 |
1990391 | 1990391 | 2021-12-07 | Henry | Missouri | 29083 | 3678 | 64 |
1990392 | 1990392 | 2021-12-07 | Hickory | Missouri | 29085 | 1268 | 43 |
1990393 | 1990393 | 2021-12-07 | Holt | Missouri | 29087 | 723 | 23 |
1990394 | 1990394 | 2021-12-07 | Howard | Missouri | 29089 | 1554 | 19 |
1990395 | 1990395 | 2021-12-07 | Howell | Missouri | 29091 | 6266 | 170 |
1990396 | 1990396 | 2021-12-07 | Iron | Missouri | 29093 | 1502 | 28 |
1990397 | 1990397 | 2021-12-07 | Jackson | Missouri | 29095 | 60838 | 843 |
1990398 | 1990398 | 2021-12-07 | Jasper | Missouri | 29097 | 14482 | 255 |
1990399 | 1990399 | 2021-12-07 | Jefferson | Missouri | 29099 | 35733 | 435 |
1990400 | 1990400 | 2021-12-07 | Johnson | Missouri | 29101 | 8002 | 109 |
1990401 | 1990401 | 2021-12-07 | Joplin | Missouri | 9267 | 186 | |
1990402 | 1990402 | 2021-12-07 | Kansas City | Missouri | 69353 | 954 | |
1990403 | 1990403 | 2021-12-07 | Knox | Missouri | 29103 | 646 | 8 |
1990404 | 1990404 | 2021-12-07 | Laclede | Missouri | 29105 | 5649 | 149 |
1990405 | 1990405 | 2021-12-07 | Lafayette | Missouri | 29107 | 5129 | 87 |
1990406 | 1990406 | 2021-12-07 | Lawrence | Missouri | 29109 | 5482 | 138 |
1990407 | 1990407 | 2021-12-07 | Lewis | Missouri | 29111 | 1865 | 30 |
1990408 | 1990408 | 2021-12-07 | Lincoln | Missouri | 29113 | 10424 | 94 |
1990409 | 1990409 | 2021-12-07 | Linn | Missouri | 29115 | 1927 | 57 |
1990410 | 1990410 | 2021-12-07 | Livingston | Missouri | 29117 | 2705 | 79 |
1990411 | 1990411 | 2021-12-07 | Macon | Missouri | 29121 | 2456 | 34 |
1990412 | 1990412 | 2021-12-07 | Madison | Missouri | 29123 | 2494 | 40 |
1990413 | 1990413 | 2021-12-07 | Maries | Missouri | 29125 | 1105 | 21 |
1990414 | 1990414 | 2021-12-07 | Marion | Missouri | 29127 | 5642 | 100 |
1990415 | 1990415 | 2021-12-07 | McDonald | Missouri | 29119 | 4159 | 63 |
1990416 | 1990416 | 2021-12-07 | Mercer | Missouri | 29129 | 478 | 9 |
1990417 | 1990417 | 2021-12-07 | Miller | Missouri | 29131 | 4321 | 100 |
1990418 | 1990418 | 2021-12-07 | Mississippi | Missouri | 29133 | 2396 | 49 |
1990419 | 1990419 | 2021-12-07 | Moniteau | Missouri | 29135 | 2812 | 46 |
1990420 | 1990420 | 2021-12-07 | Monroe | Missouri | 29137 | 1481 | 32 |
1990421 | 1990421 | 2021-12-07 | Montgomery | Missouri | 29139 | 1652 | 34 |
1990422 | 1990422 | 2021-12-07 | Morgan | Missouri | 29141 | 2835 | 73 |
1990423 | 1990423 | 2021-12-07 | New Madrid | Missouri | 29143 | 3470 | 70 |
1990424 | 1990424 | 2021-12-07 | Newton | Missouri | 29145 | 8186 | 169 |
1990425 | 1990425 | 2021-12-07 | Nodaway | Missouri | 29147 | 4092 | 37 |
1990426 | 1990426 | 2021-12-07 | Oregon | Missouri | 29149 | 1460 | 25 |
1990427 | 1990427 | 2021-12-07 | Osage | Missouri | 29151 | 2346 | 35 |
1990428 | 1990428 | 2021-12-07 | Ozark | Missouri | 29153 | 1244 | 42 |
1990429 | 1990429 | 2021-12-07 | Pemiscot | Missouri | 29155 | 2134 | 59 |
1990430 | 1990430 | 2021-12-07 | Perry | Missouri | 29157 | 3533 | 39 |
1990431 | 1990431 | 2021-12-07 | Pettis | Missouri | 29159 | 7923 | 128 |
1990432 | 1990432 | 2021-12-07 | Phelps | Missouri | 29161 | 6882 | 195 |
1990433 | 1990433 | 2021-12-07 | Pike | Missouri | 29163 | 2951 | 51 |
1990434 | 1990434 | 2021-12-07 | Platte | Missouri | 29165 | 6713 | 71 |
1990435 | 1990435 | 2021-12-07 | Polk | Missouri | 29167 | 5453 | 80 |
1990436 | 1990436 | 2021-12-07 | Pulaski | Missouri | 29169 | 5669 | 97 |
1990437 | 1990437 | 2021-12-07 | Putnam | Missouri | 29171 | 711 | 19 |
1990438 | 1990438 | 2021-12-07 | Ralls | Missouri | 29173 | 1720 | 18 |
1990439 | 1990439 | 2021-12-07 | Randolph | Missouri | 29175 | 3974 | 80 |
1990440 | 1990440 | 2021-12-07 | Ray | Missouri | 29177 | 3336 | 61 |
1990441 | 1990441 | 2021-12-07 | Reynolds | Missouri | 29179 | 790 | 12 |
1990442 | 1990442 | 2021-12-07 | Ripley | Missouri | 29181 | 2080 | 50 |
1990443 | 1990443 | 2021-12-07 | Saline | Missouri | 29195 | 4422 | 84 |
1990444 | 1990444 | 2021-12-07 | Schuyler | Missouri | 29197 | 491 | 22 |
1990445 | 1990445 | 2021-12-07 | Scotland | Missouri | 29199 | 449 | 15 |
1990446 | 1990446 | 2021-12-07 | Scott | Missouri | 29201 | 7719 | 132 |
1990447 | 1990447 | 2021-12-07 | Shannon | Missouri | 29203 | 1146 | 27 |
1990448 | 1990448 | 2021-12-07 | Shelby | Missouri | 29205 | 1050 | 13 |
1990449 | 1990449 | 2021-12-07 | St. Charles | Missouri | 29183 | 66396 | 729 |
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);