Public Library Survey (PLS) 2003
Institute of Museum and Library Services
@usgov.imls_gov_public_library_survey_pls_2003_eb01e
Institute of Museum and Library Services
@usgov.imls_gov_public_library_survey_pls_2003_eb01e
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" VARCHAR,
"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,
"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,
"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,
"f_visits" BIGINT,
"referenc" BIGINT,
"f_refer" BIGINT,
"totcir" BIGINT,
"f_totcir" BIGINT,
"loanto" BIGINT,
"f_loanto" BIGINT,
"loanfm" BIGINT,
"f_loanfm" BIGINT,
"kidcircl" BIGINT,
"f_kidcir" BIGINT,
"kidatten" BIGINT
);
Anyone who has the link will be able to view this.