entity_addresses
5,142,408 rows sorted by type descending
This data as json, CSV (advanced)
_link | _link_entity_statement | type ▲ | address | country | postcode |
---|---|---|---|---|---|
0.addresses.0 | GREEN CLIFF LIMITED S.A. 0 | registered | C/O PATTON, MORENO & ASVAT, PANAMA | PA | 0801 |
1.addresses.0 | MERIDIAN RISK SOLUTIONS LIMITED 1 | registered | 71 Fenchurch Street, London | GB | EC3M 4BS |
2.addresses.0 | PRATT PENSION SCHEME 2 | registered | 25 BRIAR LANE, MANSFIELD | GB | NG18 3HS |
3.addresses.0 | IR ERHVERV A/S 3 | registered | ØSTERGADE 25, 1. TV, HERNING | DK | 7400 |
4.addresses.0 | NILI SSAS 4 | registered | C/O EMPOWERED PENSIONS LTD, EAST GRINSTEAD | GB | RH19 2LQ |
5.addresses.0 | THE AMERICAN MUSEUM IN BRITAIN 5 | registered | CLAVERTON MANOR, BATH | GB | BA2 7BD |
6.addresses.0 | DR D R K STREET DISCRETIONARY 6 | registered | TRINITY QUAY, BRISTOL | GB | BS2 0PT |
7.addresses.0 | THE BEEHIVE FUND 7 | registered | 440 STRAND, LONDON | GB | WC2R 0QS |
8.addresses.0 | INTERCOOL HELLAS ΑΝΩΝΥΜΗ ΕΤΑΙΡΕΙΑ 8 | registered | ANDREA PAPANDREOU AVE, PATRA | GR | 26500 |
9.addresses.0 | GLOVES4U LTD 9 | registered | MILL HOUSE, LEEDS | GB | LS18 5TN |
10.addresses.0 | CLAVIS SECURITIES PLC 10 | registered | 1 BARTHOLOMEW LANE, LONDON | GB | EC2N 2AX |
11.addresses.0 | SOUTHERN DERBYSHIRE LIFT PROJECT COMPANY (NO. 1) LIMITED 11 | registered | UNIT G1 ASH TREE COURT, NOTTINGHAM | GB | NG8 6PY |
12.addresses.0 | BACTA LIMITED 12 | registered | 29-30 ELY PLACE, LONDON | GB | EC1N 6TD |
13.addresses.0 | THE LISVANE TRUST 13 | registered | C/O HERITAGE TRUST LIMITED, ST PETER PORT | GG | GY1 2BB |
14.addresses.0 | THE NORMA HANNAH GROSS 2019 TRUST 14 | registered | APARTMENT 7, ALTRINCHAM | GB | WA14 2LG |
15.addresses.0 | THE NIGEL VERNON ROBINSON & RUTH MARY ROBINSON DISCRETIONARY TRUST 15 | registered | 1 WHITE HOUSE GARTH, SELBY | GB | YO8 6NY |
16.addresses.0 | BALTIC EXCHANGE LIMITED(THE) 16 | registered | 5th Floor, 77 Leadenhall Street, London | GB | EC3A 3DE |
17.addresses.0 | WILLIAM SIMON WILSON CHARITABLE TRUST 17 | registered | 24 ROYAL CIRCUS, EDINBURGH | GB | EH3 6SS |
18.addresses.0 | THE RUBENS FAMILY DISCRETIONARY TRUST 18 | registered | C/O RATHBONE INVESTMENT MANAGEMENT LIMITED, LIVERPOOL | GB | L3 1NW |
19.addresses.0 | FOCUS ESTATE FUND 19 | registered | 2C, PARC D'ACTIVITÉS, CAPELLEN | LU | L-8308 |
20.addresses.0 | NUTRICIA SA 20 | registered | HARDTURMSTRASSE 135, ZÜRICH | CH | 8005 |
21.addresses.0 | BAZZAROO TRUST 21 | registered | 416 LAKE ROAD, AUCKLAND | NZ | 0622 |
22.addresses.0 | THE WINDY RIDGE 2006 SETTLEMENT 22 | registered | C/O BRAMALL FAMILY (PTC) LIMITED, ST HELIER | JE | JE2 4QB |
23.addresses.0 | THE GORDON WADDELL WILL TRUST 23 | registered | 20 CURSITOR STREET, LONDON | GB | EC4A 1LT |
24.addresses.0 | THE JOHN ALLISTER KIRK WILL TRUST 24 | registered | GARRIS HOUSE, SKIPTON | GB | BD23 3NE |
25.addresses.0 | SFS HOLDING AB 25 | registered | 2 HANGARVÄGEN 6A, LANDVETTER, GÖTEBORG | SE | 438 70 |
26.addresses.0 | ELYSIA AMELIA AHEARNE TRUST 26 | registered | THE OLD RECTORY, CHERINGTON | GB | GL8 8SW |
27.addresses.0 | KAVCO (MODULAR SYSTEMS) LIMITED 27 | registered | 117 SPRINGBANK ROAD, LONDON | GB | SE13 6SS |
28.addresses.0 | BANCTRUST INVESTMENT BANK LIMITED 28 | registered | 110 BISHOPSGATE, LEVEL 24, LONDON | GB | EC2N 4AY |
29.addresses.0 | HONG KONG DOLLAR 29 | registered | C/O HSBC INVESTMENT FUNDS (HONG KONG) LIMITED, CENTRAL | HK | |
30.addresses.0 | ASELI LEON B.V 30 | registered | NARITAWEG 165, AMSTERDAM | NL | 1043BW |
31.addresses.0 | H. M. AND D. G. C. HOLDINGS LTD 31 | registered | ONE THE ESPLANADE, ST HELIER | JE | JE2 3QA |
32.addresses.0 | SCOTTISH MUTUAL INTERNATIONAL INVESTMENT FUND PLC - EURO MANAGED 95 SAFETY PLUS FUND 32 | registered | TANEY HALL, EGLINTON TERRACE, DUNDRUM, DUBLIN | IE | 14 |
33.addresses.0 | MRS NM WILLIAMSON FAMILY DISCRETIONARY SETTLEMENT 33 | registered | 551 LICHFIELD ROAD, SUTTON COLDFIELD | GB | B74 4EG |
34.addresses.0 | Arreskov Gods K/S 34 | registered | Karlsbjergvej 39, Broby | DK | 5672 |
35.addresses.0 | FARNCOMBE LIMITED 35 | registered | 168 CHURCH ROAD, HOVE | GB | BN3 2DJ |
36.addresses.0 | WILL OF EMMA MARJORIE BERYL MARTIN 36 | registered | C/O MAPUS-SMITH & LEMMON LLP, KINGS LYNN | GB | PE30 1HE |
37.addresses.0 | DENIS OLIVER LIMITED 37 | registered | AQUINAS HOUSE 63 WARSTONE LANE, BIRMINGHAM | GB | B18 6NG |
38.addresses.0 | BPI Group Hungary Korlátolt Felelősségű Társaság 38 | registered | Zsigmondy utca 42., Miskolc | HU | 3527 |
39.addresses.0 | C & A CUMBO (GARAGE & SALES) LTD (1989) RETIREMENT BENEFITS SCHEME 39 | registered | GREENACRES, LONGSDON | GB | ST9 9QH |
40.addresses.0 | AW21 INVESTMENTS LIMITED 40 | registered | 53 DYER STREET, CIRENCESTER | GB | GL7 2PP |
41.addresses.0 | HSBC FIXED TERM SERIES - HSBC FIXED TERM SERIES 129 41 | registered | C/O HSBC ASSET MANAGEMENT (INDIA) PRIVATE LIMITED, MUMBAI | IN | 400001 |
42.addresses.0 | MRS M I JOHNSTON'S GRANDCHILDREN'S SETTLEMENT - CRJ 42 | registered | GORTEEN LODGE, LONDONDERRY | GB | BT48 8JW |
43.addresses.0 | SPOOK ERECTION (NORTHERN) LIMITED 43 | registered | OLD RIGGS PADDOCK, PENRITH | GB | CA11 0BY |
44.addresses.0 | CAVENDISH CORPORATE INVESTMENTS PCC LIMITED RE CELL 338 44 | registered | PADDOCKS FARM, GOLDFORD ROAD, CRANBROOK | GB | TN17 3NW |
45.addresses.0 | ESTHER CEDAR CHARITABLE TRUST 45 | registered | STRONACHS LLP, ABERDEEN | GB | AB10 1FW |
46.addresses.0 | PARTNERS 4 LIFT (FUNDCO 2) LIMITED 46 | registered | 4TH FLOOR, LONDON | GB | W1J 7NJ |
47.addresses.0 | BNP PARIBAS FUND III N.V. - BNP PARIBAS SUSTAINABLE EUROPE INDEX FUND 47 | registered | HERENGRACHT 595, AMSTERDAM | NL | 1017CE |
48.addresses.0 | H G LITTLEY WILL TRUST 48 | registered | C/O STREETER MARSHALL SOLICITORS, CROYDON | GB | CR9 2UU |
49.addresses.0 | THEO DOUGLAS DAMPNEY 1997 DISCRETIONARY SETTLEMENT 49 | registered | PARLEY MANOR, PARLEY GREEN LANE, CHRISTCHURCH | GB | BH23 6BB |
50.addresses.0 | THE D A SEARLE 1971 SETTLEMENT 50 | registered | 14 CLARENDON ROAD, LONDON | GB | W11 4JB |
51.addresses.0 | LONDON BOROUGH OF HAMMERSMITH & FULHAM PENSION FUND 51 | registered | TOWN HALL, LONDON | GB | W6 9JU |
52.addresses.0 | PENINSULA GLOBAL MARKETS LIMITED 52 | registered | 843 FINCHLEY ROAD, LONDON | GB | NW11 8NA |
53.addresses.0 | VINCENT KNIGHT PENSION SCHEME 53 | registered | 18 THE FAIRWAY, ROWLANDS CASTLE | GB | PO9 6AQ |
54.addresses.0 | HARTT ESTATE COMPANY LIMITED 54 | registered | Petit Coin, La Rue des Vaux De L'Eglise, St Martin | JE | JE3 6BF |
55.addresses.0 | JOHN NOON DISCRETIONARY WILL TRUST 55 | registered | 9 ALDERSMEAD ROAD, BECKENHAM | GB | BR3 1NA |
56.addresses.0 | "The D.H. Baxendale Trust" Dated 14 July 2004 56 | registered | The firs, Sunningdale | GB | SL5 0NJ |
57.addresses.0 | NOVIA GLOBAL LIMITED 57 | registered | CAMBRIDGE HOUSE, BATH | GB | BA1 1JS |
58.addresses.0 | INTERAGRO (UK) LIMITED 58 | registered | THORLEY WASH BARN LONDON ROAD, BISHOP'S STORTFORD | GB | CM23 4AT |
59.addresses.0 | ANSDELL UNITARIAN CHURCH 59 | registered | 47 MEYLER AVENUE, BLACKPOOL | GB | FY3 7DX |
60.addresses.0 | THE PETER MEYER CHARITABLE TRUST 60 | registered | 13 CHELSEA SQUARE, LONDON | GB | SW3 6LF |
61.addresses.0 | ΜΠΑΜΠΗΣ ΒΩΒΟΣ ΔΙΕΘΝΗΣ ΤΕΧΝΙΚΗ ΑΝΩΝΥΜΗ ΕΤΑΙΡΙΑ 61 | registered | 32, KIFISSIAS AVENUE, MAROUSSI | GR | 15125 |
62.addresses.0 | ALLIED LONDON ONE LIMITED 62 | registered | C/O ALLIED LONDON, MANCHESTER | GB | M3 4AP |
63.addresses.0 | EQC PRIVATE MARKETS SAC FUND II LTD - EQC BIOTECH SELY S FUND 63 | registered | 5TH FLOOR, ANDREW’S PLACE, HAMILTON | BM | HM12 |
64.addresses.0 | CLSIG HOLDINGS LLC 64 | registered | C/O THE CORPORATION TRUST COMPANY, WILMINGTON | US | 19801 |
65.addresses.0 | THE MARA TRUST FUND 65 | registered | 14 RAVENHURST DRIVE, BIRMINGHAM | GB | B43 7RS |
66.addresses.0 | POBL HOMES AND COMMUNITIES LIMITED 66 | registered | EXCHANGE HOUSE, NEWPORT | GB | NP20 1AA |
67.addresses.0 | RMMC GROUP LTD. 67 | registered | VANTERPOOL PLAZA, 2ND FLOOR, ROAD TOWN | VG | VG1110 |
68.addresses.0 | PYKERLEY SSAS 68 | registered | C/O POOL HOUSE ADMINISTRATION SERVICES LIMITED, LICHFIELD | GB | WS13 6AA |
69.addresses.0 | LIAM ASPDEN & CO. LIMITED 69 | registered | DALE HOUSE, LANCASTER | GB | LA6 1JH |
70.addresses.0 | JOAN CECILIA MARY PHILLIPS WILL TRUST 70 | registered | C/O DOLMANS SOLICITORS, CARDIFF | GB | CF10 3AG |
71.addresses.0 | PINCO 2223 LIMITED 71 | registered | SCEPTRE HOUSE, PRESTON | GB | PR5 6AW |
72.addresses.0 | KRAMER CHARITABLE TRUST 72 | registered | 14 DALKEITH GROVE, STANMORE | GB | HA7 4SG |
73.addresses.0 | THE BOXWAY TRUST 73 | registered | BLEICHERWEG 74, ZURICH | CH | 8027 |
74.addresses.0 | THE HOOLEY FAMILY DISCRETIONARY TRUST 2018 74 | registered | 10 PELLATT ROAD, LONDON | GB | SE22 9JA |
75.addresses.0 | EVA ELIZABETH GODDARD AND OTHERS SETTLEMENT 75 | registered | 4 THE LIMES, SAXMUNDHAM | GB | IP17 1TD |
76.addresses.0 | HELENE DARROZE COOKING CONSULTANT LIMITED 76 | registered | LYNWOOD HOUSE, CROFTON ROAD, ORPINGTON | GB | BR6 8QE |
77.addresses.0 | DR A J BURNFIELD VOLUNTARY SE 77 | registered | C/O PARIS SMITH & RANDALL, SOUTHAMPTON | GB | SO15 2AE |
78.addresses.0 | BROWNLOW LODGE 2131 GEORGE DAVIES FUND 78 | registered | C/O RATHBONE INVESTMENT MANAGEMENT LIMITED, LIVERPOOL | GB | L3 1NW |
79.addresses.0 | ERNEST WILLIAM BLAKE DECEASED 79 | registered | 12 HARDWICK STREET, BUXTON | GB | SK17 6BN |
80.addresses.0 | THE FRANK DIXON TRUST 80 | registered | 21, TORRINGTON ROAD, BERKHAMSTED | GB | HP4 3DB |
81.addresses.0 | RICHARD EDUCATION FUND 81 | registered | ORCHARD HOUSE, NEW ROAD, WATFORD | GB | WD25 8ED |
82.addresses.0 | THE STELJES LTD EXECUTIVE RETIREMENT BENEFITS SCHEME 82 | registered | HILLFIELDS FARM, BERKS | GB | RG8 9PE |
83.addresses.0 | THE MRS F A HAYNES 1991 DISCRETIONARY SETTLEMENT 83 | registered | C/O TALBOTS LAW LTD, STOURBRIDGE | GB | DY8 1QH |
84.addresses.0 | MARSHALL FAMILY INVESTMENTS LIMITED 84 | registered | C/O GEOFFREY LEAVER SOLICITORS LLP, CENTRAL MILTON KEYNES | GB | MK9 1DR |
85.addresses.0 | BRIDGEPOINT CREDIT II "B" LP 85 | registered | C/O BRIDGEPOINT, LONDON | GB | W1U 1FB |
86.addresses.0 | MARSHALL WACE LONG STRATEGIES ICAV - MW INDIA LONG-ONLY FUND 86 | registered | 32 MOLESWORTH STREET, DUBLIN | IE | D02Y512 |
87.addresses.0 | THE BALSDON TRUST 87 | registered | 11 BRAY ROAD, HOLSWORTHY | GB | EX22 6FJ |
88.addresses.0 | 法國巴黎服務(香港)有限公司 88 | registered | 60-63/F., TWO INTERNATIONAL FINANCE CENTRE, HONG KONG | HK | |
89.addresses.0 | LYNN HUGHES DISCRETIONARY SETTLEMENT TRUST 89 | registered | 18-20 Old Bridge, Haverfordwest | GB | SA61 2ET |
90.addresses.0 | ARAMIS MIDCO 3 LIMITED 90 | registered | NORTH WEST WING BUSH HOUSE, LONDON | GB | WC2B 4PJ |
91.addresses.0 | TELENZETE LIMITED 91 | registered | 21 VASSIL MICHAELIDIS, LIMASSOL | CY | 3026 |
92.addresses.0 | HILLTOP ASSETS LIMITED 92 | registered | SARNIA HOUSE, ST PETER PORT | GG | GY1 4NA |
93.addresses.0 | BERNARD HOLLINGSWORTH SETTLEMENT DATED 4 APRIL 1996 93 | registered | LINDEN HOUSE, 2 THE NIGHTINGALES, ASHFORD | GB | TN27 8HN |
94.addresses.0 | PAN-EUROPEAN INFRASTRUCTURE FUND LP 94 | registered | 26 NEW STREET, ST HELIER | JE | JE2 3RA |
95.addresses.0 | ARCHDIOCESE OF LIVERPOOL 95 | registered | LIVERPOOL ARCHDIOCESAN OFFICE, LIVERPOOL | GB | L17 1AA |
96.addresses.0 | THE LUCIE SMITHSON WILL TRUST 96 | registered | THE OLD VICARAGE, SPILSBY | GB | PE23 4BX |
97.addresses.0 | ANTHRACITE 97 | registered | C/O MONCEAU ASSET MANAGEMENT, PARIS | FR | 75008 |
98.addresses.0 | INFO BOOM LIMITED 98 | registered | P.O. BOX 957, ROAD TOWN | VG | VG1110 |
99.addresses.0 | AMUNDI PROGETTO INCOME REALE 2027 99 | registered | C/O AMUNDI SGR S.P.A, MILAN | IT | 20121 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [entity_addresses] ( [_link] TEXT , [_link_entity_statement] TEXT , [type] TEXT , [address] TEXT , [country] TEXT , [postcode] TEXT , PRIMARY KEY ([_link]) , FOREIGN KEY ([_link_entity_statement]) REFERENCES [entity_statement]([_link]) );