UK Census Data

Uli Bethke Uncategorized

Each table provides information about a single census topic like sex, dwellings, hours worked etc. Data present in the table is at the census ward level. Electoral Wards are key building blocks of UK administration. They are spatial units used to elect councillors at various levels across the UK. The Wards resulting from a policy which minimizes the statistical impact of frequent changes in the boundary of electoral wards is known as statistical wards. Under this policy any changes to English or Welsh electoral ward boundaries by the end of a calendar year, were implemented for statistical purposes on 1 April of the following year, irrespective of the year the actual change came into operation. Census wards are almost similar to statistical wards except some small statistical wards merge together to form a census wards.

In total there are 47 tables

Table Names

V_ONS_UK_ACCOMMODATION_TYPE_HOUSEHOLDS

Description

This provides information about the type and amount of housing in each area and the unit is households.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_ACCOMMODATION_TYPE
UNSHARED_DWELLING_TOTAL
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_TOTAL
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_DETACHED
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_SEMI_DETACHED
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_TERRACED_INCLUDING_END_TERRACE
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_TOTAL
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_PURPOSE_BUILT_BLOCK_OF_FLATS_OR_TENEMENT
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_PART_OF_A_CONVERTED_OR_SHARED_HOUSE_INCLUDING_BED_SITS
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_IN_COMMERCIAL_BUILDING
UNSHARED_DWELLING_CARAVAN_OR_OTHER_MOBILE_OR_TEMPORARY_STRUCTURE
SHARED_DWELLING

V_ONS_UK_ACCOMMODATION_TYPE_PEOPLE

Description

This provides information about the type and amount of housing in each area and the unit is persons.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_ACCOMMODATION_TYPE
UNSHARED_DWELLING_TOTAL
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_TOTAL
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_DETACHED
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_SEMI_DETACHED
UNSHARED_DWELLING_WHOLE_HOUSE_OR_BUNGALOW_TERRACED_INCLUDING_END_TERRACE
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_TOTAL
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_PURPOSE_BUILT_BLOCK_OF_FLATS_OR_TENEMENT
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_PART_OF_A_CONVERTED_OR_SHARED_HOUSE_INCLUDING_BED_SITS
UNSHARED_DWELLING_FLAT_MAISONETTE_OR_APARTMENT_IN_COMMERCIAL_BUILDING
UNSHARED_DWELLING_CARAVAN_OR_OTHER_MOBILE_OR_TEMPORARY_STRUCTURE
SHARED_DWELLING

V_ONS_UK_ADULT_LIFESTAGE_ALTERNATIVE_ADULT_DEFINITION

Description

This provides information about the adults in households by age, the number of people in the household, and the presence of dependent children. The definition of adults here is aged 16 and above.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_ADULT_LIFESTAGE
AGE_SIXTEEN_TO_TWENTY_FOUR_TOTAL
AGE_SIXTEEN_TO_TWENTY_FOUR_NO_DEPENDENT_CHILDREN_IN_HOUSEHOLD
AGE_SIXTEEN_TO_TWENTY_FOUR_DEPENDENT_CHILDREN_IN_HOUSEHOLD
AGE_TWENTY_FIVE_TO_THIRTY_FOUR_TOTAL
AGE_TWENTY_FIVE_TO_THIRTY_FOUR_NO_DEPENDENT_CHILDREN_IN_HOUSEHOLD
AGE_TWENTY_FIVE_TO_THIRTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_ZERO_TO_FOUR
AGE_TWENTY_FIVE_TO_THIRTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_FIVE_TO_TEN
AGE_TWENTY_FIVE_TO_THIRTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_ELEVEN_TO_FIFTEEN
AGE_TWENTY_FIVE_TO_THIRTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_SIXTEEN_TO_EIGHTEEN
AGE_THIRTY_FIVE_TO_FIFTY_FOUR_TOTAL
AGE_THIRTY_FIVE_TO_FIFTY_FOUR_NO_DEPENDENT_CHILDREN_IN_HOUSEHOLD
AGE_THIRTY_FIVE_TO_FIFTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_ZERO_TO_FOUR
AGE_THIRTY_FIVE_TO_FIFTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_FIVE_TO_TEN
AGE_THIRTY_FIVE_TO_FIFTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_ELEVEN_TO_FIFTEEN
AGE_THIRTY_FIVE_TO_FIFTY_FOUR_YOUNGEST_DEPENDENT_CHILD_IN_HOUSEHOLD_AGED_SIXTEEN_TO_EIGHTEEN
AGE_FIFTY_FIVE_TO_SIXTY_FOUR_TOTAL
AGE_FIFTY_FIVE_TO_SIXTY_FOUR_ONE_PERSON_HOUSEHOLD
AGE_FIFTY_FIVE_TO_SIXTY_FOUR_TWO_OR_MORE_PERSON_HOUSEHOLD_NO_DEPENDENT_CHILDREN
AGE_FIFTY_FIVE_TO_SIXTY_FOUR_DEPENDENT_CHILDREN_IN_HOUSEHOLD
AGE_SIXTY_FIVE_TO_SEVENTY_FOUR_TOTAL
AGE_SIXTY_FIVE_TO_SEVENTY_FOUR_ONE_PERSON_HOUSEHOLD
AGE_SIXTY_FIVE_TO_SEVENTY_FOUR_TWO_OR_MORE_PERSON_HOUSEHOLD_NO_DEPENDENT_CHILDREN
AGE_SIXTY_FIVE_TO_SEVENTY_FOUR_DEPENDENT_CHILDREN_IN_HOUSEHOLD
AGE_SEVENTY_FIVE_AND_OVER_TOTAL
AGE_SEVENTY_FIVE_AND_OVER_ONE_PERSON_HOUSEHOLD
AGE_SEVENTY_FIVE_AND_OVER_TWO_OR_MORE_PERSON_HOUSEHOLD

V_ONS_UK_AGE_BY_SINGLE_YEAR

Description

This provides classification of the census data according to the age of the persons in each area.

Following are the column names

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_AGE
AGE_UNDER_ONE
AGE_ONE
AGE_TWO
AGE_THREE
AGE_FOUR
AGE_FIVE
AGE_SIX
AGE_SEVEN
AGE_EIGHT
AGE_NINE
AGE_TEN
AGE_ELEVEN
AGE_TWELVE
AGE_THIRTEEN
AGE_FOURTEEN
AGE_FIFTEEN
AGE_SIXTEEN
AGE_SEVENTEEN
AGE_EIGHTEEN
AGE_NINETEEN
AGE_TWENTY
AGE_TWENTY_ONE
AGE_TWENTY_TWO
AGE_TWENTY_THREE
AGE_TWENTY_FOUR
AGE_TWENTY_FIVE
AGE_TWENTY_SIX
AGE_TWENTY_SEVEN
AGE_TWENTY_EIGHT
AGE_TWENTY_NINE
AGE_THIRTY
AGE_THIRTY_ONE
AGE_THIRTY_TWO
AGE_THIRTY_THREE
AGE_THIRTY_FOUR
AGE_THIRTY_FIVE
AGE_THIRTY_SIX
AGE_THIRTY_SEVEN
AGE_THIRTY_EIGHT
AGE_THIRTY_NINE
AGE_FOURTY
AGE_FOURTY_ONE
AGE_FOURTY_TWO
AGE_FOURTY_THREE
AGE_FOURTY_FOUR
AGE_FOURTY_FIVE
AGE_FOURTY_SIX
AGE_FOURTY_SEVEN
AGE_FOURTY_EIGHT
AGE_FOURTY_NINE
AGE_FIFTY
AGE_FIFTY_ONE
AGE_FIFTY_TWO
AGE_FIFTY_THREE
AGE_FIFTY_FOUR
AGE_FIFTY_FIVE
AGE_FIFTY_SIX
AGE_FIFTY_SEVEN
AGE_FIFTY_EIGHT
AGE_FIFTY_NINE
AGE_SIXTY
AGE_SIXTY_ONE
AGE_SIXTY_TWO
AGE_SIXTY_THREE
AGE_SIXTY_FOUR
AGE_SIXTY_FIVE
AGE_SIXTY_SIX
AGE_SIXTY_SEVEN
AGE_SIXTY_EIGHT
AGE_SIXTY_NINE
AGE_SEVENTY
AGE_SEVENTY_ONE
AGE_SEVENTY_TWO
AGE_SEVENTY_THREE
AGE_SEVENTY_FOUR
AGE_SEVENTY_FIVE
AGE_SEVENTY_SIX
AGE_SEVENTY_SEVEN
AGE_SEVENTY_EIGHT
AGE_SEVENTY_NINE
AGE_EIGHTY
AGE_EIGHTY_ONE
AGE_EIGHTY_TWO
AGE_EIGHTY_THREE
AGE_EIGHTY_FOUR
AGE_EIGHTY_FIVE
AGE_EIGHTY_SIX
AGE_EIGHTY_SEVEN
AGE_EIGHTY_EIGHT
AGE_EIGHTY_NINE
AGE_NINTY
AGE_NINTY_ONE
AGE_NINTY_TWO
AGE_NINTY_THREE
AGE_NINTY_FOUR
AGE_NINTY_FIVE
AGE_NINTY_SIX
AGE_NINTY_SEVEN
AGE_NINTY_EIGHT
AGE_NINTY_NINE
AGE_ONE_HUNDRED_AND_OVER

