entity_statement
11 rows where foundingdate = "2005-04-07" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104646 | 491f57ea-aa37-4103-97e6-3362ac983ad3 | entityStatement | 2019-02-05 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Meža un lauku projekts" | 2005-04-07 | 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 | ||
| 108763 | e9775af5-e9b6-45b4-ba51-e33b59dd41aa | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Buvarī" | 2005-04-07 | 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 | ||
| 17781 | 90d88959-5088-46ea-a1ab-4f346f1fe29e | entityStatement | 2018-04-24 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BALTA TREND" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 17782 | aea27e15-f909-4e5d-89f3-6769af07be29 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MIGUNOVS un KO" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 17783 | 11de5c0a-be53-40cf-9491-e5d3cfdcdaf1 | entityStatement | 2019-07-10 | false | registeredEntity | SIA "ANTIQUE EMPIRE" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 17784 | fe92d730-25b6-4228-9ed8-6b46d10c8356 | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "AB konstrukcijas" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 17785 | e9e8076f-16a6-42ce-a35d-727d06442c6a | entityStatement | 2019-07-10 | false | registeredEntity | SIA "BŪVSTELLA" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 17786 | ff8d7eb0-feb1-4a7c-a779-ce8c7cf3e399 | entityStatement | 2019-07-10 | false | registeredEntity | SIA "Osmet" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 17787 | 30e467fe-f975-4b56-a5f3-a50093bcbcff | entityStatement | 2019-07-10 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "TIGEN" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 26687 | 6bf98c44-137a-4ce2-91a9-8928c3521729 | entityStatement | 2019-07-27 | false | registeredEntity | Nodibinājums "Sing Latvia" | 2005-04-07 | Latvia | LV | 2021-01-18 | 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 | ||
| 90217 | dbd7bfd0-68f6-4103-a7c5-85cee11a3adc | entityStatement | 2019-07-15 | false | registeredEntity | SIA "JĀŅUKALNI" | 2005-04-07 | 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]) );