2010 SFO Customer Survey by US Government | Ecommerce and Consumer Trends

About this Dataset

2010 SFO Customer Survey

SFO conducts a yearly comprehensive survey of our guests to gauge satisfaction with our facilities, services, and amenities. SFO compares results to previous surveys to look for areas of improvement and discover elements of the guest experience that are not satisfactory.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:06.913506
Tags: airport, customer, sfo, survey

Tables

Table 1

@usgov.city_of_san_francisco_2010_sfo_customer_survey.table_1

166.19 KB
3234 rows
100 columns


CREATE TABLE table_1 (
  "respnum" BIGINT,
  "ccgid" BIGINT,
  "term" BIGINT,
  "strata" BIGINT,
  "atype" BIGINT,
  "airline" BIGINT,
  "dest" BIGINT,
  "gatenum" BIGINT,
  "intdate" BIGINT,
  "q1" BIGINT,
  "q2_1" BIGINT,
  "q2_2" DOUBLE,
  "q2_3" DOUBLE,
  "q2_4" DOUBLE,
  "q2_5" DOUBLE,
  "q2_6" DOUBLE,
  "q3_1" BIGINT,
  "q3_2" DOUBLE,
  "q3_3" DOUBLE,
  "q3_4" DOUBLE,
  "q3_5" VARCHAR,
  "q3_6" VARCHAR,
  "q3a" BIGINT,
  "q4a" BIGINT,
  "q4b" BIGINT,
  "q4c" BIGINT,
  "q5" BIGINT,
  "q5avg" DOUBLE,
  "saq" BIGINT,
  "q6a" BIGINT,
  "q6b" BIGINT,
  "q6c" BIGINT,
  "q6d" BIGINT,
  "q6e" BIGINT,
  "q6f" BIGINT,
  "q6g" BIGINT,
  "q6h" BIGINT,
  "q6i" BIGINT,
  "q6j" BIGINT,
  "q6k" BIGINT,
  "q6l" BIGINT,
  "q6m" BIGINT,
  "q6n" BIGINT,
  "q7com1" DOUBLE,
  "q7com2" DOUBLE,
  "q7com3" DOUBLE,
  "q7a1" DOUBLE,
  "q7a2" DOUBLE,
  "q7a3" DOUBLE,
  "q8a" BIGINT,
  "q8b" BIGINT,
  "q8c" BIGINT,
  "q8d" BIGINT,
  "q8e" BIGINT,
  "q8f" BIGINT,
  "q8com1" DOUBLE,
  "q8com2" DOUBLE,
  "q8com3" VARCHAR,
  "q9" BIGINT,
  "q9apos1" DOUBLE,
  "q9apos2" DOUBLE,
  "q9apos3" DOUBLE,
  "q9aneg1" DOUBLE,
  "q9aneg2" DOUBLE,
  "q9aneg3" VARCHAR,
  "q9antr1" DOUBLE,
  "q9antr2" DOUBLE,
  "q9antr3" VARCHAR,
  "q10" BIGINT,
  "q11" DOUBLE,
  "q11a1" DOUBLE,
  "q11a2" DOUBLE,
  "q11a3" DOUBLE,
  "q12" BIGINT,
  "q13a" BIGINT,
  "q13b" BIGINT,
  "q13_com" VARCHAR,
  "q13com1" DOUBLE,
  "q13com2" DOUBLE,
  "q13com3" VARCHAR,
  "q14" BIGINT,
  "q14a" VARCHAR,
  "q14a1" DOUBLE,
  "q14a2" DOUBLE,
  "q14a3" DOUBLE,
  "q15" BIGINT,
  "sfflag" BIGINT,
  "country" BIGINT,
  "q17" BIGINT,
  "age" DOUBLE,
  "q18" BIGINT,
  "q19" BIGINT,
  "inc" DOUBLE,
  "mail" BIGINT,
  "lang" BIGINT,
  "destmark" BIGINT,
  "destination" VARCHAR,
  "destgeo" BIGINT,
  "weight" DOUBLE,
  "location_1" VARCHAR
);