V_ONS_UK_APPROXIMATED_SOCIAL_GRADE_HOUSEHOLD_REFERENCE_PERSON_HRP_AGED_16_64

Description

This provides the socio economic classification of people in each area.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
APPROXIMATED_SOCIAL_GRADE
APPROXIMATED_SOCIAL_GRADE_AB
APPROXIMATED_SOCIAL_GRADE_C1
APPROXIMATED_SOCIAL_GRADE_C2
APPROXIMATED_SOCIAL_GRADE_DE

V_ONS_UK_CENTRAL_HEATING

Description

This provides the classification of the type of central heating in households. The unit of value here is households.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_TYPE_OF_CENTRAL_HEATING_IN_HOUSEHOLD
NO_CENTRAL_HEATING
GAS_CENTRAL_HEATING
ELECTRIC_INCLUDING_STORAGE_HEATERS_CENTRAL_HEATING
OIL_CENTRAL_HEATING
SOLID_FUEL_FOR_EXAMPLE_WOOD_COAL_CENTRAL_HEATING
OTHER_CENTRAL_HEATING
TWO_OR_MORE_TYPES_OF_CENTRAL_HEATING

V_ONS_UK_COMMUNAL_ESTABLISHMENT_MANAGEMENT_AND_TYPE_COMMUNAL_ESTABLISHMENTS

Description

This provides the classification of communal establishments and its type in each area. The unit is communal establishments (i.e. Number of communal establishments).

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_COMMUNAL_ESTABLISHMENT_MANAGEMENT_AND_TYPE
MEDICAL_AND_CARE_ESTABLISHMENT_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_GENERAL_HOSPITAL
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_MENTAL_HEALTH_HOSPITAL_UNIT_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_OTHER_HOSPITAL
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_CHILDREN_S_HOME_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_CARE_HOME_WITH_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_CARE_HOME_WITHOUT_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_OTHER_HOME
MEDICAL_AND_CARE_ESTABLISHMENT_REGISTERED_SOCIAL_LANDLORD_HOUSING_ASSOCIATION_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_REGISTERED_SOCIAL_LANDLORD_HOUSING_ASSOCIATION_HOME_OR_HOSTEL
MEDICAL_AND_CARE_ESTABLISHMENT_REGISTERED_SOCIAL_LANDLORD_HOUSING_ASSOCIATION_SHELTERED_HOUSING_ONLY
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_CARE_HOME_WITH_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_CARE_HOME_WITHOUT_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_CHILDREN_S_HOME_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_MENTAL_HEALTH_HOSPITAL_UNIT_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_OTHER_HOSPITAL
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_OTHER_ESTABLISHMENT
OTHER_ESTABLISHMENT_TOTAL
OTHER_ESTABLISHMENT_DEFENCE
OTHER_ESTABLISHMENT_PRISON_SERVICE
OTHER_ESTABLISHMENT_APPROVED_PREMISES_PROBATION_BAIL_HOSTEL
OTHER_ESTABLISHMENT_DETENTION_CENTRES_AND_OTHER_DETENTION
OTHER_ESTABLISHMENT_EDUCATION
OTHER_ESTABLISHMENT_HOTEL_GUEST_HOUSE_B_B_YOUTH_HOSTEL
OTHER_ESTABLISHMENT_HOSTEL_OR_TEMPORARY_SHELTER_FOR_THE_HOMELESS
OTHER_ESTABLISHMENT_HOLIDAY_ACCOMMODATION_FOR_EXAMPLE_HOLIDAY_PARKS
OTHER_ESTABLISHMENT_OTHER_TRAVEL_OR_TEMPORARY_ACCOMMODATION
OTHER_ESTABLISHMENT_RELIGIOUS
OTHER_ESTABLISHMENT_STAFF_WORKER_ACCOMMODATION_ONLY
OTHER_ESTABLISHMENT_OTHER

V_ONS_UK_COMMUNAL_ESTABLISHMENT_MANAGEMENT_AND_TYPE_PEOPLE

Description

This provides the classification of communal establishments and its type in each area. The unit is persons (i.e. Number of people).

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_COMMUNAL_ESTABLISHMENT_MANAGEMENT_AND_TYPE
MEDICAL_AND_CARE_ESTABLISHMENT_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_GENERAL_HOSPITAL
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_MENTAL_HEALTH_HOSPITAL_UNIT_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_NHS_OTHER_HOSPITAL
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_CHILDREN_S_HOME_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_CARE_HOME_WITH_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_CARE_HOME_WITHOUT_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_LOCAL_AUTHORITY_OTHER_HOME
MEDICAL_AND_CARE_ESTABLISHMENT_REGISTERED_SOCIAL_LANDLORD_HOUSING_ASSOCIATION_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_REGISTERED_SOCIAL_LANDLORD_HOUSING_ASSOCIATION_HOME_OR_HOSTEL
MEDICAL_AND_CARE_ESTABLISHMENT_REGISTERED_SOCIAL_LANDLORD_HOUSING_ASSOCIATION_SHELTERED_HOUSING_ONLY
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_TOTAL
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_CARE_HOME_WITH_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_CARE_HOME_WITHOUT_NURSING
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_CHILDREN_S_HOME_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_MENTAL_HEALTH_HOSPITAL_UNIT_INCLUDING_SECURE_UNITS
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_OTHER_HOSPITAL
MEDICAL_AND_CARE_ESTABLISHMENT_OTHER_OTHER_ESTABLISHMENT
OTHER_ESTABLISHMENT_TOTAL
OTHER_ESTABLISHMENT_DEFENCE
OTHER_ESTABLISHMENT_PRISON_SERVICE
OTHER_ESTABLISHMENT_APPROVED_PREMISES_PROBATION_BAIL_HOSTEL
OTHER_ESTABLISHMENT_DETENTION_CENTRES_AND_OTHER_DETENTION
OTHER_ESTABLISHMENT_EDUCATION
OTHER_ESTABLISHMENT_HOTEL_GUEST_HOUSE_B_B_YOUTH_HOSTEL
OTHER_ESTABLISHMENT_HOSTEL_OR_TEMPORARY_SHELTER_FOR_THE_HOMELESS
OTHER_ESTABLISHMENT_HOLIDAY_ACCOMMODATION_FOR_EXAMPLE_HOLIDAY_PARKS
OTHER_ESTABLISHMENT_OTHER_TRAVEL_OR_TEMPORARY_ACCOMMODATION
OTHER_ESTABLISHMENT_RELIGIOUS
OTHER_ESTABLISHMENT_STAFF_WORKER_ACCOMMODATION_ONLY
OTHER_ESTABLISHMENT_OTHER

