Dataset: London Borough Demographics

About this Dataset

London Borough Demographics

Content

The London boroughs profiles Data about demography, diversity, labour market, economy, community safety, housing, environment, transport, children, health and governance

Acknowledgements

Thanks for taking your time to look at this data and thanks for any suggestions.

Inspiration

I am new to data analysis and I would like some suggestions on how to analyse this dataset and possibly create a visualasation, or predictive analysis.

Tables

London Borough Profiles 2016 Data Set

@kaggle.marshald_london_boroughs.london_borough_profiles_2016_data_set

89.08 KB
40 rows
85 columns


CREATE TABLE london_borough_profiles_2016_data_set (
  "code" VARCHAR,
  "new_code" VARCHAR,
  "area_name" VARCHAR,
  "inner_outer_london" VARCHAR,
  "gla_population_estimate_2016" DOUBLE,
  "gla_household_estimate_2016" VARCHAR,
  "inland_area_hectares" VARCHAR,
  "population_density_per_hectare_2016" VARCHAR,
  "average_age_2016" DOUBLE,
  "proportion_of_population_aged_0_15_2016" DOUBLE,
  "proportion_of_population_of_working_age_2016" DOUBLE,
  "proportion_of_population_aged_65_and_over_2016" DOUBLE,
  "net_internal_migration_2014" VARCHAR,
  "net_international_migration_2014" VARCHAR,
  "net_natural_change_2014" VARCHAR,
  "n__of_resident_population_born_abroad_2014" VARCHAR,
  "largest_migrant_population_by_country_of_birth_2011" VARCHAR,
  "n__of_largest_migrant_population_2011" VARCHAR,
  "second_largest_migrant_population_by_country_of_birth_2011" VARCHAR,
  "n__of_second_largest_migrant_population_2011" VARCHAR,
  "third_largest_migrant_population_by_country_of_birth_2011" VARCHAR,
  "n__of_third_largest_migrant_population_2011" VARCHAR,
  "n__of_population_from_bame_groups_2016" VARCHAR,
  "n__people_aged_3_whose_main_language_is_not_english_20_e05612f1" VARCHAR,
  "overseas_nationals_entering_the_uk_nino_2014_15" DOUBLE,
  "new_migrant_nino_rates_2014_15" DOUBLE,
  "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,
  "male_employment_rate_2015" VARCHAR,
  "female_employment_rate_2015" VARCHAR,
  "unemployment_rate_2015" VARCHAR,
  "youth_unemployment_claimant_rate_18_24_dec_14" VARCHAR,
  "proportion_of_16_18_year_olds_who_are_neet_2014" VARCHAR,
  "proportion_of_the_working_age_population_who_claim_out_b70a61d8" VARCHAR,
  "n__working_age_with_a_disability_2015" VARCHAR,
  "proportion_of_working_age_people_with_no_qualifications_2015" VARCHAR,
  "proportion_of_working_age_with_degree_or_equivalent_an_adc649b2" VARCHAR,
  "gross_annual_pay_2015" VARCHAR,
  "gross_annual_pay_male_2015" VARCHAR,
  "gross_annual_pay_female_2015" VARCHAR,
  "modelled_household_median_income_estimates_2012_13" VARCHAR,
  "n__adults_that_volunteered_in_past_12_months_2010_11_t_7c115b48" VARCHAR,
  "number_of_jobs_by_workplace_2014" VARCHAR,
  "n__of_employment_that_is_in_public_sector_2014" DOUBLE,
  "jobs_density_2014" DOUBLE,
  "number_of_active_businesses_2014" DOUBLE,
  "two_year_business_survival_rates_started_in_2012" DOUBLE,
  "crime_rates_per_thousand_population_2014_15" VARCHAR,
  "fires_per_thousand_population_2014" VARCHAR,
  "ambulance_incidents_per_hundred_population_2014" VARCHAR,
  "median_house_price_2014" DOUBLE,
  "average_band_d_council_tax_charge_2015_16" VARCHAR,
  "new_homes_net_2014_15_provisional" VARCHAR,
  "homes_owned_outright_2014" VARCHAR,
  "being_bought_with_mortgage_or_loan_2014" VARCHAR,
  "rented_from_local_authority_or_housing_association_2014" VARCHAR,
  "rented_from_private_landlord_2014" VARCHAR,
  "n__of_area_that_is_greenspace_2005" VARCHAR,
  "total_carbon_emissions_2013" DOUBLE,
  "household_waste_recycling_rate_2014_15" VARCHAR,
  "number_of_cars_2011_census" DOUBLE,
  "number_of_cars_per_household_2011_census" DOUBLE,
  "n__of_adults_who_cycle_at_least_once_per_month_2013_14" VARCHAR,
  "average_public_transport_accessibility_score_2014" VARCHAR,
  "achievement_of_5_or_more_a_c_grades_at_gcse_or_equival_7d37e0e5" VARCHAR,
  "rates_of_children_looked_after_2015" VARCHAR,
  "n__of_pupils_whose_first_language_is_not_english_2015" VARCHAR,
  "n__children_living_in_out_of_work_households_2014" DOUBLE,
  "male_life_expectancy_2012_14" VARCHAR,
  "female_life_expectancy_2012_14" VARCHAR,
  "teenage_conception_rate_2014" VARCHAR,
  "life_satisfaction_score_2011_14_out_of_10" DOUBLE,
  "worthwhileness_score_2011_14_out_of_10" DOUBLE,
  "happiness_score_2011_14_out_of_10" DOUBLE,
  "anxiety_score_2011_14_out_of_10" DOUBLE,
  "childhood_obesity_prevalance_2014_15" VARCHAR,
  "people_aged_17_with_diabetes" DOUBLE,
  "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
);