Charts in the Time of Cholera (A): Saving Lives with Data Visualizations in the 19th Century Custom Case Solution & Analysis

1. Evidence Brief: Case Data Extraction

Financial Metrics and Mortality Data

• Broad Street Outbreak Intensity: 127 deaths occurred near Broad Street between August 31 and September 3, 1854. (Paragraph 4)
• Total Mortality: The final death toll reached 616 individuals within the Golden Square area. (Exhibit 1)
• Comparative Mortality Rates: Customers of the Southwark and Vauxhall Water Company died at a rate of 315 per 10,000 households. Customers of the Lambeth Company, which moved its intake pipe upstream, saw mortality rates drop to 37 per 10,000 households. (Exhibit 3)
• Workhouse Anomaly: Among 535 inmates at the Poland Street Workhouse, located near the pump, only 5 contracted cholera due to having a private well. (Paragraph 12)
• Brewery Anomaly: None of the 70 workers at the Broad Street brewery died; they were permitted to drink malt liquor instead of water. (Paragraph 12)

Operational Facts

• Primary Infrastructure: The Broad Street pump was a public water source located at the intersection of Broad and Cambridge Streets. (Exhibit 2)
• Data Collection Method: Dr. John Snow conducted door-to-door interviews to track the water source of the deceased. William Farr provided weekly mortality returns through the General Register Office. (Paragraph 8)
• Sanitation Context: London lacked a centralized sewer system; cesspools were frequently located in basements, often leaking into groundwater. (Paragraph 2)
• Intervention: The Board of Guardians removed the Broad Street pump handle on September 8, 1854. (Paragraph 14)

Stakeholder Positions

• Dr. John Snow: Physician. Position: Cholera is a waterborne contagion, not miasmatic. (Paragraph 6)
• William Farr: Statistician. Position: Initially supported miasma theory but provided the raw data that eventually supported Snow. (Paragraph 9)
• The General Board of Health: Governing body. Position: Firmly committed to miasma theory (bad air); resistant to infrastructure-based contagion arguments. (Paragraph 15)
• Reverend Henry Whitehead: Local curate. Position: Initially skeptical of Snow but later provided the critical evidence regarding the index case at 40 Broad Street. (Paragraph 16)

Information Gaps

• Economic Impact: The case lacks data on the financial loss to local businesses during the pump closure.
• Microbiological Proof: The specific biological agent (Vibrio cholerae) was not identifiable with 1854 technology; the link remained purely statistical.
• Implementation Costs: There is no record of the capital required to transition the entire city to upstream water sources.

2. Strategic Analysis

Core Strategic Question

• How can scientific innovators use data visualization to collapse the gap between empirical discovery and public policy in the face of entrenched institutional bias?
• What specific visual evidence is required to move the Board of Health from a miasma-based mental model to a contagion-based action plan?

Structural Analysis: The Value Chain of Evidence

The failure to address cholera was not a lack of data, but a failure in the synthesis and communication of that data. The information value chain broke at the visualization stage.

• Inbound Data: Farr's mortality tables provided the raw material but were too abstract for immediate policy shifts.
• Synthesis: Snow identified the correlation between water source and death, but a table of numbers failed to convey the spatial urgency.
• Visualization: The Dot Map transformed abstract statistics into a physical reality. By placing black bars at the addresses of the dead, the proximity to the pump became an undeniable geographic truth.

Strategic Options

Preliminary Recommendation

Snow must pursue a dual-track strategy. The primary path is Geospatial Visualization (The Map). In a crisis, the Board of Health requires a clear target for intervention. The map provides this by identifying the pump as the epicenter. This must be supplemented by the Southwark/Lambeth statistical data to ensure the findings are not dismissed as a local anomaly.

3. Implementation Roadmap

Critical Path

• Phase 1: Immediate Containment (Days 1–2): Remove the Broad Street pump handle. This is the only reversible, low-cost intervention that addresses the immediate threat.
• Phase 2: Data Mapping (Days 3–14): Plot the 616 deaths on a street-level map. Use the Voronoi diagram principle to show that most deaths occurred within the walking distance of the Broad Street pump.
• Phase 3: Causal Linkage (Days 15–30): Partner with Reverend Whitehead to interview the family at 40 Broad Street. Confirm the timeline of the index case and the proximity of their cesspool to the pump well.
• Phase 4: Policy Presentation (Days 31–60): Present the combined map and index case report to the Board of Health. Demand a permanent shift in water sourcing requirements.

Key Constraints

• Institutional Inertia: The Board of Health is comprised of miasmists. They will interpret the map as evidence that the air near the pump was particularly foul, not the water.
• Technological Limits: Without a microscope showing the bacteria, the argument remains circumstantial. Success depends on the weight of the evidence, not a single proof.

Risk-Adjusted Implementation Strategy

The strategy assumes the pump is the sole source. If deaths continue after the handle is removed, the map strategy loses credibility. To mitigate this, Snow must acknowledge the multiple water companies involved across London. The implementation should not promise an end to all cholera, but a specific reduction in mortality tied to water filtration and upstream sourcing. Contingency: If the Board rejects the map, pivot the argument to the financial cost of the Southwark and Vauxhall mortality rates compared to the Lambeth rates.

4. Executive Review and BLUF

BLUF: Bottom Line Up Front

The Broad Street cholera outbreak was resolved not by biological discovery, but by superior data communication. Dr. John Snow's map transformed 616 abstract deaths into a localized, actionable problem. The removal of the pump handle was the first data-driven public health intervention in history. To influence modern policy, data must move beyond tables and into visualizations that reveal spatial or structural causality. The recommendation is to approve the geospatial mapping approach as the primary tool for public health advocacy.

Dangerous Assumption

The analysis assumes that the Board of Health acts rationally when presented with evidence. In reality, the Board is governed by political and ideological commitment to miasma theory. The assumption that a better chart will overcome a lifetime of medical training is the most significant execution risk.

Unaddressed Risks

• Political Backlash: Forcing water companies to move their infrastructure involves massive capital expenditure. These companies have significant lobbying power that a physician and a curate cannot easily overcome.
• Data Integrity: The reliance on door-to-door interviews introduces recall bias. If the Board identifies even five incorrect data points on Snow's map, they may use those errors to invalidate the entire dataset.

Unconsidered Alternative

The team failed to consider a market-based intervention. Rather than seeking a policy change from the Board, Snow could have published his findings directly to the public. If customers of Southwark and Vauxhall were informed of their 8x higher death rate, market pressure would have forced the water company to move its intake pipes without the need for a legislative mandate.

Verdict

APPROVED FOR LEADERSHIP REVIEW