ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

33,322 rows where state = "Missouri" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Missouri · 33,322 ✖
Link rowid date ▲ county state fips cases deaths
938240 938240 2021-01-17 Adair Missouri 29001 1980 15
938241 938241 2021-01-17 Andrew Missouri 29003 1207 16
938242 938242 2021-01-17 Atchison Missouri 29005 286 6
938243 938243 2021-01-17 Audrain Missouri 29007 1950 44
938244 938244 2021-01-17 Barry Missouri 29009 2026 38
938245 938245 2021-01-17 Barton Missouri 29011 880 9
938246 938246 2021-01-17 Bates Missouri 29013 964 14
938247 938247 2021-01-17 Benton Missouri 29015 1337 19
938248 938248 2021-01-17 Bollinger Missouri 29017 1012 12
938249 938249 2021-01-17 Boone Missouri 29019 15395 65
938250 938250 2021-01-17 Buchanan Missouri 29021 9255 149
938251 938251 2021-01-17 Butler Missouri 29023 3076 18
938252 938252 2021-01-17 Caldwell Missouri 29025 597 7
938253 938253 2021-01-17 Callaway Missouri 29027 4135 29
938254 938254 2021-01-17 Camden Missouri 29029 3497 66
938255 938255 2021-01-17 Cape Girardeau Missouri 29031 8502 128
938256 938256 2021-01-17 Carroll Missouri 29033 733 18
938257 938257 2021-01-17 Carter Missouri 29035 404 7
938258 938258 2021-01-17 Cass Missouri 29037 6426 62
938259 938259 2021-01-17 Cedar Missouri 29039 608 9
938260 938260 2021-01-17 Chariton Missouri 29041 381 3
938261 938261 2021-01-17 Christian Missouri 29043 7359 60
938262 938262 2021-01-17 Clark Missouri 29045 418 5
938263 938263 2021-01-17 Clay Missouri 29047 8179 118
938264 938264 2021-01-17 Clinton Missouri 29049 1417 60
938265 938265 2021-01-17 Cole Missouri 29051 8162 101
938266 938266 2021-01-17 Cooper Missouri 29053 1605 21
938267 938267 2021-01-17 Crawford Missouri 29055 1908 21
938268 938268 2021-01-17 Dade Missouri 29057 652 30
938269 938269 2021-01-17 Dallas Missouri 29059 750 19
938270 938270 2021-01-17 Daviess Missouri 29061 530 10
938271 938271 2021-01-17 DeKalb Missouri 29063 857 21
938272 938272 2021-01-17 Dent Missouri 29065 765 9
938273 938273 2021-01-17 Douglas Missouri 29067 714 20
938274 938274 2021-01-17 Dunklin Missouri 29069 2266 16
938275 938275 2021-01-17 Franklin Missouri 29071 7582 122
938276 938276 2021-01-17 Gasconade Missouri 29073 791 31
938277 938277 2021-01-17 Gentry Missouri 29075 677 16
938278 938278 2021-01-17 Greene Missouri 29077 24445 333
938279 938279 2021-01-17 Grundy Missouri 29079 770 28
938280 938280 2021-01-17 Harrison Missouri 29081 724 10
938281 938281 2021-01-17 Henry Missouri 29083 1579 25
938282 938282 2021-01-17 Hickory Missouri 29085 454 9
938283 938283 2021-01-17 Holt Missouri 29087 346 9
938284 938284 2021-01-17 Howard Missouri 29089 675 4
938285 938285 2021-01-17 Howell Missouri 29091 2635 41
938286 938286 2021-01-17 Iron Missouri 29093 452 1
938287 938287 2021-01-17 Jackson Missouri 29095 26610 283
938288 938288 2021-01-17 Jasper Missouri 29097 6689 94
938289 938289 2021-01-17 Jefferson Missouri 29099 19041 154
938290 938290 2021-01-17 Johnson Missouri 29101 3527 34
938291 938291 2021-01-17 Joplin Missouri   4349 88
938292 938292 2021-01-17 Kansas City Missouri   33674 382
938293 938293 2021-01-17 Knox Missouri 29103 163 2
938294 938294 2021-01-17 Laclede Missouri 29105 2730 54
938295 938295 2021-01-17 Lafayette Missouri 29107 2278 44
938296 938296 2021-01-17 Lawrence Missouri 29109 2542 60
938297 938297 2021-01-17 Lewis Missouri 29111 603 3
938298 938298 2021-01-17 Lincoln Missouri 29113 3891 24
938299 938299 2021-01-17 Linn Missouri 29115 482 11
938300 938300 2021-01-17 Livingston Missouri 29117 1186 25
938301 938301 2021-01-17 Macon Missouri 29121 1064 10
938302 938302 2021-01-17 Madison Missouri 29123 1290 11
938303 938303 2021-01-17 Maries Missouri 29125 501 7
938304 938304 2021-01-17 Marion Missouri 29127 2514 32
938305 938305 2021-01-17 McDonald Missouri 29119 2269 29
938306 938306 2021-01-17 Mercer Missouri 29129 155 2
938307 938307 2021-01-17 Miller Missouri 29131 2215 44
938308 938308 2021-01-17 Mississippi Missouri 29133 1178 20
938309 938309 2021-01-17 Moniteau Missouri 29135 1613 26
938310 938310 2021-01-17 Monroe Missouri 29137 562 7
938311 938311 2021-01-17 Montgomery Missouri 29139 545 9
938312 938312 2021-01-17 Morgan Missouri 29141 1565 31
938313 938313 2021-01-17 New Madrid Missouri 29143 1704 39
938314 938314 2021-01-17 Newton Missouri 29145 3792 60
938315 938315 2021-01-17 Nodaway Missouri 29147 2457 22
938316 938316 2021-01-17 Oregon Missouri 29149 633 3
938317 938317 2021-01-17 Osage Missouri 29151 1299 9
938318 938318 2021-01-17 Ozark Missouri 29153 482 5
938319 938319 2021-01-17 Pemiscot Missouri 29155 1349 23
938320 938320 2021-01-17 Perry Missouri 29157 1953 22
938321 938321 2021-01-17 Pettis Missouri 29159 4592 68
938322 938322 2021-01-17 Phelps Missouri 29161 2792 103
938323 938323 2021-01-17 Pike Missouri 29163 1394 17
938324 938324 2021-01-17 Platte Missouri 29165 2778 27
938325 938325 2021-01-17 Polk Missouri 29167 2937 36
938326 938326 2021-01-17 Pulaski Missouri 29169 2850 33
938327 938327 2021-01-17 Putnam Missouri 29171 207 2
938328 938328 2021-01-17 Ralls Missouri 29173 717 9
938329 938329 2021-01-17 Randolph Missouri 29175 1760 20
938330 938330 2021-01-17 Ray Missouri 29177 1305 13
938331 938331 2021-01-17 Reynolds Missouri 29179 439 3
938332 938332 2021-01-17 Ripley Missouri 29181 745 9
938333 938333 2021-01-17 Saline Missouri 29195 2236 26
938334 938334 2021-01-17 Schuyler Missouri 29197 239 1
938335 938335 2021-01-17 Scotland Missouri 29199 234 3
938336 938336 2021-01-17 Scott Missouri 29201 3583 68
938337 938337 2021-01-17 Shannon Missouri 29203 449 9
938338 938338 2021-01-17 Shelby Missouri 29205 328 4
938339 938339 2021-01-17 St. Charles Missouri 29183 32667 342

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);