Expenditure Over £25k - March 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2016

11.31 kB
129 rows
8 columns

CREATE TABLE expenditure_over_25k_march_2016 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - March 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2017

12.55 kB
175 rows
8 columns

CREATE TABLE expenditure_over_25k_march_2017 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - March 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2018

12.38 kB
163 rows
8 columns

CREATE TABLE expenditure_over_25k_march_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - March 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2019

12.53 kB
171 rows
8 columns

CREATE TABLE expenditure_over_25k_march_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - March 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_march_2020

12.53 kB
179 rows
8 columns

CREATE TABLE expenditure_over_25k_march_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - May 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2014

9.91 kB
84 rows
8 columns

CREATE TABLE expenditure_over_25k_may_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - May 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2015

10.06 kB
78 rows
8 columns

CREATE TABLE expenditure_over_25k_may_2015 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - May 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2016

10.34 kB
97 rows
8 columns

CREATE TABLE expenditure_over_25k_may_2016 (
  "department_family" VARCHAR,
  "ledger_description" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "amount" DOUBLE
);

Expenditure Over £25k - May 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2017

10.72 kB
106 rows
8 columns

CREATE TABLE expenditure_over_25k_may_2017 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - May 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2018

11.06 kB
123 rows
8 columns

CREATE TABLE expenditure_over_25k_may_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over 25k - May 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2019

10.8 kB
118 rows
8 columns

CREATE TABLE expenditure_over_25k_may_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over 25k - May 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_may_2020

11.88 kB
143 rows
8 columns

CREATE TABLE expenditure_over_25k_may_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - November 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2014

10.3 kB
96 rows
8 columns

CREATE TABLE expenditure_over_25k_november_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - November 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2015

10.81 kB
111 rows
8 columns

CREATE TABLE expenditure_over_25k_november_2015 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - November 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2016

11.01 kB
120 rows
8 columns

CREATE TABLE expenditure_over_25k_november_2016 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - November 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2017

11.04 kB
123 rows
8 columns

CREATE TABLE expenditure_over_25k_november_2017 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - November 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2018

11.49 kB
135 rows
8 columns

CREATE TABLE expenditure_over_25k_november_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25K - November 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2019

11.39 kB
121 rows
8 columns

CREATE TABLE expenditure_over_25k_november_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - November 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_november_2020

16.44 kB
136 rows
10 columns

CREATE TABLE expenditure_over_25k_november_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Expenditure Over £25k - October 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2014

10.77 kB
107 rows
8 columns

CREATE TABLE expenditure_over_25k_october_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - October 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2015

10.91 kB
129 rows
8 columns

CREATE TABLE expenditure_over_25k_october_2015 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - October 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2016

10.73 kB
101 rows
8 columns

CREATE TABLE expenditure_over_25k_october_2016 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - October 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2017

10.32 kB
111 rows
8 columns

CREATE TABLE expenditure_over_25k_october_2017 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - October 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2018

11.26 kB
140 rows
8 columns

CREATE TABLE expenditure_over_25k_october_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25K - October 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2019

11.75 kB
125 rows
8 columns

CREATE TABLE expenditure_over_25k_october_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - October 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_october_2020

15.7 kB
130 rows
10 columns

CREATE TABLE expenditure_over_25k_october_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Expenditure Over £25k - September 2014

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2014

10.64 kB
104 rows
8 columns

CREATE TABLE expenditure_over_25k_september_2014 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2015

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2015

10.77 kB
106 rows
8 columns

CREATE TABLE expenditure_over_25k_september_2015 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2016

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2016

11.32 kB
106 rows
10 columns

CREATE TABLE expenditure_over_25k_september_2016 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" VARCHAR,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);

Expenditure Over £25k - September 2017

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2017

10.67 kB
108 rows
8 columns

CREATE TABLE expenditure_over_25k_september_2017 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2018

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2018

10.14 kB
87 rows
8 columns

CREATE TABLE expenditure_over_25k_september_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25K - September 2019

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2019

11.2 kB
130 rows
8 columns

CREATE TABLE expenditure_over_25k_september_2019 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE
);

Expenditure Over £25k - September 2020

@ukgov.phnt_financial_transactions_over_25k.expenditure_over_25k_september_2020

15.85 kB
152 rows
10 columns

CREATE TABLE expenditure_over_25k_september_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Expense Over £25k - February 2021

@ukgov.phnt_financial_transactions_over_25k.expense_over_25k_february_2021

18.76 kB
186 rows
10 columns

CREATE TABLE expense_over_25k_february_2021 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Spend Over 25K February 2023

@ukgov.phnt_financial_transactions_over_25k.spend_over_25k_february_2023

18.07 kB
205 rows
10 columns

CREATE TABLE spend_over_25k_february_2023 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_no" BIGINT,
  "ap_amount" DOUBLE,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Spend Over 25k - June 2020

@ukgov.phnt_financial_transactions_over_25k.spend_over_25k_june_2020

16.64 kB
145 rows
10 columns

CREATE TABLE spend_over_25k_june_2020 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" VARCHAR,
  "n" DOUBLE  -- Ł,
  "description" VARCHAR,
  "supplier_postcode" VARCHAR
);

Tables