Public Library Survey (PLS) 2001

CREATE TABLE table_1 (
  "stabr" VARCHAR,
  "fscskey" VARCHAR,
  "libid" VARCHAR,
  "libname" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "cnty" VARCHAR,
  "zip" VARCHAR,
  "zip4" VARCHAR,
  "addres_m" VARCHAR,
  "city_m" VARCHAR,
  "zip_m" VARCHAR,
  "zip4_m" VARCHAR,
  "phone" VARCHAR,
  "c_relatn" VARCHAR,
  "c_legbas" VARCHAR,
  "c_admin" VARCHAR,
  "c_fscs" VARCHAR,
  "geocode" VARCHAR,
  "popu_lsa" BIGINT,
  "popu_und" BIGINT,
  "centlib" BIGINT,
  "branlib" BIGINT,
  "bkmob" BIGINT,
  "master" DOUBLE,
  "libraria" DOUBLE,
  "othpaid" DOUBLE,
  "totstaff" DOUBLE,
  "locgvt" BIGINT,
  "stgvt" BIGINT,
  "fedgvt" BIGINT,
  "othincm" BIGINT,
  "totincm" BIGINT,
  "salaries" DOUBLE,
  "benefit" DOUBLE,
  "staffexp" DOUBLE,
  "totexpco" BIGINT,
  "othopexp" DOUBLE,
  "totopexp" BIGINT,
  "capital" BIGINT,
  "bkvol" BIGINT,
  "audio" BIGINT,
  "video" BIGINT,
  "subscrip" BIGINT,
  "hrs_open" BIGINT,
  "visits" BIGINT,
  "referenc" BIGINT,
  "totcir" BIGINT,
  "loanto" BIGINT,
  "loanfm" BIGINT,
  "kidcircl" BIGINT,
  "kidatten" BIGINT,
  "elmatexp" BIGINT,
  "elaccexp" BIGINT,
  "elmats" BIGINT,
  "elsvcacc" VARCHAR,
  "inetacc" VARCHAR,
  "inetuse" VARCHAR,
  "stfterms" BIGINT,
  "gpterms" BIGINT,
  "eres_usr" BIGINT,
  "pub_fips" BIGINT,
  "cntyfips" VARCHAR,
  "yr_sub" BIGINT,
  "obereg" BIGINT,
  "rstatus" BIGINT,
  "imp0" BIGINT,
  "imp1" BIGINT,
  "imp2" BIGINT,
  "imp3" BIGINT,
  "imp4" BIGINT,
  "imp5" BIGINT,
  "imp6" BIGINT,
  "imp7" BIGINT,
  "imp8" BIGINT,
  "imp9" BIGINT,
  "imp10" BIGINT,
  "imp11" BIGINT,
  "imp12" BIGINT,
  "imp13" BIGINT,
  "imp14" BIGINT,
  "imp15" BIGINT,
  "imp16" BIGINT,
  "imp17" BIGINT,
  "imp18" BIGINT,
  "imp19" BIGINT,
  "imp20" BIGINT,
  "imp21" BIGINT,
  "imp22" BIGINT,
  "imp23" BIGINT,
  "imp24" BIGINT,
  "imp25" BIGINT,
  "imp26" BIGINT,
  "imp27" BIGINT,
  "imp28" BIGINT,
  "imp29" BIGINT,
  "imp30" BIGINT,
  "imp31" BIGINT,
  "imp32" BIGINT,
  "imp33" BIGINT
);