🔤 econ_reference

Reference and dimension tables for U.S. economic data. Contains lookup tables for BLS series codes, geographic mappings, industry classifications, and metadata catalogs for FRED, NIPA, and BEA Regional datasets. These tables should be loaded before the main econ schema as they provide dimension data for enriched views and semantic queries.

7 datasets · 33 columns

jolts_industries · table

JOLTS industry code reference table from BLS. Maps industry codes to human-readable industry names for JOLTS data (jolts_regional, jolts_state tables). Essential dimension table for decoding JOLTS industry classifications.

Column	Type	Null	Description
industry_code	string	yes	JOLTS industry code
industry_name	string	yes	Industry name

jolts_dataelements · table

JOLTS data element code reference table from BLS. Maps metric codes (JOR, HIR, QUR, TSR, LDR) to descriptions (Job Openings Rate, Hires Rate, etc.). Essential dimension table for understanding JOLTS metrics in jolts_regional and jolts_state tables.

Column	Type	Null	Description
dataelement_code	string	yes	JOLTS data element code
dataelement_text	string	yes	Data element description

bls_geographies · table

BLS geography reference table mapping state abbreviations to FIPS codes, census regions, metro areas, and BLS-specific area codes. Consolidates STATE_FIPS_MAP, CENSUS_REGIONS, METRO_AREA_CODES, METRO_CPI_CODES, and METRO_BLS_AREA_CODES into a single catalog-driven table. Enables dynamic geography lookups without hardcoded maps.

Column	Type	Null	Description
geo_code	string	no	Primary geography code (state abbreviation, metro code like 'A100', or region code)
geo_name	string	yes	Geography name (e.g., 'California', 'New York-Newark-Jersey City, NY-NJ-PA', 'Northeast')
geo_type	string	no	Geography type: 'state', 'metro', 'region'
state_fips	string	yes	2-digit state FIPS code (e.g., '06' for CA, '36' for NY). NULL for regions.
region_code	string	yes	4-digit census region code for regions (e.g., '0100' for Northeast). NULL for states/metros.
metro_publication_code	string	yes	BLS publication code for metro areas (e.g., 'A100' for NYC). NULL for states/regions.
metro_cpi_area_code	string	yes	CPI area code for metro CPI series (e.g., 'S35D' for NYC). NULL if metro lacks CPI data or for states/regions.
metro_bls_area_code	string	yes	7-digit BLS area code for metro employment series (state FIPS + 5-digit area code, e.g., '3693561' for NYC). NULL for states/regions.
cbsa_code	string	yes	5-digit OMB Core Based Statistical Area code (e.g., '35620' for NYC). NULL for states/regions. Enables joins to geo.cbsa for geographic boundaries.

naics_sectors · table

BLS NAICS supersector reference table mapping supersector codes to industry names. Consolidates NAICS_SUPERSECTORS hardcoded map. Used for state_industry_employment, metro_industry_employment, and other industry-based BLS series.

Column	Type	Null	Description
supersector_code	string	no	8-digit NAICS supersector code (e.g., '00000000' for total nonfarm, '05000000' for construction)
supersector_name	string	no	Industry supersector name (e.g., 'Total Nonfarm', 'Construction', 'Manufacturing')

nipa_tables · table

BEA NIPA (National Income and Product Accounts) table reference catalog: maps each NIPA table_name code (e.g., 'T10105', 'T20100') to its BEA description. Static lookup only (table_name, description columns, no year/time dimension), downloaded early to enable dynamic discovery of available NIPA tables before the main NIPA data pull.

Column	Type	Null	Description
table_name	string	yes	NIPA table code (e.g., 'T10105', 'T20100')
description	string	yes	Full table description from BEA including frequency indicators (A, Q)

regional_linecodes · table

BEA Regional dataset LineCode catalog. Maps table-specific line codes (key) to their descriptions (desc) for the 56 tracked BEA Regional tables (SAINC, SQINC, CAINC, SAGDP, SQGDP, CAGDP series). Each Regional table has its own set of valid LineCodes, so this catalog is fetched first (one API call per tablename) to enable complete regional data collection without hardcoded LineCode limitations.

Column	Type	Null	Description
key	string	yes	Line code identifier from BEA API (e.g., '10', '20', '30')
desc	string	yes	Line code description from BEA API (e.g., 'Personal income', 'Compensation of employees')

fred_series · table

FRED series discovery/metadata catalog: series id, title, observation date range (observation_start/observation_end), frequency, units, seasonal adjustment, last-updated timestamp, and popularity scores — one row per series, partitioned by category (7 top-level FRED categories: Production & Business Activity, Population/Employment/Labor Markets, National Accounts, Prices, Discontinued/Legacy, Money/Banking/Finance, International Data; up to 1000 series fetched per category). This is a lookup/discovery catalog only, not observation data — see econ.fred_indicators for the curated ~48-series time series values (enumerated in that table's series column comment).

Column	Type	Null	Description
series	string	yes	Unique FRED series identifier (e.g. 'UNRATE', 'GDP'). This is the catalog of everything FRED publishes, so use it to decode or discover series; the econ.fred_indicators observations table loads only a curated 48-series subset, enumerated in that table's series column comment.
title	string	yes	Full descriptive title of the economic data series
observation_start	string	yes	Date of first available observation (ISO 8601 format)
observation_end	string	yes	Date of most recent observation (ISO 8601 format)
frequency	string	yes	Data frequency (e.g., 'Daily', 'Monthly', 'Quarterly', 'Annual')
frequency_short	string	yes	Abbreviated frequency code (e.g., 'D', 'M', 'Q', 'A')
units	string	yes	Units of measurement (e.g., 'Percent', 'Billions of Dollars')
units_short	string	yes	Abbreviated units code
seasonal_adjustment	string	yes	Seasonal adjustment status (e.g., 'Seasonally Adjusted', 'Not Seasonally Adjusted')
seasonal_adjustment_short	string	yes	Abbreviated seasonal adjustment code (e.g., 'SA', 'NSA')
last_updated	string	yes	Timestamp of last data update (ISO 8601 format)
popularity	int	yes	FRED popularity score indicating usage/interest level
group_popularity	int	yes	Popularity score within category group
notes	string	yes	Detailed description, methodology, and source information