entity_statement
10 rows where iscomponent = "true" and "statementdate" is on date 2018-04-03
This data as json, CSV (advanced)
Suggested facets: incorporatedinjurisdiction_name, incorporatedinjurisdiction_code, statementdate (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114274 | 646e2cbb-afe9-4bab-9db0-ef573fcfdaab | entityStatement | 2018-04-03 | true | registeredEntity | C. Deilmann GmbH & Co. KG | Germany | DE | 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 | |||
| 114275 | b44fce21-55b0-47cd-ac39-fd3311ecd3ca | entityStatement | 2018-04-03 | true | registeredEntity | Deilmann-Montan GmbH | Germany | DE | 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 | |||
| 114276 | 8c34aa8d-7f91-4657-b2a3-3075c0882629 | entityStatement | 2018-04-03 | true | registeredEntity | Klasmann-Deilmann GmbH | Germany | DE | 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 | |||
| 114316 | d6283cca-a783-455c-bd09-f58ab35d7ada | entityStatement | 2018-04-03 | true | registeredEntity | Pest Chemical OU | Estonia | EE | 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 | |||
| 114317 | 97bd7eff-c16e-442a-9ebc-51582121a3a7 | entityStatement | 2018-04-03 | true | registeredEntity | Horticom OU | Estonia | EE | 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 | |||
| 114318 | d44dd059-3f79-4ce6-9768-df13b26f32fa | entityStatement | 2018-04-03 | true | registeredEntity | MKV Invest OU | Estonia | EE | 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 | |||
| 119184 | 169319c3-513b-49e7-addf-73c2b0ded122 | entityStatement | 2018-04-03 | true | registeredEntity | AS "Nilex Grupa" | 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 | |||
| 119185 | de7d23c4-a25e-4efb-9432-7cf6ddffc56e | entityStatement | 2018-04-03 | true | registeredEntity | Sabiedrība ar ierobežotu atbildību "Nilex trading" | 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 | |||
| 119531 | e4c6350b-3976-4ee6-bb8c-3cb6a7331a2f | entityStatement | 2018-04-03 | true | registeredEntity | Sabiedrība ar ierobežotu atbildību "STATS INVEST" | 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 | |||
| 119532 | 38929c71-9839-4221-963c-e5647ae29ff3 | entityStatement | 2018-04-03 | true | registeredEntity | Sabiedrība ar ierobežotu atbildību "Amber pines" | 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]) );