ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-05-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 |
---|---|---|---|---|---|---|---|
136394 | 136394 | 2020-05-12 | Alameda | California | 6001 | 2154 | 75 |
136395 | 136395 | 2020-05-12 | Alpine | California | 6003 | 2 | 0 |
136396 | 136396 | 2020-05-12 | Amador | California | 6005 | 7 | 0 |
136397 | 136397 | 2020-05-12 | Butte | California | 6007 | 20 | 0 |
136398 | 136398 | 2020-05-12 | Calaveras | California | 6009 | 13 | 0 |
136399 | 136399 | 2020-05-12 | Colusa | California | 6011 | 3 | 0 |
136400 | 136400 | 2020-05-12 | Contra Costa | California | 6013 | 1066 | 32 |
136401 | 136401 | 2020-05-12 | Del Norte | California | 6015 | 3 | 0 |
136402 | 136402 | 2020-05-12 | El Dorado | California | 6017 | 60 | 0 |
136403 | 136403 | 2020-05-12 | Fresno | California | 6019 | 984 | 10 |
136404 | 136404 | 2020-05-12 | Glenn | California | 6021 | 6 | 0 |
136405 | 136405 | 2020-05-12 | Humboldt | California | 6023 | 64 | 0 |
136406 | 136406 | 2020-05-12 | Imperial | California | 6025 | 603 | 12 |
136407 | 136407 | 2020-05-12 | Inyo | California | 6027 | 20 | 1 |
136408 | 136408 | 2020-05-12 | Kern | California | 6029 | 1331 | 17 |
136409 | 136409 | 2020-05-12 | Kings | California | 6031 | 325 | 1 |
136410 | 136410 | 2020-05-12 | Lake | California | 6033 | 8 | 0 |
136411 | 136411 | 2020-05-12 | Los Angeles | California | 6037 | 33180 | 1613 |
136412 | 136412 | 2020-05-12 | Madera | California | 6039 | 69 | 2 |
136413 | 136413 | 2020-05-12 | Marin | California | 6041 | 271 | 14 |
136414 | 136414 | 2020-05-12 | Mariposa | California | 6043 | 15 | 0 |
136415 | 136415 | 2020-05-12 | Mendocino | California | 6045 | 12 | 0 |
136416 | 136416 | 2020-05-12 | Merced | California | 6047 | 177 | 4 |
136417 | 136417 | 2020-05-12 | Mono | California | 6051 | 32 | 1 |
136418 | 136418 | 2020-05-12 | Monterey | California | 6053 | 286 | 6 |
136419 | 136419 | 2020-05-12 | Napa | California | 6055 | 82 | 3 |
136420 | 136420 | 2020-05-12 | Nevada | California | 6057 | 41 | 1 |
136421 | 136421 | 2020-05-12 | Orange | California | 6059 | 3699 | 78 |
136422 | 136422 | 2020-05-12 | Placer | California | 6061 | 170 | 8 |
136423 | 136423 | 2020-05-12 | Plumas | California | 6063 | 4 | 0 |
136424 | 136424 | 2020-05-12 | Riverside | California | 6065 | 5248 | 228 |
136425 | 136425 | 2020-05-12 | Sacramento | California | 6067 | 1180 | 52 |
136426 | 136426 | 2020-05-12 | San Benito | California | 6069 | 58 | 2 |
136427 | 136427 | 2020-05-12 | San Bernardino | California | 6071 | 3078 | 121 |
136428 | 136428 | 2020-05-12 | San Diego | California | 6073 | 5224 | 204 |
136429 | 136429 | 2020-05-12 | San Francisco | California | 6075 | 1980 | 35 |
136430 | 136430 | 2020-05-12 | San Joaquin | California | 6077 | 629 | 30 |
136431 | 136431 | 2020-05-12 | San Luis Obispo | California | 6079 | 227 | 1 |
136432 | 136432 | 2020-05-12 | San Mateo | California | 6081 | 1499 | 65 |
136433 | 136433 | 2020-05-12 | Santa Barbara | California | 6083 | 1372 | 11 |
136434 | 136434 | 2020-05-12 | Santa Clara | California | 6085 | 2364 | 134 |
136435 | 136435 | 2020-05-12 | Santa Cruz | California | 6087 | 146 | 2 |
136436 | 136436 | 2020-05-12 | Shasta | California | 6089 | 32 | 4 |
136437 | 136437 | 2020-05-12 | Siskiyou | California | 6093 | 5 | 0 |
136438 | 136438 | 2020-05-12 | Solano | California | 6095 | 393 | 11 |
136439 | 136439 | 2020-05-12 | Sonoma | California | 6097 | 312 | 5 |
136440 | 136440 | 2020-05-12 | Stanislaus | California | 6099 | 517 | 22 |
136441 | 136441 | 2020-05-12 | Sutter | California | 6101 | 35 | 2 |
136442 | 136442 | 2020-05-12 | Tehama | California | 6103 | 1 | 1 |
136443 | 136443 | 2020-05-12 | Trinity | California | 6105 | 2 | 0 |
136444 | 136444 | 2020-05-12 | Tulare | California | 6107 | 1241 | 52 |
136445 | 136445 | 2020-05-12 | Tuolumne | California | 6109 | 2 | 0 |
136446 | 136446 | 2020-05-12 | Ventura | California | 6111 | 698 | 19 |
136447 | 136447 | 2020-05-12 | Yolo | California | 6113 | 177 | 22 |
136448 | 136448 | 2020-05-12 | Yuba | California | 6115 | 23 | 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);