ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2020-12-26 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
865454 | 865454 | 2020-12-26 | Alameda | California | 6001 | 48386 | 625 |
865455 | 865455 | 2020-12-26 | Alpine | California | 6003 | 64 | 0 |
865456 | 865456 | 2020-12-26 | Amador | California | 6005 | 2171 | 23 |
865457 | 865457 | 2020-12-26 | Butte | California | 6007 | 6873 | 83 |
865458 | 865458 | 2020-12-26 | Calaveras | California | 6009 | 1062 | 22 |
865459 | 865459 | 2020-12-26 | Colusa | California | 6011 | 1219 | 8 |
865460 | 865460 | 2020-12-26 | Contra Costa | California | 6013 | 38138 | 321 |
865461 | 865461 | 2020-12-26 | Del Norte | California | 6015 | 695 | 2 |
865462 | 865462 | 2020-12-26 | El Dorado | California | 6017 | 5170 | 13 |
865463 | 865463 | 2020-12-26 | Fresno | California | 6019 | 62251 | 646 |
865464 | 865464 | 2020-12-26 | Glenn | California | 6021 | 1390 | 14 |
865465 | 865465 | 2020-12-26 | Humboldt | California | 6023 | 1584 | 18 |
865466 | 865466 | 2020-12-26 | Imperial | California | 6025 | 21646 | 405 |
865467 | 865467 | 2020-12-26 | Inyo | California | 6027 | 546 | 20 |
865468 | 865468 | 2020-12-26 | Kern | California | 6029 | 63557 | 485 |
865469 | 865469 | 2020-12-26 | Kings | California | 6031 | 15548 | 110 |
865470 | 865470 | 2020-12-26 | Lake | California | 6033 | 1669 | 23 |
865471 | 865471 | 2020-12-26 | Lassen | California | 6035 | 4180 | 8 |
865472 | 865472 | 2020-12-26 | Los Angeles | California | 6037 | 706712 | 9438 |
865473 | 865473 | 2020-12-26 | Madera | California | 6039 | 9770 | 116 |
865474 | 865474 | 2020-12-26 | Marin | California | 6041 | 9505 | 136 |
865475 | 865475 | 2020-12-26 | Mariposa | California | 6043 | 219 | 4 |
865476 | 865476 | 2020-12-26 | Mendocino | California | 6045 | 2382 | 25 |
865477 | 865477 | 2020-12-26 | Merced | California | 6047 | 17785 | 232 |
865478 | 865478 | 2020-12-26 | Modoc | California | 6049 | 292 | 0 |
865479 | 865479 | 2020-12-26 | Mono | California | 6051 | 843 | 4 |
865480 | 865480 | 2020-12-26 | Monterey | California | 6053 | 25788 | 186 |
865481 | 865481 | 2020-12-26 | Napa | California | 6055 | 5352 | 27 |
865482 | 865482 | 2020-12-26 | Nevada | California | 6057 | 2458 | 44 |
865483 | 865483 | 2020-12-26 | Orange | California | 6059 | 149439 | 1845 |
865484 | 865484 | 2020-12-26 | Placer | California | 6061 | 12660 | 120 |
865485 | 865485 | 2020-12-26 | Plumas | California | 6063 | 381 | 1 |
865486 | 865486 | 2020-12-26 | Riverside | California | 6065 | 166690 | 1829 |
865487 | 865487 | 2020-12-26 | Sacramento | California | 6067 | 61629 | 809 |
865488 | 865488 | 2020-12-26 | San Benito | California | 6069 | 3365 | 26 |
865489 | 865489 | 2020-12-26 | San Bernardino | California | 6071 | 181812 | 1429 |
865490 | 865490 | 2020-12-26 | San Diego | California | 6073 | 142710 | 1402 |
865491 | 865491 | 2020-12-26 | San Francisco | California | 6075 | 22133 | 181 |
865492 | 865492 | 2020-12-26 | San Joaquin | California | 6077 | 42089 | 618 |
865493 | 865493 | 2020-12-26 | San Luis Obispo | California | 6079 | 9749 | 67 |
865494 | 865494 | 2020-12-26 | San Mateo | California | 6081 | 22568 | 212 |
865495 | 865495 | 2020-12-26 | Santa Barbara | California | 6083 | 16083 | 153 |
865496 | 865496 | 2020-12-26 | Santa Clara | California | 6085 | 63302 | 653 |
865497 | 865497 | 2020-12-26 | Santa Cruz | California | 6087 | 8018 | 76 |
865498 | 865498 | 2020-12-26 | Shasta | California | 6089 | 7612 | 70 |
865499 | 865499 | 2020-12-26 | Sierra | California | 6091 | 24 | 0 |
865500 | 865500 | 2020-12-26 | Siskiyou | California | 6093 | 1076 | 8 |
865501 | 865501 | 2020-12-26 | Solano | California | 6095 | 17335 | 95 |
865502 | 865502 | 2020-12-26 | Sonoma | California | 6097 | 18147 | 182 |
865503 | 865503 | 2020-12-26 | Stanislaus | California | 6099 | 35676 | 572 |
865504 | 865504 | 2020-12-26 | Sutter | California | 6101 | 6051 | 46 |
865505 | 865505 | 2020-12-26 | Tehama | California | 6103 | 2839 | 34 |
865506 | 865506 | 2020-12-26 | Trinity | California | 6105 | 237 | 2 |
865507 | 865507 | 2020-12-26 | Tulare | California | 6107 | 31323 | 373 |
865508 | 865508 | 2020-12-26 | Tuolumne | California | 6109 | 2704 | 21 |
865509 | 865509 | 2020-12-26 | Ventura | California | 6111 | 35514 | 233 |
865510 | 865510 | 2020-12-26 | Yolo | California | 6113 | 7700 | 109 |
865511 | 865511 | 2020-12-26 | Yuba | California | 6115 | 3628 | 17 |
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);