Baselight
Sign In

RSA Heritage Index

Cambridgeshire Insight

@ukgov.rsa_heritage_index1

About this Dataset

RSA Heritage Index

The RSA (Royal Society for the encouragement of Arts, Manufactures and Commerce) is collaborating with the Heritage Lottery Fund to better understand the links between heritage and identity at the local scale. They’ve analysed over 100 datasets to produce a Heritage Index to help people understand local heritage assets and activities, and access relevant data through a single site. Data ranges from the length of canals and size of protected wildlife sites, through to the number of historic local businesses and the proportion of residents visiting museums and archives.

The Index is designed to stimulate debate about what is valued from the past, and how that influences the identity of its current residents. This can help a place achieve its aspirations to grow and prosper, socially and economically.

To help you interpret the key findings from the data, they've produced an interactive guide: What can data reveal about Britain’s heritage? https://www.thersa.org/discover/publications-and-articles/reports/seven-...

More details at: https://www.thersa.org/action-and-research/rsa-projects/public-services-...
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:33:54Z

Tables

RSA Heritage Index - England And Wales - Index Default Weighted Scores 2016

@ukgov.rsa_heritage_index1.rsa_heritage_index_england_and_wales_index_default_wei_84296489
  • 132.68 KB
  • 326 rows
  • 43 columns 

CREATE TABLE rsa_heritage_index_england_and_wales_index_default_wei_84296489 (
  "local_authority_district" VARCHAR,
  "composite_score_weighted_across_assets_and_activities__aa59ced1" DOUBLE,
  "total_rank" BIGINT,
  "ass_indexed_score_weighted_by_indicator" DOUBLE,
  "ass_rank" BIGINT,
  "act_indexed_score_weighted_by_indicator" DOUBLE,
  "act_rank" BIGINT,
  "hp_indexed_score_weighted_by_indicator" DOUBLE,
  "hp_rank" DOUBLE,
  "hbe_ass_indexed_score_weighted_by_indicator" DOUBLE,
  "hbe_ass_rank" BIGINT,
  "hbe_act_indexed_score_weighted_by_indicator" DOUBLE,
  "hbe_act_rank" BIGINT,
  "hbe_overall_indexed_score_weighted_by_indicator" DOUBLE,
  "hbe_overall_rank" BIGINT,
  "maa_ass_indexed_score_weighted_by_indicator" DOUBLE,
  "maa_ass_rank" BIGINT,
  "maa_act_indexed_score_weighted_by_indicator" DOUBLE,
  "maa_act_rank" BIGINT,
  "maa_overall_indexed_score_weighted_by_indicator" DOUBLE,
  "maa_overall_rank" BIGINT,
  "ih_ass_indexed_score_weighted_by_indicator" DOUBLE,
  "ih_ass_rank" BIGINT,
  "ih_act_indexed_score_weighted_by_indicator" DOUBLE,
  "ih_act_rank" BIGINT,
  "ih_overall_indexed_score_weighted_by_indicator" DOUBLE,
  "ih_overall_rank" BIGINT,
  "pos_ass_indexed_score_weighted_by_indicator" DOUBLE,
  "pos_ass_rank" BIGINT,
  "pos_act_indexed_score_weighted_by_indicator" DOUBLE,
  "pos_act_rank" BIGINT,
  "pos_overall_indexed_score_weighted_by_indicator" DOUBLE,
  "pos_overall_rank" BIGINT,
  "lnh_ass_indexed_score_weighted_by_indicator" DOUBLE,
  "lnh_ass_rank" BIGINT,
  "lnh_act_indexed_score_weighted_by_indicator" DOUBLE,
  "lnh_act_rank" BIGINT,
  "lnh_overall_indexed_score_weighted_by_indicator" DOUBLE,
  "lnh_overall_rank" BIGINT,
  "cm_overallact_indexed_score_weighted_by_indicator" DOUBLE,
  "cm_overallact_rank" BIGINT,
  "gi_overallact_indexed_score_weighted_by_indicator" DOUBLE,
  "gi_overallact_rank" BIGINT
);

RSA Heritage Index - England And Wales - Raw Data 2016

