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