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-07-12 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
325258 | 325258 | 2020-07-12 | Alameda | California | 6001 | 7866 | 148 |
325259 | 325259 | 2020-07-12 | Alpine | California | 6003 | 1 | 0 |
325260 | 325260 | 2020-07-12 | Amador | California | 6005 | 38 | 0 |
325261 | 325261 | 2020-07-12 | Butte | California | 6007 | 338 | 4 |
325262 | 325262 | 2020-07-12 | Calaveras | California | 6009 | 67 | 0 |
325263 | 325263 | 2020-07-12 | Colusa | California | 6011 | 113 | 0 |
325264 | 325264 | 2020-07-12 | Contra Costa | California | 6013 | 4661 | 90 |
325265 | 325265 | 2020-07-12 | Del Norte | California | 6015 | 60 | 0 |
325266 | 325266 | 2020-07-12 | El Dorado | California | 6017 | 307 | 0 |
325267 | 325267 | 2020-07-12 | Fresno | California | 6019 | 8282 | 88 |
325268 | 325268 | 2020-07-12 | Glenn | California | 6021 | 161 | 0 |
325269 | 325269 | 2020-07-12 | Humboldt | California | 6023 | 174 | 4 |
325270 | 325270 | 2020-07-12 | Imperial | California | 6025 | 7827 | 134 |
325271 | 325271 | 2020-07-12 | Inyo | California | 6027 | 35 | 1 |
325272 | 325272 | 2020-07-12 | Kern | California | 6029 | 6512 | 97 |
325273 | 325273 | 2020-07-12 | Kings | California | 6031 | 2970 | 39 |
325274 | 325274 | 2020-07-12 | Lake | California | 6033 | 110 | 1 |
325275 | 325275 | 2020-07-12 | Lassen | California | 6035 | 337 | 0 |
325276 | 325276 | 2020-07-12 | Los Angeles | California | 6037 | 133549 | 3809 |
325277 | 325277 | 2020-07-12 | Madera | California | 6039 | 988 | 8 |
325278 | 325278 | 2020-07-12 | Marin | California | 6041 | 3191 | 23 |
325279 | 325279 | 2020-07-12 | Mariposa | California | 6043 | 32 | 1 |
325280 | 325280 | 2020-07-12 | Mendocino | California | 6045 | 132 | 0 |
325281 | 325281 | 2020-07-12 | Merced | California | 6047 | 1884 | 12 |
325282 | 325282 | 2020-07-12 | Mono | California | 6051 | 51 | 1 |
325283 | 325283 | 2020-07-12 | Monterey | California | 6053 | 2682 | 18 |
325284 | 325284 | 2020-07-12 | Napa | California | 6055 | 510 | 4 |
325285 | 325285 | 2020-07-12 | Nevada | California | 6057 | 163 | 1 |
325286 | 325286 | 2020-07-12 | Orange | California | 6059 | 24430 | 421 |
325287 | 325287 | 2020-07-12 | Placer | California | 6061 | 1077 | 11 |
325288 | 325288 | 2020-07-12 | Plumas | California | 6063 | 12 | 0 |
325289 | 325289 | 2020-07-12 | Riverside | California | 6065 | 25994 | 537 |
325290 | 325290 | 2020-07-12 | Sacramento | California | 6067 | 5488 | 83 |
325291 | 325291 | 2020-07-12 | San Benito | California | 6069 | 362 | 2 |
325292 | 325292 | 2020-07-12 | San Bernardino | California | 6071 | 19043 | 306 |
325293 | 325293 | 2020-07-12 | San Diego | California | 6073 | 19992 | 422 |
325294 | 325294 | 2020-07-12 | San Francisco | California | 6075 | 4525 | 50 |
325295 | 325295 | 2020-07-12 | San Joaquin | California | 6077 | 6518 | 68 |
325296 | 325296 | 2020-07-12 | San Luis Obispo | California | 6079 | 930 | 4 |
325297 | 325297 | 2020-07-12 | San Mateo | California | 6081 | 3956 | 112 |
325298 | 325298 | 2020-07-12 | Santa Barbara | California | 6083 | 4283 | 31 |
325299 | 325299 | 2020-07-12 | Santa Clara | California | 6085 | 6298 | 167 |
325300 | 325300 | 2020-07-12 | Santa Cruz | California | 6087 | 571 | 3 |
325301 | 325301 | 2020-07-12 | Shasta | California | 6089 | 200 | 6 |
325302 | 325302 | 2020-07-12 | Sierra | California | 6091 | 1 | 0 |
325303 | 325303 | 2020-07-12 | Siskiyou | California | 6093 | 41 | 0 |
325304 | 325304 | 2020-07-12 | Solano | California | 6095 | 2080 | 28 |
325305 | 325305 | 2020-07-12 | Sonoma | California | 6097 | 1819 | 16 |
325306 | 325306 | 2020-07-12 | Stanislaus | California | 6099 | 4973 | 51 |
325307 | 325307 | 2020-07-12 | Sutter | California | 6101 | 403 | 4 |
325308 | 325308 | 2020-07-12 | Tehama | California | 6103 | 111 | 1 |
325309 | 325309 | 2020-07-12 | Trinity | California | 6105 | 3 | 0 |
325310 | 325310 | 2020-07-12 | Tulare | California | 6107 | 5780 | 152 |
325311 | 325311 | 2020-07-12 | Tuolumne | California | 6109 | 73 | 0 |
325312 | 325312 | 2020-07-12 | Ventura | California | 6111 | 4545 | 53 |
325313 | 325313 | 2020-07-12 | Yolo | California | 6113 | 929 | 28 |
325314 | 325314 | 2020-07-12 | Yuba | California | 6115 | 198 | 3 |
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);