Methodology: Chinese Drywall
March 25: This post has been corrected.
Information about the addresses in our database came from two sources: a lawsuit filed in New Orleans federal court, and county property tax data. The court records include 4,166 plaintiff complaints representing at least 3,700 homes. The tax data came from 44 counties, representing 4,649 addresses in Florida, Louisiana and Virginia. Special programs have been established in those states to provide tax relief for drywall victims.
We found 1,232 duplicate addresses in the two data sets, representing 2,111 homes. After we accounted for multiple-family dwellings and condominium complexes, the documents revealed that 6,944 individual homes are affected by tainted drywall.
In order to get an accurate count of homes, we first needed to make sure that homes that appear in both lists were counted only once. The two lists used different typographic rules when listing addresses -- for instance, abbreviations weren't consistent between lists -- and some homes in unincorporated areas were listed inconsistently.
We passed each address through the Google Maps Geocoding API to standardize them. We stored the standardized addresses in our database only if Google was able to confirm each address at its highest degree of confidence ("rooftop").
Having standardized the addresses, we were able to find duplicate addresses across the two lists. In cases where we couldn't standardize addresses with the highest degree of confidence, we did a plain text match between the lists.
When an address represented multiple homes -- an apartment building, for example -- we used the number of units reported in the county appraiser data rather than the lawsuit data, because we believe the county appraiser data to be more accurate in this regard.
For some aggregate statistics, we used the database of homes compiled by the Consumer Products Safety Commission, which is based on consumer complaints the agency received. However, because the CPSC data contains city and state and not individual addresses, we were only able to include them as part of state and county aggregates.
Because the CPSC refused to provide specific addresses for the homes in its database, we placed the location of each tainted home in the geographic center of the city that the CPSC listed. This may have caused some inaccuracy in county aggregates in cases where a city spans more than one county.
Correction: The "Tainted Drywall" news application originally included lists of contractors, manufacturers, distributors, importers and builders involved in lawsuits over tainted drywall. A software bug caused those lists to overstate the number of addresses associated with each company. The erroneous lists, and references to them, have been removed.
Foul air from Chinese-made drywall has created a nightmare for thousands of homeowners.
The Story So Far
ProPublica and the Sarasota Herald-Tribune began examining in May 2010 what was—or wasn’t—being done to help people whose homes had been built with contaminated drywall. The problematic drywall, much of it imported from China, emitted foul odors and frequently caused mysterious failures of new appliances and electronics. Worse yet, some residents complained of serious respiratory problems, bloody noses, and migraines.
Request the Data
Latest Stories in this Project
Our Hottest Stories
- How Wall Street Tobacco Deals Left States With Billions in Toxic Debt
- Q&A: What Can U.S. Health Care Learn from the Ebola Outbreak?
- Report: Drillers Illegally Using Diesel Fuel to Frack
- Leaked Docs Show Spyware Used to Snoop on U.S. Computers
- Government Will Withhold One-Third of the Records from Database of Physician Payments
- What to Look For In Dueling Autopsies of Michael Brown
- Illinois Suspends Medical License of Leading Prescriber of Antipsychotic Drugs
- The Best Reporting on Federal Push to Militarize Local Police
- Q&A: The Hidden Costs of Tobacco Debt
- Pro-Troop Charity Shoots Back