Library Locations by US Government | Media and Entertainment

About this Dataset

Library Locations

Carnegie Library of Pittsburgh locations including address, coordinates, phone number, square footage, and standard operating hours. The map below does not display locations that are temporarily closed due to renovation.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:12:23.547845
Tags: books, branches, community, events, libraries, library, literacy, properties, reading, wifi

Tables

Library Locations

@usgov.allegheny_county_city_of_pitts_library_locations.library_locations

17.63 KB
19 rows
26 columns


CREATE TABLE library_locations (
  "n__id" BIGINT,
  "clpid" VARCHAR,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip4" VARCHAR,
  "county" VARCHAR,
  "phone" VARCHAR,
  "sqft" BIGINT,
  "moopen" VARCHAR,
  "moclose" VARCHAR,
  "tuopen" VARCHAR,
  "tuclose" VARCHAR,
  "weopen" VARCHAR,
  "weclose" VARCHAR,
  "thopen" VARCHAR,
  "thclose" VARCHAR,
  "fropen" VARCHAR,
  "frclose" VARCHAR,
  "saopen" VARCHAR,
  "saclose" VARCHAR,
  "suopen" VARCHAR,
  "suclose" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE
);

Library Locations Data Dictionary

@usgov.allegheny_county_city_of_pitts_library_locations.library_locations_data_dictionary

3.48 KB
24 rows
3 columns


CREATE TABLE library_locations_data_dictionary (
  "fieldname" VARCHAR,
  "fieldtype" VARCHAR,
  "description" VARCHAR
);