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

All GPC Transparency Reports

About this Dataset