entity_statement
7 rows where foundingdate = "2012-12-17", iscomponent = "false" and "publicationdetails_publicationdate" is on date 2021-01-19
This data as json, CSV (advanced)
Suggested facets: statementdate
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101065 | 8c2cb778-1c98-4417-8f88-f4ac22f2995b | entityStatement | 2018-06-26 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "ArchiJazz" | 2012-12-17 | 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 | ||
| 110255 | 1af54107-1948-4223-add1-87f8eefde7e4 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Buduars.lv" | 2012-12-17 | 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 | ||
| 91260 | 3b899c21-9bdc-45cf-a65a-9afe3a0754fe | entityStatement | 2019-07-15 | false | registeredEntity | SIA "Bāliņi IMTK" | 2012-12-17 | 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 | ||
| 95919 | 503c833b-41c3-4cb8-8860-baff00f5a8b1 | entityStatement | 2019-03-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BALTIJAS NOLIKTAVU SERVISS" | 2012-12-17 | 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 | ||
| 95920 | ba455252-f38e-4e8f-a76e-5903a498ee2d | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "GEZ" | 2012-12-17 | 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 | ||
| 95921 | 1d9a9368-c993-47fc-bca2-78aff0f4ba23 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "NL BAUDA" | 2012-12-17 | 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 | ||
| 95922 | b6e82bfd-8a79-4a92-a02a-ebbe464e4453 | entityStatement | 2018-11-27 | false | registeredEntity | SIA "RIAR15" | 2012-12-17 | 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]) );