London Borough Demographics

CREATE TABLE london_borough_profiles_2016_data_set (
  "code" VARCHAR,
  "new_code" VARCHAR,
  "area_name" VARCHAR,
  "inner_outer_london" VARCHAR  -- Inner/ Outer London,
  "gla_population_estimate_2016" DOUBLE,
  "gla_household_estimate_2016" VARCHAR,
  "inland_area_hectares" VARCHAR  -- Inland Area (Hectares),
  "population_density_per_hectare_2016" VARCHAR  -- Population Density (per Hectare) 2016,
  "average_age_2016" DOUBLE  -- Average Age, 2016,
  "proportion_of_population_aged_0_15_2016" DOUBLE  -- Proportion Of Population Aged 0-15, 2016,
  "proportion_of_population_of_working_age_2016" DOUBLE  -- Proportion Of Population Of Working-age, 2016,
  "proportion_of_population_aged_65_and_over_2016" DOUBLE  -- Proportion Of Population Aged 65 And Over, 2016,
  "net_internal_migration_2014" VARCHAR  -- Net Internal Migration (2014),
  "net_international_migration_2014" VARCHAR  -- Net International Migration (2014),
  "net_natural_change_2014" VARCHAR  -- Net Natural Change (2014),
  "n__of_resident_population_born_abroad_2014" VARCHAR  -- % Of Resident Population Born Abroad (2014),
  "largest_migrant_population_by_country_of_birth_2011" VARCHAR  -- Largest Migrant Population By Country Of Birth (2011),
  "n__of_largest_migrant_population_2011" VARCHAR  -- % Of Largest Migrant Population (2011),
  "second_largest_migrant_population_by_country_of_birth_2011" VARCHAR  -- Second Largest Migrant Population By Country Of Birth (2011),
  "n__of_second_largest_migrant_population_2011" VARCHAR  -- % Of Second Largest Migrant Population (2011),
  "third_largest_migrant_population_by_country_of_birth_2011" VARCHAR  -- Third Largest Migrant Population By Country Of Birth (2011),
  "n__of_third_largest_migrant_population_2011" VARCHAR  -- % Of Third Largest Migrant Population (2011),
  "n__of_population_from_bame_groups_2016" VARCHAR  -- % Of Population From BAME Groups (2016),
  "n__people_aged_3_whose_main_language_is_not_english_20_e05612f1" VARCHAR  -- % People Aged 3+ Whose Main Language Is Not English (2011 Census),
  "overseas_nationals_entering_the_uk_nino_2014_15" DOUBLE  -- Overseas Nationals Entering The UK (NINo), (2014/15),
  "new_migrant_nino_rates_2014_15" DOUBLE  -- New Migrant (NINo) Rates, (2014/15),
  "largest_migrant_population_arrived_during_2014_15" VARCHAR,
  "second_largest_migrant_population_arrived_during_2014_15" VARCHAR,
  "third_largest_migrant_population_arrived_during_2014_15" VARCHAR,
  "employment_rate_2015" DOUBLE  -- Employment Rate (%) (2015),
  "male_employment_rate_2015" VARCHAR  -- Male Employment Rate (2015),
  "female_employment_rate_2015" VARCHAR  -- Female Employment Rate (2015),
  "unemployment_rate_2015" VARCHAR  -- Unemployment Rate (2015),
  "youth_unemployment_claimant_rate_18_24_dec_14" VARCHAR  -- Youth Unemployment (claimant) Rate 18-24 (Dec-14),
  "proportion_of_16_18_year_olds_who_are_neet_2014" VARCHAR  -- Proportion Of 16-18 Year Olds Who Are NEET (%) (2014),
  "proportion_of_the_working_age_population_who_claim_out_b70a61d8" VARCHAR  -- Proportion Of The Working-age Population Who Claim Out-of-work Benefits (%) (Aug-2015),
  "n__working_age_with_a_disability_2015" VARCHAR  -- % Working-age With A Disability (2015),
  "proportion_of_working_age_people_with_no_qualifications_2015" VARCHAR  -- Proportion Of Working Age People With No Qualifications (%) 2015,
  "proportion_of_working_age_with_degree_or_equivalent_an_adc649b2" VARCHAR  -- Proportion Of Working Age With Degree Or Equivalent And Above (%) 2015,
  "gross_annual_pay_2015" VARCHAR  -- Gross Annual Pay, (2015),
  "gross_annual_pay_male_2015" VARCHAR  -- Gross Annual Pay - Male (2015),
  "gross_annual_pay_female_2015" VARCHAR  -- Gross Annual Pay - Female (2015),
  "modelled_household_median_income_estimates_2012_13" VARCHAR,
  "n__adults_that_volunteered_in_past_12_months_2010_11_t_7c115b48" VARCHAR  -- % Adults That Volunteered In Past 12 Months (2010/11 To 2012/13),
  "number_of_jobs_by_workplace_2014" VARCHAR  -- Number Of Jobs By Workplace (2014),
  "n__of_employment_that_is_in_public_sector_2014" DOUBLE  -- % Of Employment That Is In Public Sector (2014),
  "jobs_density_2014" DOUBLE  -- Jobs Density, 2014,
  "number_of_active_businesses_2014" DOUBLE  -- Number Of Active Businesses, 2014,
  "two_year_business_survival_rates_started_in_2012" DOUBLE  -- Two-year Business Survival Rates (started In 2012),
  "crime_rates_per_thousand_population_2014_15" VARCHAR,
  "fires_per_thousand_population_2014" VARCHAR  -- Fires Per Thousand Population (2014),
  "ambulance_incidents_per_hundred_population_2014" VARCHAR  -- Ambulance Incidents Per Hundred Population (2014),
  "median_house_price_2014" DOUBLE  -- Median House Price, 2014,
  "average_band_d_council_tax_charge_2015_16" VARCHAR  -- Average Band D Council Tax Charge (£), 2015/16,
  "new_homes_net_2014_15_provisional" VARCHAR  -- New Homes (net) 2014/15 (provisional),
  "homes_owned_outright_2014" VARCHAR  -- Homes Owned Outright, (2014) %,
  "being_bought_with_mortgage_or_loan_2014" VARCHAR  -- Being Bought With Mortgage Or Loan, (2014) %,
  "rented_from_local_authority_or_housing_association_2014" VARCHAR  -- Rented From Local Authority Or Housing Association, (2014) %,
  "rented_from_private_landlord_2014" VARCHAR  -- Rented From Private Landlord, (2014) %,
  "n__of_area_that_is_greenspace_2005" VARCHAR  -- % Of Area That Is Greenspace, 2005,
  "total_carbon_emissions_2013" DOUBLE  -- Total Carbon Emissions (2013),
  "household_waste_recycling_rate_2014_15" VARCHAR  -- Household Waste Recycling Rate, 2014/15,
  "number_of_cars_2011_census" DOUBLE  -- Number Of Cars, (2011 Census),
  "number_of_cars_per_household_2011_census" DOUBLE  -- Number Of Cars Per Household, (2011 Census),
  "n__of_adults_who_cycle_at_least_once_per_month_2013_14" VARCHAR  -- % Of Adults Who Cycle At Least Once Per Month, 2013/14,
  "average_public_transport_accessibility_score_2014" VARCHAR  -- Average Public Transport Accessibility Score, 2014,
  "achievement_of_5_or_more_a_c_grades_at_gcse_or_equival_7d37e0e5" VARCHAR  -- Achievement Of 5 Or More A*- C Grades At GCSE Or Equivalent Including English And Maths, 2013/14,
  "rates_of_children_looked_after_2015" VARCHAR  -- Rates Of Children Looked After (2015),
  "n__of_pupils_whose_first_language_is_not_english_2015" VARCHAR  -- % Of Pupils Whose First Language Is Not English (2015),
  "n__children_living_in_out_of_work_households_2014" DOUBLE  -- % Children Living In Out-of-work Households (2014),
  "male_life_expectancy_2012_14" VARCHAR  -- Male Life Expectancy, (2012-14),
  "female_life_expectancy_2012_14" VARCHAR  -- Female Life Expectancy, (2012-14),
  "teenage_conception_rate_2014" VARCHAR  -- Teenage Conception Rate (2014),
  "life_satisfaction_score_2011_14_out_of_10" DOUBLE  -- Life Satisfaction Score 2011-14 (out Of 10),
  "worthwhileness_score_2011_14_out_of_10" DOUBLE  -- Worthwhileness Score 2011-14 (out Of 10),
  "happiness_score_2011_14_out_of_10" DOUBLE  -- Happiness Score 2011-14 (out Of 10),
  "anxiety_score_2011_14_out_of_10" DOUBLE  -- Anxiety Score 2011-14 (out Of 10),
  "childhood_obesity_prevalance_2014_15" VARCHAR  -- Childhood Obesity Prevalance (%) 2014/15,
  "people_aged_17_with_diabetes" DOUBLE  -- People Aged 17+ With Diabetes (%),
  "mortality_rate_from_causes_considered_preventable_2012_14" VARCHAR,
  "political_control_in_council" VARCHAR,
  "proportion_of_seats_won_by_conservatives_in_2014_election" VARCHAR,
  "proportion_of_seats_won_by_labour_in_2014_election" VARCHAR,
  "proportion_of_seats_won_by_lib_dems_in_2014_election" VARCHAR,
  "turnout_at_2014_local_elections" VARCHAR
);