Baselight

Council Spending

Leeds City Council

@ukgov.council_spending

July 2018
@ukgov.council_spending.july_2018

Council spending

  • 410.97 KB
  • 23871 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 Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Thu Jul 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000122.2RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Thu Jul 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-00002110.2RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Thu Jul 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000375.93RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Fri Jul 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000442.09RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Mon Jul 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000525.54RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Wed Jul 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000612.77RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Wed Jul 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000786.5RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Fri Jul 27 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000818.51RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Resources and HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Mon Jul 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-0000958.97RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilTue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Children and FamiliesSocial CareThird Party PaymentsServices Rendered By Other Organisations511Fri Jul 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)0718-00010103.35RREDACTED PERSONAL DATANo

CREATE TABLE july_2018 (
  "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" DOUBLE,
  "payment_date" TIMESTAMP,
  "transaction_number" VARCHAR,
  "irrecoverable_vat_amount" DOUBLE,
  "amount" DOUBLE,
  "capital_or_revenue" VARCHAR,
  "benificiary_name" VARCHAR,
  "procurement_card" VARCHAR
);