Travel And Subsistence Claims

extractdate ExtractDate	organisationuri OrganisationURI	organisationlabel OrganisationLabel	servicetypeuri ServiceTypeURI	servicetypelabel ServiceTypeLabel	monthofclaim MonthOfClaim	monthpaid MonthPaid	expensetype ExpenseType	unnamed_12 Unnamed: 12
Tue Dec 17 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	Nov-19	Dec-19	Car mileage	6140.72
Tue Dec 17 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	Nov-19	Dec-19	Essential user lump sum	6271
Tue Dec 17 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	Nov-19	Dec-19	Rail Equivalent (car used but paid second class rail fare)	82.5
Tue Dec 17 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	Nov-19	Dec-19	Public Transport	109.25
Tue Dec 17 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	Nov-19	Dec-19	Subsistance	14.6
Tue Dec 17 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	Nov-19	Dec-19	Car mileage	495.45
Tue Dec 17 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	Nov-19	Dec-19	Public Transport	7.3
Tue Dec 17 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	Nov-19	Dec-19	Subsistance	9.91


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_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" DOUBLE
);