entity_addresses
5,142,408 rows sorted by postcode
This data as json, CSV (advanced)
_link | _link_entity_statement | type | address | country | postcode ▼ |
---|---|---|---|---|---|
178902.addresses.0 | REASEGURADORA DELTA INTERNACIONAL, S.A 178902 | registered | CALLE ISAAC HANONO MISSRI Y BOULEVARD PUNTA PACIFICA, PANAMA | PA | |
178902.addresses.1 | REASEGURADORA DELTA INTERNACIONAL, S.A 178902 | business | CALLE ISAAC HANONO MISSRI Y BOULEVARD PUNTA PACIFICA, PANAMA | PA | |
1789408.addresses.0 | BANCA TRANSILVANIA S.A. 1789408 | registered | VIA GEORGE BARITIU, 8, CLUJ- NAPOCA | RO | |
1789408.addresses.1 | BANCA TRANSILVANIA S.A. 1789408 | business | VIA GEORGE BARITIU, 8, CLUJ- NAPOCA | RO | |
178980.addresses.0 | KB Securities Hong Kong Limited 178980 | registered | Room 1105, 11/Fl., Central Plaza, 18 Harbour Road, Hongkong | HK | |
178980.addresses.1 | KB Securities Hong Kong Limited 178980 | business | Room 1105, 11/Fl., Central Plaza, 18 Harbour Road, Hongkong | HK | |
179046.addresses.0 | CHINAAMC RMB MONEY MARKET ETF 179046 | registered | C/O CHINA ASSET MANAGEMENT (HONG KONG) LIMITED, CENTRAL | HK | |
179046.addresses.1 | CHINAAMC RMB MONEY MARKET ETF 179046 | business | C/O CHINA ASSET MANAGEMENT (HONG KONG) LIMITED, CENTRAL | HK | |
179067.addresses.0 | SAVILLS ASIA PACIFIC LIMITED 179067 | registered | 23RD FLOOR, TWO EXCHANGE SQUARE, CENTRAL | HK | |
179067.addresses.1 | SAVILLS ASIA PACIFIC LIMITED 179067 | business | 23RD FLOOR, TWO EXCHANGE SQUARE, CENTRAL | HK | |
179072.addresses.0 | LANDSCROFT LIMITED 179072 | registered | SUITE E2, UNION COURT BUILDING, NASSAU | BS | |
179143.addresses.0 | AXA BALANCED FUND 179143 | registered | C/O AXA INVESTMENT MANAGERS ASIA LIMITED, HONG KONG | HK | |
179143.addresses.1 | AXA BALANCED FUND 179143 | business | C/O AXA INVESTMENT MANAGERS ASIA LIMITED, HONG KONG | HK | |
179159.addresses.0 | OSLO ASSET MANAGEMENT FUND PLC 179159 | registered | ORMONDE HOUSE, 12/13 LEESON STREET LOWER, DUBLIN | IE | |
179160.addresses.0 | BRAMBLE INTERNATIONAL LIMITED 179160 | registered | OLIAJI TRADE CENTRE, FRANCIS RACHER STREET, MAHE | SC | |
179160.addresses.1 | BRAMBLE INTERNATIONAL LIMITED 179160 | business | OLIAJI TRADE CENTRE, FRANCIS RACHER STREET, MAHE | SC | |
179178.addresses.0 | Barings Global Funds - Barings Global Multi Asset Income Fund 179178 | registered | C/O Baring Asset Management (Asia) Limited, Central and Western District | HK | |
179178.addresses.1 | Barings Global Funds - Barings Global Multi Asset Income Fund 179178 | business | C/O Baring Asset Management (Asia) Limited, Central and Western District | HK | |
179252.addresses.0 | THE HELEN MARY WALKER DISCRETIONARY TRUST 179252 | registered | WILSON BROWNE, KETTERING | GB | |
179252.addresses.1 | THE HELEN MARY WALKER DISCRETIONARY TRUST 179252 | business | WILSON BROWNE, KETTERING | GB | |
179388.addresses.0 | ام اي اتش للذهب والمجوهرات ش.ذ.م.م 179388 | registered | محل رقم M037 /M038 ملك الشيخ محمد بن خليفه بن سعيد آل مكتوم -ديرة -الراس, ديرة | AE | |
179388.addresses.1 | ام اي اتش للذهب والمجوهرات ش.ذ.م.م 179388 | business | محل رقم M037 /M038 ملك الشيخ محمد بن خليفه بن سعيد آل مكتوم -ديرة -الراس, ديرة | AE | |
179415.addresses.0 | VEMRON BUSINESS LTD. 179415 | registered | C/O MMG BAHAMAS LTD, NASSAU | BS | |
179415.addresses.1 | VEMRON BUSINESS LTD. 179415 | business | C/O MMG BAHAMAS LTD, NASSAU | BS | |
179440.addresses.0 | BANCO BAI CABO VERDE S.A. 179440 | registered | EDIFÍCIO BAICENTER, PRAIA | CV | |
179440.addresses.1 | BANCO BAI CABO VERDE S.A. 179440 | business | EDIFÍCIO BAICENTER, PRAIA | CV | |
179445.addresses.0 | THE DIMOVA LEGACY TRUST 179445 | registered | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
179445.addresses.1 | THE DIMOVA LEGACY TRUST 179445 | business | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
1794482.addresses.0 | RCI BANQUE S.A. 1794482 | registered | RUE D'UZES, 15, PARIGI | FR | |
1794482.addresses.1 | RCI BANQUE S.A. 1794482 | business | RUE D'UZES, 15, PARIGI | FR | |
179465.addresses.0 | DL GOLDEN TIME TRADING LIMITED 179465 | registered | RM910, 9/F HOLLYWOOD PLAZA, HONG KONG | HK | |
179527.addresses.0 | ACQUIRE ART INTERNATIONAL LIMITED 179527 | registered | THE BLACK CHURCH, DUBLIN | IE | |
179527.addresses.1 | ACQUIRE ART INTERNATIONAL LIMITED 179527 | business | WEATHERVIEW HOUSE, MANOR KILBRIDE | IE | |
179556.addresses.0 | LUCKY CLOVER INVESTMENTS LIMITED 179556 | registered | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
179556.addresses.1 | LUCKY CLOVER INVESTMENTS LIMITED 179556 | business | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
179563.addresses.0 | AVITUS INC. 179563 | registered | 35 New Road, Belize City | BZ | |
179563.addresses.1 | AVITUS INC. 179563 | business | 35 New Road, Belize City | BZ | |
179570.addresses.0 | LAS FINANCE LIMITED 179570 | registered | BELIZE MARINA TOWERS, SUITE 303, NEWTOWN BARRACKS, BELIZE CITY | BZ | |
179570.addresses.1 | LAS FINANCE LIMITED 179570 | business | BELIZE MARINA TOWERS, SUITE 303, NEWTOWN BARRACKS, BELIZE CITY | BZ | |
179572.addresses.0 | TABAH TRADING LLC 179572 | registered | SHARJAH MEDIA CITY, SHARJAH | AE | |
179572.addresses.1 | TABAH TRADING LLC 179572 | business | SHARJAH MEDIA CITY, SHARJAH | AE | |
179581.addresses.0 | SPECTRUM CAPITAL INTERNATIONAL LTD. 179581 | registered | NEW HORIZON BUILDING, GROUND FLOOR, BELIZE CITY | BZ | |
179581.addresses.1 | SPECTRUM CAPITAL INTERNATIONAL LTD. 179581 | business | NEW HORIZON BUILDING, GROUND FLOOR, BELIZE CITY | BZ | |
179612.addresses.0 | بوليون ستريت لتجارة الذهب ش.ذ.م.م 179612 | registered | OFFICE NO. 10, DUBAI | AE | |
179612.addresses.1 | بوليون ستريت لتجارة الذهب ش.ذ.م.م 179612 | business | OFFICE NO. 10, DUBAI | AE | |
179676.addresses.0 | بيومرك كوربوريشن م م ح 179676 | registered | P.O. BOX NO:261285, DUBAI | AE | |
179676.addresses.1 | بيومرك كوربوريشن م م ح 179676 | business | P.O. BOX NO:261285, DUBAI | AE | |
179762.addresses.0 | EAGLE GM LIMITED 179762 | registered | 14TH FLOOR,CIVIC TOWERS PLOTS GA & GI OZUMBA MBADIWE AVENUE, LAGOS | NG | |
179762.addresses.1 | EAGLE GM LIMITED 179762 | business | 14TH FLOOR,CIVIC TOWERS PLOTS GA & GI OZUMBA MBADIWE AVENUE, LAGOS | NG | |
179795.addresses.0 | HYDRA MARKETS LLC 179795 | registered | 7A BAKHTRIONI STREET, TBILISI | GE | |
179795.addresses.1 | HYDRA MARKETS LLC 179795 | business | 7A BAKHTRIONI STREET, TBILISI | GE | |
179804.addresses.0 | شركة كوني ميدل ايست (ذ.م.م) 179804 | registered | P.O. BOX 21474, DUBAI | AE | |
179804.addresses.1 | شركة كوني ميدل ايست (ذ.م.م) 179804 | business | U-BORA TOWER C/O AL ABRAJ STR. & AL KHALEEJ STR, DUBAI | AE | |
179830.addresses.0 | 通力電梯(香港)有限公司 179830 | registered | 2120 LEIGHTON CENTRE, CAUSEWAY BAY | HK | |
179830.addresses.1 | 通力電梯(香港)有限公司 179830 | business | 2120 LEIGHTON CENTRE, CAUSEWAY BAY | HK | |
179876.addresses.0 | PLANTATION HOLDINGS LIMITED 179876 | registered | C/O LISCR TRUST COMPANY, MONORVIA | LR | |
179876.addresses.1 | PLANTATION HOLDINGS LIMITED 179876 | business | C/O LISCR TRUST COMPANY, MONROVIA | LR | |
179943.addresses.0 | 恒生物業管理有限公司 179943 | registered | 83 DES VOEUX ROAD, CENTRAL | HK | |
179968.addresses.0 | CAPITONIA CONSULTANCY FZ LLE 179968 | registered | FUJAIRAH - CREATIVE TOWER, FUJAIRAH | AE | |
179968.addresses.1 | CAPITONIA CONSULTANCY FZ LLE 179968 | business | FUJAIRAH - CREATIVE TOWER, FUJAIRAH | AE | |
180013.addresses.0 | SETTLEMENT FOR THE BENEFIT OF IAN KYNASTON MAINWARING 180013 | registered | ELLESMERE, SPUN HILL, SALOP | GB | |
180013.addresses.1 | SETTLEMENT FOR THE BENEFIT OF IAN KYNASTON MAINWARING 180013 | business | ELLESMERE, SPUN HILL, SALOP | GB | |
180028.addresses.0 | ANGLOGOLD ASHANTI (GHANA) LIMITED 180028 | registered | GOLD HOUSE, ACCRA | GH | |
180028.addresses.1 | ANGLOGOLD ASHANTI (GHANA) LIMITED 180028 | business | GOLD HOUSE, ACCRA | GH | |
180036.addresses.0 | HSBC GLOBAL FUND SERVICES LIMITED 180036 | registered | 1 QUEEN'S ROAD CENTRAL, CENTRAL | HK | |
180038.addresses.0 | Estrellas Holdings Ltd. 180038 | registered | P.O. Box 2140, Belize City | BZ | |
180038.addresses.1 | Estrellas Holdings Ltd. 180038 | business | P.O. Box 2140, Belize City | BZ | |
180171.addresses.1 | CLAMFORD DEVELOPMENTS INC. 180171 | business | 24/F LEIGHTON CENTRE, 77 LEIGHTON ROAD, CAUSEWAY BAY | HK | |
1802468.addresses.1 | PPS EU S.A. 1802468 | business | BOULEVARD DU SOUVERAIN 165, BOITE 9, AUDERGHEM | BE | |
1802545.addresses.0 | EFG BANK (LUXEMBOURG) S.A. 1802545 | registered | GRAND RUE, 56, LUSSEMBURGO | LU | |
1802545.addresses.1 | EFG BANK (LUXEMBOURG) S.A. 1802545 | business | GRAND RUE, 56, LUSSEMBURGO | LU | |
180324.addresses.0 | JOSEPH SCICLUNA INVESTMENT SERVICES LIMITED 180324 | registered | BELLA VISTA COURT, LEVEL 3, VICTORIA | MT | |
180324.addresses.1 | JOSEPH SCICLUNA INVESTMENT SERVICES LIMITED 180324 | business | BELLA VISTA COURT, LEVEL 3, VICTORIA | MT | |
180446.addresses.0 | ORIENTAL GENERAL TRADING INC. 180446 | registered | 67TH STREET A EAST, VIA ESPANA, PANAMA | PA | |
180446.addresses.1 | ORIENTAL GENERAL TRADING INC. 180446 | business | 67TH STREET A EAST, VIA ESPANA, PANAMA | PA | |
180521.addresses.0 | فالينسي إنترناشيونال م.د.م.س 180521 | registered | UNIT NO: R30-17, REEF TOWER, PLOT NO: JLT-PH2-O1A, JUMEIRAH LAKES TOWERS, DUBAI | AE | |
180521.addresses.1 | فالينسي إنترناشيونال م.د.م.س 180521 | business | JUMEIRAH LAKES TOWERS, DUBAI | AE | |
180547.addresses.0 | LEMAN SOLICITORS 180547 | registered | 8-34 PERCY PLACE, DUBLIN | IE | |
180547.addresses.1 | LEMAN SOLICITORS 180547 | business | 8-34 PERCY PLACE, DUBLIN | IE | |
180557.addresses.0 | AURA TRADITION FOUNDATION 180557 | registered | CALLE LAS ABEJITAS, #41, NUEVO PAITILLA, PANAMA | PA | |
180557.addresses.1 | AURA TRADITION FOUNDATION 180557 | business | CALLE LAS ABEJITAS, #41, NUEVO PAITILLA, PANAMA | PA | |
180573.addresses.0 | 金道貴金屬有限公司 180573 | registered | 28/F, TOWER 2, THE GATEWAY, HARBOUR | HK | |
180573.addresses.1 | 金道貴金屬有限公司 180573 | business | 28/F, TOWER 2, THE GATEWAY, HARBOUR | HK | |
180619.addresses.0 | دايركت تكنولوجي دي دبليو سي ش.ذ.م.م 180619 | registered | DWC BUSINESS CENTER, BUILDING A3, DUBAI | AE | |
180619.addresses.1 | دايركت تكنولوجي دي دبليو سي ش.ذ.م.م 180619 | business | DWC BUSINESS CENTER, BUILDING A3, DUBAI | AE | |
180632.addresses.0 | GROUP METALS BUSINESS LIMITED 180632 | registered | P.O. BOX 58562, DUBAI | AE | |
180632.addresses.1 | GROUP METALS BUSINESS LIMITED 180632 | business | FORTUNE EXECUTIVE TOWER, DUBAI | AE | |
180722.addresses.1 | ABC-CA CHINA NEW ENERGY 180722 | business | C/O AMUNDI HONG KONG LIMITED, HONG KONG | HK | |
180785.addresses.0 | PPA LIMITED 180785 | registered | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
180785.addresses.1 | PPA LIMITED 180785 | business | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
1807947.addresses.0 | BAOBAB FRUIT COMPANY SENEGAL SARL 1807947 | registered | Touba Peycouk, Thies | SN | |
1807947.addresses.1 | BAOBAB FRUIT COMPANY SENEGAL SARL 1807947 | business | Touba Peycouk, Thies | SN | |
180798.addresses.0 | LOGOS TECHNOLOGIES (HK) LIMITED 180798 | registered | 20/F, ONE IFC, CENTRAL | HK | |
180798.addresses.1 | LOGOS TECHNOLOGIES (HK) LIMITED 180798 | business | 20/F, ONE IFC, CENTRAL | HK | |
180859.addresses.0 | ROSE VENTURES LIMITED 180859 | registered | C/O MORGAN & MORGAN TRUST CORPORATION BELIZE LIMITED, BELIZE CITY | BZ | |
180879.addresses.0 | ثرياسي كونسولتانسي م.م.ح 180879 | registered | SFFO0377, RAS AL KHAIMAH | AE | |
180879.addresses.1 | ثرياسي كونسولتانسي م.م.ح 180879 | business | SFFO0377, RAS AL KHAIMAH | AE | |
1809017.addresses.0 | SOMPO JAPAN NIPPONKOA INSURANCE COMPANY OF EUROPE LIMITED 1809017 | registered | 1ST FLOOR, DEVONSHIRE SQUARE, 6, LONDRA | GB | |
1809017.addresses.1 | SOMPO JAPAN NIPPONKOA INSURANCE COMPANY OF EUROPE LIMITED 1809017 | business | 1ST FLOOR, DEVONSHIRE SQUARE, 6, LONDRA | GB | |
180964.addresses.1 | ASIA PACIFIC PROMOTION LIMITED 180964 | business | 28TH FLOOR, INFINITUS PLAZA, HONG KONG | HK |
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]) );