Baselight
Sign In

Choice Based Lettings Bids

London Borough of Camden

@ukgov.choice_based_lettings_bids

Table 1
@ukgov.choice_based_lettings_bids.table_1

  • 298.65 KB
  • 5189 rows
  • 21 columns
advert_reference

Advert Reference

property_reference

Property Reference

property_address

Property Address

bid_opening_date

Bid Opening Date

bid_closing_date

Bid Closing Date

number_of_bedrooms

Number Of Bedrooms

number_of_bedspaces

Number Of Bedspaces

total_bidders

Total Bidders

successful_bid_points

Successful Bid Points

ward_code

Ward Code

ward_name

Ward Name

lower_super_output_area_code

Lower Super Output Area Code

lower_super_output_area_name

Lower Super Output Area Name

easting

Easting

northing

Northing

longitude

Longitude

latitude

Latitude

location

Location

spatial_accuracy

Spatial Accuracy

last_uploaded

Last Uploaded

organisation_uri

Organisation URI

104780648461 Broadfield Lane, London, NW1 9YJThu Jan 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Jan 18 2021 00:00:00 GMT+0000 (Coordinated Universal Time)1128160E05013654Camden SquareE01000868Camden 015D530011184240-0.12663251.542092(51.542092, -0.126632)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
108996330104 Clarence Gardens, London, NW1 3LPThu Oct 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Oct 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)4699840E05013668Regent's ParkE01000944Camden 023A528998182596-0.14183351.52755(51.52755, -0.141833)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
18049114164Flat 10, Chaucer House, Bells Hill, Barnet, EN5 2TFFri Sep 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Sep 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)2161330Outside Of BoroughNo Spatial Information AvailableTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
10892239105Flat B, 8 Manley Street, London, NW1 8LTThu Mar 24 2016 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Mar 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)12221590E05013667Primrose HillE01000859Camden 018C528127183925-0.15389951.539691(51.539691, -0.153899)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
184157512642 Gilden Crescent, London, NW5 4QAThu Jan 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Jan 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)23354350E05013658Gospel OakE01000891Camden 007C528178185078-0.15274451.550041(51.550041, -0.152744)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
19505436335Flat A, 6 Arctic Street, London, NW5 4DJFri Jun 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Jun 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)1296210E05013658Gospel OakE01000889Camden 007A528504185142-0.14799651.550545(51.550545, -0.147996)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
288350337056 Dowdney Close, London, NW5 2BPThu Oct 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Oct 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)4889360E05013664Kentish Town SouthE01000925Camden 009D529343185130-0.13593351.550243(51.550243, -0.135933)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
18851339229Flat B, 9 Lady Somerset Road, London, NW5 1URThu May 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)Mon May 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)186250E05013663Kentish Town NorthE01000921Camden 003C528984185666-0.14091151.555142(51.555142, -0.140911)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
194090543446 Wellesley Road, London, NW5 4PNThu May 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)Mon May 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)1267350E05013658Gospel OakE01000891Camden 007C528185185192-0.15260251.551064(51.551064, -0.152602)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden
184234646119 Castle Road, London, NW1 8SUMon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Sep 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)21455575E05013660HaverstockE01000904Camden 012C528592184595-0.14695351.545607(51.545607, -0.146953)Postcode LevelTue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)http://opendatacommunities.org/id/london-borough-council/camden

CREATE TABLE table_1 (
  "advert_reference" BIGINT,
  "property_reference" BIGINT,
  "property_address" VARCHAR,
  "bid_opening_date" TIMESTAMP,
  "bid_closing_date" TIMESTAMP,
  "number_of_bedrooms" BIGINT,
  "number_of_bedspaces" BIGINT,
  "total_bidders" BIGINT,
  "successful_bid_points" BIGINT,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "lower_super_output_area_code" VARCHAR,
  "lower_super_output_area_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" TIMESTAMP,
  "organisation_uri" VARCHAR
);