Libraries

CREATE TABLE libraries (
  "library_name" VARCHAR,
  "name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "address_5" VARCHAR,
  "postcode" VARCHAR,
  "web_address" VARCHAR,
  "telephone_number" VARCHAR,
  "telephone_number_1" VARCHAR,
  "email" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "hours_open_per_week" VARCHAR,
  "the_building_is_owned_or_leased" VARCHAR,
  "disability_discrimination_act_compliant" VARCHAR,
  "visits" BIGINT,
  "issues_books_and_media" BIGINT,
  "active_borrowers" BIGINT,
  "active_users" BIGINT,
  "pc_sessions" BIGINT,
  "wi_fi_hours_used" VARCHAR,
  "home_library_and_information" VARCHAR,
  "under_16" BIGINT,
  "n_16_24" BIGINT,
  "n_25_54" BIGINT,
  "over_55" BIGINT,
  "building_costs" VARCHAR,
  "other_costs" VARCHAR,
  "income" VARCHAR
);