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

About this Dataset

2015 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:14.028288
Tags: airport, customer, sfo, survey

Tables

Table 1

@usgov.city_of_san_francisco_2015_sfo_customer_survey.table_1

181.41 KB
2958 rows
88 columns


CREATE TABLE table_1 (
  "respnum" BIGINT,
  "ccgid" DOUBLE,
  "runid" BIGINT,
  "intdate" BIGINT,
  "airline" BIGINT,
  "flight" BIGINT,
  "destination" BIGINT,
  "destgeo" BIGINT,
  "destmark" BIGINT,
  "gate" BIGINT,
  "barea" VARCHAR,
  "strata" BIGINT,
  "peak" BIGINT,
  "deptime" VARCHAR,
  "arrtime" VARCHAR,
  "method" BIGINT,
  "q2purp1" BIGINT,
  "q2purp2" DOUBLE,
  "q2purp3" DOUBLE,
  "q3getto1" BIGINT,
  "q3getto2" DOUBLE,
  "q3getto3" VARCHAR,
  "q3park" DOUBLE,
  "q4bags" BIGINT,
  "q4store" BIGINT,
  "q4food" BIGINT,
  "q4wifi" BIGINT,
  "q5timesflown" BIGINT,
  "q5firsttime" BIGINT,
  "q6longuse" BIGINT,
  "saq" BIGINT,
  "q7art" BIGINT,
  "q7food" BIGINT,
  "q7store" BIGINT,
  "q7sign" BIGINT,
  "q7walkways" BIGINT,
  "q7screens" BIGINT,
  "q7infodown" BIGINT,
  "q7infoup" BIGINT,
  "q7wifi" BIGINT,
  "q7roads" BIGINT,
  "q7park" BIGINT,
  "q7airtrain" BIGINT,
  "q7ltparking" BIGINT,
  "q7rental" BIGINT,
  "q7all" BIGINT,
  "q8com1" DOUBLE,
  "q8com2" DOUBLE,
  "q8com3" DOUBLE,
  "q9boarding" BIGINT,
  "q9airtrain" BIGINT,
  "q9rental" BIGINT,
  "q9food" BIGINT,
  "q9restroom" BIGINT,
  "q9all" BIGINT,
  "q9com1" DOUBLE,
  "q9com2" DOUBLE,
  "q9com3" DOUBLE,
  "q10safe" BIGINT,
  "q10com1" DOUBLE,
  "q10com2" DOUBLE,
  "q10com3" DOUBLE,
  "q11tsapre" BIGINT,
  "q12prechekcrate" BIGINT,
  "q12com1" DOUBLE,
  "q12com2" DOUBLE,
  "q12com3" VARCHAR,
  "q13county" BIGINT,
  "q13getrate" BIGINT,
  "q14find" BIGINT,
  "q14passthru" BIGINT,
  "q15problem" BIGINT,
  "q15com1" DOUBLE,
  "q15com2" DOUBLE,
  "q15com3" DOUBLE,
  "q16live" BIGINT,
  "home" BIGINT,
  "q17zip" DOUBLE,
  "q17country" VARCHAR,
  "q18age" BIGINT,
  "q19gender" BIGINT,
  "q20income" BIGINT,
  "q21fly" BIGINT,
  "q22sjc" BIGINT,
  "q22oak" BIGINT,
  "lang" BIGINT,
  "weight" DOUBLE,
  "location_1" VARCHAR
);