Open data on public expenditure — datasets, categories and a SPARQL endpoint for research and analysis

Chicago home visit nurse costs for lead prevention

Chicago Department of Public Health lead poisoning prevention home visit nurse staffing costs are not just a wage bill. A public health nurse working an environmental health case may spend an hour with a child and family, then review paint, dust, soil and water information, coordinate a blood lead test, contact a clinician or landlord, and document follow-up. That labour protects more than one visit because early action can stop continued exposure before neurological harm accumulates.

The accounting is complicated by shared staff and work that occurs outside the home. A programme may spend on outreach before a visit, follow-up after discharge, centrally supplied laboratory testing, and staff time shared among surveillance, education and enforcement. Treating all agency spending as visit cost makes busy periods look cheap and quiet prevention look wasteful.

Chicago's housing stock makes field work costly. Many older multifamily buildings and dwellings predate the federal 1978 ban on lead-based paint, while rental turnover can weaken a family's knowledge of earlier renovation work. Illinois follow-up rules, local inspection activity and travel across neighbourhoods determine how much of a nurse's day sits with a family rather than at a desk.

For Australian readers, Chicago is a useful comparator, not a template to copy. Melbourne and Sydney have different housing systems, health funding and environmental risks. The transferable lesson is to make each home-visit dollar visible, from nurse time and travel to testing, family support and the eventual removal of an exposure hazard.

Building a full-cost staffing model

A full-cost staffing model separates the cost of employing a nurse from the cost of delivering a complete service. That distinction matters because a nurse may spend part of the week conducting home visits and the remainder reviewing referrals, preparing educational materials, attending case conferences and supervising outreach workers. Dividing the entire payroll by reported visits can therefore understate the cost of each contact.

Direct nurse costs include salary, employer contributions, overtime, leave, training, supervision and paid travel time. Mileage or public transport fares should be included when a worker moves between properties. Charges for mobile phones, data services and protective equipment also belong in the calculation, especially when they support consistent documentation and safe visits.

Several expenses are more easily overlooked. Interpretation, translation, printing, laboratory supplies and family transport assistance may sit in another budget or arrive through a grant. Landlords, community organisations and public agencies may share remediation work without recording all contributions in the same place. A defensible unit cost should assign these shared expenses consistently rather than leave them as invisible support.

Clinical care and environmental follow-up

A home visit has three connected functions: assess the child, investigate the exposure and help the family act. The nurse records an environmental exposure history, reviews the blood lead test or arranges follow-up testing, checks whether symptoms require clinical referral, and asks about medicines, nutrition and other possible influences on the child's health. There is no safe blood lead level for children, so exposure reduction and clinical review matter even when a result is below the regulatory action level.

Environmental work usually begins before the nurse arrives. Paint conditions, window treatments, dust, bare soil, imported products and plumbing can point towards a likely source. During the visit, the nurse can examine areas that an adult may overlook, explain safer cleaning methods and connect hazards with the child's daily routine. Dust from renovation and deteriorating lead-based paint are common preventable sources in older housing.

The final function is navigation. A family may need a landlord response, legal advice, tenant advocacy, a safer temporary address, a benefits referral or help scheduling a medical appointment. Community health workers and family navigators can carry much of this work, while nurses provide clinical interpretation and escalation. Effective staffing plans value that division rather than asking every nurse to handle every task alone.

Reading the spending record

Publicspending.net is an independent, self-funded research initiative that makes public payment records easier to search and compare. Its datasets, statistical tables, graphs and bulk downloads can be combined with a SPARQL endpoint and ontology-based tools. That creates a route from a broad department budget to the payments, contracts and grants associated with particular public health functions.

A useful analysis begins with agency and programme identifiers, then follows payroll, procurement and grant records across reporting periods. The researcher can classify transactions under headings such as nursing services, laboratory testing, community outreach, environmental health and programme administration. Matching those amounts to staffing levels and completed visits shows how expenditure changed, while comparisons with similar jurisdictions reveal where administrative costs or outsourced services are concentrated.

Spending data still require careful interpretation. Budget appropriations can differ from cash expenditure, and a grant award may cover several reporting periods. Transfers between agencies can be counted twice, while emergency or surge spending can distort ordinary staffing costs. Chicago figures are recorded in US dollars, so comparisons with Australian programmes require a dated currency conversion rather than an assumed exchange rate. Most importantly, expenditure records do not by themselves show whether a visit reduced exposure; they establish the cost side of that result.

Lessons from Australian cities

Melbourne and Sydney contain substantial rental sectors, share houses and apartments, and large populations living in buildings constructed before modern hazardous-product controls. Tenants may move before a landlord completes repairs, making the address history and environmental exposure history central to a public health assessment. The delivery setting differs from Chicago, but the difficulty of identifying responsibility across fragmented housing arrangements is familiar.

Water is a separate concern in parts of New South Wales. Older pipes, solder, brass fixtures and some rainwater configurations can contribute lead to household water, particularly after periods of stagnation. NSW Health recommends flushing taps after long idle periods and advises residents with older plumbing to seek testing where a household member is concerned. The Australian Drinking Water Guidelines provide the national benchmark, while local water utilities and health authorities manage implementation and advice.

Everyday renovation can also disturb old hazards. Weekend painting, sanding skirting boards or repairing windows may release contaminated dust in a home where children play and eat. Australian controls now restrict lead in many consumer products, but layers applied before those controls can remain. Wet cleaning, careful containment and thorough handwashing after dusty work are practical habits for families, landlords and tradespeople, while public health teams provide the individual risk assessment.

Australian funding is divided among state and local health services, community organisations, general practitioners, Aboriginal Community Controlled Health Organisations and specialist maternal and child health teams. Medicare rebates generally support clinic-based care, while councils, public health units and non-government programmes fund much of the outreach. Victorian maternal and child health nurses and NSW community child and family health nurses provide valuable contacts, although environmental investigation and remediation require additional capacity. State public-health and residential-tenancy laws also distribute duties differently, so each local pathway needs clear referral rules. Public information teams can consult the Ecuadorian Embassy outreach resource as a cross-border example of maintaining accessible information for Spanish-speaking communities.

A staffing model built around exposure

A transferable staffing model should reflect case complexity, travel, family needs and the likelihood of repeated contact. Nurses can concentrate on clinical assessment and complex cases, while trained outreach workers conduct lower-risk follow-up, prepare households for a visit and maintain contact after referral. Caseloads can be grouped by urgency and geography, with scheduled field days reducing unproductive travel. Remote consultation may support review meetings, but it does not replace the home visit when the exposure is inside the dwelling.

Funding decisions should follow a small set of linked measures: cost per completed visit, cost per child case, time to first contact, proportion of referred homes receiving an environmental assessment, follow-up testing completion and confirmed hazard closure. These measures need context. A lower cost per visit may reflect missed families rather than greater efficiency, while a higher cost can be justified when a nurse identifies a source that a brief telephone contact would have missed. Transparent reporting allows each jurisdiction to judge the balance.


Open the Chicago expenditure records, identify the relevant programme accounts and document each classification before calculating a staffing figure. Run the same query through the SPARQL endpoint, then compare payroll, contracts and grants across a defined reporting period. Preserve the query, units, dates and adjustments so another analyst can reproduce the result.

Turn the calculation into a public series that joins expenditure with nurse hours, completed visits and verified follow-up outcomes. Publish the finished spending series with its definitions and caveats, and adapt the method to Australian programme data so local decisions rest on visible costs rather than assumptions.