{"action":"elsewhere","city":"Cleveland","companyRegistrationNumber":null,"conformityFlag":"CONFORMING","country":"US","createdAt":"2012-12-20T00:00:00.000Z","entityCategory":"GENERAL","entityStatus":"ACTIVE","entitySubCategory":null,"expirationReason":null,"expiredAt":null,"family":{"children":[],"childrenTotal":0,"exceptions":[{"category":"DIRECT_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NO_KNOWN_PERSON"],"references":[]},{"category":"ULTIMATE_ACCOUNTING_CONSOLIDATION_PARENT","reasons":["NO_KNOWN_PERSON"],"references":[]}],"parents":[]},"headquartersAddress":"5005 Rockside Road, #800","headquartersCity":"Cleveland","headquartersCountry":"US","headquartersPostalCode":"44131","headquartersRegion":"US-OH","lastUpdatedAt":"2026-07-27T19:58:05.208Z","legalAddress":"C/O Scott J Wiles, 5005 Rockside Road, #1100","legalFormAbbreviation":"limited liability company","legalFormCode":"EZNQ","legalFormName":"Limited Liability Company","legalJurisdiction":"US-OH","legalName":"SJW Brokerage LLC","lei":"254900PYSWJVMQ1AMD05","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2027-08-26T11:36:38.889Z","otherLegalForm":null,"postalCode":"44131","region":"US-OH","registeredAt":"2020-08-26T11:36:38.889Z","registrationAuthorityId":"RA000629","registrationAuthorityName":"Corporation Database (Ohio Secretary of State)","registrationAuthorityWebsite":"https://businesssearch.ohiosos.gov/","registrationNumber":"2160278","registrationNumberFormatted":"2160278","registrationStatus":"ISSUED","served":false,"successorLeis":[],"validationAuthorityEntityId":"2160278","validationAuthorityId":"RA000629","validationAuthorityName":"Corporation Database (Ohio Secretary of State)","validationSources":"FULLY_CORROBORATED"}