Skip to main content

Data Dictionary

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.

USPS Address Change AttributesView Source Documentation

PUBLIC_DATA.USPS_ADDRESS_CHANGE_ATTRIBUTES: Aggregated inbound and outbound change of address requests at the zip code level, including request type (temporary or permanent) and historical values, provided by the USPS.

USPS Address Change Attributes Point-in-Time HistoryView Source Documentation

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

USPS Address Change TimeseriesView Source Documentation

PUBLIC_DATA.USPS_ADDRESS_CHANGE_TIMESERIES: Aggregated inbound and outbound change of address requests at the zip code level, including request type (temporary or permanent) and historical values, provided by the USPS.

USPS Address Change Timeseries Point-in-Time HistoryView Source Documentation

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