entity_statement

15 rows where "foundingdate" is on date 2013-11-14, incorporatedinjurisdiction_code = "SK" and statementdate = "2023-06-20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, replacesstatements, foundingdate (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
11840 entityStatement registeredEntity 2013-11-14 6647198217113288714 2023-06-20 false Janapharm s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
14919 entityStatement registeredEntity 2013-11-14 12900559388557770169 2023-06-20 false JMS Press, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
17198 entityStatement registeredEntity 2013-11-14 14058262644064547896 2023-06-20 false Dr. ATTILA BOKOR, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
17327 entityStatement registeredEntity 2013-11-14 15390043017358739394 2023-06-20 false AKH & PARTNERS s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
19558 entityStatement registeredEntity 2013-11-14 1866348511308387388 2023-06-20 false MIGOmédiá s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
20035 entityStatement registeredEntity 2013-11-14 5100763301824712893 2023-06-20 false ZANAK s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
23000 entityStatement registeredEntity 2013-11-14 10070020978216197035 2023-06-20 false RESTAURATOR s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
24148 entityStatement registeredEntity 2013-11-14 17288355300327812647 2023-06-20 false VEXSI s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
28542 entityStatement registeredEntity 2013-11-14 12760303747499644724 2023-06-20 false Vinnay s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
32238 entityStatement registeredEntity 2013-11-14 4393925927102745528 2023-06-20 false ProPharma Group s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
37767 entityStatement registeredEntity 2013-11-14 8191431936155370387 2023-06-20 false Projman s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
38407 entityStatement registeredEntity 2013-11-14 17459621370960274831 2023-06-20 false TOP SERVICES, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org   127251812228362214  
4260 entityStatement registeredEntity 2013-11-14 5028219713946094944 2023-06-20 false NORVA, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
5697 entityStatement registeredEntity 2013-11-14 13929132362124256460 2023-06-20 false ADL Gemer, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
8196 entityStatement registeredEntity 2013-11-14 127251812228362214 2023-06-20 false TOP SERVICES, 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]) 
);