🔤 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 with section categorization. NIPA tables are organized into 8 sections: 1=Domestic Product & Income, 2=Personal Income & Outlays, 3=Government, 4=Foreign Transactions, 5=Saving & Investment, 6=Industry, 7=Supplemental, 8=Not Seasonally Adjusted. Downloaded early to enable dynamic table discovery and complete NIPA data collection.

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 to their descriptions for all 67 Regional tables (SAINC, SQINC, CAINC, SAGDP, SQGDP, CAGDP, etc.). Each BEA Regional table has its own set of valid LineCodes - this catalog is downloaded first to enable complete regional data collection without hardcoded 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

Complete FRED economic data series catalog with 841,000+ series partitioned by category/frequency/source/status. Status partition separates 'active' (currently updated) from 'discontinued' (no longer updated) series. Includes series metadata, categories, descriptions, units, frequency, and search capabilities. Enables efficient querying for either current data or historical analysis with partitions for major economic categories (national_accounts, labor_markets, finance, prices, etc.). Updated daily from FRED API with comprehensive coverage of all available economic time series for discovery and programmatic access.

Column	Type	Null	Description
series	string	yes	Unique FRED series identifier (e.g., 'UNRATE', 'GDP')
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