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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-58630TPALisa Diaz2007-11-27——8963 Maple Ave, Houston, TX, 770920.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55946TPACynthia Martin1956-04-18——1627 Cedar Ln, Gilbert, AZ, 852980.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61251TPAJoe Howll1964-08-20UHC-75983-70——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-57438TPABrenda Ortiz1973-05-20UHC-96228-35—4107 Palm Dr, Fresno, CA, 937010.82Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-57848TPARoger Nelson1989-06-14UHC-31937-38—1103 Desert Sky Blvd, Tucson, AZ, 857330.82Date of birth reformattedZIP+4 trimmedWhitespace trimmed
TPA-64357TPAGeorge N Coleman1939-05-05UHC-22944-32—7711 Valley View Dr, Sacramento, CA, 958960.82Name re-casedSSN last four extractedPlaceholder values cleared
TPA-52266TPATerry Williams1974-12-27—2416504018—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-54472TPARalph Hicks1942-04-09—4063088132—0.82Two-digit birth yearPhone reformattedWhitespace trimmed
TPA-54423TPAGary Rodriguez1952-11-10——1707 Mesa Dr, Chandler, AZ, 852880.82Name re-casedGender normalisedPlaceholder values cleared
TPA-63597TPAElizabeth Oliver1980-04-09———0.82Name re-casedSSN last four extractedPlaceholder values cleared
TPA-54677TPAAmanda Foster1974-01-09——395 Washington St, San Diego, CA, 921990.82Name re-casedState name converted to codePlaceholder values cleared
TPA-60525TPAMaria Jenkins———2486 Mountain View Dr, Jacksonville, FL, 322320.82Name re-casedDate of birth unreadablePlaceholder values cleared
TPA-57192TPAGary K Mills1986-01-19UHC-36526-6377854506191766 Church St, Denver, CO, 802930.82Phone reformattedState name converted to codePlaceholder values cleared
TPA-59836TPAAbigail Soto1953-03-27—61744479103268 Lake View Rd, Mesa, AZ, 852520.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-61385TPABradley Cox1951-01-18UHC-86083-56—4643 Harbor Blvd, Dallas, TX, 752470.82Name re-casedState name converted to codePlaceholder values cleared
TPA-58677TPABobby E Webbb1999-07-16—2977999298—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-57938TPAKevin Cole1961-02-14—41522272072813 Market St, Eden Prairie, MN, 553290.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-56717TPAKim Marquez1941-05-15—90423025441432 Valley View Dr # 394, Las Vegas, NV, 891700.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-57693TPAHlen Wallace2006-03-25——8344 Mountain View Dr, Phoenix, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-51432TPAVincent Hanson1943-12-03——6526 Camelback Rd, Atlanta, GA, 303020.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-59835TPASarah U Kelley1946-09-03——9831 Mountain View Dr, Orlando, FL0.82Name re-casedZIP missingPlaceholder values cleared
TPA-53145TPASharon Nguyen1958-04-27——1832 Central Ave, Mesa, AZ, 852970.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52225TPABrian Little1946-02-09UHC-65114-56——0.82Date of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-64426TPAMadison Hunt1993-05-07——2547 Mesa Dr, Tucson, AZ, 857360.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64425TPAMadison Hunt1993-05-07——2547 Mesa Dr, Tucson, AZ, 857360.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60973TPABrandon N Smith1958-10-14UHC-72514-77—1746 Bayshore Dr, Dallas, TX, 752580.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-52172TPARandy Bell1971-03-18——6325 Meadow Ln, San Diego, CA, 921900.82Name re-casedStreet suffix standardisedAddress re-cased
TPA-55280TPAAnna Medina1972-05-06—84374144627443 Desert Sky Blvd, Tampa, FL, 336760.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-63387TPAKayla O Williamson1993-02-05——5310 Indian School Rd, San Diego, CA, 921840.82Name re-casedGender normalisedPlaceholder values cleared
TPA-55959TPAAnn G Simpson1984-06-28——9591 Camelback Rd, Atlanta, GA, 303970.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50526TPAJhon Powell1942-04-22UHC-16950-26—2053 Canyon Rd, Los Angeles, CA, 900490.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50158TPALarry Thomas1966-10-23UHC-34933-36—697 Meadow Ln # 666, Chandler, AZ, 852270.82Unit split from streetEmail lower-casedPlaceholder values cleared
TPA-63737TPAElijah Owens1953-05-21——8030 Cedar Ln, Mesa, AZ, 852780.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62133TPADonna Graham1976-06-12UHC-00728-7177673054301770 Oak St, Miami, FL, 331040.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56430TPAPatrick D Wiilliamson1971-11-13——105 Highland Ave, Miami, FL, 331620.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-51240TPAWayne Coleman1961-12-22UHC-27015-08—691 Grand Ave, Tampa, FL, 336210.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-54805TPACharlotte Lee1938-01-07——1687 Maple Ave, Columbus, OH, 432160.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-57355TPASctot Kennedy1979-06-24—63177797805665 Ridge Rd, Phoenix, AZ, 850550.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-51807TPAJose Carpenter1971-02-23—55898619345511 Elm St, Phoenix, AZ, 850660.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-61147TPASophia Hunt1997-11-18——5141 Valley View Dr, Phoenix, AZ, 850270.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64354TPAAhmed Adams1986-11-16———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50202TPAJohn Contreras1974-04-23——5777 Bayshore Dr, Denver, CO, 802790.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57542TPANicole Owens1974-09-15———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-57543TPANicole Owens1974-09-15———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-57065TPAAlbert Vargas1995-09-27——113 Willow Ct, Minneapolis, MN, 554440.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-54460TPAChuck Rice1953-09-09——8697 Main St, Jacksonville, FL, 322450.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57683TPAEvelyn Jensen2005-05-28UHC-72278-72—9886 Sage Ct, Phoenix, AZ, 850520.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60032TPASamantha Lne1939-04-24———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51070TPADouglas Morgan1974-01-02—77839000034328 Grand Ave, Chandler, AZ, 852070.82Phone reformattedState name converted to codePlaceholder values cleared
TPA-61528TPAEvelyn Alvarado1979-10-24——6542 Mesa Dr, San Antonio, TX, 782320.82Name re-casedStreet suffix standardisedAddress re-cased
14,474 rows, page 202 of 290PreviousNext