Great Streets Business Survey 2015

CREATE TABLE table_1 (
  "result_id" BIGINT,
  "corridor" VARCHAR,
  "q11_business_type" VARCHAR  -- Q11. Business Type,
  "q12_business_format" VARCHAR  -- Q12. Business Format,
  "q13_do_you_own_or_rent_your_business_space" VARCHAR  -- Q13. Do You Own Or Rent Your Business Space?,
  "q14_since_what_year_have_you_owned_or_rented_this_space" DOUBLE  -- Q14. Since What Year Have You Owned Or Rented This Space?,
  "q15_since_what_year_have_you_been_in_operation_in_this_space" DOUBLE  -- Q15. Since What Year Have You Been In Operation In This Space?,
  "q16_are_you_a_part_of_a_business_improvement_district__af1cf43e" VARCHAR  -- Q16. Are You A Part Of A Business Improvement District, Community Benefit District, Chamber Of Commerce, Or Similar Organizatio,
  "q17_what_neighborhood_is_your_business_located_in" VARCHAR  -- Q17. What Neighborhood Is Your Business Located In?,
  "q18_why_did_you_choose_to_locate_your_business_in_this_4618f625" VARCHAR  -- Q18. Why Did You Choose To Locate Your Business In This Neighborhood?,
  "q19_in_the_next_12_months_do_you_expect_an_increase_de_b00b2478" VARCHAR  -- Q19. In The Next 12 Months, Do You Expect An Increase, Decrease, Or No Change In The Number Of Employees/staff?,
  "q20_in_the_next_12_months_do_you_expect_an_increase_de_7bc1aed0" VARCHAR  -- Q20. In The Next 12 Months, Do You Expect An Increase, Decrease, Or No Change In The Number Of Patrons?,
  "q21_in_the_next_12_months_do_you_expect_an_increase_de_a1861dc7" VARCHAR  -- Q21. In The Next 12 Months, Do You Expect An Increase, Decrease, Or No Change In The Amount Of Business Debt?,
  "q22_in_the_next_12_months_do_you_expect_an_increase_de_9557c337" VARCHAR  -- Q22. In The Next 12 Months, Do You Expect An Increase, Decrease, Or No Change In The Amount Of Revenue?,
  "q23_in_the_next_12_months_do_you_expect_an_increase_de_45b77bff" VARCHAR  -- Q23. In The Next 12 Months, Do You Expect An Increase, Decrease, Or No Change In The Amount Of Profit?,
  "q24_how_many_full_time_employees_currently_work_at_thi_f8ef8fb5" DOUBLE  -- Q24. How Many Full Time Employees Currently Work At This Business? (Other Than The Owners),
  "q25_how_many_part_time_employees_currently_work_at_thi_79f575e7" DOUBLE  -- Q25. How Many Part Time Employees Currently Work At This Business? (Other Than The Owners),
  "q26_what_are_your_average_gross_sales_on_a_weekday" DOUBLE  -- Q26. What Are Your Average Gross Sales On A Weekday?,
  "q27_what_are_your_average_gross_sales_on_a_weekend_day" DOUBLE  -- Q27. What Are Your Average Gross Sales On A Weekend Day?,
  "q28_what_is_the_busiest_time_of_day_on_weekdays" VARCHAR  -- Q28. What Is The Busiest Time Of Day On Weekdays?,
  "q29_what_is_the_second_busiest_time_of_day_on_weekdays" VARCHAR  -- Q29. What Is The Second Busiest Time Of Day On Weekdays?,
  "q30_what_is_the_busiest_time_of_day_on_weekends" VARCHAR  -- Q30. What Is The Busiest Time Of Day On Weekends?,
  "q31_what_is_the_second_busiest_time_of_day_on_weekends" VARCHAR  -- Q31. What Is The Second Busiest Time Of Day On Weekends?,
  "q32_what_percentage_of_your_patrons_arrive_by_car" DOUBLE  -- Q32. What Percentage Of Your Patrons Arrive By Car?,
  "q33_what_percentage_of_your_patrons_arrive_on_foot" DOUBLE  -- Q33. What Percentage Of Your Patrons Arrive On Foot?,
  "q34_what_percentage_of_your_patrons_arrive_by_bike" DOUBLE  -- Q34. What Percentage Of Your Patrons Arrive By Bike?,
  "q35_what_percentage_of_your_patrons_arrive_by_transit" DOUBLE  -- Q35. What Percentage Of Your Patrons Arrive By Transit?,
  "q36_what_percentage_of_your_patrons_arrive_by_another_mode" DOUBLE  -- Q36. What Percentage Of Your Patrons Arrive By Another Mode?,
  "q37_how_long_does_the_typical_patron_spend_in_your_est_75ad4224" VARCHAR  -- Q37. How Long Does The Typical Patron Spend In Your Establishment?,
  "q38_what_percent_of_your_patrons_are_return_customers" VARCHAR  -- Q38. What Percent Of Your Patrons Are ""return Customers""?,
  "q39_what_percent_of_your_patrons_are_local" VARCHAR  -- Q39. What Percent Of Your Patrons Are ""local""?,
  "q40_what_percent_of_your_patrons_are_non_locals" VARCHAR  -- Q40. What Percent Of Your Patrons Are ""non-locals""?,
  "q41_how_much_money_does_a_typical_patron_spend_in_your_f5681669" DOUBLE  -- Q41. How Much Money Does A Typical Patron Spend In Your Establishment (in Dollars)?,
  "q42_does_your_average_patron_visit_other_local_businesses" VARCHAR  -- Q42. Does Your Average Patron Visit Other Local Businesses?,
  "q43_is_there_sufficient_parking_in_the_area_for_your_business" VARCHAR  -- Q43. Is There Sufficient Parking In The Area For Your Business?,
  "q44_for_patrons_who_drive_where_do_you_tell_them_to_pa_b3bfa661" VARCHAR  -- Q44. For Patrons Who Drive, Where Do You Tell Them To Park Their Car?,
  "q47_surveyor_pre_install_or_post_install" VARCHAR  -- Q47. SURVEYOR: Pre-Install Or Post-Install?,
  "q48_surveyor_is_it_raining" VARCHAR  -- Q48. SURVEYOR: Is It Raining?
);