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