CYC Budget Consultation

CREATE TABLE budget_consultation_2016_17_answers (
  "respondentid" BIGINT,
  "collectionmethod" VARCHAR,
  "startdate" VARCHAR,
  "enddate" VARCHAR,
  "ward" VARCHAR,
  "q1_increased_council_tax_levels" VARCHAR,
  "q1_increased_charges" VARCHAR,
  "q1_provided_fewer_services" VARCHAR,
  "q2_parking_currently_use_service" VARCHAR,
  "q2_parking_willing_to_pay_more" VARCHAR,
  "q2_household_and_bulky_waste_collection_currently_use_service" VARCHAR,
  "q2_household_and_bulky_waste_collection_willing_to_pay_more" VARCHAR,
  "q2_planning_services_currently_use_service" VARCHAR,
  "q2_planning_services_willing_to_pay_more" VARCHAR,
  "q2_use_of_swimming_pools_currently_use_service" VARCHAR,
  "q2_use_of_swimming_pools_willing_to_pay_more" VARCHAR,
  "q2_use_of_sports_centres_currently_use_service" VARCHAR,
  "q2_use_of_sports_centres_willing_to_pay_more" VARCHAR,
  "q2_use_of_public_toilets_currently_use_service" VARCHAR,
  "q2_use_of_public_toilets_willing_to_pay_more" VARCHAR,
  "q2_community_centres_currently_use_service" VARCHAR,
  "q2_community_centres_yes" VARCHAR,
  "q2_adult_education_courses_currently_use_service" VARCHAR,
  "q2_adult_education_courses_willing_to_pay_more" VARCHAR,
  "q2_home_care_fees_currently_use_service" VARCHAR,
  "q2_home_care_fees_willing_to_pay_more" VARCHAR,
  "q3_childrens_social_care_services_funding" VARCHAR,
  "q3_adults_social_care_services_funding" VARCHAR,
  "q3_services_for_young_people_funding" VARCHAR,
  "q3_housing_and_homelessness_funding" VARCHAR,
  "q3_libraries_funding" VARCHAR,
  "q3_theatres_and_museums_funding" VARCHAR,
  "q3_parks_and_open_spaces_funding" VARCHAR,
  "q3_sport_and_leisure_facilities_events_and_activities_funding" VARCHAR,
  "q3_support_for_schools_funding" VARCHAR,
  "q3_waste_and_recycling_funding" VARCHAR,
  "q3_street_cleaning_funding" VARCHAR,
  "q3_crime_prevention_and_community_safety_funding" VARCHAR,
  "q3_road_and_footpath_maintenance_funding" VARCHAR,
  "q3_funding_for_public_transport_funding" VARCHAR,
  "q3_stimulating_the_economy_eg_creating_jobs_funding" VARCHAR,
  "q3_public_health_funding" VARCHAR,
  "please_give_us_your_comments" VARCHAR
);

CREATE TABLE budget_consultation_2017_18_answers (
  "respondentid" BIGINT,
  "startdate" VARCHAR,
  "enddate" VARCHAR,
  "q1_i_am_answering_this_survey_as_a" VARCHAR  -- Q1 I Am Answering This Survey As A:,
  "q2_increased_council_tax_levels" VARCHAR,
  "q2_increased_charges" VARCHAR,
  "q2_provided_fewer_services" VARCHAR,
  "q3_do_you_support_an_increase_in_council_tax_to_fund_a_ad563ea8" VARCHAR  -- Q3 Do You Support An Increase In Council Tax To Fund Adult Social Care And By How Much?,
  "q4_childrens_social_care_services" VARCHAR,
  "q4_adults_social_care_services_funding" VARCHAR,
  "q4_services_for_young_people_eg_youth_clubs_careers_ad_01f818cd" VARCHAR  -- Q4 Services For Young People Eg Youth Clubs, Careers Advice Funding,
  "q4_housing_and_homelessness_funding" VARCHAR,
  "q4_libraries_funding" VARCHAR,
  "q4_theatres_and_museums_funding" VARCHAR,
  "q4_parks_and_open_spaces_funding" VARCHAR,
  "q4_sport_and_leisure_facilities_events_and_activities_funding" VARCHAR  -- Q4 Sport And Leisure Facilities, Events And Activities Funding,
  "q4_support_for_schools_funding" VARCHAR,
  "q4_waste_and_recycling_funding" VARCHAR,
  "q4_street_cleaning_funding" VARCHAR,
  "q4_crime_prevention_and_community_safety_funding" VARCHAR,
  "q4_road_and_footpath_maintenance_funding" VARCHAR,
  "q4_funding_for_public_transport_funding" VARCHAR,
  "ward" VARCHAR,
  "any_further_comments_on_the_budget" VARCHAR
);

