entity_addresses

5,226,472 rows

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_entity_statement type address country postcode
0.addresses.0 JAI 21 COMMODITIES MANAGEMENT, S.L.U, 0 registered CALLE VÁZQUEZ DE PARGA 10 1º B, Carballo ES 15100
0.addresses.1 JAI 21 COMMODITIES MANAGEMENT, S.L.U, 0 business LUGAR QUEO DE ARRIBA - BÉRTOA 47, Carballo ES 15105
1.addresses.0 HEMARE CONSULTING S.L. 1 registered ANGLI 32 1 B, Barcelona ES 08017
1.addresses.1 HEMARE CONSULTING S.L. 1 business ANGLI 32 1 B, Barcelona ES 08017
10.addresses.0 SITIO DE GOBELALDE SL 10 registered ALAMEDA MAZARREDO, 9- 2º, Bilbao ES 48001
10.addresses.1 SITIO DE GOBELALDE SL 10 business ALAMEDA MAZARREDO, 9- 2º, Bilbao ES 48001
100.addresses.0 FERRI MOVIL S.A. 100 registered AUTOVIA SEVILLA-MERIDA 475, CAMAS ES 41900
100.addresses.1 FERRI MOVIL S.A. 100 business AVD ALCALDE MANUEL CABELLO S/N, CAMAS ES 41900
1000.addresses.0 INVERSUVAL SL 1000 registered C/ LITOGRAFO PASCUAL Y ABAD 10 - BAJO, IZQUIERDA, VALÈNCIA ES 46017
1000.addresses.1 INVERSUVAL SL 1000 business C/ LITOGRAFO PASCUAL Y ABAD 10 - BAJO, IZQUIERDA, VALÈNCIA ES 46017
10000.addresses.0 SENIOR LOANS IV 10000 registered Via Machiavelli 4, Trieste IT 34132
10000.addresses.1 SENIOR LOANS IV 10000 business C/O Generali Investments Partners S.P.A. Societa Di Gestione Del Risparmio, Trieste IT 34132
100000.addresses.0 SWEDESFORD SQUARE APARTMENTS L/CAL LIMITED PARTNERSHIP 100000 registered C/O Corporation Service Company, Wilmington US 19808
100000.addresses.1 SWEDESFORD SQUARE APARTMENTS L/CAL LIMITED PARTNERSHIP 100000 business 850 Cassatt Road, Berwyn US 19312
100001.addresses.0 Tembusu Partners Pte. Ltd. 100001 registered Ocean Financial Centre, Singapore SG 049315
100001.addresses.1 Tembusu Partners Pte. Ltd. 100001 business Ocean Financial Centre, Singapore SG 049315
100002.addresses.0 Firestone Commercial Investment, LLC 100002 registered 14655 Firestone Blvd., La Mirada US 90638
100002.addresses.1 Firestone Commercial Investment, LLC 100002 business 14655 Firestone Blvd., La Mirada US 90638
100003.addresses.0 LOSFELIZ51 LP 100003 registered C/O MICHAEL NIGH, NEWBURY PARK US 91320
100003.addresses.1 LOSFELIZ51 LP 100003 business 1400 W HILLCREST DR, Newbury Park US 91320
100004.addresses.0 J2 Sourcing AB 100004 registered Kantyxegatan 29, Malmö SE 213 76
100004.addresses.1 J2 Sourcing AB 100004 business Kantyxegatan 29, Malmö SE 213 76
100005.addresses.0 CYNTEL INVESTMENTS LIMITED 100005 registered C/O SHRM Trustees (BVI) Limited, Road Town, Tortola VG VG1110
100005.addresses.1 CYNTEL INVESTMENTS LIMITED 100005 business C/O SHRM Trustees (BVI) Limited, Road Town, Tortola VG VG1110
100006.addresses.0 PALMCO POWER MA LLC 100006 registered C/O CORPORATION SERVICE COPMANY, BOSTON US 02109
100006.addresses.1 PALMCO POWER MA LLC 100006 business 40 HINGHAM ST., ROCKLAND US 02370
100007.addresses.0 A & T Invest Holding ApS 100007 registered Zicavej 19, Klampenborg DK 2930
100007.addresses.1 A & T Invest Holding ApS 100007 business Zicavej 19, Klampenborg DK 2930
100008.addresses.0 Ypsicon Ab 100008 registered Bost 2, Helsinki FI 00250
100008.addresses.1 Ypsicon Ab 100008 business Bost 2, Helsinki FI 00250
100009.addresses.0 PATIO DRUMMOND LTÉE 100009 registered 8435 boul. Saint-Joseph, Drummondville CA J2A 3W8
100009.addresses.1 PATIO DRUMMOND LTÉE 100009 business 8435 boul. Saint-Joseph, Drummondville CA J2A 3W8
10001.addresses.0 MIDOCEAN SELECT FLOATING RATE FUND, LP 10001 registered C/O MAPLES FIDUCIARY SERVICES (DELAWARE) INC., WILMINGTON US 19807
10001.addresses.1 MIDOCEAN SELECT FLOATING RATE FUND, LP 10001 business MidOcean Partners, New York US 10022
100010.addresses.0 REVERSE MORTGAGE FUNDING LLC 100010 registered C/O CORPORATE CREATIONS NETWORK INC., WILMINGTON US 19810
100010.addresses.1 REVERSE MORTGAGE FUNDING LLC 100010 business 1455 Broad Street, Bloomfield US 07003
100011.addresses.0 Metropolitan Life Insurance Company - MetLife Separate Account No. 429 100011 registered 200 Park Avenue, New York US 10166
100011.addresses.1 Metropolitan Life Insurance Company - MetLife Separate Account No. 429 100011 business C/O Metropolitan Life Insurance Company - MetLife Separate Account No. 429, New York US 10166
100012.addresses.0 WOODHILL CREATIVE 352, LLC 100012 registered C/O THOMAS L DAVIS, RICHARDSON US 75080
100012.addresses.1 WOODHILL CREATIVE 352, LLC 100012 business 9465 Wilshire Boulevard, Beverly Hills US 90212
100013.addresses.0 AIG AUSTRALIA LIMITED 100013 registered Level 19, 2 Park Street, SYDNEY AU 2000
100013.addresses.1 AIG AUSTRALIA LIMITED 100013 business Level 19, 2 Park Street, SYDNEY AU 2000
100014.addresses.0 OSI FOOD SOLUTIONS HUNGARY HÚSIPARI KORLÁTOLT FELELŐSSÉGŰ TÁRSASÁG 100014 registered SPORT UTCA 1., BÁBOLNA HU 2943
100014.addresses.1 OSI FOOD SOLUTIONS HUNGARY HÚSIPARI KORLÁTOLT FELELŐSSÉGŰ TÁRSASÁG 100014 business SPORT UTCA 1, BÁBOLNA HU 2943
100015.addresses.0 Invesco Global Property Plus Fund 100015 registered 37A, Avenue J-F. Kennedy, Luxembourg LU L-1855
100015.addresses.1 Invesco Global Property Plus Fund 100015 business C/O Invesco Real Estate Management S.a r.l, Luxembourg LU L-1855
100016.addresses.0 SPECIALTY METALS RESOURCES 100016 registered RUE DE TENBOSCH 42A, BRUSSELS BE 1050
100016.addresses.1 SPECIALTY METALS RESOURCES 100016 business RUE DE TENBOSCH 42A, BRUSSELS BE 1050
100017.addresses.0 CASELLA WINES PTY. LIMITED 100017 registered 193 YAMBIL STREET, GRIFFITH AU 2680
100017.addresses.1 CASELLA WINES PTY. LIMITED 100017 business 1471 Wakley Road, YENDA AU 2681
100018.addresses.0 Chess Capital AB 100018 registered C/O Stefan Sedersten, Hönö SE 475 42
100018.addresses.1 Chess Capital AB 100018 business C/O Stefan Sedersten, Hönö SE 475 42
100019.addresses.0 GEFLE MINUTHANDLAREFÖRENING 100019 registered C/O Halvards Livsmedel, Gävle SE 804 24
100019.addresses.1 GEFLE MINUTHANDLAREFÖRENING 100019 business C/O Halvards Livsmedel, Gävle SE 804 24
10002.addresses.0 Swedbank Robur Fastighet 10002 registered Landsvägen 40, Sundbyberg SE 172 63
10002.addresses.1 Swedbank Robur Fastighet 10002 business C/O Swedbank Robur Fonder AB, Sundbyberg SE 172 63
100020.addresses.0 COMPASS POWER GENERATION, L.L.C. 100020 registered C/O THE CORPORATION TRUST COMPANY, WILMINGTON US 19801
100020.addresses.1 COMPASS POWER GENERATION, L.L.C. 100020 business 591 West Putnam Avenue, Greenwich US 06830
100021.addresses.0 LOMACA ApS 100021 registered c/o Jan Rasmussen, Fuglegårdsvej 22 B, Gentofte DK 2820
100021.addresses.1 LOMACA ApS 100021 business c/o Jan Rasmussen, Fuglegårdsvej 22 B, Gentofte DK 2820
100022.addresses.0 ERB HELLAS (CAYMAN ISLANDS) LIMITED 100022 registered PO BOX 2681, CRICKET SQUARE HUTCHINGS DRIVE, GRAND CAYMAN, GEORGE TOWN KY KY1-1111
100022.addresses.1 ERB HELLAS (CAYMAN ISLANDS) LIMITED 100022 business PO BOX 2681, CRICKET SQUARE HUTCHINGS DRIVE, GRAND CAYMAN, GEORGE TOWN KY KY1-1111
100023.addresses.0 CALIFORNIA TOWNHOUSES LLC 100023 registered C/O JACK DAVIS, ASHLAND US 97520
100023.addresses.1 CALIFORNIA TOWNHOUSES LLC 100023 business 515 E MAIN STREET, ASHLAND US 97520
100024.addresses.0 Purpose Real Estate Income Fund 100024 registered 130 Adelaide Street West, Suite 3100, Toronto CA M5H 3P5
100024.addresses.1 Purpose Real Estate Income Fund 100024 business C/O Purpose Investments Inc., Toronto CA M5H 3P5
100025.addresses.0 THA-HOLDING APS 100025 registered C/O Torben Hedegaard Andersen, Copenhagen DK 2960
100025.addresses.1 THA-HOLDING APS 100025 business C/O Torben Hedegaard Andersen, Copenhagen DK 2960
100026.addresses.0 WILLIS EUROPE B.V. 100026 registered MARTEN MESSWEG 51, ROTTERDAM NL 3068 AV
100026.addresses.1 WILLIS EUROPE B.V. 100026 business 51 LIME STREET, LONDON GB EC3M 7DQ
100027.addresses.0 ELK THAMESVIEW LLC 100027 registered C/O CORPORATION SERVICE COMPANY, WILMINGTON US 19808
100027.addresses.1 ELK THAMESVIEW LLC 100027 business 489 Fifth Ave, 7th Floor, New York US 10017
1000274.addresses.0 GROUPE SOBER 1000274 registered 391 RUE DE L’AVENIR, SAINT-GEORGES-DE-RENEINS FR 69830
1000274.addresses.1 GROUPE SOBER 1000274 business 391 RUE DE L’AVENIR, SAINT-GEORGES-DE-RENEINS FR 69830
1000275.addresses.0 INTERNATIONAL FLAVORS & FRAGRANCES FRANCE HOLDING II 1000275 registered 61 RUE DE VILLIERS, NEUILLY-SUR-SEINE FR 92200
1000275.addresses.1 INTERNATIONAL FLAVORS & FRAGRANCES FRANCE HOLDING II 1000275 business 61 RUE DE VILLIERS, NEUILLY-SUR-SEINE FR 92200
1000276.addresses.0 MUTUASSUR CROISSANCE 1000276 registered 128 BD RASPAIL, PARIS 6 FR 75006
1000276.addresses.1 MUTUASSUR CROISSANCE 1000276 business C/O LA FRANCAISE ASSET MANAGEMENT, PARIS 6 FR 75006
1000277.addresses.0 ASSOCIATION INTERNATIONALE POUR LA PARTICIPATION FINANCIERE AIPF 1000277 registered 18 RUE DE CHAZELLES, PARIS FR 75017
1000277.addresses.1 ASSOCIATION INTERNATIONALE POUR LA PARTICIPATION FINANCIERE AIPF 1000277 business 18 RUE DE CHAZELLES, PARIS FR 75017
1000278.addresses.0 FACKELMANN FRANCE 1000278 registered 42 RUE DU 3 EME RTA, BUSSANG FR 88540
1000278.addresses.1 FACKELMANN FRANCE 1000278 business 42 RUE DU 3 EME RTA, BUSSANG FR 88540
1000279.addresses.0 LAGONISSI 1000279 registered 22 RUE CHARLES LAURENT, RENNES FR 35000
1000279.addresses.1 LAGONISSI 1000279 business 22 RUE CHARLES LAURENT, RENNES FR 35000
100028.addresses.0 Fiera North American Market Neutral Fund 100028 registered 200 Bay Street, Toronto CA M5J 2J1
100028.addresses.1 Fiera North American Market Neutral Fund 100028 business 1981 McGill College Avenue, Montreal CA H3A 0H5
1000280.addresses.0 COLUMBUS EM DEBT LONG DURATION 1000280 registered 6 PL DE LA PYRAMIDE, PUTEAUX FR 92800
1000280.addresses.1 COLUMBUS EM DEBT LONG DURATION 1000280 business C/O AXA INVESTMENT MANAGERS PARIS, PUTEAUX FR 92800
1000281.addresses.0 ELIOR PARTICIPATIONS 1000281 registered 9 ALLEE DE L'ARCHE, COURBEVOIE FR 92400
1000281.addresses.1 ELIOR PARTICIPATIONS 1000281 business 9 ALLEE DE L'ARCHE, COURBEVOIE FR 92400
1000282.addresses.0 BUDGET HOSPITALITY INVESTMENT 1000282 registered 57 RUE DE LA CHAUSSEE D'ANTIN, PARIS FR 75009
1000282.addresses.1 BUDGET HOSPITALITY INVESTMENT 1000282 business 57 RUE DE LA CHAUSSEE D'ANTIN, PARIS FR 75009
1000283.addresses.0 HARRI 1000283 registered ZONE DE PLANUYA, ARCANGUES FR 64200
1000283.addresses.1 HARRI 1000283 business ZONE DE PLANUYA, ARCANGUES FR 64200
1000284.addresses.0 QANOPI 1000284 registered 6 ROUTE DE GALLARDON, EPERNON FR 28230
1000284.addresses.1 QANOPI 1000284 business 6 ROUTE DE GALLARDON, EPERNON FR 28230
1000285.addresses.0 GROUPE MARONCELLI - P. ET J.C.M. 1000285 registered 1495 AVENUE D'ORANGE, SORGUES FR 84700
1000285.addresses.1 GROUPE MARONCELLI - P. ET J.C.M. 1000285 business 1495 AVENUE D'ORANGE, SORGUES FR 84700
1000286.addresses.0 SOMALOE 1000286 registered 16 QUAI DUGUAY-TROUIN, RENNES FR 35000
1000286.addresses.1 SOMALOE 1000286 business 16 QUAI DUGUAY-TROUIN, RENNES FR 35000

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]) 
   );