entity_statement
22 rows where foundingdate = "2011-04-20", iscomponent = "false" and "statementdate" is on date 2019-07-11
This data as json, CSV (advanced)
Suggested facets: foundingdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42282 | ad9c1210-bef7-4cf5-8bb1-12ddf318a203 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Crystal Real Estate" | 2011-04-20 | 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 | ||
| 42283 | 94aeadd2-6060-4861-96a6-96da25a4afcb | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GRĀMATVEDĪBAS STIPRINĀJUMI" | 2011-04-20 | 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 | ||
| 42284 | e63cc3c7-0a82-4b2e-be30-521a0e82d01b | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "JARDI.Treneri" | 2011-04-20 | 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 | ||
| 42285 | be8874bf-e097-4397-9d91-72d5b846f5c4 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MIKS-SKS" | 2011-04-20 | 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 | ||
| 42286 | 10603db0-3d41-42d3-862d-fa096233c0ef | entityStatement | 2019-07-11 | false | registeredEntity | SIA "MMInfo" | 2011-04-20 | 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 | ||
| 42288 | cd155cd8-0cd8-4d36-add9-4f703ece114e | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Orange city" | 2011-04-20 | 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 | ||
| 42289 | 216cf16d-50b4-4ce1-a970-415512da17a2 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "MAXTRADE LOGISTIC" | 2011-04-20 | 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 | ||
| 42290 | c20e2dc5-c057-49b4-b667-3a7bd273e749 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Partners for Progress" | 2011-04-20 | 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 | ||
| 42291 | 87539d23-920c-4643-b9eb-67a76d7ffb1e | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RE68" | 2011-04-20 | 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 | ||
| 42293 | 07482072-701f-4599-aa88-c6cf843c2adb | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Alta BS" | 2011-04-20 | 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 | ||
| 42294 | 597a7757-7990-450b-8b8d-6ed5477cffda | entityStatement | 2019-07-11 | false | registeredEntity | SIA "TIRGO" | 2011-04-20 | 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 | ||
| 42297 | c45c4ede-dfcf-404f-ab28-fd9b9937ea16 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "The Wunderbar" | 2011-04-20 | 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 | ||
| 42298 | e966c3d0-eef5-4c1f-83c6-f96194d7460f | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Bizart" | 2011-04-20 | 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 | ||
| 42299 | 5e4515f2-bde8-49d3-ad96-3deb841dae62 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "RM SERVICE" | 2011-04-20 | 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 | ||
| 42300 | 9ab3711c-3326-443c-8725-3699dd5d5126 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KRAIWI IT" | 2011-04-20 | 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 | ||
| 42303 | b033e548-3fe2-4759-b471-aa5e41d7d586 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "KM BIROJS" | 2011-04-20 | 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 | ||
| 42304 | 6be8303e-b503-4d55-be8b-8d1add822e53 | entityStatement | 2019-07-11 | false | registeredEntity | "AP DBA" SIA | 2011-04-20 | 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 | ||
| 42306 | 30d0e596-a07c-4c29-a46a-1aa97b95c314 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Libco lv" | 2011-04-20 | 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 | ||
| 42307 | d339eb18-0137-46e2-afaa-f57b7f3a0109 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Industrial Smart Technology" | 2011-04-20 | 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 | ||
| 42308 | 3eecd934-1033-43c9-8947-6c481a29b207 | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ALIPE 74" | 2011-04-20 | 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 | ||
| 42309 | 21ee04c9-6677-4959-9d7b-20b4a461d711 | entityStatement | 2019-07-11 | false | registeredEntity | SIA "Providence Ltd." | 2011-04-20 | 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 | ||
| 42311 | c4972e71-adc4-4923-a8c9-93b205821bfd | entityStatement | 2019-07-11 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "PROPERTIES SUPPORT" | 2011-04-20 | 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 |
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]) );