2022 MusicCensus Details

CREATE TABLE table_1 (
  "county_of_residence" VARCHAR,
  "residence_distance_from_downtown_in_miles" DOUBLE,
  "city_of_austin_resident" VARCHAR,
  "primary_music_ecosystem_sector" VARCHAR,
  "music_business_structure" VARCHAR,
  "work_location" VARCHAR,
  "years_experience" VARCHAR,
  "music_education" VARCHAR,
  "community_or_business_participation" VARCHAR,
  "restored_pre_pandemic_workload" VARCHAR,
  "registrations_memberships" VARCHAR,
  "suggested_assistance_for_royalty_collecting" VARCHAR,
  "intent_to_continue_music_career_next_3_years" VARCHAR,
  "intent_to_stay_in_austin_next_3_years" VARCHAR,
  "work_space_status_including_venue_performance_space" VARCHAR,
  "conditions_of_current_lease" VARCHAR,
  "intent_to_renew_current_lease" VARCHAR,
  "suggested_financial_tools" VARCHAR,
  "suggested_terms_for_outside_investment" VARCHAR,
  "confidence_navigating_grant_process" VARCHAR,
  "suggested_grant_assistance" VARCHAR,
  "suggested_music_training_topics" VARCHAR,
  "suggested_level_of_music_training" VARCHAR,
  "creatives_income_from_live_performance_locally" VARCHAR,
  "creatives_income_from_live_performance_touring" VARCHAR,
  "creatives_income_related_to_recordings" VARCHAR,
  "creatives_income_related_to_songwriting" VARCHAR,
  "creatives_income_related_to_studio_work" VARCHAR,
  "creatives_income_related_to_merchandise" VARCHAR,
  "creatives_income_related_to_teaching" VARCHAR,
  "creatives_paid_performances_per_month_currently" VARCHAR,
  "creatives_percentage_of_gigs_with_base_guarantee" DOUBLE,
  "creatives_work_also_as_gig_presenter" VARCHAR,
  "creatives_annual_spending_on_new_recordings" DOUBLE,
  "creatives_annual_spending_on_publicity_promotion" DOUBLE,
  "creatives_annual_spending_on_web_or_social_media" DOUBLE,
  "creatives_annual_spending_on_supplies" DOUBLE,
  "creatives_annual_spending_on_rehearsal_or_work_space" DOUBLE,
  "creatives_annual_spending_on_gear_or_rentals" DOUBLE,
  "creatives_annual_spending_on_merchandise" DOUBLE,
  "creatives_annual_spending_on_accounting_or_legal" DOUBLE,
  "creatives_percentage_of_annual_spending_paid_to_local_providers" DOUBLE,
  "creatives_hiring_for_booking" VARCHAR,
  "creatives_hiring_for_management" VARCHAR,
  "creatives_hiring_for_record_label" VARCHAR,
  "creatives_hiring_for_merchandise" VARCHAR,
  "creatives_hiring_for_publicity_social_media" VARCHAR,
  "creatives_hiring_for_recording_studio" VARCHAR,
  "creatives_hiring_for_equipment_supplies" VARCHAR,
  "creatives_hiring_for_publishing_licensing" VARCHAR,
  "creatives_hiring_for_legal_accounting" VARCHAR,
  "presenter_ownership_structure" VARCHAR,
  "presenter_venue_type" VARCHAR,
  "presenter_role_of_live_music" VARCHAR,
  "presenter_venue_capacity" VARCHAR,
  "presenter_outdoor_live_music_possible" VARCHAR,
  "presenter_ranking_of_pressures_talent_costs_1_highest_10_lowest" DOUBLE,
  "presenter_ranking_of_pressures_changing_audience_behav_e53c7668" DOUBLE  -- PRESENTER Ranking Of Pressures CHANGING AUDIENCE BEHAVIORS 1 Highest 10 Lowest,
  "presenter_ranking_of_pressures_labor_1_highest_10_lowest" DOUBLE,
  "presenter_ranking_of_pressures_property_tax_1_highest_10_lowest" DOUBLE,
  "presenter_ranking_of_pressures_marketing_1_highest_10_lowest" DOUBLE,
  "presenter_ranking_of_pressures_ordinances_permits_1_hi_16fd6bd8" DOUBLE  -- PRESENTER Ranking Of Pressures ORDINANCES PERMITS 1 Highest 10 Lowest,
  "presenter_ranking_of_pressures_unpredictability_of_cos_07cd39b7" DOUBLE  -- PRESENTER Ranking Of Pressures UNPREDICTABILITY OF COSTS 1 Highest 10 Lowest,
  "presenter_ranking_of_pressures_neighborhood_redevelopm_cdb33df4" DOUBLE  -- PRESENTER Ranking Of Pressures NEIGHBORHOOD REDEVELOPMENT 1 Highest 10 Lowest,
  "presenter_ranking_of_pressures_building_operations_1_h_0d4d7aa1" DOUBLE  -- PRESENTER Ranking Of Pressures BUILDING OPERATIONS 1 Highest 10 Lowest,
  "presenter_percentage_of_talent_deals_paid_by_guarantee_bd34c466" VARCHAR  -- PRESENTER Percentage Of Talent Deals Paid By Guarantee As Business Expense,
  "presenter_percentage_of_talent_deals_paid_by_guarantee_a5d77fd0" VARCHAR  -- PRESENTER Percentage Of Talent Deals Paid By Guarantee From Door Proceeds,
  "presenter_percentage_of_talent_deals_paid_by_percentag_17777dbd" VARCHAR  -- PRESENTER Percentage Of Talent Deals Paid By Percentage Of Door Only,
  "presenter_percentage_of_talent_deals_paid_by_fixed_per_dff462f6" VARCHAR  -- PRESENTER Percentage Of Talent Deals Paid By Fixed Percentage Of Bar Sales,
  "presenter_percentage_of_talent_deals_paid_by_tips_only" VARCHAR,
  "presenter_local_talent_bookings_as_percentage_of_total_bookings" VARCHAR,
  "presenter_confidence_booking_local_talent_next_3_years" VARCHAR,
  "industry_professional_experience_in_13_subcategories" VARCHAR,
  "industry_percentage_of_work_related_to_music" VARCHAR,
  "industry_ranking_of_client_geography_austin_area" VARCHAR,
  "industry_ranking_of_client_geography_rest_of_usa" VARCHAR,
  "industry_ranking_of_client_geography_international" VARCHAR,
  "health_insurance_currently_covered" VARCHAR,
  "health_insurance_provider" VARCHAR,
  "health_services" VARCHAR,
  "reasons_for_not_pursuing_help_from_haam_or_sims" VARCHAR,
  "choice_for_care_when_sick_or_need_healthcare" VARCHAR,
  "health_wellness_concerns" VARCHAR,
  "affordability_struggles" VARCHAR,
  "received_covid_related_relief" VARCHAR,
  "covid_relief_was_first_ever_government_support_for_music_person" VARCHAR,
  "current_housing" VARCHAR,
  "housing_changes_over_past_2_years" VARCHAR,
  "race" VARCHAR,
  "hispanic_latino_latina_latinx_origin" VARCHAR,
  "age" VARCHAR,
  "gender" VARCHAR,
  "sexual_orientation" VARCHAR,
  "dei_austin_music_scene_hostile_friendly" VARCHAR,
  "dei_austin_music_scene_homogeneous_diverse" VARCHAR,
  "dei_austin_music_scene_racist_inclusive" VARCHAR,
  "dei_austin_music_scene_disrespectful_respectful" VARCHAR,
  "dei_austin_music_scene_competitive_cooperative" VARCHAR,
  "dei_austin_music_scene_contentious_collegial" VARCHAR,
  "dei_austin_music_scene_sexist_non_sexist" VARCHAR
);