V_ONS_UK_COUNTRY_OF_BIRTH

Description

This provides the classification of the population by the country of birth.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_COUNTRY_OF_BIRTH
EUROPE_TOTAL
EUROPE_UNITED_KINGDOM_TOTAL
EUROPE_UNITED_KINGDOM_ENGLAND
EUROPE_UNITED_KINGDOM_NORTHERN_IRELAND
EUROPE_UNITED_KINGDOM_SCOTLAND
EUROPE_UNITED_KINGDOM_WALES
EUROPE_UNITED_KINGDOM_NOT_OTHERWISE_SPECIFIED
EUROPE_CHANNEL_ISLANDS_AND_ISLE_OF_MAN
EUROPE_IRELAND
EUROPE_OTHER_EUROPE_TOTAL
EUROPE_OTHER_EUROPE_EU_COUNTRIES_TOTAL
EUROPE_OTHER_EUROPE_EU_COUNTRIES_GERMANY
EUROPE_OTHER_EUROPE_EU_COUNTRIES_LITHUANIA
EUROPE_OTHER_EUROPE_EU_COUNTRIES_POLAND
EUROPE_OTHER_EUROPE_EU_COUNTRIES_ROMANIA
EUROPE_OTHER_EUROPE_EU_COUNTRIES_OTHER_EU_COUNTRIES
EUROPE_OTHER_EUROPE_REST_OF_EUROPE_TOTAL
EUROPE_OTHER_EUROPE_REST_OF_EUROPE_TURKEY
EUROPE_OTHER_EUROPE_REST_OF_EUROPE_OTHER_EUROPE
AFRICA_TOTAL
AFRICA_NORTH_AFRICA
AFRICA_CENTRAL_AND_WESTERN_AFRICA_TOTAL
AFRICA_CENTRAL_AND_WESTERN_AFRICA_NIGERIA
AFRICA_CENTRAL_AND_WESTERN_AFRICA_OTHER_CENTRAL_AND_WESTERN_AFRICA
AFRICA_SOUTH_AND_EASTERN_AFRICA_TOTAL
AFRICA_SOUTH_AND_EASTERN_AFRICA_KENYA
AFRICA_SOUTH_AND_EASTERN_AFRICA_SOUTH_AFRICA
AFRICA_SOUTH_AND_EASTERN_AFRICA_ZIMBABWE
AFRICA_SOUTH_AND_EASTERN_AFRICA_OTHER_SOUTH_AND_EASTERN_AFRICA
MIDDLE_EAST_AND_ASIA_TOTAL
MIDDLE_EAST_AND_ASIA_MIDDLE_EAST_TOTAL
MIDDLE_EAST_AND_ASIA_MIDDLE_EAST_IRAN
MIDDLE_EAST_AND_ASIA_MIDDLE_EAST_OTHER_MIDDLE_EAST
MIDDLE_EAST_AND_ASIA_EASTERN_ASIA_TOTAL
MIDDLE_EAST_AND_ASIA_EASTERN_ASIA_CHINA
MIDDLE_EAST_AND_ASIA_EASTERN_ASIA_HONG_KONG_SPECIAL_ADMINISTRATIVE_REGION_OF_CHINA
MIDDLE_EAST_AND_ASIA_EASTERN_ASIA_OTHER_EASTERN_ASIA
MIDDLE_EAST_AND_ASIA_SOUTHERN_ASIA_TOTAL
MIDDLE_EAST_AND_ASIA_SOUTHERN_ASIA_BANGLADESH
MIDDLE_EAST_AND_ASIA_SOUTHERN_ASIA_INDIA
MIDDLE_EAST_AND_ASIA_SOUTHERN_ASIA_PAKISTAN
MIDDLE_EAST_AND_ASIA_SOUTHERN_ASIA_OTHER_SOUTHERN_ASIA
MIDDLE_EAST_AND_ASIA_SOUTH_EAST_ASIA_TOTAL
MIDDLE_EAST_AND_ASIA_CENTRAL_ASIA
THE_AMERICAS_AND_THE_CARIBBEAN_TOTAL
THE_AMERICAS_AND_THE_CARIBBEAN_NORTH_AMERICAS_AND_THE_CARIBBEAN_TOTAL
THE_AMERICAS_AND_THE_CARIBBEAN_NORTH_AMERICAS_AND_THE_CARIBBEAN_THE_CARIBBEAN
THE_AMERICAS_AND_THE_CARIBBEAN_NORTH_AMERICAS_AND_THE_CARIBBEAN_UNITED_STATES_OF_AMERICA
THE_AMERICAS_AND_THE_CARIBBEAN_NORTH_AMERICAS_AND_THE_CARIBBEAN_OTHER_NORTH_AMERICA
THE_AMERICAS_AND_THE_CARIBBEAN_CENTRAL_AMERICA
THE_AMERICAS_AND_THE_CARIBBEAN_SOUTH_AMERICA
ANTARCTICA_AND_OCEANIA_TOTAL
ANTARCTICA_AND_OCEANIA_AUSTRALIA
ANTARCTICA_AND_OCEANIA_OTHER_ANTARCTICA_AND_OCEANIA
OTHER

V_ONS_UK_DWELLINGS

Description

This provides the classification of type of dwellings in each area. The unit is dwellings (i.e. Number of dwellings).

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_DWELLING_TYPE
UNSHARED_DWELLING
SHARED_DWELLING

V_ONS_UK_ECONOMIC_ACTIVITY_FULL_TIME_STUDENTS

Description

This provides classification of economic activity of full time students.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
RURAL_URBAN
ALL_CATEGORIES_FULL_TIME_STUDENTS_AND_ECONOMIC_ACTIVITY
FULL_TIME_STUDENTS_ECONOMICALLY_ACTIVE_IN_EMPLOYMENT
FULL_TIME_STUDENTS_ECONOMICALLY_ACTIVE_UNEMPLOYED
FULL_TIME_STUDENTS_ECONOMICALLY_INACTIVE

V_ONS_UK_ECONOMIC_ACTIVITY

Description

This provides classification of population according to the economic activity.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_ECONOMIC_ACTIVITY
ECONOMICALLY_ACTIVE_TOTAL
ECONOMICALLY_ACTIVE_EMPLOYEE_PART_TIME
ECONOMICALLY_ACTIVE_EMPLOYEE_FULL_TIME
ECONOMICALLY_ACTIVE_SELF_EMPLOYED_WITH_EMPLOYEES_PART_TIME
ECONOMICALLY_ACTIVE_SELF_EMPLOYED_WITH_EMPLOYEES_FULL_TIME
ECONOMICALLY_ACTIVE_SELF_EMPLOYED_WITHOUT_EMPLOYEES_PART_TIME
ECONOMICALLY_ACTIVE_SELF_EMPLOYED_WITHOUT_EMPLOYEES_FULL_TIME
ECONOMICALLY_ACTIVE_UNEMPLOYED
ECONOMICALLY_ACTIVE_FULL_TIME_STUDENT
ECONOMICALLY_INACTIVE_TOTAL
ECONOMICALLY_INACTIVE_RETIRED
ECONOMICALLY_INACTIVE_STUDENT_INCLUDING_FULL_TIME_STUDENTS
ECONOMICALLY_INACTIVE_LOOKING_AFTER_HOME_OR_FAMILY
ECONOMICALLY_INACTIVE_LONG_TERM_SICK_OR_DISABLED
ECONOMICALLY_INACTIVE_OTHER

V_ONS_UK_FAMILIES_WITH_DEPENDENT_CHILDREN_QS118UK

Description

