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-02 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
393863 | 393863 | 2020-08-02 | Adair | Missouri | 29001 | 134 | 0 |
393864 | 393864 | 2020-08-02 | Andrew | Missouri | 29003 | 84 | 1 |
393865 | 393865 | 2020-08-02 | Atchison | Missouri | 29005 | 12 | 0 |
393866 | 393866 | 2020-08-02 | Audrain | Missouri | 29007 | 193 | 1 |
393867 | 393867 | 2020-08-02 | Barry | Missouri | 29009 | 228 | 0 |
393868 | 393868 | 2020-08-02 | Barton | Missouri | 29011 | 65 | 0 |
393869 | 393869 | 2020-08-02 | Bates | Missouri | 29013 | 39 | 1 |
393870 | 393870 | 2020-08-02 | Benton | Missouri | 29015 | 71 | 1 |
393871 | 393871 | 2020-08-02 | Bollinger | Missouri | 29017 | 56 | 0 |
393872 | 393872 | 2020-08-02 | Boone | Missouri | 29019 | 1251 | 4 |
393873 | 393873 | 2020-08-02 | Buchanan | Missouri | 29021 | 1083 | 10 |
393874 | 393874 | 2020-08-02 | Butler | Missouri | 29023 | 239 | 2 |
393875 | 393875 | 2020-08-02 | Caldwell | Missouri | 29025 | 30 | 1 |
393876 | 393876 | 2020-08-02 | Callaway | Missouri | 29027 | 125 | 1 |
393877 | 393877 | 2020-08-02 | Camden | Missouri | 29029 | 300 | 4 |
393878 | 393878 | 2020-08-02 | Cape Girardeau | Missouri | 29031 | 597 | 3 |
393879 | 393879 | 2020-08-02 | Carroll | Missouri | 29033 | 98 | 0 |
393880 | 393880 | 2020-08-02 | Carter | Missouri | 29035 | 20 | 1 |
393881 | 393881 | 2020-08-02 | Cass | Missouri | 29037 | 667 | 12 |
393882 | 393882 | 2020-08-02 | Cedar | Missouri | 29039 | 34 | 0 |
393883 | 393883 | 2020-08-02 | Chariton | Missouri | 29041 | 14 | 0 |
393884 | 393884 | 2020-08-02 | Christian | Missouri | 29043 | 281 | 1 |
393885 | 393885 | 2020-08-02 | Clark | Missouri | 29045 | 14 | 0 |
393886 | 393886 | 2020-08-02 | Clay | Missouri | 29047 | 900 | 22 |
393887 | 393887 | 2020-08-02 | Clinton | Missouri | 29049 | 61 | 0 |
393888 | 393888 | 2020-08-02 | Cole | Missouri | 29051 | 315 | 2 |
393889 | 393889 | 2020-08-02 | Cooper | Missouri | 29053 | 94 | 0 |
393890 | 393890 | 2020-08-02 | Crawford | Missouri | 29055 | 56 | 0 |
393891 | 393891 | 2020-08-02 | Dade | Missouri | 29057 | 15 | 0 |
393892 | 393892 | 2020-08-02 | Dallas | Missouri | 29059 | 49 | 1 |
393893 | 393893 | 2020-08-02 | Daviess | Missouri | 29061 | 17 | 0 |
393894 | 393894 | 2020-08-02 | DeKalb | Missouri | 29063 | 32 | 1 |
393895 | 393895 | 2020-08-02 | Dent | Missouri | 29065 | 9 | 0 |
393896 | 393896 | 2020-08-02 | Douglas | Missouri | 29067 | 73 | 2 |
393897 | 393897 | 2020-08-02 | Dunklin | Missouri | 29069 | 247 | 4 |
393898 | 393898 | 2020-08-02 | Franklin | Missouri | 29071 | 519 | 18 |
393899 | 393899 | 2020-08-02 | Gasconade | Missouri | 29073 | 20 | 0 |
393900 | 393900 | 2020-08-02 | Gentry | Missouri | 29075 | 79 | 9 |
393901 | 393901 | 2020-08-02 | Greene | Missouri | 29077 | 1260 | 11 |
393902 | 393902 | 2020-08-02 | Grundy | Missouri | 29079 | 24 | 1 |
393903 | 393903 | 2020-08-02 | Harrison | Missouri | 29081 | 60 | 1 |
393904 | 393904 | 2020-08-02 | Henry | Missouri | 29083 | 69 | 3 |
393905 | 393905 | 2020-08-02 | Hickory | Missouri | 29085 | 17 | 0 |
393906 | 393906 | 2020-08-02 | Holt | Missouri | 29087 | 6 | 0 |
393907 | 393907 | 2020-08-02 | Howard | Missouri | 29089 | 46 | 0 |
393908 | 393908 | 2020-08-02 | Howell | Missouri | 29091 | 137 | 2 |
393909 | 393909 | 2020-08-02 | Iron | Missouri | 29093 | 16 | 0 |
393910 | 393910 | 2020-08-02 | Jackson | Missouri | 29095 | 3450 | 59 |
393911 | 393911 | 2020-08-02 | Jasper | Missouri | 29097 | 1204 | 5 |
393912 | 393912 | 2020-08-02 | Jefferson | Missouri | 29099 | 1417 | 25 |
393913 | 393913 | 2020-08-02 | Johnson | Missouri | 29101 | 464 | 2 |
393914 | 393914 | 2020-08-02 | Joplin | Missouri | 448 | 20 | |
393915 | 393915 | 2020-08-02 | Kansas City | Missouri | 5929 | 69 | |
393916 | 393916 | 2020-08-02 | Knox | Missouri | 29103 | 15 | 0 |
393917 | 393917 | 2020-08-02 | Laclede | Missouri | 29105 | 197 | 1 |
393918 | 393918 | 2020-08-02 | Lafayette | Missouri | 29107 | 152 | 2 |
393919 | 393919 | 2020-08-02 | Lawrence | Missouri | 29109 | 186 | 2 |
393920 | 393920 | 2020-08-02 | Lewis | Missouri | 29111 | 33 | 1 |
393921 | 393921 | 2020-08-02 | Lincoln | Missouri | 29113 | 301 | 1 |
393922 | 393922 | 2020-08-02 | Linn | Missouri | 29115 | 31 | 1 |
393923 | 393923 | 2020-08-02 | Livingston | Missouri | 29117 | 53 | 0 |
393924 | 393924 | 2020-08-02 | Macon | Missouri | 29121 | 53 | 0 |
393925 | 393925 | 2020-08-02 | Madison | Missouri | 29123 | 17 | 0 |
393926 | 393926 | 2020-08-02 | Maries | Missouri | 29125 | 14 | 0 |
393927 | 393927 | 2020-08-02 | Marion | Missouri | 29127 | 150 | 1 |
393928 | 393928 | 2020-08-02 | McDonald | Missouri | 29119 | 988 | 7 |
393929 | 393929 | 2020-08-02 | Mercer | Missouri | 29129 | 9 | 0 |
393930 | 393930 | 2020-08-02 | Miller | Missouri | 29131 | 96 | 0 |
393931 | 393931 | 2020-08-02 | Mississippi | Missouri | 29133 | 130 | 0 |
393932 | 393932 | 2020-08-02 | Moniteau | Missouri | 29135 | 123 | 2 |
393933 | 393933 | 2020-08-02 | Monroe | Missouri | 29137 | 17 | 0 |
393934 | 393934 | 2020-08-02 | Montgomery | Missouri | 29139 | 36 | 0 |
393935 | 393935 | 2020-08-02 | Morgan | Missouri | 29141 | 67 | 0 |
393936 | 393936 | 2020-08-02 | New Madrid | Missouri | 29143 | 184 | 1 |
393937 | 393937 | 2020-08-02 | Newton | Missouri | 29145 | 801 | 6 |
393938 | 393938 | 2020-08-02 | Nodaway | Missouri | 29147 | 157 | 0 |
393939 | 393939 | 2020-08-02 | Oregon | Missouri | 29149 | 14 | 0 |
393940 | 393940 | 2020-08-02 | Osage | Missouri | 29151 | 39 | 0 |
393941 | 393941 | 2020-08-02 | Ozark | Missouri | 29153 | 7 | 0 |
393942 | 393942 | 2020-08-02 | Pemiscot | Missouri | 29155 | 205 | 8 |
393943 | 393943 | 2020-08-02 | Perry | Missouri | 29157 | 206 | 4 |
393944 | 393944 | 2020-08-02 | Pettis | Missouri | 29159 | 410 | 4 |
393945 | 393945 | 2020-08-02 | Phelps | Missouri | 29161 | 75 | 0 |
393946 | 393946 | 2020-08-02 | Pike | Missouri | 29163 | 69 | 1 |
393947 | 393947 | 2020-08-02 | Platte | Missouri | 29165 | 318 | 10 |
393948 | 393948 | 2020-08-02 | Polk | Missouri | 29167 | 191 | 0 |
393949 | 393949 | 2020-08-02 | Pulaski | Missouri | 29169 | 180 | 1 |
393950 | 393950 | 2020-08-02 | Putnam | Missouri | 29171 | 10 | 1 |
393951 | 393951 | 2020-08-02 | Ralls | Missouri | 29173 | 21 | 0 |
393952 | 393952 | 2020-08-02 | Randolph | Missouri | 29175 | 55 | 1 |
393953 | 393953 | 2020-08-02 | Ray | Missouri | 29177 | 90 | 0 |
393954 | 393954 | 2020-08-02 | Reynolds | Missouri | 29179 | 16 | 0 |
393955 | 393955 | 2020-08-02 | Ripley | Missouri | 29181 | 40 | 0 |
393956 | 393956 | 2020-08-02 | Saline | Missouri | 29195 | 410 | 7 |
393957 | 393957 | 2020-08-02 | Schuyler | Missouri | 29197 | 9 | 0 |
393958 | 393958 | 2020-08-02 | Scotland | Missouri | 29199 | 12 | 1 |
393959 | 393959 | 2020-08-02 | Scott | Missouri | 29201 | 345 | 13 |
393960 | 393960 | 2020-08-02 | Shannon | Missouri | 29203 | 43 | 1 |
393961 | 393961 | 2020-08-02 | Shelby | Missouri | 29205 | 28 | 0 |
393962 | 393962 | 2020-08-02 | St. Charles | Missouri | 29183 | 3679 | 97 |
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);