Skip to main content

Data Dictionary

Point of Interest Addresses RelationshipsView Source Documentation

PUBLIC_DATA.POINT_OF_INTEREST_ADDRESSES_RELATIONSHIPS: Map between Point of Interest (POI) identifiers and addresses found in US_ADDRESSES.

Point of Interest Addresses Relationships Point-in-Time HistoryView Source Documentation

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

Point of Interest IndexView Source Documentation

PUBLIC_DATA.POINT_OF_INTEREST_INDEX: Database of US points of interest (POIs), including names, detailed categorical information, and unique POI IDs for mapping to addresses.

Point of Interest Index Point-in-Time HistoryView Source Documentation

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

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.