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-28 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 |
---|---|---|---|---|---|---|---|
477700 | 477700 | 2020-08-28 | Adair | Missouri | 29001 | 222 | 0 |
477701 | 477701 | 2020-08-28 | Andrew | Missouri | 29003 | 122 | 1 |
477702 | 477702 | 2020-08-28 | Atchison | Missouri | 29005 | 25 | 0 |
477703 | 477703 | 2020-08-28 | Audrain | Missouri | 29007 | 255 | 1 |
477704 | 477704 | 2020-08-28 | Barry | Missouri | 29009 | 349 | 4 |
477705 | 477705 | 2020-08-28 | Barton | Missouri | 29011 | 94 | 0 |
477706 | 477706 | 2020-08-28 | Bates | Missouri | 29013 | 66 | 1 |
477707 | 477707 | 2020-08-28 | Benton | Missouri | 29015 | 154 | 1 |
477708 | 477708 | 2020-08-28 | Bollinger | Missouri | 29017 | 115 | 1 |
477709 | 477709 | 2020-08-28 | Boone | Missouri | 29019 | 2316 | 7 |
477710 | 477710 | 2020-08-28 | Buchanan | Missouri | 29021 | 1355 | 10 |
477711 | 477711 | 2020-08-28 | Butler | Missouri | 29023 | 366 | 2 |
477712 | 477712 | 2020-08-28 | Caldwell | Missouri | 29025 | 41 | 1 |
477713 | 477713 | 2020-08-28 | Callaway | Missouri | 29027 | 306 | 2 |
477714 | 477714 | 2020-08-28 | Camden | Missouri | 29029 | 500 | 8 |
477715 | 477715 | 2020-08-28 | Cape Girardeau | Missouri | 29031 | 978 | 8 |
477716 | 477716 | 2020-08-28 | Carroll | Missouri | 29033 | 108 | 0 |
477717 | 477717 | 2020-08-28 | Carter | Missouri | 29035 | 33 | 1 |
477718 | 477718 | 2020-08-28 | Cass | Missouri | 29037 | 1096 | 16 |
477719 | 477719 | 2020-08-28 | Cedar | Missouri | 29039 | 48 | 0 |
477720 | 477720 | 2020-08-28 | Chariton | Missouri | 29041 | 23 | 0 |
477721 | 477721 | 2020-08-28 | Christian | Missouri | 29043 | 609 | 2 |
477722 | 477722 | 2020-08-28 | Clark | Missouri | 29045 | 40 | 0 |
477723 | 477723 | 2020-08-28 | Clay | Missouri | 29047 | 1346 | 36 |
477724 | 477724 | 2020-08-28 | Clinton | Missouri | 29049 | 127 | 0 |
477725 | 477725 | 2020-08-28 | Cole | Missouri | 29051 | 788 | 8 |
477726 | 477726 | 2020-08-28 | Cooper | Missouri | 29053 | 216 | 0 |
477727 | 477727 | 2020-08-28 | Crawford | Missouri | 29055 | 175 | 1 |
477728 | 477728 | 2020-08-28 | Dade | Missouri | 29057 | 24 | 0 |
477729 | 477729 | 2020-08-28 | Dallas | Missouri | 29059 | 105 | 1 |
477730 | 477730 | 2020-08-28 | Daviess | Missouri | 29061 | 22 | 0 |
477731 | 477731 | 2020-08-28 | DeKalb | Missouri | 29063 | 61 | 1 |
477732 | 477732 | 2020-08-28 | Dent | Missouri | 29065 | 33 | 0 |
477733 | 477733 | 2020-08-28 | Douglas | Missouri | 29067 | 106 | 2 |
477734 | 477734 | 2020-08-28 | Dunklin | Missouri | 29069 | 473 | 4 |
477735 | 477735 | 2020-08-28 | Franklin | Missouri | 29071 | 981 | 19 |
477736 | 477736 | 2020-08-28 | Gasconade | Missouri | 29073 | 81 | 1 |
477737 | 477737 | 2020-08-28 | Gentry | Missouri | 29075 | 92 | 9 |
477738 | 477738 | 2020-08-28 | Greene | Missouri | 29077 | 2972 | 30 |
477739 | 477739 | 2020-08-28 | Grundy | Missouri | 29079 | 38 | 1 |
477740 | 477740 | 2020-08-28 | Harrison | Missouri | 29081 | 68 | 1 |
477741 | 477741 | 2020-08-28 | Henry | Missouri | 29083 | 112 | 3 |
477742 | 477742 | 2020-08-28 | Hickory | Missouri | 29085 | 62 | 0 |
477743 | 477743 | 2020-08-28 | Holt | Missouri | 29087 | 58 | 0 |
477744 | 477744 | 2020-08-28 | Howard | Missouri | 29089 | 110 | 0 |
477745 | 477745 | 2020-08-28 | Howell | Missouri | 29091 | 235 | 3 |
477746 | 477746 | 2020-08-28 | Iron | Missouri | 29093 | 47 | 0 |
477747 | 477747 | 2020-08-28 | Jackson | Missouri | 29095 | 5324 | 77 |
477748 | 477748 | 2020-08-28 | Jasper | Missouri | 29097 | 1560 | 14 |
477749 | 477749 | 2020-08-28 | Jefferson | Missouri | 29099 | 2663 | 45 |
477750 | 477750 | 2020-08-28 | Johnson | Missouri | 29101 | 582 | 3 |
477751 | 477751 | 2020-08-28 | Joplin | Missouri | 691 | 21 | |
477752 | 477752 | 2020-08-28 | Kansas City | Missouri | 8995 | 96 | |
477753 | 477753 | 2020-08-28 | Knox | Missouri | 29103 | 38 | 0 |
477754 | 477754 | 2020-08-28 | Laclede | Missouri | 29105 | 280 | 1 |
477755 | 477755 | 2020-08-28 | Lafayette | Missouri | 29107 | 226 | 2 |
477756 | 477756 | 2020-08-28 | Lawrence | Missouri | 29109 | 342 | 2 |
477757 | 477757 | 2020-08-28 | Lewis | Missouri | 29111 | 56 | 2 |
477758 | 477758 | 2020-08-28 | Lincoln | Missouri | 29113 | 537 | 1 |
477759 | 477759 | 2020-08-28 | Linn | Missouri | 29115 | 46 | 1 |
477760 | 477760 | 2020-08-28 | Livingston | Missouri | 29117 | 71 | 1 |
477761 | 477761 | 2020-08-28 | Macon | Missouri | 29121 | 75 | 0 |
477762 | 477762 | 2020-08-28 | Madison | Missouri | 29123 | 111 | 0 |
477763 | 477763 | 2020-08-28 | Maries | Missouri | 29125 | 41 | 0 |
477764 | 477764 | 2020-08-28 | Marion | Missouri | 29127 | 425 | 1 |
477765 | 477765 | 2020-08-28 | McDonald | Missouri | 29119 | 1044 | 11 |
477766 | 477766 | 2020-08-28 | Mercer | Missouri | 29129 | 16 | 0 |
477767 | 477767 | 2020-08-28 | Miller | Missouri | 29131 | 229 | 1 |
477768 | 477768 | 2020-08-28 | Mississippi | Missouri | 29133 | 222 | 0 |
477769 | 477769 | 2020-08-28 | Moniteau | Missouri | 29135 | 181 | 2 |
477770 | 477770 | 2020-08-28 | Monroe | Missouri | 29137 | 66 | 0 |
477771 | 477771 | 2020-08-28 | Montgomery | Missouri | 29139 | 55 | 1 |
477772 | 477772 | 2020-08-28 | Morgan | Missouri | 29141 | 117 | 0 |
477773 | 477773 | 2020-08-28 | New Madrid | Missouri | 29143 | 365 | 4 |
477774 | 477774 | 2020-08-28 | Newton | Missouri | 29145 | 1063 | 13 |
477775 | 477775 | 2020-08-28 | Nodaway | Missouri | 29147 | 379 | 1 |
477776 | 477776 | 2020-08-28 | Oregon | Missouri | 29149 | 47 | 0 |
477777 | 477777 | 2020-08-28 | Osage | Missouri | 29151 | 75 | 1 |
477778 | 477778 | 2020-08-28 | Ozark | Missouri | 29153 | 21 | 0 |
477779 | 477779 | 2020-08-28 | Pemiscot | Missouri | 29155 | 319 | 9 |
477780 | 477780 | 2020-08-28 | Perry | Missouri | 29157 | 360 | 4 |
477781 | 477781 | 2020-08-28 | Pettis | Missouri | 29159 | 774 | 8 |
477782 | 477782 | 2020-08-28 | Phelps | Missouri | 29161 | 190 | 0 |
477783 | 477783 | 2020-08-28 | Pike | Missouri | 29163 | 138 | 1 |
477784 | 477784 | 2020-08-28 | Platte | Missouri | 29165 | 484 | 11 |
477785 | 477785 | 2020-08-28 | Polk | Missouri | 29167 | 317 | 1 |
477786 | 477786 | 2020-08-28 | Pulaski | Missouri | 29169 | 374 | 1 |
477787 | 477787 | 2020-08-28 | Putnam | Missouri | 29171 | 22 | 1 |
477788 | 477788 | 2020-08-28 | Ralls | Missouri | 29173 | 106 | 0 |
477789 | 477789 | 2020-08-28 | Randolph | Missouri | 29175 | 107 | 1 |
477790 | 477790 | 2020-08-28 | Ray | Missouri | 29177 | 124 | 0 |
477791 | 477791 | 2020-08-28 | Reynolds | Missouri | 29179 | 21 | 0 |
477792 | 477792 | 2020-08-28 | Ripley | Missouri | 29181 | 85 | 0 |
477793 | 477793 | 2020-08-28 | Saline | Missouri | 29195 | 534 | 7 |
477794 | 477794 | 2020-08-28 | Schuyler | Missouri | 29197 | 16 | 0 |
477795 | 477795 | 2020-08-28 | Scotland | Missouri | 29199 | 18 | 1 |
477796 | 477796 | 2020-08-28 | Scott | Missouri | 29201 | 582 | 13 |
477797 | 477797 | 2020-08-28 | Shannon | Missouri | 29203 | 50 | 1 |
477798 | 477798 | 2020-08-28 | Shelby | Missouri | 29205 | 45 | 0 |
477799 | 477799 | 2020-08-28 | St. Charles | Missouri | 29183 | 5561 | 108 |
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);