Analysizing Census data:

Tidycensus package (K. Walker and Herman 2021), R package designed to facilitate the process of acquiring and working with US Census Bureau population data in the R environment. The package has two distinct goals:

  • Data retrieval from Census

  • Data manipulation and wrangling for analysis

Asian Populations in California Counties
2020 Census
NAME value
Los Angeles 1499984
Santa Clara 759030
Orange 706813
Alameda 545261
San Diego 410752
San Francisco 296505
Sacramento 281733
San Mateo 230242
Contra Costa 217823
San Bernardino 182287
Riverside 171243
San Joaquin 139323
Fresno 113328
Solano 72766
Ventura 64923
Kern 46777
Placer 35500
Stanislaus 34778
Yolo 30392
Monterey 26680

San Diego City _ General Populations
2020 Census
variable value percent
Hispanic 411286 30
Asian 247860 18
White 643304 46
Black 82265 6
Chula Vista city _ General Populations
2020 Census
variable value percent
Hispanic 164698 60
Asian 42683 15
White 72083 26
Black 13991 5
Escondido city _ General Populations
2020 Census
variable value percent
Hispanic 78226 52
Asian 11974 8
White 63249 42
Black 3602 2
National City _ General Populations
2020 Census
variable value percent
Hispanic 37086 66
Asian 11094 20
White 11149 20
Black 2239 4
Carlsbad City _ General Populations
2020 Census
variable value percent
Hispanic 17302 15
Asian 9176 8
White 83264 73
Black 1340 1
El Cajon City _ General Populations
2020 Census
variable value percent
Hispanic 31271 29
Asian 5254 5
White 61728 58
Black 7164 7
El Centro City _ General Populations
2020 Census
variable value percent
Hispanic 38566 87
Asian 802 2
White 11677 26
Black 890 2
Poway City _ General Populations
2020 Census
variable value percent
Hispanic 9017 18
Asian 6738 14
White 30591 63
Black 725 1

##2020 ASIAN ALONE BY SELECTED GROUPS

B02015_002 Estimate!!Total:!!Asian Indian B02015_007 Estimate!!Total:!!Chinese, except Taiwanese B02015_008 Estimate!!Total:!!Filipino B02015_011 Estimate!!Total:!!Japanese B02015_012 Estimate!!Total:!!Korean B02015_018 Estimate!!Total:!!Pakistani B02015_020 Estimate!!Total:!!Taiwanese B02015_021 Estimate!!Total:!!Thai B02015_022 Estimate!!Total:!!Vietnamese

#——————— # 2010 Census acs5 variables B02006_010 Estimate!!Total!!Korean B02006_005 Estimate!!Total!!Chinese , except Taiwanese B02006_015 Estimate!!Total!!Taiwanese B02006_017 Estimate!!Total!!Vietnamese B02006_006 Estimate!!Total!!Filipino B02006_010 Estimate!!Total!!Korean B02006_009 Estimate!!Total!!Japanese B02006_002 Estimate!!Total!!Asian Indian B02006_016 Estimate!!Total!!Thai B02006_013 Estimate!!Total!!Pakistani B02006_015 Estimate!!Total!!Taiwanese

