entity_statement
10 rows where "foundingdate" is on date 2009-10-09, incorporatedinjurisdiction_code = "SK" and statementdate = "2023-06-20"
This data as json, CSV (advanced)
Suggested facets: name, publicationdetails_publicationdate, dissolutiondate, replacesstatements, foundingdate (date), 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 | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12642 | entityStatement | registeredEntity | 2009-10-09 | 12766552926679653007 | 2023-06-20 | false | VS Investment a.s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 14595 | entityStatement | registeredEntity | 2009-10-09 | 10580949730942740031 | 2023-06-20 | false | Liečebňa sv. Františka, a. s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 15701 | entityStatement | registeredEntity | 2009-10-09 | 2060340495495347329 | 2023-06-20 | false | PV Chyžné II., s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 15846 | entityStatement | registeredEntity | 2009-10-09 | 3269501112121685338 | 2023-06-20 | false | J & H ENERGY s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 25 | entityStatement | registeredEntity | 2009-10-09 | 1017877959942470812 | 2023-06-20 | false | HAGO s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2018-11-14 | ||
| 34286 | entityStatement | registeredEntity | 2009-10-09 | 16965503156450615262 | 2023-06-20 | false | VS stavby s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 38670 | entityStatement | registeredEntity | 2009-10-09 | 5203773781928448719 | 2023-06-20 | false | LARA SERVIS, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 41187 | entityStatement | registeredEntity | 2009-10-09 | 1291986920313040112 | 2023-06-20 | false | LARA SERVIS, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-09-05 | OpenOwnership Register | https://register.openownership.org | 5203773781928448719 | ||
| 41259 | entityStatement | registeredEntity | 2009-10-09 | 15644855577690634421 | 2023-06-20 | false | PV Chyžné II., s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-09-05 | OpenOwnership Register | https://register.openownership.org | 2060340495495347329 | ||
| 6768 | entityStatement | registeredEntity | 2009-10-09 | 3659815476545241639 | 2023-06-20 | false | Applipower, 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]) );