{"action":"elsewhere","city":"DAVENPORT","companyRegistrationNumber":null,"conformityFlag":"NON_CONFORMING","country":"US","createdAt":"2004-12-23T00: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":"2300 53RD AVENUE","headquartersCity":"BETTENDORF","headquartersCountry":"US","headquartersPostalCode":"52722","headquartersRegion":"US-IA","lastUpdatedAt":"2025-10-18T13:30:00.020Z","legalAddress":"C/O L & W AGENTS, INC., 220 N MAIN ST, STE 600","legalFormAbbreviation":"L.P.","legalFormCode":"HPKC","legalFormName":"Limited Partnership","legalJurisdiction":"US-IA","legalName":"THE HAVERSIAN CANAL SYSTEMS, LLP","lei":"549300CS3EHVVG7GQQ91","managingLou":"5493001KJTIIGC8Y1R12","managingLouName":"Bloomberg","managingLouWebsite":"http://lei.bloomberg.com","nextRenewalAt":"2025-10-17T18:57:29.204Z","otherLegalForm":null,"postalCode":"52801","region":"US-IA","registeredAt":"2015-12-15T02:06:00.000Z","registrationAuthorityId":"RA000606","registrationAuthorityName":"Business Services Division (Secretary of State)","registrationAuthorityWebsite":"http://www.sos.iowa.gov/search/business","registrationNumber":"304238","registrationNumberFormatted":"304238","registrationStatus":"LAPSED","served":false,"successorLeis":[],"validationAuthorityEntityId":"304238","validationAuthorityId":"RA000606","validationAuthorityName":"Business Services Division (Secretary of State)","validationSources":"FULLY_CORROBORATED"}