San Diego City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 36509 32041 4468
Chinese 45556 34442 11114
Filipino 77612 74437 3175
Korean 14809 12435 2374
Japanese 9349 10140 -791
Indian 30207 16334 13873
Thai 1710 1681 29
Pakistani 1343 716 627
Tainwanese 3246 1901 1345
Chula Vista City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1170 982 188
Chinese 1537 2036 -499
Filipino 31983 24138 7845
Korean 1681 1679 2
Japanese 1778 1466 312
Indian 542 832 -290
Thai 74 51 23
Pakistani 37 0 37
Tainwanese 168 209 -41
Escondido City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1638 1781 -143
Chinese 1110 1290 -180
Filipino 3324 3458 -134
Korean 549 514 35
Japanese 556 317 239
Indian 397 117 280
Thai 91 12 79
Pakistani 79 51 28
Tainwanese 133 0 133
National City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 237 229 8
Chinese 335 157 178
Filipino 9799 9955 -156
Korean 85 0 85
Japanese 132 257 -125
Indian 45 43 2
Thai 36 0 36
Pakistani 0 0 0
Tainwanese 0 25 -25
Carlsbad City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1182 607 575
Chinese 2352 1832 520
Filipino 1429 1264 165
Korean 862 819 43
Japanese 527 1006 -479
Indian 2968 1293 1675
Thai 41 26 15
Pakistani 45 0 45
Tainwanese 207 84 123
El Centro City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 19 30 -11
Chinese 131 225 -94
Filipino 266 145 121
Korean 154 306 -152
Japanese 16 61 -45
Indian 214 127 87
Thai 0 0 0
Pakistani 0 12 -12
Tainwanese 30 0 30
La Mesa City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 646 580 66
Chinese 1221 601 620
Filipino 1304 1272 32
Korean 195 144 51
Japanese 268 392 -124
Indian 151 271 -120
Thai 30 177 -147
Pakistani 9 0 9
Tainwanese 99 0 99
Poway City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1107 701 406
Chinese 1003 790 213
Filipino 2001 1973 28
Korean 288 237 51
Japanese 524 191 333
Indian 774 364 410
Thai 31 69 -38
Pakistani 77 63 14
Tainwanese 37 77 -40

2020 Census acs5 variables

B02006_010 Estimate!!Total!!Korean B02006_005 Estimate!!Total!!Chinese , except Taiwanese B02006_015 Estimate!!Total!!Taiwanese B02006_017 Estimate!!Total!!Vietnamese B02006_006 Estimate!!Total!!Filipino B02006_010 Estimate!!Total!!Korean B02006_009 Estimate!!Total!!Japanese B02006_002 Estimate!!Total!!Asian Indian B02006_016 Estimate!!Total!!Thai B02006_013 Estimate!!Total!!Pakistani B02006_015 Estimate!!Total!!Taiwanese B03001_002 Estimate!!Total!!Not Hispanic or Latino

