entity_statement
4 rows where "dissolutiondate" is on date 2024-01-05
This data as json, CSV (advanced)
Suggested facets: foundingdate (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44794 | entityStatement | registeredEntity | 2011-12-06 | 12119721527364115475 | 2024-03-02 | false | gpe, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-03-02 | OpenOwnership Register | https://register.openownership.org | 2024-01-05 | 6911831086090934411 | |
44928 | entityStatement | registeredEntity | 1994-11-16 | 9763223202586663697 | 2024-03-02 | false | Donau farm Váhovce, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-03-02 | OpenOwnership Register | https://register.openownership.org | 2024-01-05 | 6787851462600613228 | |
44999 | entityStatement | registeredEntity | 1992-02-25 | 4565638614551768104 | 2024-03-02 | false | Donau farm Bellova, s.r.o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-03-02 | OpenOwnership Register | https://register.openownership.org | 2024-01-05 | 5631515681584812232 | |
45058 | entityStatement | registeredEntity | 1996-06-06 | 16676840130073880906 | 2024-03-02 | false | Donau farm Malý Háj, s. r. o. | SK | Slovakia | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-03-02 | OpenOwnership Register | https://register.openownership.org | 2024-01-05 | 14165560322926063084 |
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]) );