{"main_topic":"census","sub_topic":"acs","topic":"labor_force_by_nativity","key":"census/acs/labor_force_by_nativity","version":"1.0.0","year_min":2020,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"census/labor_force_by_nativity/year={year}/{detail}.parquet","grain":["year","county_fips","district_code","tract_geoid","citizenship_status"],"title":"Labor Force Status by Nativity (ACS)","summary":"How Georgia's native-born, foreign-born, naturalized and noncitizen residents 16 and over participate in the labor force - participation, employment and unemployment rates from ACS 5-year estimates for the state and its larger immigrant-receiving counties.","description":"Labor-force status of the population 16 years and over by nativity and citizenship from the American Community Survey 5-year estimates (subject table S0501, Selected Characteristics of the Native and Foreign-Born Populations - the EMPLOYMENT STATUS rows), for Georgia and the 20 to 24 counties the Census publishes it for, vintages 2020-2024: the population 16+ (a count) and its labor-force participation (the headline metric), civilian labor force, employed, unemployed, Armed Forces and not-in-labor-force shares plus the unemployment rate (a share of the civilian labor force), for the total, native, foreign-born, naturalized-citizen and noncitizen populations, each with its 90 percent margin of error.","source":"U.S. Census Bureau, American Community Survey 5-Year Estimates","source_url":"https://data.census.gov/table/ACSST5Y2024.S0501?g=040XX00US13","endpoint":"/api/v1/census/labor_force_by_nativity","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit county FIPS code (state 13 + county). Populated only on county-level rows; NULL on the state row. Only the 20 to 24 counties the Census publishes S0501 for appear (a foreign-born population threshold).","valid_values":null,"example":"13135","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","description":"Always NULL: this topic collects state and county geography only. The Census publishes S0501 for just 27 of Georgia's 182 unified school districts (2024 vintage), so the district level was not collected and no district rows are served. Kept for the census domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"Always NULL: S0501 is NULL at every census tract, so no tract rows are served. Kept for the census domain's standard key shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"citizenship_status","type":"string","role":"categorical","nullable":false,"label":"Citizenship Status","short_description":"Native vs foreign born, and the foreign born by citizenship; a hierarchy, never summed.","description":"Nativity and citizenship status. Hierarchical, not a partition: all = native + foreign_born, and foreign_born = naturalized + noncitizen, so the five values must never be summed. 'all' is the total row. The ACS asks citizenship, not legal status: noncitizen covers lawful permanent residents, temporary visa holders, and unauthorized migrants alike. In this topic the universe is the population 16 years and over (S0501 columns C01-C05, EMPLOYMENT STATUS rows).","valid_values":["all","native","foreign_born","naturalized","noncitizen"],"example":"foreign_born","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_population_16_plus","type":"integer","role":"metric","nullable":true,"label":"Number Population 16 Plus","short_description":"Estimated people 16 and over in the citizenship category - the base every share is a percent of.","description":"ACS 5-year estimate of the population 16 years and over in the citizenship_status category (S0501 row 'Population 16 years and over'), a count of persons. The denominator of labor_force_participation_rate and of every other share except unemployment_rate. The count the shares were computed from is unrounded; the published shares are rounded, so shares times this count are approximate.","valid_values":null,"example":1152869,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_population_16_plus_moe","type":"integer","role":"metric","nullable":true,"label":"Number Population 16 Plus Moe","short_description":"","description":"90 percent margin of error for num_population_16_plus, as published (integer persons). Never the headline metric.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"labor_force_participation_rate","type":"number","role":"metric","nullable":true,"label":"Labor Force Participation Rate","short_description":"Share of people 16+ who are working or looking for work (civilian labor force plus Armed Forces).","description":"Labor-force participation: the share of the population 16 and over that is in the labor force - employed, unemployed and looking, or in the Armed Forces (S0501 row 'In labor force'). Equals pct_civilian_labor_force + pct_armed_forces and 1 - pct_not_in_labor_force, within rounding. Published as a one-decimal percent of the population 16 and over and served as a proportion (divided by 100). Do not multiply by num_population_16_plus to rebuild a headcount - the rounding makes such counts false precision. The numerator count is not published, so only the denominator is served.","valid_values":null,"example":0.712,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"labor_force_participation_rate_moe","type":"number","role":"metric","nullable":true,"label":"Labor Force Participation Rate Moe","short_description":"","description":"90 percent margin of error for labor_force_participation_rate, in the same unit as the estimate (a proportion: published percentage points divided by 100). Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_civilian_labor_force","type":"number","role":"metric","nullable":true,"label":"Percent Civilian Labor Force","short_description":"Share of people 16+ in the civilian labor force (employed plus unemployed, excluding Armed Forces).","description":"Share of the population 16 and over in the civilian labor force - employed or unemployed, excluding the Armed Forces (S0501 row 'Civilian labor force'). Equals pct_employed + pct_unemployed within rounding, and is the base of unemployment_rate. Published as a one-decimal percent of the population 16 and over and served as a proportion (divided by 100). Do not multiply by num_population_16_plus to rebuild a headcount - the rounding makes such counts false precision.","valid_values":null,"example":0.71,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_civilian_labor_force_moe","type":"number","role":"metric","nullable":true,"label":"Percent Civilian Labor Force Moe","short_description":"","description":"90 percent margin of error for pct_civilian_labor_force, in the same unit as the estimate (a proportion: published percentage points divided by 100). Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_employed","type":"number","role":"metric","nullable":true,"label":"Percent Employed","short_description":"Share of people 16+ who are employed (the employment-to-population ratio).","description":"Share of the population 16 and over that is employed in the civilian labor force (S0501 row 'Employed') - the employment-to-population ratio, not the share of the labor force that has a job. Published as a one-decimal percent of the population 16 and over and served as a proportion (divided by 100). Do not multiply by num_population_16_plus to rebuild a headcount - the rounding makes such counts false precision.","valid_values":null,"example":0.683,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_employed_moe","type":"number","role":"metric","nullable":true,"label":"Percent Employed Moe","short_description":"","description":"90 percent margin of error for pct_employed, in the same unit as the estimate (a proportion: published percentage points divided by 100). Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_unemployed","type":"number","role":"metric","nullable":true,"label":"Percent Unemployed","short_description":"Share of ALL people 16+ who are unemployed - smaller than the unemployment rate, which is a share of the labor force.","description":"Share of the population 16 and over that is unemployed - without a job, available, and actively looking (S0501 row 'Unemployed') - as a share of everyone 16+, NOT of the labor force. For the conventional unemployment rate use unemployment_rate, which divides by the civilian labor force instead. Published as a one-decimal percent of the population 16 and over and served as a proportion (divided by 100). Do not multiply by num_population_16_plus to rebuild a headcount - the rounding makes such counts false precision.","valid_values":null,"example":0.027,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_unemployed_moe","type":"number","role":"metric","nullable":true,"label":"Percent Unemployed Moe","short_description":"","description":"90 percent margin of error for pct_unemployed, in the same unit as the estimate (a proportion: published percentage points divided by 100). Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"unemployment_rate","type":"number","role":"metric","nullable":true,"label":"Unemployment Rate","short_description":"Unemployed as a share of the civilian labor force - the conventional unemployment rate.","description":"Unemployment rate: the unemployed as a proportion of the CIVILIAN LABOR FORCE, not of the population 16+ (S0501 row 'Unemployed - Percent of civilian labor force'). Served as published (one-decimal percent divided by 100), never recomputed from the rounded shares; it reproduces pct_unemployed / pct_civilian_labor_force within 0.002. Published zeros are real: a county subgroup with no unemployed respondents in the sample reports 0.0.","valid_values":null,"example":0.037,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"unemployment_rate_moe","type":"number","role":"metric","nullable":true,"label":"Unemployment Rate Moe","short_description":"","description":"90 percent margin of error for unemployment_rate, in the same unit as the estimate (a proportion: published percentage points divided by 100). Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_armed_forces","type":"number","role":"metric","nullable":true,"label":"Percent Armed Forces","short_description":"Share of people 16+ serving in the Armed Forces.","description":"Share of the population 16 and over in the Armed Forces (S0501 row 'Armed Forces'), the non-civilian part of the labor force. Published zeros are real (no Armed Forces respondents in the sample). Published as a one-decimal percent of the population 16 and over and served as a proportion (divided by 100). Do not multiply by num_population_16_plus to rebuild a headcount - the rounding makes such counts false precision.","valid_values":null,"example":0.003,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_armed_forces_moe","type":"number","role":"metric","nullable":true,"label":"Percent Armed Forces Moe","short_description":"","description":"90 percent margin of error for pct_armed_forces, in the same unit as the estimate (a proportion: published percentage points divided by 100). Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_not_in_labor_force","type":"number","role":"metric","nullable":true,"label":"Percent Not in Labor Force","short_description":"Share of people 16+ neither working nor looking for work (students, retirees, caregivers, others).","description":"Share of the population 16 and over not in the labor force - neither employed, unemployed and looking, nor in the Armed Forces: students, retirees, caregivers, the disabled, and discouraged workers (S0501 row 'Not in labor force'). Equals 1 - labor_force_participation_rate within rounding. Published as a one-decimal percent of the population 16 and over and served as a proportion (divided by 100). Do not multiply by num_population_16_plus to rebuild a headcount - the rounding makes such counts false precision.","valid_values":null,"example":0.288,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row: unpublished geographies are dropped, and S0501 carries no annotation sentinel in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_not_in_labor_force_moe","type":"number","role":"metric","nullable":true,"label":"Percent Not in Labor Force Moe","short_description":"","description":"90 percent margin of error for pct_not_in_labor_force, in the same unit as the estimate (a proportion: published percentage points divided by 100). Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Never NULL on a served row in vintages 2020-2024. A NULL margin beside a present estimate would be a controlled estimate (no sampling error published), never suppression.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"labor_force_participation_rate","usage":"Star-schema fact table at state and county grain, one row per year x geography x citizenship_status. Join the counties dimension on county_fips (NULL on the state row); district_code and tract_geoid are always NULL. Only the 20 to 24 counties the Census publishes appear - filter citizenship_status to one value and never sum across it. Read directly with DuckDB over Parquet.","limitations":"County coverage is PARTIAL: the Census publishes S0501 for only 20 to 24 of Georgia's 159 counties per vintage (22 in 2020, 20 in 2021, 23 in 2022, 24 in 2023, 24 in 2024) - the counties above a FOREIGN-BORN population threshold, not a total-population cut (2024 vintage: Bibb County, roughly 157,000 people, is unpublished; Barrow, roughly 90,000, is published) - and the published set shifts by vintage as counties cross it. Unpublished counties are absent from this table (not NULL, not zero, not imputed), so summing county rows never reproduces the state; the state row is always published; no school-district or tract geography is served at all. Statewide figures are complete; county figures cover metro Atlanta and the larger immigrant-receiving counties only. citizenship_status is a hierarchy, not a partition: all = native + foreign_born and foreign_born = naturalized + noncitizen, so never sum across it; the ACS asks citizenship, not legal status, so noncitizen covers lawful permanent residents, temporary visa holders, humanitarian migrants, and unauthorized migrants alike. num_population_16_plus is a count of persons; every other metric is a share published to one decimal percent and served as a proportion (three decimals). Do not multiply a share by the count to rebuild a headcount - the rounding makes such counts and their margins false precision - and note that unemployment_rate is a share of the CIVILIAN LABOR FORCE while pct_unemployed is a share of everyone 16 and over. ACS 5-year period estimates: the year column is the vintage END year and each estimate pools five years of survey responses (2024 = 2020-2024). Consecutive vintages share about 80% of their sample, so the series is heavily smoothed - never difference overlapping vintages as if they were annual change. Estimates are survey-based and carry 90% margins of error (the *_moe columns, in the same unit as their estimate); county margins on the citizenship subgroups reach 10 to 12 percentage points. State and county rows serve vintages 2020-2024 only: the state row has NULL county_fips, county rows carry county_fips, and district_code and tract_geoid are NULL on every row.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2020,2021,2022,2023,2024],"schema_hash":"4c1d485587fc0cffc681256ca2133068b0c56988b0d66fdecea73949e7787c92","tags":["census","u.s. census bureau, american community survey 5-year estimates","labor_force_by_nativity"],"granularity_description":"One row per year, county_fips, district_code, tract_geoid, citizenship_status (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM labor_force_by_nativity WHERE year = 2024 LIMIT 100"},{"description":"Filter by citizenship_status = foreign_born","query":"SELECT * FROM labor_force_by_nativity WHERE citizenship_status = 'foreign_born' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties","states"],"default":"counties"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"citizenship_status","kind":"categorical","column":"citizenship_status","type":"string","multi_value":true,"enum_enforced":true,"values":["all","native","foreign_born","naturalized","noncitizen"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]}],"filter_hints":[],"values_endpoint":"/api/v1/census/labor_force_by_nativity/values"}