Vietnamese Populations by cities
2020 California Census
NAME estimate
San Jose city, California 115405
Garden Grove city, California 57280
Westminster city, California 40187
San Diego city, California 36509
Santa Ana city, California 26935
Los Angeles city, California 25295
Anaheim city, California 19367
San Francisco city, California 16139
Fountain Valley city, California 13345
Huntington Beach city, California 10077
Irvine city, California 9875
Milpitas city, California 9860
El Monte city, California 9679
Elk Grove city, California 8332
Oakland city, California 7689
Rosemead city, California 7537
Stanton city, California 7174
Sacramento city, California 7018
Stockton city, California 6380
Fremont city, California 5564
Hayward city, California 4695
Riverside city, California 4023
Orange city, California 3954
San Gabriel city, California 3919
Alhambra city, California 3814
Santa Clara city, California 3551
West Covina city, California 3122
Costa Mesa city, California 3089
San Leandro city, California 2980
Long Beach city, California 2885
Sunnyvale city, California 2805
Baldwin Park city, California 2751
Corona city, California 2718
Mission Viejo city, California 2643
Monterey Park city, California 2642
Fresno city, California 2423
Torrance city, California 2302
Tustin city, California 2215
Murrieta city, California 2179
Union City city, California 2136
Alameda city, California 2128
Chinese Populations by cities
2020 California Census
NAME estimate
San Francisco city, California 181963
San Jose city, California 83598
Los Angeles city, California 76545
San Diego city, California 45556
Irvine city, California 39384
Fremont city, California 38955
Oakland city, California 32095
Alhambra city, California 30178
Monterey Park city, California 27855
Sunnyvale city, California 25065
Sacramento city, California 22130
Daly City city, California 21557
Arcadia city, California 21505
Rosemead city, California 21146
El Monte city, California 19731
Diamond Bar city, California 17047
San Gabriel city, California 16653
Cupertino city, California 16070
Temple City city, California 16008
Santa Clara city, California 14822
San Leandro city, California 14324
West Covina city, California 13946
Chino Hills city, California 13420
Palo Alto city, California 12356
San Ramon city, California 11669
Berkeley city, California 11585
San Mateo city, California 11484
Walnut city, California 11449
Mountain View city, California 11404
Milpitas city, California 11147
Alameda city, California 10467
Elk Grove city, California 9719
Pasadena city, California 9382
Dublin city, California 9208
Union City city, California 9144
Hayward city, California 9085
Pleasanton city, California 8743
South San Francisco city, California 8223
Baldwin Park city, California 7767
Saratoga city, California 7609
Foster City city, California 7398
Davis city, California 7390
Rancho Cucamonga city, California 7199
Millbrae city, California 7130
Eastvale city, California 6830
San Marino city, California 6298
Torrance city, California 6081
San Bruno city, California 5578
Cerritos city, California 5555
Riverside city, California 5495
Stockton city, California 5229
Fresno city, California 5175
Pomona city, California 5118
Redwood City city, California 5094
Chino city, California 4773
Anaheim city, California 4739
Newark city, California 4732
Yorba Linda city, California 4621
Richmond city, California 4563
Walnut Creek city, California 4483
Huntington Beach city, California 4251
Fullerton city, California 4235
Long Beach city, California 4171
Concord city, California 4139
Tustin city, California 4094
Burlingame city, California 3952
Los Altos city, California 3934
Belmont city, California 3767
Thousand Oaks city, California 3719
Montebello city, California 3681
Campbell city, California 3663
El Cerrito city, California 3659
South Pasadena city, California 3654
Rancho Palos Verdes city, California 3295
Lake Forest city, California 3244
Glendale city, California 3156
Ontario city, California 3093
Fontana city, California 2951
Orange city, California 2937
Bakersfield city, California 2922
Santa Monica city, California 2810
Albany city, California 2735
Azusa city, California 2685
Santa Cruz city, California 2635
Santa Clarita city, California 2586
Pacifica city, California 2557
Cypress city, California 2502
Santa Ana city, California 2421
Carlsbad city, California 2352
Livermore city, California 2336
Newport Beach city, California 2323
Glendora city, California 2308
San Dimas city, California 2236
Burbank city, California 2195
Mission Viejo city, California 2113
Menlo Park city, California 2090
Garden Grove city, California 2062
Vallejo city, California 2028
Monrovia city, California 2011
Korean Populations by cities
2020 California Census
NAME estimate
Los Angeles city, California 106241
Irvine city, California 21271
Fullerton city, California 17492
San Diego city, California 14809
San Jose city, California 13082
San Francisco city, California 11970
Torrance city, California 11782
Buena Park city, California 9703
Glendale city, California 7823
Anaheim city, California 6630
Cerritos city, California 6159
Cypress city, California 5465
Diamond Bar city, California 5024
La Mirada city, California 4615
Garden Grove city, California 4086
Brea city, California 4029
Chino Hills city, California 3647
Gardena city, California 3622
Santa Clarita city, California 3348
La Habra city, California 3340
Tustin city, California 3311
Rancho Palos Verdes city, California 3118
Santa Clara city, California 3095
Long Beach city, California 3085
Fremont city, California 3003
Pasadena city, California 2840
Yorba Linda city, California 2797
Oakland city, California 2757
Rancho Cucamonga city, California 2708
Cupertino city, California 2695
Sunnyvale city, California 2561
Pleasanton city, California 2495
La Cañada Flintridge city, California 2447
Riverside city, California 2398
Palo Alto city, California 2274
Berkeley city, California 2200
San Ramon city, California 2183
La Palma city, California 2069
Filipino Populations by cities
2020 California Census
NAME estimate
Los Angeles city, California 129754
San Diego city, California 77612
San Jose city, California 55781
San Francisco city, California 35588
Daly City city, California 32928
Chula Vista city, California 31983
Vallejo city, California 23695
Stockton city, California 21079
Long Beach city, California 20227
Carson city, California 19617
Hayward city, California 17498
South San Francisco city, California 14939
Anaheim city, California 14782
Elk Grove city, California 14359
Fremont city, California 14329
Sacramento city, California 14052
Union City city, California 13773
Glendale city, California 11671
Fairfield city, California 11227
Milpitas city, California 10054
National City city, California 9799
San Leandro city, California 9363
West Covina city, California 9169
Oxnard city, California 9134
Santa Clarita city, California 8821
Bakersfield city, California 8537
Pittsburg city, California 8470
Lakewood city, California 8130
Fresno city, California 7992
Buena Park city, California 7811
Cerritos city, California 7681
Irvine city, California 7631
Santa Clara city, California 7165
Riverside city, California 6648
Norwalk city, California 6593
Delano city, California 6485
Antioch city, California 6293
Oakland city, California 6253
Salinas city, California 6205
Oceanside city, California 6005
Temecula city, California 5945
Rancho Cucamonga city, California 5911
Chino Hills city, California 5843
Sunnyvale city, California 5791
Alameda city, California 5747
Fontana city, California 5734
Eastvale city, California 5714
Torrance city, California 5666
Corona city, California 5589
Concord city, California 5353
Hercules city, California 5242
American Canyon city, California 5140
Bellflower city, California 5070
Tracy city, California 4926
Roseville city, California 4904
San Bruno city, California 4819
Moreno Valley city, California 4676
Newark city, California 4634
Orange city, California 4340
Murrieta city, California 4335
Burbank city, California 4320
Pasadena city, California 4072
Modesto city, California 3984
Vacaville city, California 3893
Lancaster city, California 3876
San Mateo city, California 3772
Santa Maria city, California 3732
Fullerton city, California 3726
Suisun City city, California 3709
Garden Grove city, California 3653
Brentwood city, California 3561
Chino city, California 3533
Richmond city, California 3462
Diamond Bar city, California 3413
Ontario city, California 3397
Huntington Beach city, California 3374
Manteca city, California 3325
Escondido city, California 3324
Pacifica city, California 3314
Pomona city, California 3270
Lathrop city, California 3264
Palmdale city, California 3244
Downey city, California 3188
San Ramon city, California 3108
Baldwin Park city, California 3105
Walnut city, California 3093
San Marcos city, California 3076
Lake Forest city, California 3039
Santa Ana city, California 2979
Victorville city, California 2923
Simi Valley city, California 2820
Artesia city, California 2791
Rancho Cordova city, California 2749
Cathedral City city, California 2698
Redwood City city, California 2654
Menifee city, California 2627
La Mirada city, California 2611
Camarillo city, California 2606
Mission Viejo city, California 2573
Livermore city, California 2539
Visalia city, California 2530
San Bernardino city, California 2458
Gilroy city, California 2451
Gardena city, California 2417
Dublin city, California 2400
Tustin city, California 2381
Cypress city, California 2317
Lake Elsinore city, California 2312
Clovis city, California 2208
Arcadia city, California 2169
Loma Linda city, California 2126
Alhambra city, California 2123
Santa Rosa city, California 2029
Poway city, California 2001
Japanese Populations by cities
2020 California Census
NAME estimate
Los Angeles city, California 29972
Torrance city, California 15036
San Jose city, California 11059
San Francisco city, California 9748
San Diego city, California 9349
Irvine city, California 7869
Sacramento city, California 5342
Gardena city, California 5011
Monterey Park city, California 3289
Rancho Palos Verdes city, California 3024
Huntington Beach city, California 2874
Anaheim city, California 2522
Long Beach city, California 2492
Sunnyvale city, California 2420
Fresno city, California 2363
Santa Clara city, California 2079
Redondo Beach city, California 2017
Indian Populations by cities
2020 California Census
NAME estimate
San Jose city, California 72179
Fremont city, California 65788
Los Angeles city, California 41689
San Diego city, California 30207
Sunnyvale city, California 29854
Santa Clara city, California 22742
San Francisco city, California 22265
Irvine city, California 18036
San Ramon city, California 17635
Cupertino city, California 17514
Dublin city, California 16247
Fresno city, California 15959
Milpitas city, California 15182
Pleasanton city, California 14020
Sacramento city, California 13661
Union City city, California 10545
Bakersfield city, California 9995
Yuba City city, California 9841
Torrance city, California 7358
Hayward city, California 7146
Folsom city, California 6903
Mountain View city, California 6632
Elk Grove city, California 6242
Stockton city, California 5842
Simi Valley city, California 5300
Foster City city, California 5278
Roseville city, California 5216
Tracy city, California 5194
Anaheim city, California 4827
Newark city, California 4306
Cerritos city, California 4239
Berkeley city, California 4197
San Mateo city, California 3926
Palo Alto city, California 3873
Riverside city, California 3867
Saratoga city, California 3802
Livermore city, California 3772
Pasadena city, California 3756
Tustin city, California 3599
Oakland city, California 3569
Manteca city, California 3413
Santa Clarita city, California 3194
Modesto city, California 3075
Cypress city, California 3052
Rancho Cucamonga city, California 3038
Carlsbad city, California 2968
Buena Park city, California 2932
Los Altos city, California 2919
Redwood City city, California 2866
Livingston city, California 2675
Long Beach city, California 2523
Thousand Oaks city, California 2492
Turlock city, California 2399
Corona city, California 2362
Campbell city, California 2348
Fairfield city, California 2233
Belmont city, California 2166
Fullerton city, California 2141
Lathrop city, California 2114
Eastvale city, California 2072
Lake Forest city, California 2069
Yorba Linda city, California 2032
Thai Populations by cities
2020 California Census
NAME estimate
Los Angeles city, California 12427
Pakistani Populations by cities
2020 California Census
NAME estimate
Los Angeles city, California 4651
Stockton city, California 4002
Lodi city, California 3692
San Jose city, California 2647
Sacramento city, California 2417
Fremont city, California 2378
Taiwanese Populations by cities
2020 California Census
NAME estimate
San Jose city, California 6221
Los Angeles city, California 5472
Irvine city, California 5145
Fremont city, California 3651
San Diego city, California 3246
San Francisco city, California 2889
Arcadia city, California 2796

