ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-08-24" 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 |
---|---|---|---|---|---|---|---|
463469 | 463469 | 2020-08-24 | Alameda | California | 6001 | 16807 | 234 |
463470 | 463470 | 2020-08-24 | Alpine | California | 6003 | 2 | 0 |
463471 | 463471 | 2020-08-24 | Amador | California | 6005 | 226 | 14 |
463472 | 463472 | 2020-08-24 | Butte | California | 6007 | 1664 | 18 |
463473 | 463473 | 2020-08-24 | Calaveras | California | 6009 | 197 | 2 |
463474 | 463474 | 2020-08-24 | Colusa | California | 6011 | 426 | 5 |
463475 | 463475 | 2020-08-24 | Contra Costa | California | 6013 | 12663 | 169 |
463476 | 463476 | 2020-08-24 | Del Norte | California | 6015 | 116 | 1 |
463477 | 463477 | 2020-08-24 | El Dorado | California | 6017 | 924 | 2 |
463478 | 463478 | 2020-08-24 | Fresno | California | 6019 | 23414 | 226 |
463479 | 463479 | 2020-08-24 | Glenn | California | 6021 | 421 | 3 |
463480 | 463480 | 2020-08-24 | Humboldt | California | 6023 | 359 | 4 |
463481 | 463481 | 2020-08-24 | Imperial | California | 6025 | 10396 | 271 |
463482 | 463482 | 2020-08-24 | Inyo | California | 6027 | 144 | 11 |
463483 | 463483 | 2020-08-24 | Kern | California | 6029 | 28234 | 240 |
463484 | 463484 | 2020-08-24 | Kings | California | 6031 | 5957 | 69 |
463485 | 463485 | 2020-08-24 | Lake | California | 6033 | 299 | 3 |
463486 | 463486 | 2020-08-24 | Lassen | California | 6035 | 704 | 0 |
463487 | 463487 | 2020-08-24 | Los Angeles | California | 6037 | 232893 | 5558 |
463488 | 463488 | 2020-08-24 | Madera | California | 6039 | 3484 | 50 |
463489 | 463489 | 2020-08-24 | Marin | California | 6041 | 5942 | 85 |
463490 | 463490 | 2020-08-24 | Mariposa | California | 6043 | 70 | 2 |
463491 | 463491 | 2020-08-24 | Mendocino | California | 6045 | 645 | 16 |
463492 | 463492 | 2020-08-24 | Merced | California | 6047 | 7653 | 106 |
463493 | 463493 | 2020-08-24 | Modoc | California | 6049 | 5 | 0 |
463494 | 463494 | 2020-08-24 | Mono | California | 6051 | 161 | 2 |
463495 | 463495 | 2020-08-24 | Monterey | California | 6053 | 7274 | 52 |
463496 | 463496 | 2020-08-24 | Napa | California | 6055 | 1349 | 13 |
463497 | 463497 | 2020-08-24 | Nevada | California | 6057 | 423 | 3 |
463498 | 463498 | 2020-08-24 | Orange | California | 6059 | 46307 | 897 |
463499 | 463499 | 2020-08-24 | Placer | California | 6061 | 2795 | 31 |
463500 | 463500 | 2020-08-24 | Plumas | California | 6063 | 37 | 0 |
463501 | 463501 | 2020-08-24 | Riverside | California | 6065 | 50744 | 972 |
463502 | 463502 | 2020-08-24 | Sacramento | California | 6067 | 16330 | 246 |
463503 | 463503 | 2020-08-24 | San Benito | California | 6069 | 978 | 7 |
463504 | 463504 | 2020-08-24 | San Bernardino | California | 6071 | 45246 | 692 |
463505 | 463505 | 2020-08-24 | San Diego | California | 6073 | 36790 | 660 |
463506 | 463506 | 2020-08-24 | San Francisco | California | 6075 | 8939 | 77 |
463507 | 463507 | 2020-08-24 | San Joaquin | California | 6077 | 16131 | 297 |
463508 | 463508 | 2020-08-24 | San Luis Obispo | California | 6079 | 2735 | 21 |
463509 | 463509 | 2020-08-24 | San Mateo | California | 6081 | 7670 | 128 |
463510 | 463510 | 2020-08-24 | Santa Barbara | California | 6083 | 7800 | 88 |
463511 | 463511 | 2020-08-24 | Santa Clara | California | 6085 | 16151 | 225 |
463512 | 463512 | 2020-08-24 | Santa Cruz | California | 6087 | 1636 | 7 |
463513 | 463513 | 2020-08-24 | Shasta | California | 6089 | 531 | 11 |
463514 | 463514 | 2020-08-24 | Sierra | California | 6091 | 6 | 0 |
463515 | 463515 | 2020-08-24 | Siskiyou | California | 6093 | 124 | 0 |
463516 | 463516 | 2020-08-24 | Solano | California | 6095 | 5211 | 46 |
463517 | 463517 | 2020-08-24 | Sonoma | California | 6097 | 5212 | 73 |
463518 | 463518 | 2020-08-24 | Stanislaus | California | 6099 | 13483 | 232 |
463519 | 463519 | 2020-08-24 | Sutter | California | 6101 | 1283 | 8 |
463520 | 463520 | 2020-08-24 | Tehama | California | 6103 | 381 | 1 |
463521 | 463521 | 2020-08-24 | Trinity | California | 6105 | 11 | 0 |
463522 | 463522 | 2020-08-24 | Tulare | California | 6107 | 13431 | 216 |
463523 | 463523 | 2020-08-24 | Tuolumne | California | 6109 | 177 | 2 |
463524 | 463524 | 2020-08-24 | Ventura | California | 6111 | 10126 | 103 |
463525 | 463525 | 2020-08-24 | Yolo | California | 6113 | 2239 | 47 |
463526 | 463526 | 2020-08-24 | Yuba | California | 6115 | 880 | 4 |
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);