Public Passenger Vehicle Chauffeur Survey - 2021

CREATE TABLE table_1 (
  "respondent_id" BIGINT,
  "date" TIMESTAMP,
  "how_long_have_you_been_a_taxicab_livery_or_lyft_uber_v_5be4e3d8" VARCHAR  -- How Long Have You Been A Taxicab, Livery, Or Lyft/Uber/Via Chauffeur In Chicago?,
  "when_do_you_usually_drive_as_a_chauffeur" VARCHAR  -- When Do You Usually Drive As A Chauffeur?,
  "i_usually_prefer_to_drive_as_a_chauffeur" VARCHAR  -- I Usually Prefer To Drive As A Chauffeur:,
  "how_do_you_decide_when_to_drive_as_a_chauffeur" VARCHAR  -- How Do You Decide When To Drive As A Chauffeur?,
  "which_best_describes_the_vehicle_you_use_d_most_often__50232f81" VARCHAR  -- Which Best Describes The Vehicle You Use(d) Most Often As A Chauffeur?,
  "which_best_describes_the_vehicle_you_use_d_most_often__a8a16b57" VARCHAR  -- Which Best Describes The Vehicle You Use(d) Most Often As A Chauffeur? Other (please Specify),
  "vehicle_wav" VARCHAR  -- Vehicle WAV?,
  "insurance_increase" VARCHAR  -- Insurance Increase?,
  "in_2019_before_covid_did_you_operate_as_a_taxicab_live_1a39fb93" VARCHAR  -- In 2019 (before COVID), Did You Operate As A Taxicab, Livery, Or Lyft/Uber/Via Chauffeur?,
  "in_2019_before_covid_what_best_described_your_status_a_1d46bfe2" VARCHAR  -- In 2019 (before COVID), What Best Described Your Status As A Chauffeur?,
  "in_2019_before_covid_why_did_you_operate_as_a_chauffeur" VARCHAR  -- In 2019 (before COVID), Why Did You Operate As A Chauffeur?,
  "in_2019_before_covid_what_best_described_your_status_a_bd498f6f" VARCHAR  -- In 2019 (before COVID), What Best Described Your Status As A Chauffeur? Other Response,
  "in_2019_before_covid_how_much_of_your_total_earnings_w_e53939ed" VARCHAR  -- In 2019 (before COVID), How Much Of Your Total Earnings Were From Being A Taxicab, Livery, Or Lyft/Uber/Via Driver?,
  "estimate_your_average_weekly_chauffeur_expenses_in_201_0979a9fe" VARCHAR  -- Estimate Your Average Weekly Chauffeur Expenses In 2019 (before COVID). Use Whole Numbers Only. (example: For $50, Enter 50) Vehicle Loan Or Lease,
  "estimate_your_average_weekly_chauffeur_expenses_in_201_5ae5af39" VARCHAR  -- Estimate Your Average Weekly Chauffeur Expenses In 2019 (before COVID). Use Whole Numbers Only. (example: For $50, Enter 50) Vehicle Insurance,
  "estimate_your_average_weekly_chauffeur_expenses_in_201_e10c36b8" VARCHAR  -- Estimate Your Average Weekly Chauffeur Expenses In 2019 (before COVID). Use Whole Numbers Only. (example: For $50, Enter 50) Vehicle Maintainance,
  "estimate_your_average_weekly_chauffeur_expenses_in_201_9148697c" VARCHAR  -- Estimate Your Average Weekly Chauffeur Expenses In 2019 (before COVID). Use Whole Numbers Only. (example: For $50, Enter 50) Fuel,
  "other_chauffeur_expenses" VARCHAR,
  "what_else_described_you_in_2019_before_covid" VARCHAR  -- What Else Described You In 2019 (before COVID)?,
  "what_else_described_you_in_2019_before_covid_other" VARCHAR  -- What Else Described You In 2019 (before COVID)? - Other,
  "did_you_provide_taxicab_chauffeur_services_in_2019_bef_231a3cfa" VARCHAR  -- Did You Provide TAXICAB Chauffeur Services In 2019 (before COVID)?,
  "during_weeks_you_drove_a_taxicab_how_many_hours_did_yo_56c048a7" VARCHAR  -- During Weeks You Drove A Taxicab, How Many Hours Did You Operate Per Week On Average Driving Passengers?,
  "during_weeks_you_drove_a_taxicab_how_many_hours_did_yo_31dfad85" VARCHAR  -- During Weeks You Drove A Taxicab, How Many Hours Did You Operate Per Week On Average Waiting For And Driving Passengers?,
  "taxi_weekly_earnings_net_pay" VARCHAR  -- Taxi Weekly Earnings - Net Pay,
  "taxi_weekly_earnings_tips" VARCHAR  -- Taxi Weekly Earnings - Tips,
  "taxi_weekly_earnings_advertising" VARCHAR  -- Taxi Weekly Earnings - Advertising,
  "taxi_hourly_earnings_net_pay" VARCHAR  -- Taxi Hourly Earnings - Net Pay,
  "did_you_use_lyft_uber_or_via_to_operate_as_chauffeur_i_5b121115" VARCHAR  -- Did You Use Lyft, Uber, Or Via To Operate As Chauffeur In 2019 (before COVID)?,
  "which_apps_did_you_use_in_2019_before_covid" VARCHAR  -- Which Apps Did You Use In 2019 (before COVID)?,
  "how_did_you_choose_which_apps_to_use" VARCHAR  -- How Did You Choose Which Apps To Use?,
  "how_did_you_choose_which_apps_to_use_other" VARCHAR  -- How Did You Choose Which Apps To Use? - Other,
  "how_often_do_you_use_multiple_gig_work_apps_at_the_sam_bdb281f1" VARCHAR  -- How Often Do You Use Multiple Gig-work Apps At The Same Time? (Example: Go Online With Lyft/Uber And Instacart At The Same Time),
  "which_lyft_uber_via_services_did_you_provide_in_2019_b_c971d3b8" VARCHAR  -- Which Lyft/Uber/Via Services Did You Provide In 2019 (before COVID)? (select All That Apply),
  "during_weeks_you_used_lyft_uber_via_how_many_hours_did_6a031b75" VARCHAR  -- During Weeks You Used Lyft/Uber/Via, How Many Hours Did You Operate As A Chauffeur Per Week On Average Driving Passengers?,
  "during_weeks_you_used_lyft_uber_via_how_many_hours_did_f94ba7e9" VARCHAR  -- During Weeks You Used Lyft/Uber/Via, How Many Hours Did You Operate As A Chauffeur Per Week On Average Waiting For And Driving Passengers?,
  "tnp_weekly_earnings_net_pay" VARCHAR  -- TNP Weekly Earnings - Net Pay,
  "tnp_weekly_earnings_tips" VARCHAR  -- TNP Weekly Earnings - Tips,
  "tnp_weekly_earnings_advertising" VARCHAR  -- TNP Weekly Earnings - Advertising,
  "during_weeks_you_used_lyft_uber_via_how_much_did_you_e_73931d03" VARCHAR  -- During Weeks You Used Lyft/Uber/Via, How Much Did You Earn On Average Per Hour (net Pay After Taxes; Do Not Subtract Expenses)?,
  "did_you_provide_livery_chauffeur_services_in_2019_before_covid" VARCHAR  -- Did You Provide LIVERY Chauffeur Services In 2019 (before COVID)?,
  "during_weeks_you_were_a_livery_driver_how_many_hours_d_6fd4740f" VARCHAR  -- During Weeks You Were A Livery Driver, How Many Hours Did You Operate Per Week On Average Driving Passengers?,
  "during_weeks_you_were_a_livery_driver_how_many_hours_d_200ccb72" VARCHAR  -- During Weeks You Were A Livery Driver, How Many Hours Did You Operate Per Week On Average Waiting For And Driving Passengers?,
  "livery_weekly_earnings_net_pay" VARCHAR  -- Livery Weekly Earnings - Net Pay,
  "livery_weekly_earnings_tips" VARCHAR  -- Livery Weekly Earnings - Tips,
  "livery_weekly_earnings_advertising" VARCHAR  -- Livery Weekly Earnings - Advertising,
  "during_weeks_you_were_a_livery_driver_how_much_did_you_1355acea" VARCHAR  -- During Weeks You Were A Livery Driver, How Much Did You Earn On Average Per Hour (net Pay After Taxes; Do Not Subtract Expenses)?,
  "were_you_a_taxicab_livery_or_lyft_uber_via_chauffeur_i_fd49261e" VARCHAR  -- Were You A Taxicab, Livery, Or Lyft/Uber/Via Chauffeur In April-December 2020 (during COVID)?,
  "in_2020_during_covid_when_did_you_operate_as_a_taxicab_c86de697" VARCHAR  -- In 2020 (during COVID), When Did You Operate As A Taxicab, Livery, Or Lyft/Uber/Via Chauffeur? (select All That Apply),
  "in_2020_during_covid_which_services_did_you_provide" VARCHAR  -- In 2020 (during COVID), Which Services Did You Provide?,
  "in_2020_during_covid_why_did_you_operate_as_a_chauffeu_ff67c2d7" VARCHAR  -- In 2020 (during COVID), Why Did You Operate As A Chauffeur? (select All That Apply),
  "in_2020_during_covid_why_did_you_operate_as_a_chauffeur_other" VARCHAR  -- In 2020 (during COVID), Why Did You Operate As A Chauffeur? - Other,
  "in_2020_during_covid_what_best_described_your_status_a_c0dca4af" VARCHAR  -- In 2020 (during COVID), What Best Described Your Status As A Chauffeur?,
  "in_2020_during_covid_how_much_of_your_total_earnings_w_89beaec1" VARCHAR  -- In 2020 (during COVID), How Much Of Your Total Earnings Were From Being A Taxicab, Livery, Or Lyft/Uber/Via Driver?,
  "what_else_described_you_in_2020_during_covid_select_al_02eea199" VARCHAR  -- What Else Described You In 2020 (during COVID)? (select All That Apply),
  "what_else_described_you_in_2020_during_covid_other" VARCHAR  -- What Else Described You In 2020 (during COVID)? - Other,
  "have_you_received_information_training_about_chauffeur_a14d35b9" VARCHAR  -- Have You Received Information/training About Chauffeuring During The Pandemic From The Company(ies) You Drive With/apps You Use?,
  "have_you_received_personal_protective_equipment_ppe_ha_8d597792" VARCHAR  -- Have You Received Personal Protective Equipment (PPE), Hand Sanitizer, Or Cleaning Supplies From The Company You Drive With/apps You Use?,
  "have_you_been_sick_from_covid_19_or_had_to_quarantine__991dafdd" VARCHAR  -- Have You Been Sick From COVID-19 Or Had To Quarantine Because Of COVID-19 Exposure?,
  "after_the_covid_19_pandemic_stabilizes_or_is_under_con_22e62a98" VARCHAR  -- After The COVID-19 Pandemic Stabilizes Or Is Under Control, How Likely Are You To Be A Taxicab, Livery, Or Lyft/Uber/Via Chauffeur?,
  "what_is_are_the_main_concerns_about_continuing_to_be_a_fbcc84b5" VARCHAR  -- What Is/are The Main Concerns About Continuing To Be A Chauffeur After The Pandemic? (select All That Apply),
  "what_is_are_the_main_concerns_about_continuing_to_be_a_3e45ee3d" VARCHAR  -- What Is/are The Main Concerns About Continuing To Be A Chauffeur After The Pandemic? - Other,
  "what_would_most_improve_chauffeur_conditions_select_1_to_3" VARCHAR  -- What Would Most Improve Chauffeur Conditions? (select 1 To 3),
  "what_would_most_improve_chauffeur_conditions_other" VARCHAR  -- What Would Most Improve Chauffeur Conditions? - Other,
  "do_you_have_any_additional_comments" VARCHAR  -- Do You Have Any Additional Comments?,
  "in_what_zip_code_is_your_home_located" DOUBLE  -- In What ZIP Code Is Your Home Located?,
  "what_is_your_age" VARCHAR  -- What Is Your Age?,
  "gender_identity" VARCHAR,
  "what_is_your_race_or_ethnicity" VARCHAR  -- What Is Your Race Or Ethnicity?,
  "what_is_the_highest_degree_or_level_of_education_you_h_2be3f5a3" VARCHAR  -- What Is The Highest Degree Or Level Of Education You Have Completed?,
  "do_you_have_health_insurance" VARCHAR  -- Do You Have Health Insurance?,
  "how_many_dependent_children_under_age_18_do_you_have" VARCHAR  -- How Many Dependent Children Under Age 18 Do You Have?
);