Schema Reference

Detailed column descriptions for all four Census LEHD LODES data tables. Column descriptions are sourced from dbt schema.yml and pushed to Snowflake as native column comments via persist_docs.

OD (Origin-Destination)

Block-to-block commute flows. Each row represents a unique home-block to work-block pair for a given year and part (main/aux).

Primary Key: w_geocode + h_geocode + year + part Row Count: 2.6 billion Join to XWALK: w_geocode = tabblk2020 (workplace) or h_geocode = tabblk2020 (residence)

Column	Type	Description
w_geocode	VARCHAR	Workplace Census Block Code (2020, 15-digit FIPS)
h_geocode	VARCHAR	Residence Census Block Code (2020, 15-digit FIPS)
year	NUMBER	Reference year for the employment data (2002-2023)
part	VARCHAR	File part: 'main' (both residence and workplace in same state) or 'aux' (workplace in state, residence elsewhere)
S000	NUMBER	Total number of jobs in this commute flow
SA01	NUMBER	Number of jobs for workers age 29 or younger
SA02	NUMBER	Number of jobs for workers age 30 to 54
SA03	NUMBER	Number of jobs for workers age 55 or older
SE01	NUMBER	Number of jobs with earnings $1,250/month or less
SE02	NUMBER	Number of jobs with earnings $1,251 to $3,333/month
SE03	NUMBER	Number of jobs with earnings greater than $3,333/month
SI01	NUMBER	Number of jobs in Goods Producing industry sectors (NAICS 11-33)
SI02	NUMBER	Number of jobs in Trade, Transportation, and Utilities (NAICS 42-49)
SI03	NUMBER	Number of jobs in All Other Services (NAICS 51-92)
state_fips	VARCHAR	State FIPS code derived from workplace block (first 2 digits of w_geocode)
feed_id	VARCHAR	FK to FEEDS — identifies which dataset this row belongs to
feeds_files_id	VARCHAR	FK to FEEDS_FILES — identifies which batch loaded this data
created_at	TIMESTAMP	When the source data was loaded into the warehouse
updated_at	TIMESTAMP	When dbt last rebuilt this table

OD Column Groups

Group	Columns	What They Measure
Age	SA01, SA02, SA03	Workers by age bracket (≤29, 30-54, 55+)
Earnings	SE01, SE02, SE03	Workers by monthly earnings bracket
Industry	SI01, SI02, SI03	Workers by broad NAICS industry sector

---

RAC (Residence Area Characteristics)

Jobs by where workers live. Each row is a Census block where workers reside, with 42 demographic breakdown columns covering age, earnings, industry, race, ethnicity, education, and sex.

Primary Key: h_geocode + year Row Count: 119 million Join to XWALK: h_geocode = tabblk2020

