Choice Based Lettings Bids

London Borough of Camden

@ukgov.choice_based_lettings_bids

Table List

1 table(298.65 KB)

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
104780	6484	61 Broadfield Lane, London, NW1 9YJ	Thu Jan 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 18 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		1	128	160	E05013654	Camden Square	E01000868	Camden 015D	530011	184240	-0.126632	51.542092	(51.542092, -0.126632)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
108996	330	104 Clarence Gardens, London, NW1 3LP	Thu Oct 19 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	4	6	99	840	E05013668	Regent's Park	E01000944	Camden 023A	528998	182596	-0.141833	51.52755	(51.52755, -0.141833)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
180491	14164	Flat 10, Chaucer House, Bells Hill, Barnet, EN5 2TF	Fri Sep 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2		161	330		Outside Of Borough								No Spatial Information Available	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
108922	39105	Flat B, 8 Manley Street, London, NW1 8LT	Thu Mar 24 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 28 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	1	2	221	590	E05013667	Primrose Hill	E01000859	Camden 018C	528127	183925	-0.153899	51.539691	(51.539691, -0.153899)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
184157	5126	42 Gilden Crescent, London, NW5 4QA	Thu Jan 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2	3	354	350	E05013658	Gospel Oak	E01000891	Camden 007C	528178	185078	-0.152744	51.550041	(51.550041, -0.152744)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
195054	36335	Flat A, 6 Arctic Street, London, NW5 4DJ	Fri Jun 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 12 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	1	2	96	210	E05013658	Gospel Oak	E01000889	Camden 007A	528504	185142	-0.147996	51.550545	(51.550545, -0.147996)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
288350	33705	6 Dowdney Close, London, NW5 2BP	Thu Oct 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4	8	89	360	E05013664	Kentish Town South	E01000925	Camden 009D	529343	185130	-0.135933	51.550243	(51.550243, -0.135933)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
188513	39229	Flat B, 9 Lady Somerset Road, London, NW5 1UR	Thu May 17 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 21 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		1	86	250	E05013663	Kentish Town North	E01000921	Camden 003C	528984	185666	-0.140911	51.555142	(51.555142, -0.140911)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
194090	5434	46 Wellesley Road, London, NW5 4PN	Thu May 23 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 27 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	1	2	67	350	E05013658	Gospel Oak	E01000891	Camden 007C	528185	185192	-0.152602	51.551064	(51.551064, -0.152602)	Postcode Level	Tue Apr 29 2025 00:00:00 GMT+0000 (Coordinated Universal Time)	http://opendatacommunities.org/id/london-borough-council/camden
184234	646	119 Castle Road, London, NW1 8SU	Mon Sep 06 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 08 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2	1	455	575	E05013660	Haverstock	E01000904	Camden 012C	528592	184595	-0.146953	51.545607	(51.545607, -0.146953)	Postcode Level	Tue 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
);