💻Data Schema

NameDefinitionFormat

echo_poi_id

A POI's unique and consistent Identification code created by Echo Analytics

string

echo_poi_id_v2

An improved version of our echo_poi_id. End of Q3/early Q4 this attribute will be rename as echo_poi_id and will replace the current version 1.

string

poi_name

Specific name of the physical place of interest

string

brand

A label indicating which chain/franchise the entity is operated by, if any. At Echo, an entity is only considered a brand if it has more than 3 physical locations and has a proprietary website

string

tier1_category

Echo Analytics has its own taxonomy, which indicates which industry the POI falls under. Tier 1 indicates the least granular category, E.g Retail

string

tier2_category

Echo Analytics has its own taxonomy, which indicates which business the POI operates in. Tier 2 indicates the most granular category level, E.g. Clothing Stores

string

tier1_naics_code

The code that belongs to the highest level tier of the North American Industry Classification System

integer

tier1_naics_category

The category that belongs to the highest level tier of the North American Industry Classification System

string

tier2_naics_code

The code that belongs to the second highest level tier of the North American Industry Classification System

integer

tier2_naics_category

The category that belongs to the second highest level tier of the North American Industry Classification System

string

tier3_naics_code

The code that belongs to the third highest level tier of the North American Industry Classification System

integer

tier3_naics_category

The category that belongs to the third highest level tier of the North American Industry Classification System

string

tier4_naics_code

The code belongs to the second to last level tier of the North American Industry Classification System

integer

tier4_naics_category

The category that belongs to the second to last level tier of the North American Industry Classification System

string

tier5_naics_code

The code that belongs to the lowest level tier of the North American Industry Classification System

integer

tier5_naics_category

The category that belongs to the lowest level tier of the North American Industry Classification System

string

business_status

This indicates whether the POI is operational, temporarily closed, or permanently closed

string

full_address

Full address of the POI, it contains all available information about the address. (street name, street number, admin boundaries, zip code, etc.)

string

street_number

Street number, street name

string

zip_code

Zip code

string

admin_boundary_3

City, village, town

string

admin_boundary_2

Municipality, Suburb, County

string

admin_boundary_1

State, region

string

country_code

The country where the POI is located in a 2-letter ISO code format

string

latitude

The standard latitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)

float

longitude

The standard longitude in decimal degrees, truncated to 5 digits (approx. 1.11 meter accuracy)

float

geo_h3_id_level_10

A unique identifier for each H3 area (H3 = Uber's Hexagonal Hierarchical Spatial Index, a grid system with different granularity levels). At Echo, we use Level 10, which has an area of approximately 15 meters

string

parent_organization

A legal entity that runs the stated brand/franchise. This is the indicator of the business group that the company is listed under, Eg: Esso is owned by the Parent Organization Exxon Mobil Corporation

string

stock_ticker

The stock ticker symbol is a unique series of letters associated with publicly listed parent organisations E.g. McDonald's = MCD

string

opening_hours

Indicates the operating hours of the POI business (if applicable). Operating hours formatting can vary for each POI. E.g. (Mo-Fr 09:00-19:30; Sa 10:00-17:00)

string

phone_number

The phone number of the POI business (if applicable). E.g. +33673647563

string

website

URL of the official website tied to the POI business. Can sometimes be just the domain name of the company itself, can be a Facebook page associated to the business, or can be a detailed URL of the specific store of that chain

string

Last updated