Column	Type	Description
h_geocode	VARCHAR	Residence Census Block Code (2020, 15-digit FIPS)
year	NUMBER	Reference year for the employment data (2002-2023)
C000	NUMBER	Total number of jobs for workers residing in this block
CA01	NUMBER	Workers age 29 or younger
CA02	NUMBER	Workers age 30 to 54
CA03	NUMBER	Workers age 55 or older
CE01	NUMBER	Workers earning $1,250/month or less
CE02	NUMBER	Workers earning $1,251 to $3,333/month
CE03	NUMBER	Workers earning greater than $3,333/month
CNS01	NUMBER	Workers in Agriculture, Forestry, Fishing and Hunting (NAICS 11)
CNS02	NUMBER	Workers in Mining, Quarrying, and Oil and Gas Extraction (NAICS 21)
CNS03	NUMBER	Workers in Utilities (NAICS 22)
CNS04	NUMBER	Workers in Construction (NAICS 23)
CNS05	NUMBER	Workers in Manufacturing (NAICS 31-33)
CNS06	NUMBER	Workers in Wholesale Trade (NAICS 42)
CNS07	NUMBER	Workers in Retail Trade (NAICS 44-45)
CNS08	NUMBER	Workers in Transportation and Warehousing (NAICS 48-49)
CNS09	NUMBER	Workers in Information (NAICS 51)
CNS10	NUMBER	Workers in Finance and Insurance (NAICS 52)
CNS11	NUMBER	Workers in Real Estate and Rental and Leasing (NAICS 53)
CNS12	NUMBER	Workers in Professional, Scientific, and Technical Services (NAICS 54)
CNS13	NUMBER	Workers in Management of Companies and Enterprises (NAICS 55)
CNS14	NUMBER	Workers in Administrative and Support and Waste Management (NAICS 56)
CNS15	NUMBER	Workers in Educational Services (NAICS 61)
CNS16	NUMBER	Workers in Health Care and Social Assistance (NAICS 62)
CNS17	NUMBER	Workers in Arts, Entertainment, and Recreation (NAICS 71)
CNS18	NUMBER	Workers in Accommodation and Food Services (NAICS 72)
CNS19	NUMBER	Workers in Other Services except Public Administration (NAICS 81)
CNS20	NUMBER	Workers in Public Administration (NAICS 92)
CR01	NUMBER	Workers identifying as White, Alone
CR02	NUMBER	Workers identifying as Black or African American, Alone
CR03	NUMBER	Workers identifying as American Indian or Alaska Native, Alone
CR04	NUMBER	Workers identifying as Asian, Alone
CR05	NUMBER	Workers identifying as Native Hawaiian or Other Pacific Islander, Alone
CR07	NUMBER	Workers identifying as Two or More Race Groups
CT01	NUMBER	Workers who are Not Hispanic or Latino
CT02	NUMBER	Workers who are Hispanic or Latino
CD01	NUMBER	Workers with Less than High School education
CD02	NUMBER	Workers with High School or Equivalent, No College
CD03	NUMBER	Workers with Some College or Associate Degree
CD04	NUMBER	Workers with Bachelor's Degree or Advanced Degree
CS01	NUMBER	Workers who are Male
CS02	NUMBER	Workers who are Female
state_fips	VARCHAR	State FIPS code derived from residence block (first 2 digits of h_geocode)
feed_id	VARCHAR	FK to FEEDS — identifies which dataset this row belongs to
feeds_files_id	VARCHAR	FK to FEEDS_FILES — identifies which batch loaded this data
created_at	TIMESTAMP	When the source data was loaded into the warehouse
updated_at	TIMESTAMP	When dbt last rebuilt this table

RAC Column Groups

Group	Columns	What They Measure
Total	C000	Total jobs at residence block
Age	CA01-CA03	Workers by age bracket (≤29, 30-54, 55+)
Earnings	CE01-CE03	Workers by monthly earnings bracket
Industry	CNS01-CNS20	Workers by 2-digit NAICS sector (20 sectors)
Race	CR01-CR05, CR07	Workers by race category (6 categories)
Ethnicity	CT01-CT02	Workers by Hispanic/Latino status
Education	CD01-CD04	Workers by educational attainment
Sex	CS01-CS02	Workers by sex

---

WAC (Workplace Area Characteristics)

Jobs by where people work. Identical demographic columns to RAC plus firm age (CFA) and firm size (CFS) columns not available in RAC.

Primary Key: w_geocode + year Row Count: 48.5 million Join to XWALK: w_geocode = tabblk2020

