๐Ÿ’ปData Schema

NameDefinitionsData 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 income for the given postal code

integer

purchasing_power_per_household_in_euros

The household level income for the given postal code

integer

pop_age_0_to_5_years

Population between 0 to 5 years

integer

pop_0_to_5_years_male

Male population between 0 to 5 years

integer

pop_0_to_5_years_female

Female population between 0 to 5 years

integer

pop_age_5_to_10_years

Population between 5 to 10 years

integer

pop_5_to_10_years_male

Male population between 5 to 10 years

integer

pop_5_to_10_years_female

Female population between 5 to 10 years

integer

pop_age_10_to_15_years

Population between 10 to 15 years

integer

pop_10_to_15_years_male

Male population between 10 to 15 years

integer

pop_10_to_15_years_female

Female population between 10 to 15 years

integer

pop_age_15_to_20_years

Population between 15 to 20 years

integer

pop_15_to_20_years_male

Male population between 15 to 20 years

integer

pop_15_to_20_years_female

Female population between 15 to 20 years

integer

pop_age_20_to_25_years

Population between 20 to 25 years

integer

pop_20_to_25_years_male

Male population between Population between 20 to 25 years

integer

pop_20_to_25_years_female

Female population between Population between 20 to 25 years

integer

pop_age_25_to_30_years

Population between 25 to 30 years

integer

pop_25_to_30_years_male

Male population between 25 to 30 years

integer

pop_25_to_30_years_female

Female population between 25 to 30 years

integer

pop_age_30_to_35_years

Population between 30 to 35 years

integer

pop_30_to_35_years_male

Male population between 30 to 35 years

integer

pop_30_to_35_years_female

Female population between 30 to 35 years

integer

pop_age_35_to_40_years

Population between 35 to 40 years

integer

pop_35_to_40_years_male

Male population between 35 to 40 years

integer

pop_35_to_40_years_female

Female population between 35 to 40 years

integer

pop_age_40_to_45_years

Population between 40 to 45 years

integer

pop_40_to_45_years_male

Male population between 40 to 45 years

integer

pop_40_to_45_years_female

Female population between 40 to 45 years

integer

pop_age_45_to_50_years

Population between 45 to 50 years

integer

pop_45_to_50_years_male

Male population between 45 to 50 years

integer

pop_45_to_50_years_female

Female population between 45 to 50 years

integer

pop_age_50_to_55_years

Population between 50 to 55 years

integer

pop_50_to_55_years_male

Male population between 50 to 55 years

integer

pop_50_to_55_years_female

Female population between 50 to 55 years

integer

pop_age_55_to_60_years

Population between 55 to 60 years

integer

pop_55_to_60_years_male

Male population between 55 to 60 years

integer

pop_55_to_60_years_female

Female population between 55 to 60 years

integer

pop_age_60_to_65_years

Population between 60 to 65 years

integer

pop_60_to_65_years_male

Male population between 60 to 65 years

integer

pop_60_to_65_years_female

Female population between 60 to 65 years

integer

pop_age_65_to_70_years

Population between 65 to 70 years

integer

pop_65_to_70_years_male

Male population between 65 to 70 years

integer

pop_65_to_70_years_female

Female population between 65 to 70 years

integer

pop_age_70_to_75_years

Population between 70 to 75 years

integer

pop_70_to_75_years_male

Male population between 70 to 75 years

integer

pop_70_to_75_years_female

Female population between 70 to 75 years

integer

pop_age_75_and_older

Population 75 and older

integer

pop_75_and_older_male

Male population 75 and older

integer

pop_75_and_older_female

Female population 75 and older

integer

Last updated