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

NameDescriptionExample of Input
ADDRESSThe full address including country, state or region, city, street name, ZIP code and other potential address identifiers associated with the entity's location.3 Brewster Rd, Newark, NJ 07114, United States
BOOLEANThe purpose of this data type is to represent conditional rules relevant to the entity. Typically, it is used to assign one of two values that represent 'true' and 'false'.True | False || Yes | No
CATEGORYA division of information into groups that represent characteristics of the entity.Group A | Group B | Group C || 1-100 | 101-200 | 201-300
CITYThe name of the entity's city location.NYC | New-York | New York City
COMPANYThe name of an organization.Warner Brothers

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

The link to the website associated with the business or company.

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

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

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

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

The link to a Facebook profile associated with the entity.

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

The link to a Glassdoor profile associated with an organization.

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

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

The link to an Instagram profile associated with the entity.

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.

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

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

The link to a LinkedIn profile associated with the entity.

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

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

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

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

The link to a Pinterest profile associated with the entity.

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'

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

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 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.

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.

The link to a Twitter profile associated with the entity.[adalovelace]

A universally unique identifier (UUID) is generated using random numbers and consists of a 128-bit label.

A web address associated with the entity.

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

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

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

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

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