April 2019

@ukgov.travel_and_subsistence_claims.april_2019

7.93 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.46 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  -- Unnamed: 9
);

December 2018

@ukgov.travel_and_subsistence_claims.december_2018

7.93 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

10.06 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: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" DOUBLE  -- Unnamed: 12
);

February 2019

@ukgov.travel_and_subsistence_claims.february_2019

7.93 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.93 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.45 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  -- Unnamed: 9
);

July 2019

@ukgov.travel_and_subsistence_claims.july_2019

8.04 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  -- Unnamed: 9
);

June 2019

@ukgov.travel_and_subsistence_claims.june_2019

7.92 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.92 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.89 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

10.07 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: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" DOUBLE  -- Unnamed: 12
);

October 2019

@ukgov.travel_and_subsistence_claims.october_2019

7.93 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.45 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  -- Unnamed: 9
);