entity_statement
36 rows where "foundingdate" is on date 2012-04-11
This data as json, CSV (advanced)
_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105230 | 34de526a-687d-4f56-b179-02a5a01545dc | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Kiči RC" | 2012-04-11 | 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 | ||
110056 | f28254ee-0544-4f24-9c73-488c1df3e7d4 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "eco-prof" | 2012-04-11 | 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 | ||
110057 | 1b0a1c5d-ce21-41ca-b617-60e4b03c12a6 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Camish" | 2012-04-11 | 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 | ||
110058 | 8475fd50-7448-4386-9731-a3391fdf3d9f | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SPAGO" | 2012-04-11 | 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 | ||
47848 | f2b90d63-94b7-4cc1-b501-cbbc0faf713c | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Monex TG" | 2012-04-11 | 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 | ||
47849 | bb16b3ae-e6b8-4298-8360-24d6e0202496 | entityStatement | 2019-06-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SPECIAL" | 2012-04-11 | 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 | ||
47850 | 86aaccb4-59b5-45f9-8a59-60cfc122813c | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Pm & D" | 2012-04-11 | 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 | ||
47851 | 79b31c9d-c6c1-46be-a60c-1599ddfcd3fe | entityStatement | 2019-07-15 | false | registeredEntity | SIA "D.M.SNEKKER" | 2012-04-11 | 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 | ||
47852 | 23cca3dd-2e65-4e37-8840-0d2e41736e7f | entityStatement | 2019-07-12 | false | registeredEntity | SIA "Riga Export Car" | 2012-04-11 | 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 | ||
47853 | 28b4f332-104a-428a-a09d-5769d1b9efee | entityStatement | 2018-12-17 | false | registeredEntity | SIA "STIKLS PLUS" | 2012-04-11 | 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 | ||
47854 | 669a959f-81db-49af-a72b-4b3a83548344 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PERFEKTS PLUSS" | 2012-04-11 | 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 | ||
47855 | 659e6c2c-5038-4aae-bf79-83828b60aadb | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "LUCKY DESTINY" | 2012-04-11 | 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 | ||
47856 | 7d9f6926-e327-40d2-b0df-d43512d44c40 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RAA projekti" | 2012-04-11 | 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 | ||
47857 | f167f03f-1a51-4d36-b93e-57bbc6d94583 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Kalna Dzirnavu HES" | 2012-04-11 | 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 | ||
47858 | 082e9684-473a-40d8-8554-909f876c4f5f | entityStatement | 2018-12-21 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "R.Evolution Strategy" | 2012-04-11 | 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 | ||
47859 | 14db84aa-ff47-440b-9b39-bee0182b334c | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Ošāres" | 2012-04-11 | 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 | ||
47860 | f087e619-8891-4b55-8153-ca4c0c3e1d9d | entityStatement | 2018-03-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "JV172 HOLDING" | 2012-04-11 | 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 | ||
47861 | e5d42564-8a55-4cea-b8e3-510275218683 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "HANZA CONSTRUCTION" | 2012-04-11 | 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 | ||
47862 | ece0f91a-98b9-427c-bb79-dc2a3dcf31b8 | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RAMODA" | 2012-04-11 | 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 | ||
47863 | 6aef2333-5fcc-4c6e-9a79-67026c44e9de | entityStatement | 2019-07-12 | false | registeredEntity | SIA "IRB" | 2012-04-11 | 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 | ||
47864 | 40377e10-b8cc-4f4b-81e4-c96bd994d07d | entityStatement | 2019-07-12 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KRZ" | 2012-04-11 | 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 | ||
47865 | e2fdefa7-dc20-49e8-85ed-33b260037bfe | entityStatement | 2019-07-12 | false | registeredEntity | Services Company Solution SIA | 2012-04-11 | 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 | ||
47866 | 42ddbf01-40cf-4864-963c-71342e08d9cb | entityStatement | 2019-07-12 | false | registeredEntity | SIA "KOD" | 2012-04-11 | 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 | ||
47867 | 45513d2c-ad30-41f2-9341-a92d73e2c7c8 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Alvus Lekto" | 2012-04-11 | 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 | ||
47868 | 857e6821-fc2a-47af-837e-f15722d3ce64 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EuRo Water" | 2012-04-11 | 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 | ||
47869 | af743bba-ff9c-446a-be1f-a8601581fbdd | entityStatement | 2019-07-12 | false | registeredEntity | "OpenDBA" SIA | 2012-04-11 | 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 | ||
47870 | 7417661b-91a8-4697-af46-4977dc63c8a3 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Auto Instalāciju Sistēmas" | 2012-04-11 | 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 | ||
47871 | 7443b8f3-6924-411e-9ceb-20a7eec19567 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "AMBIZIO" | 2012-04-11 | 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 | ||
47872 | e8e04706-9c51-41d3-9131-90d91518e893 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Frizētava Mūza" | 2012-04-11 | 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 | ||
47873 | f9fa759b-8add-4bb1-bf47-a5c42be17c4c | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Costume Studio" | 2012-04-11 | 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 | ||
47874 | 13968fe6-6083-469a-9ce1-5c80102c75e2 | entityStatement | 2019-11-25 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Baltic Select" | 2012-04-11 | 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 | ||
47875 | f007c6ad-86e9-42ee-8ce4-5636f2afc63e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "RK Baltic Export" | 2012-04-11 | 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 | ||
47876 | 048a0e2b-edee-4c44-8c4e-e1709cfe8514 | entityStatement | 2018-04-25 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Bulduru Investment" | 2012-04-11 | 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 | ||
47877 | e1c4bff5-272f-4cfb-940d-99e09ea6da84 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Airport City" | 2012-04-11 | 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 | ||
47878 | c35f578a-bace-4792-a81d-011cd4930825 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "ARS ART" | 2012-04-11 | 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 | ||
91124 | 54138478-c80c-4981-bb1c-53fe9cefef5e | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Kolters" | 2012-04-11 | 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]) );