entity_statement
23 rows where "foundingdate" is on date 2013-11-08
This data as json, CSV (advanced)
Suggested facets: statementdate, name, publicationdetails_publicationdate, replacesstatements, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13337 | entityStatement | registeredEntity | 2013-11-08 | 18196126263945443641 | 2023-06-20 | false | BENU SK 35, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
15144 | entityStatement | registeredEntity | 2013-11-08 | 14661909772729302760 | 2023-06-20 | false | BENU SK 10, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
15649 | entityStatement | registeredEntity | 2013-11-08 | 1827864664162738874 | 2023-06-20 | false | BENU SK 39, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
16152 | entityStatement | registeredEntity | 2013-11-08 | 5448097368461721980 | 2023-06-20 | false | BENU SK 34, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
16954 | entityStatement | registeredEntity | 2013-11-08 | 11607142145960456975 | 2023-06-20 | false | BENU SK 33, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
17803 | entityStatement | registeredEntity | 2013-11-08 | 3816877680664720287 | 2023-06-20 | false | Scandoll, spol. s r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
19143 | entityStatement | registeredEntity | 2013-11-08 | 15584457508574189245 | 2023-06-20 | false | najdrevo s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
20987 | entityStatement | registeredEntity | 2013-11-08 | 11578140163721528819 | 2023-06-20 | false | MT CASTRUM s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
23197 | entityStatement | registeredEntity | 2013-11-08 | 1124499093958948455 | 2023-06-20 | false | DKT - STAV s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
23816 | entityStatement | registeredEntity | 2013-11-08 | 15086065396619748285 | 2023-06-20 | false | TOMPERA, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
24229 | entityStatement | registeredEntity | 2013-11-08 | 17751831287611339245 | 2023-06-20 | false | FLY PUB, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
24615 | entityStatement | registeredEntity | 2013-11-08 | 330496863402211943 | 2023-06-20 | false | TomaNet, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
27071 | entityStatement | registeredEntity | 2013-11-08 | 2772388717406982851 | 2023-06-20 | false | HORMAL NZ s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
34993 | entityStatement | registeredEntity | 2013-11-08 | 4100687321873743802 | 2023-06-20 | false | Pekáreň PODHORIE, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
38064 | entityStatement | registeredEntity | 2013-11-08 | 11689299494166101919 | 2023-06-20 | false | BENU SK 34, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 5448097368461721980 | ||
38388 | entityStatement | registeredEntity | 2013-11-08 | 17101786976732313928 | 2023-06-20 | false | BENU SK 10, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 14661909772729302760 | ||
38543 | entityStatement | registeredEntity | 2013-11-08 | 3007563505416912800 | 2023-06-20 | false | BENU SK 35, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 18196126263945443641 | ||
38549 | entityStatement | registeredEntity | 2013-11-08 | 3055164841692033862 | 2023-06-20 | false | BENU SK 39, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 1827864664162738874 | ||
38666 | entityStatement | registeredEntity | 2013-11-08 | 5131811224284883827 | 2023-06-20 | false | BENU SK 33, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 11607142145960456975 | ||
39654 | entityStatement | registeredEntity | 2013-11-08 | 5958631699871198543 | 2023-06-20 | false | Maki Works s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
46685 | entityStatement | registeredEntity | 2013-11-08 | 10347089904478960860 | 2024-03-02 | false | FLY PUB, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-03-02 | OpenOwnership Register | https://register.openownership.org | 17751831287611339245 | ||
5028 | entityStatement | registeredEntity | 2013-11-08 | 9668449579807997454 | 2023-06-20 | false | REDDING, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
5218 | entityStatement | registeredEntity | 2013-11-08 | 10903522965161197662 | 2023-06-20 | false | ZAPHIR 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]) );