entity_statement
11 rows where "foundingdate" is on date 2009-06-11, 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 | 
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12124 | entityStatement | registeredEntity | 2009-06-11 | 8775742552365222614 | 2023-06-20 | false | Ponton City a. s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 12878 | entityStatement | registeredEntity | 2009-06-11 | 14514777659159113532 | 2023-06-20 | false | BEMAX SK s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 17418 | entityStatement | registeredEntity | 2009-06-11 | 16398547788076927629 | 2023-06-20 | false | ZUZIK - MONT GEO, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 18568 | entityStatement | registeredEntity | 2009-06-11 | 11347228152136604551 | 2023-06-20 | false | Archaeoservices s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2022-12-06 | ||
| 23109 | entityStatement | registeredEntity | 2009-06-11 | 10744811638539429932 | 2023-06-20 | false | TM Invest Group s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 23491 | entityStatement | registeredEntity | 2009-06-11 | 13057812306365029802 | 2023-06-20 | false | MadNet Services, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 29348 | entityStatement | registeredEntity | 2009-06-11 | 18396612704216047410 | 2023-06-20 | false | MIBERAS, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 3426 | entityStatement | registeredEntity | 2009-06-11 | 16341569527874949224 | 2023-06-20 | false | ECOEN Slovakia, a.s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 39349 | entityStatement | registeredEntity | 2009-06-11 | 10947764231012169680 | 2023-06-20 | false | ECO -ENERGIA CONSULTING s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
| 41050 | entityStatement | registeredEntity | 2009-06-11 | 8839921839749778218 | 2023-06-20 | false | BEMAX SK s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-09-05 | OpenOwnership Register | https://register.openownership.org | 14514777659159113532 | ||
| 4736 | entityStatement | registeredEntity | 2009-06-11 | 8090805409314383290 | 2023-06-20 | false | GEMEX SLOVAKIA 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]) );