Scotland's Health, Housing And Crime Statistics
Exploring Multifaceted Issues with Machine Learning
@kaggle.thedevastator_scotland_s_health_housing_and_crime_statistics
Exploring Multifaceted Issues with Machine Learning
@kaggle.thedevastator_scotland_s_health_housing_and_crime_statistics
CREATE TABLE statistical_indicators (
"unnamed_0" BIGINT,
"data_zone" VARCHAR,
"house_prices" DOUBLE,
"travel_times_minutes_to_gp_surgeries_by_public_transport" DOUBLE,
"travel_times_minutes_to_post_office_by_public_transport" DOUBLE,
"travel_times_minutes_to_retail_centre_by_public_transport" DOUBLE,
"travel_times_minutes_to_gp_surgeries_by_car" DOUBLE,
"travel_times_minutes_to_petrol_station_by_car" DOUBLE,
"travel_times_minutes_to_post_office_by_car" DOUBLE,
"travel_times_minutes_to_primary_school_by_car" DOUBLE,
"travel_times_minutes_to_secondary_school_by_car" DOUBLE,
"travel_times_minutes_to_retail_centre_by_car" DOUBLE,
"chimney_fires_ratio" DOUBLE,
"dwelling_fires_ratio" DOUBLE,
"other_building_fires_ratio" DOUBLE,
"other_primary_fires_ratio" DOUBLE,
"outdoor_fires_ratio" DOUBLE,
"refuse_fires_ratio" DOUBLE,
"vehicle_fires_ratio" DOUBLE,
"accidental_chimney_fires_ratio" DOUBLE,
"accidental_dwelling_fires_ratio" DOUBLE,
"accidental_other_building_fires_ratio" DOUBLE,
"accidental_other_primary_fires_ratio" DOUBLE,
"accidental_outdoor_fires_ratio" DOUBLE,
"accidental_refuse_fires_ratio" DOUBLE,
"accidental_vehicle_fires_ratio" DOUBLE,
"not_accidental_chimney_fires_ratio" DOUBLE,
"not_accidental_dwelling_fires_ratio" DOUBLE,
"not_accidental_other_building_fires_ratio" DOUBLE,
"not_accidental_other_primary_fires_ratio" DOUBLE,
"not_accidental_outdoor_fires_ratio" DOUBLE,
"not_accidental_refuse_fires_ratio" DOUBLE,
"not_accidental_vehicle_fires_ratio" DOUBLE,
"children_0_15_living_in_low_income_families_ratio" DOUBLE,
"children_0_19_living_in_low_income_families_ratio" DOUBLE,
"educational_attainment_of_school_leavers_score" DOUBLE,
"school_attendance_ratio" DOUBLE,
"land_area_in_hectares" DOUBLE,
"urban_rural_classification" DOUBLE,
"age_of_first_time_mothers_19_years_and_under_ratio" DOUBLE,
"age_of_first_time_mothers_35_years_and_older_ratio" DOUBLE,
"mothers_currently_smoking_ratio" DOUBLE,
"mothers_former_smokers_ratio" DOUBLE,
"mothers_never_smoked_ratio" DOUBLE,
"low_birthweight_less_than_2500g_babies_single_births_ratio" DOUBLE,
"dwellings_per_hectare_ratio" DOUBLE,
"detached_dwellings_ratio" DOUBLE,
"flats_ratio" DOUBLE,
"semi_detached_dwellings_ratio" DOUBLE,
"terraced_dwellings_ratio" DOUBLE,
"dwellings_of_unknown_type_ratio" DOUBLE,
"mothers_not_known_if_they_smoke_ratio" DOUBLE,
"long_term_empty_households_ratio" DOUBLE,
"occupied_households_ratio" DOUBLE,
"second_home_households_ratio" DOUBLE,
"vacant_households_ratio" DOUBLE,
"households_with_occupied_exemptions_ratio" DOUBLE,
"households_with_unoccupied_exemptions_ratio" DOUBLE,
"households_with_single_adult_discounts_ratio" DOUBLE,
"crime_indicators_ratio" DOUBLE,
"employment_deprivation_ratio" DOUBLE,
"comparative_illness_factor" DOUBLE
);
Anyone who has the link will be able to view this.