ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 62 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
740255 | 740255 | 2020-11-17 | Mercer | Missouri | 29129 | 62 | 0 |
665642 | 665642 | 2020-10-25 | Knox | Missouri | 29103 | 62 | 1 |
662397 | 662397 | 2020-10-24 | Knox | Missouri | 29103 | 62 | 1 |
655946 | 655946 | 2020-10-22 | Reynolds | Missouri | 29179 | 62 | 0 |
607196 | 607196 | 2020-10-07 | Atchison | Missouri | 29005 | 62 | 0 |
571565 | 571565 | 2020-09-26 | Dade | Missouri | 29057 | 62 | 0 |
555400 | 555400 | 2020-09-21 | Linn | Missouri | 29115 | 62 | 1 |
552162 | 552162 | 2020-09-20 | Linn | Missouri | 29115 | 62 | 1 |
535979 | 535979 | 2020-09-15 | Maries | Missouri | 29125 | 62 | 0 |
513286 | 513286 | 2020-09-08 | Cedar | Missouri | 29039 | 62 | 0 |
510054 | 510054 | 2020-09-07 | Cedar | Missouri | 29039 | 62 | 0 |
506880 | 506880 | 2020-09-06 | Ozark | Missouri | 29153 | 62 | 0 |
503645 | 503645 | 2020-09-05 | Oregon | Missouri | 29149 | 62 | 0 |
487444 | 487444 | 2020-08-31 | Holt | Missouri | 29087 | 62 | 0 |
484210 | 484210 | 2020-08-30 | Holt | Missouri | 29087 | 62 | 0 |
477742 | 477742 | 2020-08-28 | Hickory | Missouri | 29085 | 62 | 0 |
471241 | 471241 | 2020-08-26 | Bates | Missouri | 29013 | 62 | 1 |
471275 | 471275 | 2020-08-26 | Harrison | Missouri | 29081 | 62 | 1 |
471305 | 471305 | 2020-08-26 | Monroe | Missouri | 29137 | 62 | 0 |
468011 | 468011 | 2020-08-25 | Bates | Missouri | 29013 | 62 | 1 |
468045 | 468045 | 2020-08-25 | Harrison | Missouri | 29081 | 62 | 1 |
464816 | 464816 | 2020-08-24 | Harrison | Missouri | 29081 | 62 | 1 |
461585 | 461585 | 2020-08-23 | Harrison | Missouri | 29081 | 62 | 1 |
458358 | 458358 | 2020-08-22 | Harrison | Missouri | 29081 | 62 | 1 |
455130 | 455130 | 2020-08-21 | Harrison | Missouri | 29081 | 62 | 1 |
451902 | 451902 | 2020-08-20 | Harrison | Missouri | 29081 | 62 | 1 |
448674 | 448674 | 2020-08-19 | Harrison | Missouri | 29081 | 62 | 1 |
445448 | 445448 | 2020-08-18 | Harrison | Missouri | 29081 | 62 | 1 |
442222 | 442222 | 2020-08-17 | Harrison | Missouri | 29081 | 62 | 1 |
442259 | 442259 | 2020-08-17 | Osage | Missouri | 29151 | 62 | 1 |
438995 | 438995 | 2020-08-16 | Harrison | Missouri | 29081 | 62 | 1 |
439032 | 439032 | 2020-08-16 | Osage | Missouri | 29151 | 62 | 1 |
435840 | 435840 | 2020-08-15 | Vernon | Missouri | 29217 | 62 | 0 |
426114 | 426114 | 2020-08-12 | Macon | Missouri | 29121 | 62 | 0 |
426157 | 426157 | 2020-08-12 | Ste. Genevieve | Missouri | 29186 | 62 | 1 |
426166 | 426166 | 2020-08-12 | Wayne | Missouri | 29223 | 62 | 0 |
422947 | 422947 | 2020-08-11 | Wright | Missouri | 29229 | 62 | 0 |
419725 | 419725 | 2020-08-10 | Wright | Missouri | 29229 | 62 | 0 |
416504 | 416504 | 2020-08-09 | Wright | Missouri | 29229 | 62 | 0 |
406736 | 406736 | 2020-08-06 | Bollinger | Missouri | 29017 | 62 | 1 |
403537 | 403537 | 2020-08-05 | Crawford | Missouri | 29055 | 62 | 0 |
390718 | 390718 | 2020-08-01 | Morgan | Missouri | 29141 | 62 | 0 |
387501 | 387501 | 2020-07-31 | Morgan | Missouri | 29141 | 62 | 0 |
381000 | 381000 | 2020-07-29 | Barton | Missouri | 29011 | 62 | 0 |
381036 | 381036 | 2020-07-29 | Henry | Missouri | 29083 | 62 | 3 |
377783 | 377783 | 2020-07-28 | Barton | Missouri | 29011 | 62 | 0 |
371418 | 371418 | 2020-07-26 | Miller | Missouri | 29131 | 62 | 0 |
345759 | 345759 | 2020-07-18 | Howell | Missouri | 29091 | 62 | 0 |
339432 | 339432 | 2020-07-16 | Webster | Missouri | 29225 | 62 | 1 |
304408 | 304408 | 2020-07-05 | Moniteau | Missouri | 29135 | 62 | 1 |
301244 | 301244 | 2020-07-04 | Moniteau | Missouri | 29135 | 62 | 1 |
298081 | 298081 | 2020-07-03 | Moniteau | Missouri | 29135 | 62 | 1 |
294923 | 294923 | 2020-07-02 | Moniteau | Missouri | 29135 | 62 | 1 |
263430 | 263430 | 2020-06-22 | Butler | Missouri | 29023 | 62 | 0 |
260302 | 260302 | 2020-06-21 | Butler | Missouri | 29023 | 62 | 0 |
257176 | 257176 | 2020-06-20 | Butler | Missouri | 29023 | 62 | 0 |
207527 | 207527 | 2020-06-04 | Adair | Missouri | 29001 | 62 | 0 |
176903 | 176903 | 2020-05-25 | Cape Girardeau | Missouri | 29031 | 62 | 2 |
137685 | 137685 | 2020-05-12 | Lafayette | Missouri | 29107 | 62 | 1 |
134695 | 134695 | 2020-05-11 | Lafayette | Missouri | 29107 | 62 | 1 |
131704 | 131704 | 2020-05-10 | Lafayette | Missouri | 29107 | 62 | 1 |
128711 | 128711 | 2020-05-09 | Johnson | Missouri | 29101 | 62 | 0 |
125724 | 125724 | 2020-05-08 | Johnson | Missouri | 29101 | 62 | 0 |
122742 | 122742 | 2020-05-07 | Johnson | Missouri | 29101 | 62 | 0 |
102423 | 102423 | 2020-04-30 | Cass | Missouri | 29037 | 62 | 6 |
99571 | 99571 | 2020-04-29 | Cass | Missouri | 29037 | 62 | 6 |
96789 | 96789 | 2020-04-28 | Scott | Missouri | 29201 | 62 | 2 |
82643 | 82643 | 2020-04-23 | Clay | Missouri | 29047 | 62 | 1 |
44514 | 44514 | 2020-04-09 | Franklin | Missouri | 29071 | 62 | 3 |
31982 | 31982 | 2020-04-04 | Greene | Missouri | 29077 | 62 | 7 |
29608 | 29608 | 2020-04-03 | Jefferson | Missouri | 29099 | 62 | 1 |
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);