This provides classification of families with the number of dependent children's.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_FAMILIES_IN_HOUSEHOLDS
NO_DEPENDENT_CHILDREN_IN_FAMILY
ONE_DEPENDENT_CHILD_IN_FAMILY_AGED_ZERO_TO_FOUR
ONE_DEPENDENT_CHILD_IN_FAMILY_AGED_FIVE_TO_ELEVEN
ONE_DEPENDENT_CHILD_IN_FAMILY_AGED_TWELVE_TO_EIGHTEEN
TWO_DEPENDENT_CHILDREN_IN_FAMILY_YOUNGEST_AGED_ZERO_TO_FOUR
TWO_DEPENDENT_CHILDREN_IN_FAMILY_YOUNGEST_AGED_FIVE_TO_ELEVEN
TWO_DEPENDENT_CHILDREN_IN_FAMILY_YOUNGEST_AGED_TWELVE_TO_EIGHTEEN
THREE_OR_MORE_DEPENDENT_CHILDREN_IN_FAMILY_YOUNGEST_AGED_ZERO_TO_FOUR
THREE_OR_MORE_DEPENDENT_CHILDREN_IN_FAMILY_YOUNGEST_AGED_FIVE_TO_ELEVEN
THREE_OR_MORE_DEPENDENT_CHILDREN_IN_FAMILY_YOUNGEST_AGED_TWELVE_TO_EIGHTEEN

V_ONS_UK_GENERAL_HEALTH

Description

This provides classification of the UK population by the state of their general health.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_GENERAL_HEALTH
VERY_GOOD_HEALTH
GOOD_HEALTH
FAIR_HEALTH
BAD_HEALTH
VERY_BAD_HEALTH

V_ONS_UK_HIGHEST_LEVEL_OF_QUALIFICATION

Description

This provides classification of the population by their qualification.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HIGHEST_LEVEL_OF_QUALIFICATION
NO_QUALIFICATIONS
LEVEL_ONE_QUALIFICATIONS
LEVEL_TWO_QUALIFICATIONS
APPRENTICESHIP
LEVEL_THREE_QUALIFICATIONS
LEVEL_FOUR_QUALIFICATIONS_AND_ABOVE
OTHER_QUALIFICATIONS

V_ONS_UK_HOURS_WORKED

Description

This classifies the UK Population by number of hours worked.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOURS_WORKED
PART_TIME_TOTAL
PART_TIME_FIFTEEN_HOURS_OR_LESS_WORKED
PART_TIME_SIXTEEN_TO_THIRTY_HOURS_WORKED
FULL_TIME_TOTAL
FULL_TIME_THIRTY_ONE_TO_FOURTY_EIGHT_HOURS_WORKED
FULL_TIME_FOURTY_NINE_OR_MORE_HOURS_WORKED

V_ONS_UK_HOUSEHOLD_COMPOSITION_ALTERNATIVE_CHILD_ADULT_DEFINITIONS_HOUSEHOLDS

Description

This provides classification of households in the United Kingdom by household composition.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOUSEHOLD_COMPOSITION_ALTERNATIVE_CHILD_AND_ADULT_DEFINTIONS
ONE_PERSON_HOUSEHOLD_TOTAL
ONE_PERSON_HOUSEHOLD_ONE_PERSON_AGED_SIXTY_FIVE_AND_OVER
ONE_PERSON_HOUSEHOLD_ONE_PERSON_AGED_UNDER_SIXTY_FIVE
OTHER_HOUSEHOLDS_TOTAL
OTHER_HOUSEHOLDS_NO_ADULTS_OR_ONE_ADULT_AND_ONE_OR_MORE_CHILDREN
OTHER_HOUSEHOLDS_ONE_ADULT_AGED_SIXTEEN_TO_SIXTY_FOUR_AND_ONE_AGED_SIXTY_FIVE_AND_OVER_AND_NO_CHILDREN_OR_TWO_ADULTS_AGED_SIXTY_FIVE_AND_OVER_AND_NO_CHILDREN
OTHER_HOUSEHOLDS_TWO_ADULTS_AND_ONE_OR_TWO_CHILDREN
OTHER_HOUSEHOLDS_TWO_ADULTS_AGED_SIXTEEN_TO_SIXTY_FOUR_AND_NO_CHILDREN
OTHER_HOUSEHOLDS_TWO_ADULTS_AND_THREE_OR_MORE_CHILDREN
OTHER_HOUSEHOLDS_THREE_OR_MORE_ADULTS_AND_ONE_OR_MORE_CHILDREN
OTHER_HOUSEHOLDS_THREE_OR_MORE_ADULTS_AND_NO_CHILDREN

V_ONS_UK_HOUSEHOLD_COMPOSITION_ALTERNATIVE_CHILD_AND_ADULT_DEFINITIONS_PEOPLE

Description

This provides classification of households in the United Kingdom by household composition.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOUSEHOLD_COMPOSITION_ALTERNATIVE_CHILD_AND_ADULT_DEFINTIONS
ONE_PERSON_HOUSEHOLD_TOTAL
ONE_PERSON_HOUSEHOLD_ONE_PERSON_AGED_SIXTY_FIVE_AND_OVER
ONE_PERSON_HOUSEHOLD_ONE_PERSON_AGED_UNDER_SIXTY_FIVE
OTHER_HOUSEHOLDS_TOTAL
OTHER_HOUSEHOLDS_NO_ADULTS_OR_ONE_ADULT_AND_ONE_OR_MORE_CHILDREN
OTHER_HOUSEHOLDS_ONE_ADULT_AGED_SIXTEEN_TO_SIXTY_FOUR_AND_ONE_AGED_SIXTY_FIVE_AND_OVER_AND_NO_CHILDREN_OR_TWO_ADULTS_AGED_SIXTY_FIVE_AND_OVER_AND_NO_CHILDREN
OTHER_HOUSEHOLDS_TWO_ADULTS_AND_ONE_OR_TWO_CHILDREN
OTHER_HOUSEHOLDS_TWO_ADULTS_AGED_SIXTEEN_TO_SIXTY_FOUR_AND_NO_CHILDREN
OTHER_HOUSEHOLDS_TWO_ADULTS_AND_THREE_OR_MORE_CHILDREN
OTHER_HOUSEHOLDS_THREE_OR_MORE_ADULTS_AND_ONE_OR_MORE_CHILDREN
OTHER_HOUSEHOLDS_THREE_OR_MORE_ADULTS_AND_NO_CHILDREN

V_ONS_UK_HOUSEHOLD_COMPOSITION_HOUSEHOLDS_QS113UK

Description

This provides classification of households in the UK living by the relationships between household members.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOUSEHOLD_COMPOSITION
ONE_PERSON_HOUSEHOLD_TOTAL
ONE_PERSON_HOUSEHOLD_AGED_SIXTY_FIVE_AND_OVER
ONE_PERSON_HOUSEHOLD_OTHER
ONE_FAMILY_ONLY_TOTAL
ONE_FAMILY_ONLY_ALL_AGED_SIXTY_FIVE_AND_OVER
ONE_FAMILY_ONLY_MARRIED_COUPLE_TOTAL
ONE_FAMILY_ONLY_MARRIED_COUPLE_NO_CHILDREN
ONE_FAMILY_ONLY_MARRIED_COUPLE_ONE_DEPENDENT_CHILD
ONE_FAMILY_ONLY_MARRIED_COUPLE_TWO_OR_MORE_DEPENDENT_CHILDREN
ONE_FAMILY_ONLY_MARRIED_COUPLE_ALL_CHILDREN_NON_DEPENDENT
ONE_FAMILY_ONLY_SAME_SEX_CIVIL_PARTNERSHIP_COUPLE_TOTAL
ONE_FAMILY_ONLY_COHABITING_COUPLE_TOTAL
ONE_FAMILY_ONLY_COHABITING_COUPLE_NO_CHILDREN
ONE_FAMILY_ONLY_COHABITING_COUPLE_ONE_DEPENDENT_CHILD
ONE_FAMILY_ONLY_COHABITING_COUPLE_TWO_OR_MORE_DEPENDENT_CHILDREN
ONE_FAMILY_ONLY_COHABITING_COUPLE_ALL_CHILDREN_NON_DEPENDENT
ONE_FAMILY_ONLY_LONE_PARENT_TOTAL
ONE_FAMILY_ONLY_LONE_PARENT_ONE_DEPENDENT_CHILD
ONE_FAMILY_ONLY_LONE_PARENT_TWO_OR_MORE_DEPENDENT_CHILDREN
ONE_FAMILY_ONLY_LONE_PARENT_ALL_CHILDREN_NON_DEPENDENT
OTHER_HOUSEHOLD_TYPES_TOTAL
OTHER_HOUSEHOLD_TYPES_WITH_ONE_DEPENDENT_CHILD
OTHER_HOUSEHOLD_TYPES_WITH_TWO_OR_MORE_DEPENDENT_CHILDREN
OTHER_HOUSEHOLD_TYPES_ALL_FULL_TIME_STUDENTS
OTHER_HOUSEHOLD_TYPES_ALL_AGED_SIXTY_FIVE_AND_OVER
OTHER_HOUSEHOLD_TYPES_OTHER

