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 435
- Los Angeles 433
- Santa Clara 429
- San Francisco 427
- San Diego 419
- Humboldt 408
- Sacramento 408
- Solano 405
- Napa 403
- Sonoma 403
- Marin 402
- Alameda 398
- Placer 398
- San Mateo 398
- Contra Costa 396
- Yolo 394
- Riverside 393
- Santa Cruz 393
- Fresno 392
- Madera 392
- Shasta 391
- San Joaquin 390
- Ventura 390
- Stanislaus 389
- Tulare 388
- San Benito 387
- San Luis Obispo 386
- San Bernardino 385
- Santa Barbara 385
- Nevada 384
- …
state 1
- California · 22,169 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1183577 | 1183577 | 2021-04-03 | Monterey | California | 6053 | 43002 | 342 |
1183578 | 1183578 | 2021-04-03 | Napa | California | 6055 | 9454 | 78 |
1183579 | 1183579 | 2021-04-03 | Nevada | California | 6057 | 4323 | 74 |
1183580 | 1183580 | 2021-04-03 | Orange | California | 6059 | 266766 | 4768 |
1183581 | 1183581 | 2021-04-03 | Placer | California | 6061 | 21095 | 276 |
1183582 | 1183582 | 2021-04-03 | Plumas | California | 6063 | 666 | 4 |
1183583 | 1183583 | 2021-04-03 | Riverside | California | 6065 | 294736 | 4362 |
1183584 | 1183584 | 2021-04-03 | Sacramento | California | 6067 | 98647 | 1613 |
1183585 | 1183585 | 2021-04-03 | San Benito | California | 6069 | 5888 | 61 |
1183586 | 1183586 | 2021-04-03 | San Bernardino | California | 6071 | 291360 | 4417 |
1183587 | 1183587 | 2021-04-03 | San Diego | California | 6073 | 271397 | 3571 |
1183588 | 1183588 | 2021-04-03 | San Francisco | California | 6075 | 35454 | 488 |
1183589 | 1183589 | 2021-04-03 | San Joaquin | California | 6077 | 70117 | 1310 |
1183590 | 1183590 | 2021-04-03 | San Luis Obispo | California | 6079 | 20547 | 256 |
1183591 | 1183591 | 2021-04-03 | San Mateo | California | 6081 | 40542 | 553 |
1183592 | 1183592 | 2021-04-03 | Santa Barbara | California | 6083 | 33297 | 443 |
1183593 | 1183593 | 2021-04-03 | Santa Clara | California | 6085 | 114947 | 1950 |
1183594 | 1183594 | 2021-04-03 | Santa Cruz | California | 6087 | 15363 | 202 |
1183595 | 1183595 | 2021-04-03 | Shasta | California | 6089 | 11381 | 207 |
1183596 | 1183596 | 2021-04-03 | Sierra | California | 6091 | 50 | 0 |
1183597 | 1183597 | 2021-04-03 | Siskiyou | California | 6093 | 1885 | 16 |
1183598 | 1183598 | 2021-04-03 | Solano | California | 6095 | 31306 | 237 |
1183599 | 1183599 | 2021-04-03 | Sonoma | California | 6097 | 29349 | 311 |
1183600 | 1183600 | 2021-04-03 | Stanislaus | California | 6099 | 59342 | 1003 |
1183601 | 1183601 | 2021-04-03 | Sutter | California | 6101 | 9175 | 106 |
1183602 | 1183602 | 2021-04-03 | Tehama | California | 6103 | 4775 | 52 |
1183603 | 1183603 | 2021-04-03 | Trinity | California | 6105 | 321 | 3 |
1183604 | 1183604 | 2021-04-03 | Tulare | California | 6107 | 49100 | 818 |
1183605 | 1183605 | 2021-04-03 | Tuolumne | California | 6109 | 4043 | 62 |
1183606 | 1183606 | 2021-04-03 | Ventura | California | 6111 | 79774 | 986 |
1183607 | 1183607 | 2021-04-03 | Yolo | California | 6113 | 13381 | 198 |
1183608 | 1183608 | 2021-04-03 | Yuba | California | 6115 | 6021 | 44 |
1180304 | 1180304 | 2021-04-02 | Alameda | California | 6001 | 83595 | 1425 |
1180305 | 1180305 | 2021-04-02 | Alpine | California | 6003 | 88 | 0 |
1180306 | 1180306 | 2021-04-02 | Amador | California | 6005 | 3557 | 45 |
1180307 | 1180307 | 2021-04-02 | Butte | California | 6007 | 11328 | 193 |
1180308 | 1180308 | 2021-04-02 | Calaveras | California | 6009 | 2006 | 51 |
1180309 | 1180309 | 2021-04-02 | Colusa | California | 6011 | 2165 | 16 |
1180310 | 1180310 | 2021-04-02 | Contra Costa | California | 6013 | 65559 | 771 |
1180311 | 1180311 | 2021-04-02 | Del Norte | California | 6015 | 1213 | 6 |
1180312 | 1180312 | 2021-04-02 | El Dorado | California | 6017 | 9393 | 108 |
1180313 | 1180313 | 2021-04-02 | Fresno | California | 6019 | 99317 | 1616 |
1180314 | 1180314 | 2021-04-02 | Glenn | California | 6021 | 2832 | 25 |
1180315 | 1180315 | 2021-04-02 | Humboldt | California | 6023 | 3492 | 36 |
1180316 | 1180316 | 2021-04-02 | Imperial | California | 6025 | 27520 | 711 |
1180317 | 1180317 | 2021-04-02 | Inyo | California | 6027 | 1374 | 36 |
1180318 | 1180318 | 2021-04-02 | Kern | California | 6029 | 106329 | 1277 |
1180319 | 1180319 | 2021-04-02 | Kings | California | 6031 | 22659 | 241 |
1180320 | 1180320 | 2021-04-02 | Lake | California | 6033 | 3337 | 43 |
1180321 | 1180321 | 2021-04-02 | Lassen | California | 6035 | 5652 | 24 |
1180322 | 1180322 | 2021-04-02 | Los Angeles | California | 6037 | 1221506 | 23235 |
1180323 | 1180323 | 2021-04-02 | Madera | California | 6039 | 16023 | 234 |
1180324 | 1180324 | 2021-04-02 | Marin | California | 6041 | 13635 | 221 |
1180325 | 1180325 | 2021-04-02 | Mariposa | California | 6043 | 410 | 7 |
1180326 | 1180326 | 2021-04-02 | Mendocino | California | 6045 | 3949 | 46 |
1180327 | 1180327 | 2021-04-02 | Merced | California | 6047 | 30687 | 439 |
1180328 | 1180328 | 2021-04-02 | Modoc | California | 6049 | 474 | 4 |
1180329 | 1180329 | 2021-04-02 | Mono | California | 6051 | 1245 | 4 |
1180330 | 1180330 | 2021-04-02 | Monterey | California | 6053 | 42979 | 342 |
1180331 | 1180331 | 2021-04-02 | Napa | California | 6055 | 9454 | 78 |
1180332 | 1180332 | 2021-04-02 | Nevada | California | 6057 | 4316 | 74 |
1180333 | 1180333 | 2021-04-02 | Orange | California | 6059 | 266464 | 4761 |
1180334 | 1180334 | 2021-04-02 | Placer | California | 6061 | 21095 | 276 |
1180335 | 1180335 | 2021-04-02 | Plumas | California | 6063 | 664 | 4 |
1180336 | 1180336 | 2021-04-02 | Riverside | California | 6065 | 294736 | 4362 |
1180337 | 1180337 | 2021-04-02 | Sacramento | California | 6067 | 98487 | 1613 |
1180338 | 1180338 | 2021-04-02 | San Benito | California | 6069 | 5878 | 61 |
1180339 | 1180339 | 2021-04-02 | San Bernardino | California | 6071 | 291199 | 4404 |
1180340 | 1180340 | 2021-04-02 | San Diego | California | 6073 | 271098 | 3568 |
1180341 | 1180341 | 2021-04-02 | San Francisco | California | 6075 | 35389 | 488 |
1180342 | 1180342 | 2021-04-02 | San Joaquin | California | 6077 | 70117 | 1310 |
1180343 | 1180343 | 2021-04-02 | San Luis Obispo | California | 6079 | 20547 | 256 |
1180344 | 1180344 | 2021-04-02 | San Mateo | California | 6081 | 40462 | 553 |
1180345 | 1180345 | 2021-04-02 | Santa Barbara | California | 6083 | 33270 | 443 |
1180346 | 1180346 | 2021-04-02 | Santa Clara | California | 6085 | 114852 | 1950 |
1180347 | 1180347 | 2021-04-02 | Santa Cruz | California | 6087 | 15363 | 202 |
1180348 | 1180348 | 2021-04-02 | Shasta | California | 6089 | 11381 | 207 |
1180349 | 1180349 | 2021-04-02 | Sierra | California | 6091 | 50 | 0 |
1180350 | 1180350 | 2021-04-02 | Siskiyou | California | 6093 | 1885 | 16 |
1180351 | 1180351 | 2021-04-02 | Solano | California | 6095 | 31306 | 237 |
1180352 | 1180352 | 2021-04-02 | Sonoma | California | 6097 | 29310 | 311 |
1180353 | 1180353 | 2021-04-02 | Stanislaus | California | 6099 | 59271 | 1003 |
1180354 | 1180354 | 2021-04-02 | Sutter | California | 6101 | 9175 | 106 |
1180355 | 1180355 | 2021-04-02 | Tehama | California | 6103 | 4764 | 52 |
1180356 | 1180356 | 2021-04-02 | Trinity | California | 6105 | 320 | 3 |
1180357 | 1180357 | 2021-04-02 | Tulare | California | 6107 | 49100 | 817 |
1180358 | 1180358 | 2021-04-02 | Tuolumne | California | 6109 | 4043 | 62 |
1180359 | 1180359 | 2021-04-02 | Ventura | California | 6111 | 79774 | 986 |
1180360 | 1180360 | 2021-04-02 | Yolo | California | 6113 | 13342 | 198 |
1180361 | 1180361 | 2021-04-02 | Yuba | California | 6115 | 6021 | 44 |
1177057 | 1177057 | 2021-04-01 | Alameda | California | 6001 | 83496 | 1423 |
1177058 | 1177058 | 2021-04-01 | Alpine | California | 6003 | 88 | 0 |
1177059 | 1177059 | 2021-04-01 | Amador | California | 6005 | 3555 | 45 |
1177060 | 1177060 | 2021-04-01 | Butte | California | 6007 | 11321 | 193 |
1177061 | 1177061 | 2021-04-01 | Calaveras | California | 6009 | 2005 | 51 |
1177062 | 1177062 | 2021-04-01 | Colusa | California | 6011 | 2165 | 16 |
1177063 | 1177063 | 2021-04-01 | Contra Costa | California | 6013 | 65435 | 769 |
1177064 | 1177064 | 2021-04-01 | Del Norte | California | 6015 | 1197 | 6 |
1177065 | 1177065 | 2021-04-01 | El Dorado | California | 6017 | 9390 | 107 |
1177066 | 1177066 | 2021-04-01 | Fresno | California | 6019 | 99240 | 1616 |
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);