entity_addresses
5,142,408 rows sorted by country
This data as json, CSV (advanced)
_link | _link_entity_statement | type | address | country ▼ | postcode |
---|---|---|---|---|---|
404347.addresses.1 | Bmagic Holding, SAU 404347 | business | C. Serrat Del Camp 001 1 1, L'aldosa | AD | AD400 |
407605.addresses.0 | Nine Yards, SLU 407605 | registered | Avinguda de les Moles, No.21, Ordino | AD | AD301 |
407605.addresses.1 | Nine Yards, SLU 407605 | business | Avinguda de les Moles,no.21, Ordino | AD | AD301 |
407724.addresses.0 | Companyia Andorrana Catalonia, SL 407724 | registered | Sant Miquel d'Engolasters, Escaldes-Engordany | AD | AD700 |
407724.addresses.1 | Companyia Andorrana Catalonia, SL 407724 | business | Sant Miquel d'Engolasters, Escaldes-Engordany | AD | AD700 |
422941.addresses.0 | OSSAU PATRIMOINE, SLU 422941 | registered | CARRER BONY DE SANT QUIRI, ORDINO | AD | AD300 |
422941.addresses.1 | OSSAU PATRIMOINE, SLU 422941 | business | CARRER BONY DE SANT QUIRI, ORDINO | AD | AD300 |
427142.addresses.0 | PROFUND PARTNERS, SLU 427142 | registered | Carretera de la Comella, 23, Andorra la Vella | AD | AD500 |
427142.addresses.1 | PROFUND PARTNERS, SLU 427142 | business | Carretera de la Comella, 23, Andorra la Vella | AD | AD500 |
431443.addresses.0 | ARMOR S.A. 431443 | registered | PASSATGE D'EUROPA, 2, ANDORRA LA VELLA | AD | AD500 |
431443.addresses.1 | ARMOR S.A. 431443 | business | PASSATGE D'EUROPA, 2, ANDORRA LA VELLA | AD | AD500 |
614052.addresses.0 | EAGLEANDSKY, SLU 614052 | registered | Avinguda Del Pessebre 22, Escaldes-Engordany | AD | AD700 |
614052.addresses.1 | EAGLEANDSKY, SLU 614052 | business | Avinguda Del Pessebre 22, Escaldes-Engordany | AD | AD700 |
61620.addresses.0 | MORA ASSEGURANCES, SAU 61620 | registered | AV. MERITXELL, 96, ANDORRA LA VELLA | AD | AD500 |
61620.addresses.1 | MORA ASSEGURANCES, SAU 61620 | business | AV. MERITXELL, 96, ANDORRA LA VELLA | AD | AD500 |
636897.addresses.0 | MSΚYM PRODUCTION, SLU 636897 | registered | CARRER PERE d'Urg 9, Andorra la Vella | AD | AD500 |
636897.addresses.1 | MSΚYM PRODUCTION, SLU 636897 | business | CARRER PERE d'Urg 9, Andorra la Vella | AD | AD500 |
658965.addresses.0 | Holt Holding SA 658965 | registered | Placa Guillemo 3/1/, Andorra la Vella | AD | 500 |
658965.addresses.1 | Holt Holding SA 658965 | business | Placa Guillemo 3/1/, Andorra la Vella | AD | 500 |
675295.addresses.0 | U.S.S.A.X., SLU 675295 | registered | Urbanització Sant Miquel d'Engolasters, Escaldes-Engordany | AD | AD700 |
675295.addresses.1 | U.S.S.A.X., SLU 675295 | business | Urbanització Sant Miquel d'Engolasters, Escaldes-Engordany | AD | AD700 |
830438.addresses.1 | PROFO TRADING LP 830438 | business | Avinguda De les Moles 19 A, 11 EDIP PRAT DELA Mola, Andorra la Vella | AD | AD3000 |
884166.addresses.0 | LC INVEST SLU 884166 | registered | Bonaventura Armengol Street, no.10, Andorra | AD | AD500 |
884166.addresses.1 | LC INVEST SLU 884166 | business | Bonaventura Armengol Street, no.10, Andorra | AD | AD500 |
884167.addresses.0 | Integral APM, SLU 884167 | registered | Ctra del Mas de Ribafeta 14 1 1, Arinsal | AD | AD400 |
884167.addresses.1 | Integral APM, SLU 884167 | business | Ctra. del Mas de Ribafeta 14 1 1, Arinsal | AD | AD400 |
884169.addresses.0 | AD TYRES INTERNATIONAL SLU 884169 | registered | Carrer Bonaventura Armengol 10, Andorra | AD | AD500 |
884169.addresses.1 | AD TYRES INTERNATIONAL SLU 884169 | business | Carrer Bonaventura Armengol 10, Andorra | AD | AD500 |
884170.addresses.0 | Belumo Crypto Capital SLU 884170 | registered | Carrer Pere D'URG, 10-12, Andorra la Vella | AD | AD500 |
884170.addresses.1 | Belumo Crypto Capital SLU 884170 | business | Carrer Pere D'Urg,Num 10-12, Andorra La Vella | AD | AD500 |
884171.addresses.0 | Zotto Capital, SLU 884171 | registered | Edifici El Tarter, CANILLO | AD | AD200 |
884171.addresses.1 | Zotto Capital, SLU 884171 | business | Edifici El Tarter, CANILLO | AD | AD200 |
884537.addresses.0 | Bema Verde SL 884537 | registered | Pleta Socalina, Escaldes-Engordany | AD | AD700 |
884537.addresses.1 | Bema Verde SL 884537 | business | Pleta Socalina, Escaldes-Engordany | AD | AD700 |
885208.addresses.0 | CREDIT FONS CONSERVADOR, FI 885208 | registered | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
885208.addresses.1 | CREDIT FONS CONSERVADOR, FI 885208 | business | C.BONAVENTURA ARMENGOL, 6-8, ANDORRA LA VELLA | AD | AD500 |
886549.addresses.0 | X-BERG CAPITAL,SLU 886549 | registered | Carrer de la Solana 9, PAS DE LA CASA | AD | AD200 |
886549.addresses.1 | X-BERG CAPITAL,SLU 886549 | business | CARRER DE LA SOLANA, 9, PAS DE LA CASA | AD | AD200 |
887054.addresses.0 | CASA MOLINES, S.A. 887054 | registered | CARRER LES CANALS, 007 1-2, ANDORRA LA VELLA | AD | AD500 |
887054.addresses.1 | CASA MOLINES, S.A. 887054 | business | CARRER LES CANALS, 007 1-2, ANDORRA LA VELLA | AD | AD500 |
887203.addresses.0 | Breizho Europe SL 887203 | registered | CAN NOGUER 14 ED LA DEVESA XALET 4, ESCALDES ENGORDANY | AD | AD700 |
887203.addresses.1 | Breizho Europe SL 887203 | business | Urbanitzacio Can Noguer, Escaldes-Engordany | AD | AD700 |
887230.addresses.0 | L.G.Q. Investors 2017,SL 887230 | registered | Carrer de Laldosa 033 1 4 (BellmBloc B), La massana | AD | AD400 |
887230.addresses.1 | L.G.Q. Investors 2017,SL 887230 | business | Carrer de Laldosa 033 1 4 (BellmBloc B), La Massana | AD | AD400 |
887519.addresses.0 | Champions Peak Holding SLU 887519 | registered | Carrer del cap del roc 4, Sornas | AD | AD300 |
887519.addresses.1 | Champions Peak Holding SLU 887519 | business | Casa Joanet, Sornas | AD | AD300 |
888414.addresses.0 | Poulougathe, SLU 888414 | registered | Carrer Bonaventura Armengol, Num. 15, Andorra La Vella | AD | AD500 |
888414.addresses.1 | Poulougathe, SLU 888414 | business | Carrer Bonaventura Armengol, Num. 15, Andorra La Vella | AD | AD500 |
891176.addresses.0 | Smart OH, SLU 891176 | registered | Carretera del Forn a la Urbanitzacio Ribagrossa, Canillo | AD | AD100 |
891176.addresses.1 | Smart OH, SLU 891176 | business | Carretera del Forn a la Urbanitzacio Ribagrossa, Canillo | AD | AD100 |
891755.addresses.0 | Green Tree SL 891755 | registered | Av. de Tarragona 22, Andorra la Vella | AD | AD500 |
891755.addresses.1 | Green Tree SL 891755 | business | Av. de Tarragona 22, Andorra la Vella | AD | AD500 |
896368.addresses.0 | Uye Slu 896368 | registered | Roca Corba 1, Escaldes | AD | AD700 |
896368.addresses.1 | Uye Slu 896368 | business | Roca Corba 1, Escaldes | AD | AD700 |
902377.addresses.0 | SIO STRATEGIC INVESTMENT OPPORTUNITIES SICAV I 902377 | registered | CARRER BONAVENTURA ARMENGOL, 6-8, ANDORRA LA VELLA | AD | AD500 |
902377.addresses.1 | SIO STRATEGIC INVESTMENT OPPORTUNITIES SICAV I 902377 | business | CARRER BONAVENTURA ARMENGOL, 6-8, ANDORRA LA VELLA | AD | AD500 |
902848.addresses.0 | CAPRI II SUB-FUND 902848 | registered | AV VERGE DE CANOLICH 36, SANT JULIA DE LORIA | AD | AD600 |
902848.addresses.1 | CAPRI II SUB-FUND 902848 | business | C/O MERIDEN IFM SGOIC, SAU, SANT JULIA DE LORIA | AD | AD600 |
903902.addresses.0 | MULTIPLE COMPARTMENT FUND, FI - DOMINIUM GLOBAL EQUITIES SUB-FUND 903902 | registered | C/O MERIDEN IFM SGOIC, SAU, SANT JULIÀ DE LÒRIA | AD | AD600 |
903902.addresses.1 | MULTIPLE COMPARTMENT FUND, FI - DOMINIUM GLOBAL EQUITIES SUB-FUND 903902 | business | AVENUE VERGE DE CANOLICH, 36, SANT JULIÀ DE LÒRIA | AD | AD600 |
904310.addresses.0 | CREDI-INVEST, SA 904310 | registered | C/ BONAVENTURA ARMENGOL, 6-8, 5, ANDORRA LA VELLA | AD | AD500 |
904310.addresses.1 | CREDI-INVEST, SA 904310 | business | C/ BONAVENTURA ARMENGOL, 6-8, 5, ANDORRA LA VELLA | AD | AD500 |
915780.addresses.0 | RENDIBILITAT OBJECTIU 6 915780 | registered | C/O CREDI-INVEST, SA, NULL | AD | AD500 |
915780.addresses.1 | RENDIBILITAT OBJECTIU 6 915780 | business | C/O CREDI-INVEST, SA, NULL | AD | AD500 |
927007.addresses.0 | CREDITFUND RENDIBILITAT OBJECTIU 2, FI 927007 | registered | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
927007.addresses.1 | CREDITFUND RENDIBILITAT OBJECTIU 2, FI 927007 | business | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
927263.addresses.0 | CREDITFUND INCOME DOLLAR, FI 927263 | registered | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
927263.addresses.1 | CREDITFUND INCOME DOLLAR, FI 927263 | business | C.BONAVENTURA ARMENGOL, 6-8, ANDORRA LA VELLA | AD | AD500 |
927864.addresses.0 | INSTITUTIONAL FUND, FI 927864 | registered | CARRER MANUEL CERQUEDA I ESCALER, NÚM. 3-5, A L’EDIFICI MIL·LENIUM, ESCALDES-ENGORDANY | AD | AD700 |
927864.addresses.1 | INSTITUTIONAL FUND, FI 927864 | business | C/O ANDORRA GESTIÓ AGRÍCOL REIG, SAU SGOIC, ESCALDES-ENGORDANY | AD | AD700 |
929251.addresses.0 | GARANT SUB-FUND 929251 | registered | C/O MERIDEN IFM SGOIC, SAU, SANT JULIÀ DE LÒRIA | AD | AD600 |
929251.addresses.1 | GARANT SUB-FUND 929251 | business | C/O MERIDEN IFM SGOIC, SAU, SANT JULIÀ DE LÒRIA | AD | AD600 |
929376.addresses.1 | REALICA ENTERPRISE LTD. 929376 | business | RANKRE BUSINESS SERVICES, LA VELLA | AD | AD500 |
934803.addresses.0 | ANDORRA GESTIÓ AGRÍCOL REIG, SAU SGOIC 934803 | registered | C. MANUEL CERQUEDA I ESCALER, 3-5, ED., ESCALDES-ENGORDANY | AD | AD700 |
934803.addresses.1 | ANDORRA GESTIÓ AGRÍCOL REIG, SAU SGOIC 934803 | business | CARRER MANUEL CERQUEDA I ESCALER, 3-5, ESCALDES-ENGORDANY | AD | AD700 |
934841.addresses.0 | INVERSIONS MORSA, SA 934841 | registered | CARRER CAN DIUMENGE, ESCALDES | AD | AD700 |
934841.addresses.1 | INVERSIONS MORSA, SA 934841 | business | PASSATGE D'EUROPA 2, ANDORRA LA VELLA | AD | AD500 |
937320.addresses.0 | MORA GESTIO D'ACTIUS SAU 937320 | registered | PASSATGE DE L'AIGÜETA, 3, ANDORRA LA VELLA | AD | AD500 |
937320.addresses.1 | MORA GESTIO D'ACTIUS SAU 937320 | business | PASSATGE DE L'AIGÜETA, 3, ANDORRA LA VELLA | AD | AD500 |
937389.addresses.0 | ANDBANK PATRIMONI 937389 | registered | CARRER MANUEL CERQUEDA I ESCALER, NÚM. 3-5, A L’EDIFICI MIL·LENIUM, ESCALDES-ENGORDANY | AD | AD700 |
937389.addresses.1 | ANDBANK PATRIMONI 937389 | business | C/O ANDORRA GESTIÓ AGRÍCOL REIG, SAU SGOIC, ESCALDES-ENGORDANY | AD | AD700 |
940315.addresses.0 | SICAV CARTERA 1278 940315 | registered | C/O MORA GESTIÓ D'ACTIUS, SAU SGOIC, ANDORRA LA VELLA | AD | AD500 |
940315.addresses.1 | SICAV CARTERA 1278 940315 | business | C/O MORA GESTIÓ D'ACTIUS, SAU SGOIC, ANDORRA LA VELLA | AD | AD500 |
944133.addresses.0 | ALTERNATIVE INVESTMENT FUND, FI - ALTERNATIVE INVESTMENT GROWTH A 944133 | registered | C/O ANDORRA GESTIÓ AGRÍCOL REIG, SAU SGOIC, ESCALDES-ENGORDANY | AD | AD700 |
944133.addresses.1 | ALTERNATIVE INVESTMENT FUND, FI - ALTERNATIVE INVESTMENT GROWTH A 944133 | business | CARRER MANUEL CERQUEDA I ESCALER, 3-5, ESCALDES-ENGORDANY | AD | AD700 |
945494.addresses.0 | SIO STRATEGIC INVESTMENT OPPORTUNITIES SICAV SCALE LAB 945494 | registered | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
945494.addresses.1 | SIO STRATEGIC INVESTMENT OPPORTUNITIES SICAV SCALE LAB 945494 | business | C/ BONAVENTURA ARMENGOL, 6-8, 2N, ANDORRA LA VELLA | AD | AD500 |
948957.addresses.0 | SHORT TERM FUND, FI - SHORT TERM FUND - PREMIUM 948957 | registered | C/O ANDORRA GESTIÓ AGRÍCOL REIG, SAU SGOIC, ESCALDES-ENGORDANY | AD | AD700 |
948957.addresses.1 | SHORT TERM FUND, FI - SHORT TERM FUND - PREMIUM 948957 | business | C/MANUEL CERQUEDA I ESCALER, 3-5, ESCALDES-ENGORDANY | AD | AD700 |
949626.addresses.0 | ANDBANK AR INVESTMENT SICAV - MCINTYRE 949626 | registered | CARRER MANUEL CERQUEDA I ESCALER 3-5, ESCALDES-ENGORDANY | AD | AD700 |
949626.addresses.1 | ANDBANK AR INVESTMENT SICAV - MCINTYRE 949626 | business | CARRER MANUEL CERQUEDA I ESCALER 3-5, ESCALDES-ENGORDANY | AD | AD700 |
949763.addresses.0 | MORA BANC GRUP, SA 949763 | registered | AV. MERITXELL, 32, ANDORRA LA VELLA | AD | AD500 |
949763.addresses.1 | MORA BANC GRUP, SA 949763 | business | 96, AVENUE MERITXELL, ANDORRA LA VELLA | AD | AD500 |
949883.addresses.0 | EQUITY FUND, FI - EQUITY FUND EUROPEAN EQUITIES A 949883 | registered | CARRER MANUEL CERQUEDA I ESCALER, 3-5, ESCALDES-ENGORDANY | AD | AD700 |
949883.addresses.1 | EQUITY FUND, FI - EQUITY FUND EUROPEAN EQUITIES A 949883 | business | CARRER MANUEL CERQUEDA I ESCALER, 3-5, ESCALDES-ENGORDANY | AD | AD700 |
951079.addresses.0 | CREDIT FONS ACTIU, FI 951079 | registered | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
951079.addresses.1 | CREDIT FONS ACTIU, FI 951079 | business | C.BONAVENTURA ARMENGOL, 6-8, ANDORRA LA VELLA | AD | AD500 |
953673.addresses.0 | BANANA SPLIT 953673 | registered | CARRER MANUEL CERQUEDA I ESCALER, NÚM. 3-5, A L’EDIFICI MIL·LENIUM, ESCALDES-ENGORDANY | AD | AD700 |
953673.addresses.1 | BANANA SPLIT 953673 | business | C/O ANDORRA GESTIÓ AGRÍCOL REIG, SAU SGOIC, ESCALDES-ENGORDANY | AD | AD700 |
973098.addresses.0 | PLC SERVICES, SLU 973098 | registered | 26 CARRER MIRADOR D`ENCAMP, ENCAMP | AD | AD200 |
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]) );