entity_addresses
5,142,408 rows sorted by postcode
This data as json, CSV (advanced)
_link | _link_entity_statement | type | address | country | postcode ▼ |
---|---|---|---|---|---|
29.addresses.0 | HONG KONG DOLLAR 29 | registered | C/O HSBC INVESTMENT FUNDS (HONG KONG) LIMITED, CENTRAL | HK | |
29.addresses.1 | HONG KONG DOLLAR 29 | business | C/O HSBC INVESTMENT FUNDS (HONG KONG) LIMITED, CENTRAL | HK | |
86.addresses.1 | MARSHALL WACE LONG STRATEGIES ICAV - MW INDIA LONG-ONLY FUND 86 | business | C/O MARSHALL WACE ASIA LIMITED, CENTRAL | HK | |
88.addresses.0 | 法國巴黎服務(香港)有限公司 88 | registered | 60-63/F., TWO INTERNATIONAL FINANCE CENTRE, HONG KONG | HK | |
88.addresses.1 | 法國巴黎服務(香港)有限公司 88 | business | 60-63/F., TWO INTERNATIONAL FINANCE CENTRE, HONG KONG | HK | |
98.addresses.1 | INFO BOOM LIMITED 98 | business | UNIT B, 9/F, SILVERCORP INTERNATIONAL TOWER, KOWLOON | HK | |
126.addresses.0 | سلع التاج - ش 126 | registered | 1C منطقة عجمان الحرة - مبنى, الحرة | AE | |
126.addresses.1 | سلع التاج - ش 126 | business | 1C منطقة عجمان الحرة - مبنى, الحرة | AE | |
156.addresses.0 | WING LUNG BULLION LIMITED 156 | registered | 391-407, JAFFE ROAD, HONG KONG | HK | |
156.addresses.1 | WING LUNG BULLION LIMITED 156 | business | 391-407, JAFFE ROAD, HONG KONG | HK | |
183.addresses.1 | SYWEST INVESTMENT LTD. 183 | business | 112 NEW HENRY HOUSE, 11/F, CENTRAL | HK | |
205.addresses.0 | MACSON INTERNATIONAL LIMITED 205 | registered | 59-63/F TWO INTERNATIONAL FINANCE CENTRE, HONG KONG | HK | |
205.addresses.1 | MACSON INTERNATIONAL LIMITED 205 | business | 59-63/F TWO INTERNATIONAL FINANCE CENTRE, HONG KONG | HK | |
215.addresses.1 | CONCORD ASSET MANAGMENT LIMITED 215 | business | 2310 DOMINION CENTRE, WAN CHAI | HK | |
238.addresses.1 | บริษัท หลักทรัพย์ ซี แอล เอส เอ (ประเทศไทย) จำกัด 238 | business | C/O CLSA LIMITED, HONG KONG | HK | |
242.addresses.0 | MEDITERRANEAN SHIPPING SERVICES LTD. 242 | registered | SUITE 102, GROUND FLOOR, BELIZE CITY | BZ | |
242.addresses.1 | MEDITERRANEAN SHIPPING SERVICES LTD. 242 | business | SUITE 102, GROUND FLOOR, BELIZE CITY | BZ | |
272.addresses.0 | QUILLA INVESTMENTS HOLDING INC. 272 | registered | MONT FLEURI, MAHE | SC | |
272.addresses.1 | QUILLA INVESTMENTS HOLDING INC. 272 | business | MONT FLEURI, MAHE | SC | |
324.addresses.0 | SUPERB INTERNATIONAL OPERATIONS LTD. 324 | registered | SUITE 5, HORSFORD'S BUSINESS CENTRE, CHARLESTOWN | KN | |
324.addresses.1 | SUPERB INTERNATIONAL OPERATIONS LTD. 324 | business | SUITE 5, HORSFORD'S BUSINESS CENTRE, CHARLESTOWN | KN | |
334.addresses.0 | MARINE VISIO INC. 334 | registered | TENANCY 10, MARINA HOUSE, EDEN ISLAND, MAHE | SC | |
334.addresses.1 | MARINE VISIO INC. 334 | business | TENANCY 10, MARINA HOUSE, EDEN ISLAND, MAHE | SC | |
353.addresses.0 | NEW PROPITIOUS DEVELOPMENT LIMITED 353 | registered | Caves Corporate Center, Building No. 2, NASSAU | BS | |
353.addresses.1 | NEW PROPITIOUS DEVELOPMENT LIMITED 353 | business | Caves Corporate Center, Building No. 2, NASSAU | BS | |
358.addresses.0 | FUTURA FUNDS SICAV P.L.C. - GAMMA FUND 358 | registered | CENTRAL NORTH BUSINESS CENTRE, LEVEL 1, SQAQ IL-FAWWARA, SLIEMA | MT | |
358.addresses.1 | FUTURA FUNDS SICAV P.L.C. - GAMMA FUND 358 | business | C/O APEX FUND SERVICES MALTA LIMITED, SLIEMA | MT | |
362.addresses.0 | JTC TRUSTEES LIMITED AS TRUSTEE OF THE STEPHEN MALLONEY SUB-TRUST 362 | registered | C/O JTC TRUSTEES LTD, ST. HELIER | JE | |
362.addresses.1 | JTC TRUSTEES LIMITED AS TRUSTEE OF THE STEPHEN MALLONEY SUB-TRUST 362 | business | C/O JTC TRUSTEES LTD, ST. HELIER | JE | |
368.addresses.0 | COMORORO LIMITED 368 | registered | 102 AARTI CHAMBERS, VICTORIA | SC | |
368.addresses.1 | COMORORO LIMITED 368 | business | 102 AARTI CHAMBERS, VICTORIA | SC | |
438.addresses.0 | QF TECHNOLOGIES LIMITED 438 | registered | HUNKINS WATERFRONT PLAZA, SUITE 556, CHARLESTOWN | KN | |
438.addresses.1 | QF TECHNOLOGIES LIMITED 438 | business | HUNKINS WATERFRONT PLAZA, SUITE 556, CHARLESTOWN | KN | |
512.addresses.0 | ANDRIANI LIMITED 512 | registered | CITIBANK BUILDING, NASSAU | BS | |
512.addresses.1 | ANDRIANI LIMITED 512 | business | CITIBANK BUILDING, NASSAU | BS | |
538.addresses.0 | RSBMMII LIMITED 538 | registered | 2ND FLOOR, YELLOWMAN & SONS BUILDING, GRAND TURK | TC | |
538.addresses.1 | RSBMMII LIMITED 538 | business | 2ND FLOOR, YELLOWMAN & SONS BUILDING, GRAND TURK | TC | |
607.addresses.0 | SOUTHERN SIGNS (CORK) LIMITED 607 | registered | 85 DOUGLAS STREET, CORK | IE | |
607.addresses.1 | SOUTHERN SIGNS (CORK) LIMITED 607 | business | 85, DOUGLAS STREET,, CORK | IE | |
642.addresses.0 | CAPITAL FOUR - STRATEGIC CREDIT FUND II 642 | registered | 32 MOLESWORTH STREET, DUBLIN | IE | |
642.addresses.1 | CAPITAL FOUR - STRATEGIC CREDIT FUND II 642 | business | C/O B-FLEXION FUND MANAGEMENT (IRELAND) LIMITED, DUBLIN | IE | |
664.addresses.0 | S J WHITEHORN SETTLEMENT 664 | registered | YEW HEDGES, NEWBURY | GB | |
710.addresses.0 | ADTEC AERAUTO LIMITED 710 | registered | GIBBSTOWN, NAVAN | IE | |
710.addresses.1 | ADTEC AERAUTO LIMITED 710 | business | GIBBSTOWN, NAVAN | IE | |
720.addresses.0 | SUN GROWTH SECURITIES LIMITED 720 | registered | UNIT 2901-05, 29TH FLOOR, HONG KONG | HK | |
720.addresses.1 | SUN GROWTH SECURITIES LIMITED 720 | business | UNIT 2901-05, 29TH FLOOR, HONG KONG | HK | |
792.addresses.0 | CASTRO INVESTMENTS LTD 792 | registered | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
814.addresses.0 | YERIEL BUSINESS GROUP LTD. 814 | registered | SUITE 1, SECOND FLOOR, SOUND & VISION HOUSE, FRANCIS RACHEL STR., VICTORIA | SC | |
814.addresses.1 | YERIEL BUSINESS GROUP LTD. 814 | business | SUITE 1, SECOND FLOOR, SOUND & VISION HOUSE, FRANCIS RACHEL STR., VICTORIA | SC | |
816.addresses.0 | MRS L HIGGINS DECEASED HIGG 2 816 | registered | DX 17207, HEREFORD | GB | |
816.addresses.1 | MRS L HIGGINS DECEASED HIGG 2 816 | business | DX 17207, HEREFORD | GB | |
840.addresses.0 | SAINT JOSEPH’S SOCIETY FOR FOREIGN MISSIONS 840 | registered | SAINT JOSEPH’S HOUSE, RATHGAR | IE | |
840.addresses.1 | SAINT JOSEPH’S SOCIETY FOR FOREIGN MISSIONS 840 | business | C/O MERRION CAPITAL INVESTMENT MANAGERS LIMITED, RATHGAR | IE | |
859.addresses.0 | نيرا كابيتال م.د.م.س 859 | registered | UNIT NO: 2908, DMCC BUSINESS CENTRE, LEVEL NO 1, DUBAI | AE | |
859.addresses.1 | نيرا كابيتال م.د.م.س 859 | business | UNIT NO: 2908, DMCC BUSINESS CENTRE, LEVEL NO 1, DUBAI | AE | |
916.addresses.0 | JOAN ELLEN MARGARET COKER WILL TRUST 916 | registered | 124 RISCA ROAD, NEWPORT | GB | |
916.addresses.1 | JOAN ELLEN MARGARET COKER WILL TRUST 916 | business | 124 RISCA ROAD, NEWPORT | GB | |
939.addresses.0 | OMNIX ASIA FUND LIMITED OFC 939 | registered | UNIT 16, 1/F., NEW HENRY HOUSE, HONG KONG | HK | |
939.addresses.1 | OMNIX ASIA FUND LIMITED OFC 939 | business | UNIT 16, 1/F., NEW HENRY HOUSE, HONG KONG | HK | |
967.addresses.0 | TOP HONOR HOLDING LTD. 967 | registered | BAHAMAS FINANCIAL CENTRE, NASSAU | BS | |
967.addresses.1 | TOP HONOR HOLDING LTD. 967 | business | BAHAMAS FINANCIAL CENTRE, NASSAU | BS | |
1108.addresses.0 | 磐石成長開放式基金型公司 1108 | registered | UNIT 1011, LEVEL 10, HONG KONG | HK | |
1108.addresses.1 | 磐石成長開放式基金型公司 1108 | business | C/O BANDS CAPITAL MANAGEMENT LIMITED, HONG KONG | HK | |
1164.addresses.0 | 香港麗都投資有限公司 1164 | registered | ROOM 909, 9/F, CENTRAL | HK | |
1164.addresses.1 | 香港麗都投資有限公司 1164 | business | ROOM 909, 9/F, CENTRAL | HK | |
1201.addresses.0 | اوفر سيز بتروليوم اند شيبنج ش ذ م م 1201 | registered | مكتب رقم 01 A ملك مركز دبي العقاري - رقة البطين, ديرة | AE | |
1201.addresses.1 | اوفر سيز بتروليوم اند شيبنج ش ذ م م 1201 | business | مكتب رقم 01 A ملك مركز دبي العقاري - رقة البطين, ديرة | AE | |
1225.addresses.0 | PENTON ASSOCIATES LIMITED 1225 | registered | 12-14 FINCH ROAD, DOUGLAS | IM | |
1225.addresses.1 | PENTON ASSOCIATES LIMITED 1225 | business | 12-14 FINCH ROAD, DOUGLAS | IM | |
1256.addresses.0 | CRANHAM COMPANY LLC 1256 | registered | HENVILLE BUILDING, CHARLESTOWN | KN | |
1256.addresses.1 | CRANHAM COMPANY LLC 1256 | business | HENVILLE BUILDING, CHARLESTOWN | KN | |
1289.addresses.0 | OMNIX CAPITAL LIMITED 1289 | registered | ROOM 16, 1/F, NEW HENRY HOUSE, HONG KONG | HK | |
1289.addresses.1 | OMNIX CAPITAL LIMITED 1289 | business | ROOM 16, 1/F, NEW HENRY HOUSE, HONG KONG | HK | |
1348.addresses.0 | SIU YIN WAI & ASSOCIATES LIMITED 1348 | registered | 8 / F, LIPPO LEIGHTON TOWER, KOWLOON | HK | |
1348.addresses.1 | SIU YIN WAI & ASSOCIATES LIMITED 1348 | business | 8 / F, LIPPO LEIGHTON TOWER, KOWLOON | HK | |
1352.addresses.0 | MARKS AND SPENCER (IRELAND) LIMITED 1352 | registered | 24/27, MARY STREET, DUBLIN | IE | |
1352.addresses.1 | MARKS AND SPENCER (IRELAND) LIMITED 1352 | business | 24/27, MARY STREET, DUBLIN | IE | |
1361.addresses.0 | BLOOMFIELD CARE CENTRE - SAMUEL MERRIN FD 1361 | registered | BLOOMFIELD CARE CENTRE, DUBLIN | IE | |
1361.addresses.1 | BLOOMFIELD CARE CENTRE - SAMUEL MERRIN FD 1361 | business | BLOOMFIELD CARE CENTRE, DUBLIN | IE | |
1379.addresses.0 | PARAGON SICAV P.L.C. - D&R SPEEDLAB OPPORTUNITY FUND 1379 | registered | CENTRAL NORTH BUSINESS CENTRE LEVEL 1, SLIEMA | MT | |
1389.addresses.0 | ASTRAT LIMITED 1389 | registered | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
1389.addresses.1 | ASTRAT LIMITED 1389 | business | C/O CITITRUST (BAHAMAS) LIMITED, NASSAU | BS | |
1390.addresses.0 | CHARLES SHEILS CHARITY 1390 | registered | 24 SHEILS' HOUSES, DUBLIN | IE | |
1390.addresses.1 | CHARLES SHEILS CHARITY 1390 | business | 24 SHEILS' HOUSES, DUBLIN | IE | |
1408.addresses.0 | BEAR STEARNS COMPANIES LTD 1408 | registered | GLOBAL GATEWAY 8, RUE DE LA PERLE, PROVIDENCE | SC | |
1408.addresses.1 | BEAR STEARNS COMPANIES LTD 1408 | business | GLOBAL GATEWAY 8, RUE DE LA PERLE, PROVIDENCE | SC | |
1537.addresses.0 | SALAMIS SHIPPING COMPANY LIMITED 1537 | registered | 80 BROAD STREET, MONROVIA | LR | |
1537.addresses.1 | SALAMIS SHIPPING COMPANY LIMITED 1537 | business | 80 BROAD STREET, MONROVIA | LR | |
1581.addresses.0 | BOCOM INTERNATIONAL FUND 1581 | registered | C/O BOCOM INTERNATIONAL ASSET MANAGEMENT LIMITED, HONG KONG | HK | |
1581.addresses.1 | BOCOM INTERNATIONAL FUND 1581 | business | C/O BOCOM INTERNATIONAL ASSET MANAGEMENT LIMITED, HONG KONG | HK | |
1587.addresses.1 | WINEASE INVESTMENTS LIMITED 1587 | business | ROOM 3305, 33/F, TOWER TWO, LIPPO CENTRE, QUEENSWAY | HK | |
1615.addresses.0 | HEATHER MARGARET BROWN WILL TRUST 1615 | registered | 16 DENDY ROAD, PAIGNTON | GB | |
1615.addresses.1 | HEATHER MARGARET BROWN WILL TRUST 1615 | business | 16 DENDY ROAD, PAIGNTON | GB | |
1700.addresses.0 | EVERAN LIMITED 1700 | registered | CORNER HUTSON & EYRE STREET, BELIZE CITY | BZ | |
1726.addresses.0 | CHINAAMC SELECT MONEY MARKET FUND 1726 | registered | C/O CHINA ASSET MANAGEMENT (HONG KONG) LIMITED, HONG KONG | HK | |
1726.addresses.1 | CHINAAMC SELECT MONEY MARKET FUND 1726 | business | C/O CHINA ASSET MANAGEMENT (HONG KONG) LIMITED, HONG KONG | HK | |
1751.addresses.0 | SHAWCROSS SETTLEMENT NO. 1 1751 | registered | DEHLIA COTTAGE, UPPER SWANMORE | GB | |
1751.addresses.1 | SHAWCROSS SETTLEMENT NO. 1 1751 | business | DEHLIA COTTAGE, UPPER SWANMORE | GB | |
1789.addresses.0 | 金門建築有限公司 1789 | registered | 22/F TOWER 1 AND 2, KWUN TONG | HK | |
1789.addresses.1 | 金門建築有限公司 1789 | business | 22/F TOWER 1 AND 2, KWUN TONG | 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]) );