entity_statement
9 rows where "foundingdate" is on date 2012-12-20, iscomponent = "false" and publicationdetails_publicationdate = "2021-01-19"
This data as json, CSV (advanced)
Suggested facets: statementdate, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105365 | 06124dba-0ef4-436c-bccc-208031d242d2 | entityStatement | 2019-07-16 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību SALRIS | 2012-12-20 | 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 | ||
110258 | 4a415d9d-cb31-4cd2-a23b-fc7a9d3d9282 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Vivejas Epiņas ģimenes ārsta prakse" | 2012-12-20 | 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 | ||
110259 | 737430f8-ffef-4fe5-b4f3-f111518619d7 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "A. Veržbicka ārsta prakse" | 2012-12-20 | 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 | ||
110260 | a0a7e9ef-9b44-47cb-901e-266ce751a1d4 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Ligitas Igaunes ārsta prakse neiroloģijā" | 2012-12-20 | 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 | ||
110261 | 3fb6a2f3-f58a-4c18-acfe-36f3cdbd4863 | entityStatement | 2019-07-16 | false | registeredEntity | SIA "Elektro AJ" | 2012-12-20 | 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 | ||
91262 | 77790439-062f-4ace-be45-40c7e5e30769 | entityStatement | 2019-07-14 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Modra Autoskola" | 2012-12-20 | 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 | ||
91263 | 9574e3f1-ea64-4e37-b004-a6bfe4fbc672 | entityStatement | 2019-07-15 | false | registeredEntity | SIA "LD 1" | 2012-12-20 | 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 | ||
91264 | cb0572d4-7282-4ea0-ad36-ef2d6b99791e | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "EGO-L" | 2012-12-20 | 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 | ||
95926 | 184c6aaf-5242-4506-90a4-fd875b5c7627 | entityStatement | 2019-07-15 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Dzinējspēks" | 2012-12-20 | 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]) );