entity_statement
12 rows where foundingdate = "2017-06-30", "foundingdate" is on date 2017-06-30 and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: statementdate, statementdate (date), foundingdate (date), publicationdetails_publicationdate (date)
| _link ▼ | statementid | statementtype | statementdate | iscomponent | entitytype | name | foundingdate | incorporatedinjurisdiction_name | incorporatedinjurisdiction_code | publicationdetails_publicationdate | publicationdetails_bodsversion | publicationdetails_license | publicationdetails_publisher_name | publicationdetails_publisher_url | source_type | unspecifiedentitydetails_reason | unspecifiedentitydetails_description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111668 | 3f2d2008-7495-453d-b248-8d2c65c89461 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LG grāmatvedības birojs" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77971 | 5032fbe8-3dd5-471c-8c8a-3ea6f98edabb | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TYREX" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77972 | 00d9e4f6-a93a-4eb5-b1dd-c7cf4fefa191 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "COGNISENSU" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77973 | 4b619ef8-bd88-4662-8c55-8709c1b543c5 | entityStatement | false | registeredEntity | SIA "LUX meble" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | |||
| 77974 | 8f10c303-97da-436d-a911-6d141f1f4649 | entityStatement | 2019-10-24 | false | registeredEntity | SIA "EKA Tours" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77975 | 6655d557-311e-4ce3-a2e3-64f9916f0e80 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrības ar ierobežotu atbildību "BrainsCloud" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77976 | 1036dba6-abdb-4fdc-ba22-0ed880aa449c | entityStatement | 2019-07-14 | false | registeredEntity | SIA "KBLV Law Firm" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77977 | 200ec2f2-f972-47f4-93c9-543abf936835 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību CONMODUS | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77978 | 3a6c3813-4af6-42ce-bb5f-f331aa4e69dc | entityStatement | 2019-07-14 | false | registeredEntity | "CELT Alianse" SIA | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 77979 | b7bb2805-2c7c-4045-9387-025dc7b0874e | entityStatement | 2019-02-04 | false | registeredEntity | SIA GERLIONTI | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 92248 | ccf9e911-99de-456b-bfe9-2274152d0de1 | entityStatement | 2018-06-05 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MILENIALS" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister | ||
| 96918 | 02910c3d-7f48-4b89-ac87-5d904e99f268 | entityStatement | 2019-10-03 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "One Stop Service" | 2017-06-30 | Latvia | LV | 2021-01-19 | 0.2 | http://creativecommons.org/publicdomain/zero/1.0/ | The Register of Enterprises of the Republic of Latvia | https://www.ur.gov.lv/ | selfDeclaration,officialRegister |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [entity_statement] ( [_link] TEXT , [statementid] TEXT , [statementtype] TEXT , [statementdate] TEXT , [iscomponent] BOOL , [entitytype] TEXT , [name] TEXT , [foundingdate] TEXT , [incorporatedinjurisdiction_name] TEXT , [incorporatedinjurisdiction_code] TEXT , [publicationdetails_publicationdate] TEXT , [publicationdetails_bodsversion] TEXT , [publicationdetails_license] TEXT , [publicationdetails_publisher_name] TEXT , [publicationdetails_publisher_url] TEXT , [source_type] TEXT , [unspecifiedentitydetails_reason] TEXT , [unspecifiedentitydetails_description] TEXT , PRIMARY KEY ([_link]) );