home / slovakia

entity_statement

10 rows where "foundingdate" is on date 2010-11-26 and incorporatedinjurisdiction_name = "Slovakia"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: statementdate, name, publicationdetails_publicationdate, replacesstatements, foundingdate (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
12656 entityStatement registeredEntity 2010-11-26 12880977221754921268 2023-06-20 false Poľnohospodárska spoločnosť, a.s. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
1654 entityStatement registeredEntity 2010-11-26 4808041857101215434 2023-06-20 false B&MYstav s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
21910 entityStatement registeredEntity 2010-11-26 2369479958508925832 2023-06-20 false Geometer, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
23414 entityStatement registeredEntity 2010-11-26 12650311677504126446 2023-06-20 false Oak Invest s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
29093 entityStatement registeredEntity 2010-11-26 16417954276412063461 2023-06-20 false AGM - TRADE s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
40131 entityStatement registeredEntity 2010-11-26 3470965537158927019 2023-06-20 false FINE - STAV, s. r. o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-06-20 OpenOwnership Register https://register.openownership.org      
42469 entityStatement registeredEntity 2010-11-26 16475769357075650363 2023-10-06 false UNIVENTA Žilina, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-10-06 OpenOwnership Register https://register.openownership.org      
43746 entityStatement registeredEntity 2010-11-26 4281672755069366833 2023-11-01 false DMS - SERVICES s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2023-11-01 OpenOwnership Register https://register.openownership.org      
45900 entityStatement registeredEntity 2010-11-26 15506817055391655851 2024-03-02 false UNIVENTA Žilina, s.r.o. SK Slovakia 0.2 https://register.openownership.org/terms-and-conditions 2024-03-02 OpenOwnership Register https://register.openownership.org   16475769357075650363  
9615 entityStatement registeredEntity 2010-11-26 6495401524120439535 2023-06-20 false RegioJet a. s. 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]) 
);
Powered by Datasette · Queries took 4282.49ms