Baselight

Council Spending

Leeds City Council

@ukgov.council_spending

August 2016
@ukgov.council_spending.august_2016

Council spending

  • 425.29 KB
  • 24846 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 CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Childrens ServicesSafeguarding Targeted & SpecialistThird Party PaymentsSection 17551Fri Aug 05 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-00001846RA A DomesticsNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Wed Aug 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-0000297.74RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Wed Aug 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-0000319.04RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Wed Aug 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-000045.78RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingLeeds Building ServicesSupplies and ServicesOperational Materials205Fri Aug 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-000055.09RA Andrews & Sons (Marbles & Tiles)No
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Environment & HousingHousing Leeds ServiceCapitalOther Costs7Tue Aug 16 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-00006168.15CREDACTED PERSONAL DATANo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Furniture And Equipment203Tue Aug 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-00007173.19RA C Entertainment Technologies LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Materials205Mon Aug 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-00008115.3RA C Entertainment Technologies LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Furniture And Equipment203Wed Aug 24 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-00009147.5RA C Entertainment Technologies LtdNo
Http://opendatacommunities.org/id/metropolitan-district-council/leedsLeeds City CouncilWed Aug 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)City DevelopmentLibraries Arts & HeritageSupplies and ServicesOperational Furniture And Equipment203Wed Aug 24 2016 00:00:00 GMT+0000 (Coordinated Universal Time)1608-00010265.99RA C Entertainment Technologies LtdNo

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