Normalised records

Normalised records (silver)

Each raw row is parsed into consistently formatted fields. Every change from the raw value is recorded as a data-quality flag.

Normalised rows
99,495
usable in matching
Flagged rows
99,881
99.9% carry at least one flag
Junk quarantined
505
no usable last name
Average quality score
0.75
1.00 = no corrections needed

Quality flags

What normalisation had to do, and how often. Select a flag to filter the table.

Normalised records

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-123207ENRDoris E Arnold1945-04-23UHC-53358-12—6876 Jefferson Ave, Austin, TX, 787390.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-137777ENRHiroshi J Shaw1972-05-08UHC-17958-158947945234119 Camelback Rd # 933, Miami, FL, 331830.52Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-100186ENRChristina Russell1960-05-17UHC-19733-52—662 Ridge Rd # 957, Gilbert, AZ0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-117155ENRMichelle G Jimenez1944-09-20UHC-07901-842467090634148 Forest Ave, Atlanta, GA, 303850.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100991ENRAnna S Fisher1990-09-28UHC-66514-15—6576 Camelback Rd, Los Angeles, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-20223PRVDouglas M Morales1952-08-19——2023 Maple Ave, Gilbert, AZ, 852260.52Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55376TPAThomas Boyd1996-11-05—8104388722204 Indian School Rd, Glendale, AZ, 853680.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402354CLMAngela Williams1995-05-28——7312 Meadow Ln, Jacksonville, FL, 322010.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-125798ENRAlice Carter1963-12-03UHC-42043-2765298600765321 Ocean Ave, Sacramento, CA, 958040.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-427485CLMKimberly P Robertson1940-11-18—51162235289549 Apache Blvd, Tempe, AZ, 852960.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422241CLMAdm B Young1992-07-07UHC-88914-9536442597029456 Mesa Dr, Tempe, AZ, 852770.52Middle initial moved out of first nameTwo-digit birth yearPhone reformattedGender normalised+2 more
ENR-110261ENRHenry Yang1979-06-01UHC-51973-5270172754176477 Valley View Dr, Scottsdale, AZ, 852770.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-55896TPALori Singh1973-06-04——2288 Canyon Rd, Denver, CO, 802500.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-124488ENRVirginia Cooper1942-04-16UHC-28150-1548547425243201 Mesa Dr, Gilbert, AZ, 852530.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424405CLMJohn Yang1986-09-23UHC-65125-01—8045 Church St, Phoenix, AZ, 850510.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-411414CLMVincent Stewart1939-04-05——8497 Valley View Dr, Jacksonville, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-132912ENREmma Jackson1905-11-25UHC-14402-8868971791271433 Jefferson Ave, Nashville, TN, 372380.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100994ENRStephanie Gardner1953-12-28UHC-33192-03—1154 Lincoln Way, Seattle, WA, 981590.52Name split from “Last, First”Date of birth reformattedZIP+4 trimmedGender normalised+2 more
PRV-24063PRVCamila Burton2003-01-14——6355 Mesa Dr, Seattle, WA, 981850.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142674ENRBobby Butler1974-09-27UHC-92800-68—9720 Central Ave # 524, Columbus, OH0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-131355ENRRoger Fox1990-07-18UHC-96985-7064041481005466 Maple Ave, Tampa, FL, 336800.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-124705ENRMichael F Aguilar—UHC-84748-08—9087 Apache Blvd, Las Vegas, NV, 891440.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412378CLMLauren H Lyncch1993-07-24UHC-13897-33—1657 Ocean Ave, San Antonio, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-108034ENRJudith H Rivara1954-09-08UHC-82345-5472088600227771 Lake View Rd, Nashville, TN0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-421638CLMWillie Wang1997-12-05UHC-59116-79—4236 Washington St, Eden Prairie, MN, 553900.52Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+2 more
TPA-61037TPAMark Johnson1989-09-14——3957 Willow Ct, Scottsdale, AZ, 852650.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-111579ENRBryan S Smith2003-10-02UHC-11693-4074156374358664 Ridge Rd, Nashville, TN, 372070.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-58244TPAMaia B Gonzales——48333816086725 Bayshore Dr, Glendale, AZ, 853300.52Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-425164CLMKayla W Le2002-03-09UHC-50548-50—2921 Market St, Miami, FL, 331800.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-414678CLMJohn Austin2004-08-01UHC-48708-1345380597159557 Forest Ave, Nashville, TN, 372890.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-130950ENRBobby Luna1980-04-14UHC-58068-4496644251316309 Jefferson Ave, Miami, FL, 331620.52Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more
ENR-111629ENRJustin N Carr1979-02-16UHC-13351-15—7691 Forest Ave, Gilbert, AZ, 852750.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-118853ENRAngela E Woods1977-08-26UHC-24555-8773741636633702 Central Ave, Los Angeles, CA, 900470.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426449CLMEvelyn Palmer——60923909248011 Church St, Tucson, AZ, 857580.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129055ENRHarold E Casillo1949-05-28UHC-59339-91—1101 Church St, Dallas, TX, 752440.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429845CLMDiane Huwell1970-06-20—32861414707422 Market St, Charlotte, NC, 282190.52Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+2 more
CLM-411722CLMWilliam Brooks——93873259182965 Oak St, San Diego, CA, 921010.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-426413CLMRachel Kennedy1975-07-09UHC-76272-4494262408818703 Park Pl, Phoenix, AZ, 850290.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-128800ENRElijah X Greene1988-08-10UHC-82662-56—8413 Church St, Phoenix, AZ, 850500.52Name split from “Last, First”Two-digit birth yearCity re-casedGender normalised+2 more
ENR-115281ENRAlexis M Hunt1978-10-09UHC-21311-8530263475806601 Maple Ave, Tempe, AZ, 852450.52Date of birth reformattedPhone reformattedSSN last four extractedZIP+4 trimmed+2 more
CLM-402592CLMOlivia Hughes1985-02-19UHC-11245-96—6459 Lake View Rd, Denver, CO, 802280.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-426169CLMJoan Long—UHC-83158-92—6094 Apache Blvd, Atlanta, GA, 303900.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28254PRVLogan J Larson1945-04-19—98668874576157 Forest Ave, Phoenix, AZ, 850530.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135307ENRSofia Gonzalez1989-06-16UHC-28733-52—2628 Washington St, Nashville, TN0.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-50457TPABeverly Dominguez1963-06-01—92335001042507 Cedar Ln, San Diego, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-130331ENRFrances A Wong1997-11-20UHC-71214-6071789217206245 Broadway, Denver, CO, 802350.52Name split from “Last, First”Phone reformattedState name converted to codeEmail lower-cased+2 more
CLM-404967CLMSam Miller1940-11-09——5308 Grand Ave, Tucson, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-404968CLMSam Miller1940-11-09——5308 Grand Ave, Tucson, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-132268ENRHannah Cooper1945-03-20UHC-05330-1285476496756186 Ocean Ave, Denver, CO, 802050.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61502TPACarl Gibson2005-10-02——8206 Willow Ct, Dallas, TX, 752180.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
100,000 rows, page 187 of 2,000PreviousNext