entity_statement
11 rows where "foundingdate" is on date 2008-11-12, incorporatedinjurisdiction_code = "SK" and statementdate = "2023-06-20"
This data as json, CSV (advanced)
Suggested facets: name, publicationdetails_publicationdate, replacesstatements, foundingdate (date), statementdate (date), publicationdetails_publicationdate (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 | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12170 | entityStatement | registeredEntity | 2008-11-12 | 9142587623067260406 | 2023-06-20 | false | SkyToll, a. s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 14553 | entityStatement | registeredEntity | 2008-11-12 | 10217352934738820751 | 2023-06-20 | false | Nemocnica s poliklinikou Sv. Lukáša Galanta, a.s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 15049 | entityStatement | registeredEntity | 2008-11-12 | 13808365273006619026 | 2023-06-20 | false | POLYGEO, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 21946 | entityStatement | registeredEntity | 2008-11-12 | 2652893626345534258 | 2023-06-20 | false | PESTE s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 24619 | entityStatement | registeredEntity | 2008-11-12 | 3315122863445028377 | 2023-06-20 | false | ELTUR s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 11752304120262093216 | ||
| 27731 | entityStatement | registeredEntity | 2008-11-12 | 7212121394152254678 | 2023-06-20 | false | ELSAM, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 30486 | entityStatement | registeredEntity | 2008-11-12 | 9203125545283845740 | 2023-06-20 | false | VeGa solutions s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 35646 | entityStatement | registeredEntity | 2008-11-12 | 7785016184055691077 | 2023-06-20 | false | BANCO CASINO s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 40454 | entityStatement | registeredEntity | 2008-11-12 | 12153597970342345991 | 2023-06-20 | false | SkyToll, a. s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-09-05 | OpenOwnership Register | https://register.openownership.org | 9142587623067260406 | ||
| 8066 | entityStatement | registeredEntity | 2008-11-12 | 11752304120262093216 | 2023-06-20 | false | ELTUR s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 8491 | entityStatement | registeredEntity | 2008-11-12 | 14689882493695107759 | 2023-06-20 | false | K&P AGENCY 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]) );