Data Classifications (Ontologies)

What are Data Classifications (Ontologies)?
A data classification (ontologies) is the classification of the data loaded into the Explorium system, the type of data in a column, such as a zip code, city, email, credit card number, text, numeric, categorical and so on.
Explorium automatically assigns data classifications (ontologies) when you load data into the platform, and Explorium uses the data classification (ontology) to determine which external data can be used to enrich it. From a date column, for example, we can extract the day of the month, day of the week, the month, and the year.
The data classification (ontology) is also being used to normalize the data, for example, we know how to handle state codes if classified as US state, but we won't know to handle it the same way if classified as a category.
Where a data classification (ontology) is incorrect you can select the correct data classification (Ontology) by hovering over the data classification and selecting a new data classification. For more information, click here.
Now proceed to transform your data.
To avoid potential parsing errors make sure that your numeric data does not contain any non-numeric characters.
For zip codes in US, you should only include numeric characters.
We recommend that you add a regional prefix to the phone number and make sure that “address” contains the full address of the location, including street, city, region, and zip code, and if possible, country and house number.

Data Classification (Ontology) Types

COMPANY_LEGAL_NAME
The name that a business or company is legally registered under.
Warner Bros. Entertainment, Inc.

COMPANY_WEBSITE
The link to the website associated with the business or company.
http://www.mybank.com

COUNTRY
The name of the entity's country location.
AR | ARG | Argentina

DATETIME
The time and date of an event related to the entity, represented by 17 digits YYYY-MM-DD hh:mm:ss[.nnn] and the time zone.
2021-12-05T15:00:00.123+00:00 |
2021-12-05T15:00:00Z |
20211205T150000Z | 2000-01-01
22:00:00.123456+00:00
DISPLAY

These values are only displayed, and no features will be extracted from them.
The second address is for shipping, ignore.

EMAIL
The email address associated with the entity.
[email protected] | [email protected]

FACEBOOK_URL
The link to a Facebook profile associated with the entity.
http://www.facebook.com/profile.php?id=1234567890

First Name
The first name or private name associated with the individual.
Ada | Domingo 'Inigo'

Full Name
All first and last names listed under the individual.
Ada Lovelace | Domingo 'Inigo' Montoya

GLASSDOOR_URL
The link to a Glassdoor profile associated with an organization.
https://www.glassdoor.com/Reviews/Tel-Aviv-University-Reviews-E364263.htm

H3
H3 is a geospatial indexing system that partitions the world into hexagonal cells in the area resolution of around 12k square kilometers.
89283082e73ffff

HOUSE NUMBER
The unique number and letter combination assigned to each house or building on a street, this number is used to form the building's full address.
57 | 4

INSTAGRAM_URL
The link to an Instagram profile associated with the entity.
https://www.instagram.com/adalovelace/

IP Address
In IPV4 format, the IP address associated with the entity consists of 4 numbers, ranging from 0 to 255 and separated by dots.
192.0.2.146

Last Name
The last name, family name or surname associated with the individual.
Lovelace | Montoya

LATITUDE
Latitude coordinate degrees specify the entity's distance from the equator as measured on the north-south axis.
29.979 | 46.777541
LINKEDIN_URL

The link to a LinkedIn profile associated with the entity.
http://www.linkedin.com/pub/eva-lovelace/6a217b542

LONGITUDE
Longitude coordinate degrees specify the entity's distance from the equator as measured on the east-west axis.
31.1342, 31.777777

NAICS Code
The unique North American Industry Classification System code assigned to the relevant industry.
'4444' | '444422'

NUMERIC
An exact numeric value related to the entity.
3.3333 | 598765432 | 0.12358

PHONE NUMBER
The phone number associated with the entity, including a '+', a country code, and a number up to 12 digits that does not start with '0'.
(+1)66666666666 | +972556667788 | +902165558844

PINTEREST_URL
The link to a Pinterest profile associated with the entity.
https://www.pinterest.com/AdaLovelace/_saved/

REGION
An area or province of a country with definable characteristics, generally considered to be the equivalent of a US state as coded by ISO 3166-2.
DE-Bavaria | DE-BY | FR-Normandy

SIC Code
Standard Industrial Classification codes are four-digit numerical codes that categorize the industries that companies belong to based on their business activities, and have been replaced by NAICS
‘44' | '4444'

STREET
The street name associated with the entity's location.
Brewster Rd

SUBPREMISE
Subpremise within a property, is usually in the form of a unit marked by a number or letter such as an apartment number within a building.
26A | 8

TEXT
Text data related to the entity can contain both single-byte and multibyte characters.
Countess of Lovelace was an English mathematician and writer, chiefly known for her work on Charles Babbage's proposed mechanical general-purpose computer, the Analytical Engine.

TICKER
A stock symbol that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders.
NYSE: AAIC

TWITTER_URL
The link to a Twitter profile associated with the entity.
http://twitter.com/[adalovelace]

UNIQUE_ID
A universally unique identifier (UUID) is generated using random numbers and consists of a 128-bit label.
123e4567-e89b-12d3-a456-426614174000

URL
A web address associated with the entity.
https://en.wikipedia.org

US State
The entity's US state location.
Georgia | GA

YEAR
A Gregorian calendar year represented by 4 digits YYYY.
1989 | 2015

ZIP CODE
The unique ZIP code or postcode associated with the entity
US-66666 | US-66666-7777 | TR-30707

ZIP CODE US
The unique US ZIP code associated with the entity
12345-1234 | 66666-7777 | 66666

ZIP_CODE_UK
The unique UK ZIP code or postcode associated with the entity.
SW1W 0NY | GU16 7HF