All GPC Transparency Reports

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports

9.25 kB
198 rows
5 columns

CREATE TABLE all_gpc_transparency_reports (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" VARCHAR
);

All GPC Transparency Reports - April 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2018

5.38 kB
15 rows
5 columns

CREATE TABLE all_gpc_transparency_reports_april_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

All GPC Transparency Reports - April 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2019

4.47 kB
12 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_april_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - April 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2020

4.25 kB
7 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_april_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - April 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2021

4.37 kB
10 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_april_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - April 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2022

4.27 kB
7 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_april_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - August 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2018

5.47 kB
15 rows
5 columns

CREATE TABLE all_gpc_transparency_reports_august_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

All GPC Transparency Reports - August 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2019

4.73 kB
20 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_august_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - August 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2020

4.47 kB
12 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_august_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - August 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2021

4.29 kB
21 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_august_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

All GPC Transparency Reports - August 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2022

4.53 kB
15 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_august_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

All GPC Transparency Reports - August 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2024

4.45 kB
10 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_august_2024 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - December 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2018

5.34 kB
15 rows
5 columns

CREATE TABLE all_gpc_transparency_reports_december_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

All GPC Transparency Reports - December 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2019

4.46 kB
14 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_december_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - December 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2020

4.21 kB
8 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_december_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - December 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2021

4.32 kB
15 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_december_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

All GPC Transparency Reports - December 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2022

4.17 kB
9 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_december_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

All GPC Transparency Reports - December 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2024

4.4 kB
9 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_december_2024 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - February 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2019

4.63 kB
17 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_february_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - February 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2020

4.44 kB
15 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_february_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - February 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2021

4.38 kB
12 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_february_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - February 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2022

4.4 kB
11 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_february_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - January 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2019

4.59 kB
16 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_january_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - January 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2020

4.51 kB
14 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_january_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - January 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2021

4.39 kB
10 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_january_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - January 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2022

4.46 kB
15 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_january_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

All GPC Transparency Reports - January 2023

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2023

4.22 kB
6 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_january_2023 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - July 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2018

5.3 kB
12 rows
5 columns

CREATE TABLE all_gpc_transparency_reports_july_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

All GPC Transparency Reports - July 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2019

5.05 kB
30 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_july_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - July 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2020

4.6 kB
17 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_july_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - July 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2021

4.23 kB
6 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_july_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - July 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2022

4.32 kB
15 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_july_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" DOUBLE
);

All GPC Transparency Reports - July 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2024

4.53 kB
16 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_july_2024 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - June 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2018

5.87 kB
24 rows
5 columns

CREATE TABLE all_gpc_transparency_reports_june_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

All GPC Transparency Reports - June 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2019

4.63 kB
17 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_june_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - June 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2020

4.59 kB
18 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_june_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - June 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2021

4.76 kB
21 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_june_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - June 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2022

4.5 kB
15 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_june_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - March 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2019

5.11 kB
28 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_march_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - March 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2020

4.63 kB
18 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_march_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - March 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2021

4.64 kB
18 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_march_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - March 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2022

4.51 kB
15 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_march_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - May 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2018

5.54 kB
20 rows
5 columns

CREATE TABLE all_gpc_transparency_reports_may_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

All GPC Transparency Reports - May 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2019

4.72 kB
19 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_may_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - May 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2020

4.42 kB
11 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_may_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - May 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2021

4.45 kB
13 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_may_2021 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - May 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2022

4.36 kB
11 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_may_2022 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - November 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2018

5.4 kB
15 rows
5 columns

CREATE TABLE all_gpc_transparency_reports_november_2018 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "costcode" BIGINT,
  "expensetype" VARCHAR,
  "transactionamount" DOUBLE
);

All GPC Transparency Reports - November 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2019

4.53 kB
16 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_november_2019 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

All GPC Transparency Reports - November 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2020

4.28 kB
9 rows
4 columns

CREATE TABLE all_gpc_transparency_reports_november_2020 (
  "transactiondate" TIMESTAMP,
  "merchantname" VARCHAR,
  "transactionamount" DOUBLE,
  "referencenumber" BIGINT
);

Tables