Travel And Subsistence Claims

extractdate ExtractDate	organisationuri OrganisationURI	organisationlabel OrganisationLabel	servicetypeuri ServiceTypeURI	servicetypelabel ServiceTypeLabel	monthofclaim MonthOfClaim	monthpaid MonthPaid	expensetype ExpenseType	unnamed_9 Unnamed: 9
Fri Oct 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	Jul-19	Aug-19	Car mileage	7481.54
Fri Oct 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	Jul-19	Aug-19	Essential user lump sum	6511.15
Fri Oct 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	Jul-19	Aug-19	Rail Equivalent (car used but paid second class rail fare)	14.8
Fri Oct 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	Jul-19	Aug-19	Public Transport	100.85
Fri Oct 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	Jul-19	Aug-19	Subsistance	78.43
Fri Oct 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	Jul-19	Aug-19	Car mileage	1975.95
Fri Oct 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	Jul-19	Aug-19	Public Transport	11.9
Fri Oct 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	Jul-19	Aug-19	Subsistance	24.45


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