entity_recordDetails_addresses

8,679,286 rows

✎ View and edit SQL

This data as json, CSV (advanced)

_link ▼ _link_entity_statement type address postcode country_name country_code
0.recordDetails.addresses.0 0 registered DON RAMON DE LA CRUZ 87 5 INTERIOR DERECHA, Madrid 28006 Spain ES
0.recordDetails.addresses.1 0 business CALLE OLOF PALME 1 BAJO, Murcia 30009 Spain ES
1.recordDetails.addresses.0 1 registered LG. PATARROA S/N BAJO, Viveiro 27861 Spain ES
1.recordDetails.addresses.1 1 business LG. PATARROA S/N BAJO, Viveiro 27861 Spain ES
10.recordDetails.addresses.0 10 registered ANDIA 2 2/9, Donostia/San Sebastián 20004 Spain ES
10.recordDetails.addresses.1 10 business ANDIA 2 2/9, Donostia/San Sebastián 20004 Spain ES
100.recordDetails.addresses.0 100 registered JESUS APRENDIZ 21, Madrid 28007 Spain ES
100.recordDetails.addresses.1 100 business JESUS APRENDIZ 21, Madrid 28007 Spain ES
1000.recordDetails.addresses.0 1000 registered 3 RUE JULES VERNE, CHAPONOST 69630 France FR
1000.recordDetails.addresses.1 1000 business 3 RUE JULES VERNE, CHAPONOST 69630 France FR
10000.recordDetails.addresses.0 10000 registered Munkagård 107, Morup 311 90 Sweden SE
10000.recordDetails.addresses.1 10000 business Munkagård 107, Morup 311 90 Sweden SE
100000.recordDetails.addresses.0 100000 registered Am Grünen Hof 6, Berlin, Berlin 13465 Germany DE
100000.recordDetails.addresses.1 100000 business Am Grünen Hof 6, Berlin, Berlin 13465 Germany DE
1000000.recordDetails.addresses.0 1000000 registered C/O REGISTERED AGENTS, INC., SUITE 100, AUSTIN, Texas 78731 United States US
1000000.recordDetails.addresses.1 1000000 business 1501 HALL JOHNSON RD, UNIT 1093, COLLEYVILLE, Texas 76034-2345 United States US
1000001.recordDetails.addresses.0 1000001 registered C/O UNITED AGENT GROUP INC., SUITE 201, WILMINGTON, Delaware 19803 United States US
1000001.recordDetails.addresses.1 1000001 business 260 East Brown Street, Suite 100, Birmingham, Michigan 48009 United States US
1000002.recordDetails.addresses.0 1000002 registered C/O THE CORPORATION TRUST COMPANY, 1209 ORANGE ST, WILMINGTON, Delaware 19801 United States US
1000002.recordDetails.addresses.1 1000002 business 6406 Ivy Lane, Suite 700, Greenbelt, Maryland 20770 United States US
1000003.recordDetails.addresses.0 1000003 registered House No 1379, Delhi, New Delhi, Delhi 110009 India IN
1000003.recordDetails.addresses.1 1000003 business Second Floor, Dr. Mukherjee Nagar, New Delhi, Delhi 110009 India IN
1000004.recordDetails.addresses.0 1000004 registered 1st Floor Bilkha Plaza, Opp. Mohanbhai hall, Rajkot, Gujarāt 360001 India IN
1000004.recordDetails.addresses.1 1000004 business 1st Floor Bilkha Plaza, Opp. Mohanbhai Hall, Rajkot, Gujarāt 360001 India IN
1000005.recordDetails.addresses.0 1000005 registered Orredalen 4, Sorumsand 1920 Norway NO
1000005.recordDetails.addresses.1 1000005 business Orredalen 4, Sorumsand 1920 Norway NO
1000006.recordDetails.addresses.0 1000006 registered OMC Chambers, Tortola, Road Town VG1110 Virgin Islands, British VG
1000006.recordDetails.addresses.1 1000006 business OMC Chambers, Tortola, Road Town VG1110 Virgin Islands, British VG
1000007.recordDetails.addresses.0 1000007 registered Thereses gate 35B, OSLO 0354 Norway NO
1000007.recordDetails.addresses.1 1000007 business Thereses gate 35B, OSLO 0354 Norway NO
1000008.recordDetails.addresses.0 1000008 registered Ritter House, Wickhams Cay II, Road Town VG1110 Virgin Islands, British VG
1000008.recordDetails.addresses.1 1000008 business Room 1202, Chaoyang District, Beijing, Beijing Shi 100020 China CN
1000009.recordDetails.addresses.0 1000009 registered C/O COGENCY GLOBAL INC., SUITE 201, DOVER, Delaware 19904 United States US
1000009.recordDetails.addresses.1 1000009 business 912 MANHATTAN AVENUE C4, MANHATTAN BEACH, California 90266 United States US
100001.recordDetails.addresses.0 100001 registered Spielberg 1, Eiselfing, Bayern 83549 Germany DE
100001.recordDetails.addresses.1 100001 business Spielberg 1, Eiselfing, Bayern 83549 Germany DE
1000010.recordDetails.addresses.0 1000010 registered Skuiveien 43, Voyenenga 1339 Norway NO
1000010.recordDetails.addresses.1 1000010 business Skuiveien 43, Voyenenga 1339 Norway NO
1000011.recordDetails.addresses.0 1000011 registered C/O CORPORATION SERVICE COMPANY, 251 LITTLE FALLS DRIVE, WILMINGTON, Delaware 19808 United States US
1000011.recordDetails.addresses.1 1000011 business 550 Newport Center Drive, Newport Beach, California 92660 United States US
1000012.recordDetails.addresses.0 1000012 registered Juan Vazquez de Mella 481, 2nd Floor, Meixico City, MX-CMX 11510 Mexico MX
1000012.recordDetails.addresses.1 1000012 business Sierra Gamon 120, piso 7 Miguel Hidalgo, Meixico City, MX-CMX 11000 Mexico MX
1000013.recordDetails.addresses.0 1000013 registered Abish Kekilbauly street, Bostandyk district, Almaty 050060 Kazakhstan KZ
1000013.recordDetails.addresses.1 1000013 business n.p. 12a, 77/7 Al Farabi Ave., Almaty, Almaty 050040 Kazakhstan KZ
1000014.recordDetails.addresses.0 1000014 registered c/o CORPORATION SERVICE COMPANY, 251 LITTLE FALLS DRIVE, WILMINGTON, Delaware 19808 United States US
1000014.recordDetails.addresses.1 1000014 business Two Newton Place, 255 Washington Street, Newton, Massachusetts 02458 United States US
1000015.recordDetails.addresses.0 1000015 registered c/o Aleman, Cordero, Galindo & Lee Trust (BVI) Limited, Road Town, Tortola VG1110 Virgin Islands, British VG
1000015.recordDetails.addresses.1 1000015 business 3rd floor, Yamraj Building, Road Town, Tortola VG1110 Virgin Islands, British VG
1000016.recordDetails.addresses.0 1000016 registered C/O CORPORATION SERVICE COMPANY, 251 LITTLE FALLS DRIVE, WILMINGTON, Delaware 19808 United States US
1000016.recordDetails.addresses.1 1000016 business C/O GRANITESHARES ADVISORS LLC, 251 LITTLE FALLS DRIVE, WILMINGTON, Delaware 19808 United States US
1000017.recordDetails.addresses.0 1000017 registered C/O Christos Gazeas, 240 Avenue SW, Calgary, Alberta T2P 4H4 Canada CA
1000017.recordDetails.addresses.1 1000017 business 5915 Airport Road, Suite 425, Mississauga, Ontario L4V 1T1 Canada CA
1000018.recordDetails.addresses.0 1000018 registered C/O Maples Corporate Services Limited, Ugland House, George Town KY1-1104 Cayman Islands KY
1000018.recordDetails.addresses.1 1000018 business PO Box 309, Ugland House, George Town KY1-1104 Cayman Islands KY
1000019.recordDetails.addresses.0 1000019 registered Level 4, 240 Queen Street, Brisbane, AU-QLD 4000 Australia AU
1000019.recordDetails.addresses.1 1000019 business Level 12, 1 Eagle Street, Brisbane, AU-QLD 4000 Australia AU
100002.recordDetails.addresses.0 100002 registered Ludwigstraße 60a, Homburg, Saarland 66424 Germany DE
100002.recordDetails.addresses.1 100002 business Ludwigstraße 60a, Homburg, Saarland 66424 Germany DE
1000020.recordDetails.addresses.0 1000020 registered NO - 48/4, 5, 2nd STREET, SURAMANGALAM, SALEM, Tamil Nādu 636005 India IN
1000020.recordDetails.addresses.1 1000020 business 47/r Dharmanagar, Suramangalam, Salem, Tamil Nādu 636005 India IN
1000021.recordDetails.addresses.0 1000021 registered 33, Rue du Puits Romain, Bertrange L-8070 Luxembourg LU
1000021.recordDetails.addresses.1 1000021 business 33, Rue du Puits Romain, Bertrange L-8070 Luxembourg LU
1000022.recordDetails.addresses.0 1000022 registered C/O INCORPORATING SERVICES, LTD., Suite 300, DOVER, Delaware 94133 United States US
1000022.recordDetails.addresses.1 1000022 business 535 Pacific Ave, Suite 300, San Francisco, California 94133 United States US
1000023.recordDetails.addresses.0 1000023 registered C/O CORPORATION SERVICE COMPANY, 251 LITTLE FALLS DRIVE, WILMINGTON, Delaware 19808 United States US
1000023.recordDetails.addresses.1 1000023 business One Town Center Road, Suite 600, Boca Raton, Florida 33486 United States US
1000024.recordDetails.addresses.0 1000024 registered C/O Equity Trust (BVI) Limited, Tortola, Road Town VG1110 Virgin Islands, British VG
1000024.recordDetails.addresses.1 1000024 business Schout bij Nacht Doormanweg 40, 2nd Floor, Willemstad 00000 Curaçao CW
1000025.recordDetails.addresses.0 1000025 registered c/o UNITED CORPORATE SERVICES, INC., Suite 304, Dover, Delaware 19901 United States US
1000025.recordDetails.addresses.1 1000025 business 140 Broadway, FL 38, New York, New York 10005 United States US
1000026.recordDetails.addresses.0 1000026 registered AKROPOLEOS 66, STROVOLOS, NICOSIA, Lefkosia 2012 Cyprus CY
1000026.recordDetails.addresses.1 1000026 business AKROPOLEOS 66, STROVOLOS, NICOSIA, Lefkosia 2012 Cyprus CY
1000027.recordDetails.addresses.0 1000027 registered Nanjing East Road, NO. 219, Taipei 104 Taiwan, Province of China TW
1000027.recordDetails.addresses.1 1000027 business Sec.3, Nanjing East Road, NO.219, Taipei 104 Taiwan, Province of China TW
1000028.recordDetails.addresses.0 1000028 registered Clifton House, 75 Fort Street, PO Box 1350, Grand Cayman KY1-1108 Cayman Islands KY
1000028.recordDetails.addresses.1 1000028 business Clifton House, 75 Fort Street, PO Box 1350, Grand Cayman KY1-1108 Cayman Islands KY
1000029.recordDetails.addresses.0 1000029 registered 287-289 route d'Arlon, Luxembourg, Luxembourg L-1150 Luxembourg LU
1000029.recordDetails.addresses.1 1000029 business C/O MUFG LUX Management Company S.A., 287-289, route d'Arlon, Luxembourg L-1150 Luxembourg LU
100003.recordDetails.addresses.0 100003 registered Am Graspoint 17, Rosenheim, Bayern 83026 Germany DE
100003.recordDetails.addresses.1 100003 business Am Graspoint 17, Rosenheim, Bayern 83026 Germany DE
1000030.recordDetails.addresses.0 1000030 registered c/o Carl Markestad, 1650 Putman Parkway, Milton, Wisconsin 53563 United States US
1000030.recordDetails.addresses.1 1000030 business 1650 Putman Pkwy, Milton, Wisconsin 53563 United States US
1000031.recordDetails.addresses.0 1000031 registered 4th Floor, Unit 401, Golf Course Extension Road, Gurugram, Haryāna 122011 India IN
1000031.recordDetails.addresses.1 1000031 business 4th Floor, Unit 401, Golf Course Extension Road, Gurugram, Haryāna 122011 India IN
1000032.recordDetails.addresses.0 1000032 registered 9 TEMASEK BOULEVARD, SUNTEC TOWER TWO, SINGAPORE, Central Singapore 038989 Singapore SG
1000032.recordDetails.addresses.1 1000032 business 33/F Three Pacific Place, 1 Queen's Road East, Hong Kong 999077 Hong Kong HK
1000033.recordDetails.addresses.0 1000033 registered C/O Harneys Corporate Services Limited, Tortola, Road Town VG1110 Virgin Islands, British VG
1000033.recordDetails.addresses.1 1000033 business Craigmuir Chambers, Tortola, Road Town VG1110 Virgin Islands, British VG
1000034.recordDetails.addresses.0 1000034 registered 1209 Orange Street, Wilmington, Delaware 19801 United States US
1000034.recordDetails.addresses.1 1000034 business C/O NexPoint Asset Management, L.P., 1209 Orange St, Wilmington, Delaware 19801 United States US
1000035.recordDetails.addresses.0 1000035 registered C/O Ogier Global (Cayman) Limited, Grand Cayman, Camana Bay KY1-9009 Cayman Islands KY
1000035.recordDetails.addresses.1 1000035 business C/O Tranquility Asset Management Co., Limited, 18 Harbour Road, Wanchai, Hong Kong 999077 Hong Kong HK
1000036.recordDetails.addresses.0 1000036 registered Suite 2700, 225 - 6Th Avenue SW, Calgary, Alberta T2P 1N2 Canada CA
1000036.recordDetails.addresses.1 1000036 business Suite 2700, 225 - 6Th Avenue SW, Calgary, Alberta T2P 1N2 Canada CA
1000037.recordDetails.addresses.0 1000037 registered C/O THE CORPORATION TRUST COMPANY, 1209 ORANGE ST, WILMINGTON, Delaware 19801 United States US
1000037.recordDetails.addresses.1 1000037 business C/O Massachusetts Financial Services Company, 111 Huntington Avenue, Boston, Massachusetts 02199 United States US
1000038.recordDetails.addresses.0 1000038 registered D- 13, Satlapur Growth Centre, New Industrial Area, Phase- II Mandideep, Raisen, Madhya Pradesh 462046 India IN
1000038.recordDetails.addresses.1 1000038 business D- 13, Satlapur Growth Centre, New Industrial Area, Phase- II Mandideep, Raisen, Madhya Pradesh 462046 India IN
1000039.recordDetails.addresses.0 1000039 registered C/O CORPORATION SERVICE COMPANY, 251 LITTLE FALLS DRIVE, WILMINGTON, Delaware 19808 United States US
1000039.recordDetails.addresses.1 1000039 business 1910 Fairview Ave East, Suite 200, Seattle, Washington 98102 United States US

Next page

Advanced export

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

CSV options: 

CREATE TABLE [entity_recordDetails_addresses] ( [_link] TEXT 
 , [_link_entity_statement] TEXT 
 , [type] TEXT 
 , [address] TEXT 
 , [postcode] TEXT 
 , [country_name] TEXT 
 , [country_code] TEXT 
 , PRIMARY KEY ([_link]) 
 , FOREIGN KEY ([_link_entity_statement]) REFERENCES [entity_statement]([_link]) 
   );