Baselight

Casual Car User Mileage

Leeds City Council

@ukgov.casual_car_user_mileage

2018-2019
@ukgov.casual_car_user_mileage.n_2018_2019

  • 66.44 KB
  • 2081 rows
  • 12 columns
pers_area

Pers Area

personnel_subarea

Personnel Subarea

organisational_unit

Organisational Unit

cost_centre

Cost Centre

location_description

Location Description

wk_hrs

Wk.hrs.

fte

FTE

claims_submitted

Claims Submitted

total_miles_claimed

Total Miles Claimed

total_amount_claimed

Total Amount Claimed

unnamed_10

Unnamed: 10

unnamed_11

Unnamed: 11

Children & FamiliesLA ChildrenAdel Beck OperationsAdel BeckAdel Beck Secure Childrens Ctre LS16 8EB371101155825895.5
Resources & HousingBus Spt CtreCorporate Print HubPrint & Sign AgencyLimewood Approach LS14 1NZ3715100954523.75
Civic Enterprise LeedsPassenger TransPassenger Assistants ASpecial educ needsWestland Road Passenger Svcs LS11 5SB250.681784973872.32
Adults & HealthDirectorateADASS Yorkshire & HumbersideArea EnablersMerrion House - Floor 5 West LS2 8BB29.50.8679823591.9
Civic Enterprise LeedsCleaning LeedsSchool Crossing Patrol ASchool Crossing PatrSchool Crossing Patrol - Wardens18.50.5971573220.65
Civic Enterprise LeedsCleaning LeedsSchool Crossing Patrol BSchool Crossing PatrCommunity Based School Crossing Patrol100.271362362806.2
Resources & HousingHousing P&CGas Services SouthMechncl & ElectrclNavigation House Floor 1 LS10 1DJ3711260762655.54
Children & FamiliesSch Imp TchrsStringsMusic Support SvcsMusic Service - Peripatetic22.580.69961372623.95
Civic Enterprise LeedsCleaning LeedsSchool Crossing Patrol CSchool Crossing PatrSchool Crossing Patrol - Wardens18.50.51455912515.95
Communities & EnvironmentParks & CountryBereavement Services OperationsAdministration - CemLawnswood Cemetery LS16 6AH3711155592501.55

CREATE TABLE n_2018_2019 (
  "pers_area" VARCHAR,
  "personnel_subarea" VARCHAR,
  "organisational_unit" VARCHAR,
  "cost_centre" VARCHAR,
  "location_description" VARCHAR,
  "wk_hrs" DOUBLE,
  "fte" DOUBLE,
  "claims_submitted" DOUBLE,
  "total_miles_claimed" BIGINT,
  "total_amount_claimed" DOUBLE,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR
);