Column	Type	Description
w_geocode	VARCHAR	Workplace Census Block Code (2020, 15-digit FIPS)
year	NUMBER	Reference year for the employment data (2002-2023)
C000	NUMBER	Total number of jobs at this workplace block
CA01	NUMBER	Workers age 29 or younger
CA02	NUMBER	Workers age 30 to 54
CA03	NUMBER	Workers age 55 or older
CE01	NUMBER	Workers earning $1,250/month or less
CE02	NUMBER	Workers earning $1,251 to $3,333/month
CE03	NUMBER	Workers earning greater than $3,333/month
CNS01	NUMBER	Jobs in Agriculture, Forestry, Fishing and Hunting (NAICS 11)
CNS02	NUMBER	Jobs in Mining, Quarrying, and Oil and Gas Extraction (NAICS 21)
CNS03	NUMBER	Jobs in Utilities (NAICS 22)
CNS04	NUMBER	Jobs in Construction (NAICS 23)
CNS05	NUMBER	Jobs in Manufacturing (NAICS 31-33)
CNS06	NUMBER	Jobs in Wholesale Trade (NAICS 42)
CNS07	NUMBER	Jobs in Retail Trade (NAICS 44-45)
CNS08	NUMBER	Jobs in Transportation and Warehousing (NAICS 48-49)
CNS09	NUMBER	Jobs in Information (NAICS 51)
CNS10	NUMBER	Jobs in Finance and Insurance (NAICS 52)
CNS11	NUMBER	Jobs in Real Estate and Rental and Leasing (NAICS 53)
CNS12	NUMBER	Jobs in Professional, Scientific, and Technical Services (NAICS 54)
CNS13	NUMBER	Jobs in Management of Companies and Enterprises (NAICS 55)
CNS14	NUMBER	Jobs in Administrative and Support and Waste Management (NAICS 56)
CNS15	NUMBER	Jobs in Educational Services (NAICS 61)
CNS16	NUMBER	Jobs in Health Care and Social Assistance (NAICS 62)
CNS17	NUMBER	Jobs in Arts, Entertainment, and Recreation (NAICS 71)
CNS18	NUMBER	Jobs in Accommodation and Food Services (NAICS 72)
CNS19	NUMBER	Jobs in Other Services except Public Administration (NAICS 81)
CNS20	NUMBER	Jobs in Public Administration (NAICS 92)
CR01	NUMBER	Workers who are White, Alone
CR02	NUMBER	Workers who are Black or African American, Alone
CR03	NUMBER	Workers who are American Indian or Alaska Native, Alone
CR04	NUMBER	Workers who are Asian, Alone
CR05	NUMBER	Workers who are Native Hawaiian or Other Pacific Islander, Alone
CR07	NUMBER	Workers who are Two or More Race Groups
CT01	NUMBER	Workers who are Not Hispanic or Latino
CT02	NUMBER	Workers who are Hispanic or Latino
CD01	NUMBER	Workers with Less than High School education
CD02	NUMBER	Workers with High School or Equivalent, No College
CD03	NUMBER	Workers with Some College or Associate Degree
CD04	NUMBER	Workers with Bachelor's Degree or Advanced Degree
CS01	NUMBER	Workers who are Male
CS02	NUMBER	Workers who are Female
CFA01	NUMBER	Jobs at firms age 0-1 years
CFA02	NUMBER	Jobs at firms age 2-3 years
CFA03	NUMBER	Jobs at firms age 4-5 years
CFA04	NUMBER	Jobs at firms age 6-10 years
CFA05	NUMBER	Jobs at firms age 11 or more years
CFS01	NUMBER	Jobs at firms with 0-19 employees
CFS02	NUMBER	Jobs at firms with 20-49 employees
CFS03	NUMBER	Jobs at firms with 50-249 employees
CFS04	NUMBER	Jobs at firms with 250-499 employees
CFS05	NUMBER	Jobs at firms with 500+ employees
state_fips	VARCHAR	State FIPS code derived from workplace block (first 2 digits of w_geocode)
feed_id	VARCHAR	FK to FEEDS — identifies which dataset this row belongs to
feeds_files_id	VARCHAR	FK to FEEDS_FILES — identifies which batch loaded this data
created_at	TIMESTAMP	When the source data was loaded into the warehouse
updated_at	TIMESTAMP	When dbt last rebuilt this table

WAC Column Groups

Group	Columns	What They Measure
Total	C000	Total jobs at workplace block
Age	CA01-CA03	Workers by age bracket (≤29, 30-54, 55+)
Earnings	CE01-CE03	Workers by monthly earnings bracket
Industry	CNS01-CNS20	Jobs by 2-digit NAICS sector (20 sectors)
Race	CR01-CR05, CR07	Workers by race category (6 categories)
Ethnicity	CT01-CT02	Workers by Hispanic/Latino status
Education	CD01-CD04	Workers by educational attainment
Sex	CS01-CS02	Workers by sex
Firm Age	CFA01-CFA05	Jobs by firm age (WAC only)
Firm Size	CFS01-CFS05	Jobs by firm employee count (WAC only)

WAC vs RAC: What's Different?

WAC includes 10 additional columns not found in RAC:

WAC-Only Columns	Description
CFA01-CFA05	Firm age distribution (0-1, 2-3, 4-5, 6-10, 11+ years)
CFS01-CFS05	Firm size distribution (0-19, 20-49, 50-249, 250-499, 500+ employees)

WAC also uses noise infusion (not synthetic data), making it reliable at lower block-level counts (10+ jobs) compared to OD and RAC which use synthetic data generation.

