POI Index

Snowflake table name : CYBERSYN.POI_INDEX

View documentation here.

Name	Description	Type	Example
ADDRESS	POI's street address.	VARCHAR	2516 E LINCOLNWAY
CITY	Name of the POI's city.	VARCHAR	STERLING
ESTIMATED_CLOSE_MONTH	Cybersyn's estimation for the month when the POI closed. Recorded as '9999-01-01' if still open.	DATE	2008-05-01
ESTIMATED_OPEN_MONTH	Cybersyn's estimation for the month when the POI opened.	DATE	2005-12-01
LATITUDE	Latitude of the POI, rounded to 4 digits.	FLOAT	41.8023
LONGITUDE	Longitude of the POI, rounded to 4 digits.	FLOAT	-89.667
MERCHANT_ID	Unique identifier assigned by Cybersyn to each merchant.	VARCHAR	85807857a1b8b1a5428e46ee94ced96d
MERCHANT_NAME	The name of the merchant.	VARCHAR	KFC
POI_ID	Unique identifier assigned by Cybersyn to each point of interest (POI). Joinable to the POI TIMESERIES tables.	VARCHAR	db3f4859ee49745c5b57a9cf9edfeaf6
STATE	POI's abbreviated state.	VARCHAR	IL
ZIP	POI's 5-digit zip code.	VARCHAR	618081