Public Library Survey (PLS) 2020
Institute of Museum and Library Services
@usgov.imls_gov_public_library_survey_pls_2020
Institute of Museum and Library Services
@usgov.imls_gov_public_library_survey_pls_2020
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" BIGINT,
"c_relatn" VARCHAR,
"c_legbas" VARCHAR,
"c_admin" VARCHAR,
"c_fscs" VARCHAR,
"geocode" VARCHAR,
"lsabound" VARCHAR,
"startdat" VARCHAR,
"enddate" VARCHAR,
"popu_lsa" BIGINT,
"f_poplsa" VARCHAR,
"popu_und" BIGINT,
"centlib" BIGINT,
"f_cenlib" VARCHAR,
"branlib" BIGINT,
"f_brlib" VARCHAR,
"bkmob" BIGINT,
"f_bkmob" VARCHAR,
"master" DOUBLE,
"f_master" VARCHAR,
"libraria" DOUBLE,
"f_librar" VARCHAR,
"othpaid" DOUBLE,
"f_othstf" VARCHAR,
"totstaff" DOUBLE,
"f_totstf" VARCHAR,
"locgvt" BIGINT,
"f_locgvt" VARCHAR,
"stgvt" BIGINT,
"f_stgvt" VARCHAR,
"fedgvt" BIGINT,
"f_fedgvt" VARCHAR,
"othincm" BIGINT,
"f_othinc" VARCHAR,
"totincm" BIGINT,
"f_totinc" VARCHAR,
"salaries" BIGINT,
"f_salx" VARCHAR,
"benefit" BIGINT,
"f_benx" VARCHAR,
"staffexp" BIGINT,
"f_tostfx" VARCHAR,
"prmatexp" BIGINT,
"f_prmatx" VARCHAR,
"elmatexp" BIGINT,
"f_elmatx" VARCHAR,
"othmatex" BIGINT,
"f_otmatx" VARCHAR,
"totexpco" BIGINT,
"f_tocolx" VARCHAR,
"othopexp" BIGINT,
"f_othopx" VARCHAR,
"totopexp" BIGINT,
"f_totopx" VARCHAR,
"lcap_rev" BIGINT,
"f_lcaprv" VARCHAR,
"scap_rev" BIGINT,
"f_scaprv" VARCHAR,
"fcap_rev" BIGINT,
"f_fcaprv" VARCHAR,
"ocap_rev" BIGINT,
"f_ocaprv" VARCHAR,
"cap_rev" BIGINT,
"f_tcaprv" VARCHAR,
"capital" BIGINT,
"f_tcapx" VARCHAR,
"bkvol" BIGINT,
"f_bkvol" VARCHAR,
"ebook" BIGINT,
"f_ebook" VARCHAR,
"audio_ph" BIGINT,
"f_aud_ph" VARCHAR,
"audio_dl" BIGINT,
"f_aud_dl" VARCHAR,
"video_ph" BIGINT,
"f_vid_ph" VARCHAR,
"video_dl" BIGINT,
"f_vid_dl" VARCHAR,
"ec_lo_ot" BIGINT,
"f_ec_l_o" VARCHAR,
"ec_st" BIGINT,
"f_ec_st" VARCHAR,
"eleccoll" BIGINT,
"f_elecol" VARCHAR,
"hrs_open" BIGINT,
"f_hrs_op" VARCHAR,
"visits" BIGINT
);
Anyone who has the link will be able to view this.