ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where "date" is on date 2020-06-14 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
237209 | 237209 | 2020-06-14 | Alameda | California | 6001 | 4341 | 112 |
237210 | 237210 | 2020-06-14 | Alpine | California | 6003 | 1 | 0 |
237211 | 237211 | 2020-06-14 | Amador | California | 6005 | 9 | 0 |
237212 | 237212 | 2020-06-14 | Butte | California | 6007 | 74 | 1 |
237213 | 237213 | 2020-06-14 | Calaveras | California | 6009 | 26 | 0 |
237214 | 237214 | 2020-06-14 | Colusa | California | 6011 | 7 | 0 |
237215 | 237215 | 2020-06-14 | Contra Costa | California | 6013 | 1959 | 44 |
237216 | 237216 | 2020-06-14 | Del Norte | California | 6015 | 47 | 0 |
237217 | 237217 | 2020-06-14 | El Dorado | California | 6017 | 113 | 0 |
237218 | 237218 | 2020-06-14 | Fresno | California | 6019 | 2547 | 52 |
237219 | 237219 | 2020-06-14 | Glenn | California | 6021 | 24 | 0 |
237220 | 237220 | 2020-06-14 | Humboldt | California | 6023 | 106 | 4 |
237221 | 237221 | 2020-06-14 | Imperial | California | 6025 | 4157 | 42 |
237222 | 237222 | 2020-06-14 | Inyo | California | 6027 | 23 | 1 |
237223 | 237223 | 2020-06-14 | Kern | California | 6029 | 3291 | 55 |
237224 | 237224 | 2020-06-14 | Kings | California | 6031 | 1805 | 6 |
237225 | 237225 | 2020-06-14 | Lake | California | 6033 | 31 | 0 |
237226 | 237226 | 2020-06-14 | Lassen | California | 6035 | 9 | 0 |
237227 | 237227 | 2020-06-14 | Los Angeles | California | 6037 | 73018 | 2907 |
237228 | 237228 | 2020-06-14 | Madera | California | 6039 | 203 | 3 |
237229 | 237229 | 2020-06-14 | Marin | California | 6041 | 730 | 17 |
237230 | 237230 | 2020-06-14 | Mariposa | California | 6043 | 16 | 1 |
237231 | 237231 | 2020-06-14 | Mendocino | California | 6045 | 38 | 0 |
237232 | 237232 | 2020-06-14 | Merced | California | 6047 | 409 | 7 |
237233 | 237233 | 2020-06-14 | Mono | California | 6051 | 37 | 1 |
237234 | 237234 | 2020-06-14 | Monterey | California | 6053 | 949 | 12 |
237235 | 237235 | 2020-06-14 | Napa | California | 6055 | 184 | 3 |
237236 | 237236 | 2020-06-14 | Nevada | California | 6057 | 52 | 1 |
237237 | 237237 | 2020-06-14 | Orange | California | 6059 | 8581 | 221 |
237238 | 237238 | 2020-06-14 | Placer | California | 6061 | 372 | 9 |
237239 | 237239 | 2020-06-14 | Plumas | California | 6063 | 4 | 0 |
237240 | 237240 | 2020-06-14 | Riverside | California | 6065 | 10931 | 383 |
237241 | 237241 | 2020-06-14 | Sacramento | California | 6067 | 1752 | 63 |
237242 | 237242 | 2020-06-14 | San Benito | California | 6069 | 125 | 2 |
237243 | 237243 | 2020-06-14 | San Bernardino | California | 6071 | 7359 | 229 |
237244 | 237244 | 2020-06-14 | San Diego | California | 6073 | 9503 | 320 |
237245 | 237245 | 2020-06-14 | San Francisco | California | 6075 | 2931 | 45 |
237246 | 237246 | 2020-06-14 | San Joaquin | California | 6077 | 1652 | 43 |
237247 | 237247 | 2020-06-14 | San Luis Obispo | California | 6079 | 326 | 1 |
237248 | 237248 | 2020-06-14 | San Mateo | California | 6081 | 2553 | 99 |
237249 | 237249 | 2020-06-14 | Santa Barbara | California | 6083 | 1999 | 18 |
237250 | 237250 | 2020-06-14 | Santa Clara | California | 6085 | 3197 | 152 |
237251 | 237251 | 2020-06-14 | Santa Cruz | California | 6087 | 257 | 3 |
237252 | 237252 | 2020-06-14 | Shasta | California | 6089 | 50 | 5 |
237253 | 237253 | 2020-06-14 | Sierra | California | 6091 | 1 | 0 |
237254 | 237254 | 2020-06-14 | Siskiyou | California | 6093 | 16 | 0 |
237255 | 237255 | 2020-06-14 | Solano | California | 6095 | 662 | 23 |
237256 | 237256 | 2020-06-14 | Sonoma | California | 6097 | 758 | 4 |
237257 | 237257 | 2020-06-14 | Stanislaus | California | 6099 | 1122 | 34 |
237258 | 237258 | 2020-06-14 | Sutter | California | 6101 | 86 | 2 |
237259 | 237259 | 2020-06-14 | Tehama | California | 6103 | 17 | 1 |
237260 | 237260 | 2020-06-14 | Trinity | California | 6105 | 3 | 0 |
237261 | 237261 | 2020-06-14 | Tulare | California | 6107 | 2626 | 98 |
237262 | 237262 | 2020-06-14 | Tuolumne | California | 6109 | 9 | 0 |
237263 | 237263 | 2020-06-14 | Ventura | California | 6111 | 1567 | 40 |
237264 | 237264 | 2020-06-14 | Yolo | California | 6113 | 253 | 24 |
237265 | 237265 | 2020-06-14 | Yuba | California | 6115 | 35 | 1 |
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);