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

Ontario City _ General Populations
2020 Census
variable value percent
Hispanic 119928 68
Asian 16243 9
White 42332 24
Black 11045 6
Chino City _ General Populations
2020 Census
variable value percent
Hispanic 46841 51
Asian 17628 19
White 27290 30
Black 5535 6
Chino Hills City _ General Populations
2020 Census
variable value percent
Hispanic 22084 28
Asian 31780 41
White 22746 29
Black 3308 4
Fontana City _ General Populations
2020 Census
variable value percent
Hispanic 141269 68
Asian 17631 8
White 49777 24
Black 18756 9
Montclair city _ General Populations
2020 Census
variable value percent
Hispanic 27222 72
Asian 4366 12
White 7741 20
Black 1652 4
Upland city _ General Populations
2020 Census
variable value percent
Hispanic 35190 45
Asian 8059 10
White 34980 44
Black 5089 6
Colton city _ General Populations
2020 Census
variable value percent
Hispanic 39779 74
Asian 2601 5
White 13306 25
Black 4741 9

##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

Ontario City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1131 1083 48
Chinese 3093 966 2127
Filipino 3397 3410 -13
Korean 710 282 428
Japanese 535 355 180
Indian 612 441 171
Thai 140 67 73
Pakistani 68 105 -37
Tainwanese 98 93 5
Chino City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 532 508 24
Chinese 4773 1461 3312
Filipino 3533 3011 522
Korean 1618 567 1051
Japanese 328 372 -44
Indian 524 881 -357
Thai 134 51 83
Pakistani 259 7 252
Tainwanese 405 273 132
Chino Hills City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 976 690 286
Chinese 13420 5385 8035
Filipino 5843 6593 -750
Korean 3647 2426 1221
Japanese 854 1385 -531
Indian 1912 2534 -622
Thai 150 189 -39
Pakistani 200 339 -139
Tainwanese 1282 613 669
Fontana City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1562 946 616
Chinese 2951 1513 1438
Filipino 5734 5113 621
Korean 652 1253 -601
Japanese 134 116 18
Indian 765 834 -69
Thai 31 80 -49
Pakistani 369 278 91
Tainwanese 86 74 12
Montclair City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1659 1483 176
Chinese 790 643 147
Filipino 904 681 223
Korean 198 12 186
Japanese 16 140 -124
Indian 179 46 133
Thai 54 24 30
Pakistani 50 0 50
Tainwanese 72 0 72
Upland City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 304 979 -675
Chinese 1800 1020 780
Filipino 1934 1361 573
Korean 549 718 -169
Japanese 334 284 50
Indian 808 593 215
Thai 149 290 -141
Pakistani 51 36 15
Tainwanese 111 293 -182
Colton City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 130 290 -160
Chinese 237 264 -27
Filipino 772 1275 -503
Korean 120 15 105
Japanese 29 142 -113
Indian 89 149 -60
Thai 18 284 -266
Pakistani 0 43 -43
Tainwanese 0 0 0
San Bernardino City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1424 1602 -178
Chinese 865 957 -92
Filipino 2458 2579 -121
Korean 417 394 23
Japanese 79 341 -262
Indian 750 815 -65
Thai 84 211 -127
Pakistani 172 91 81
Tainwanese 14 35 -21
Rancho Cucamonga City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 1617 1263 354
Chinese 7199 2751 4448
Filipino 5911 5714 197
Korean 2708 1730 978
Japanese 698 560 138
Indian 3038 1474 1564
Thai 450 196 254
Pakistani 759 333 426
Tainwanese 841 271 570
Rialto City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 260 64 196
Chinese 298 186 112
Filipino 1073 1023 50
Korean 103 70 33
Japanese 159 144 15
Indian 151 97 54
Thai 57 68 -11
Pakistani 58 60 -2
Tainwanese 0 0 0

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

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