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  -- Issues - Books And Media,
  "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  -- 16-24,
  "n_25_54" BIGINT  -- 25-54,
  "over_55" BIGINT,
  "building_costs" VARCHAR  -- Building Costs (Ł),
  "other_costs" VARCHAR  -- Other Costs (Ł),
  "income" VARCHAR  -- Income (Ł)
);