Camden Non-Domestic Rates - Rateable Values

London Borough of Camden

@ukgov.camden_non_domestic_rates_rateable_values

Table List

1 table(13.18 MB)

Table 1

@ukgov.camden_non_domestic_rates_rateable_values.table_1

13.18 MB
283436 rows
16 columns

property_reference Property Reference	address Address	start_date Start Date	end_date End Date	rateable_value Rateable Value	description Description	transitional_relief_for_whole_year Transitional Relief For Whole Year	spatial_accuracy Spatial Accuracy	last_uploaded Last Uploaded	organisation_uri Organisation URI	socrata_id Socrata ID
UPRN01212019600024	BST & GND, 196 SHAFTESBURY AVENUE, LONDON, WC2H 8LF	Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	73000	SHOP AND PREMISES	1431.96	No spatial information available	23/12/2024 03:27:37 PM	http://opendatacommunities.org/id/london-borough-council/camden	163237
UPRN012040103I8994	BST 124 AT, 103 NEW OXFORD STREET, LONDON, WC1A 1DD	Sat Apr 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2500	CAR PARKING SPACE	-19.83	No spatial information available	23/12/2024 03:27:26 PM	http://opendatacommunities.org/id/london-borough-council/camden	143227
UPRN00816005900006	59 CHESTER ROAD, LONDON, NW1 4NP	Fri Apr 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	24250	LIBRARY AND PREMISES		No spatial information available	23/12/2024 03:27:09 PM	http://opendatacommunities.org/id/london-borough-council/camden	114229
UPRN01125001000085	8TH FLR, 10 BLOOMSBURY WAY, LONDON, WC2A 2SL	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	680000	OFFICES AND PREMISES		No spatial information available	23/12/2024 03:28:09 PM	http://opendatacommunities.org/id/london-borough-council/camden	220338
UPRN01058006310022	GND F, 63 CHARLOTTE STREET, LONDON, W1T 4PG	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	18500	CAFE & PREMISES		No spatial information available	23/12/2024 03:26:07 PM	http://opendatacommunities.org/id/london-borough-council/camden	10608
UPRN01261014200459	RM 1.053 1ST FLR, WATERHOUSE SQUARE, 142 HOLBORN, LONDON, EC1N 2NH	Mon Apr 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)		2800	OFFICES AND PREMISES		No spatial information available	23/12/2024 03:28:43 PM	http://opendatacommunities.org/id/london-borough-council/camden	281544
UPRN0123200101001A	BST, 10 DRURY LANE, LONDON, WC2B 5RF	Tue Apr 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 31 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	24500	CAR PARKING SPACE AND PREMISES		No spatial information available	23/12/2024 03:26:51 PM	http://opendatacommunities.org/id/london-borough-council/camden	85545
UPRN05076033320001	NEXT TO, 33 LIDDELL ROAD, LONDON, NW6 2EW	Sun Apr 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 31 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	3750	STORE AND PREMISES		No spatial information available	23/12/2024 03:26:29 PM	http://opendatacommunities.org/id/london-borough-council/camden	50920
UPRN01261014210231	RM 2.031 2ND FLR, WATERHOUSE SQUAR, 142 HOLBORN, LONDON, EC1N 2NH	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	6400	OFFICE		No spatial information available	23/12/2024 03:28:11 PM	http://opendatacommunities.org/id/london-borough-council/camden	224470
UPRN00780006720024	2ND FLR WEST, 67-78 HAMPSTEAD ROAD, LONDON, NW1 2PN	Thu Apr 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)		PROPERTY UNDERGOIND REDEVELOPMENT		No spatial information available	23/12/2024 03:28:05 PM	http://opendatacommunities.org/id/london-borough-council/camden	212898


CREATE TABLE table_1 (
  "property_reference" VARCHAR,
  "address" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "rateable_value" DOUBLE,
  "description" VARCHAR,
  "transitional_relief_for_whole_year" DOUBLE,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "spatial_accuracy" VARCHAR,
  "location" VARCHAR,
  "last_uploaded" VARCHAR,
  "organisation_uri" VARCHAR,
  "socrata_id" BIGINT
);