Schema: economic_data
This schema houses an economic datamart built from multiple public data sources. The data is modeled in a traditional star schema and also provided as a denormalized ‘one-big-table’ view for simplified analytics.
Tables:
- fact_zip_naics_establishments
- wide_zip_naics_establishments
Views
- dim_geography_zip
- dim_industry_naics
Schema: industry_code
This schema holds reference data that can be useful in its own right as well as joined to our star schemas to provide descriptions and additional details.
Tables:
- naics_1997
- naics_2002
- naics_2007
- naics_2012
- naics_2017
- naics_2022
- sic
- sic_to_naics
Views:
- naics
- naics_sector
- naics_subsector
- naics_industry_group
- naics_industry
- naics_national_industry
- naics_hierarchy
- naics_change_over_time