ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-08-27" and state = "California" 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 |
---|---|---|---|---|---|---|---|
473159 | 473159 | 2020-08-27 | Alameda | California | 6001 | 17642 | 244 |
473160 | 473160 | 2020-08-27 | Alpine | California | 6003 | 2 | 0 |
473161 | 473161 | 2020-08-27 | Amador | California | 6005 | 230 | 14 |
473162 | 473162 | 2020-08-27 | Butte | California | 6007 | 1815 | 21 |
473163 | 473163 | 2020-08-27 | Calaveras | California | 6009 | 223 | 2 |
473164 | 473164 | 2020-08-27 | Colusa | California | 6011 | 439 | 6 |
473165 | 473165 | 2020-08-27 | Contra Costa | California | 6013 | 13398 | 173 |
473166 | 473166 | 2020-08-27 | Del Norte | California | 6015 | 122 | 1 |
473167 | 473167 | 2020-08-27 | El Dorado | California | 6017 | 942 | 2 |
473168 | 473168 | 2020-08-27 | Fresno | California | 6019 | 24071 | 239 |
473169 | 473169 | 2020-08-27 | Glenn | California | 6021 | 429 | 3 |
473170 | 473170 | 2020-08-27 | Humboldt | California | 6023 | 364 | 4 |
473171 | 473171 | 2020-08-27 | Imperial | California | 6025 | 10573 | 285 |
473172 | 473172 | 2020-08-27 | Inyo | California | 6027 | 157 | 13 |
473173 | 473173 | 2020-08-27 | Kern | California | 6029 | 28854 | 256 |
473174 | 473174 | 2020-08-27 | Kings | California | 6031 | 6090 | 72 |
473175 | 473175 | 2020-08-27 | Lake | California | 6033 | 308 | 3 |
473176 | 473176 | 2020-08-27 | Lassen | California | 6035 | 716 | 0 |
473177 | 473177 | 2020-08-27 | Los Angeles | California | 6037 | 236986 | 5701 |
473178 | 473178 | 2020-08-27 | Madera | California | 6039 | 3551 | 53 |
473179 | 473179 | 2020-08-27 | Marin | California | 6041 | 6053 | 95 |
473180 | 473180 | 2020-08-27 | Mariposa | California | 6043 | 71 | 2 |
473181 | 473181 | 2020-08-27 | Mendocino | California | 6045 | 659 | 17 |
473182 | 473182 | 2020-08-27 | Merced | California | 6047 | 7814 | 114 |
473183 | 473183 | 2020-08-27 | Modoc | California | 6049 | 7 | 0 |
473184 | 473184 | 2020-08-27 | Mono | California | 6051 | 162 | 2 |
473185 | 473185 | 2020-08-27 | Monterey | California | 6053 | 7522 | 53 |
473186 | 473186 | 2020-08-27 | Napa | California | 6055 | 1394 | 13 |
473187 | 473187 | 2020-08-27 | Nevada | California | 6057 | 432 | 5 |
473188 | 473188 | 2020-08-27 | Orange | California | 6059 | 47459 | 947 |
473189 | 473189 | 2020-08-27 | Placer | California | 6061 | 2875 | 32 |
473190 | 473190 | 2020-08-27 | Plumas | California | 6063 | 39 | 0 |
473191 | 473191 | 2020-08-27 | Riverside | California | 6065 | 51734 | 997 |
473192 | 473192 | 2020-08-27 | Sacramento | California | 6067 | 16908 | 265 |
473193 | 473193 | 2020-08-27 | San Benito | California | 6069 | 1018 | 7 |
473194 | 473194 | 2020-08-27 | San Bernardino | California | 6071 | 46407 | 715 |
473195 | 473195 | 2020-08-27 | San Diego | California | 6073 | 37562 | 673 |
473196 | 473196 | 2020-08-27 | San Francisco | California | 6075 | 9152 | 82 |
473197 | 473197 | 2020-08-27 | San Joaquin | California | 6077 | 16845 | 305 |
473198 | 473198 | 2020-08-27 | San Luis Obispo | California | 6079 | 2842 | 21 |
473199 | 473199 | 2020-08-27 | San Mateo | California | 6081 | 7911 | 130 |
473200 | 473200 | 2020-08-27 | Santa Barbara | California | 6083 | 7951 | 91 |
473201 | 473201 | 2020-08-27 | Santa Clara | California | 6085 | 16607 | 241 |
473202 | 473202 | 2020-08-27 | Santa Cruz | California | 6087 | 1726 | 7 |
473203 | 473203 | 2020-08-27 | Shasta | California | 6089 | 557 | 12 |
473204 | 473204 | 2020-08-27 | Sierra | California | 6091 | 6 | 0 |
473205 | 473205 | 2020-08-27 | Siskiyou | California | 6093 | 127 | 0 |
473206 | 473206 | 2020-08-27 | Solano | California | 6095 | 5333 | 46 |
473207 | 473207 | 2020-08-27 | Sonoma | California | 6097 | 5469 | 78 |
473208 | 473208 | 2020-08-27 | Stanislaus | California | 6099 | 14101 | 245 |
473209 | 473209 | 2020-08-27 | Sutter | California | 6101 | 1347 | 10 |
473210 | 473210 | 2020-08-27 | Tehama | California | 6103 | 396 | 1 |
473211 | 473211 | 2020-08-27 | Trinity | California | 6105 | 11 | 0 |
473212 | 473212 | 2020-08-27 | Tulare | California | 6107 | 13775 | 229 |
473213 | 473213 | 2020-08-27 | Tuolumne | California | 6109 | 181 | 2 |
473214 | 473214 | 2020-08-27 | Ventura | California | 6111 | 10412 | 110 |
473215 | 473215 | 2020-08-27 | Yolo | California | 6113 | 2287 | 51 |
473216 | 473216 | 2020-08-27 | Yuba | California | 6115 | 900 | 6 |
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);