City Of Tempe 2021 Business Survey Data

CREATE TABLE table_1 (
  "id" BIGINT,
  "q1_how_safe_do_you_think_your" BIGINT,
  "q2_how_safe_do_you_think_your" BIGINT,
  "q3_01_1_police_services" BIGINT,
  "q3_02_2_fire_services" BIGINT,
  "q3_03_3_emergency_medical_s" BIGINT,
  "q3_04_4_water_and_sewer_ser" BIGINT,
  "q3_05_5_parks" BIGINT,
  "q3_06_6_recreation_services" BIGINT,
  "q3_07_7_street_maintenance" BIGINT,
  "q3_08_8_street_lighting" BIGINT,
  "q3_09_9_street_sweeping" BIGINT,
  "q3_10_10_stormwater_drainag" BIGINT,
  "q3_11_11_public_transportat" BIGINT,
  "q3_12_12_planning" BIGINT,
  "q3_13_13_enforcement_of_cod" BIGINT,
  "q3_14_14_construction_codes" BIGINT,
  "q3_15_15_business_resource" BIGINT,
  "q3_16_16_public_landscaping" BIGINT,
  "q3_17_17_traffic_on_city_st" BIGINT,
  "q4_01_1st" BIGINT,
  "q4_02_2nd" BIGINT,
  "q4_03_3rd" BIGINT,
  "q5_how_would_you_rate_the_phys" BIGINT,
  "q6_01_1_overall_image_of_the" BIGINT,
  "q6_02_2_quality_of_local_sch" BIGINT,
  "q6_03_3_low_crime_rate" BIGINT,
  "q6_04_4_availability_of_trai" BIGINT,
  "q6_05_5_level_of_taxation" BIGINT,
  "q6_06_6_access_to_highways" BIGINT,
  "q6_07_7_access_to_sky_harbor" BIGINT,
  "q6_08_8_availability_of_qual" BIGINT,
  "q6_09_9_availability_of_hous" BIGINT,
  "q6_10_10_proximity_to_other" BIGINT,
  "q6_11_11_availability_of_pub" BIGINT,
  "q6_12_12_availability_of_lib" BIGINT,
  "q6_13_13_attitude_of_local_g" BIGINT,
  "q6_14_14_availability_of_tel" BIGINT,
  "q6_15_15_proximity_to_arizon" BIGINT,
  "q6_16_16_quality_attractiven" BIGINT,
  "q6_17_17_availability_of_par" BIGINT,
  "q6_18_18_appearance_of_priva" BIGINT,
  "q6_19_19_up_to_date_construc" BIGINT,
  "q6_20_20_ease_of_obtaining_c" BIGINT,
  "q6_21_21_other" BIGINT,
  "q7_01_1st" BIGINT,
  "q7_02_2nd" BIGINT,
  "q7_03_3rd" BIGINT,
  "q8_are_you_aware_of_the_city_s" BIGINT,
  "q9_do_you_think_that_the_city" BIGINT,
  "q10_do_you_think_the_tax_struc" BIGINT,
  "q11_01_1_the_availability" BIGINT,
  "q11_02_2_the_quality_of_wo" BIGINT,
  "q11_03_3_the_stability_of" BIGINT,
  "q11_04_4_the_education_tec" BIGINT,
  "q12_01_1_land_use_codes" BIGINT,
  "q12_02_2_landscaping_codes" BIGINT,
  "q12_03_3_requirement_for_pro" BIGINT,
  "q12_04_4_business_signage_re" BIGINT,
  "q12_05_5_business_parking_re" BIGINT,
  "q12_06_6_trash_disposal_regu" BIGINT,
  "q12_07_7_alternatives_to_lan" BIGINT,
  "q12_08_8_construction_codes" BIGINT,
  "q12_09_9_commercial_trash_re" BIGINT,
  "q13_01_expanding_1our_busines" BIGINT,
  "q13_02_renovating_2our_busine" BIGINT,
  "q13_03_relocating_to_another" BIGINT,
  "q13_04_relocating_to_another" BIGINT,
  "q13_05_downsizing" BIGINT,
  "q13_06_closing" BIGINT,
  "q13_07_none_of_these" BIGINT,
  "q13_09_don_t_know" BIGINT,
  "q14_overall_how_would_you_rat" BIGINT,
  "q15_01_tempe_11_cable_tv" BIGINT,
  "q15_02_recreation_opportunit" BIGINT,
  "q15_03_cit3_websites" BIGINT,
  "q15_04_water_bill_newsletter" BIGINT,
  "q15_05_cit5_social_media_tw" BIGINT,
  "q15_06_cit6_videos_on_6outu" BIGINT,
  "q15_07_tv_news" BIGINT,
  "q15_08_cit8_meetings" BIGINT,
  "q15_09_cit9_e_mail_subscript" BIGINT,
  "q15_10_tempe_311_b10_phone" BIGINT,
  "q15_11_radio_news" BIGINT,
  "q15_12_newspapers" BIGINT,
  "q16_01_1_code_compliance" VARCHAR,
  "q16_02_2_construction_perm" VARCHAR,
  "q16_03_3_planning_and_deve" VARCHAR,
  "q16_04_4_special_events" VARCHAR,
  "q16_05_5_police" VARCHAR,
  "q16_06_6_fire" VARCHAR,
  "q16_07_7_emergency_medical" VARCHAR,
  "q16_08_8_streets_and_traff" VARCHAR,
  "q16_09_9_stormwater_flood" VARCHAR,
  "q16_10_10_utility_billing" VARCHAR,
  "q16_11_11_small_business_d" VARCHAR,
  "q16_12_12_economic_develop" VARCHAR,
  "q16_13_13_trash_and_recycl" VARCHAR,
  "q16a_01_1_code_compliance" BIGINT,
  "q16a_02_2_construction_permi" BIGINT
);