Travel And Subsistence Claims

extractdate ExtractDate	organisationuri OrganisationURI	organisationlabel OrganisationLabel	servicetypeuri ServiceTypeURI	servicetypelabel ServiceTypeLabel	monthofclaim MonthOfClaim	monthpaid MonthPaid	expensetype ExpenseType	amount Amount
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1656	Staff- busines travel	May-19	Jun-19	Car mileage	7681
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1656	Staff- busines travel	May-19	Jun-19	Essential user lump sum	6483
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1656	Staff- busines travel	May-19	Jun-19	Rail Equivalent (car used but paid second class rail fare)	96
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1656	Staff- busines travel	May-19	Jun-19	Public Transport	106
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1727	Staff - expenses	May-19	Jun-19	Subsistance	39
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1028	Members - allowances	May-19	Jun-19	Car mileage	1158
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1028	Members - allowances	May-19	Jun-19	Public Transport
Tue Jun 18 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/district-council/south-lakeland	South Lakeland	http://id.esd.org.uk/service/1028	Members - allowances	May-19	Jun-19	Subsistance	9


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