NPPES Provider Addresses

Snowflake table name : CYBERSYN.NPPES_PROVIDER_ADDRESSES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
NPI	National Provider Identifier, which is a unique id assigned to a provider by the CMS National Plan and Provider Enumeration System	NUMBER	1376208298
ADDRESS_TYPE	Type of address: mailing, primary practice, secondary practice	VARCHAR	Primary Practice
ADDRESS_FIRST_LINE	First line of address	VARCHAR	3400 SPRUCE ST
ADDRESS_SECOND_LINE	Second line of address	VARCHAR	SUITE 250
CITY	City or town of address	VARCHAR	MEMPHIS
STATE	State or US territory the address is located in	VARCHAR	MN
ZIP_CODE	Zip code of the address	VARCHAR	45840
COUNTRY_CODE	Two letter country code of the address	VARCHAR	US
TELEPHONE	Telephone number associated with the address	ARRAY	[ "9095620012" ]
FAX	Fax number	ARRAY	[ "6177736606" ]
EMAIL	Email address	ARRAY	[ "[e-mail]" ]
GEO_ID_ZIP	Unique zip code geographic identifier joinable to the geography_index	VARCHAR	zip/21207
GEO_ID_CITY	Unique city geographic identifier joinable to the geography_index	VARCHAR	geoId/5363000
GEO_ID_STATE	Unique US state or territory geographic identifier joinable to the geography_index	VARCHAR	geoId/39
GEO_ID_COUNTRY	Unique country geographic identifier joinable to the geography_index	VARCHAR	country/USA