entity_statement
23 rows where "foundingdate" is on date 2011-02-22
This data as json, CSV (advanced)
Suggested facets: statementdate, name, publicationdetails_publicationdate, dissolutiondate, replacesstatements, statementdate (date), publicationdetails_publicationdate (date), dissolutiondate (date)
_link ▼ | statementtype | entitytype | foundingdate | statementid | statementdate | iscomponent | name | incorporatedinjurisdiction_code | incorporatedinjurisdiction_name | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publicationdate | publicationdetails_publisher_name | publicationdetails_publisher_url | dissolutiondate | replacesstatements | alternatenames |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10286 | entityStatement | registeredEntity | 2011-02-22 | 11120588663458166072 | 2023-06-20 | false | Dr.Max 15 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
10600 | entityStatement | registeredEntity | 2011-02-22 | 13511368766622782269 | 2023-06-20 | false | KK pharm, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
10865 | entityStatement | registeredEntity | 2011-02-22 | 15735203028087891514 | 2023-06-20 | false | Dr.Max 17 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
13114 | entityStatement | registeredEntity | 2011-02-22 | 16400833765566311321 | 2023-06-20 | false | KOVOSTAV SK, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
13771 | entityStatement | registeredEntity | 2011-02-22 | 4652742077169541837 | 2023-06-20 | false | Dr.Max 21 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
13881 | entityStatement | registeredEntity | 2011-02-22 | 532921383069397175 | 2023-06-20 | false | Dr.Max 7 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
14142 | entityStatement | registeredEntity | 2011-02-22 | 7329132985730582562 | 2023-06-20 | false | Dr.Max 28 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
17111 | entityStatement | registeredEntity | 2011-02-22 | 13229371034020837250 | 2023-06-20 | false | Dr.Max 12 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
17782 | entityStatement | registeredEntity | 2011-02-22 | 3636185421561341002 | 2023-06-20 | false | Dr.Max 6 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
18230 | entityStatement | registeredEntity | 2011-02-22 | 824233563634799694 | 2023-06-20 | false | Dr.Max 9 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
18732 | entityStatement | registeredEntity | 2011-02-22 | 12523796361860303744 | 2023-06-20 | false | EdgeCom, a. s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
22817 | entityStatement | registeredEntity | 2011-02-22 | 8822699319586854125 | 2023-06-20 | false | EdgeCom, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 12523796361860303744 | ||
25125 | entityStatement | registeredEntity | 2011-02-22 | 6268858454516624960 | 2023-06-20 | false | TORNSTAV s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 6089506124276594213 | ||
37769 | entityStatement | registeredEntity | 2011-02-22 | 8214393679652962200 | 2023-06-20 | false | Maximus Logistics s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
38697 | entityStatement | registeredEntity | 2011-02-22 | 5608783292567375483 | 2023-06-20 | false | ENERGOS, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
40531 | entityStatement | registeredEntity | 2011-02-22 | 13888897275877937361 | 2023-06-20 | false | EdgeCom, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-09-05 | OpenOwnership Register | https://register.openownership.org | 8822699319586854125 | ||
42986 | entityStatement | registeredEntity | 2011-02-22 | 10647308405065065652 | 2023-10-06 | false | DOOR Investment s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-10-06 | OpenOwnership Register | https://register.openownership.org | |||
43023 | entityStatement | registeredEntity | 2011-02-22 | 14020736482182909853 | 2023-10-06 | false | REAL MM, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-10-06 | OpenOwnership Register | https://register.openownership.org | |||
44705 | entityStatement | registeredEntity | 2011-02-22 | 4965061111567726204 | 2024-03-02 | false | KK pharm, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-03-02 | OpenOwnership Register | https://register.openownership.org | 13511368766622782269 | ||
7751 | entityStatement | registeredEntity | 2011-02-22 | 9459573123355523418 | 2023-06-20 | false | Giga Trade s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2020-02-15 | ||
9316 | entityStatement | registeredEntity | 2011-02-22 | 4358445349574174595 | 2023-06-20 | false | SERVIS OKNA, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
9564 | entityStatement | registeredEntity | 2011-02-22 | 6089506124276594213 | 2023-06-20 | false | TORNSTAV s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
9608 | entityStatement | registeredEntity | 2011-02-22 | 6438803697701903042 | 2023-06-20 | false | Dr.Max 23 s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [entity_statement] ( [_link] TEXT , [statementtype] TEXT , [entitytype] TEXT , [foundingdate] TIMESTAMP , [statementid] TEXT , [statementdate] TIMESTAMP , [iscomponent] BOOL , [name] TEXT , [incorporatedinjurisdiction_code] TEXT , [incorporatedinjurisdiction_name] TEXT , [publicationdetails_bodsversion] NUMERIC , [publicationdetails_license] TEXT , [publicationdetails_publicationdate] TIMESTAMP , [publicationdetails_publisher_name] TEXT , [publicationdetails_publisher_url] TEXT , [dissolutiondate] TIMESTAMP , [replacesstatements] TEXT , [alternatenames] TEXT , PRIMARY KEY ([_link]) );