Great Streets Pedestrian Survey 2015

CREATE TABLE table_1 (
  "id" BIGINT,
  "surveyed_date" TIMESTAMP,
  "surveyed_time" VARCHAR,
  "surveyed_end_date" VARCHAR,
  "q1_what_brings_you_to_this_neighborhood_today" VARCHAR  -- Q1. What Brings You To This Neighborhood Today?,
  "q2_how_often_do_you_visit_the_neighborhood" VARCHAR  -- Q2. How Often Do You Visit The Neighborhood?,
  "q3_how_much_time_do_you_typically_spend_when_you_visit" VARCHAR  -- Q3. How Much Time Do You Typically Spend When You Visit?,
  "q4_how_do_you_typically_get_to_this_neighborhood_selec_0c14ab96" VARCHAR  -- Q4. How Do You Typically Get To This Neighborhood? Select Primary (next: Secondary),
  "q5_how_do_you_typically_get_to_this_neighborhood_selec_0499f127" VARCHAR  -- Q5. How Do You Typically Get To This Neighborhood? (select Secondary),
  "q6_how_much_money_do_you_typically_spend_when_you_visi_c83bfa68" VARCHAR  -- Q6. How Much Money Do You Typically Spend When You Visit? (at Businesses In The Area),
  "q7_in_this_neighborhood_how_often_do_you_recognize_som_dd4cef9a" VARCHAR  -- Q7. In This Neighborhood, How Often Do You Recognize Someone By Face Or Name?,
  "q8_this_neighborhood_is_clean_and_well_maintained" VARCHAR  -- Q8. This Neighborhood Is Clean And Well-maintained,
  "q9_this_neighborhood_is_safe" VARCHAR  -- Q9. This Neighborhood Is Safe,
  "q10_this_neighborhood_is_attractive" VARCHAR  -- Q10. This Neighborhood Is Attractive,
  "q11_this_neighborhood_is_active_and_lively" VARCHAR  -- Q11. This Neighborhood Is Active And Lively,
  "q12_this_neighborhood_is_a_place_where_it_s_easy_to_ta_eeb8e808" VARCHAR  -- Q12. This Neighborhood Is A Place Where It's Easy To Talk To Others (who I May Not Have Known Before),
  "q13_this_neighborhood_has_a_strong_identity" VARCHAR  -- Q13. This Neighborhood Has A Strong Identity,
  "q14_this_neighborhood_is_in_an_area_with_a_lot_of_noise" VARCHAR  -- Q14. This Neighborhood Is In An Area With A Lot Of Noise,
  "q15_when_you_visit_the_neighborhood_how_often_are_you__0a770ef4" VARCHAR  -- Q15. When You Visit The Neighborhood, How Often Are You Accompanied By Anyone Under 16 Years Old?,
  "q16_when_you_visit_the_neighborhood_how_often_are_you__ddf247eb" VARCHAR  -- Q16. When You Visit The Neighborhood, How Often Are You Accompanied By Anyone Over 65 Years Old?,
  "q17_when_you_visit_the_neighborhood_how_often_are_you__37aed527" VARCHAR  -- Q17. When You Visit The Neighborhood, How Often Are You Accompanied By Anyone Mobility Assisted?,
  "q18_when_you_visit_the_neighborhood_how_often_are_you__c8c0b263" VARCHAR  -- Q18. When You Visit The Neighborhood, How Often Are You Accompanied By Anyone Who Is A Family Member?,
  "q19_what_year_were_you_born" DOUBLE  -- Q19. What Year Were You Born?,
  "q20_your_gender_identity" VARCHAR  -- Q20. Your Gender Identity:,
  "q21_your_ethnic_identity" VARCHAR  -- Q21. Your Ethnic Identity:,
  "q22_your_racial_identity" VARCHAR  -- Q22. Your Racial Identity:,
  "q23_what_is_your_home_zipcode" DOUBLE  -- Q23. What Is Your Home Zipcode?,
  "q25_surveyor_is_it_raining" VARCHAR  -- Q25. SURVEYOR: Is It Raining?,
  "q26_surveyor_location" VARCHAR  -- Q26. SURVEYOR: Location,
  "q27_location_between" VARCHAR  -- Q27. Location Between ,,
  "q28_location_between_and" VARCHAR  -- Q28. Location Between AND ,,
  "q29_surveyor_side_of_street_for_this_interview" VARCHAR  -- Q29. SURVEYOR: Side Of Street For This Interview
);