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-11-07 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 |
---|---|---|---|---|---|---|---|
707750 | 707750 | 2020-11-07 | Adair | Missouri | 29001 | 663 | 1 |
707751 | 707751 | 2020-11-07 | Andrew | Missouri | 29003 | 518 | 8 |
707752 | 707752 | 2020-11-07 | Atchison | Missouri | 29005 | 102 | 1 |
707753 | 707753 | 2020-11-07 | Audrain | Missouri | 29007 | 988 | 10 |
707754 | 707754 | 2020-11-07 | Barry | Missouri | 29009 | 1019 | 18 |
707755 | 707755 | 2020-11-07 | Barton | Missouri | 29011 | 483 | 4 |
707756 | 707756 | 2020-11-07 | Bates | Missouri | 29013 | 296 | 8 |
707757 | 707757 | 2020-11-07 | Benton | Missouri | 29015 | 560 | 7 |
707758 | 707758 | 2020-11-07 | Bollinger | Missouri | 29017 | 590 | 4 |
707759 | 707759 | 2020-11-07 | Boone | Missouri | 29019 | 7291 | 18 |
707760 | 707760 | 2020-11-07 | Buchanan | Missouri | 29021 | 4379 | 52 |
707761 | 707761 | 2020-11-07 | Butler | Missouri | 29023 | 1500 | 8 |
707762 | 707762 | 2020-11-07 | Caldwell | Missouri | 29025 | 228 | 1 |
707763 | 707763 | 2020-11-07 | Callaway | Missouri | 29027 | 1831 | 7 |
707764 | 707764 | 2020-11-07 | Camden | Missouri | 29029 | 1817 | 37 |
707765 | 707765 | 2020-11-07 | Cape Girardeau | Missouri | 29031 | 3312 | 55 |
707766 | 707766 | 2020-11-07 | Carroll | Missouri | 29033 | 257 | 4 |
707767 | 707767 | 2020-11-07 | Carter | Missouri | 29035 | 206 | 3 |
707768 | 707768 | 2020-11-07 | Cass | Missouri | 29037 | 2531 | 33 |
707769 | 707769 | 2020-11-07 | Cedar | Missouri | 29039 | 281 | 4 |
707770 | 707770 | 2020-11-07 | Chariton | Missouri | 29041 | 113 | 0 |
707771 | 707771 | 2020-11-07 | Christian | Missouri | 29043 | 2955 | 17 |
707772 | 707772 | 2020-11-07 | Clark | Missouri | 29045 | 167 | 2 |
707773 | 707773 | 2020-11-07 | Clay | Missouri | 29047 | 3097 | 60 |
707774 | 707774 | 2020-11-07 | Clinton | Missouri | 29049 | 623 | 33 |
707775 | 707775 | 2020-11-07 | Cole | Missouri | 29051 | 4066 | 26 |
707776 | 707776 | 2020-11-07 | Cooper | Missouri | 29053 | 816 | 4 |
707777 | 707777 | 2020-11-07 | Crawford | Missouri | 29055 | 795 | 9 |
707778 | 707778 | 2020-11-07 | Dade | Missouri | 29057 | 181 | 3 |
707779 | 707779 | 2020-11-07 | Dallas | Missouri | 29059 | 437 | 2 |
707780 | 707780 | 2020-11-07 | Daviess | Missouri | 29061 | 252 | 4 |
707781 | 707781 | 2020-11-07 | DeKalb | Missouri | 29063 | 403 | 5 |
707782 | 707782 | 2020-11-07 | Dent | Missouri | 29065 | 307 | 4 |
707783 | 707783 | 2020-11-07 | Douglas | Missouri | 29067 | 327 | 13 |
707784 | 707784 | 2020-11-07 | Dunklin | Missouri | 29069 | 1316 | 13 |
707785 | 707785 | 2020-11-07 | Franklin | Missouri | 29071 | 3270 | 50 |
707786 | 707786 | 2020-11-07 | Gasconade | Missouri | 29073 | 325 | 24 |
707787 | 707787 | 2020-11-07 | Gentry | Missouri | 29075 | 233 | 10 |
707788 | 707788 | 2020-11-07 | Greene | Missouri | 29077 | 10988 | 171 |
707789 | 707789 | 2020-11-07 | Grundy | Missouri | 29079 | 321 | 11 |
707790 | 707790 | 2020-11-07 | Harrison | Missouri | 29081 | 227 | 1 |
707791 | 707791 | 2020-11-07 | Henry | Missouri | 29083 | 561 | 8 |
707792 | 707792 | 2020-11-07 | Hickory | Missouri | 29085 | 282 | 4 |
707793 | 707793 | 2020-11-07 | Holt | Missouri | 29087 | 154 | 1 |
707794 | 707794 | 2020-11-07 | Howard | Missouri | 29089 | 316 | 2 |
707795 | 707795 | 2020-11-07 | Howell | Missouri | 29091 | 1339 | 16 |
707796 | 707796 | 2020-11-07 | Iron | Missouri | 29093 | 133 | 0 |
707797 | 707797 | 2020-11-07 | Jackson | Missouri | 29095 | 11748 | 145 |
707798 | 707798 | 2020-11-07 | Jasper | Missouri | 29097 | 3672 | 51 |
707799 | 707799 | 2020-11-07 | Jefferson | Missouri | 29099 | 7318 | 90 |
707800 | 707800 | 2020-11-07 | Johnson | Missouri | 29101 | 1805 | 10 |
707801 | 707801 | 2020-11-07 | Joplin | Missouri | 2367 | 34 | |
707802 | 707802 | 2020-11-07 | Kansas City | Missouri | 16633 | 227 | |
707803 | 707803 | 2020-11-07 | Knox | Missouri | 29103 | 81 | 1 |
707804 | 707804 | 2020-11-07 | Laclede | Missouri | 29105 | 1372 | 25 |
707805 | 707805 | 2020-11-07 | Lafayette | Missouri | 29107 | 1052 | 26 |
707806 | 707806 | 2020-11-07 | Lawrence | Missouri | 29109 | 1351 | 26 |
707807 | 707807 | 2020-11-07 | Lewis | Missouri | 29111 | 274 | 2 |
707808 | 707808 | 2020-11-07 | Lincoln | Missouri | 29113 | 1475 | 5 |
707809 | 707809 | 2020-11-07 | Linn | Missouri | 29115 | 203 | 7 |
707810 | 707810 | 2020-11-07 | Livingston | Missouri | 29117 | 610 | 9 |
707811 | 707811 | 2020-11-07 | Macon | Missouri | 29121 | 319 | 1 |
707812 | 707812 | 2020-11-07 | Madison | Missouri | 29123 | 578 | 3 |
707813 | 707813 | 2020-11-07 | Maries | Missouri | 29125 | 248 | 1 |
707814 | 707814 | 2020-11-07 | Marion | Missouri | 29127 | 1145 | 14 |
707815 | 707815 | 2020-11-07 | McDonald | Missouri | 29119 | 1376 | 16 |
707816 | 707816 | 2020-11-07 | Mercer | Missouri | 29129 | 43 | 0 |
707817 | 707817 | 2020-11-07 | Miller | Missouri | 29131 | 1100 | 18 |
707818 | 707818 | 2020-11-07 | Mississippi | Missouri | 29133 | 511 | 6 |
707819 | 707819 | 2020-11-07 | Moniteau | Missouri | 29135 | 806 | 13 |
707820 | 707820 | 2020-11-07 | Monroe | Missouri | 29137 | 225 | 2 |
707821 | 707821 | 2020-11-07 | Montgomery | Missouri | 29139 | 226 | 2 |
707822 | 707822 | 2020-11-07 | Morgan | Missouri | 29141 | 819 | 8 |
707823 | 707823 | 2020-11-07 | New Madrid | Missouri | 29143 | 919 | 23 |
707824 | 707824 | 2020-11-07 | Newton | Missouri | 29145 | 2325 | 22 |
707825 | 707825 | 2020-11-07 | Nodaway | Missouri | 29147 | 1450 | 11 |
707826 | 707826 | 2020-11-07 | Oregon | Missouri | 29149 | 280 | 0 |
707827 | 707827 | 2020-11-07 | Osage | Missouri | 29151 | 650 | 3 |
707828 | 707828 | 2020-11-07 | Ozark | Missouri | 29153 | 238 | 1 |
707829 | 707829 | 2020-11-07 | Pemiscot | Missouri | 29155 | 825 | 14 |
707830 | 707830 | 2020-11-07 | Perry | Missouri | 29157 | 1016 | 8 |
707831 | 707831 | 2020-11-07 | Pettis | Missouri | 29159 | 2268 | 28 |
707832 | 707832 | 2020-11-07 | Phelps | Missouri | 29161 | 1028 | 30 |
707833 | 707833 | 2020-11-07 | Pike | Missouri | 29163 | 492 | 8 |
707834 | 707834 | 2020-11-07 | Platte | Missouri | 29165 | 1168 | 13 |
707835 | 707835 | 2020-11-07 | Polk | Missouri | 29167 | 1335 | 19 |
707836 | 707836 | 2020-11-07 | Pulaski | Missouri | 29169 | 1154 | 11 |
707837 | 707837 | 2020-11-07 | Putnam | Missouri | 29171 | 67 | 1 |
707838 | 707838 | 2020-11-07 | Ralls | Missouri | 29173 | 251 | 0 |
707839 | 707839 | 2020-11-07 | Randolph | Missouri | 29175 | 795 | 3 |
707840 | 707840 | 2020-11-07 | Ray | Missouri | 29177 | 391 | 2 |
707841 | 707841 | 2020-11-07 | Reynolds | Missouri | 29179 | 107 | 1 |
707842 | 707842 | 2020-11-07 | Ripley | Missouri | 29181 | 331 | 5 |
707843 | 707843 | 2020-11-07 | Saline | Missouri | 29195 | 1119 | 11 |
707844 | 707844 | 2020-11-07 | Schuyler | Missouri | 29197 | 79 | 0 |
707845 | 707845 | 2020-11-07 | Scotland | Missouri | 29199 | 97 | 1 |
707846 | 707846 | 2020-11-07 | Scott | Missouri | 29201 | 1722 | 31 |
707847 | 707847 | 2020-11-07 | Shannon | Missouri | 29203 | 290 | 6 |
707848 | 707848 | 2020-11-07 | Shelby | Missouri | 29205 | 121 | 1 |
707849 | 707849 | 2020-11-07 | St. Charles | Missouri | 29183 | 13970 | 173 |
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);