Median Household income

in the past 12 months

## Getting data from the 2016-2020 5-year ACS
Median Household Income
Westminster City, 2020 Census Survey
Group Estimate
white 82761
black 60917
asian 58529
hispanic 42979
Median Household Income
Garden Grove City, 2020 Census Survey
Group Estimate
white 78924
black 83597
asian 67958
hispanic 41734
Median Household Income
Irvine City, 2020 Census Survey
Group Estimate
white 107568
black 99735
asian 112079
hispanic 59394
Median Household Income
Santa Ana City, 2020 Census Survey
Group Estimate
white 79395
black 68630
asian 74832
hispanic 45755
Median Household Income
Fountain Valley City, 2020 Census Survey
Group Estimate
white 89144
black 130787
asian 91717
hispanic 47615
Median Household Income
Fullerton City, 2020 Census Survey
Group Estimate
white 83450
black 53125
asian 105219
hispanic 52375
Median Household Income
Anaheim City, 2020 Census Survey
Group Estimate
white 74565
black 68544
asian 87466
hispanic 47007
Median Household Income
San Francisco City, 2020 Census Survey
Group Estimate
white 146043
black 38862
asian 101563
hispanic 102173

B16001_088 Estimate!!Total:!!Vietnamese:!!Speak English “very well” (state level only)

