Baselight

Council Spending

Leeds City Council

@ukgov.council_spending

May 2016
@ukgov.council_spending.may_2016

Council spending

  • 399.84 KB
  • 23125 rows
  • 15 columns
organisation_code

Organisation Code

organisation_label

Organisation Label

effective_date

Effective Date

organisational_unit

Organisational Unit

service_division_label

Service Division Label

category_internal_name

Category Internal Name

purpose

Purpose

detailed_expenditure_code

Detailed Expenditure Code

payment_date

Payment Date

transaction_number

Transaction Number

irrecoverable_vat_amount

Irrecoverable VAT Amount

amount

Amount

capital_or_revenue

Capital Or Revenue

benificiary_name

Benificiary Name

procurement_card

Procurement Card

Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingLeeds Building ServicesSupplies and ServicesOperational Materials20513-May-161605-0000127.42RA & A Electrical Distributors LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Public HealthPublic HealthSupplies and ServicesPublication And Promotion26720-May-161605-00002400RA + C MealingNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Furniture And Equipment20318-May-161605-000032249.33RA C Entertainment Technologies LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Furniture And Equipment20318-May-161605-00004559.07RA C Entertainment Technologies LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Furniture And Equipment20318-May-161605-00005928.8RA C Entertainment Technologies LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Furniture And Equipment20319-May-161605-000068391.49RA C Entertainment Technologies LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingHousing Leeds ServiceCapitalOther Costs712-May-161605-0000741.99CREDACTED PERSONAL DATANo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingHousing Leeds ServiceCapitalOther Costs726-May-161605-0000841.99CREDACTED PERSONAL DATANo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOther Hired And Contracted Services26520-May-161605-00009357.5RA J BellNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Childrens ServicesSafeguarding Targeted & SpecialistThird Party PaymentsRents (non supported)55203-May-161605-00010360RA J BlackwellNo

CREATE TABLE may_2016 (
  "organisation_code" VARCHAR,
  "organisation_label" VARCHAR,
  "effective_date" TIMESTAMP,
  "organisational_unit" VARCHAR,
  "service_division_label" VARCHAR,
  "category_internal_name" VARCHAR,
  "purpose" VARCHAR,
  "detailed_expenditure_code" BIGINT,
  "payment_date" VARCHAR,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" BIGINT,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);