entity_addresses
5,142,408 rows sorted by _link descending
This data as json, CSV (advanced)
_link ▲ | _link_entity_statement | type | address | country | postcode |
---|---|---|---|---|---|
999999.addresses.1 | PROSPECT PLAZA IMPROVEMENTS, LLC 999999 | business | 565 Taxter Road, Elmsford | US | 10523 |
999999.addresses.0 | PROSPECT PLAZA IMPROVEMENTS, LLC 999999 | registered | C/O NATIONAL REGISTERED AGENTS, INC., WILMINGTON | US | 19801 |
999998.addresses.1 | STØRE INVEST AS 999998 | business | Trollåsveien 1B, Bodø | NO | 8011 |
999998.addresses.0 | STØRE INVEST AS 999998 | registered | Trollåsveien 1B, Bodø | NO | 8011 |
999997.addresses.1 | AQR DELTA OFFSHORE FUND V LTD. 999997 | business | C/O AQR Capital Management, LLC, Greenwich | US | 06830 |
999997.addresses.0 | AQR DELTA OFFSHORE FUND V LTD. 999997 | registered | C/O Ogier Global (Cayman) Limited, Camana Bay | KY | KY1-9009 |
999996.addresses.1 | Smedenman Förvaltnings AB 999996 | business | Box 9083, Jönköping | SE | 550 09 |
999996.addresses.0 | Smedenman Förvaltnings AB 999996 | registered | Box 9083, Jönköping | SE | 550 09 |
999995.addresses.1 | MainStay Funds Trust - MainStay Epoch International Small Cap Fund 999995 | business | 51 Madison Avenue, New York | US | 10010 |
999995.addresses.0 | MainStay Funds Trust - MainStay Epoch International Small Cap Fund 999995 | registered | C/O The Corporation Trust Company, Wilmington | US | 19801 |
999994.addresses.1 | AHA Huts LLC 999994 | business | 3340 Peachtree Road North East, Atlanta | US | 30326 |
999994.addresses.0 | AHA Huts LLC 999994 | registered | C/O Legalinc Corporate Services Inc., Pittsburgh | US | 15219 |
999993.addresses.1 | PREMIUM AQUA ApS 999993 | business | Herstedvang 3A, Albertslund | DK | 2620 |
999993.addresses.0 | PREMIUM AQUA ApS 999993 | registered | Herstedvang 3A, Albertslund | DK | 2620 |
999992.addresses.1 | CHJ Konsult AB 999992 | business | Laboratoriegatan 20, Göteborg | SE | 412 68 |
999992.addresses.0 | CHJ Konsult AB 999992 | registered | Laboratoriegatan 20, Göteborg | SE | 412 68 |
999991.addresses.1 | SEF ENERGI A/S 999991 | business | c/o Sydfyns Elforsyning, Postbox 187, Fåborgvej 44, Svendborg | DK | 5700 |
999991.addresses.0 | SEF ENERGI A/S 999991 | registered | C/O Sydfyns Elforsyning, Svendborg | DK | 5700 |
999990.addresses.1 | iShares SMIM® ETF (CH) 999990 | business | c/o BlackRock Asset Management Schweiz AG, Bahnhofstrasse 39, Zürich | CH | 8001 |
999990.addresses.0 | iShares SMIM® ETF (CH) 999990 | registered | Bahnhofstrasse 39, Zürich | CH | 8001 |
99999.addresses.1 | ALIX AM PTE. LTD. 99999 | business | PHILLIP STREET 3, Singapore | SG | 048693 |
99999.addresses.0 | ALIX AM PTE. LTD. 99999 | registered | PHILLIP STREET 3, Singapore | SG | 048693 |
999989.addresses.1 | Teza Digital LLC 999989 | business | 190 Elgin Avenue, George Town | KY | KY1-9001 |
999989.addresses.0 | Teza Digital LLC 999989 | registered | 190 Elgin Avenue, George Town | KY | KY1-9001 |
999988.addresses.1 | Zandén Läkarkonsult AB 999988 | business | Stenstigen 6a, Halmstad | SE | 302 40 |
999988.addresses.0 | Zandén Läkarkonsult AB 999988 | registered | Stenstigen 6a, Halmstad | SE | 302 40 |
999987.addresses.1 | Pennant Master Fund, L.P. 999987 | business | 1 Deforest Avenue, Summit | US | 07901 |
999987.addresses.0 | Pennant Master Fund, L.P. 999987 | registered | C/O Citi Hedge Fund Services (Cayman), Ltd., George Town | KY | KY1-1109 |
999986.addresses.1 | ST HILDA'S COLLEGE 999986 | business | COWLEY PLACE, OXFORD | GB | OX4 1DY |
999986.addresses.0 | ST HILDA'S COLLEGE 999986 | registered | COWLEY PLACE, OXFORD | GB | OX4 1DY |
999985.addresses.1 | Eagle Quants Macro Japan Unit Trust 999985 | business | 47 Hulfish Street, Princeton | US | 08542 |
999985.addresses.0 | Eagle Quants Macro Japan Unit Trust 999985 | registered | C/O CIBC Bank and Trust Company (Cayman) Limited, George Town | KY | KY1-1107 |
999984.addresses.1 | Edmond de Rothschild Prifund - Alpha Europa 999984 | business | 20, Boulevard Emmanuel Servais, Luxembourg | LU | L-2535 |
999984.addresses.0 | Edmond de Rothschild Prifund - Alpha Europa 999984 | registered | 20, Boulevard Emmanuel Servais, Luxembourg | LU | L-2535 |
999983.addresses.1 | Hadrian Greeley Delaware, LLC 999983 | business | 6199 East Princeton Circle, Englewood | US | 80111 |
999983.addresses.0 | Hadrian Greeley Delaware, LLC 999983 | registered | C/O Corporation Service Company, Wilmington | US | 19808 |
999982.addresses.1 | DWS FLEXPENSION - II 2029 999982 | business | C/O DWS Investment S.A., Luxembourg | LU | L - 1115 |
999982.addresses.0 | DWS FLEXPENSION - II 2029 999982 | registered | 2, Boulevard Konrad Adenauer, Luxembourg | LU | L - 1115 |
999981.addresses.1 | COMPUTER PARTS DENMARK ApS 999981 | business | Lundevej 8, Frederikshavn | DK | 9900 |
999981.addresses.0 | COMPUTER PARTS DENMARK ApS 999981 | registered | Lundevej 8, Frederikshavn | DK | 9900 |
999980.addresses.1 | JSS ApS 999980 | business | Ternevej 16, Ulfborg | DK | 6990 |
999980.addresses.0 | JSS ApS 999980 | registered | Ternevej 16, Ulfborg | DK | 6990 |
99998.addresses.1 | ENERGIA GROUP NI HOLDINGS LIMITED 99998 | business | GREENWOOD HOUSE, BELFAST | GB | BT9 5NF |
99998.addresses.0 | ENERGIA GROUP NI HOLDINGS LIMITED 99998 | registered | GREENWOOD HOUSE, BELFAST | GB | BT9 5NF |
999979.addresses.1 | TOPJOHN ApS 999979 | business | Helsingørsgade 23 C, Hillerød | DK | 3400 |
999979.addresses.0 | TOPJOHN ApS 999979 | registered | Helsingørsgade 23 C, Hillerød | DK | 3400 |
999978.addresses.1 | IA Clarington Inhance Monthly Income SRI Fund 999978 | business | 1080 Grande Allee O, Quebec | CA | G1S 1C7 |
999978.addresses.0 | IA Clarington Inhance Monthly Income SRI Fund 999978 | registered | 1080 Grande Allee O, Quebec | CA | G1S 1C7 |
999977.addresses.1 | AGETOR ApS 999977 | business | C/O Søren Nikolajsen, Frederiksberg | DK | 2000 |
999977.addresses.0 | AGETOR ApS 999977 | registered | C/O Søren Nikolajsen, Frederiksberg | DK | 2000 |
999976.addresses.1 | KVIST-ANDREASSEN APS 999976 | business | c/o Søren Peter Kvist, Dianavej 30, Rødovre | DK | 2610 |
999976.addresses.0 | KVIST-ANDREASSEN APS 999976 | registered | c/o Søren Peter Kvist, Dianavej 30, Rødovre | DK | 2610 |
999975.addresses.1 | AnPac Bio-Medical Science Co., Ltd. 999975 | business | C/O SHRM Trustees (BVI) Limited, Road Town | VG | VG1110 |
999975.addresses.0 | AnPac Bio-Medical Science Co., Ltd. 999975 | registered | C/O SHRM Trustees (BVI) Limited, Road Town | VG | VG1110 |
999974.addresses.1 | CP VII Coinvestment A Ontario, L.P. 999974 | business | 1001 Pennsylvania Avenue, N.W., 220 South, Washington | US | 20004 |
999974.addresses.0 | CP VII Coinvestment A Ontario, L.P. 999974 | registered | 199 Bay St., Commerce Ct. W., Toronto | CA | M5L 1B9 |
999973.addresses.1 | EUROFOIL FRANCE 999973 | business | RUE DU MOULIN A PAPIER, RUGLES | FR | 27250 |
999973.addresses.0 | EUROFOIL FRANCE 999973 | registered | RUE DU MOULIN A PAPIER, RUGLES | FR | 27250 |
999972.addresses.1 | Hellman & Friedman Capital Partners VII, L.P. 999972 | business | 415 Mission Street, San Francisco | US | 94105 |
999972.addresses.0 | Hellman & Friedman Capital Partners VII, L.P. 999972 | registered | 27 Hospital Road, George Town, Grand Cayman | KY | KY1-9008 |
999971.addresses.1 | AKTSIASELTS H.T. VALUUTA 999971 | business | LIIVALAIA TN 9, TALLINN | EE | 10118 |
999971.addresses.0 | AKTSIASELTS H.T. VALUUTA 999971 | registered | LIIVALAIA TN 9, TALLINN | EE | 10118 |
999970.addresses.1 | Mercury Schaumburg Limited Partnership 999970 | business | 1201 Mercury Drive, Schaumburg | US | 60193 |
999970.addresses.0 | Mercury Schaumburg Limited Partnership 999970 | registered | c/o Cogency Global Inc., Springfield | US | 62704 |
99997.addresses.1 | JENS SCHLIE INVEST APS 99997 | business | KYSTVEJEN 37, HIRTSHALS | DK | 9850 |
99997.addresses.0 | JENS SCHLIE INVEST APS 99997 | registered | KYSTVEJEN 37, HIRTSHALS | DK | 9850 |
999969.addresses.1 | MALNATI GROUP HOLDINGS, LLC 999969 | business | 3685 Woodhead Drive, Northbrook | US | 60062 |
999969.addresses.0 | MALNATI GROUP HOLDINGS, LLC 999969 | registered | C/O JOSHUA A KLEIN, CHICAGO | US | 60602 |
999968.addresses.1 | YELLOWSTONE CAYMAN LP 999968 | business | C/O MAPLES CORPORATE SERVICES LIMITED, GEORGE TOWN | KY | KY1-1104 |
999968.addresses.0 | YELLOWSTONE CAYMAN LP 999968 | registered | C/O MAPLES CORPORATE SERVICES LIMITED, GEORGE TOWN | KY | KY1-1104 |
999967.addresses.1 | 1790 POMONA ROAD 4 LLC 999967 | business | 4920 Campus Drive, Newport Beach | US | 92660 |
999967.addresses.0 | 1790 POMONA ROAD 4 LLC 999967 | registered | C/O CORPORATION SERVICE COMPANY WHICH WILL DO BUSINESS IN CALIFORNIA AS CSC - LAWYERS INCORPORATING, Sacramento | US | 95833 |
999966.addresses.1 | STATE STREET GLOBAL ADVISORS MUTUAL INVESTMENT FUND - SSGA GLOBAL INDEX REAL ESTATE MUTUAL FUND 999966 | business | STATE STREET FINANCIAL CENTER, BOSTON | US | 02111 |
999966.addresses.0 | STATE STREET GLOBAL ADVISORS MUTUAL INVESTMENT FUND - SSGA GLOBAL INDEX REAL ESTATE MUTUAL FUND 999966 | registered | C/O STATE STREET CUSTODIAL SERVICES (IRELAND) LIMITED, DUBLIN | IE | D02 RK57 |
999965.addresses.1 | PROS ISSUER PCC LIMITED 999965 | business | SUITE 6, ST PETER PORT | GG | GY1 2QE |
999965.addresses.0 | PROS ISSUER PCC LIMITED 999965 | registered | SUITE 6, ST PETER PORT | GG | GY1 2QE |
999964.addresses.1 | 1741 Asset Management Funds SICAV - Notenstein (Lux) Sustainable Bond International ex CHF 999964 | business | 11-13, boulevard de la Foire, Luxembourg | LU | L-1528 |
999964.addresses.0 | 1741 Asset Management Funds SICAV - Notenstein (Lux) Sustainable Bond International ex CHF 999964 | registered | 11-13, boulevard de la Foire, Luxembourg | LU | L-1528 |
999963.addresses.1 | GSO EUROPEAN SENIOR DEBT FUND II LP 999963 | business | PO Box 309, George Town | KY | KY1-1104 |
999963.addresses.0 | GSO EUROPEAN SENIOR DEBT FUND II LP 999963 | registered | C/O Maples Corporate Services Limited, George Town | KY | KY1-1104 |
999962.addresses.1 | Hymer Holding AB 999962 | business | Åkergränden 2, Lund | SE | 226 60 |
999962.addresses.0 | Hymer Holding AB 999962 | registered | Åkergränden 2, Lund | SE | 226 60 |
999961.addresses.1 | Jane ja Aatos Erkon säätiö sr 999961 | business | PL 144, HELSINKI | FI | FI-00131 |
999961.addresses.0 | Jane ja Aatos Erkon säätiö sr 999961 | registered | PL 144, HELSINKI | FI | FI-00131 |
999960.addresses.1 | MDM ENTERPRISES OF FARMINGTON, LLC 999960 | business | 2224 Pierce Creek Road, Binghamton | US | 13903 |
999960.addresses.0 | MDM ENTERPRISES OF FARMINGTON, LLC 999960 | registered | 2224 PIERCE CREEK ROAD, BINGHAMTON | US | 13903 |
99996.addresses.1 | ΕΞΤΡΑΚΟ ΕΚΡΗΚΤΙΚΑ ΚΑΙ ΧΗΜΙΚΑ ΠΡΟΪΟΝΤΑ ΑΝΩΝΥΜΗ ΕΜΠΟΡΙΚΗ ΒΙΟΜΗΧΑΝΙΚΗ ΚΑΙ ΤΕΧΝΙΚΗ ΕΤΑΙΡΕΙΑ 99996 | business | 3RD SEPTEMVRIOU 90, ATHENS | GR | 10434 |
99996.addresses.0 | ΕΞΤΡΑΚΟ ΕΚΡΗΚΤΙΚΑ ΚΑΙ ΧΗΜΙΚΑ ΠΡΟΪΟΝΤΑ ΑΝΩΝΥΜΗ ΕΜΠΟΡΙΚΗ ΒΙΟΜΗΧΑΝΙΚΗ ΚΑΙ ΤΕΧΝΙΚΗ ΕΤΑΙΡΕΙΑ 99996 | registered | 3RD SEPTEMVRIOU 90, ATHENS | GR | 10434 |
999959.addresses.1 | CUMULUS-INVEST ApS 999959 | business | Skodsborgparken 22, Skodsborg | DK | 2942 |
999959.addresses.0 | CUMULUS-INVEST ApS 999959 | registered | Skodsborgparken 22, Skodsborg | DK | 2942 |
999958.addresses.1 | Pioneer Global Sustainable Value Fund 999958 | business | C/O AMUNDI ASSET MANAGEMENT US, INC., WILMINGTON | US | 19801 |
999958.addresses.0 | Pioneer Global Sustainable Value Fund 999958 | registered | C/O Delaware Corporation Organizers, Inc., WILMINGTON | US | 19801 |
999957.addresses.1 | J.A.C. WINDOW, INC. 999957 | business | 122A E Foothill Blvd, Arcadia | US | 91006 |
999957.addresses.0 | J.A.C. WINDOW, INC. 999957 | registered | C/O TIFFANY SAKURADA, ARCADIA | US | 91006 |
999956.addresses.1 | Stockpile AB 999956 | business | Stadsnotariegatan 7, Vimmerby | SE | 598 35 |
999956.addresses.0 | Stockpile AB 999956 | registered | Stadsnotariegatan 7, Vimmerby | SE | 598 35 |
999955.addresses.1 | Eurizon Investment SICAV - Insurance Unit Euro Short Term Two 999955 | business | C/O Eurizon Capital S.A., Luxembourg | LU | L-1930 |
999955.addresses.0 | Eurizon Investment SICAV - Insurance Unit Euro Short Term Two 999955 | registered | 49, avenue J.F. Kennedy, Luxembourg | LU | L-1855 |
999954.addresses.1 | DAMIMA INVEST AS 999954 | business | c/o Business Village, Oslo | NO | 0250 |
999954.addresses.0 | DAMIMA INVEST AS 999954 | registered | c/o Business Village, Oslo | NO | 0250 |
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]) );