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 392
- Los Angeles 390
- Santa Clara 386
- San Francisco 384
- San Diego 376
- Humboldt 365
- Sacramento 365
- Solano 362
- Napa 360
- Sonoma 360
- Marin 359
- Alameda 355
- Placer 355
- San Mateo 355
- Contra Costa 353
- Yolo 351
- Riverside 350
- Santa Cruz 350
- Fresno 349
- Madera 349
- Shasta 348
- San Joaquin 347
- Ventura 347
- Stanislaus 346
- Tulare 345
- San Benito 344
- San Luis Obispo 343
- San Bernardino 342
- Santa Barbara 342
- Nevada 341
- …
state 1
- California · 19,675 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1043979 | 1043979 | 2021-02-19 | Monterey | California | 6053 | 41787 | 315 |
1043980 | 1043980 | 2021-02-19 | Napa | California | 6055 | 8878 | 67 |
1043981 | 1043981 | 2021-02-19 | Nevada | California | 6057 | 3852 | 74 |
1043982 | 1043982 | 2021-02-19 | Orange | California | 6059 | 258567 | 3726 |
1043983 | 1043983 | 2021-02-19 | Placer | California | 6061 | 19520 | 229 |
1043984 | 1043984 | 2021-02-19 | Plumas | California | 6063 | 624 | 6 |
1043985 | 1043985 | 2021-02-19 | Riverside | California | 6065 | 287534 | 3633 |
1043986 | 1043986 | 2021-02-19 | Sacramento | California | 6067 | 91796 | 1431 |
1043987 | 1043987 | 2021-02-19 | San Benito | California | 6069 | 5697 | 57 |
1043988 | 1043988 | 2021-02-19 | San Bernardino | California | 6071 | 283873 | 2522 |
1043989 | 1043989 | 2021-02-19 | San Diego | California | 6073 | 255865 | 3169 |
1043990 | 1043990 | 2021-02-19 | San Francisco | California | 6075 | 33653 | 387 |
1043991 | 1043991 | 2021-02-19 | San Joaquin | California | 6077 | 65891 | 1026 |
1043992 | 1043992 | 2021-02-19 | San Luis Obispo | California | 6079 | 19340 | 217 |
1043993 | 1043993 | 2021-02-19 | San Mateo | California | 6081 | 38229 | 481 |
1043994 | 1043994 | 2021-02-19 | Santa Barbara | California | 6083 | 31334 | 392 |
1043995 | 1043995 | 2021-02-19 | Santa Clara | California | 6085 | 108462 | 1726 |
1043996 | 1043996 | 2021-02-19 | Santa Cruz | California | 6087 | 14438 | 172 |
1043997 | 1043997 | 2021-02-19 | Shasta | California | 6089 | 10868 | 172 |
1043998 | 1043998 | 2021-02-19 | Sierra | California | 6091 | 47 | 0 |
1043999 | 1043999 | 2021-02-19 | Siskiyou | California | 6093 | 1701 | 13 |
1044000 | 1044000 | 2021-02-19 | Solano | California | 6095 | 29771 | 161 |
1044001 | 1044001 | 2021-02-19 | Sonoma | California | 6097 | 27542 | 291 |
1044002 | 1044002 | 2021-02-19 | Stanislaus | California | 6099 | 54887 | 921 |
1044003 | 1044003 | 2021-02-19 | Sutter | California | 6101 | 8766 | 94 |
1044004 | 1044004 | 2021-02-19 | Tehama | California | 6103 | 4528 | 51 |
1044005 | 1044005 | 2021-02-19 | Trinity | California | 6105 | 283 | 5 |
1044006 | 1044006 | 2021-02-19 | Tulare | California | 6107 | 47399 | 720 |
1044007 | 1044007 | 2021-02-19 | Tuolumne | California | 6109 | 3870 | 56 |
1044008 | 1044008 | 2021-02-19 | Ventura | California | 6111 | 76442 | 782 |
1044009 | 1044009 | 2021-02-19 | Yolo | California | 6113 | 12549 | 181 |
1044010 | 1044010 | 2021-02-19 | Yuba | California | 6115 | 5681 | 36 |
1040708 | 1040708 | 2021-02-18 | Alameda | California | 6001 | 79113 | 1126 |
1040709 | 1040709 | 2021-02-18 | Alpine | California | 6003 | 77 | 0 |
1040710 | 1040710 | 2021-02-18 | Amador | California | 6005 | 3414 | 38 |
1040711 | 1040711 | 2021-02-18 | Butte | California | 6007 | 10770 | 153 |
1040712 | 1040712 | 2021-02-18 | Calaveras | California | 6009 | 1876 | 25 |
1040713 | 1040713 | 2021-02-18 | Colusa | California | 6011 | 2116 | 13 |
1040714 | 1040714 | 2021-02-18 | Contra Costa | California | 6013 | 61134 | 631 |
1040715 | 1040715 | 2021-02-18 | Del Norte | California | 6015 | 954 | 5 |
1040716 | 1040716 | 2021-02-18 | El Dorado | California | 6017 | 8847 | 91 |
1040717 | 1040717 | 2021-02-18 | Fresno | California | 6019 | 93555 | 1349 |
1040718 | 1040718 | 2021-02-18 | Glenn | California | 6021 | 2647 | 23 |
1040719 | 1040719 | 2021-02-18 | Humboldt | California | 6023 | 3053 | 32 |
1040720 | 1040720 | 2021-02-18 | Imperial | California | 6025 | 26817 | 583 |
1040721 | 1040721 | 2021-02-18 | Inyo | California | 6027 | 1197 | 34 |
1040722 | 1040722 | 2021-02-18 | Kern | California | 6029 | 101157 | 727 |
1040723 | 1040723 | 2021-02-18 | Kings | California | 6031 | 21720 | 213 |
1040724 | 1040724 | 2021-02-18 | Lake | California | 6033 | 3057 | 39 |
1040725 | 1040725 | 2021-02-18 | Lassen | California | 6035 | 5558 | 19 |
1040726 | 1040726 | 2021-02-18 | Los Angeles | California | 6037 | 1174897 | 19514 |
1040727 | 1040727 | 2021-02-18 | Madera | California | 6039 | 15135 | 201 |
1040728 | 1040728 | 2021-02-18 | Marin | California | 6041 | 12881 | 192 |
1040729 | 1040729 | 2021-02-18 | Mariposa | California | 6043 | 389 | 7 |
1040730 | 1040730 | 2021-02-18 | Mendocino | California | 6045 | 3750 | 41 |
1040731 | 1040731 | 2021-02-18 | Merced | California | 6047 | 28385 | 384 |
1040732 | 1040732 | 2021-02-18 | Modoc | California | 6049 | 446 | 4 |
1040733 | 1040733 | 2021-02-18 | Mono | California | 6051 | 1180 | 4 |
1040734 | 1040734 | 2021-02-18 | Monterey | California | 6053 | 41675 | 313 |
1040735 | 1040735 | 2021-02-18 | Napa | California | 6055 | 8866 | 65 |
1040736 | 1040736 | 2021-02-18 | Nevada | California | 6057 | 3832 | 74 |
1040737 | 1040737 | 2021-02-18 | Orange | California | 6059 | 258182 | 3685 |
1040738 | 1040738 | 2021-02-18 | Placer | California | 6061 | 19462 | 229 |
1040739 | 1040739 | 2021-02-18 | Plumas | California | 6063 | 623 | 6 |
1040740 | 1040740 | 2021-02-18 | Riverside | California | 6065 | 287200 | 3599 |
1040741 | 1040741 | 2021-02-18 | Sacramento | California | 6067 | 91392 | 1412 |
1040742 | 1040742 | 2021-02-18 | San Benito | California | 6069 | 5661 | 57 |
1040743 | 1040743 | 2021-02-18 | San Bernardino | California | 6071 | 283356 | 2492 |
1040744 | 1040744 | 2021-02-18 | San Diego | California | 6073 | 255053 | 3135 |
1040745 | 1040745 | 2021-02-18 | San Francisco | California | 6075 | 33561 | 376 |
1040746 | 1040746 | 2021-02-18 | San Joaquin | California | 6077 | 65705 | 1021 |
1040747 | 1040747 | 2021-02-18 | San Luis Obispo | California | 6079 | 19283 | 210 |
1040748 | 1040748 | 2021-02-18 | San Mateo | California | 6081 | 38124 | 481 |
1040749 | 1040749 | 2021-02-18 | Santa Barbara | California | 6083 | 31185 | 388 |
1040750 | 1040750 | 2021-02-18 | Santa Clara | California | 6085 | 108255 | 1709 |
1040751 | 1040751 | 2021-02-18 | Santa Cruz | California | 6087 | 14394 | 172 |
1040752 | 1040752 | 2021-02-18 | Shasta | California | 6089 | 10834 | 171 |
1040753 | 1040753 | 2021-02-18 | Sierra | California | 6091 | 47 | 0 |
1040754 | 1040754 | 2021-02-18 | Siskiyou | California | 6093 | 1695 | 13 |
1040755 | 1040755 | 2021-02-18 | Solano | California | 6095 | 29695 | 156 |
1040756 | 1040756 | 2021-02-18 | Sonoma | California | 6097 | 27414 | 291 |
1040757 | 1040757 | 2021-02-18 | Stanislaus | California | 6099 | 54728 | 916 |
1040758 | 1040758 | 2021-02-18 | Sutter | California | 6101 | 8744 | 94 |
1040759 | 1040759 | 2021-02-18 | Tehama | California | 6103 | 4511 | 51 |
1040760 | 1040760 | 2021-02-18 | Trinity | California | 6105 | 278 | 5 |
1040761 | 1040761 | 2021-02-18 | Tulare | California | 6107 | 47311 | 717 |
1040762 | 1040762 | 2021-02-18 | Tuolumne | California | 6109 | 3866 | 56 |
1040763 | 1040763 | 2021-02-18 | Ventura | California | 6111 | 76234 | 775 |
1040764 | 1040764 | 2021-02-18 | Yolo | California | 6113 | 12506 | 181 |
1040765 | 1040765 | 2021-02-18 | Yuba | California | 6115 | 5661 | 36 |
1037463 | 1037463 | 2021-02-17 | Alameda | California | 6001 | 79037 | 1125 |
1037464 | 1037464 | 2021-02-17 | Alpine | California | 6003 | 76 | 0 |
1037465 | 1037465 | 2021-02-17 | Amador | California | 6005 | 3412 | 38 |
1037466 | 1037466 | 2021-02-17 | Butte | California | 6007 | 10748 | 153 |
1037467 | 1037467 | 2021-02-17 | Calaveras | California | 6009 | 1872 | 25 |
1037468 | 1037468 | 2021-02-17 | Colusa | California | 6011 | 2110 | 13 |
1037469 | 1037469 | 2021-02-17 | Contra Costa | California | 6013 | 60996 | 626 |
1037470 | 1037470 | 2021-02-17 | Del Norte | California | 6015 | 947 | 4 |
1037471 | 1037471 | 2021-02-17 | El Dorado | California | 6017 | 8836 | 91 |
1037472 | 1037472 | 2021-02-17 | Fresno | California | 6019 | 93363 | 1341 |
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);