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 Jose City _ General Populations
2020 Census
variable value percent
Hispanic 316266 31
Asian 390532 39
White 276523 27
Black 29308 3
Sunnyvale City _ General Populations
2020 Census
variable value percent
Hispanic 25372 16
Asian 77842 50
White 46551 30
Black 2228 1
Santa Clara City _ General Populations
2020 Census
variable value percent
Hispanic 22550 18
Asian 60002 47
White 39504 31
Black 2839 2
Mountain View City _ General Populations
2020 Census
variable value percent
Hispanic 14206 17
Asian 28891 35
White 34895 42
Black 1227 1
Milpitas city _ General Populations
2020 Census
variable value percent
Hispanic 10586 13
Asian 57537 72
White 9085 11
Black 1691 2
Palo Alto city _ General Populations
2020 Census
variable value percent
Hispanic 5091 7
Asian 24317 35
White 34191 50
Black 1225 2
Cupertino city _ General Populations
2020 Census
variable value percent
Hispanic 2330 4
Asian 42411 70
White 13449 22
Black 387 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 B02015_013 Estimate!!Total:!!Laotian B02015_006 Estimate!!Total:!!Cambodian B02015_014 Estimate!!Total:!!Malaysian

#——————— # 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 B02006_012 Estimate!!Total!!Malaysian B02006_011 Estimate!!Total!!Laotian B02006_004 Estimate!!Total!!Cambodian

San Jose City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 115405 93432 21973
Chinese 83598 62483 21115
Filipino 55781 52561 3220
Korean 13082 12630 452
Japanese 11059 12453 -1394
Indian 72179 40169 32010
Thai 873 905 -32
Pakistani 2647 1609 1038
Taiwanese 6221 2618 3603
Kmer 3113 4115 -1002
Laos 1116 1637 -521
Malays 316 80 236
Sunnyvale City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 2805 3671 -866
Chinese 25065 15215 9850
Filipino 5791 7413 -1622
Korean 2561 2596 -35
Japanese 2420 2989 -569
Indian 29854 19716 10138
Thai 94 218 -124
Pakistani 601 287 314
Taiwanese 1060 458 602
Kmer 91 185 -94
Laos 0 105 -105
Malays 77 46 31
Santa Clara City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 3551 5808 -2257
Chinese 14822 7239 7583
Filipino 7165 7889 -724
Korean 3095 2603 492
Japanese 2079 2082 -3
Indian 22742 13741 9001
Thai 149 15 134
Pakistani 318 1152 -834
Taiwanese 770 223 547
Kmer 51 43 8
Laos 11 158 -147
Malays 48 108 -60
Mountain View City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 754 613 141
Chinese 11404 7460 3944
Filipino 1750 1437 313
Korean 1337 1381 -44
Japanese 1275 1971 -696
Indian 6632 4057 2575
Thai 259 170 89
Pakistani 167 100 67
Taiwanese 743 324 419
Kmer 0 8 -8
Laos 0 0 0
Malays 13 17 -4
Milpitas City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 9860 8637 1223
Chinese 11147 8237 2910
Filipino 10054 11820 -1766
Korean 1408 681 727
Japanese 632 431 201
Indian 15182 6572 8610
Thai 49 43 6
Pakistani 203 499 -296
Taiwanese 540 297 243
Kmer 103 120 -17
Laos 92 228 -136
Malays 21 8 13
Palo Alto City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 418 372 46
Chinese 12356 7819 4537
Filipino 680 623 57
Korean 2274 1918 356
Japanese 1281 1337 -56
Indian 3873 2736 1137
Thai 27 159 -132
Pakistani 114 175 -61
Taiwanese 692 376 316
Kmer 7 0 7
Laos 0 0 0
Malays 9 0 9
Cupertino City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 762 663 99
Chinese 16070 14838 1232
Filipino 345 576 -231
Korean 2695 2624 71
Japanese 1658 1701 -43
Indian 17514 10832 6682
Thai 80 95 -15
Pakistani 124 57 67
Taiwanese 1142 986 156
Kmer 0 33 -33
Laos 0 0 0
Malays 45 0 45
Saratoga City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 763 420 343
Chinese 7609 6210 1399
Filipino 180 168 12
Korean 796 871 -75
Japanese 685 612 73
Indian 3802 2644 1158
Thai 37 150 -113
Pakistani 223 40 183
Taiwanese 828 458 370
Kmer 0 0 0
Laos 0 0 0
Malays 18 0 18
Los Altos City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 149 309 -160
Chinese 3934 2504 1430
Filipino 147 165 -18
Korean 1064 531 533
Japanese 721 627 94
Indian 2919 1484 1435
Thai 25 0 25
Pakistani 128 26 102
Taiwanese 370 203 167
Kmer 0 0 0
Laos 0 0 0
Malays 0 0 0
Gilroy City _ Asian Populations
2020 Census
variable y2020 y2010 change
Vietnamese 631 440 191
Chinese 997 217 780
Filipino 2451 1570 881
Korean 231 298 -67
Japanese 423 350 73
Indian 944 116 828
Thai 0 0 0
Pakistani 37 0 37
Taiwanese 12 0 12
Kmer 76 0 76
Laos 0 0 0
Malays 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 California 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 California 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 California 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 California 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 California 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 California 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 California cities
2020 California Census
NAME estimate
Los Angeles city, California 12427
Pakistani Populations by California 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 California 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
## Adding missing grouping variables: `GEOID`
Median Household Income
California cities with general population over 500,000
NAME Group Median Income
0644000
Los Angeles city white 76589
Los Angeles city black 42485
Los Angeles city asian 73933
Los Angeles city hispanic 65466
0666000
San Diego city white 86062
San Diego city black 55336
San Diego city asian 99886
San Diego city hispanic 59309
0668000
San Jose city white 118978
San Jose city black 78092
San Jose city asian 139164
San Jose city hispanic 72503
0667000
San Francisco city white 146043
San Francisco city black 38862
San Francisco city asian 101563
San Francisco city hispanic 102173
0627000
Fresno city white 55765
Fresno city black 34361
Fresno city asian 63460
Fresno city hispanic 39967
0664000
Sacramento city white 73255
Sacramento city black 51139
Sacramento city asian 71993
Sacramento city hispanic 49513

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