V_ONS_UK_HOUSEHOLD_COMPOSITION_PEOPLE

Description

This provides classification of UK residents living by the relationships between household members.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOUSEHOLD_COMPOSITION
ONE_PERSON_HOUSEHOLD_TOTAL
ONE_PERSON_HOUSEHOLD_AGED_SIXTY_FIVE_AND_OVER
ONE_PERSON_HOUSEHOLD_OTHER
ONE_FAMILY_ONLY_TOTAL
ONE_FAMILY_ONLY_ALL_AGED_SIXTY_FIVE_AND_OVER
ONE_FAMILY_ONLY_MARRIED_COUPLE_TOTAL
ONE_FAMILY_ONLY_MARRIED_COUPLE_NO_CHILDREN
ONE_FAMILY_ONLY_MARRIED_COUPLE_ONE_DEPENDENT_CHILD
ONE_FAMILY_ONLY_MARRIED_COUPLE_TWO_OR_MORE_DEPENDENT_CHILDREN
ONE_FAMILY_ONLY_MARRIED_COUPLE_ALL_CHILDREN_NON_DEPENDENT
ONE_FAMILY_ONLY_SAME_SEX_CIVIL_PARTNERSHIP_COUPLE_TOTAL
ONE_FAMILY_ONLY_COHABITING_COUPLE_TOTAL
ONE_FAMILY_ONLY_COHABITING_COUPLE_NO_CHILDREN
ONE_FAMILY_ONLY_COHABITING_COUPLE_ONE_DEPENDENT_CHILD
ONE_FAMILY_ONLY_COHABITING_COUPLE_TWO_OR_MORE_DEPENDENT_CHILDREN
ONE_FAMILY_ONLY_COHABITING_COUPLE_ALL_CHILDREN_NON_DEPENDENT
ONE_FAMILY_ONLY_LONE_PARENT_TOTAL
ONE_FAMILY_ONLY_LONE_PARENT_ONE_DEPENDENT_CHILD
ONE_FAMILY_ONLY_LONE_PARENT_TWO_OR_MORE_DEPENDENT_CHILDREN
ONE_FAMILY_ONLY_LONE_PARENT_ALL_CHILDREN_NON_DEPENDENT
OTHER_HOUSEHOLD_TYPES_TOTAL
OTHER_HOUSEHOLD_TYPES_WITH_ONE_DEPENDENT_CHILD
OTHER_HOUSEHOLD_TYPES_WITH_TWO_OR_MORE_DEPENDENT_CHILDREN
OTHER_HOUSEHOLD_TYPES_ALL_FULL_TIME_STUDENTS
OTHER_HOUSEHOLD_TYPES_ALL_AGED_SIXTY_FIVE_AND_OVER
OTHER_HOUSEHOLD_TYPES_OTHER

V_ONS_UK_HOUSEHOLD_LIFESTAGE

Description

This provides classification of households by the household life stage of the Household Reference Person.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOUSEHOLD_LIFESTAGE
AGE_OF_HRP_UNDER_THIRTY_FIVE_TOTAL
AGE_OF_HRP_UNDER_THIRTY_FIVE_ONE_PERSON_HOUSEHOLD
AGE_OF_HRP_UNDER_THIRTY_FIVE_TWO_OR_MORE_PERSON_HOUSEHOLD_NO_DEPENDENT_CHILDREN
AGE_OF_HRP_UNDER_THIRTY_FIVE_TWO_OR_MORE_PERSON_HOUSEHOLD_WITH_DEPENDENT_CHILDREN
AGE_OF_HRP_THIRTY_FIVE_TO_FIFTY_FOUR_TOTAL
AGE_OF_HRP_THIRTY_FIVE_TO_FIFTY_FOUR_ONE_PERSON_HOUSEHOLD
AGE_OF_HRP_THIRTY_FIVE_TO_FIFTY_FOUR_TWO_OR_MORE_PERSON_HOUSEHOLD_NO_DEPENDENT_CHILDREN
AGE_OF_HRP_THIRTY_FIVE_TO_FIFTY_FOUR_TWO_OR_MORE_PERSON_HOUSEHOLD_WITH_DEPENDENT_CHILDREN
AGE_OF_HRP_FIFTY_FIVE_TO_SIXTY_FOUR_TOTAL
AGE_OF_HRP_FIFTY_FIVE_TO_SIXTY_FOUR_ONE_PERSON_HOUSEHOLD
AGE_OF_HRP_FIFTY_FIVE_TO_SIXTY_FOUR_TWO_OR_MORE_PERSON_HOUSEHOLD_NO_DEPENDENT_CHILDREN
AGE_OF_HRP_FIFTY_FIVE_TO_SIXTY_FOUR_TWO_OR_MORE_PERSON_HOUSEHOLD_WITH_DEPENDENT_CHILDREN
AGE_OF_HRP_SIXTY_FIVE_AND_OVER_TOTAL
AGE_OF_HRP_SIXTY_FIVE_AND_OVER_ONE_PERSON_HOUSEHOLD
AGE_OF_HRP_SIXTY_FIVE_AND_OVER_TWO_OR_MORE_PERSON_HOUSEHOLD_NO_DEPENDENT_CHILDREN
AGE_OF_HRP_SIXTY_FIVE_AND_OVER_TWO_OR_MORE_PERSON_HOUSEHOLD_WITH_DEPENDENT_CHILDREN

V_ONS_UK_HOUSEHOLD_SIZE

Description

This provides classification of household spaces with at least one person living in the household.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOUSEHOLD_SIZE
ONE_PERSON_IN_HOUSEHOLD
TWO_PEOPLE_IN_HOUSEHOLD
THREE_PEOPLE_IN_HOUSEHOLD
FOUR_PEOPLE_IN_HOUSEHOLD
FIVE_PEOPLE_IN_HOUSEHOLD
SIX_PEOPLE_IN_HOUSEHOLD
SEVEN_PEOPLE_IN_HOUSEHOLD
EIGHT_OR_MORE_PEOPLE_IN_HOUSEHOLD

V_ONS_UK_HOUSEHOLD_SPACES

Description

This provides classification of household spaces with at least one person living in the household or none living in the household.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_HOUSEHOLD_SPACES
HOUSEHOLD_SPACES_WITH_AT_LEAST_ONE_USUAL_RESIDENT
HOUSEHOLD_SPACES_WITH_NO_USUAL_RESIDENTS

V_ONS_UK_INDUSTRY

Description

