cdph-population-race-ethnicity

Table actions

The breakdown of the population by race and ethnicity statewide and in each of the 58 counties, as provided by the California Department of Public Health.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

county
The name of the county. The state of California also included as a row.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
aian
The percentage of people in the area who are American Indian or Alaska Native
asian
The percentage of people in the area who are Asian
black
The percentage of people in the area who are Black
latino
The percentage of people in the area who are Latino
multirace
The percentage of people in the area who are multirace
nhpi
The percentage of people in the area who are Native Hawaiian or Pacific Islander
other
The percentage of people in the area who are of another race
unknown
The percentage of people in the area who are of unknown race
white
The percentage of people in the area who are white

59 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Link rowid ▼ county fips aian asian black latino multirace nhpi other unknown white
1 1 Alameda 1 0.350794774973 30.436577562184 11.716450578509 22.555854903594 4.037580239708 0.774488903757 0.0 0.0 30.128253037275
2 2 Alpine 3 18.800358102059 2.864816472695 1.342882721576 11.01163831692 2.775290957923 0.0 0.0 0.0 63.205013428827
3 3 Amador 5 1.795956502556 1.372920505567 3.527030183489 15.434325607952 2.481119098907 0.324414108121 0.0 0.0 75.064233993408
4 4 Butte 7 1.373932928929 5.159136516217 1.717875363344 16.669957615639 2.094421152689 0.160720763745 0.0 0.0 72.823955659437
5 5 Calaveras 9 1.372801372801 1.659554291133 1.372801372801 12.42069136806 2.42498137235 0.239337081442 0.0 0.0 80.509833141412
6 6 California   0.513805920682 15.424377186066 5.964894356124 38.93641681012 2.209622628532 0.338210418558 0.0 0.0 36.612672679917
7 7 Colusa 11 1.403089452485 1.22604346479 0.725888549551 62.209533926437 1.013588279556 0.230159784004 0.0 0.0 33.191696543177
8 8 Contra Costa 13 0.298681405639 16.713056385705 9.371269176165 26.771508293689 3.918286284188 0.441514043198 0.0 0.0 42.485684411417
9 9 Del Norte 15 7.359024602656 3.99521010233 4.51048697293 20.074025691269 2.73604760868 0.214093911024 0.0 0.0 61.111111111111
10 10 El Dorado 17 0.835327139587 4.600772664657 0.965830821655 14.632466416017 1.368735046453 0.160540243814 0.0 0.0 77.436327667816
11 11 Fresno 19 0.645885062104 10.711403596302 4.999772336899 52.56586002885 1.923123498998 0.121291150106 0.0 0.0 29.032664326742
12 12 Glenn 21 1.632138476216 2.368134114761 0.810958157285 42.899005042933 1.366362273409 0.06814774431 0.0 0.0 50.855254191086
13 13 Humboldt 23 5.425136840221 2.701009709317 1.629405360259 13.124729675312 2.367671404495 0.263240316783 0.0 0.0 74.488806693612
14 14 Imperial 25 0.672061946579 1.327948489165 2.18107060303 83.838684261332 0.604751394476 0.050091573658 0.0 0.0 11.32539173176
15 15 Inyo 27 10.572806589714 1.555302660814 1.360212431583 23.990679022381 2.460304557525 0.211347748334 0.0 0.0 59.849346989649
16 16 Kern 29 0.68277090022 4.679315525138 6.000424911917 52.590291086232 1.89905430137 0.129738334065 0.0 0.0 34.018404941057
17 17 Kings 31 0.798368745366 4.167625476209 6.358185676664 55.992559637953 1.71179463578 0.768965252742 0.0 0.0 30.202500575286
18 18 Lake 33 2.552758551587 1.217801482943 1.913027392826 21.496508455242 2.390898860816 0.140278398668 0.0 0.0 70.288726857918
19 19 Lassen 35 3.389323133211 1.546648927324 9.230001663063 19.461167470481 1.972393148179 0.781639780476 0.0 0.0 63.618825877266
20 20 Los Angeles 37 0.292408806502 16.054543981574 8.123386494465 47.55094219803 2.030717450559 0.23208255143 0.0 0.0 25.71591851744
21 21 Madera 39 1.113755473518 1.978274584762 3.345014335776 58.811661013561 1.219946404812 0.06933643161 0.0 0.0 33.462011755961
22 22 Marin 41 0.223159509202 7.13726993865 3.403757668712 18.132285276074 1.399923312883 0.180981595092 0.0 0.0 69.522622699387
23 23 Mariposa 43 2.961506041023 2.169148637258 1.421747681933 12.239393087946 2.613093565608 0.264119134588 0.0 0.0 78.330991851644
24 24 Mendocino 45 4.25717160981 1.722090932733 0.933977091555 26.967740476487 2.055654179717 0.104026504144 0.0 0.0 63.959339205554
25 25 Merced 47 0.421682555146 9.128801057686 3.150441862083 57.722844617633 1.220165611301 0.192749286758 0.0 0.0 28.163315009394
26 26 Modoc 49 3.831134564644 1.551451187335 1.562005277045 17.804749340369 2.448548812665 0.474934036939 0.0 0.0 72.327176781003
27 27 Mono 51 2.156006016761 6.023923787694 1.081584413724 30.090967695724 1.797865482415 0.214884320607 0.0 0.0 58.634768283074
28 28 Monterey 53 0.333160995873 6.292842944118 2.829305688028 59.899450005794 1.426686752895 0.443694677447 0.0 0.0 28.774858935846
29 29 Napa 55 0.397416435139 8.138086099734 1.795176581789 37.748116747343 1.470082777189 0.213387563372 0.0 0.0 50.237733795434
30 30 Nevada 57 1.437544321751 2.240907709452 1.718164319724 12.098065039003 1.275453348192 0.221862020059 0.0 0.0 81.008003241819
31 31 Orange 59 0.23980035428 21.799623914247 1.75690463646 35.265705420969 0.882107244839 0.126497629408 0.0 0.0 39.929360799797
32 32 Placer 61 0.582368130578 7.520090701589 1.623738244005 15.250203529171 1.301837506306 0.16282333668 0.0 0.0 73.558938551671
33 33 Plumas 63 2.963625835658 1.431805021846 2.347739116703 11.796599463073 2.358267094804 0.215823551087 0.0 0.0 78.886139916829
34 34 Riverside 65 0.605110315642 7.038970562913 6.511327332876 47.335022861299 2.227867487526 0.272188222329 0.0 0.0 36.009513217416
35 35 Sacramento 67 0.622841563163 16.215883544062 10.605908895231 22.936653964508 2.583842216872 0.981648304342 0.0 0.0 46.053221511823
36 36 San Benito 69 0.434225734904 2.8334010184 1.073068632658 58.957858236231 1.415138546125 0.203055199775 0.0 0.0 35.083252631908
37 37 San Bernardino 71 0.510643556096 7.460546099527 8.969341543557 50.858889563353 2.196809052773 0.294128523612 0.0 0.0 29.709641661082
38 38 San Diego 73 0.658998379429 13.195722311001 5.047356143956 32.790235513815 3.135605138591 0.426712651072 0.0 0.0 44.745369862136
39 39 San Francisco 75 0.398977899314 36.59479087282 5.37600304837 14.711189312772 1.593894293271 0.229300219662 0.0 0.0 41.09584435379
40 40 San Joaquin 77 0.505402245238 15.746953849299 6.992824693788 40.94754934221 3.317508897252 0.488278629344 0.0 0.0 32.001482342868
41 41 San Luis Obispo 79 0.471200809002 3.900854185941 2.42091070135 24.346092332408 1.429022240391 0.112600497737 0.0 0.0 67.319319233169
42 42 San Mateo 81 0.207583280741 29.036595068644 2.516963345805 27.342381307993 1.858352367156 1.217350620372 0.0 0.0 37.820774009288
43 43 Santa Barbara 83 0.450727803792 6.188578202479 1.849364445311 47.450878995909 1.102606858863 0.143303832611 0.0 0.0 42.814539861035
44 44 Santa Clara 85 0.323594660459 38.819923916883 2.365183715062 25.894586510875 3.168147754735 0.343670032044 0.0 0.0 29.084893409942
45 45 Santa Cruz 87 0.419709560984 5.637611816102 1.023361399129 35.538085905423 1.526647907474 0.120803360596 0.0 0.0 55.733780050292
46 46 Shasta 89 2.856259659969 3.424476605311 1.290993396094 11.562175073767 1.770970914711 0.1337642265 0.0 0.0 78.961360123648
47 47 Sierra 91 2.118780096308 2.022471910112 1.669341894061 14.767255216693 2.279293739968 0.256821829856 0.0 0.0 76.886035313002
48 48 Siskiyou 93 4.163254163254 2.140777140777 2.495677495678 13.759213759214 2.461552461552 0.325325325325 0.0 0.0 74.6541996542
49 49 Solano 95 0.476753216058 16.189800902635 14.678731809434 27.339253356743 3.050050083848 0.915465217049 0.0 0.0 37.349945414233
50 50 Sonoma 97 0.87060168966 4.236834263532 2.180329717236 28.879855356093 1.270869071492 0.350535971716 0.0 0.0 62.210973930271
51 51 Stanislaus 99 0.512179376599 5.557324076165 2.854332984174 46.453068897018 1.444950498219 0.572289317325 0.0 0.0 42.605854850499
52 52 Sutter 101 0.859598853868 17.204270570324 2.069089430433 32.490756238948 2.209991772816 0.246815512497 0.0 0.0 44.919477621115
53 53 Tehama 103 1.762161341732 1.322000455339 0.705775214389 27.015253851408 1.709038476133 0.078925400319 0.0 0.0 67.406845260681
54 54 Trinity 105 4.118616144975 0.936049123858 0.681443762169 13.044780590085 3.130148270181 0.08986071589 0.0 0.0 77.999101392841
55 55 Tulare 107 0.659960406504 3.147042976902 1.269138748573 64.917644290217 0.874648808995 0.083398187122 0.0 0.0 29.048166581686
56 56 Tuolumne 109 1.661859372314 1.47466142003 2.616950965598 12.578556283548 1.942656300739 0.236862715134 0.0 0.0 79.488452942637
57 57 Ventura 111 0.425565847784 7.826119587639 1.673884516744 44.010005312244 2.265267423984 0.170859586724 0.0 0.0 43.628297724882
58 58 Yolo 113 0.61937641987 19.092445843694 2.566946317729 32.090853800333 3.184086721643 0.459277677406 0.0 0.0 41.987013219326
59 59 Yuba 115 1.597931643335 9.184008071636 3.217303569176 29.891537394375 3.258922941102 0.392231050574 0.0 0.0 52.458065329802

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-population-race-ethnicity" (
   [county] TEXT,
   [fips] INTEGER,
   [aian] FLOAT,
   [asian] FLOAT,
   [black] FLOAT,
   [latino] FLOAT,
   [multirace] FLOAT,
   [nhpi] FLOAT,
   [other] FLOAT,
   [unknown] FLOAT,
   [white] FLOAT
);