---

XWALK (Geographic Crosswalk)

Reference table mapping every 2020 Census block to higher geographies. This is the aggregation enabler — JOIN OD/RAC/WAC to XWALK to roll up block-level data to any geographic level.

Primary Key: tabblk2020 Row Count: 8.2 million Always fully available — no trial limit (essential for any analysis)

Column	Type	Description
tabblk2020	VARCHAR	2020 Census Tabulation Block Code (15-digit FIPS, primary key)
st	VARCHAR	FIPS State Code (2-digit)
stname	VARCHAR	State Name
cty	VARCHAR	FIPS County Code (5-digit: state + county)
ctyname	VARCHAR	County Name
trct	VARCHAR	Census Tract Code (11-digit)
trctname	VARCHAR	Census Tract Name
bgrp	VARCHAR	Block Group Code (12-digit)
bgrpname	VARCHAR	Block Group Name
cbsa	VARCHAR	Core Based Statistical Area (Metropolitan/Micropolitan) Code
cbsaname	VARCHAR	CBSA Name
zcta	VARCHAR	ZIP Code Tabulation Area (5-digit)
zctaname	VARCHAR	ZCTA Name
stplc	VARCHAR	State + Place FIPS Code (7-digit)
stplcname	VARCHAR	Census Place Name (city/town)
ctycsub	VARCHAR	County Subdivision FIPS Code
ctycsubname	VARCHAR	County Subdivision Name
stcd119	VARCHAR	Congressional District Code (119th Congress)
stcd119name	VARCHAR	Congressional District Name (119th Congress)
stsldl	VARCHAR	State Legislative District (Lower Chamber) Code
stsldlname	VARCHAR	State Legislative District (Lower Chamber) Name
stsldu	VARCHAR	State Legislative District (Upper Chamber) Code
stslduname	VARCHAR	State Legislative District (Upper Chamber) Name
stusps	VARCHAR	State USPS abbreviation (e.g., CA, NY)
stschool	VARCHAR	School District Code
stschoolname	VARCHAR	School District Name
stsecon	VARCHAR	State Economic Area Code
stseconname	VARCHAR	State Economic Area Name
trib	VARCHAR	Tribal Area Code
tribname	VARCHAR	Tribal Area Name
tsub	VARCHAR	Tribal Subdivision Code
tsubname	VARCHAR	Tribal Subdivision Name
stanrc	VARCHAR	Alaska Native Regional Corporation Code
stanrcname	VARCHAR	Alaska Native Regional Corporation Name
mil	VARCHAR	Military Installation Code
milname	VARCHAR	Military Installation Name
stwib	VARCHAR	Workforce Innovation Board Area Code
stwibname	VARCHAR	Workforce Innovation Board Area Name
blklatdd	FLOAT	Block internal point latitude (decimal degrees, WGS84)
blklondd	FLOAT	Block internal point longitude (decimal degrees, WGS84)
createdate	VARCHAR	Date the crosswalk record was created by Census
feed_id	VARCHAR	FK to FEEDS — identifies which dataset this row belongs to
feeds_files_id	VARCHAR	FK to FEEDS_FILES — identifies which batch loaded this data
created_at	TIMESTAMP	When the source data was loaded into the warehouse
updated_at	TIMESTAMP	When dbt last rebuilt this table

XWALK Geography Levels

Level	Code Column	Name Column	Digit Count	Example
State	st	stname	2	06 = California
County	cty	ctyname	5	06037 = Los Angeles County
Tract	trct	trctname	11	06037264000
Block Group	bgrp	bgrpname	12	060372640001
Block	tabblk2020	—	15	060372640001001
Metro (CBSA)	cbsa	cbsaname	5	31080 = Los Angeles-Long Beach
ZCTA	zcta	zctaname	5	90210
Place	stplc	stplcname	7	0644000 = Los Angeles city
Congressional District	stcd119	stcd119name	4	0634 = CA-34
School District	stschool	stschoolname	varies	School district boundaries
Workforce Board	stwib	stwibname	varies	Workforce Innovation areas
Tribal Area	trib	tribname	varies	Tribal statistical areas
Military Installation	mil	milname	varies	Military base boundaries
Coordinates	blklatdd, blklondd	—	decimal	34.0522, -118.2437