entity_statement
36 rows where "foundingdate" is on date 2019-01-28
This data as json, CSV (advanced)
Suggested facets: statementdate, publicationdetails_publicationdate, statementdate (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102872 | 2b112eef-6973-4b06-a28c-977285ff448f | entityStatement | 2019-01-28 | false | registeredEntity | SIA "Produktivs" | 2019-01-28 | 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 | ||
102873 | 3e49230d-ce60-4239-802c-ed165f974c9f | entityStatement | 2019-01-28 | false | registeredEntity | SIA Lucrum V | 2019-01-28 | 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 | ||
102874 | ca12f88a-53e5-452c-abdf-49015bf3bd2c | entityStatement | 2019-01-28 | false | registeredEntity | YUKON SIA | 2019-01-28 | 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 | ||
102875 | fb94d4cf-600c-4e42-9554-edf45fa50ed2 | entityStatement | 2019-01-28 | false | registeredEntity | SIA "STILO" | 2019-01-28 | 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 | ||
102876 | 0c9bd111-a552-4a02-9d08-05cf5f78c51e | entityStatement | 2019-01-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "SAGOS" | 2019-01-28 | 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 | ||
102877 | b3002fe0-8b71-41bc-b638-5d18daf61e23 | entityStatement | 2019-01-28 | false | registeredEntity | SIA 4 Solution | 2019-01-28 | 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 | ||
102878 | e46b47d2-bdae-480a-8dd0-32b43cdc694e | entityStatement | 2019-01-28 | false | registeredEntity | SIA "Make and create" | 2019-01-28 | 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 | ||
112293 | aa05c5ac-c1c3-4385-b34d-b5ab8f0f9d85 | entityStatement | 2019-01-28 | false | registeredEntity | Pilnsabiedrība "LATBŪVNIEKS GROUP" | 2019-01-28 | 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 | ||
29269 | d8f1f341-8fd1-4bc6-96aa-54d4f64145cb | entityStatement | false | registeredEntity | "AJ Tennis Academy" | 2019-01-28 | 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 | |||
29270 | 5027c2d5-d5d3-45f2-93d1-9af39552de62 | entityStatement | false | registeredEntity | "Jūrmalas 1991.gada barikāžu dalībnieku biedrība" | 2019-01-28 | 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 | |||
29271 | 79242b47-b62e-48d8-b850-809ebe79e447 | entityStatement | 2019-01-28 | false | registeredEntity | JKK Lūšu ķepas | 2019-01-28 | 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 | ||
29272 | 733234fe-c206-4ba3-ad1b-85d2490d1ca8 | entityStatement | false | registeredEntity | "Rēzeknes 27AB" | 2019-01-28 | 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 | |||
87066 | 12600bdb-54f6-408e-b84f-d7bb6cf3889a | entityStatement | 2019-01-28 | false | registeredEntity | SIA Best Finance | 2019-01-28 | 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 | ||
87067 | c5cd31c7-0bc8-4a60-ae8a-43a8c8e6acbb | entityStatement | 2019-01-28 | false | registeredEntity | SIA Elrex | 2019-01-28 | 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 | ||
87068 | 48a9a0be-7fd4-4203-af83-54e647bf6cb7 | entityStatement | 2019-01-28 | false | registeredEntity | Riga Tennis Academy SIA | 2019-01-28 | 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 | ||
87069 | 95ffeb5a-c481-4257-9c8b-a57bcc6fc241 | entityStatement | 2020-03-17 | false | registeredEntity | SIA Deus Ex Machina Resulting | 2019-01-28 | 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 | ||
87070 | 83a2899d-2785-44f2-97e1-27c1a383cf9e | entityStatement | 2019-01-28 | false | registeredEntity | SIA Deadlift | 2019-01-28 | 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 | ||
87071 | f030493e-d93e-4743-9a34-7b638bcce299 | entityStatement | 2019-01-28 | false | registeredEntity | SIA "Ābols" | 2019-01-28 | 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 | ||
87072 | aa23b9d6-19e9-4b12-92ef-4a3b2a31c19f | entityStatement | 2019-01-28 | false | registeredEntity | Vivid SIA | 2019-01-28 | 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 | ||
87073 | b9f77126-0971-45a8-8f4d-a3868f505bdb | entityStatement | 2019-01-28 | false | registeredEntity | SIA "Activepark" | 2019-01-28 | 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 | ||
87074 | 47bc7b87-8175-4b6b-877d-ae9f54ca1d8c | entityStatement | 2019-01-28 | false | registeredEntity | SIA RCHBO | 2019-01-28 | 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 | ||
87075 | 7efb9fc2-e5e8-4671-8544-db473ed7f492 | entityStatement | 2019-01-28 | false | registeredEntity | SIA "SocialGuruLab" | 2019-01-28 | 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 | ||
87076 | 8fa26f12-f88b-4b71-a364-56871ed0e8f4 | entityStatement | 2019-01-28 | false | registeredEntity | SIA "Antares Key" | 2019-01-28 | 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 | ||
87077 | 689afb1b-3c59-410d-8179-13cfa5b62769 | entityStatement | 2019-01-28 | false | registeredEntity | SIA "ULTRA DENTAL" | 2019-01-28 | 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 | ||
87078 | de39e9d2-6935-48c4-9588-f1245ae0274a | entityStatement | 2019-01-28 | false | registeredEntity | SIA "Avia Engineering" | 2019-01-28 | 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 | ||
87079 | 407351a8-64d3-4fc7-a53d-b8a4efc1e1b2 | entityStatement | 2019-01-28 | false | registeredEntity | SIA "PROUDIS" | 2019-01-28 | 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 | ||
87080 | 2d62189b-c952-46eb-bc33-1b412198ae6e | entityStatement | 2019-01-28 | false | registeredEntity | SIA "FILMBOX" | 2019-01-28 | 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 | ||
87081 | 067bc365-043a-40f6-ae84-55966420613c | entityStatement | 2019-01-28 | false | registeredEntity | SIA Burnickis | 2019-01-28 | 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 | ||
87082 | 1d6e6b4c-bb0d-44b5-a4db-b0bc4ff4289f | entityStatement | 2019-01-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "Jonathan Incorporation" | 2019-01-28 | 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 | ||
87083 | b9177a55-bed3-4893-9857-5b7187f10d61 | entityStatement | 2019-01-28 | false | registeredEntity | SIA "Madara 76" | 2019-01-28 | 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 | ||
92656 | 6da6dc50-5cd6-408f-9677-fd992eebcd64 | entityStatement | 2020-12-15 | false | registeredEntity | SIA "Saimnieks VM" | 2019-01-28 | 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 | ||
92657 | c93e19e8-15b5-4a49-8d30-8b480bee0d99 | entityStatement | 2019-01-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "WARM WOOD" | 2019-01-28 | 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 | ||
92658 | e16e2d28-17bf-4cfb-a72b-3279b0a3f3fa | entityStatement | 2019-01-28 | false | registeredEntity | SIA "StrEC" | 2019-01-28 | 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 | ||
97355 | d37e2dfd-3901-41bc-83f4-9a3866e994a2 | entityStatement | 2019-01-28 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "RK Trans Trade LTD" | 2019-01-28 | 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 | ||
97356 | 65222977-2085-47f0-8559-1b91eb5b70f2 | entityStatement | 2020-12-18 | false | registeredEntity | Sabiedrība ar ierobežotu atbildību "BIS INFO" | 2019-01-28 | 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 | ||
97357 | 216149b0-50d3-4010-8c38-34736fe899ce | entityStatement | 2019-01-28 | false | registeredEntity | SIA Tonny | 2019-01-28 | 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]) );