@ukgov.rsa_heritage_index1.rsa_heritage_index_england_and_wales_raw_data_2016
  • 169.81 KB
  • 327 rows
  • 101 columns 

CREATE TABLE rsa_heritage_index_england_and_wales_raw_data_2016 (
  "location" VARCHAR,
  "hbe_ass_listed_buildings_grade_i_no_per_local_authority" DOUBLE,
  "hbe_ass_listed_buildings_grade_ii_no_per_local_authority" DOUBLE,
  "hbe_ass_listed_buildings_grade_ii_no_per_local_authority_a60f23" DOUBLE,
  "hbe_ass_scheduled_monuments_no_per_local_authority" DOUBLE,
  "hbe_ass_pubs_listed_as_assets_of_community_value_no_pe_8022f5d7" DOUBLE,
  "hbe_ass_conservation_areas_no_per_local_authority" DOUBLE,
  "hbe_ass_registered_battlefields_no_per_local_authority" DOUBLE,
  "hbe_ass_world_heritage_sites_no_per_local_authority" DOUBLE,
  "hbe_ass_heritage_at_risk_negative_weighting_no_per_loc_060037a6" DOUBLE,
  "hbe_act_hlf_funding_2010_15_number_of_project_no_per_l_ca2d1d4e" DOUBLE,
  "hbe_act_hlf_funding_2010_15_local_authority_000s" DOUBLE,
  "hbe_act_online_searcheable_her_y_n" VARCHAR,
  "hbe_act_heritage_open_days_2014_no_per_local_authority" DOUBLE,
  "hbe_act_local_authority_non_capital_expenditure_conser_b5a60c7e" DOUBLE,
  "hbe_act_local_authority_revenue_from_sales_fees_and_ch_46e2c600" DOUBLE,
  "hbe_act_neighbourhood_plans_numberprogressed" DOUBLE,
  "hbe_act_participation_visiting_heritage_sites_of_local_b3ad8d5f" VARCHAR,
  "maa_ass_act_museums_accredited_by_arts_council_england_47308f12" DOUBLE,
  "maa_ass_major_museums_arts_council_england_major_partn_5ddf4ed8" DOUBLE,
  "maa_ass_archives_no_per_local_authority" DOUBLE,
  "maa_ass_archaeological_finds_reported_no_per_local_authority" DOUBLE,
  "maa_ass_historypins_no_per_local_authority" VARCHAR,
  "maa_act_hlf_funding_2010_15_number_of_project_no_per_l_43c2e3eb" DOUBLE,
  "maa_act_hlf_funding_2010_15_local_authority_000s" DOUBLE,
  "maa_act_arts_council_england_funding_major_partner_mus_176479c6" DOUBLE,
  "maa_act_continuously_trading_businesses_in_identified__23cdd0b4" DOUBLE,
  "maa_act_local_authority_non_capital_expenditure_museum_b566be2c" DOUBLE,
  "maa_act_local_authority_revenue_from_sales_fees_and_ch_1f94838b" DOUBLE,
  "maa_act_heritage_open_days_2014_no_per_local_authority" DOUBLE,
  "maa_act_museum_participation_rate_of_local_authority_p_87bc31e4" VARCHAR,
  "maa_act_archive_participation_rate_of_local_authority__d1777326" VARCHAR,
  "maa_act_youth_archeological_clubs_no_per_local_authority" DOUBLE,
  "ih_ass_european_route_of_industrial_heritage_sites_no__cadd389c" DOUBLE,
  "ih_ass_canals_meters_per_local_authority" DOUBLE,
  "ih_ass_railways_heritage_steam_miniature_no_per_local__89549d53" DOUBLE,
  "ih_ass_historical_ships_no_per_local_authority" DOUBLE,
  "ih_act_hlf_funding_2010_15_number_of_project_no_per_lo_d461697c" DOUBLE,
  "ih_act_hlf_funding_2010_15_local_authority_000s" DOUBLE,
  "ih_act_heritage_open_days_2014_no_per_local_authority" DOUBLE,
  "ih_act_continuously_trading_businesses_75_years_old_co_5e716d73" DOUBLE,
  "ih_act_heritage_site_participation_rate_of_local_autho_a7e87fd3" VARCHAR,
  "pos_ass_national_park_square_km_per_local_authority" VARCHAR,
  "pos_ass_country_parks_ha_per_local_authority" DOUBLE,
  "pos_ass_parks_and_gardens_grade_i_no_per_local_authority" DOUBLE,
  "pos_ass_parks_and_gardens_grade_ii_no_per_local_authority" DOUBLE,
  "pos_ass_parks_and_gardens_grade_ii_no_per_local_authorit_8d3002" DOUBLE,
  "pos_ass_traditional_orchards_ha_per_local_authority" DOUBLE,
  "pos_ass_heritage_at_risk_negative_weighting_no_per_loc_c4e6540e" DOUBLE,
  "pos_act_green_flag_parks_heritage_award_no_per_local_authority" DOUBLE,
  "pos_act_blue_flag_beaches_no_per_local_authority" DOUBLE,
  "pos_act_heritage_open_days_2014_no_per_local_authority" DOUBLE,
  "pos_act_hlf_funding_2010_15_number_of_project_no_per_l_d9b5630b" VARCHAR,
  "pos_act_hlf_funding_2010_15_local_authority_000s" VARCHAR,
  "pos_act_local_authority_capital_expenditure_open_space_4cbdd799" DOUBLE,
  "pos_act_local_authority_non_capital_expenditure_open_s_b6ac699b" DOUBLE,
  "pos_act_local_authority_revenue_from_sales_fees_and_ch_74288834" DOUBLE,
  "pos_act_historic_parks_and_gardens_participation_rate__fbcd9d65" VARCHAR,
  "lnh_ass_area_of_outstanding_natural_beauty_square_km_p_00ab03da" VARCHAR,
  "lnh_ass_special_areas_conservation_ha_per_local_authority" VARCHAR,
  "lnh_ass_special_sites_scientific_interest_ha_per_local_3550b1c0" VARCHAR,
  "lnh_ass_special_protection_areas_ha_per_local_authority" VARCHAR,
  "lnh_ass_ramsar_wetlands_ha_per_local_authority" VARCHAR,
  "lnh_ass_national_nature_reserves_ha_per_local_authority" VARCHAR,
  "lnh_ass_local_nature_reserves_ha_per_local_authority" VARCHAR,
  "lnh_ass_ancient_woodlands_ha_per_local_authority" VARCHAR,
  "lnh_ass_wildlife_trust_reserves_no_per_local_authority" VARCHAR,
  "lnh_ass_world_heritage_sites_no_per_local_authority" VARCHAR,
  "lnh_ass_heritage_coast_km_per_local_authority" VARCHAR,
  "lnh_act_engagement_watching_wildlife_number_of_people__954d81c9" VARCHAR,
  "lnh_act_perception_of_value_of_natural_environment_num_a00c94ae" VARCHAR,
  "lnh_act_volunteering_no_per_local_authority" VARCHAR,
  "lnh_act_heritage_open_days_2014_no_per_local_authority" DOUBLE,
  "lnh_act_nature_clubs_for_kids_no_per_local_authority" DOUBLE,
  "lnh_act_tcv_volunteer_organisations_no_per_local_authority" DOUBLE,
  "lnh_act_tcv_volunteers_individuals_no_per_local_authority" DOUBLE,
  "lnh_act_hlf_funding_2010_15_number_of_project_no_per_l_2a1787ff" VARCHAR,
  "lnh_act_hlf_funding_2010_15_local_authority_000s" VARCHAR,
  "lnh_act_local_authority_capital_expenditure_coast_and__42f3a024" DOUBLE,
  "lnh_act_local_authority_non_capital_expenditure_coast__b8b5b530" DOUBLE,
  "lnh_act_local_authority_revenue_from_sales_fees_and_ch_db963f4c" DOUBLE,
  "cm_act_blue_plaques_no_per_local_authority" VARCHAR,
  "cm_act_local_resident_continuity_local_authority_popul_b46a0eb6" VARCHAR,
  "cm_act_hlf_funding_2010_15_number_of_project_no_per_lo_3279b44c" DOUBLE,
  "cm_act_hlf_funding_2010_15_local_authority_000s" DOUBLE,
  "cm_act_heritage_open_days_no_per_local_authority" DOUBLE,
  "cm_act_european_designated_protection_food_and_drink_n_e73000b6" DOUBLE,
  "cm_act_continuously_trading_businesses_eg_cinemas_scho_b9b69e3f" DOUBLE,
  "cm_act_intangible_cultural_events_no_per_local_authority" DOUBLE,
  "gi_act_locality_member_organisations_with_heritage_kno_8e33916c" DOUBLE,
  "gi_act_learning_outside_the_classroom_accredited_schoo_90328ac4" DOUBLE,
  "gi_act_heritage_sector_business_count_no_per_local_authority" DOUBLE,
  "gi_act_heritage_sector_business_employment_no_per_loca_15b7857d" DOUBLE,
  "gi_act_heritage_sector_business_turnover_local_authority_000s" DOUBLE,
  "gi_act_number_of_holiday_nights_spent_bespoke_estimate_236bc75a" VARCHAR,
  "gi_act_heritage_open_days_not_elsewhere_classified_no__fee07023" DOUBLE,
  "gi_act_civic_societies_no_per_local_authority" DOUBLE,
  "gi_act_sightseeing_tours_viewing_and_visitor_centres_n_01d5d941" DOUBLE,
  "gi_act_local_authority_capital_expenditure_heritage_an_5c28777d" DOUBLE,
  "gi_act_local_authority_non_capital_expenditure_heritag_84949a3a" DOUBLE
);

