About this Dataset

FY18 Tenant Satisfaction Survey Individual Responses With Comments

A CSV export of Tenant Satisfaction Survey (TSS) individual responses with comments, file does not contain PII.
Organization: General Services Administration
Last updated: 2021-07-16T13:22:53.198518
Tags: air-quality, bathrooms, building, building-security, cleanliness, common-areas, condition, desk, elevators, happiness, satisfaction, survey-results, tss

Tables

FY18 TSS Individual Results With Comments

@usgov.gsa_gov_fy18_tenant_satisfaction_survey_individual_res_fe0db64d.fy18_tss_individual_results_with_comments

37.13 MB
192924 rows
99 columns


CREATE TABLE fy18_tss_individual_results_with_comments (
  "datayear" BIGINT,
  "response_id" VARCHAR,
  "real_property_unique_id" VARCHAR,
  "agency" VARCHAR,
  "agency_short" VARCHAR,
  "bureau" VARCHAR,
  "agency_id" VARCHAR,
  "component_id" VARCHAR,
  "sub_component_id" VARCHAR,
  "real_property_use" VARCHAR,
  "country" VARCHAR,
  "region" DOUBLE,
  "state" VARCHAR,
  "city" VARCHAR,
  "building_name" VARCHAR,
  "address" VARCHAR,
  "field_office" VARCHAR,
  "service_center" VARCHAR,
  "legal_interest" VARCHAR,
  "frpp_agency" VARCHAR,
  "frpp_bureau" VARCHAR,
  "frpp_source" VARCHAR,
  "frpp_zip_code" VARCHAR,
  "non_gsa" VARCHAR,
  "property_manager_email" VARCHAR,
  "supervisor_email" VARCHAR,
  "best_interest" DOUBLE,
  "cleanliness_avg" DOUBLE,
  "cleanliness_exteriorbldgandgrounds" DOUBLE,
  "cleanliness_interiorcommonareas" DOUBLE,
  "cleanliness_workspace" DOUBLE,
  "cleanliness_restrooms" DOUBLE,
  "condition_avg" DOUBLE,
  "condition_exteriorbldgandgrounds" DOUBLE,
  "condition_interiorcommonareas" DOUBLE,
  "condition_workspace" DOUBLE,
  "condition_restrooms" DOUBLE,
  "personalworkspace_avg" DOUBLE,
  "personalworkspace_airquality" DOUBLE,
  "personalworkspace_light" DOUBLE,
  "personalworkspace_noise" DOUBLE,
  "personalworkspace_temp" DOUBLE,
  "correct_issue" DOUBLE,
  "contact_issue" DOUBLE,
  "elevators" DOUBLE,
  "meetingspaceavailable" DOUBLE,
  "security_avg" DOUBLE,
  "security_professionalism" DOUBLE,
  "security_presence" DOUBLE,
  "overall_satisfaction" BIGINT,
  "comment" VARCHAR,
  "comment_redacted" VARCHAR,
  "sentiment_score" DOUBLE,
  "workspace_design" DOUBLE,
  "virtual_employee" VARCHAR,
  "personal_workspace_demographics" VARCHAR,
  "airquality_f0" VARCHAR,
  "airquality_f1" VARCHAR,
  "airquality_f2" VARCHAR,
  "conditionbathrooms_f0" VARCHAR,
  "conditionbathrooms_f1" VARCHAR,
  "conditionbathrooms_f2" VARCHAR,
  "conditionbathrooms_f3" VARCHAR,
  "conditionbathrooms_f4" VARCHAR,
  "conditionbathrooms_f5" VARCHAR,
  "conditionbathrooms_f6" VARCHAR,
  "conditionbathrooms_f7" VARCHAR,
  "conditioncommonrooms_f0" VARCHAR,
  "conditioncommonrooms_f1" VARCHAR,
  "conditioncommonrooms_f2" VARCHAR,
  "conditioncommonrooms_f3" VARCHAR,
  "conditioncommonrooms_f4" VARCHAR,
  "conditioncommonrooms_f5" VARCHAR,
  "conditioncommonrooms_f6" VARCHAR,
  "conditioncommonrooms_f7" VARCHAR,
  "conditioncommonrooms_f8" VARCHAR,
  "conditionworkspace_f0" VARCHAR,
  "conditionworkspace_f1" VARCHAR,
  "conditionworkspace_f2" VARCHAR,
  "conditionworkspace_f3" VARCHAR,
  "conditionworkspace_f4" VARCHAR,
  "conditionexterior_f0" VARCHAR,
  "conditionexterior_f1" VARCHAR,
  "conditionexterior_f2" VARCHAR,
  "conditionexterior_f3" VARCHAR,
  "light_f0" VARCHAR,
  "light_f1" VARCHAR,
  "light_f2" VARCHAR,
  "light_f3" VARCHAR,
  "light_f4" VARCHAR,
  "sound_f0" VARCHAR,
  "sound_f1" VARCHAR,
  "sound_f2" VARCHAR,
  "sound_f3" VARCHAR,
  "sound_f4" VARCHAR,
  "temperature_f0" VARCHAR,
  "temperature_f1" VARCHAR,
  "temperature_f2" VARCHAR,
  "temperature_f3" VARCHAR
);