ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,693 rows where state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Orange 464
- Los Angeles 463
- Santa Clara 458
- San Francisco 456
- San Diego 448
- Humboldt 438
- Sacramento 437
- Solano 434
- Marin 432
- Napa 432
- Sonoma 432
- Alameda 428
- Placer 427
- San Mateo 427
- Contra Costa 426
- Yolo 423
- Fresno 422
- Madera 422
- Riverside 422
- Santa Cruz 422
- Shasta 420
- San Joaquin 419
- Ventura 419
- Stanislaus 418
- Tulare 417
- San Benito 416
- San Luis Obispo 415
- San Bernardino 414
- Santa Barbara 414
- Nevada 413
- …
state 1
- California · 23,877 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277730 | 1277730 | 2021-05-02 | Alameda | California | 6001 | 86725 | 1519 |
1277731 | 1277731 | 2021-05-02 | Alpine | California | 6003 | 88 | 0 |
1277732 | 1277732 | 2021-05-02 | Amador | California | 6005 | 3649 | 47 |
1277733 | 1277733 | 2021-05-02 | Butte | California | 6007 | 11845 | 198 |
1277734 | 1277734 | 2021-05-02 | Calaveras | California | 6009 | 2096 | 52 |
1277735 | 1277735 | 2021-05-02 | Colusa | California | 6011 | 2216 | 16 |
1277736 | 1277736 | 2021-05-02 | Contra Costa | California | 6013 | 68115 | 800 |
1277737 | 1277737 | 2021-05-02 | Del Norte | California | 6015 | 1329 | 7 |
1277738 | 1277738 | 2021-05-02 | El Dorado | California | 6017 | 9944 | 110 |
1277739 | 1277739 | 2021-05-02 | Fresno | California | 6019 | 101326 | 1678 |
1277740 | 1277740 | 2021-05-02 | Glenn | California | 6021 | 2883 | 25 |
1277741 | 1277741 | 2021-05-02 | Humboldt | California | 6023 | 3852 | 38 |
1277742 | 1277742 | 2021-05-02 | Imperial | California | 6025 | 28262 | 720 |
1277743 | 1277743 | 2021-05-02 | Inyo | California | 6027 | 1421 | 38 |
1277744 | 1277744 | 2021-05-02 | Kern | California | 6029 | 108628 | 1354 |
1277745 | 1277745 | 2021-05-02 | Kings | California | 6031 | 22905 | 246 |
1277746 | 1277746 | 2021-05-02 | Lake | California | 6033 | 3441 | 43 |
1277747 | 1277747 | 2021-05-02 | Lassen | California | 6035 | 5692 | 24 |
1277748 | 1277748 | 2021-05-02 | Los Angeles | California | 6037 | 1234435 | 23946 |
1277749 | 1277749 | 2021-05-02 | Madera | California | 6039 | 16408 | 240 |
1277750 | 1277750 | 2021-05-02 | Marin | California | 6041 | 13902 | 228 |
1277751 | 1277751 | 2021-05-02 | Mariposa | California | 6043 | 441 | 7 |
1277752 | 1277752 | 2021-05-02 | Mendocino | California | 6045 | 4029 | 48 |
1277753 | 1277753 | 2021-05-02 | Merced | California | 6047 | 31594 | 454 |
1277754 | 1277754 | 2021-05-02 | Modoc | California | 6049 | 492 | 4 |
1277755 | 1277755 | 2021-05-02 | Mono | California | 6051 | 1276 | 4 |
1277756 | 1277756 | 2021-05-02 | Monterey | California | 6053 | 43461 | 381 |
1277757 | 1277757 | 2021-05-02 | Napa | California | 6055 | 9801 | 81 |
1277758 | 1277758 | 2021-05-02 | Nevada | California | 6057 | 4625 | 75 |
1277759 | 1277759 | 2021-05-02 | Orange | California | 6059 | 270284 | 4969 |
1277760 | 1277760 | 2021-05-02 | Placer | California | 6061 | 22240 | 289 |
1277761 | 1277761 | 2021-05-02 | Plumas | California | 6063 | 700 | 6 |
1277762 | 1277762 | 2021-05-02 | Riverside | California | 6065 | 298450 | 4574 |
1277763 | 1277763 | 2021-05-02 | Sacramento | California | 6067 | 103042 | 1663 |
1277764 | 1277764 | 2021-05-02 | San Benito | California | 6069 | 6030 | 63 |
1277765 | 1277765 | 2021-05-02 | San Bernardino | California | 6071 | 296089 | 4652 |
1277766 | 1277766 | 2021-05-02 | San Diego | California | 6073 | 276430 | 3706 |
1277767 | 1277767 | 2021-05-02 | San Francisco | California | 6075 | 36499 | 541 |
1277768 | 1277768 | 2021-05-02 | San Joaquin | California | 6077 | 72478 | 1346 |
1277769 | 1277769 | 2021-05-02 | San Luis Obispo | California | 6079 | 21193 | 260 |
1277770 | 1277770 | 2021-05-02 | San Mateo | California | 6081 | 41617 | 564 |
1277771 | 1277771 | 2021-05-02 | Santa Barbara | California | 6083 | 34180 | 453 |
1277772 | 1277772 | 2021-05-02 | Santa Clara | California | 6085 | 118424 | 2069 |
1277773 | 1277773 | 2021-05-02 | Santa Cruz | California | 6087 | 15999 | 207 |
1277774 | 1277774 | 2021-05-02 | Shasta | California | 6089 | 11901 | 220 |
1277775 | 1277775 | 2021-05-02 | Sierra | California | 6091 | 53 | 0 |
1277776 | 1277776 | 2021-05-02 | Siskiyou | California | 6093 | 2071 | 21 |
1277777 | 1277777 | 2021-05-02 | Solano | California | 6095 | 32482 | 249 |
1277778 | 1277778 | 2021-05-02 | Sonoma | California | 6097 | 29876 | 318 |
1277779 | 1277779 | 2021-05-02 | Stanislaus | California | 6099 | 61430 | 1044 |
1277780 | 1277780 | 2021-05-02 | Sutter | California | 6101 | 9358 | 110 |
1277781 | 1277781 | 2021-05-02 | Tehama | California | 6103 | 4950 | 53 |
1277782 | 1277782 | 2021-05-02 | Trinity | California | 6105 | 327 | 3 |
1277783 | 1277783 | 2021-05-02 | Tulare | California | 6107 | 49477 | 835 |
1277784 | 1277784 | 2021-05-02 | Tuolumne | California | 6109 | 4105 | 65 |
1277785 | 1277785 | 2021-05-02 | Ventura | California | 6111 | 80617 | 1009 |
1277786 | 1277786 | 2021-05-02 | Yolo | California | 6113 | 13784 | 208 |
1277787 | 1277787 | 2021-05-02 | Yuba | California | 6115 | 6172 | 44 |
1274483 | 1274483 | 2021-05-01 | Alameda | California | 6001 | 86623 | 1508 |
1274484 | 1274484 | 2021-05-01 | Alpine | California | 6003 | 88 | 0 |
1274485 | 1274485 | 2021-05-01 | Amador | California | 6005 | 3649 | 47 |
1274486 | 1274486 | 2021-05-01 | Butte | California | 6007 | 11812 | 197 |
1274487 | 1274487 | 2021-05-01 | Calaveras | California | 6009 | 2087 | 52 |
1274488 | 1274488 | 2021-05-01 | Colusa | California | 6011 | 2216 | 16 |
1274489 | 1274489 | 2021-05-01 | Contra Costa | California | 6013 | 68051 | 800 |
1274490 | 1274490 | 2021-05-01 | Del Norte | California | 6015 | 1329 | 7 |
1274491 | 1274491 | 2021-05-01 | El Dorado | California | 6017 | 9929 | 110 |
1274492 | 1274492 | 2021-05-01 | Fresno | California | 6019 | 101263 | 1670 |
1274493 | 1274493 | 2021-05-01 | Glenn | California | 6021 | 2883 | 25 |
1274494 | 1274494 | 2021-05-01 | Humboldt | California | 6023 | 3852 | 38 |
1274495 | 1274495 | 2021-05-01 | Imperial | California | 6025 | 28244 | 720 |
1274496 | 1274496 | 2021-05-01 | Inyo | California | 6027 | 1421 | 38 |
1274497 | 1274497 | 2021-05-01 | Kern | California | 6029 | 108598 | 1354 |
1274498 | 1274498 | 2021-05-01 | Kings | California | 6031 | 22886 | 246 |
1274499 | 1274499 | 2021-05-01 | Lake | California | 6033 | 3440 | 43 |
1274500 | 1274500 | 2021-05-01 | Lassen | California | 6035 | 5692 | 24 |
1274501 | 1274501 | 2021-05-01 | Los Angeles | California | 6037 | 1234151 | 23919 |
1274502 | 1274502 | 2021-05-01 | Madera | California | 6039 | 16395 | 240 |
1274503 | 1274503 | 2021-05-01 | Marin | California | 6041 | 13895 | 228 |
1274504 | 1274504 | 2021-05-01 | Mariposa | California | 6043 | 441 | 7 |
1274505 | 1274505 | 2021-05-01 | Mendocino | California | 6045 | 4029 | 48 |
1274506 | 1274506 | 2021-05-01 | Merced | California | 6047 | 31594 | 454 |
1274507 | 1274507 | 2021-05-01 | Modoc | California | 6049 | 492 | 4 |
1274508 | 1274508 | 2021-05-01 | Mono | California | 6051 | 1276 | 4 |
1274509 | 1274509 | 2021-05-01 | Monterey | California | 6053 | 43461 | 381 |
1274510 | 1274510 | 2021-05-01 | Napa | California | 6055 | 9793 | 81 |
1274511 | 1274511 | 2021-05-01 | Nevada | California | 6057 | 4608 | 75 |
1274512 | 1274512 | 2021-05-01 | Orange | California | 6059 | 270194 | 4965 |
1274513 | 1274513 | 2021-05-01 | Placer | California | 6061 | 22222 | 289 |
1274514 | 1274514 | 2021-05-01 | Plumas | California | 6063 | 700 | 6 |
1274515 | 1274515 | 2021-05-01 | Riverside | California | 6065 | 298450 | 4574 |
1274516 | 1274516 | 2021-05-01 | Sacramento | California | 6067 | 102958 | 1663 |
1274517 | 1274517 | 2021-05-01 | San Benito | California | 6069 | 6024 | 63 |
1274518 | 1274518 | 2021-05-01 | San Bernardino | California | 6071 | 296009 | 4640 |
1274519 | 1274519 | 2021-05-01 | San Diego | California | 6073 | 276220 | 3702 |
1274520 | 1274520 | 2021-05-01 | San Francisco | California | 6075 | 36456 | 538 |
1274521 | 1274521 | 2021-05-01 | San Joaquin | California | 6077 | 72478 | 1346 |
1274522 | 1274522 | 2021-05-01 | San Luis Obispo | California | 6079 | 21193 | 260 |
1274523 | 1274523 | 2021-05-01 | San Mateo | California | 6081 | 41583 | 564 |
1274524 | 1274524 | 2021-05-01 | Santa Barbara | California | 6083 | 34180 | 451 |
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);