Peterborough Payments Over £500 April 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_april_2020

73.44 kB
4,078 rows
10 columns

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  -- Amount In Ł,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 August 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_august_2019

65.37 kB
3,106 rows
10 columns

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
);

Peterborough Payments Over £500 December 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_december_2019

73.12 kB
3,577 rows
10 columns

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  -- Amount Paid In Ł,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 February 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_february_2019

70.47 kB
3,472 rows
10 columns

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
);

Peterborough Payments Over £500 February 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_february_2020

72.17 kB
4,155 rows
10 columns

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  -- Amount In Ł,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 January 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_january_2019

66.14 kB
3,301 rows
10 columns

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
);

Peterborough Payments Over £500 January 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_january_2020

82.53 kB
8,026 rows
17 columns

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  -- Amount In Ł,
  "capital_or_revenue" VARCHAR,
  "supplier_t" VARCHAR  -- Supplier(T),
  "merchant_category" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16
);

Peterborough Payments Over £500 July 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_july_2019

75 kB
3,939 rows
10 columns

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
);

Peterborough Payments Over £500 July 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_july_2020

79.79 kB
5,660 rows
10 columns

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  -- Amount In Ł,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 June 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_june_2019

75.65 kB
3,583 rows
14 columns

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: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13
);

Peterborough Payments Over £500 June 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_june_2020

74.11 kB
4,583 rows
10 columns

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  -- Amount In Ł,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 March 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_march_2019

72.08 kB
3,518 rows
10 columns

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
);

Peterborough Payments Over £500 March 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_march_2020

74.9 kB
4,433 rows
11 columns

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  -- Amount In Ł,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10
);

Peterborough Payments Over £500 May 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_may_2019

67.36 kB
3,285 rows
10 columns

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
);

Peterborough Payments Over £500 May 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_may_2020

67.05 kB
4,192 rows
10 columns

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  -- Amount In Ł,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 November 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_november_2019

70.79 kB
4,099 rows
10 columns

CREATE TABLE peterborough_payments_over_500_november_2019 (
  "body_name_t" VARCHAR  -- Body Name(T),
  "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
);

Peterborough Payments Over £500 November 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_november_2020

69.91 kB
4,579 rows
10 columns

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  -- Amount In Ś,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 October 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_october_2019

67.9 kB
3,523 rows
10 columns

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
);

Peterborough Payments Over £500 October 2020

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_october_2020

66.28 kB
4,430 rows
10 columns

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  -- Amount In Ś,
  "capital_or_revenue" VARCHAR,
  "beneficiary" VARCHAR,
  "merchant_category" VARCHAR
);

Peterborough Payments Over £500 September 2019

@ukgov.peterborough_payments_over_500_to_suppliers.peterborough_payments_over_500_september_2019

60.76 kB
2,906 rows
10 columns

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
);

Peterborough Payments Over £500 To Suppliers

About this Dataset