entity_statement

15 rows where "foundingdate" is on date 1975-01-01, incorporatedinjurisdiction_code = "SK" and statementdate = "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
11523 entityStatement registeredEntity 1975-01-01 4170394461785493017 2023-06-20 false Poľnohospodárske družstvo Senica SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
11775 entityStatement registeredEntity 1975-01-01 6261939191593571689 2023-06-20 false Spoločné poľnohospodárske družstvo Veselé SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
12923 entityStatement registeredEntity 1975-01-01 14971580534088441503 2023-06-20 false PD Uhrovec, a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
14336 entityStatement registeredEntity 1975-01-01 8737910277694384889 2023-06-20 false PD „BREZINA“ PRAVOTICE, družstvo SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
14719 entityStatement registeredEntity 1975-01-01 11488079072034756 2023-06-20 false Poľnohospodárske družstvo Poriadie SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
14845 entityStatement registeredEntity 1975-01-01 12356129062669962523 2023-06-20 false PD Dolné Otrokovce s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
15859 entityStatement registeredEntity 1975-01-01 3345975917356253474 2023-06-20 false Poľnohospodárske družstvo Ludanice SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19621 entityStatement registeredEntity 1975-01-01 2219958432394397406 2023-06-20 false ROD Skalica, a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19669 entityStatement registeredEntity 1975-01-01 2575380440922198453 2023-06-20 false Poľnohospodárske družstvo Radošovce SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
21638 entityStatement registeredEntity 1975-01-01 16778371131653237159 2023-06-20 false Poľnohospodárske družstvo BEBRAVA SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
25150 entityStatement registeredEntity 1975-01-01 6415777134662062280 2023-06-20 false Roľnícke družstvo Petrova Ves, družstvo SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
26620 entityStatement registeredEntity 1975-01-01 15997289021582575986 2023-06-20 false Poľnohospodárske družstvo so sídlom v Žemberovciach SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
29826 entityStatement registeredEntity 1975-01-01 4939177753490153011 2023-06-20 false Poľnohospodárske družstvo Trenčianska Turná SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
36707 entityStatement registeredEntity 1975-01-01 15339605370079059591 2023-06-20 false Poľnohospodárske družstvo Žlkovce-Ratkovce SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
41411 entityStatement registeredEntity 1975-01-01 4901497776096916166 2023-06-20 false Spoločné poľnohospodárske družstvo Veselé SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-09-05 OpenOwnership Register https://register.openownership.org   6261939191593571689  

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