entity_statement
34 rows where "foundingdate" is on date 2012-04-03, incorporatedinjurisdiction_name = "Latvia" and iscomponent = "false"
This data as json, CSV (advanced)
Suggested facets: publicationdetails_publicationdate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47755 | 9276edc5-41f2-4d42-ae4a-cffd4138df83 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "YAM 8" | 2012-04-03 | 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 | ||
| 47756 | e7e09c0c-434a-4a38-9471-590ddb841cf5 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Novapack" | 2012-04-03 | 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 | ||
| 47757 | de9957c6-1b25-48ab-a430-7b750012dd12 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "OGRESA" | 2012-04-03 | 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 | ||
| 47758 | c3512d8e-b7e8-4e52-b579-7692a1ca5150 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Sense Works" | 2012-04-03 | 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 | ||
| 47759 | fffb7cb1-7652-4c8f-aef4-ff99fbf16afc | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LUFTEKO" | 2012-04-03 | 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 | ||
| 47760 | 49c5f217-8188-42a1-a0ea-6cf53c8c4a8f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Avanti JT" | 2012-04-03 | 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 | ||
| 47761 | 1386e29f-3a41-4b0a-becb-41d772dc235b | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību REAL SERVICE | 2012-04-03 | 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 | ||
| 47762 | 10bdc300-29d6-4582-ac3b-fcb52b395821 | entityStatement | 2020-07-28 | false | registeredEntity | SIA "PETRA PLUSS" | 2012-04-03 | 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 | ||
| 47763 | 848e04f4-8e00-4a15-9bf2-3748865ac2c1 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Solid base consult" | 2012-04-03 | 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 | ||
| 47764 | 979a8ae6-04fc-49ed-bf90-bdaa70f8b8f3 | entityStatement | 2019-07-12 | false | registeredEntity | SIA "EvroVak" | 2012-04-03 | 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 | ||
| 47765 | 71318ee2-776f-4146-b84c-2a1d1d4c6c9d | entityStatement | 2017-12-19 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "FAVORĪTS RĪGA" | 2012-04-03 | 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 | ||
| 47766 | 7ead99a5-d470-4a58-8ecb-99d2e0d449df | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LERGO" | 2012-04-03 | 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 | ||
| 47767 | 22ff1a00-5baf-4cf0-8890-8d9c1f5635f3 | entityStatement | 2019-07-15 | false | registeredEntity | "OZOLIŅI AK" SIA | 2012-04-03 | 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 | ||
| 47768 | 214f155b-ed74-43f3-b7ce-9870d9b88f70 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "BŪVBALSTS" | 2012-04-03 | 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 | ||
| 47769 | ea279e04-b868-46b7-9ed2-3700f5e7ffe6 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "LD.NI" | 2012-04-03 | 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 | ||
| 47770 | f34828d7-e927-4e38-ad67-98840a8c9d91 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "VersoTec" | 2012-04-03 | 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 | ||
| 47771 | 575bd66d-a28a-419b-acc7-ea2e2838ffb2 | entityStatement | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LastDress" | 2012-04-03 | 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 | |||
| 47772 | 91b3ddfb-1fee-4e0b-9041-45a9df4f0fb1 | entityStatement | 2019-07-22 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "A.F. FASĀDES" | 2012-04-03 | 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 | ||
| 47773 | 9105418e-071e-44d4-a87d-0cd0ddbaa2e8 | entityStatement | 2020-01-23 | false | registeredEntity | SIA "Metropol Hotel Riga" | 2012-04-03 | 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 | ||
| 47774 | 4b74cd8c-3059-478c-ae3e-bab6c1226b16 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "HP Auto" | 2012-04-03 | 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 | ||
| 47775 | e961b931-8774-4739-8d22-4e6ded84bd15 | entityStatement | 2019-11-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KOMBITRA" | 2012-04-03 | 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 | ||
| 47776 | a055286c-a25c-422d-889a-ef4aea03ed25 | entityStatement | 2018-03-08 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Favorit Rent" | 2012-04-03 | 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 | ||
| 47777 | 4ca489b3-317c-4f52-b08d-c95153ca2c19 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SV Centr" | 2012-04-03 | 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 | ||
| 47778 | 660656b0-1dd8-4b3e-be8a-6bd85b186c95 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "MY BAR" | 2012-04-03 | 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 | ||
| 47779 | 70553b05-a6cc-4cf9-994c-0c90291c679b | entityStatement | 2020-02-25 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PROJECT R & M" | 2012-04-03 | 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 | ||
| 47780 | aee48647-3bce-4072-984a-a287b1c6c7f3 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Bērnu celiņš" | 2012-04-03 | 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 | ||
| 47781 | bd893363-a39e-40cb-ad05-c40a3d823595 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SJ Line" | 2012-04-03 | 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 | ||
| 47782 | 472b9137-e5f4-4358-9bee-e2ae25e2395e | entityStatement | 2019-07-12 | false | registeredEntity | SIA "AK Studio" | 2012-04-03 | 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 | ||
| 47783 | 08e809ea-6678-49f3-a430-98f66e938b8f | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "IDM serviss" | 2012-04-03 | 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 | ||
| 47784 | c8e8f8e3-7091-41b0-b1b1-291b35fd490b | entityStatement | 2019-07-15 | false | registeredEntity | SIA "PRojectum" | 2012-04-03 | 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 | ||
| 47785 | 4437aed7-3636-4980-887b-931fd23f7418 | entityStatement | 2018-07-17 | false | registeredEntity | SIA "Devii" | 2012-04-03 | 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 | ||
| 781 | 5f07bcf2-f219-47cb-9a34-7602feb44451 | entityStatement | 2019-07-24 | false | registeredEntity | Ķeguma novada zemnieku saimniecība "Meža tiļķeni" | 2012-04-03 | 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 | ||
| 95723 | b040927b-d7e8-4103-88f7-ed0dc03c5f53 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "DUBNAS GRAUDI" | 2012-04-03 | 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 | ||
| 95724 | ed9ca80e-8443-4fee-bea3-ec20b6f15717 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Ozolkalni JS" | 2012-04-03 | 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]) );