Skip to main content

Data Dictionary

Data Commons AttributesView Source Documentation

PUBLIC_DATA.DATACOMMONS_ATTRIBUTES: Demographic, economic, government spending, and environmental statistics at national, state, county, and municipal levels, aggregated by Data Commons.

Data Commons Attributes Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.DATACOMMONS_ATTRIBUTES_PIT: Tracks history of the datacommons_attributes table with start and end timestamps to indicate row validity periods.

Data Commons TimeseriesView Source Documentation

PUBLIC_DATA.DATACOMMONS_TIMESERIES: Demographic, economic, government spending, and environmental statistics at national, state, county, and municipal levels, aggregated by Data Commons.

Data Commons Timeseries Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.DATACOMMONS_TIMESERIES_PIT: Tracks history of the datacommons_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.

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.