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 2020-08-10 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 |
---|---|---|---|---|---|---|---|
419609 | 419609 | 2020-08-10 | Adair | Missouri | 29001 | 160 | 0 |
419610 | 419610 | 2020-08-10 | Andrew | Missouri | 29003 | 88 | 1 |
419611 | 419611 | 2020-08-10 | Atchison | Missouri | 29005 | 18 | 0 |
419612 | 419612 | 2020-08-10 | Audrain | Missouri | 29007 | 203 | 1 |
419613 | 419613 | 2020-08-10 | Barry | Missouri | 29009 | 258 | 4 |
419614 | 419614 | 2020-08-10 | Barton | Missouri | 29011 | 69 | 0 |
419615 | 419615 | 2020-08-10 | Bates | Missouri | 29013 | 48 | 1 |
419616 | 419616 | 2020-08-10 | Benton | Missouri | 29015 | 104 | 1 |
419617 | 419617 | 2020-08-10 | Bollinger | Missouri | 29017 | 68 | 1 |
419618 | 419618 | 2020-08-10 | Boone | Missouri | 29019 | 1429 | 5 |
419619 | 419619 | 2020-08-10 | Buchanan | Missouri | 29021 | 1128 | 10 |
419620 | 419620 | 2020-08-10 | Butler | Missouri | 29023 | 283 | 2 |
419621 | 419621 | 2020-08-10 | Caldwell | Missouri | 29025 | 35 | 1 |
419622 | 419622 | 2020-08-10 | Callaway | Missouri | 29027 | 159 | 1 |
419623 | 419623 | 2020-08-10 | Camden | Missouri | 29029 | 356 | 5 |
419624 | 419624 | 2020-08-10 | Cape Girardeau | Missouri | 29031 | 663 | 5 |
419625 | 419625 | 2020-08-10 | Carroll | Missouri | 29033 | 101 | 0 |
419626 | 419626 | 2020-08-10 | Carter | Missouri | 29035 | 21 | 1 |
419627 | 419627 | 2020-08-10 | Cass | Missouri | 29037 | 796 | 14 |
419628 | 419628 | 2020-08-10 | Cedar | Missouri | 29039 | 40 | 0 |
419629 | 419629 | 2020-08-10 | Chariton | Missouri | 29041 | 18 | 0 |
419630 | 419630 | 2020-08-10 | Christian | Missouri | 29043 | 395 | 1 |
419631 | 419631 | 2020-08-10 | Clark | Missouri | 29045 | 20 | 0 |
419632 | 419632 | 2020-08-10 | Clay | Missouri | 29047 | 1053 | 27 |
419633 | 419633 | 2020-08-10 | Clinton | Missouri | 29049 | 84 | 0 |
419634 | 419634 | 2020-08-10 | Cole | Missouri | 29051 | 427 | 3 |
419635 | 419635 | 2020-08-10 | Cooper | Missouri | 29053 | 131 | 0 |
419636 | 419636 | 2020-08-10 | Crawford | Missouri | 29055 | 78 | 0 |
419637 | 419637 | 2020-08-10 | Dade | Missouri | 29057 | 15 | 0 |
419638 | 419638 | 2020-08-10 | Dallas | Missouri | 29059 | 69 | 1 |
419639 | 419639 | 2020-08-10 | Daviess | Missouri | 29061 | 17 | 0 |
419640 | 419640 | 2020-08-10 | DeKalb | Missouri | 29063 | 36 | 1 |
419641 | 419641 | 2020-08-10 | Dent | Missouri | 29065 | 12 | 0 |
419642 | 419642 | 2020-08-10 | Douglas | Missouri | 29067 | 87 | 2 |
419643 | 419643 | 2020-08-10 | Dunklin | Missouri | 29069 | 317 | 4 |
419644 | 419644 | 2020-08-10 | Franklin | Missouri | 29071 | 631 | 18 |
419645 | 419645 | 2020-08-10 | Gasconade | Missouri | 29073 | 24 | 0 |
419646 | 419646 | 2020-08-10 | Gentry | Missouri | 29075 | 85 | 9 |
419647 | 419647 | 2020-08-10 | Greene | Missouri | 29077 | 1613 | 16 |
419648 | 419648 | 2020-08-10 | Grundy | Missouri | 29079 | 29 | 1 |
419649 | 419649 | 2020-08-10 | Harrison | Missouri | 29081 | 60 | 1 |
419650 | 419650 | 2020-08-10 | Henry | Missouri | 29083 | 82 | 3 |
419651 | 419651 | 2020-08-10 | Hickory | Missouri | 29085 | 33 | 0 |
419652 | 419652 | 2020-08-10 | Holt | Missouri | 29087 | 8 | 0 |
419653 | 419653 | 2020-08-10 | Howard | Missouri | 29089 | 53 | 0 |
419654 | 419654 | 2020-08-10 | Howell | Missouri | 29091 | 153 | 2 |
419655 | 419655 | 2020-08-10 | Iron | Missouri | 29093 | 22 | 0 |
419656 | 419656 | 2020-08-10 | Jackson | Missouri | 29095 | 4083 | 65 |
419657 | 419657 | 2020-08-10 | Jasper | Missouri | 29097 | 1264 | 11 |
419658 | 419658 | 2020-08-10 | Jefferson | Missouri | 29099 | 1836 | 28 |
419659 | 419659 | 2020-08-10 | Johnson | Missouri | 29101 | 489 | 2 |
419660 | 419660 | 2020-08-10 | Joplin | Missouri | 507 | 21 | |
419661 | 419661 | 2020-08-10 | Kansas City | Missouri | 6786 | 78 | |
419662 | 419662 | 2020-08-10 | Knox | Missouri | 29103 | 27 | 0 |
419663 | 419663 | 2020-08-10 | Laclede | Missouri | 29105 | 202 | 1 |
419664 | 419664 | 2020-08-10 | Lafayette | Missouri | 29107 | 178 | 2 |
419665 | 419665 | 2020-08-10 | Lawrence | Missouri | 29109 | 230 | 2 |
419666 | 419666 | 2020-08-10 | Lewis | Missouri | 29111 | 46 | 1 |
419667 | 419667 | 2020-08-10 | Lincoln | Missouri | 29113 | 382 | 1 |
419668 | 419668 | 2020-08-10 | Linn | Missouri | 29115 | 33 | 1 |
419669 | 419669 | 2020-08-10 | Livingston | Missouri | 29117 | 63 | 0 |
419670 | 419670 | 2020-08-10 | Macon | Missouri | 29121 | 59 | 0 |
419671 | 419671 | 2020-08-10 | Madison | Missouri | 29123 | 25 | 0 |
419672 | 419672 | 2020-08-10 | Maries | Missouri | 29125 | 24 | 0 |
419673 | 419673 | 2020-08-10 | Marion | Missouri | 29127 | 201 | 1 |
419674 | 419674 | 2020-08-10 | McDonald | Missouri | 29119 | 1003 | 7 |
419675 | 419675 | 2020-08-10 | Mercer | Missouri | 29129 | 11 | 0 |
419676 | 419676 | 2020-08-10 | Miller | Missouri | 29131 | 132 | 1 |
419677 | 419677 | 2020-08-10 | Mississippi | Missouri | 29133 | 140 | 0 |
419678 | 419678 | 2020-08-10 | Moniteau | Missouri | 29135 | 148 | 2 |
419679 | 419679 | 2020-08-10 | Monroe | Missouri | 29137 | 31 | 0 |
419680 | 419680 | 2020-08-10 | Montgomery | Missouri | 29139 | 41 | 0 |
419681 | 419681 | 2020-08-10 | Morgan | Missouri | 29141 | 83 | 0 |
419682 | 419682 | 2020-08-10 | New Madrid | Missouri | 29143 | 256 | 1 |
419683 | 419683 | 2020-08-10 | Newton | Missouri | 29145 | 874 | 6 |
419684 | 419684 | 2020-08-10 | Nodaway | Missouri | 29147 | 186 | 0 |
419685 | 419685 | 2020-08-10 | Oregon | Missouri | 29149 | 16 | 0 |
419686 | 419686 | 2020-08-10 | Osage | Missouri | 29151 | 49 | 1 |
419687 | 419687 | 2020-08-10 | Ozark | Missouri | 29153 | 14 | 0 |
419688 | 419688 | 2020-08-10 | Pemiscot | Missouri | 29155 | 234 | 9 |
419689 | 419689 | 2020-08-10 | Perry | Missouri | 29157 | 232 | 4 |
419690 | 419690 | 2020-08-10 | Pettis | Missouri | 29159 | 550 | 4 |
419691 | 419691 | 2020-08-10 | Phelps | Missouri | 29161 | 89 | 0 |
419692 | 419692 | 2020-08-10 | Pike | Missouri | 29163 | 106 | 1 |
419693 | 419693 | 2020-08-10 | Platte | Missouri | 29165 | 374 | 10 |
419694 | 419694 | 2020-08-10 | Polk | Missouri | 29167 | 210 | 0 |
419695 | 419695 | 2020-08-10 | Pulaski | Missouri | 29169 | 226 | 1 |
419696 | 419696 | 2020-08-10 | Putnam | Missouri | 29171 | 13 | 1 |
419697 | 419697 | 2020-08-10 | Ralls | Missouri | 29173 | 34 | 0 |
419698 | 419698 | 2020-08-10 | Randolph | Missouri | 29175 | 71 | 1 |
419699 | 419699 | 2020-08-10 | Ray | Missouri | 29177 | 119 | 2 |
419700 | 419700 | 2020-08-10 | Reynolds | Missouri | 29179 | 16 | 0 |
419701 | 419701 | 2020-08-10 | Ripley | Missouri | 29181 | 52 | 0 |
419702 | 419702 | 2020-08-10 | Saline | Missouri | 29195 | 435 | 7 |
419703 | 419703 | 2020-08-10 | Schuyler | Missouri | 29197 | 11 | 0 |
419704 | 419704 | 2020-08-10 | Scotland | Missouri | 29199 | 16 | 1 |
419705 | 419705 | 2020-08-10 | Scott | Missouri | 29201 | 400 | 13 |
419706 | 419706 | 2020-08-10 | Shannon | Missouri | 29203 | 43 | 1 |
419707 | 419707 | 2020-08-10 | Shelby | Missouri | 29205 | 38 | 0 |
419708 | 419708 | 2020-08-10 | St. Charles | Missouri | 29183 | 4168 | 103 |
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);