Contracts June 2015
Leicester City Council
@ukgov.contracts_june_2015
Table 1
@ukgov.contracts_june_2015.table_1
Contracts June 2015 (csv)
- 109 KB
- 849 rows
- 20 columns
contract_numberContract Number | title_of_agreementTitle Of Agreement | contract_descriptionContract Description | departmentDepartment | contract_valueContract Value | contract_value_notesContract Value Notes | annual_contract_valueAnnual Contract Value | contract_value_excl_variationsContract Value Excl Variations | start_dateStart Date | end_dateEnd Date | review_dateReview Date | review_date_notesReview Date Notes | procurement_routeProcurement Route | supplier_nameSupplier Name | supplier_addressSupplier Address | postcodePostcode | company_registration_numberCompany Registration Number | small_or_medium_sized_enterpriseSmall Or Medium Sized Enterprise | voluntary_or_community_sector_organisationVoluntary Or Community Sector Organisation | notesNotes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PAN0606 | Supply of High-Density Polyethylene (HDPE) Capping and Handrails (2) | Supply of High-Density Polyethylene (HDPE) Capping and Handrails (2) | Housing | 120000 | 120000 | Mon Apr 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Apr 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Apr 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Request for Quotation | Eco Plastic Wood Ltd | Unit 6 Oakhill Industrial Estate Euston Street, Leicester, Leicestershire, LE2 7ST | 7353313 | Yes | No | |||||
| PAN0708 | Ashton Green – Transport Consultant | Ashton Green – Transport Consultant | City Development & Neighbourhoods | 19950 | 19950 | Wed Oct 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Sat May 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Aug 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Tender - Open | WYG Environmental Planning Transport Limited | Arndale Court Otley Road Headingley, Leeds, West Yorkshire, LS6 2UJ | 3050297 | Yes | No | |||||
| PAN0735 | Medieval Animation Creation for Guild hall | Medieval Animation Creation for Guild hall | City Development & Neighbourhoods | 7000 | 7000 | Fri Sep 26 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Mar 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Mar 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Request for Quotation | Cass Productions | CASS PRODUCTIONS LTD 101 LEIGH ROAD, EASTLEIGH, HAMPSHIRE, SO50 9DR | 3667610 | Yes | No | |||||
| PAN0660 | Clerk of Works x four | Clerk of Works x four | City Development & Neighbourhoods | 58162 | 58162 | Tue May 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun May 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Sat Feb 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Tender - Open | Gage-Tupper & Associates Limited | The Signal House Evesham Station High Street, Evesham, Worcestershire, WR11 4EJ | 2563420 | Yes | No | |||||
| PAN0741 | Evaluation Reports - Creative Enterprise Hub Project | Evaluation Reports - Creative Enterprise Hub Project | City Development & Neighbourhoods | 7980 | 7980 | Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Mar 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Request for Quotation | DC Research Ltd | Info not available | 6623912 | Yes | No | |||||
| ASC123 | Midland Heart - Heathfield House | Heathfield House is a dedicated facility for drug users who require short-term supported accommodation because of a previous history of substance use. This is a 24 one – bedroom flat hostel | Adult Social Care & Health | 143000 | 143000 | Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Mar 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Sep 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tender | Midland Heart Ltd | 20 Bath Row Ladywood, Birmingham, Birmingham, B15 1LZ | IP30069R | No | No | |||||
| ASC124 | Framework Agreement for Supported Living Services for Adults with Learning Disabilities | Framework Agreement for Supported Living Services for Adults with Learning Disabilities (LOT 1) | Adult Social Care & Health | Mon Nov 26 2012 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Nov 25 2016 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri May 27 2016 00:00:00 GMT+0000 (Coordinated Universal Time) | Tender | Sterling Homecare Ltd | 11 Brunel Parkway Brunel Business Park, Derby, Derbyshire, DE24 8HR | 4258709 | Yes | No | |||||||
| PAN0531 | Tender 1- Open access youth work & positive activities to be delivered during the school summer holiday period only. | Tender 1- Open access youth work & positive activities to be delivered during the school summer holiday period only. | Education & Children's Services | 49047 | 49047 | Tue Apr 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Mar 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tender - Open | Street Vibe, B-Inspired,Boxercise,STARS, Leicestershire Fire and Rescue | Info not available | Yes | No | ||||||
| PAN0453 | Sales and Marketing Training | Sales and Marketing Training | City Development & Neighbourhoods | 900 | 450 | Mon Oct 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Oct 20 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Jul 22 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Request for Quotation | Creative Training | Chesham House 53 Lower Street, Kettering, Northamptonshire, NN16 8BH | 6126728 | Yes | No | |||||
| PAN0509 | Marketing Strategy for Visitor Centre, Leicester | Marketing Strategy for Visitor Centre, Leicester | City Development & Neighbourhoods | 37750 | 37750 | Mon Feb 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Mon Feb 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | Tue Nov 04 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tender - Open | Blue Sail | 25 Goldstone Villas, Brighton & Hove, East Sussex, BN3 3RR | 1726817 | Yes | No |
CREATE TABLE table_1 (
"contract_number" VARCHAR,
"title_of_agreement" VARCHAR,
"contract_description" VARCHAR,
"department" VARCHAR,
"contract_value" DOUBLE,
"contract_value_notes" VARCHAR,
"annual_contract_value" DOUBLE,
"contract_value_excl_variations" DOUBLE,
"start_date" TIMESTAMP,
"end_date" TIMESTAMP,
"review_date" TIMESTAMP,
"review_date_notes" VARCHAR,
"procurement_route" VARCHAR,
"supplier_name" VARCHAR,
"supplier_address" VARCHAR,
"postcode" VARCHAR,
"company_registration_number" VARCHAR,
"small_or_medium_sized_enterprise" VARCHAR,
"voluntary_or_community_sector_organisation" VARCHAR,
"notes" VARCHAR
);