💻Data Schema

Name
Definitions
Data Type

postal_code

The Postal Code for the area the data is for. For eg - ‘20001’

integer

postal_code_name

The assigned name for the Postal Code. For eg - ‘Inveruno’

string

region_name

The name of the region the Postal Code belongs to. For eg - ‘Lombardy’

string

country_code

The country code for the country the Postal Code belongs to. For eg - Italy is ‘IT’

string

geopersona_segment

The GeoPersona audience segmenting tag

string

brand_name

The brand for which affinity is being measured

string

affinity_index_regional

The affinity index of inhabitants for a particular postal code, as compared to the regional average (1 = Average, >1 = Over-Indexed/High Interest, <1 = Under-Indexed/Low interest)

float

affinity_index_national

The affinity index of inhabitants for a particular postal code, as compared to the national average (1 = Average, >1 = Over-Indexed/High Interest, <1 = Under-Indexed/Low interest)

float

quarter_range_start

Indicates the starting date of the quarter the data was computed (2023-01-01 would indicate the beginning of Q1 2023)

date object

quarter_range_end

Indicates the ending date of the quarter the data was computed (2023-03-31 would indicate the end of Q1 2023)

date object

population

The number of inhabitants in the given postal code

integer

households

The number of households in the given postal code

integer

purchasing_power_per_capita_in_euros

The individual level disposable income for the given postal code

integer

purchasing_power_per_household_in_euros

The household level disposable income for the given postal code

integer

pop_age_0_to_20_years

Population between 0 to 20 years

integer

pop_0_to_20_years_male

Male population between 0 to 20 years

integer

pop_0_to_20_years_female

Female population between 0 to 20 years

integer

pop_age_20_to_35_years

Population between 20 to 35 years

integer

pop_20_to_35_years_male

Male population between Population between 20 to 35 years

integer

pop_20_to_35_years_female

Female population between Population between 20 to 35 years

integer

pop_age_35_to_45_years

Population between 35 to 45 years

integer

pop_35_to_45_years_male

Male population between 35 to 45 years

integer

pop_35_to_45_years_female

Female population between 35 to 45 years

integer

pop_age_45_to_60_years

Population between 45 to 60 years

integer

pop_45_to_60_years_male

Male population between 45 to 60 years

integer

pop_45_to_60_years_female

Female population between 45 to 60 years

integer

pop_age_60_and_older

Population 60 and older

integer

pop_60_and_older_male

Male population 60 and older

integer

pop_60_and_older_female

Female population 60 and older

integer

Last updated