entity_statement
21 rows where "foundingdate" is on date 2010-01-21
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10998 | entityStatement | registeredEntity | 2010-01-21 | 16788705308465290831 | 2023-06-20 | false | TATRA SPC21, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
12755 | entityStatement | registeredEntity | 2010-01-21 | 13629961557263082244 | 2023-06-20 | false | SPAREX SK, spol. s r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
1440 | entityStatement | registeredEntity | 2010-01-21 | 3412967236568744492 | 2023-06-20 | false | Peron Slovakia, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
14637 | entityStatement | registeredEntity | 2010-01-21 | 10928220029794520243 | 2023-06-20 | false | TATRA SPC25, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
15478 | entityStatement | registeredEntity | 2010-01-21 | 1712473431952022355 | 2023-06-20 | false | TATRA SPC18, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
18739 | entityStatement | registeredEntity | 2010-01-21 | 12587422823103084358 | 2023-06-20 | false | REVITALSTAV SK s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 1635603113803811094 | ||
21774 | entityStatement | registeredEntity | 2010-01-21 | 17873748402019818420 | 2023-06-20 | false | DANCOV, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
23207 | entityStatement | registeredEntity | 2010-01-21 | 11295981825738359717 | 2023-06-20 | false | TATRA SPC23, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
24903 | entityStatement | registeredEntity | 2010-01-21 | 491631494156797486 | 2023-06-20 | false | MAPA Slovakia Digital s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2021-07-28 | ||
26357 | entityStatement | registeredEntity | 2010-01-21 | 1414196788160192402 | 2023-06-20 | false | PANDA - KOŠICE s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
29135 | entityStatement | registeredEntity | 2010-01-21 | 16764222570738923175 | 2023-06-20 | false | Peron Slovakia, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 3412967236568744492 | ||
3495 | entityStatement | registeredEntity | 2010-01-21 | 16758675348046134744 | 2023-06-20 | false | MONTASTAV SK s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
35883 | entityStatement | registeredEntity | 2010-01-21 | 9089990896881482899 | 2023-06-20 | false | Manima Servis s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
41355 | entityStatement | registeredEntity | 2010-01-21 | 3171620333149554340 | 2023-06-20 | false | REVITALSTAV SK s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-09-05 | OpenOwnership Register | https://register.openownership.org | 12587422823103084358 | ||
4983 | entityStatement | registeredEntity | 2010-01-21 | 9432705548274754143 | 2023-06-20 | false | Real MS-Stav, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
6505 | entityStatement | registeredEntity | 2010-01-21 | 2068267265434152591 | 2023-06-20 | false | BGM - impex, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
7296 | entityStatement | registeredEntity | 2010-01-21 | 6876763154448174583 | 2023-06-20 | false | TOMAD - predaj a spracovanie hutného materiálu, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
8217 | entityStatement | registeredEntity | 2010-01-21 | 12871387610747475305 | 2023-06-20 | false | TATRA SPC20, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
8702 | entityStatement | registeredEntity | 2010-01-21 | 1635603113803811094 | 2023-06-20 | false | REVITALSTAV SK s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
8759 | entityStatement | registeredEntity | 2010-01-21 | 16867118036555667150 | 2023-06-20 | false | TATRA SPC27, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
9315 | entityStatement | registeredEntity | 2010-01-21 | 4356813341322225611 | 2023-06-20 | false | JAVIL-služby 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]) );