Data Dictionary
American Community Survey (ACS) Population AttributesView Source Documentation
PUBLIC_DATA.AMERICAN_COMMUNITY_SURVEY_ATTRIBUTES: Population variables covering demographic, social, economic, and housing trends in the US, releasing 1-year and 5-year estimates annually.
American Community Survey (ACS) Population Attributes Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.AMERICAN_COMMUNITY_SURVEY_ATTRIBUTES_PIT: Tracks history of the american_community_survey_attributes table with start and end timestamps to indicate row validity periods.
American Community Survey (ACS) Population TimeseriesView Source Documentation
PUBLIC_DATA.AMERICAN_COMMUNITY_SURVEY_TIMESERIES: Annual population estimates with detailed demographic, social, economic, and housing data at multiple geographic levels, from national to census block group.
Financial & Economic Indicators AttributesView Source Documentation
PUBLIC_DATA.FINANCIAL_ECONOMIC_INDICATORS_ATTRIBUTES: Economic metrics including retail sales, consumer credit, mortgage rates, unemployment claims, GDP estimates, employment, and CPI data for various geographic entities, aggregated from various government sources.
Financial & Economic Indicators Attributes Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.FINANCIAL_ECONOMIC_INDICATORS_ATTRIBUTES_PIT: Tracks history of the financial_economic_indicators_attributes table with start and end timestamps to indicate row validity periods.
Financial & Economic Indicators TimeseriesView Source Documentation
PUBLIC_DATA.FINANCIAL_ECONOMIC_INDICATORS_TIMESERIES: Economic metrics including retail sales, consumer credit, mortgage rates, unemployment claims, GDP estimates, employment, and CPI data for various geographic entities, aggregated from various government sources.
Financial & Economic Indicators Timeseries Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.FINANCIAL_ECONOMIC_INDICATORS_TIMESERIES_PIT: Tracks history of the financial_economic_indicators_timeseries table with start and end timestamps to indicate row validity periods.
Geographic Entity CharacteristicsView Source Documentation
PUBLIC_DATA.GEOGRAPHY_CHARACTERISTICS: Repository of geography characteristics, including GEOJSON coordinates, WKT coordinates, state abbreviations, and FIPS codes.
Geographic Entity Characteristics Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.GEOGRAPHY_CHARACTERISTICS_PIT: Tracks history of the geography_characteristics table with start and end timestamps to indicate row validity periods.
Geographic Entity HierarchiesView Source Documentation
PUBLIC_DATA.GEOGRAPHY_HIERARCHY: Hierarchical relationships between geographic entities, such as countries, states, and counties.
Geographic Entity Hierarchies Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.GEOGRAPHY_HIERARCHY_PIT: Tracks history of the geography_hierarchy table with start and end timestamps to indicate row validity periods.
Geography IndexView Source Documentation
PUBLIC_DATA.GEOGRAPHY_INDEX: Snowflake Public Data unified geographic entity index, joinable to all tables, providing unique geographic identifiers with associated names, levels, and ISO codes for various US geographies.
Geographic Entity Index Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.GEOGRAPHY_INDEX_PIT: Tracks history of the geography_index table with start and end timestamps to indicate row validity periods.
Geographic Entity OverlapsView Source Documentation
PUBLIC_DATA.GEOGRAPHY_OVERLAPS: Geographic relationships between overlapping regions, such as counties and zip codes, identified by unique GEO_IDs.
Geographic Entity Overlaps Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.GEOGRAPHY_OVERLAPS_PIT: Tracks history of the geography_overlaps table with start and end timestamps to indicate row validity periods.
Geographic Entity RelationshipsView Source Documentation
PUBLIC_DATA.GEOGRAPHY_RELATIONSHIPS: Relationships between geographic entities of differing levels, including overlaps and contains relationships, using Snowflake Public Data GEO_IDs.
Geographic Entity Relationships Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.GEOGRAPHY_RELATIONSHIPS_PIT: Tracks history of the geography_relationships table with start and end timestamps to indicate row validity periods.
NAICS Code IndexView Source Documentation
PUBLIC_DATA.NAICS_CODE_INDEX: Index table of NAICS codes with industry definitions and classification year.
NPPES Provider Addresses IndexView Source Documentation
PUBLIC_DATA.NPPES_PROVIDER_ADDRESSES: Addresses and contact information associated with a particular provider by NPI.
US Addresses IndexView Source Documentation
PUBLIC_DATA.US_ADDRESSES: Comprehensive US address data, including geographic information, latitude/longitude coordinates, and address specifics, mapped to a unique ADDRESS_ID for each address.
US Addresses Index Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.US_ADDRESSES_PIT: Tracks history of the us_addresses table with start and end timestamps to indicate row validity periods.
US Economic Census AttributesView Source Documentation
PUBLIC_DATA.US_ECONOMIC_CENSUS_ATTRIBUTES: Detailed economic data on US businesses, such as number of establishments, types of goods and services provided, employment figures, payroll expenses, and operational costs, across different industries and geographic regions.
US Economic Census Attributes Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.US_ECONOMIC_CENSUS_ATTRIBUTES_PIT: Tracks history of the us_economic_census_attributes table with start and end timestamps to indicate row validity periods.
US Economic Census TimeseriesView Source Documentation
PUBLIC_DATA.US_ECONOMIC_CENSUS_TIMESERIES: Detailed economic data on US businesses, such as number of establishments, types of goods and services provided, employment figures, payroll expenses, and operational costs, across different industries and geographic regions.
US Economic Census Timeseries Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.US_ECONOMIC_CENSUS_TIMESERIES_PIT: Tracks history of the us_economic_census_attributes table with start and end timestamps to indicate row validity periods.
US Real Estate Indicators AttributesView Source Documentation
PUBLIC_DATA.US_REAL_ESTATE_ATTRIBUTES: Construction and real estate data, including new building permits and construction spending, categorized into residential, non-residential, and public sectors, provided by the US Census Bureau.
US Real Estate Indicators Attributes Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.US_REAL_ESTATE_ATTRIBUTES_PIT: Tracks history of the us_real_estate_attributes table with start and end timestamps to indicate row validity periods.
US Real Estate Indicators TimeseriesView Source Documentation
PUBLIC_DATA.US_REAL_ESTATE_TIMESERIES: Construction and real estate data, including new building permits and construction spending, categorized into residential, non-residential, and public sectors, provided by the US Census Bureau.
US Real Estate Indicators Timeseries Point-in-Time HistoryView Source Documentation
PUBLIC_DATA.US_REAL_ESTATE_TIMESERIES_PIT: Tracks history of the us_real_estate_timeseries table with start and end timestamps to indicate row validity periods.