Travel And Subsistence Claims

extractdate ExtractDate	organisationuri OrganisationURI	organisationlabel OrganisationLabel	servicetypeuri ServiceTypeURI	servicetypelabel ServiceTypeLabel	monthofclaim MonthOfClaim	monthpaid MonthPaid	expensetype ExpenseType	amount Amount
Thu Feb 21 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	Dec-18	Jan-19	Car mileage	6159.64
Thu Feb 21 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	Dec-18	Jan-19	Essential user lump sum	6807.82
Thu Feb 21 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	Dec-18	Jan-19	Rail Equivalent (car used but paid second class rail fare)	43
Thu Feb 21 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	Dec-18	Jan-19	Public Transport	55.7
Thu Feb 21 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	Dec-18	Jan-19	Subsistance	8.1
Thu Feb 21 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	Dec-18	Jan-19	Car mileage	577.8
Thu Feb 21 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	Dec-18	Jan-19	Public Transport
Thu Feb 21 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	Dec-18	Jan-19	Subsistance


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