This provides classification of the usual residents according to their employment industry.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_INDUSTRY
A_AGRICULTURE_FORESTRY_AND_FISHING
B_MINING_AND_QUARRYING
C_MANUFACTURING
C10_TWELVE_MANUFACTURING_FOOD_BEVERAGES_AND_TOBACCO
C13_FIFTEEN_MANUFACTURING_TEXTILES_WEARING_APPAREL_AND_LEATHER_AND_RELATED_PRODUCTS
C16_SEVENTEEN_MANUFACTURING_WOOD_PAPER_AND_PAPER_PRODUCTS
C19_TWENTY_TWO_MANUFACTURING_CHEMICALS_CHEMICAL_PRODUCTS_RUBBER_AND_PLASTIC
C23_TWENTY_FIVE_MANUFACTURING_LOW_TECH
C26_THIRTY_MANUFACTURING_HIGH_TECH
C18_THIRTY_ONE_THIRTY_TWO_MANUFACTURING_OTHER
D_ELECTRICITY_GAS_STEAM_AND_AIR_CONDITIONING_SUPPLY
E_WATER_SUPPLY_SEWERAGE_WASTE_MANAGEMENT_AND_REMEDIATION_ACTIVITIES
F_CONSTRUCTION
G_WHOLESALE_AND_RETAIL_TRADE_REPAIR_OF_MOTOR_VEHICLES_AND_MOTOR_CYCLES
H_TRANSPORT_AND_STORAGE
I_ACCOMMODATION_AND_FOOD_SERVICE_ACTIVITIES
J_INFORMATION_AND_COMMUNICATION
K_FINANCIAL_AND_INSURANCE_ACTIVITIES
L_REAL_ESTATE_ACTIVITIES
M_PROFESSIONAL_SCIENTIFIC_AND_TECHNICAL_ACTIVITIES
N_ADMINISTRATIVE_AND_SUPPORT_SERVICE_ACTIVITIES
O_PUBLIC_ADMINISTRATION_AND_DEFENCE_COMPULSORY_SOCIAL_SECURITY
P_EDUCATION
Q_HUMAN_HEALTH_AND_SOCIAL_WORK_ACTIVITIES
R_S_ARTS_ENTERTAINMENT_AND_RECREATION_OTHER_SERVICE_ACTIVITIES
T_ACTIVITIES_OF_HOUSEHOLDS_AS_EMPLOYERS_UNDIFFERENTIATED_GOODS_AND_SERVICES_PRODUCING_ACTIVITIES_OF_HOUSEHOLDS_FOR_OWN_USE
U_ACTIVITIES_OF_EXTRATERRITORIAL_ORGANISATIONS_AND_BODIES

V_ONS_UK_LIVING_ARRANGEMENTS

Description

This classifies the residents of the UK according to the living arrangements.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_LIVING_ARRANGEMENTS
LIVING_IN_A_COUPLE_TOTAL
LIVING_IN_A_COUPLE_MARRIED
LIVING_IN_A_COUPLE_COHABITING_OPPOSITE_SEX
LIVING_IN_A_COUPLE_IN_A_REGISTERED_SAME_SEX_CIVIL_PARTNERSHIP_OR_COHABITING_SAME_SEX
NOT_LIVING_IN_A_COUPLE_TOTAL
NOT_LIVING_IN_A_COUPLE_SINGLE_NEVER_MARRIED_OR_NEVER_REGISTERED_A_SAME_SEX_CIVIL_PARTNERSHIP
NOT_LIVING_IN_A_COUPLE_MARRIED_OR_IN_A_REGISTERED_SAME_SEX_CIVIL_PARTNERSHIP
NOT_LIVING_IN_A_COUPLE_SEPARATED_BUT_STILL_LEGALLY_MARRIED_OR_STILL_LEGALLY_IN_A_SAME_SEX_CIVIL_PARTNERSHIP
NOT_LIVING_IN_A_COUPLE_DIVORCED_OR_FORMERLY_IN_A_SAME_SEX_CIVIL_PARTNERSHIP_WHICH_IS_NOW_LEGALLY_DISSOLVED
NOT_LIVING_IN_A_COUPLE_WIDOWED_OR_SURVIVING_PARTNER_FROM_A_SAME_SEX_CIVIL_PARTNERSHIP

V_ONS_UK_LONG_TERM_HEALTH_PROBLEM_OR_DISABILITY

Description

This provides classification of residents suffering from long term problem or disabilities

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_LONG_TERM_HEALTH_PROBLEM_OR_DISABILITY
DAY_TO_DAY_ACTIVITIES_LIMITED_A_LOT
DAY_TO_DAY_ACTIVITIES_LIMITED_A_LITTLE
DAY_TO_DAY_ACTIVITIES_NOT_LIMITED

V_ONS_UK_MULTIPLE_ETHNIC_GROUP

Description

This provides classification of households in the UK by diversity of ethnic groups of household members.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_MULTIPLE_ETHNIC_GROUPS
ONE_PERSON_HOUSEHOLD
ALL_HOUSEHOLD_MEMBERS_HAVE_THE_SAME_ETHNIC_GROUP
DIFFERENT_ETHNIC_GROUPS_BETWEEN_THE_GENERATIONS_ONLY
DIFFERENT_ETHNIC_GROUPS_WITHIN_PARTNERSHIPS_WHETHER_OR_NOT_DIFFERENT_ETHNIC_GROUPS_BETWEEN_GENERATIONS
ANY_OTHER_COMBINATION_OF_MULTIPLE_ETHNIC_GROUPS

V_ONS_UK_NS_SEC_OF_HOUSEHOLD_REFERENCE_PERSON_HRP_HRP_AGED_UNDER_65

Description

This provides classification of UK residents in the household where the Household Reference Person is aged under 65, by the NS-SeC of the Household Reference Person. NS-SeC gives us socio economic status according to the occupation.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NS_SEC
ONE_HIGHER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
ONE_ONE_LARGE_EMPLOYERS_AND_HIGHER_MANAGERIAL_AND_ADMINISTRATIVE_OCCUPATIONS
ONE_TWO_HIGHER_PROFESSIONAL_OCCUPATIONS
TWO_LOWER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
THREE_INTERMEDIATE_OCCUPATIONS
FOUR_SMALL_EMPLOYERS_AND_OWN_ACCOUNT_WORKERS
FIVE_LOWER_SUPERVISORY_AND_TECHNICAL_OCCUPATIONS
SIX_SEMI_ROUTINE_OCCUPATIONS
SEVEN_ROUTINE_OCCUPATIONS
EIGHT_NEVER_WORKED_AND_LONG_TERM_UNEMPLOYED
L14_ONE_NEVER_WORKED
L14_TWO_LONG_TERM_UNEMPLOYED
L15_FULL_TIME_STUDENTS

V_ONS_UK_NS_SEC_OF_HOUSEHOLD_REFERENCE_PERSON_HRP_PEOPLE_AGED_UNDER_65

Description

This provides classification of residents aged under 65 in households in the UK by the NS-SeC of Household Reference Person.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NS_SEC
ONE_HIGHER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
ONE_ONE_LARGE_EMPLOYERS_AND_HIGHER_MANAGERIAL_AND_ADMINISTRATIVE_OCCUPATIONS
ONE_TWO_HIGHER_PROFESSIONAL_OCCUPATIONS
TWO_LOWER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
THREE_INTERMEDIATE_OCCUPATIONS
FOUR_SMALL_EMPLOYERS_AND_OWN_ACCOUNT_WORKERS
FIVE_LOWER_SUPERVISORY_AND_TECHNICAL_OCCUPATIONS
SIX_SEMI_ROUTINE_OCCUPATIONS
SEVEN_ROUTINE_OCCUPATIONS
EIGHT_NEVER_WORKED_AND_LONG_TERM_UNEMPLOYED
L14_ONE_NEVER_WORKED
L14_TWO_LONG_TERM_UNEMPLOYED
L15_FULL_TIME_STUDENTS

V_ONS_UK_NS_SEC_OF_HOUSEHOLD_REFERENCE_PERSON_HRP_PEOPLE

Description

This provides classification of residents in households in the UK by the NS-SeC of Household Reference Person.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NS_SEC
ONE_HIGHER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
ONE_ONE_LARGE_EMPLOYERS_AND_HIGHER_MANAGERIAL_AND_ADMINISTRATIVE_OCCUPATIONS
ONE_TWO_HIGHER_PROFESSIONAL_OCCUPATIONS
TWO_LOWER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
THREE_INTERMEDIATE_OCCUPATIONS
FOUR_SMALL_EMPLOYERS_AND_OWN_ACCOUNT_WORKERS
FIVE_LOWER_SUPERVISORY_AND_TECHNICAL_OCCUPATIONS
SIX_SEMI_ROUTINE_OCCUPATIONS
SEVEN_ROUTINE_OCCUPATIONS
EIGHT_NEVER_WORKED_AND_LONG_TERM_UNEMPLOYED
L14_ONE_NEVER_WORKED
L14_TWO_LONG_TERM_UNEMPLOYED
L15_FULL_TIME_STUDENTS

