entity_statement
7 rows where "dissolutiondate" is on date 2018-12-31 and "foundingdate" is on date 2008-01-01
This data as json, CSV (advanced)
_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108715 | entityStatement | registeredEntity | 2008-01-01 | 7673282175164043048 | 2023-06-20 | false | BFT Ejendomme I/S v/Bent Priess Østergaard og Finn Dons Sørensen og Tommy Otto Andersen | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2018-12-31 | ||
169597 | entityStatement | registeredEntity | 2008-01-01 | 11659733894792449836 | 2023-06-20 | false | Farvehandler Lauritz Thomas Nielsens Familielegat | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2018-12-31 | ||
215799 | entityStatement | registeredEntity | 2008-01-01 | 11917235858263775464 | 2023-06-20 | false | Dinesen Ejendomme I/S | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2018-12-31 | ||
26992 | entityStatement | registeredEntity | 2008-01-01 | 12515862402905169838 | 2023-06-20 | false | Kalkværksvej 2 + 4 I/S | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2018-12-31 | ||
341048 | entityStatement | registeredEntity | 2008-01-01 | 8478314892429974265 | 2023-06-21 | false | Tandlægerne i Tjele I/S | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-21 | OpenOwnership Register | https://register.openownership.org | 2018-12-31 | ||
6246 | entityStatement | registeredEntity | 2008-01-01 | 7602179965427235175 | 2023-06-20 | false | Theodora og Lars Møllers Legat | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2023-06-20 | OpenOwnership Register | https://register.openownership.org | 2018-12-31 | ||
707158 | entityStatement | registeredEntity | 2008-01-01 | 2778396446306003259 | 2024-04-07 | false | Theodora og Lars Møllers Legat | DK | Denmark | 0.2 | https://register.openownership.org/terms-and-conditions | 2024-04-07 | OpenOwnership Register | https://register.openownership.org | 2018-12-31 | 7602179965427235175 |
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]) );