{"action":"elsewhere","city":"Brooklyn","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"2017-04-17T00:00:00.000Z","entityCategory":"GENERAL","entityStatus":"ACTIVE","entitySubCategory":null,"expirationReason":null,"expiredAt":null,"family":{"children":[],"childrenTotal":0,"exceptions":[{"category":"DIRECT_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NON_CONSOLIDATING"],"references":[]},{"category":"ULTIMATE_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NON_CONSOLIDATING"],"references":[]}],"parents":[]},"headquartersAddress":"111 West End Avenue","headquartersCity":"Brooklyn","headquartersCountry":"US","headquartersPostalCode":"11235","headquartersRegion":"US-NY","lastUpdatedAt":"2023-10-25T13:30:05.897Z","legalAddress":"111 West End Avenue","legalFormAbbreviation":null,"legalFormCode":"SDX0","legalFormName":"Limited Liability Company","legalJurisdiction":"US-NY","legalName":"Tide Realty NY, LLC","lei":"254900GQK0OGA72D6I80","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2023-10-25T13:21:14.751Z","otherLegalForm":null,"postalCode":"11235","region":"US-NY","registeredAt":"2022-10-25T13:21:14.751Z","registrationAuthorityId":"RA000628","registrationAuthorityName":"Corporation and Business Entity Database (Division of Corporations, State Records and UCC, Department of State)","registrationAuthorityWebsite":"http://www.dos.ny.gov/corps/bus_entity_search.html","registrationNumber":"5120590","registrationNumberFormatted":"5120590","registrationStatus":"LAPSED","served":false,"successorLeis":[],"validationAuthorityEntityId":"5120590","validationAuthorityId":"RA000628","validationAuthorityName":"Corporation and Business Entity Database (Division of Corporations, State Records and UCC, Department of State)","validationSources":"FULLY_CORROBORATED"}