entity_statement

18 rows where "foundingdate" is on date 2011-03-01 and "statementdate" is on date 2023-06-20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, publicationdetails_publicationdate, replacesstatements, 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
1001 entityStatement registeredEntity 2011-03-01 16799832698222745824 2023-06-20 false Forestland, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
12122 entityStatement registeredEntity 2011-03-01 8766213277221283741 2023-06-20 false Solarpark Myjava, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
12392 entityStatement registeredEntity 2011-03-01 10863915070378372330 2023-06-20 false Solarpark Polianka, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
13480 entityStatement registeredEntity 2011-03-01 2488517443709578669 2023-06-20 false Eleven Slovensko s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
13886 entityStatement registeredEntity 2011-03-01 5384517808897978565 2023-06-20 false Photon SK SPV 2 s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
18932 entityStatement registeredEntity 2011-03-01 14077125104176853777 2023-06-20 false J.I. Trade spol. s r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
24451 entityStatement registeredEntity 2011-03-01 2424208390939574236 2023-06-20 false Jacaranda promotion s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
27126 entityStatement registeredEntity 2011-03-01 3101928404213867644 2023-06-20 false RPK STAV, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
29486 entityStatement registeredEntity 2011-03-01 2779133756320582523 2023-06-20 false ECO Buildings s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
34112 entityStatement registeredEntity 2011-03-01 15962439439841751871 2023-06-20 false FINECARS s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
34534 entityStatement registeredEntity 2011-03-01 18302122759094387439 2023-06-20 false Enerline, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
36566 entityStatement registeredEntity 2011-03-01 14208104634116166650 2023-06-20 false GSYSTEM s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
40839 entityStatement registeredEntity 2011-03-01 430952860130052774 2023-06-20 false Photon SK SPV 2 s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   5384517808897978565  
41449 entityStatement registeredEntity 2011-03-01 585160277693353846 2023-06-20 false Solarpark Polianka, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   10863915070378372330  
41622 entityStatement registeredEntity 2011-03-01 11886134637615889260 2023-06-20 false Solarpark Myjava, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   8766213277221283741  
4419 entityStatement registeredEntity 2011-03-01 6044184783226727486 2023-06-20 false KLOGA s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
7657 entityStatement registeredEntity 2011-03-01 8878064507707871632 2023-06-20 false ORIOLA s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
9958 entityStatement registeredEntity 2011-03-01 8927745702322563173 2023-06-20 false Tlačiareň P+M, 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

CSV options: 

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]) 
);