Database Health

A detailed look at completeness and data quality. Select a category to filter the sample records below.

Missing information doesn’t always mean an error. Children often share a household email or phone, visitors may only give a first name, and not every profile needs a birthdate. Overlaps are counted once: 238 profiles (8.4%) are missing at least one contact method (142 email only + 55 phone only + 41 both).

Sample records

Showing 17 of 68 detailed fictional sample records · filter: Missing phone. Aggregate counts above cover all 2,847 profiles.

		Profile ID
Jenny Park	Park Household (2)	PC-1048215	Missing phoneMissing birthdatePotential duplicate	2024-06-09
Steve Wright	Wright Household (2)	PC-1048227	Missing phoneMissing birthdatePotential duplicate	2023-02-26
Emily Davis	Davis Household (2)	PC-1048239	Missing phoneMissing birthdatePotential duplicate	2025-02-16
Nick Hall	Hall Household (2)	PC-1048241	Missing phoneMissing birthdatePotential duplicate	2024-07-07
Visitor (no last name)	Household	PC-1048262	Missing phoneIncomplete nameMissing birthdate	2025-11-02
Liz Carter	Carter Household (2)	PC-1048203	Missing phonePotential duplicate	2024-03-02
David Alvarez	Alvarez Household (2)	PC-1048209	Missing phonePotential duplicate	2024-05-30
Chris Lee	Lee Household (2)	PC-1048211	Missing phonePotential duplicate	2024-11-01
Bill Scott	Scott Household (2)	PC-1048235	Missing phonePotential duplicate	2023-06-11
Sam Ward	Ward Household (2)	PC-1048243	Missing phonePotential duplicate	2024-03-17
Laura Fisher	Fisher Household (2)	PC-1048247	Missing phonePotential duplicate	2024-11-03
Ruth Anderson	Anderson Household	PC-1048253	Missing phoneMissing birthdate	2025-11-02
Priya Shah	Shah Household	PC-1048258	Missing phoneMissing birthdate	2025-11-02
Teresa Long	Long Household	PC-1048263	Missing email & phoneMissing birthdate	2025-11-02
Marcus Greene	Greene Household	PC-1048257	Missing email & phone	2025-11-02
Caleb MorganChild	Morgan Household	PC-1048259	Missing email & phone	2025-11-02
Lily MorganChild	Morgan Household	PC-1048260	Missing email & phone	2025-11-02