Museums Loans
Leeds City Council
@ukgov.museums_loans
Leeds City Council
@ukgov.museums_loans
CREATE TABLE long_term_museum_loans_2016 (
"loan_no" VARCHAR,
"requesting_institution" VARCHAR,
"objects" VARCHAR,
"no_of_objects" VARCHAR,
"period_of_loan" VARCHAR,
"n_2006" VARCHAR,
"n_2007" VARCHAR,
"n_2008" VARCHAR,
"n_2009" VARCHAR,
"n_2010" VARCHAR,
"n_2011" VARCHAR,
"n_2012" VARCHAR,
"n_2013" VARCHAR,
"n_2016" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" VARCHAR,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" VARCHAR,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"unnamed_71" VARCHAR,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" VARCHAR,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" VARCHAR
);
CREATE TABLE long_term_museum_loans_2017 (
"loan_no" VARCHAR,
"requesting_institution" VARCHAR,
"objects" VARCHAR,
"no_of_objects" VARCHAR,
"period_of_loan" VARCHAR,
"n_2017" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" VARCHAR,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" VARCHAR,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" VARCHAR,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" VARCHAR,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" VARCHAR,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" VARCHAR,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" VARCHAR,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" VARCHAR,
"unnamed_66" VARCHAR
);
CREATE TABLE short_term_museum_loans_2016 (
"loan_no" VARCHAR,
"requesting_institution" VARCHAR,
"objects" VARCHAR,
"no_of_items" DOUBLE,
"visitor_figures" VARCHAR,
"catalogue" VARCHAR,
"jan_16" VARCHAR,
"feb_16" VARCHAR,
"mar_16" VARCHAR,
"apr_16" VARCHAR,
"may_16" VARCHAR,
"jun_16" VARCHAR,
"jul_16" VARCHAR,
"aug_16" VARCHAR,
"sep_16" VARCHAR,
"oct_16" VARCHAR,
"nov_16" VARCHAR,
"dec_16" VARCHAR
);
CREATE TABLE short_term_museum_loans_2017 (
"loan_no" VARCHAR,
"requesting_institution" VARCHAR,
"objects" VARCHAR,
"no_of_items" DOUBLE,
"visitor_figures_requests" VARCHAR,
"catalogue" VARCHAR,
"jan_17" VARCHAR,
"feb_17" VARCHAR,
"mar_17" VARCHAR,
"apr_17" VARCHAR,
"may_17" VARCHAR,
"jun_17" VARCHAR,
"jul_17" VARCHAR,
"aug_17" VARCHAR,
"sep_17" VARCHAR,
"oct_17" VARCHAR,
"nov_17" VARCHAR,
"dec_17" VARCHAR
);
Anyone who has the link will be able to view this.