April 2019

@ukgov.travel_and_subsistence_claims.april_2019

7.75 KB
8 rows
9 columns


CREATE TABLE april_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" DOUBLE
);

August 2019

@ukgov.travel_and_subsistence_claims.august_2019

8.26 KB
8 rows
10 columns


CREATE TABLE august_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" VARCHAR,
  "unnamed_9" DOUBLE
);

December 2018

@ukgov.travel_and_subsistence_claims.december_2018

7.75 KB
8 rows
9 columns


CREATE TABLE december_2018 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" DOUBLE
);

December 2019

@ukgov.travel_and_subsistence_claims.december_2019

9.83 KB
8 rows
13 columns


CREATE TABLE december_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" DOUBLE
);

February 2019

@ukgov.travel_and_subsistence_claims.february_2019

7.75 KB
8 rows
9 columns


CREATE TABLE february_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" DOUBLE
);

January 2019

@ukgov.travel_and_subsistence_claims.january_2019

7.74 KB
8 rows
9 columns


CREATE TABLE january_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" DOUBLE
);

January 2020

@ukgov.travel_and_subsistence_claims.january_2020

8.25 KB
8 rows
10 columns


CREATE TABLE january_2020 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" VARCHAR,
  "unnamed_9" DOUBLE
);

July 2019

@ukgov.travel_and_subsistence_claims.july_2019

7.85 KB
10 rows
10 columns


CREATE TABLE july_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" VARCHAR,
  "unnamed_9" DOUBLE
);

June 2019

@ukgov.travel_and_subsistence_claims.june_2019

7.73 KB
8 rows
9 columns


CREATE TABLE june_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" BIGINT
);

March 2019

@ukgov.travel_and_subsistence_claims.march_2019

7.74 KB
8 rows
9 columns


CREATE TABLE march_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" DOUBLE
);

May 2019

@ukgov.travel_and_subsistence_claims.may_2019

7.7 KB
8 rows
9 columns


CREATE TABLE may_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" BIGINT
);

November 2019

@ukgov.travel_and_subsistence_claims.november_2019

9.83 KB
8 rows
13 columns


CREATE TABLE november_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" DOUBLE
);

October 2019

@ukgov.travel_and_subsistence_claims.october_2019

7.74 KB
8 rows
9 columns


CREATE TABLE october_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" DOUBLE
);

September 2019

@ukgov.travel_and_subsistence_claims.september_2019

8.25 KB
8 rows
10 columns


CREATE TABLE september_2019 (
  "extractdate" TIMESTAMP,
  "organisationuri" VARCHAR,
  "organisationlabel" VARCHAR,
  "servicetypeuri" VARCHAR,
  "servicetypelabel" VARCHAR,
  "monthofclaim" VARCHAR,
  "monthpaid" VARCHAR,
  "expensetype" VARCHAR,
  "amount" VARCHAR,
  "unnamed_9" DOUBLE
);