RSA Heritage Index - England And Wales - League Table Results 2016

@ukgov.rsa_heritage_index1.rsa_heritage_index_england_and_wales_league_results_2016
  • 141.49 KB
  • 327 rows
  • 42 columns 

CREATE TABLE rsa_heritage_index_england_and_wales_league_results_2016 (
  "total_score" DOUBLE,
  "total_score_location" VARCHAR,
  "assets_score_ass" DOUBLE,
  "ass_location" VARCHAR,
  "activities_score_act" DOUBLE,
  "act_location" VARCHAR,
  "heritage_potential_hp" DOUBLE,
  "hp_location" VARCHAR,
  "historic_built_environment_hbe_ass_score" DOUBLE,
  "hbe_ass_location" VARCHAR,
  "hbe_act_score" DOUBLE,
  "hbe_act_location" VARCHAR,
  "hbe_overall_score" DOUBLE,
  "hbe_overall_location" VARCHAR,
  "museums_archives_and_artefacts_maa_ass_score" DOUBLE,
  "museums_archives_and_artefacts_maa_ass_location" VARCHAR,
  "museums_archives_and_artefacts_maa_act_score" DOUBLE,
  "museums_archives_and_artefacts_maa_act_location" VARCHAR,
  "museums_archives_and_artefacts_maa_overall_score" DOUBLE,
  "museums_archives_and_artefacts_maa_overall_location" VARCHAR,
  "industrial_heritage_ih_ass_score" DOUBLE,
  "ih_ass_location" VARCHAR,
  "ih_act_score" DOUBLE,
  "ih_act_location" VARCHAR,
  "ih_overall_score" DOUBLE,
  "ih_overall_location" VARCHAR,
  "parks_and_open_space_pos_ass_score" DOUBLE,
  "pos_ass_location" VARCHAR,
  "pos_act_score" DOUBLE,
  "pos_act_location" VARCHAR,
  "pos_overall_score" DOUBLE,
  "pos_overall_location" VARCHAR,
  "landscape_and_natural_heritage_lnh_ass_score" DOUBLE,
  "lnh_ass_location" VARCHAR,
  "lnh_act_score" DOUBLE,
  "lnh_act_location" VARCHAR,
  "lnh_overall_score" DOUBLE,
  "lnh_overall_location" VARCHAR,
  "cultures_and_memories_cm_overall_act_score" DOUBLE,
  "cm_overall_act_location" VARCHAR,
  "general_infrastructure_gi_overall_act_score" DOUBLE,
  "gi_overall_act_location" VARCHAR
);

Share link

Anyone who has the link will be able to view this.