{"action":"elsewhere","city":"Tallinn","companyRegistrationNumber":null,"conformityFlag":"CONFORMING","country":"EE","createdAt":"2013-07-09T00:00:00.000Z","entityCategory":"GENERAL","entityStatus":"ACTIVE","entitySubCategory":null,"expirationReason":null,"expiredAt":null,"family":{"children":[{"active":true,"country":"EE","legalName":"TMJ Trading OÜ","lei":"2549007BPUKABP85PZ46","relationshipTypes":["IS_DIRECTLY_CONSOLIDATED_BY","IS_ULTIMATELY_CONSOLIDATED_BY"]}],"childrenTotal":1,"exceptions":[{"category":"DIRECT_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NATURAL_PERSONS"],"references":[]},{"category":"ULTIMATE_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NATURAL_PERSONS"],"references":[]}],"parents":[]},"headquartersAddress":"Künnapuu tn 88, Pirita linnaosa","headquartersCity":"Tallinn","headquartersCountry":"EE","headquartersPostalCode":"12011","headquartersRegion":"EE-37","lastUpdatedAt":"2026-08-28T11:35:30.892Z","legalAddress":"Künnapuu tn 88, Pirita linnaosa","legalFormAbbreviation":"OÜ","legalFormCode":"JC0Y","legalFormName":"Osaühing","legalJurisdiction":"EE","legalName":"Artesian OÜ","lei":"2549002CEG37BPQPQO28","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2027-09-07T15:25:54.143Z","otherLegalForm":null,"postalCode":"12011","region":"EE-37","registeredAt":"2018-02-22T20:19:57.758Z","registrationAuthorityId":"RA000181","registrationAuthorityName":"Commercial Register","registrationAuthorityWebsite":"https://ariregister.rik.ee/index.py?lang=eng","registrationNumber":"12501405","registrationNumberFormatted":"12501405","registrationStatus":"ISSUED","served":false,"successorLeis":[],"validationAuthorityEntityId":"12501405","validationAuthorityId":"RA000181","validationAuthorityName":"Commercial Register","validationSources":"FULLY_CORROBORATED"}