Public Library Survey (PLS) 2005
Institute of Museum and Library Services
@usgov.imls_gov_public_library_survey_pls_2005_b861a
Institute of Museum and Library Services
@usgov.imls_gov_public_library_survey_pls_2005_b861a
CREATE TABLE table_1 (
"stabr" VARCHAR,
"fscskey" VARCHAR,
"libid" VARCHAR,
"libname" VARCHAR,
"address" VARCHAR,
"city" VARCHAR,
"zip" BIGINT,
"zip4" VARCHAR,
"addres_m" VARCHAR,
"city_m" VARCHAR,
"zip_m" BIGINT,
"zip4_m" VARCHAR,
"cnty" VARCHAR,
"phone" VARCHAR,
"web_addr" VARCHAR,
"c_relatn" VARCHAR,
"c_legbas" VARCHAR,
"c_admin" VARCHAR,
"c_fscs" VARCHAR,
"geocode" VARCHAR,
"lsabound" VARCHAR,
"startdat" VARCHAR,
"f_stdat" BIGINT,
"enddate" VARCHAR,
"f_enddat" BIGINT,
"popu_lsa" BIGINT,
"f_poplsa" BIGINT,
"popu_und" BIGINT,
"f_popund" BIGINT,
"centlib" BIGINT,
"f_cenlib" BIGINT,
"branlib" BIGINT,
"f_brlib" BIGINT,
"bkmob" BIGINT,
"f_bkmob" BIGINT,
"master" DOUBLE,
"f_master" BIGINT,
"libraria" DOUBLE,
"f_librar" BIGINT,
"othpaid" DOUBLE,
"f_othstf" BIGINT,
"totstaff" DOUBLE,
"f_totstf" BIGINT,
"locgvt" BIGINT,
"f_locgvt" BIGINT,
"stgvt" BIGINT,
"f_stgvt" BIGINT,
"fedgvt" BIGINT,
"f_fedgvt" BIGINT,
"othincm" BIGINT,
"f_othinc" BIGINT,
"totincm" BIGINT,
"f_totinc" BIGINT,
"salaries" DOUBLE,
"f_salx" BIGINT,
"benefit" DOUBLE,
"f_benx" BIGINT,
"staffexp" DOUBLE,
"f_tostfx" BIGINT,
"prmatexp" BIGINT,
"f_prmatx" BIGINT,
"elmatexp" BIGINT,
"f_elmatx" BIGINT,
"othmatex" BIGINT,
"f_otmatx" BIGINT,
"totexpco" BIGINT,
"f_tocolx" BIGINT,
"othopexp" DOUBLE,
"f_othopx" BIGINT,
"totopexp" BIGINT,
"f_totopx" BIGINT,
"lcap_rev" BIGINT,
"f_lcaprv" BIGINT,
"scap_rev" BIGINT,
"f_scaprv" BIGINT,
"fcap_rev" BIGINT,
"f_fcaprv" BIGINT,
"ocap_rev" BIGINT,
"f_ocaprv" BIGINT,
"cap_rev" BIGINT,
"f_tcaprv" BIGINT,
"capital" BIGINT,
"f_tcapx" BIGINT,
"bkvol" BIGINT,
"f_bkvol" BIGINT,
"ebook" BIGINT,
"f_ebook" BIGINT,
"audio" BIGINT,
"f_audio" BIGINT,
"video" BIGINT,
"f_video" BIGINT,
"database" BIGINT,
"f_dbase" BIGINT,
"subscrip" BIGINT,
"f_prsub" BIGINT,
"esubscrp" BIGINT,
"f_esub" BIGINT,
"hrs_open" BIGINT,
"f_hrs_op" BIGINT,
"visits" BIGINT
);
Anyone who has the link will be able to view this.