Pendle Procurement - Purchase Orders And Invitations To Quote Over £5,000
Pendle Borough Council
@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2
Pendle Borough Council
@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2
CREATE TABLE april_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR
);
CREATE TABLE august_2018 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" 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
);
CREATE TABLE august_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" TIMESTAMP,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
CREATE TABLE december_2018 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" 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
);
CREATE TABLE december_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" TIMESTAMP,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
CREATE TABLE february_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR
);
CREATE TABLE february_2020 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" TIMESTAMP,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
CREATE TABLE january_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR
);
CREATE TABLE january_2020 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" TIMESTAMP,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
CREATE TABLE july_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" TIMESTAMP,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
CREATE TABLE june_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
CREATE TABLE march_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR
);
CREATE TABLE may_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR
);
CREATE TABLE november_2018 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" 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
);
CREATE TABLE october_2018 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" 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
);
CREATE TABLE october_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" TIMESTAMP,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
CREATE TABLE pendle_procurement_purchase_orders_and_invitations_to__da6dacc2 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" DOUBLE,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR
);
CREATE TABLE september_2018 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" VARCHAR,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" 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
);
CREATE TABLE september_2019 (
"organisation_name_a" VARCHAR,
"reference_number_b" VARCHAR,
"title_of_agreement_c" VARCHAR,
"dept_d" VARCHAR,
"service_label_e" VARCHAR,
"service_description_f" VARCHAR,
"description_g" VARCHAR,
"start_date_h" TIMESTAMP,
"end_date_i" VARCHAR,
"quantity_j" DOUBLE,
"price_k" DOUBLE,
"value_l" DOUBLE,
"supplier_name_m" VARCHAR,
"tender_process_n" VARCHAR
);
Anyone who has the link will be able to view this.