entity_statement
10 rows where "foundingdate" is on date 2010-11-26 and incorporatedinjurisdiction_name = "Slovakia"
This data as json, CSV (advanced)
Suggested facets: statementdate, name, publicationdetails_publicationdate, replacesstatements, foundingdate (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12656 | entityStatement | registeredEntity | 2010-11-26 | 12880977221754921268 | 2023-06-20 | false | Poľnohospodárska spoločnosť, a.s. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
1654 | entityStatement | registeredEntity | 2010-11-26 | 4808041857101215434 | 2023-06-20 | false | B&MYstav s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
21910 | entityStatement | registeredEntity | 2010-11-26 | 2369479958508925832 | 2023-06-20 | false | Geometer, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
23414 | entityStatement | registeredEntity | 2010-11-26 | 12650311677504126446 | 2023-06-20 | false | Oak Invest s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
29093 | entityStatement | registeredEntity | 2010-11-26 | 16417954276412063461 | 2023-06-20 | false | AGM - TRADE s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
40131 | entityStatement | registeredEntity | 2010-11-26 | 3470965537158927019 | 2023-06-20 | false | FINE - STAV, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | |||
42469 | entityStatement | registeredEntity | 2010-11-26 | 16475769357075650363 | 2023-10-06 | false | UNIVENTA Žilina, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-10-06 | OpenOwnership Register | https://register.openownership.org | |||
43746 | entityStatement | registeredEntity | 2010-11-26 | 4281672755069366833 | 2023-11-01 | false | DMS - SERVICES s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-11-01 | OpenOwnership Register | https://register.openownership.org | |||
45900 | entityStatement | registeredEntity | 2010-11-26 | 15506817055391655851 | 2024-03-02 | false | UNIVENTA Žilina, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-03-02 | OpenOwnership Register | https://register.openownership.org | 16475769357075650363 | ||
9615 | entityStatement | registeredEntity | 2010-11-26 | 6495401524120439535 | 2023-06-20 | false | RegioJet a. s. | 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]) );