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 395
- Los Angeles 394
- Santa Clara 389
- San Francisco 387
- San Diego 379
- Humboldt 369
- Sacramento 368
- Solano 365
- Marin 363
- Napa 363
- Sonoma 363
- Alameda 359
- Placer 358
- San Mateo 358
- Contra Costa 357
- Yolo 354
- Fresno 353
- Madera 353
- Riverside 353
- Santa Cruz 353
- Shasta 351
- San Joaquin 350
- Ventura 350
- Stanislaus 349
- Tulare 348
- San Benito 347
- San Luis Obispo 346
- San Bernardino 345
- Santa Barbara 345
- Nevada 344
- …
state 1
- California · 19,875 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053692 | 1053692 | 2021-02-22 | Alameda | California | 6001 | 79670 | 1200 |
1053693 | 1053693 | 2021-02-22 | Alpine | California | 6003 | 77 | 0 |
1053694 | 1053694 | 2021-02-22 | Amador | California | 6005 | 3434 | 39 |
1053695 | 1053695 | 2021-02-22 | Butte | California | 6007 | 10855 | 158 |
1053696 | 1053696 | 2021-02-22 | Calaveras | California | 6009 | 1860 | 25 |
1053697 | 1053697 | 2021-02-22 | Colusa | California | 6011 | 2120 | 13 |
1053698 | 1053698 | 2021-02-22 | Contra Costa | California | 6013 | 61744 | 654 |
1053699 | 1053699 | 2021-02-22 | Del Norte | California | 6015 | 971 | 5 |
1053700 | 1053700 | 2021-02-22 | El Dorado | California | 6017 | 8927 | 93 |
1053701 | 1053701 | 2021-02-22 | Fresno | California | 6019 | 94374 | 1367 |
1053702 | 1053702 | 2021-02-22 | Glenn | California | 6021 | 2671 | 23 |
1053703 | 1053703 | 2021-02-22 | Humboldt | California | 6023 | 3124 | 32 |
1053704 | 1053704 | 2021-02-22 | Imperial | California | 6025 | 26840 | 583 |
1053705 | 1053705 | 2021-02-22 | Inyo | California | 6027 | 1232 | 34 |
1053706 | 1053706 | 2021-02-22 | Kern | California | 6029 | 101849 | 783 |
1053707 | 1053707 | 2021-02-22 | Kings | California | 6031 | 21881 | 216 |
1053708 | 1053708 | 2021-02-22 | Lake | California | 6033 | 3100 | 40 |
1053709 | 1053709 | 2021-02-22 | Lassen | California | 6035 | 5591 | 19 |
1053710 | 1053710 | 2021-02-22 | Los Angeles | California | 6037 | 1181994 | 19904 |
1053711 | 1053711 | 2021-02-22 | Madera | California | 6039 | 15298 | 201 |
1053712 | 1053712 | 2021-02-22 | Marin | California | 6041 | 12968 | 195 |
1053713 | 1053713 | 2021-02-22 | Mariposa | California | 6043 | 393 | 7 |
1053714 | 1053714 | 2021-02-22 | Mendocino | California | 6045 | 3786 | 43 |
1053715 | 1053715 | 2021-02-22 | Merced | California | 6047 | 28655 | 391 |
1053716 | 1053716 | 2021-02-22 | Modoc | California | 6049 | 446 | 4 |
1053717 | 1053717 | 2021-02-22 | Mono | California | 6051 | 1189 | 4 |
1053718 | 1053718 | 2021-02-22 | Monterey | California | 6053 | 41884 | 315 |
1053719 | 1053719 | 2021-02-22 | Napa | California | 6055 | 8930 | 67 |
1053720 | 1053720 | 2021-02-22 | Nevada | California | 6057 | 3899 | 74 |
1053721 | 1053721 | 2021-02-22 | Orange | California | 6059 | 259581 | 3848 |
1053722 | 1053722 | 2021-02-22 | Placer | California | 6061 | 19646 | 230 |
1053723 | 1053723 | 2021-02-22 | Plumas | California | 6063 | 625 | 6 |
1053724 | 1053724 | 2021-02-22 | Riverside | California | 6065 | 287822 | 3664 |
1053725 | 1053725 | 2021-02-22 | Sacramento | California | 6067 | 92427 | 1438 |
1053726 | 1053726 | 2021-02-22 | San Benito | California | 6069 | 5716 | 57 |
1053727 | 1053727 | 2021-02-22 | San Bernardino | California | 6071 | 284866 | 2637 |
1053728 | 1053728 | 2021-02-22 | San Diego | California | 6073 | 257414 | 3190 |
1053729 | 1053729 | 2021-02-22 | San Francisco | California | 6075 | 33894 | 394 |
1053730 | 1053730 | 2021-02-22 | San Joaquin | California | 6077 | 66046 | 1039 |
1053731 | 1053731 | 2021-02-22 | San Luis Obispo | California | 6079 | 19458 | 220 |
1053732 | 1053732 | 2021-02-22 | San Mateo | California | 6081 | 38448 | 497 |
1053733 | 1053733 | 2021-02-22 | Santa Barbara | California | 6083 | 31567 | 396 |
1053734 | 1053734 | 2021-02-22 | Santa Clara | California | 6085 | 109276 | 1737 |
1053735 | 1053735 | 2021-02-22 | Santa Cruz | California | 6087 | 14495 | 172 |
1053736 | 1053736 | 2021-02-22 | Shasta | California | 6089 | 10868 | 172 |
1053737 | 1053737 | 2021-02-22 | Sierra | California | 6091 | 47 | 0 |
1053738 | 1053738 | 2021-02-22 | Siskiyou | California | 6093 | 1716 | 13 |
1053739 | 1053739 | 2021-02-22 | Solano | California | 6095 | 29864 | 161 |
1053740 | 1053740 | 2021-02-22 | Sonoma | California | 6097 | 27793 | 295 |
1053741 | 1053741 | 2021-02-22 | Stanislaus | California | 6099 | 55347 | 931 |
1053742 | 1053742 | 2021-02-22 | Sutter | California | 6101 | 8802 | 96 |
1053743 | 1053743 | 2021-02-22 | Tehama | California | 6103 | 4547 | 52 |
1053744 | 1053744 | 2021-02-22 | Trinity | California | 6105 | 287 | 5 |
1053745 | 1053745 | 2021-02-22 | Tulare | California | 6107 | 47562 | 722 |
1053746 | 1053746 | 2021-02-22 | Tuolumne | California | 6109 | 3914 | 59 |
1053747 | 1053747 | 2021-02-22 | Ventura | California | 6111 | 76862 | 794 |
1053748 | 1053748 | 2021-02-22 | Yolo | California | 6113 | 12670 | 181 |
1053749 | 1053749 | 2021-02-22 | Yuba | California | 6115 | 5711 | 36 |
1050445 | 1050445 | 2021-02-21 | Alameda | California | 6001 | 79560 | 1200 |
1050446 | 1050446 | 2021-02-21 | Alpine | California | 6003 | 77 | 0 |
1050447 | 1050447 | 2021-02-21 | Amador | California | 6005 | 3431 | 39 |
1050448 | 1050448 | 2021-02-21 | Butte | California | 6007 | 10838 | 156 |
1050449 | 1050449 | 2021-02-21 | Calaveras | California | 6009 | 1858 | 25 |
1050450 | 1050450 | 2021-02-21 | Colusa | California | 6011 | 2117 | 13 |
1050451 | 1050451 | 2021-02-21 | Contra Costa | California | 6013 | 61628 | 654 |
1050452 | 1050452 | 2021-02-21 | Del Norte | California | 6015 | 959 | 5 |
1050453 | 1050453 | 2021-02-21 | El Dorado | California | 6017 | 8911 | 93 |
1050454 | 1050454 | 2021-02-21 | Fresno | California | 6019 | 94234 | 1367 |
1050455 | 1050455 | 2021-02-21 | Glenn | California | 6021 | 2664 | 23 |
1050456 | 1050456 | 2021-02-21 | Humboldt | California | 6023 | 3073 | 32 |
1050457 | 1050457 | 2021-02-21 | Imperial | California | 6025 | 26840 | 583 |
1050458 | 1050458 | 2021-02-21 | Inyo | California | 6027 | 1226 | 34 |
1050459 | 1050459 | 2021-02-21 | Kern | California | 6029 | 101738 | 773 |
1050460 | 1050460 | 2021-02-21 | Kings | California | 6031 | 21857 | 215 |
1050461 | 1050461 | 2021-02-21 | Lake | California | 6033 | 3089 | 40 |
1050462 | 1050462 | 2021-02-21 | Lassen | California | 6035 | 5558 | 19 |
1050463 | 1050463 | 2021-02-21 | Los Angeles | California | 6037 | 1181060 | 19885 |
1050464 | 1050464 | 2021-02-21 | Madera | California | 6039 | 15274 | 201 |
1050465 | 1050465 | 2021-02-21 | Marin | California | 6041 | 12945 | 194 |
1050466 | 1050466 | 2021-02-21 | Mariposa | California | 6043 | 392 | 7 |
1050467 | 1050467 | 2021-02-21 | Mendocino | California | 6045 | 3783 | 43 |
1050468 | 1050468 | 2021-02-21 | Merced | California | 6047 | 28489 | 388 |
1050469 | 1050469 | 2021-02-21 | Modoc | California | 6049 | 446 | 4 |
1050470 | 1050470 | 2021-02-21 | Mono | California | 6051 | 1187 | 4 |
1050471 | 1050471 | 2021-02-21 | Monterey | California | 6053 | 41884 | 315 |
1050472 | 1050472 | 2021-02-21 | Napa | California | 6055 | 8911 | 67 |
1050473 | 1050473 | 2021-02-21 | Nevada | California | 6057 | 3887 | 74 |
1050474 | 1050474 | 2021-02-21 | Orange | California | 6059 | 259305 | 3810 |
1050475 | 1050475 | 2021-02-21 | Placer | California | 6061 | 19520 | 229 |
1050476 | 1050476 | 2021-02-21 | Plumas | California | 6063 | 626 | 6 |
1050477 | 1050477 | 2021-02-21 | Riverside | California | 6065 | 287534 | 3633 |
1050478 | 1050478 | 2021-02-21 | Sacramento | California | 6067 | 92056 | 1431 |
1050479 | 1050479 | 2021-02-21 | San Benito | California | 6069 | 5709 | 57 |
1050480 | 1050480 | 2021-02-21 | San Bernardino | California | 6071 | 284639 | 2612 |
1050481 | 1050481 | 2021-02-21 | San Diego | California | 6073 | 257093 | 3190 |
1050482 | 1050482 | 2021-02-21 | San Francisco | California | 6075 | 33823 | 394 |
1050483 | 1050483 | 2021-02-21 | San Joaquin | California | 6077 | 65891 | 1026 |
1050484 | 1050484 | 2021-02-21 | San Luis Obispo | California | 6079 | 19340 | 217 |
1050485 | 1050485 | 2021-02-21 | San Mateo | California | 6081 | 38371 | 497 |
1050486 | 1050486 | 2021-02-21 | Santa Barbara | California | 6083 | 31518 | 394 |
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);