Travel And Subsistence Claims

extractdate ExtractDate	organisationuri OrganisationURI	organisationlabel OrganisationLabel	servicetypeuri ServiceTypeURI	servicetypelabel ServiceTypeLabel	monthofclaim MonthOfClaim	monthpaid MonthPaid	expensetype ExpenseType	amount Amount
Wed Apr 24 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	Mar-19	Apr-19	Car mileage	8568.26
Wed Apr 24 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	Mar-19	Apr-19	Essential user lump sum	6811.68
Wed Apr 24 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	Mar-19	Apr-19	Rail Equivalent (car used but paid second class rail fare)	49.1
Wed Apr 24 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	Mar-19	Apr-19	Public Transport	180.1
Wed Apr 24 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	Mar-19	Apr-19	Subsistance	15.99
Wed Apr 24 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	Mar-19	Apr-19	Car mileage	1302.75
Wed Apr 24 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	Mar-19	Apr-19	Public Transport	70.1
Wed Apr 24 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	Mar-19	Apr-19	Subsistance	25


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