Peterborough Payments Over £500 To Suppliers
Cambridgeshire Insight
@ukgov.peterborough_payments_over_500_to_suppliers
Cambridgeshire Insight
@ukgov.peterborough_payments_over_500_to_suppliers
CREATE TABLE peterborough_payments_over_500_may_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" BIGINT,
"amount_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_september_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_may_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_october_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_november_2019 (
"body_name_t" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" DOUBLE,
"amount" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_july_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_june_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" BIGINT,
"amount_in" VARCHAR,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_december_2019 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" DOUBLE,
"amount_paid_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_february_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" DOUBLE,
"amount_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_july_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" BIGINT,
"amount_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_february_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_march_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" VARCHAR,
"trans_no" DOUBLE,
"amount_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR,
"unnamed_10" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_april_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" BIGINT,
"amount_in" VARCHAR,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_october_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" BIGINT,
"amount_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_november_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" BIGINT,
"amount_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"beneficiary" VARCHAR,
"merchant_category" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_january_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_june_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_january_2020 (
"body_name" VARCHAR,
"service_area_categorisation" VARCHAR,
"service_area_division" VARCHAR,
"purpose_of_expenditure" VARCHAR,
"payment_date" TIMESTAMP,
"trans_no" DOUBLE,
"amount_in" DOUBLE,
"capital_or_revenue" VARCHAR,
"supplier_t" VARCHAR,
"merchant_category" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_march_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
CREATE TABLE peterborough_payments_over_500_august_2019 (
"bodyname" VARCHAR,
"serviceareacategorisation" VARCHAR,
"servicedivisioncategorisation" VARCHAR,
"expensestype" VARCHAR,
"date" TIMESTAMP,
"transactionnumber" BIGINT,
"amount" DOUBLE,
"capitalorrevenue" VARCHAR,
"suppliername" VARCHAR,
"merchantcategory" VARCHAR
);
Anyone who has the link will be able to view this.