ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where "date" is on date 2020-04-13 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
55097 | 55097 | 2020-04-13 | Adair | Missouri | 29001 | 11 | 0 |
55098 | 55098 | 2020-04-13 | Andrew | Missouri | 29003 | 1 | 0 |
55099 | 55099 | 2020-04-13 | Atchison | Missouri | 29005 | 1 | 0 |
55100 | 55100 | 2020-04-13 | Barry | Missouri | 29009 | 2 | 0 |
55101 | 55101 | 2020-04-13 | Bates | Missouri | 29013 | 6 | 1 |
55102 | 55102 | 2020-04-13 | Benton | Missouri | 29015 | 3 | 0 |
55103 | 55103 | 2020-04-13 | Bollinger | Missouri | 29017 | 3 | 0 |
55104 | 55104 | 2020-04-13 | Boone | Missouri | 29019 | 82 | 1 |
55105 | 55105 | 2020-04-13 | Buchanan | Missouri | 29021 | 22 | 1 |
55106 | 55106 | 2020-04-13 | Butler | Missouri | 29023 | 16 | 0 |
55107 | 55107 | 2020-04-13 | Caldwell | Missouri | 29025 | 1 | 0 |
55108 | 55108 | 2020-04-13 | Callaway | Missouri | 29027 | 20 | 1 |
55109 | 55109 | 2020-04-13 | Camden | Missouri | 29029 | 26 | 1 |
55110 | 55110 | 2020-04-13 | Cape Girardeau | Missouri | 29031 | 30 | 1 |
55111 | 55111 | 2020-04-13 | Carter | Missouri | 29035 | 3 | 1 |
55112 | 55112 | 2020-04-13 | Cass | Missouri | 29037 | 36 | 2 |
55113 | 55113 | 2020-04-13 | Cedar | Missouri | 29039 | 5 | 0 |
55114 | 55114 | 2020-04-13 | Chariton | Missouri | 29041 | 4 | 0 |
55115 | 55115 | 2020-04-13 | Christian | Missouri | 29043 | 17 | 0 |
55116 | 55116 | 2020-04-13 | Clark | Missouri | 29045 | 1 | 0 |
55117 | 55117 | 2020-04-13 | Clay | Missouri | 29047 | 51 | 1 |
55118 | 55118 | 2020-04-13 | Clinton | Missouri | 29049 | 11 | 0 |
55119 | 55119 | 2020-04-13 | Cole | Missouri | 29051 | 37 | 1 |
55120 | 55120 | 2020-04-13 | Cooper | Missouri | 29053 | 4 | 0 |
55121 | 55121 | 2020-04-13 | Crawford | Missouri | 29055 | 4 | 0 |
55122 | 55122 | 2020-04-13 | Dallas | Missouri | 29059 | 2 | 0 |
55123 | 55123 | 2020-04-13 | DeKalb | Missouri | 29063 | 3 | 0 |
55124 | 55124 | 2020-04-13 | Dunklin | Missouri | 29069 | 16 | 0 |
55125 | 55125 | 2020-04-13 | Franklin | Missouri | 29071 | 84 | 3 |
55126 | 55126 | 2020-04-13 | Gasconade | Missouri | 29073 | 2 | 0 |
55127 | 55127 | 2020-04-13 | Gentry | Missouri | 29075 | 1 | 0 |
55128 | 55128 | 2020-04-13 | Greene | Missouri | 29077 | 71 | 8 |
55129 | 55129 | 2020-04-13 | Harrison | Missouri | 29081 | 6 | 0 |
55130 | 55130 | 2020-04-13 | Henry | Missouri | 29083 | 4 | 1 |
55131 | 55131 | 2020-04-13 | Howard | Missouri | 29089 | 2 | 0 |
55132 | 55132 | 2020-04-13 | Howell | Missouri | 29091 | 4 | 0 |
55133 | 55133 | 2020-04-13 | Iron | Missouri | 29093 | 1 | 0 |
55134 | 55134 | 2020-04-13 | Jackson | Missouri | 29095 | 223 | 7 |
55135 | 55135 | 2020-04-13 | Jasper | Missouri | 29097 | 21 | 0 |
55136 | 55136 | 2020-04-13 | Jefferson | Missouri | 29099 | 129 | 3 |
55137 | 55137 | 2020-04-13 | Johnson | Missouri | 29101 | 39 | 0 |
55138 | 55138 | 2020-04-13 | Kansas City | Missouri | 329 | 8 | |
55139 | 55139 | 2020-04-13 | Lafayette | Missouri | 29107 | 27 | 1 |
55140 | 55140 | 2020-04-13 | Lincoln | Missouri | 29113 | 26 | 1 |
55141 | 55141 | 2020-04-13 | Linn | Missouri | 29115 | 4 | 1 |
55142 | 55142 | 2020-04-13 | Livingston | Missouri | 29117 | 1 | 0 |
55143 | 55143 | 2020-04-13 | Macon | Missouri | 29121 | 2 | 0 |
55144 | 55144 | 2020-04-13 | Madison | Missouri | 29123 | 1 | 0 |
55145 | 55145 | 2020-04-13 | Maries | Missouri | 29125 | 2 | 0 |
55146 | 55146 | 2020-04-13 | McDonald | Missouri | 29119 | 4 | 0 |
55147 | 55147 | 2020-04-13 | Moniteau | Missouri | 29135 | 3 | 0 |
55148 | 55148 | 2020-04-13 | Montgomery | Missouri | 29139 | 6 | 0 |
55149 | 55149 | 2020-04-13 | Morgan | Missouri | 29141 | 1 | 0 |
55150 | 55150 | 2020-04-13 | New Madrid | Missouri | 29143 | 8 | 0 |
55151 | 55151 | 2020-04-13 | Newton | Missouri | 29145 | 8 | 0 |
55152 | 55152 | 2020-04-13 | Nodaway | Missouri | 29147 | 2 | 0 |
55153 | 55153 | 2020-04-13 | Oregon | Missouri | 29149 | 1 | 0 |
55154 | 55154 | 2020-04-13 | Osage | Missouri | 29151 | 4 | 0 |
55155 | 55155 | 2020-04-13 | Pemiscot | Missouri | 29155 | 8 | 0 |
55156 | 55156 | 2020-04-13 | Perry | Missouri | 29157 | 36 | 0 |
55157 | 55157 | 2020-04-13 | Pettis | Missouri | 29159 | 3 | 0 |
55158 | 55158 | 2020-04-13 | Phelps | Missouri | 29161 | 1 | 0 |
55159 | 55159 | 2020-04-13 | Pike | Missouri | 29163 | 6 | 0 |
55160 | 55160 | 2020-04-13 | Platte | Missouri | 29165 | 25 | 0 |
55161 | 55161 | 2020-04-13 | Polk | Missouri | 29167 | 1 | 0 |
55162 | 55162 | 2020-04-13 | Pulaski | Missouri | 29169 | 10 | 1 |
55163 | 55163 | 2020-04-13 | Ralls | Missouri | 29173 | 1 | 0 |
55164 | 55164 | 2020-04-13 | Randolph | Missouri | 29175 | 8 | 0 |
55165 | 55165 | 2020-04-13 | Ray | Missouri | 29177 | 7 | 0 |
55166 | 55166 | 2020-04-13 | Reynolds | Missouri | 29179 | 2 | 0 |
55167 | 55167 | 2020-04-13 | Ripley | Missouri | 29181 | 3 | 0 |
55168 | 55168 | 2020-04-13 | Saline | Missouri | 29195 | 23 | 0 |
55169 | 55169 | 2020-04-13 | Scotland | Missouri | 29199 | 3 | 0 |
55170 | 55170 | 2020-04-13 | Scott | Missouri | 29201 | 24 | 0 |
55171 | 55171 | 2020-04-13 | Shelby | Missouri | 29205 | 1 | 0 |
55172 | 55172 | 2020-04-13 | St. Charles | Missouri | 29183 | 346 | 14 |
55173 | 55173 | 2020-04-13 | St. Clair | Missouri | 29185 | 2 | 0 |
55174 | 55174 | 2020-04-13 | St. Francois | Missouri | 29187 | 23 | 1 |
55175 | 55175 | 2020-04-13 | St. Louis | Missouri | 29189 | 1724 | 50 |
55176 | 55176 | 2020-04-13 | St. Louis city | Missouri | 29510 | 639 | 24 |
55177 | 55177 | 2020-04-13 | Ste. Genevieve | Missouri | 29186 | 7 | 1 |
55178 | 55178 | 2020-04-13 | Stoddard | Missouri | 29207 | 11 | 0 |
55179 | 55179 | 2020-04-13 | Stone | Missouri | 29209 | 3 | 0 |
55180 | 55180 | 2020-04-13 | Taney | Missouri | 29213 | 8 | 1 |
55181 | 55181 | 2020-04-13 | Vernon | Missouri | 29217 | 3 | 0 |
55182 | 55182 | 2020-04-13 | Warren | Missouri | 29219 | 12 | 0 |
55183 | 55183 | 2020-04-13 | Washington | Missouri | 29221 | 1 | 0 |
55184 | 55184 | 2020-04-13 | Webster | Missouri | 29225 | 4 | 0 |
55185 | 55185 | 2020-04-13 | Worth | Missouri | 29227 | 1 | 0 |
55186 | 55186 | 2020-04-13 | Wright | Missouri | 29229 | 8 | 0 |
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);