V_ONS_UK_NS_SEC

Description

This provides classification of residents in the UK aged between 16 to 74 by the NS-SeC.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NS_SEC
ONE_HIGHER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
ONE_ONE_LARGE_EMPLOYERS_AND_HIGHER_MANAGERIAL_AND_ADMINISTRATIVE_OCCUPATIONS
ONE_TWO_HIGHER_PROFESSIONAL_OCCUPATIONS
L3_ONE_TRADITIONAL_EMPLOYEES
L3_TWO_NEW_EMPLOYEES
L3_THREE_TRADITIONAL_SELF_EMPLOYED
L3_FOUR_NEW_SELF_EMPLOYED
TWO_LOWER_MANAGERIAL_ADMINISTRATIVE_AND_PROFESSIONAL_OCCUPATIONS
L4_LOWER_PROFESSIONAL_AND_HIGHER_TECHNICAL_OCCUPATIONS
L4_ONE_TRADITIONAL_EMPLOYEES
L4_TWO_NEW_EMPLOYEES
L4_THREE_TRADITIONAL_SELF_EMPLOYED
L4_FOUR_NEW_SELF_EMPLOYED
L5_LOWER_MANAGERIAL_AND_ADMINISTRATIVE_OCCUPATIONS
L6_HIGHER_SUPERVISORY_OCCUPATIONS
THREE_INTERMEDIATE_OCCUPATIONS
L7_ONE_INTERMEDIATE_CLERICAL_AND_ADMINISTRATIVE_OCCUPATIONS
L7_TWO_INTERMEDIATE_SALES_AND_SERVICE_OCCUPATIONS
L7_THREE_INTERMEDIATE_TECHNICAL_AND_AUXILIARY_OCCUPATIONS
L7_FOUR_INTERMEDIATE_ENGINEERING_OCCUPATIONS
FOUR_SMALL_EMPLOYERS_AND_OWN_ACCOUNT_WORKERS
L8_EMPLOYERS_IN_SMALL_ESTABLISHMENTS
L8_ONE_EMPLOYERS_IN_SMALL_ESTABLISHMENTS_IN_INDUSTRY_COMMERCE_SERVICES_ETC
L8_TWO_EMPLOYERS_IN_SMALL_ESTABLISHMENTS_IN_AGRICULTURE
L9_OWN_ACCOUNT_WORKERS
L9_ONE_OWN_ACCOUNT_WORKERS_NON_PROFESSIONAL
L9_TWO_OWN_ACCOUNT_WORKERS_AGRICULTURE
FIVE_LOWER_SUPERVISORY_AND_TECHNICAL_OCCUPATIONS
L10_LOWER_SUPERVISORY_OCCUPATIONS
L11_LOWER_TECHNICAL_OCCUPATIONS
L11_ONE_LOWER_TECHNICAL_CRAFT_OCCUPATIONS
L11_TWO_LOWER_TECHNICAL_PROCESS_OPERATIVE_OCCUPATIONS
SIX_SEMI_ROUTINE_OCCUPATIONS
L12_ONE_SEMI_ROUTINE_SALES_OCCUPATIONS
L12_TWO_SEMI_ROUTINE_SERVICE_OCCUPATIONS
L12_THREE_SEMI_ROUTINE_TECHNICAL_OCCUPATIONS
L12_FOUR_SEMI_ROUTINE_OPERATIVE_OCCUPATIONS
L12_FIVE_SEMI_ROUTINE_AGRICULTURAL_OCCUPATIONS
L12_SIX_SEMI_ROUTINE_CLERICAL_OCCUPATIONS
L12_SEVEN_SEMI_ROUTINE_CHILDCARE_OCCUPATIONS
SEVEN_ROUTINE_OCCUPATIONS
L13_ONE_ROUTINE_SALES_AND_SERVICE_OCCUPATIONS
L13_TWO_ROUTINE_PRODUCTION_OCCUPATIONS
L13_THREE_ROUTINE_TECHNICAL_OCCUPATIONS
L13_FOUR_ROUTINE_OPERATIVE_OCCUPATIONS
L13_FIVE_ROUTINE_AGRICULTURAL_OCCUPATIONS
EIGHT_NEVER_WORKED_AND_LONG_TERM_UNEMPLOYED
L14_ONE_NEVER_WORKED
L14_TWO_LONG_TERM_UNEMPLOYED
L15_FULL_TIME_STUDENTS

V_ONS_UK_NUMBER_OF_ROOMS

Description

This provides classification of household spaces where a UK resident resides in at least one room by the number of rooms.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NUMBER_OF_ROOMS
ONE_ROOM
TWO_ROOMS
THREE_ROOMS
FOUR_ROOMS
FIVE_ROOMS
SIX_ROOMS
SEVEN_ROOMS
EIGHT_ROOMS
NINE_OR_MORE_ROOMS

V_ONS_UK_OCCUPANCY_RATING

Description

This provides classification of household by occupancy rating based on the number of rooms in the households.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_OCCUPANCY_RATING_ROOMS
OCCUPANCY_RATING_ROOMS_OF_PLUS_TWO_OR_MORE
OCCUPANCY_RATING_ROOMS_OF_PLUS_ONE
OCCUPANCY_RATING_ROOMS_OF_ZERO
OCCUPANCY_RATING_ROOMS_OF_MINUS_ONE
OCCUPANCY_RATING_ROOMS_OF_MINUS_TWO_OR_LESS

V_ONS_UK_OCCUPATION

Description

This provides classification of residents aged between 16 to 74 by their occupation.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_OCCUPATION
ONE_MANAGERS_DIRECTORS_AND_SENIOR_OFFICIALS
ELEVEN_CORPORATE_MANAGERS_AND_DIRECTORS
TWELVE_OTHER_MANAGERS_AND_PROPRIETORS
TWO_PROFESSIONAL_OCCUPATIONS
TWENTY_ONE_SCIENCE_RESEARCH_ENGINEERING_AND_TECHNOLOGY_PROFESSIONALS
TWENTY_TWO_HEALTH_PROFESSIONALS
TWENTY_THREE_TEACHING_AND_EDUCATIONAL_PROFESSIONALS
TWENTY_FOUR_BUSINESS_MEDIA_AND_PUBLIC_SERVICE_PROFESSIONALS
THREE_ASSOCIATE_PROFESSIONAL_AND_TECHNICAL_OCCUPATIONS
THIRTY_ONE_SCIENCE_ENGINEERING_AND_TECHNOLOGY_ASSOCIATE_PROFESSIONALS
THIRTY_TWO_HEALTH_AND_SOCIAL_CARE_ASSOCIATE_PROFESSIONALS
THIRTY_THREE_PROTECTIVE_SERVICE_OCCUPATIONS
THIRTY_FOUR_CULTURE_MEDIA_AND_SPORTS_OCCUPATIONS
THIRTY_FIVE_BUSINESS_AND_PUBLIC_SERVICE_ASSOCIATE_PROFESSIONALS
FOUR_ADMINISTRATIVE_AND_SECRETARIAL_OCCUPATIONS
FOURTY_ONE_ADMINISTRATIVE_OCCUPATIONS
FOURTY_TWO_SECRETARIAL_AND_RELATED_OCCUPATIONS
FIVE_SKILLED_TRADES_OCCUPATIONS
FIFTY_ONE_SKILLED_AGRICULTURAL_AND_RELATED_TRADES
FIFTY_TWO_SKILLED_METAL_ELECTRICAL_AND_ELECTRONIC_TRADES
FIFTY_THREE_SKILLED_CONSTRUCTION_AND_BUILDING_TRADES
FIFTY_FOUR_TEXTILES_PRINTING_AND_OTHER_SKILLED_TRADES
SIX_CARING_LEISURE_AND_OTHER_SERVICE_OCCUPATIONS
SIXTY_ONE_CARING_PERSONAL_SERVICE_OCCUPATIONS
SIXTY_TWO_LEISURE_TRAVEL_AND_RELATED_PERSONAL_SERVICE_OCCUPATIONS
SEVEN_SALES_AND_CUSTOMER_SERVICE_OCCUPATIONS
SEVENTY_ONE_SALES_OCCUPATIONS
SEVENTY_TWO_CUSTOMER_SERVICE_OCCUPATIONS
EIGHT_PROCESS_PLANT_AND_MACHINE_OPERATIVES
EIGHTY_ONE_PROCESS_PLANT_AND_MACHINE_OPERATIVES
EIGHTY_TWO_TRANSPORT_AND_MOBILE_MACHINE_DRIVERS_AND_OPERATIVES
NINE_ELEMENTARY_OCCUPATIONS
NINTY_ONE_ELEMENTARY_TRADES_AND_RELATED_OCCUPATIONS
NINTY_TWO_ELEMENTARY_ADMINISTRATION_AND_SERVICE_OCCUPATIONS

