Baselight
Sign In

Pendle Procurement - Purchase Orders And Invitations To Quote Over £5,000

Pendle Borough Council

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2

Loading...
Loading...

About this Dataset

Pendle Procurement - Purchase Orders And Invitations To Quote Over £5,000

This dataset contains all Pendle Council's Purchase Orders and Invitations to Quote over £5,000 from November 2014 onwards.
Publisher name: Pendle Borough Council
Last updated: 2022-07-01T04:02:58Z

Tables

April 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.april_2019
  • 14.97 kB
  • 4 rows
  • 21 columns
Loading... 
CREATE TABLE april_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);

August 2018

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.august_2018
  • 16.35 kB
  • 9 rows
  • 23 columns
Loading... 
CREATE TABLE august_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

August 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.august_2019
  • 11.08 kB
  • 4 rows
  • 14 columns
Loading... 
CREATE TABLE august_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" TIMESTAMP  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

December 2018

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.december_2018
  • 15.91 kB
  • 6 rows
  • 23 columns
Loading... 
CREATE TABLE december_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

December 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.december_2019
  • 11.15 kB
  • 3 rows
  • 14 columns
Loading... 
CREATE TABLE december_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" TIMESTAMP  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

February 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.february_2019
  • 15.13 kB
  • 4 rows
  • 21 columns
Loading... 
CREATE TABLE february_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);

February 2020

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.february_2020
  • 12.38 kB
  • 4 rows
  • 14 columns
Loading... 
CREATE TABLE february_2020 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" TIMESTAMP  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

January 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.january_2019
  • 15.29 kB
  • 4 rows
  • 21 columns
Loading... 
CREATE TABLE january_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);

January 2020

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.january_2020
  • 11.18 kB
  • 3 rows
  • 14 columns
Loading... 
CREATE TABLE january_2020 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" TIMESTAMP  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

July 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.july_2019
  • 13.46 kB
  • 6 rows
  • 14 columns
Loading... 
CREATE TABLE july_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" TIMESTAMP  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

June 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.june_2019
  • 11.3 kB
  • 6 rows
  • 14 columns
Loading... 
CREATE TABLE june_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

March 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.march_2019
  • 16.03 kB
  • 11 rows
  • 21 columns
Loading... 
CREATE TABLE march_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);

May 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.may_2019
  • 15.55 kB
  • 10 rows
  • 21 columns
Loading... 
CREATE TABLE may_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);

November 2018

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.november_2018
  • 16.61 kB
  • 7 rows
  • 23 columns
Loading... 
CREATE TABLE november_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

October 2018

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.october_2018
  • 16.05 kB
  • 5 rows
  • 23 columns
Loading... 
CREATE TABLE october_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

October 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.october_2019
  • 11.4 kB
  • 4 rows
  • 14 columns
Loading... 
CREATE TABLE october_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" TIMESTAMP  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

Pendle Procurement - Purchase Orders And Invitations To Quote Over £5,000

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2
  • 14.64 kB
  • 2 rows
  • 21 columns
Loading... 
CREATE TABLE pendle_procurement_purchase_orders_and_invitations_to__da6dacc2 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" DOUBLE  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);

September 2018

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.september_2018
  • 16.11 kB
  • 6 rows
  • 23 columns
Loading... 
CREATE TABLE september_2018 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" VARCHAR  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N),
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22
);

September 2019

@ukgov.pendle_procurement_purchase_orders_and_invitations_to__da6dacc2.september_2019
  • 13.03 kB
  • 8 rows
  • 14 columns
Loading... 
CREATE TABLE september_2019 (
  "organisation_name_a" VARCHAR  -- Organisation Name (A),
  "reference_number_b" VARCHAR  -- Reference Number (B),
  "title_of_agreement_c" VARCHAR  -- Title Of Agreement (C ),
  "dept_d" VARCHAR  -- Dept (D),
  "service_label_e" VARCHAR  -- Service Label (E ),
  "service_description_f" VARCHAR  -- Service Description (F),
  "description_g" VARCHAR  -- Description (G),
  "start_date_h" TIMESTAMP  -- Start Date (H),
  "end_date_i" VARCHAR  -- End Date (I),
  "quantity_j" DOUBLE  -- Quantity (J),
  "price_k" DOUBLE  -- Price (K),
  "value_l" DOUBLE  -- Value (L),
  "supplier_name_m" VARCHAR  -- Supplier Name (M),
  "tender_process_n" VARCHAR  -- Tender Process (N)
);

Share link

Anyone who has the link will be able to view this.