US Addresses

Snowflake table name : CYBERSYN.US_ADDRESSES

View data source documentation here.

Name	Description	Type	Example
ADDRESS_ID	A unique identifier of an address based on street address that is joinable to the point_of_interest_addresses_relationships table.	VARCHAR	addressId/302aa86b4f62eeaaeb0831629ef9188e
ID_ZIP	A unique identifier for a zip code joinable to the geography_index/relationships tables	VARCHAR	zip/72023
ID_CITY	A unique identifier for a city joinable to the geography_index/relationships tables	VARCHAR	geoId/4284512
ID_STATE	A unique identifier for a state, Washington, D.C. or Puerto Rico joinable to the geography_index/relationships tables	VARCHAR	geoId/37
ID_COUNTRY	A unique identifier for a country joinable to the geography_index/relationships tables	VARCHAR	country/USA
LONGITUDE	longitude coordinate in degrees	FLOAT	-96.5475366
LATITUDE	latitude coordinate in degrees	FLOAT	40.3684996
NUMBER	number of the address identifying location on a street	VARCHAR	4344
STREET_DIRECTIONAL_PREFIX	a directional modifier preceding the street name, such as N or SW	VARCHAR	N
STREET	name of the street	VARCHAR	Beaumont
STREET_TYPE	string type of the street, such as ROAD	VARCHAR	Loop
STREET_DIRECTIONAL_SUFFIX	a directional modifier following the street name, such as S or NE	VARCHAR	N
UNIT	number or label for a unit used to distinguish multiple tenants at a single address	VARCHAR	915
CITY	name of the city	VARCHAR	Kearney
STATE	name of the state	VARCHAR	NE
ZIP	5-digit code identifying the location of an address	VARCHAR	15227