entity_addresses
5,142,408 rows sorted by country
This data as json, CSV (advanced)
_link | _link_entity_statement | type | address | country ▼ | postcode |
---|---|---|---|---|---|
10343.addresses.0 | LLIBERTAT INVERSIONS, SLU 10343 | registered | CARRER DE ROCA CORBA, CONJUNT RESIDENCIAL ROCA CORBA BLOC D, 1R, ESCALDES-ENGORDANY | AD | AD700 |
10343.addresses.1 | LLIBERTAT INVERSIONS, SLU 10343 | business | CARRER DE ROCA CORBA, CONJUNT RESIDENCIAL ROCA CORBA BLOC D, 1R, ESCALDES-ENGORDANY | AD | AD700 |
19476.addresses.0 | SKYLINE HOLDING, SLU 19476 | registered | PLAÇA GUILLEMÓ NÚM 3 1R PIS, ANDORRA LA VELLA | AD | |
19476.addresses.1 | SKYLINE HOLDING, SLU 19476 | business | PLAÇA GUILLEMÓ NÚM 3 1R PIS, ANDORRA LA VELLA | AD | |
31068.addresses.1 | NEIPER HOLDINGS LTD 31068 | business | ATICA EDIFICICERAMICA, LA MASSANA | AD | AD400 |
36320.addresses.0 | LEGENDARY LEARNING SL 36320 | registered | CLOTASSOS I, 2-1, ORDINO | AD | |
36320.addresses.1 | LEGENDARY LEARNING SL 36320 | business | CLOTASSOS I, 2-1, ORDINO | AD | |
37940.addresses.1 | CORUNDUM RUSSIA FUND LIMITED 37940 | business | URB. ELS ORIOSOS, LA MASSANA | AD | AD400 |
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 |
112119.addresses.0 | LAKE HOLDING SLU 112119 | registered | 26 CONJUNT RESIDENCIAL "GINEBROSA" LA CAUBA, LA MASSANA | AD | AD400 |
112119.addresses.1 | LAKE HOLDING SLU 112119 | business | 26 CONJUNT RESIDENCIAL "GINEBROSA" LA CAUBA, LA MASSANA | AD | AD400 |
130462.addresses.0 | ASSESSORA I GESTORA D’INVERSIONS, SA 130462 | registered | 65, 3R 2A, ESCALDES ENGORDANY | AD | AD700 |
130462.addresses.1 | ASSESSORA I GESTORA D’INVERSIONS, SA 130462 | business | 65, 3R 2A, ESCALDES ENGORDANY | AD | AD700 |
147347.addresses.0 | C.L.P.M., SL 147347 | registered | CLOTASSOS I, 2-1, ORDINO | AD | AD300 |
147347.addresses.1 | C.L.P.M., SL 147347 | business | CLOTASSOS I, 2-1, ORDINO | AD | AD300 |
165039.addresses.0 | ERRANTES SL. 165039 | registered | 6 SA CLOTA VERDE, ORDINO | AD | AD300 |
165039.addresses.1 | ERRANTES SL. 165039 | business | 6 SA CLOTA VERDE, ORDINO | AD | AD300 |
165266.addresses.0 | PHÈME SLU 165266 | registered | BP ECONOMIST, AV. CONSELL D'EUROPA, 14, ANDORRA-LA-VELLA | AD | AD500 |
165266.addresses.1 | PHÈME SLU 165266 | business | BP ECONOMIST, AV. CONSELL D'EUROPA, 14, ANDORRA-LA-VELLA | AD | AD500 |
189813.addresses.0 | ORBITA, S.A. 189813 | registered | PASSATGE D'EUROPA 2, ANDORRA LA VELLA | AD | AD500 |
189813.addresses.1 | ORBITA, S.A. 189813 | business | PASSATGE D'EUROPA 2, ANDORRA LA VELLA | AD | AD500 |
231134.addresses.1 | SHORT TERM FIXED INCOME EURO FUND 231134 | business | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
231837.addresses.1 | US AMERICAN VALUE 231837 | business | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
231975.addresses.1 | MONEY MARKET DOLLAR FUND 231975 | business | 6-8, BONAVENTURA ARMENGOL, ANDORRA LA VELLA | AD | AD500 |
233101.addresses.1 | INVESTCREDIT SICAV 233101 | business | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
235061.addresses.1 | FIMARGE BALANCED PORTFOLIO FUND 235061 | business | C/O FIMARGE, SOCIETAT FINANCERA D'INVERSIO, ANDORRA AL VELLA | AD | AD500 |
236259.addresses.1 | FIXED INCOME DOLLAR 236259 | business | C/O CREDI-INVEST, SA, ANDORRA LA VELLA | AD | AD500 |
237463.addresses.1 | MONEY MARKET EURO FUND 237463 | business | 6-8, BONAVENTURA ARMENGOL, ANDORRA LA VELLA | AD | AD500 |
252599.addresses.1 | China Resources Limited 252599 | business | Carretera Dels Plans, La Massana | AD | AD400 |
259058.addresses.0 | WATT INTERNACIONAL, SLU 259058 | registered | Josep Rossell Calva 13, Andorra La Vella | AD | AD500 |
259058.addresses.1 | WATT INTERNACIONAL, SLU 259058 | business | Josep Rossell Calva 13, Andorra La Vella | AD | AD500 |
259322.addresses.0 | VIDEO SECURITY SYSTEMS 2016, SLU 259322 | registered | Carrer Hort De Godi 2 B, Encamp | AD | AD200 |
259322.addresses.1 | VIDEO SECURITY SYSTEMS 2016, SLU 259322 | business | Carrer Hort De Godi 2 B, Encamp | AD | AD200 |
265455.addresses.0 | Creekside Patrimonial, SL 265455 | registered | Carretera d'Engolasters n. 53, Les Escaldes | AD | AD700 |
265455.addresses.1 | Creekside Patrimonial, SL 265455 | business | Carretera d'Engolasters n. 53, Les Escaldes | AD | AD700 |
270520.addresses.0 | ASSEGURANCES GENERALS, SA 270520 | registered | Carre Gil Torres 38 1st, Andorra La Vella | AD | AD500 |
270520.addresses.1 | ASSEGURANCES GENERALS, SA 270520 | business | Carrer Sant Salvador 7, Andorra La Vella | AD | AD500 |
272899.addresses.0 | MAR D'ARDORA, SLU 272899 | registered | Passatge Antonia Font Caminal, Escaldes-Engordany | AD | AD700 |
272899.addresses.1 | MAR D'ARDORA, SLU 272899 | business | Passatge Antonia Font Caminal, Escaldes-Engordany | AD | AD700 |
275075.addresses.1 | BANCO ANDBANK (BRASIL) S.A. 275075 | business | 6 Escaldes, Les Escaldes | AD | AD700 |
289968.addresses.0 | Laurion Backoffice and Corporate Shared Services, SLU 289968 | registered | Urbanitzacio Ermengol Serra, Num. 18, Escaldes-Engordany | AD | AD700 |
289968.addresses.1 | Laurion Backoffice and Corporate Shared Services, SLU 289968 | business | Urbanitzacio Ermengol Serra, Num. 18, Escaldes-Engordany | AD | AD700 |
291083.addresses.0 | Club Internacional D'Andorra 291083 | registered | Av. De Sant Antoni 26, La Massana | AD | AD400 |
291083.addresses.1 | Club Internacional D'Andorra 291083 | business | Av. De Sant Antoni 26, La Massana | AD | AD400 |
295485.addresses.0 | Capital Synthesis, SL 295485 | registered | Carrer Del Manual Digest,, Ordino | AD | AD300 |
295485.addresses.1 | Capital Synthesis, SL 295485 | business | Carrer Del Manual Digest,, Ordino | AD | AD300 |
303157.addresses.0 | Autoritat Financera Andorrana 303157 | registered | C. Bonaventura Armengol, 10, Andorra la Vella | AD | AD500 |
303157.addresses.1 | Autoritat Financera Andorrana 303157 | business | C. Bonaventura Armengol, 10, Andorra la Vella | AD | AD500 |
309079.addresses.0 | Universal Gestió, SA 309079 | registered | Carrer Bonaventura Armengol 010 1, Andorra la Vella | AD | AD500 |
309079.addresses.1 | Universal Gestió, SA 309079 | business | Carrer Bonaventura Armengol 010 1, Andorra la Vella | AD | AD500 |
325264.addresses.0 | DRAC TECHNOLOGIES, S.L. 325264 | registered | Avinguda Benlloch, Num. 43, ANDORRA LA VELLA | AD | AD500 |
325264.addresses.1 | DRAC TECHNOLOGIES, S.L. 325264 | business | Avinguda Benlloch, Num. 43, ANDORRA LA VELLA | AD | AD500 |
325416.addresses.0 | OSVIRA, SLU 325416 | registered | Complex Residencial Els Buners, Ordino | AD | |
325416.addresses.1 | OSVIRA, SLU 325416 | business | Complex Residencial Els Buners, Ordino | AD | |
326600.addresses.0 | SLVC, SLU 326600 | registered | Carrer Balco del sola, Encamp | AD | AD200 |
326600.addresses.1 | SLVC, SLU 326600 | business | Carrer Balco del sola, Encamp | AD | AD200 |
329411.addresses.0 | KRASATA, SLU 329411 | registered | C. Major 1/8, La Massana | AD | AD400 |
329411.addresses.1 | KRASATA, SLU 329411 | business | C. Major 1/8, La Massana | AD | AD400 |
334619.addresses.0 | DREAMGATE CAPITAL, SLU 334619 | registered | Meritxell Avenue, Andorra la Vella | AD | AD500 |
334619.addresses.1 | DREAMGATE CAPITAL, SLU 334619 | business | Meritxell Avenue, Andorra la Vella | AD | AD500 |
338884.addresses.0 | Trading Alto Rendimiento, SL 338884 | registered | Carretera La Comella, 121, Andorra la Vella | AD | AD500 |
338884.addresses.1 | Trading Alto Rendimiento, SL 338884 | business | Carretera La Comella, 121, Andorra la Vella | AD | AD500 |
341099.addresses.0 | Inverpro, SLU 341099 | registered | Princep Benlloch Avenue,Num.26-30, Andorra La Vella | AD | AD500 |
341099.addresses.1 | Inverpro, SLU 341099 | business | Princep Benlloch Avenue,Num.26-30, Andorra La Vella | AD | AD500 |
342704.addresses.0 | ARBO, SL 342704 | registered | Urb Guem, 10, Escaldes Engordany | AD | AD700 |
342704.addresses.1 | ARBO, SL 342704 | business | Urb Guem, 10, Escaldes Engordany | AD | AD700 |
344410.addresses.0 | Jetho, SLU 344410 | registered | Avinguda Doctor Mitjavila, Andorra la Vella | AD | AD500 |
344410.addresses.1 | Jetho, SLU 344410 | business | Carrer Sant Salvador, Andorra la Vella | AD | AD500 |
345732.addresses.0 | Borjes Patrimonial, SLU 345732 | registered | C/Josep Rossell, La Massana | AD | AD400 |
345732.addresses.1 | Borjes Patrimonial, SLU 345732 | business | C/Josep Rossell, La Massana | AD | AD400 |
346775.addresses.0 | INVESTIGACIO TECNOLOGICA EUROPEA S.A. 346775 | registered | Placa Guillemo, num 8, 2n 2a, Andorra la Vella | AD | AD500 |
346775.addresses.1 | INVESTIGACIO TECNOLOGICA EUROPEA S.A. 346775 | business | Placa Guillemo, num 8, 2n 2a, Andorra la Vella | AD | AD500 |
350966.addresses.0 | db patrimonial, SLU 350966 | registered | Avinguda de Santa Coloma, No.31, Andorra La Vella | AD | AD501 |
350966.addresses.1 | db patrimonial, SLU 350966 | business | Avinguda de Santa Coloma, No.31, Andorra La Vella | AD | AD501 |
358192.addresses.0 | Consortium Elit SL 358192 | registered | ED BELESGUARD B 4T 2A, Canillo | AD | AD100 |
358192.addresses.1 | Consortium Elit SL 358192 | business | ED BELESGUARD B 4T 2A, Canillo | AD | AD100 |
373451.addresses.0 | S.G.L., SL 373451 | registered | Carrer De La Creu Grossa, Num 15, Andorra La Vella | AD | AD500 |
373451.addresses.1 | S.G.L., SL 373451 | business | Carrer De La Creu Grossa, Num 15, Andorra La Vella | AD | AD500 |
378099.addresses.0 | SOFI INVEST GROUP SLU 378099 | registered | Edifici Devesa, Canillo | AD | AD 100 |
378099.addresses.1 | SOFI INVEST GROUP SLU 378099 | business | Edifici Devesa, Canillo | AD | AD 100 |
386113.addresses.0 | AM INTERNATIONAL HOLDING LIMITED, SL 386113 | registered | PASSATGE D'EUROPA, 2, ANDORRA LA VELLA | AD | AD500 |
386113.addresses.1 | AM INTERNATIONAL HOLDING LIMITED, SL 386113 | business | PASSATGE D'EUROPA, 2, ANDORRA LA VELLA | AD | AD500 |
387089.addresses.0 | RANDT CORPORATE SERVICES, SL 387089 | registered | Carretera de la Comella, 23, Andorra la Vella | AD | AD500 |
387089.addresses.1 | RANDT CORPORATE SERVICES, SL 387089 | business | Carretera de la Comella, 23, Andorra la Vella | AD | AD500 |
389081.addresses.0 | Llinàs Consultoria, SLU 389081 | registered | Carrer del Llinas, Juberri | AD | AD600 |
389081.addresses.1 | Llinàs Consultoria, SLU 389081 | business | Carrer del Llinas, Juberri | AD | AD600 |
389734.addresses.0 | Vest Capital, SL 389734 | registered | CARRER SOLA DEL JAN 19, Andorra la Vella | AD | AD500 |
389734.addresses.1 | Vest Capital, SL 389734 | business | CARRER SOLA DEL JAN 19, Andorra la Vella | AD | AD500 |
393805.addresses.0 | VERCARO, SL 393805 | registered | carrer St Pau Calsals, Num.8, Andorra la vella | AD | AD500 |
393805.addresses.1 | VERCARO, SL 393805 | business | carrer St Pau Calsals, Num.8, Andorra la Vella | AD | AD500 |
395125.addresses.0 | SYSTEMA CAPITAL, SL 395125 | registered | Passatge D' Europa, Andorra la Vella | AD | AD500 |
395125.addresses.1 | SYSTEMA CAPITAL, SL 395125 | business | Parc de la Mola, 10 - 4, Escaldes-Engordany | AD | AD700 |
397327.addresses.0 | Liberty Rock SLU 397327 | registered | Carrer Pau Casals, 10, Andorra la Vella | AD | AD500 |
397327.addresses.1 | Liberty Rock SLU 397327 | business | Carrer Pau Casals, 10, Andorra la Vella | AD | AD500 |
398278.addresses.0 | Doll Patrimonial, SLU 398278 | registered | C/Josep Rossell, 3, La Massana | AD | AD400 |
398278.addresses.1 | Doll Patrimonial, SLU 398278 | business | C/Josep Rossell, 3, La Massana | AD | AD400 |
400138.addresses.0 | Rocinante, SL 400138 | registered | Carrer Prat De la Creu, Num.79, Androrra La Vella | AD | AD500 |
400138.addresses.1 | Rocinante, SL 400138 | business | Carrer Prat De la Creu, Num.79, Androrra La Vella | AD | AD500 |
404347.addresses.0 | Bmagic Holding, SAU 404347 | registered | C. Serrat Del Camp 001 1 1, L'aldosa | AD | AD400 |
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]) );