V_ONS_UK_PEOPLE_AGED_18_TO_64_LIVING_IN_A_ONE_ADULT_HOUSEHOLD

Description

This provides classification of usual residents in the UK between 18 to 64 by whether they live in a single adult household or not.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NUMBER_OF_ADULTS_IN_HOUSEHOLD
ONE_ADULT_IN_HOUSEHOLD
ZERO_OR_MULTIPLE_ADULTS_IN_HOUSEHOLD

V_ONS_UK_PERSONS_PER_ROOM_HOUSEHOLDS

Description

This provides classification of households in the UK by number of people per room.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NUMBER_OF_PERSONS_PER_ROOM_IN_HOUSEHOLD
UP_TO_ZERO_FIVE_PERSONS_PER_ROOM
OVER_ZERO_FIVE_AND_UP_TO_ONE_ZERO_PERSONS_PER_ROOM
OVER_ONE_ZERO_AND_UP_TO_ONE_FIVE_PERSONS_PER_ROOM
OVER_ONE_FIVE_PERSONS_PER_ROOM

V_ONS_UK_PERSONS_PER_ROOM_PEOPLE

Description

This provides classification of persons in the UK by number of people per room.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_NUMBER_OF_PERSONS_PER_ROOM_IN_HOUSEHOLD
UP_TO_ZERO_FIVE_PERSONS_PER_ROOM
OVER_ZERO_FIVE_AND_UP_TO_ONE_ZERO_PERSONS_PER_ROOM
OVER_ONE_ZERO_AND_UP_TO_ONE_FIVE_PERSONS_PER_ROOM
OVER_ONE_FIVE_PERSONS_PER_ROOM

V_ONS_UK_POPULATION_DENSITY

Description

This provides the area of the ward and population residing in the ward along with the population density.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_USUAL_RESIDENTS
AREA_HECTARES
DENSITY_NUMBER_OF_PERSONS_PER_HECTARE

V_ONS_UK_POSITION_IN_COMMUNAL_ESTABLISHMENT

Description

This provides the classification of UK residents in communal establishments by their position within the establishments.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_POSITION_IN_COMMUNAL_ESTABLISHMENT
RESIDENT
STAFF_OR_OWNER
FAMILY_MEMBER_OR_PARTNER_OF_STAFF_OR_OWNER

V_ONS_UK_PROVISION_OF_UNPAID_CARE

Description

This provides the classification of UK residents in communal establishments by the number of hours of unpaid care they provide.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_PROVISION_OF_UNPAID_CARE
PROVIDES_NO_UNPAID_CARE
PROVIDES_ONE_TO_NINETEEN_HOURS_UNPAID_CARE_A_WEEK
PROVIDES_TWENTY_TO_FOURTY_NINE_HOURS_UNPAID_CARE_A_WEEK
PROVIDES_FIFTY_OR_MORE_HOURS_UNPAID_CARE_A_WEEK

V_ONS_UK_RESIDENCE_TYPE

Description

This provides the classification of UK residents according to the type of residence.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_RESIDENCE_TYPE
LIVES_IN_A_HOUSEHOLD
LIVES_IN_A_COMMUNAL_ESTABLISHMENT

V_ONS_UK_SCHOOLCHILDREN_AND_FULL_TIME_STUDENTS_AT_THEIR_NON_TERM_TIME_ADDRESS

Description

This provides the classification of school children and full time students at their non term time according to their sex.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_PERSONS
MALES
FEMALES

V_ONS_UK_SEX

Description

This provides the classification of UK resident according to their sex.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_PERSONS
MALES
FEMALES

V_ONS_UK_TENURE_HOUSEHOLDS

Description

This provides the classification of households in the UK by Tenure.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_TENURE
OWNED_TOTAL
OWNED_OWNED_OUTRIGHT
OWNED_OWNED_WITH_A_MORTGAGE_OR_LOAN
SHARED_OWNERSHIP_PART_OWNED_AND_PART_RENTED
SOCIAL_RENTED_TOTAL
SOCIAL_RENTED_RENTED_FROM_COUNCIL_LOCAL_AUTHORITY
SOCIAL_RENTED_OTHER_SOCIAL_RENTED
PRIVATE_RENTED_TOTAL
PRIVATE_RENTED_PRIVATE_LANDLORD_OR_LETTING_AGENCY
PRIVATE_RENTED_EMPLOYER_OF_A_HOUSEHOLD_MEMBER
PRIVATE_RENTED_RELATIVE_OR_FRIEND_OF_HOUSEHOLD_MEMBER
PRIVATE_RENTED_OTHER
LIVING_RENT_FREE

V_ONS_UK_TENURE_HOUSEHOLD_REFERENCE_PERSON_AGED_65_AND_OVER

Description

This provides classification of households with a HRP aged 65 and above by Tenure.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_TENURE
OWNED
SHARED_OWNERSHIP_PART_OWNED_AND_PART_RENTED
RENTED_FROM_COUNCIL_LOCAL_AUTHORITY
OTHER_SOCIAL_RENTED
PRIVATE_RENTED
LIVING_RENT_FREE

V_ONS_UK_TENURE_PEOPLE

Description

This provides classification of residents in households by Tenure of the households.

Columns

DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_TENURE
OWNED_TOTAL
OWNED_OWNED_OUTRIGHT
OWNED_OWNED_WITH_A_MORTGAGE_OR_LOAN
SHARED_OWNERSHIP_PART_OWNED_AND_PART_RENTED
SOCIAL_RENTED_TOTAL
SOCIAL_RENTED_RENTED_FROM_COUNCIL_LOCAL_AUTHORITY
SOCIAL_RENTED_OTHER_SOCIAL_RENTED
PRIVATE_RENTED_TOTAL
PRIVATE_RENTED_PRIVATE_LANDLORD_OR_LETTING_AGENCY
PRIVATE_RENTED_EMPLOYER_OF_A_HOUSEHOLD_MEMBER
PRIVATE_RENTED_RELATIVE_OR_FRIEND_OF_HOUSEHOLD_MEMBER
PRIVATE_RENTED_OTHER
LIVING_RENT_FREE

V_ONS_UK_YEAR_LAST_WORKED

Description

This provides classification of residents between 16 to 74 years of age by year last worked.

Columns

COLUMN_NAME
DATE
GEOGRAPHY
GEOGRAPHY_CODE
ALL_CATEGORIES_YEAR_LAST_WORKED
IN_EMPLOYMENT
NOT_IN_EMPLOYMENT_TOTAL
LAST_WORKED_IN_2011
LAST_WORKED_IN_2010
LAST_WORKED_IN_2009
LAST_WORKED_IN_2008
LAST_WORKED_IN_2007
LAST_WORKED_IN_2006
LAST_WORKED_IN_2001_2005
LAST_WORKED_BEFORE_2001
NEVER_WORKED

SQL queries

Population of Male and Female in England

Top 10 areas having high Density of Female Population

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.