B16001_089 Estimate!!Total:!!Vietnamese:!!Speak English less than “very well”

B16005_022 Estimate!!Total:!!Native:!!Speak other languages:!!Speak English “not well” ( tract level)

B16005_039 Estimate!!Total:!!Foreign born:!!Speak Asian and Pacific Island languages:!!Speak English “not well”

B16005D_006 Estimate!!Total:!!Native:!!Speak another language:!!Speak English less than “very well”( Asian alone)

## Getting data from the 2016-2020 5-year ACS
Education Attainment
Westminster City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 11149 16
Education Attainment
Garden Grove City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 17109 13
Education Attainment
Irvine City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 9457 4
Education Attainment
Santa Ana City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 8143 3
Education Attainment
Fountain Valley City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 2899 6
Education Attainment
Fullerton City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 4120 4
Education Attainment
Anaheim City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 7720 3
Education Attainment
Fountain Valley City, 2020 Census Survey
variable estimate percent
Vietnamese NA NA
Asian 2899 6

Employment and industry sectors

2021 Asian Employment by Industries
Percent Employment
Industry Asian Hispanic Black
Manicurists and pedicurists 73.1 12.2 4.8
Medical scientists 43.1 4.5 7.2
Software developers 37.1 5.8 5.4
Computer hardware engineers 36.4 7.2 5.9
Gambling services workers 29.1 12.4 9.7
Software quality assurance analysts and testers 27.6 5.7 14.1
Physical scientists, all other 27.3 6.5 6.9
Tailors, dressmakers, and sewers 25.8 19.5 10.6
Computer and mathematical occupations 23.3 8.3 8.5
Other physicians 22.9 5.8 8.1
Computer programmers 22.0 6.4 6.0
Other mathematical science occupations 21.6 7.9 12.3
Chemists and materials scientists 21.5 6.1 8.0
Financial and investment analysts 20.7 10.7 13.1
Database administrators and architects 20.0 6.3 5.1
Engineers, all other 19.9 9.6 5.1
Chefs and head cooks 19.9 23.0 14.8
Pharmacists 19.8 6.0 7.9
Dentists 19.6 6.0 4.5
Electrical and electronics engineers 19.1 10.2 4.4
Computer network architects 18.3 9.1 6.5
Computer and information systems managers 17.8 7.3 7.2
Jewelers and precious stone and metal workers 17.4 17.1 2.6
Industrial engineers, including health and safety 16.2 5.1 5.1
Computer systems analysts 16.0 11.0 11.3
2021 Hispanic Employment by Industries
Percent Employment
Industry Asian Hispanic Black
Drywall installers, ceiling tile installers, and tapers 0.7 72.5 3.3
Graders and sorters, agricultural products 10.5 65.3 10.8
Roofers 1.1 63.5 7.5
Painters and paperhangers 1.0 59.3 7.0
Cement masons, concrete finishers, and terrazzo workers 0.1 53.0 6.2
Brickmasons, blockmasons, and stonemasons 0.0 51.7 9.6
Construction laborers 2.6 48.9 8.1
Maids and housekeeping cleaners 5.2 48.2 15.2
Carpet, floor, and tile installers and finishers 0.2 48.2 6.2
Landscaping and groundskeeping workers 1.8 47.1 9.2
Miscellaneous agricultural workers 2.0 46.7 3.8
Sewing machine operators 3.9 46.1 6.9
Farming, fishing, and forestry occupations 2.3 43.9 4.4
Packaging and filling machine operators and tenders 7.3 43.9 21.0
Helpers, construction trades 0.6 43.3 9.9
Barbers 5.2 40.5 22.5
Butchers and other meat, poultry, and fish processing workers 4.6 39.7 15.4
Carpenters 1.6 39.3 6.3
Construction and extraction occupations 1.7 38.9 7.1
Interpreters and translators 14.1 38.7 7.9
Telecommunications line installers and repairers 2.1 38.4 13.7
Building and grounds cleaning and maintenance occupations 3.4 38.3 14.2
Packers and packagers, hand 8.5 38.0 19.1
Cooks 6.0 35.9 15.8
Parking attendants 6.8 35.7 28.4
## Getting data from the 2016-2020 5-year ACS

Conclusion:

  • This report is very general, and could be refocused to specific issues
  • This report might present more questions than answers
  • R Census packages are new powerful tools for data analysis
  • Let’s continue to work on demographics

Thank you

  • Joe Long
  • 858-442-2566