All GPC Transparency Reports by UK Government | Environmental and Climate Sciences

All GPC Transparency Reports

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports

9.04 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 - May 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2020

4.32 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 - August 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2019

4.62 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 - January 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2022

4.35 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 - December 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2024

4.3 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 - October 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_october_2021

4.27 KB
9 rows
4 columns


CREATE TABLE all_gpc_transparency_reports_october_2021 (
  "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.37 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 - December 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2021

4.22 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 - April 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2020

4.15 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 - May 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2018

5.41 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 - March 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2022

4.41 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 - April 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2021

4.27 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 - March 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2019

4.99 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 - June 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2019

4.52 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 - December 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2020

4.11 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 - February 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2019

4.52 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 - June 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2021

4.65 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 - July 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2020

4.5 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 - October 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_october_2019

4.42 KB
15 rows
4 columns


CREATE TABLE all_gpc_transparency_reports_october_2019 (
  "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.29 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 - April 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2022

4.17 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 - June 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2020

4.49 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 - April 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2018

5.25 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 - February 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2022

4.3 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 2023

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2023

4.12 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 - November 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2019

4.43 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 - August 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2022

4.42 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 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2021

4.19 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 - February 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2021

4.27 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 - January 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2020

4.4 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 - November 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2018

5.27 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 - October 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_october_2024

4.84 KB
29 rows
4 columns


CREATE TABLE all_gpc_transparency_reports_october_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.74 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 - February 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_february_2020

4.33 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 - May 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2022

4.26 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 - July 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2018

5.17 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 - December 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2019

4.36 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 - January 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_january_2019

4.48 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 - May 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_may_2019

4.61 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 - November 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2020

4.18 KB
9 rows
4 columns


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

All GPC Transparency Reports - September 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_september_2018

5.37 KB
18 rows
5 columns


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

All GPC Transparency Reports - October 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_october_2022

4.27 KB
15 rows
4 columns


CREATE TABLE all_gpc_transparency_reports_october_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.43 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 - December 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2018

5.21 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 - July 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2021

4.13 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 - November 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2024

4.23 KB
8 rows
4 columns


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

All GPC Transparency Reports - September 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_september_2022

4.44 KB
15 rows
4 columns


CREATE TABLE all_gpc_transparency_reports_september_2022 (
  "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.34 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 - August 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2018

5.34 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 - March 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2020

4.52 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 - September 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_september_2019

4.48 KB
18 rows
4 columns


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

All GPC Transparency Reports - November 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2021

4.43 KB
15 rows
4 columns


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

All GPC Transparency Reports - August 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_august_2024

4.34 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 - September 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_september_2021

4.49 KB
21 rows
4 columns


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

All GPC Transparency Reports - April 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_april_2019

4.37 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 - September 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_september_2020

4.31 KB
10 rows
4 columns


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

All GPC Transparency Reports - November 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_november_2022

4.25 KB
15 rows
4 columns


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

All GPC Transparency Reports - June 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_june_2022

4.39 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 - October 2020

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_october_2020

4.42 KB
14 rows
4 columns


CREATE TABLE all_gpc_transparency_reports_october_2020 (
  "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.22 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 - March 2021

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_march_2021

4.53 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 - December 2022

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_december_2022

4.07 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 - September 2024

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_september_2024

4.57 KB
26 rows
4 columns


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

All GPC Transparency Reports - July 2019

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_july_2019

4.93 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 - October 2018

@ukgov.all_gpc_transparency_reports.all_gpc_transparency_reports_october_2018

5.43 KB
17 rows
5 columns


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

Tables