CREATE TABLE budget_consultation_2018_19_answers (
  "respondent_id" BIGINT,
  "collector_id" BIGINT,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "q1_i_am_answering_this_survey" VARCHAR  -- Q1 I Am Answering This Survey:,
  "q2_my_postcode_eg_yo1_6ga" VARCHAR  -- Q2 My Postcode (eg YO1–6GA):,
  "q3_increased_council_tax_levels" VARCHAR,
  "q3_increased_charges_for_services" VARCHAR,
  "q3_provided_fewer_services" VARCHAR,
  "q3_provided_services_more_efficiently_by_working_differently" VARCHAR,
  "q4_do_you_support_an_increase_in_council_tax_to_fund_a_efc3b10b" VARCHAR  -- Q4 Do You Support An Increase In Council Tax To Fund Adult Social Care And By How Much?,
  "q5_maintenance_of_council_houses" VARCHAR,
  "q5_maintenance_and_development_of_highways_and_infrast_17b4d673" VARCHAR  -- Q5 Maintenance And Development Of Highways And Infrastructure Assets,
  "q5_maintenance_and_refurbishment_of_council_premises" VARCHAR,
  "q5_maintenance_of_historic_assets_and_facilities" VARCHAR,
  "q5_maintenance_and_refurbishment_of_parks_play_areas_a_1db3afae" VARCHAR  -- Q5 Maintenance And Refurbishment Of Parks, Play Areas And Libraries,
  "q5_maintenance_and_development_of_leisure_facilities" VARCHAR,
  "q5_maintenance_and_upkeep_of_schools" VARCHAR,
  "q5_maintenance_and_development_of_it_systems_to_suppor_b59d8760" VARCHAR  -- Q5 Maintenance And Development Of IT Systems To Support Frontline Services,
  "q5_investment_in_the_commercial_property_portfolio" VARCHAR,
  "q5_various_regeneration_initiatives" VARCHAR,
  "q5_flood_defence_measures" VARCHAR,
  "q5_renewable_energy_to_reduce_council_and_city_energy_bills" VARCHAR,
  "q6_do_you_have_any_further_comments_on_capital_investment" VARCHAR  -- Q6 Do You Have Any Further Comments On Capital Investment?,
  "q7_children_s_social_care_services" VARCHAR,
  "q7_adult_s_social_care_services" VARCHAR,
  "q7_services_for_young_people_eg_youth_clubs_careers_advice" VARCHAR  -- Q7 Services For Young People Eg Youth Clubs, Careers Advice,
  "q7_housing_and_homelessness" VARCHAR,
  "q7_libraries" VARCHAR,
  "q7_parks_and_open_spaces" VARCHAR,
  "q7_sport_and_leisure_facilities_events_and_activities" VARCHAR  -- Q7 Sport And Leisure Facilities, Events And Activities,
  "q7_support_for_schools" VARCHAR,
  "q7_waste_and_recycling" VARCHAR,
  "q7_street_cleaning" VARCHAR,
  "q7_crime_prevention_and_community_safety" VARCHAR,
  "q7_road_and_footpath_maintenance" VARCHAR,
  "q7_funding_for_public_transport" VARCHAR,
  "q8_supported_employment_workshops_and_offering_custome_bfef90a6" VARCHAR  -- Q8 Supported Employment Workshops And Offering Customers Work Experience In Other Settings,
  "q8_commissioned_contracted_services_offering_a_range_o_77148f3c" VARCHAR  -- Q8 Commissioned Contracted Services Offering A Range Of Support Which Are Considered Critical In Delivering Our Early Intervention And Prevention Approach,
  "q8_early_intervention_and_prevention_contracts" VARCHAR,
  "q8_emergency_planning_this_is_already_at_minimum_level_93845a0f" VARCHAR  -- Q8 Emergency Planning; This Is Already At Minimum Levels Required To Plan And Co-ordinate Our Response To Significant Events,
  "q8_community_safety_including_management_and_delivery__a9e16393" VARCHAR  -- Q8 Community Safety Including Management And Delivery Of Our Response To Anti Social Behaviour,
  "q9_re_design_adult_social_care_services_to_reduce_the__39de90fe" VARCHAR  -- Q9 Re-design Adult Social Care Services To Reduce The Number Of Customers Accessing Care, Which In Turn Will Affect The Size Of The Assessment And Care Management Function Needed To Support Customers,
  "q9_explore_opportunities_for_joint_working_with_health_3cece1b0" VARCHAR  -- Q9 Explore Opportunities For Joint Working With Health Colleagues,
  "q9_simplify_and_standardise_practice_and_process_shari_11e9b983" VARCHAR  -- Q9 Simplify And Standardise Practice And Process, Sharing Best Practice,
  "q9_use_technology_to_increase_the_amount_of_time_our_s_ecf8febc" VARCHAR  -- Q9 Use Technology To Increase The Amount Of Time Our Staff Spend Supporting Residents,
  "q9_encourage_self_assessment_so_customers_can_determin_80d20d5b" VARCHAR  -- Q9 Encourage Self Assessment So Customers Can Determine For Themselves Whether They Are Likely To Be Eligible For Services,
  "q9_review_existing_contracts_to_determine_if_efficienc_f8107d38" VARCHAR  -- Q9 Review Existing Contracts To Determine If Efficiencies Can Be Made By Retendering, Commissioning With Health Or Through Other Opportunities,
  "q9_in_house_small_day_services_reviewed_and_remodelled" VARCHAR,
  "q9_reviewing_the_management_of_yorhome_our_social_lett_394da55e" VARCHAR  -- Q9 Reviewing The Management Of YorHome (our Social Lettings Agency) And Management Of Housing Stock On Behalf Of Housing Associations,
  "q9_a_saving_from_undertaking_work_on_empty_homes_for_o_83f55271" VARCHAR  -- Q9 A Saving From Undertaking Work On Empty Homes For Other Councils,
  "q9_look_to_externally_trade_our_housing_repairs_servic_b58dacfe" VARCHAR  -- Q9 Look To Externally Trade Our Housing Repairs Service To Deliver Income,
  "q10_do_you_have_any_further_comments_on_services_in_he_d805cef7" VARCHAR  -- Q10 Do You Have Any Further Comments On Services In Health, Housing And Adult Social Care?,
  "q11_education_psychology_the_statutory_assessment_serv_58d013bb" VARCHAR  -- Q11 Education Psychology; The Statutory Assessment Service For Special Educational Needs (SEN) Children,
  "q11_children_s_social_care_services_reductions_to_soci_55b72fd7" VARCHAR  -- Q11 Children’s Social Care Services; Reductions To Social Care Staffing Levels Have Been Ruled Out As This May Place Vulnerable Children At Risk,
  "q11_early_intervention_fund_a_range_of_small_grants_to_edad9d4a" VARCHAR  -- Q11 Early Intervention Fund; A Range Of Small Grants To Voluntary Sector Organisations Who Support Children And Young People Plan Priorities,
  "q11_investment_in_the_troubled_families_programme_to_e_68aa92c5" VARCHAR  -- Q11 Investment In The ‘Troubled Families’ Programme To Ensure We Achieve Our Payment By Results Target,
  "q11_core_grant_funding_to_organisations_such_as_citize_0dbb7dc5" VARCHAR  -- Q11 Core Grant Funding To Organisations Such As Citizen’s Advice, Council For Voluntary Services And Welfare Benefits Unit,
  "q11_ward_committee_funding" VARCHAR,
  "q12_restructure_the_childcare_strategy_team_focused_on_20382d57" VARCHAR  -- Q12 Restructure The Childcare Strategy Team, Focused On Delivering Our Statutory Duty To Ensure Sufficient Places In Early Years Provision, To Avoid Duplication Of Work And Reflect Changes In Government Policy,
  "q12_savings_in_the_early_years_learning_and_welfare_te_14183a5c" VARCHAR  -- Q12 Savings In The Early Years Learning And Welfare Team, Which Provides Support And Advice To Schools (private And Voluntary Settings), As Schools And Other Early Years Providers Can Commission And Fund Services Directly,
  "q12_review_of_home_to_school_transport_provision" VARCHAR,
  "q12_support_the_development_of_local_specialist_foster_218490fb" VARCHAR  -- Q12 Support The Development Of Local Specialist Foster Carer Capacity To ’Make York Home' For Most Of Our Looked After Children,
  "q12_develop_alternative_provision_that_provides_target_b03d5f7d" VARCHAR  -- Q12 Develop Alternative Provision That Provides Targeted Specialist Care For Children With The Most Complex Needs To Support Them In The Long Term Care Of Their Families,
  "q12_reduction_in_the_york_museums_trust_ymt_grant_contribution" VARCHAR  -- Q12 Reduction In The York Museums Trust (YMT) Grant Contribution,
  "q12_re_tendering_the_library_service" VARCHAR,
  "q13_do_you_have_any_further_comments_on_services_in_ch_8360a35a" VARCHAR  -- Q13 Do You Have Any Further Comments On Services In Children, Education And Communities?,
  "q14_in_legal_services_work_relating_to_childcare" VARCHAR  -- Q14 In Legal Services; Work Relating To Childcare,
  "q14_in_financial_procedures_financial_assessments_for__3b3a15a7" VARCHAR  -- Q14 In Financial Procedures; Financial Assessments For Vulnerable Adults,
  "q14_core_statutory_services_such_a_financial_accounts__4ae75be3" VARCHAR  -- Q14 Core Statutory Services Such A Financial Accounts And Legal Work,
  "q14_information_governance_e_g_foi_s_and_data_management" VARCHAR  -- Q14 Information Governance E.g. FOI’s And Data Management,
  "q15_reduction_in_staffing_and_general_efficiencies_acr_c9ca94a8" VARCHAR  -- Q15 Reduction In Staffing And General Efficiencies Across Services,
  "q15_opportunities_to_generate_additional_income_throug_4d7bbc28" VARCHAR  -- Q15 Opportunities To Generate Additional Income Through West Offices,
  "q16_do_you_have_any_further_comments_on_services_in_cu_114a917e" VARCHAR  -- Q16 Do You Have Any Further Comments On Services In Customer And Corporate Services?,
  "q17_maintain_current_levels_of_charges_and_services_fo_be466cc2" VARCHAR  -- Q17 Maintain Current Levels Of Charges And Services For Domestic Waste Customers,
  "q17_maintain_current_levels_of_charges_and_opening_tim_81bbdd50" VARCHAR  -- Q17 Maintain Current Levels Of Charges And Opening Times For Services Operating From Household Waste Recycling Centres (HWRCs),
  "q17_as_a_lead_local_flood_authority_under_the_flood_an_8923ce4e" VARCHAR  -- Q17 As A Lead Local Flood Authority Under The Flood And Water Management Act, We Are Required To Deliver A Range Of Responsibilities For Flood Risk Management,
  "q17_the_highways_budget_for_day_to_day_maintenance_e_g_f9c35725" VARCHAR  -- Q17 The Highways Budget For Day To Day Maintenance E.g. Potholes, Gully Emptying And Bridge Maintenance,
  "q17_the_winter_maintenance_gritting_budget" VARCHAR  -- Q17 The Winter Maintenance (gritting) Budget,
  "q17_the_dial_and_ride_service_public_transport_provisi_9203d2cc" VARCHAR  -- Q17 The Dial And Ride Service; Public Transport Provision For The Most Vulnerable In Society,
  "q17_school_crossing_patrols" VARCHAR,
  "q17_the_concessionary_fares_scheme_will_remain_unchanged" VARCHAR,
  "q17_the_current_level_of_subsidised_bus_services_will__d6767e07" VARCHAR  -- Q17 The Current Level Of Subsidised Bus Services Will Be Maintained,
  "q18_significant_capital_investment_within_highways_to__1ebd52a7" VARCHAR  -- Q18 Significant Capital Investment Within Highways To Slow Down Deterioration Of The Network And Implement New Working Practices/technology To Undertake Repairs,
  "q18_review_waste_rounds_to_ensure_collections_are_as_e_c43ac97e" VARCHAR  -- Q18 Review Waste Rounds To Ensure Collections Are As Efficient As Possible,
  "q18_use_external_providers_and_where_possible_share_st_78a904dd" VARCHAR  -- Q18 Use External Providers And, Where Possible, Share Staff Resources With Other Councils In Public Protection, Planning, Development Management, Building Control And Highway Regulation,
  "q18_increase_car_parking_charges_which_are_a_key_incom_2ed76cec" VARCHAR  -- Q18 Increase Car Parking Charges Which Are A Key Income Generator Providing Revenue For Highways And Transport Expenditure,
  "q18_investigate_potential_sites_where_civil_camera_enf_db24132f" VARCHAR  -- Q18 Investigate Potential Sites Where Civil (camera) Enforcement Of Bus Lanes Would Reduce Delays To Public Transport,
  "q18_seek_opportunities_for_further_grants_gaining_exte_16e86955" VARCHAR  -- Q18 Seek Opportunities For Further Grants - Gaining External Funding For Discretionary Transport Expenditure,
  "q18_increase_community_involvement_to_facilitate_a_red_211584fd" VARCHAR  -- Q18 Increase Community Involvement To Facilitate A Reduction In Grounds Maintenance And Cleansing Budgets By Transferring Spaces To Community Management,
  "q18_reduce_the_grant_to_make_it_york_miy_over_time_as__a4f4ace0" VARCHAR  -- Q18 Reduce The Grant To Make It York (MIY) Over Time As We Expect MIY To Deliver Additional Income Streams And Efficiencies,
  "q18_radical_review_of_assets_to_potentially_rationalis_26663c2e" VARCHAR  -- Q18 Radical Review Of Assets To Potentially Rationalise, Generate Additional Income And Achieve Additional Capital Receipts,
  "q19_do_you_have_any_further_comments_on_services_in_ec_4f61be07" VARCHAR  -- Q19 Do You Have Any Further Comments On Services In Economy And Place?,
  "q20_would_you_be_willing_to_volunteer_to_maintain_an_e_112f852e" VARCHAR  -- Q20 Would You Be Willing To Volunteer To Maintain An Existing Service?,
  "q21_if_yes_in_which_area_would_you_be_most_interested__9d9edaf1" VARCHAR  -- Q21 If Yes, In Which Area Would You Be Most Interested And Willing To Volunteer?,
  "q22_name" VARCHAR,
  "q22_address" VARCHAR,
  "q22_city_town" VARCHAR,
  "q22_postcode" VARCHAR,
  "q22_email_address" VARCHAR
);

