- California Immigrant Data Portal API query exports (2021 county metrics)
- Generated via POST to https://api.atlas-data.org/display-groups/{indicator}/{display}/data with header x-tenant: cidp
- [Educational attainment]
- indicator=cidp_educational_attainment_20220601
- display=map
- displayRev=18
- filters={"geo_type": ["04"], "immig": ["2"], "racethd": ["0000"], "sex": ["0"], "year": ["2021"]}
- metric_field=nAADEG_25to64_ipums
- county_rows:
- {"GEO_NAME": "Butte County, CA", "geo_code_long": "04000000000006007", "nAADEG_25to64_ipums": 815, "year": "2021"}
- {"GEO_NAME": "Fresno County, CA", "geo_code_long": "04000000000006019", "nAADEG_25to64_ipums": 8349, "year": "2021"}
- {"GEO_NAME": "Kern County, CA", "geo_code_long": "04000000000006029", "nAADEG_25to64_ipums": 6274, "year": "2021"}
- {"GEO_NAME": "Sonoma County, CA", "geo_code_long": "04000000000006097", "nAADEG_25to64_ipums": 3042, "year": "2021"}
- {"GEO_NAME": "Ventura County, CA", "geo_code_long": "04000000000006111", "nAADEG_25to64_ipums": 7966, "year": "2021"}
- [Employment]
- indicator=cidp_empoyment_20220610
- display=employment-status
- displayRev=22
- filters={"geo_type": ["04"], "immig": ["2"], "racethdimmigsex": ["000020"], "year": ["2021"]}
- metric_field=nEMP_CIVEMPANDLFSTAT_25TO64_ipums
- county_rows:
- {"GEO_NAME": "Butte County, CA", "geo_code_long": "04000000000006007", "nEMP_CIVEMPANDLFSTAT_25TO64_ipums": 7787, "year": "2021"}
- {"GEO_NAME": "Fresno County, CA", "geo_code_long": "04000000000006019", "nEMP_CIVEMPANDLFSTAT_25TO64_ipums": 105260, "year": "2021"}
- {"GEO_NAME": "Kern County, CA", "geo_code_long": "04000000000006029", "nEMP_CIVEMPANDLFSTAT_25TO64_ipums": 91571, "year": "2021"}
- {"GEO_NAME": "Sonoma County, CA", "geo_code_long": "04000000000006097", "nEMP_CIVEMPANDLFSTAT_25TO64_ipums": 47241, "year": "2021"}
- {"GEO_NAME": "Ventura County, CA", "geo_code_long": "04000000000006111", "nEMP_CIVEMPANDLFSTAT_25TO64_ipums": 97086, "year": "2021"}
- [Economic contributions]
- indicator=cidp_economic_contributions_20220630
- display=map
- displayRev=26
- filters={"geo_type": ["04"], "immig": ["2"], "racethd": ["0000"], "sex": ["0"], "year": ["2021"]}
- metric_field=spending_power
- county_rows:
- {"GEO_NAME": "Butte County, CA", "geo_code_long": "04000000000006007", "spending_power": 395473220, "year": "2021"}
- {"GEO_NAME": "Fresno County, CA", "geo_code_long": "04000000000006019", "spending_power": 5090346500, "year": "2021"}
- {"GEO_NAME": "Kern County, CA", "geo_code_long": "04000000000006029", "spending_power": 4186379300, "year": "2021"}
- {"GEO_NAME": "Sonoma County, CA", "geo_code_long": "04000000000006097", "spending_power": 2564952800, "year": "2021"}
- {"GEO_NAME": "Ventura County, CA", "geo_code_long": "04000000000006111", "spending_power": 5743460000, "year": "2021"}
- [Combined metrics requested]
- Format: County | nAADEG_25to64_ipums | nEMP_CIVEMPANDLFSTAT_25TO64_ipums | spending_power
- Butte County, CA | 815 | 7787 | 395473220
- Fresno County, CA | 8349 | 105260 | 5090346500
- Kern County, CA | 6274 | 91571 | 4186379300
- Sonoma County, CA | 3042 | 47241 | 2564952800
- Ventura County, CA | 7966 | 97086 | 5743460000
Untitled
From Anonymous, 2 Days ago, written in Plain Text, viewed 3 times.
This paste will check out in 3 Weeks.
URL https://paste.intergen.online/view/74333e1e
Embed
Download Paste or View Raw
— Expand Paste to full width of browser