home / uk_version_0_4

entity_recordDetails_addresses

5,790,763 rows

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_entity_statement type address postcode country_name country_code
0.recordDetails.addresses.0 0 service Pipersdene, Parkwood Road, Tatsfield, Westerham, England TN16 2LT United Kingdom GB
1.recordDetails.addresses.0 1 service 71 Horn Park Lane, London, England SE12 8AP United Kingdom GB
10.recordDetails.addresses.0 10 service 4 Maxted Road, Hemel Hempstead Industrial Estate, Hemel Hempstead, England HP2 7BE United Kingdom GB
100.recordDetails.addresses.0 100 service Court Lodge Farm, Forge Lane, East Farleigh, Maidstone, England ME15 0HQ United Kingdom GB
1000.recordDetails.addresses.0 1000 registered 27 ASTON ROAD, BRIGHTHAMPTON, WITNEY, ENGLAND OX29 7QW United Kingdom GB
10000.recordDetails.addresses.0 10000 registered OFFICE 3, 146/148 BURY OLD ROAD, MANCHESTER M45 6AT United Kingdom GB
100000.recordDetails.addresses.0 100000 registered     United Kingdom GB
1000000.recordDetails.addresses.0 1000000 registered 319B WALTON ROAD, WEST MOLESEY, ENGLAND KT8 2QG United Kingdom GB
1000001.recordDetails.addresses.0 1000001 registered 27 OLD GLOUCESTER STREET, LONDON WC1N 3AX United Kingdom GB
1000002.recordDetails.addresses.0 1000002 registered LYNWOOD HOUSE, 373/375 STATION ROAD, HARROW, MIDDLESEX HA1 2AW United Kingdom GB
1000003.recordDetails.addresses.0 1000003 registered HARLEYWOOD HOUSE BROOKFIELD ROAD, CHURCHDOWN, GLOUCESTER, GLOUCESTERSHIRE GL3 2PF United Kingdom GB
1000004.recordDetails.addresses.0 1000004 registered 10 BOOTH STREET, SALFORD, ENGLAND M3 5DG United Kingdom GB
1000005.recordDetails.addresses.0 1000005 registered 17 TENNYSON ROAD, PENGE, LONDON SE20 7ND United Kingdom GB
1000006.recordDetails.addresses.0 1000006 registered 23 CANONBURY PARK NORTH, ISLINGTON, LONDON N1 2JZ United Kingdom GB
1000007.recordDetails.addresses.0 1000007 registered 20 WENLOCK ROAD, LONDON, ENGLAND N1 7GU United Kingdom GB
1000008.recordDetails.addresses.0 1000008 registered H C A CAPITAL HOUSE, 7 SHEEPSCAR COURT, LEEDS, ENGLAND LS7 2BB United Kingdom GB
1000009.recordDetails.addresses.0 1000009 registered 47-49 NEW HALL LANE, PRESTON, ENGLAND PR1 5NY United Kingdom GB
100001.recordDetails.addresses.0 100001 registered FISHER HOUSE, 84 FISHERTON STREET, SALISBURY, WILTSHIRE SP2 7QY United Kingdom GB
1000010.recordDetails.addresses.0 1000010 registered OLD FARM HOUSE STATION ROAD, SIBSEY, BOSTON, ENGLAND PE22 0SA United Kingdom GB
1000011.recordDetails.addresses.0 1000011 registered 34 WILLIAM BONNEY ESTATE, LONDON, ENGLAND SW4 7JQ United Kingdom GB
1000012.recordDetails.addresses.0 1000012 registered WIGLEY FARM WIGLEY DRIVE, WIGLEY, LUDLOW, SHROPSHIRE SY8 3DR United Kingdom GB
1000013.recordDetails.addresses.0 1000013 registered 85 GREAT PORTLAND STREET, LONDON, ENGLAND W1W 7LT United Kingdom GB
1000014.recordDetails.addresses.0 1000014 registered OFFICE 4, 3/F COACHWORKS ARCADE, NORTHGATE STREET, CHESTER CH1 2EY United Kingdom GB
1000015.recordDetails.addresses.0 1000015 registered PAULTON HOUSE OLD MILLS, PAULTON, BRISTOL, ENGLAND BS39 7SX United Kingdom GB
1000016.recordDetails.addresses.0 1000016 registered 47 BENTRA ROAD, BALLYCARRY, CARRICKFERGUS, NORTHERN IRELAND BT38 9JY United Kingdom GB
1000017.recordDetails.addresses.0 1000017 registered UNIT 1 SWALLOW COURT, KETTERING PARKWAY, KETTERING, NORTHAMPTONSHIRE NN15 6XX United Kingdom GB
1000018.recordDetails.addresses.0 1000018 registered UNIT-1E, NORTH CRESCENT, LONDON, ENGLAND E16 4TG United Kingdom GB
1000019.recordDetails.addresses.0 1000019 registered 57 EMLYN ROAD, LONDON, ENGLAND W12 9TG United Kingdom GB
100002.recordDetails.addresses.0 100002 registered 52 OSBORNE ROAD, SOUTHSEA, HAMPSHIRE PO5 3LU United Kingdom GB
1000020.recordDetails.addresses.0 1000020 registered 4 PARK APPROACH, WELLING, ENGLAND DA16 2AW United Kingdom GB
1000021.recordDetails.addresses.0 1000021 registered ST MARY'S HOUSE, NETHERHAMPTON, SALISBURY, WILTSHIRE SP2 8PU United Kingdom GB
1000022.recordDetails.addresses.0 1000022 registered ACRE HOUSE, 11/15 WILLIAM ROAD, LONDON NW1 3ER United Kingdom GB
1000023.recordDetails.addresses.0 1000023 registered 36 A ENTERPRISE HOUSE, 44-46 TERRACE ROAD, WALTON-ON-THAMES, SURREY KT12 2SD United Kingdom GB
1000024.recordDetails.addresses.0 1000024 registered 37 BEAUMONT AVENUE, SOUTH ELMSALL, PONTEFRACT, ENGLAND WF9 2XE United Kingdom GB
1000025.recordDetails.addresses.0 1000025 registered 20-22 WENLOCK ROAD, LONDON, ENGLAND N1 7GU United Kingdom GB
1000026.recordDetails.addresses.0 1000026 registered 6 BEVIS COURT, LONDON, ENGLAND EC3A 7BA United Kingdom GB
1000027.recordDetails.addresses.0 1000027 registered 2 BLUEWATER QUAY, WIXAMS, BEDFORD, BEDFORDSHIRE MK42 6BF United Kingdom GB
1000028.recordDetails.addresses.0 1000028 registered ARQUEN HOUSE, 4-6 SPICER STREET, ST. ALBANS, ENGLAND AL3 4PQ United Kingdom GB
1000029.recordDetails.addresses.0 1000029 registered 1 PARKSHOT, RICHMOND, SURREY TW9 2RD United Kingdom GB
100003.recordDetails.addresses.0 100003 registered 5 BOLLIN GROVE, PRESTBURY, MACCLESFIELD SK10 4JJ United Kingdom GB
1000030.recordDetails.addresses.0 1000030 registered 22B HIGH STREET, WITNEY, ENGLAND OX28 6RB United Kingdom GB
1000031.recordDetails.addresses.0 1000031 registered C/O RILEY ACCOUNTANTS LTD FIRST FLOOR, 11 HIGH STREET, TRING, ENGLAND HP23 5AL United Kingdom GB
1000032.recordDetails.addresses.0 1000032 registered TREVIOT HOUSE, 186-192 HIGH ROAD, ILFORD, ESSEX IG1 1LR United Kingdom GB
1000033.recordDetails.addresses.0 1000033 registered C/0 CLARKE BELL LIMITED, 3RD FLOOR, THE PINNACLE, 73 KING STREET, MANCHESTER M2 4NG United Kingdom GB
1000034.recordDetails.addresses.0 1000034 registered 124 CITY ROAD, LONDON, ENGLAND EC1V 2NX United Kingdom GB
1000035.recordDetails.addresses.0 1000035 registered 8 WELLESLEY ROAD, CHISWICK, LONDON W4 4BL United Kingdom GB
1000036.recordDetails.addresses.0 1000036 registered 1 DAVENPORT HOUSE, 207 REGENT ST, LONDON, ENGLAND W1B 3HH United Kingdom GB
1000037.recordDetails.addresses.0 1000037 registered 35-37 OFFICE 7, LUDGATE HILL, LONDON, ENGLAND EC4M 7JN United Kingdom GB
1000038.recordDetails.addresses.0 1000038 registered 34-40 HIGH STREET, WANSTEAD, LONDON E11 2RJ United Kingdom GB
1000039.recordDetails.addresses.0 1000039 registered 2 TOOMERS WHARF, CANAL WALK, NEWBURY, BERKSHIRE RG14 1DY United Kingdom GB
100004.recordDetails.addresses.0 100004 registered THE FOXHUNTER PARK, MONKTON, RAMSGATE, KENT CT12 4JG United Kingdom GB
1000040.recordDetails.addresses.0 1000040 registered 2 LAMMAS MEAD, BINFIELD, BRACKNELL, ENGLAND RG42 4NF United Kingdom GB
1000041.recordDetails.addresses.0 1000041 registered 52 NAUTILUS BUILDING, 3 MYDDELTON PASSAGE, LONDON EC1R 1XW United Kingdom GB
1000042.recordDetails.addresses.0 1000042 registered 9 ROBERT CLOSE, BILLERICAY, ENGLAND CM12 9DS United Kingdom GB
1000043.recordDetails.addresses.0 1000043 registered SQUARE MILE DENTAL CENTRE, 7 - 9 WHITE KENNETT STREET, LONDON, GREATER LONDON E1 7BS United Kingdom GB
1000044.recordDetails.addresses.0 1000044 registered 10 PANGBOURNE DRIVE, STANMORE, MIDDLESEX HA7 4QT United Kingdom GB
1000045.recordDetails.addresses.0 1000045 registered 44 ST PETERS STREET, ISLINGTON, LONDON N1 8JT United Kingdom GB
1000046.recordDetails.addresses.0 1000046 registered 2 KINGDOM STREET, PADDINGTON CENTRAL, LONDON, ENGLAND W2 6BD United Kingdom GB
1000047.recordDetails.addresses.0 1000047 registered 67 EMPRESS AVENUE, WEST MERSEA, COLCHESTER, ENGLAND CO5 8BL United Kingdom GB
1000048.recordDetails.addresses.0 1000048 registered 3 WARREN YARD, WARREN PARK WOLVERTON MILL, MILTON KEYNES, BUCKINGHAMSHIRE MK12 5NW United Kingdom GB
1000049.recordDetails.addresses.0 1000049 registered 26 HIGH STREET, RICKMANSWORTH, HERTFORDSHIRE WD3 1ER United Kingdom GB
100005.recordDetails.addresses.0 100005 registered OXSTALLS FARM, WARWICK ROAD, STRATFORD-UPON-AVON, WARWICKSHIRE CV37 0NS United Kingdom GB
1000050.recordDetails.addresses.0 1000050 registered 11 HIGH STREET, KENSINGTON, LONDON W14 8NN United Kingdom GB
1000051.recordDetails.addresses.0 1000051 registered LEVEL 30 THE LEADENHALLL BUILDING, 122 LEADENHALL STREET, LONDON, ENGLAND EC3V 4AB United Kingdom GB
1000052.recordDetails.addresses.0 1000052 registered 86-90 PAUL STREET, SHOREDITCH, LONDON, ENGLAND EC2A 4NE United Kingdom GB
1000053.recordDetails.addresses.0 1000053 registered NORTHGATE, 118 NORTH STREET, LEEDS, ENGLAND LS2 7PN United Kingdom GB
1000054.recordDetails.addresses.0 1000054 registered 34-40 HIGH STREET, WANSTEAD, LONDON E11 2RJ United Kingdom GB
1000055.recordDetails.addresses.0 1000055 registered 8TH FLOOR, 167 FLEET STREET, LONDON, ENGLAND EC4A 2EA United Kingdom GB
1000056.recordDetails.addresses.0 1000056 registered 337 FOREST ROAD, LONDON E17 5JR United Kingdom GB
1000057.recordDetails.addresses.0 1000057 registered 28 THE RIDGE, ORPINGTON, KENT BR6 8AQ United Kingdom GB
1000058.recordDetails.addresses.0 1000058 registered 2ND FLOOR GROVE HOUSE, 55 LOWLANDS ROAD, HARROW, MIDDLESEX HA1 3AW United Kingdom GB
1000059.recordDetails.addresses.0 1000059 registered 5TH FLOOR, 101, WIGMORE STREET, LONDON, ENGLAND W1U 1QU United Kingdom GB
100006.recordDetails.addresses.0 100006 registered FOXHUNTER PARK, MONKTON, RAMSGATE, KENT CT12 4JG United Kingdom GB
1000060.recordDetails.addresses.0 1000060 registered 5TH FLOOR, 101, WIGMORE STREET, LONDON, ENGLAND W1U 1QU United Kingdom GB
1000061.recordDetails.addresses.0 1000061 registered 311 COMMERCIAL ROAD, LONDON, ENGLAND E1 2PS United Kingdom GB
1000062.recordDetails.addresses.0 1000062 registered 146A LANDCROFT ROAD, LONDON SE22 9JW United Kingdom GB
1000063.recordDetails.addresses.0 1000063 registered ANGLO HOUSE, BELL LANE, AMERSHAM, BUCKINGHAMSHIRE HP6 6FA United Kingdom GB
1000064.recordDetails.addresses.0 1000064 registered 13 THE DRIVE, BUCKHURST HILL, ESSEX IG9 5RB United Kingdom GB
1000065.recordDetails.addresses.0 1000065 registered 3RD FLOOR, 207 REGENT STREET, LONDON W1B 3HH United Kingdom GB
1000066.recordDetails.addresses.0 1000066 registered 30 FIRS PARK GARDENS, LONDON N21 2PX United Kingdom GB
1000067.recordDetails.addresses.0 1000067 registered 20-22 WENLOCK ROAD, LONDON, ENGLAND N1 7GU United Kingdom GB
1000068.recordDetails.addresses.0 1000068 registered 2 POLRUNNY COTTAGES, MINSTER, BOSCASTLE, CORNWALL PL35 0EL United Kingdom GB
1000069.recordDetails.addresses.0 1000069 registered 146A LANDCROFT ROAD, LONDON SE22 9JW United Kingdom GB
100007.recordDetails.addresses.0 100007 registered OFFICE 1, 9, STANHOPE COMMUNITY CENTRE, FRONT STREET, STANHOPE, COUNTY DURHAM DL13 2NQ United Kingdom GB
1000070.recordDetails.addresses.0 1000070 registered PILGRIM HOUSE 10 BISHOP STREET, TOWN HALL SQUARE, LEICESTER, ENGLAND LE1 6AF United Kingdom GB
1000071.recordDetails.addresses.0 1000071 registered 20 WENLOCK ROAD, LONDON, ENGLAND N1 7GU United Kingdom GB
1000072.recordDetails.addresses.0 1000072 registered 124 CITY ROAD, LONDON, ENGLAND EC1V 2NX United Kingdom GB
1000073.recordDetails.addresses.0 1000073 registered 20-22 WENLOCK ROAD, LONDON, ENGLAND N1 7GU United Kingdom GB
1000074.recordDetails.addresses.0 1000074 registered 8 WELLESLEY ROAD, LONDON, ENGLAND W4 4BL United Kingdom GB
1000075.recordDetails.addresses.0 1000075 registered 3 WARREN YARD WARREN PARK, STRATFORD ROAD, WOLVERTON MILL, MILTON KEYNES MK12 5NW United Kingdom GB
1000076.recordDetails.addresses.0 1000076 registered CORNHILL HOUSE, 59/60 CORNHILL, LONDON, ENGLAND EC3V 3PD United Kingdom GB
1000077.recordDetails.addresses.0 1000077 registered 1ST FLOOR 11 FREEPORT OFFICE VILLAGE, CENTURY DRIVE, BRAINTREE, ESSEX CM77 8YG United Kingdom GB
1000078.recordDetails.addresses.0 1000078 registered 12 GREAT JUBILEE WHARF, 78 - 80 WAPPING WALL, LONDON E1W 3TH United Kingdom GB
1000079.recordDetails.addresses.0 1000079 registered 7 WAREHAM CLOSE, HOUNSLOW, ENGLAND TW3 3PX United Kingdom GB
100008.recordDetails.addresses.0 100008 registered 62 RUMBRIDGE STREET, TOTTON, SOUTHAMPTON SO40 9DS United Kingdom GB
1000080.recordDetails.addresses.0 1000080 registered 107-111 FLEET STREET, OFFICE 209, LONDON, ENGLAND EC4A 2AB United Kingdom GB
1000081.recordDetails.addresses.0 1000081 registered 110 HIGH HOLBORN, 5TH FLOOR, LONDON, ENGLAND WC1V 6JS United Kingdom GB
1000082.recordDetails.addresses.0 1000082 registered 29 DEVIZES ROAD, SWINDON, WILTSHIRE SN1 4BG United Kingdom GB
1000083.recordDetails.addresses.0 1000083 registered 1 PARKSHOT, RICHMOND, SURREY TW9 2RD United Kingdom GB
1000084.recordDetails.addresses.0 1000084 registered UNIT C3 SPELDHURST BUSINESS PARK LANGTON ROAD, SPELDHURST, TUNBRIDGE WELLS, KENT TN3 0AQ United Kingdom GB

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [entity_recordDetails_addresses] ( [_link] TEXT 
 , [_link_entity_statement] TEXT 
 , [type] TEXT 
 , [address] TEXT 
 , [postcode] TEXT 
 , [country_name] TEXT 
 , [country_code] TEXT 
 , PRIMARY KEY ([_link]) 
 , FOREIGN KEY ([_link_entity_statement]) REFERENCES [entity_statement]([_link]) 
   );
Powered by Datasette · Queries took 759.723ms