CREATE TABLE budget_consultation_2019_20_online_budget_slider_answers (
  "council_tax_levels_income" VARCHAR  -- Council Tax Levels (Income),
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "social_care_precept_levels_income" VARCHAR  -- Social Care Precept Levels (Income),
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "fees_and_charges_income" VARCHAR  -- Fees And Charges (Income),
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "children_education_and_communities_expenditure" VARCHAR  -- Children, Education And Communities (Expenditure),
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "health_housing_and_adult_social_care_expenditure" VARCHAR  -- Health, Housing And Adult Social Care (Expenditure),
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "transport_highways_and_environment_expenditure" VARCHAR  -- Transport, Highways And Environment (Expenditure),
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "corporate_services_expenditure" VARCHAR  -- Corporate Services (Expenditure),
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "investment_capital_programme_expenditure" VARCHAR  -- Investment (Capital) Programme (Expenditure),
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "totals" VARCHAR,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "final_comments" VARCHAR
);

CREATE TABLE budget_consultation_2019_20_paper_survey_answers (
  "by_how_much_would_you_support_an_increase_in_council_tax" VARCHAR  -- By How Much Would You Support An Increase In Council Tax?,
  "by_how_much_would_you_support_an_increase_in_council_t_8adbde28" VARCHAR  -- By How Much Would You Support An Increase In Council Tax To Fund Adult Social Care?,
  "thinking_about_each_of_the_following_services_which_do_f44c1893" VARCHAR  -- Thinking About Each Of The Following Services, Which Do You Believe Should Have Its Funding Stay The Same And Which Should Have Its Funding Reduced Or Increased?,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "do_you_agree_or_disagree_that_we_should_prioritise_the_22602d4c" VARCHAR  -- Do You Agree Or Disagree That We Should Prioritise The Following Areas For Investment? (Please Choose Your Top Three Priorities),
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "do_you_believe_that_car_parking_charges_are_fair_need__0ad81e99" VARCHAR  -- Do You Believe That Car Parking Charges Are Fair, Need Increasing Or Decreasing?,
  "do_you_believe_that_other_fees_and_charges_are_fair_ne_dfd4656a" VARCHAR  -- Do You Believe That Other Fees And Charges Are Fair, Need Increasing Or Decreasing?,
  "would_you_like_us_to_explore_alternative_options_aroun_5eddfdf1" VARCHAR  -- Would You Like Us To Explore Alternative Options Around Bulky Household Waste Collections?,
  "would_you_like_us_to_explore_opportunities_to_increase_2d3dcd81" VARCHAR  -- Would You Like Us To Explore Opportunities To Increase The Amount Of Plastics That We Recycle In The Near Future?
);