Cooling Towers In Camden

London Borough of Camden

@ukgov.cooling_towers_in_camden

Table List

1 table(15.74 KB)

Table 1

@ukgov.cooling_towers_in_camden.table_1

15.74 KB
36 rows
17 columns

premises_name Premises Name	building_name Building Name	building_number Building Number	street Street	postcode Postcode	unit_count Unit Count	responsible_authority Responsible Authority	ward_code Ward Code	ward_name Ward Name	easting Easting	northing Northing	longitude Longitude	latitude Latitude	spatial_accuracy Spatial Accuracy	last_uploaded Last Uploaded	location Location	organisation_uri Organisation URI
Victory House	Victory House	30-34	Kingsway	WC2B 6EX	1	HSE Enforced Premises	E05013662	Holborn and Covent Garden	530633	181332	-0.11872	51.515817	Property Level	11/04/2025 08:00:11 PM	(51.515817, -0.11872)	http://opendatacommunities.org/id/london-borough-council/camden
Castlewood House	Castlewood House	77-91	New Oxford Street	WC1A 1PP	2	Local Authority Enforced Premises							Unknown	11/04/2025 08:00:11 PM		http://opendatacommunities.org/id/london-borough-council/camden
Office Block (Common Parts)	Stephenson House	75	Hampstead Road	NW1 2PL	2	Local Authority Enforced Premises							Unknown	11/04/2025 08:00:11 PM		http://opendatacommunities.org/id/london-borough-council/camden
Carter Jonas		1	Eversholt Street	NW1 2DN	2	Local Authority Enforced Premises	E05013668	Regents Park	529666	182668	-0.132157	51.528046	Property Level	11/04/2025 08:00:11 PM	(51.528046, -0.132157)	http://opendatacommunities.org/id/london-borough-council/camden
UCL Roberts Building	University College London		Torrington Place	WC1E 7JE	2	HSE Enforced Premises	E05013653	Bloomsbury	529678	182104	-0.132192	51.522975	Property Level	11/04/2025 08:00:11 PM	(51.522975, -0.132192)	http://opendatacommunities.org/id/london-borough-council/camden
Euston Tower	Euston Tower	286	Euston Road	NW1 3BY	4	Local Authority Enforced Premises	E05013668	Regents Park	529180	182343	-0.139278	51.525237	Property Level	11/04/2025 08:00:11 PM	(51.525237, -0.139278)	http://opendatacommunities.org/id/london-borough-council/camden
Carat Ltd		43-49	Parker Street	WC2B 5PS	1	Local Authority Enforced Premises							Unknown	11/04/2025 08:00:11 PM		http://opendatacommunities.org/id/london-borough-council/camden
École Jeannine Manuel		43-45	Bedford Square	WC1B 3DP	1	HSE Enforced Premises	E05013653	Bloomsbury	529854	181588	-0.129846	51.518297	Property Level	11/04/2025 08:00:11 PM	(51.518297, -0.129846)	http://opendatacommunities.org/id/london-borough-council/camden
Royal Free Hospital	Royal Free Hospital		Pond Street	NW3 2PZ	4	HSE Enforced Premises	E05013658	Gospel Oak	527297	185410	-0.165298	51.553227	Property Level	11/04/2025 08:00:11 PM	(51.553227, -0.165298)	http://opendatacommunities.org/id/london-borough-council/camden
De beers uk ltd		17	Charterhouse Street	EC1N 6RA	3	Local Authority Enforced Premises	E05013662	Holborn and Covent Garden	531484.57	181644.4	-0.106338	51.518427	Property Level	11/04/2025 08:00:11 PM	(51.518427, -0.106338)	http://opendatacommunities.org/id/london-borough-council/camden


CREATE TABLE table_1 (
  "premises_name" VARCHAR,
  "building_name" VARCHAR,
  "building_number" VARCHAR,
  "street" VARCHAR,
  "postcode" VARCHAR,
  "unit_count" BIGINT,
  "responsible_authority" VARCHAR,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "last_uploaded" VARCHAR,
  "location" VARCHAR,
  "organisation_uri" VARCHAR
);