US Addresses

Snowflake table name : CYBERSYN.US_ADDRESSES

View data sources, attributes, and sample queries 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/c0c9a4cf54808c312b381b4e4f28c846
ID_ZIP	A unique identifier for a zip code joinable to the geography_index/relationships tables	VARCHAR	zip/37040
ID_CITY	A unique identifier for a city joinable to the geography_index/relationships tables	VARCHAR	geoId/1235000
ID_STATE	A unique identifier for a state, Washington, D.C. or Puerto Rico joinable to the geography_index/relationships tables	VARCHAR	geoId/12
ID_COUNTRY	A unique identifier for a country joinable to the geography_index/relationships tables	VARCHAR	country/USA
LONGITUDE	longitude coordinate in degrees	FLOAT	-94.835859
LATITUDE	latitude coordinate in degrees	FLOAT	47.8892694
NUMBER	number of the address identifying location on a street	VARCHAR	741
STREET_DIRECTIONAL_PREFIX	a directional modifier preceding the street name, such as N or SW	VARCHAR	E
STREET	name of the street	VARCHAR	Mcclure
STREET_TYPE	string type of the street, such as ROAD	VARCHAR	Avenue
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	Unit A
CITY	name of the city	VARCHAR	Clarksville
STATE	name of the state	VARCHAR	MO
ZIP	5-digit code identifying the location of an address	VARCHAR	37040