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-56178TPAJulia Holmes1974-12-28—6967289662—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
TPA-56564TPAJoseph E Chavez1996-10-02——5116 Main St, Tampa, FL, 336700.64Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
TPA-61450TPAJonathan Rivera1953-04-10—58697246418587 River Rd, Phoenix, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-60386TPAThomas Day———2133 Broadway, Las Vegas, NV, 891090.64Name re-casedDate of birth unreadableCity re-casedGender normalised+2 more
TPA-52088TPAJack Griffin1977-02-25UHC-51506-1643694763775316 Canyon Rd, Minneapolis, MN, 554740.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53984TPARobert E Pierce1988-03-04——3041 Hillcrest Rd, Houston, TX, 770720.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60581TPAJuan Cooper1950-04-20—46580765113666 Sage Ct, San Diego, CA, 921990.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-50360TPABilly Medina1989-09-14UHC-16597-76—810 Washington St, Sacramento, CA, 958680.64Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59634TPADonald Singh1976-08-13—88729379643049 Park Pl, Tampa, FL0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61035TPARalph Morris1971-12-28——2055 Forest Ave, Austin, TX, 787180.64Two-digit birth yearStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-54663TPAVicoria Contreras1974-07-19——7228 Baseline Rd, Orlando, FL, 328170.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53200TPAScott Simmons1976-01-09——2254 Lake View Rd, Mesa, AZ, 852260.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-62118TPAChristian Holmes1951-08-01—54948752854067 Highland Ave, Minneapolis, MN, 554740.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-50041TPAOlivia H Estrada1963-04-22—33778855128818 Camelback Rd, Sacramento, CA, 958660.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50163TPADaniel Howell2008-09-20——3838 Central Ave, Tucson, AZ, 857600.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-51956TPANatalie King1946-01-09—43478365085353 Valley View Dr, Mesa, AZ, 852560.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
TPA-51724TPASharon Mason1939-03-23——6653 Park Pl # 183, Chandler, AZ, 852090.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-63657TPAEthan S Garza2002-06-26—34968159379873 Market St, Atlanta, GA, 303350.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56133TPARoy Coleman1986-11-12——4485 Pine Dr, Tampa, FL, 336500.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-54286TPAJoe Q Hernandez1984-04-12—7448370918795 Maple Ave, Tempe, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-56932TPAJean Russell1947-05-17—27775803938519 River Rd # 721, Orlando, FL, 328960.64Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
TPA-56845TPALgoan Lawson—UHC-11101-9528368073939216 Mesa Dr, Atlanta, GA, 303130.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
TPA-60699TPACharles Murray1951-01-15——5473 Mesa Dr # 768, San Diego, CA, 921990.64Unit split from streetStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-55339TPAJean Hamilton1965-02-08—41671433834244 Oak St, Tempe, AZ, 852580.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55868TPASarah Kennedy1998-07-05——5026 Hillcrest Rd, Mesa, AZ, 852860.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63175TPAJake Marquez1945-06-08UHC-72121-60—8943 Market St, Columbus, OH, 432930.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52906TPARalph F Torrees1945-09-17——7823 Lincoln Way, Phoenix, AZ, 850140.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-54867TPAAisha Barnes1986-05-05——6083 Main St, San Diego, CA0.64Name re-casedDate of birth reformattedZIP missingGender normalised+2 more
TPA-61312TPANathan Reynolds1964-03-05——5436 Park Pl, Sacramento, CA, 958270.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62836TPAKyle Howell1986-12-25——274 Highland Ave, Miami, FL, 331520.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57850TPAArjun Jimenez1994-06-09—28080526117369 River Rd # 881, Phoenix, AZ0.64Name re-casedPhone reformattedUnit split from streetZIP missing+2 more
TPA-60293TPAMaria Stephens1986-09-24—86176339111827 Canyon Rd, San Diego, CA, 921190.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62670TPAJacqueline Reid2004-11-04——8207 Cedar Ln, Sacramento, CA, 958800.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51668TPACamila Walsh—UHC-95340-275778404672238 Market St, Miami, FL, 331870.64Name re-casedDate of birth unreadablePhone reformattedGender normalised+2 more
TPA-53120TPANathan Schultz1968-02-18——4204 Highland Ave, Miami, FL, 331440.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-54754TPAAmy Martin1950-07-24UHC-11699-1428446516455564 Apache Blvd # 266, Mesa, AZ, 852120.64Name re-casedMember ID reformattedUnit split from streetState name converted to code+2 more
TPA-55932TPACynthia Sandoval2002-04-06——9753 Lake View Rd, Austin, TX, 787870.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61282TPATeresa Mitchell2001-09-12UHC-68340-13—1695 Cedar Ln, San Antonio, TX, 782720.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56529TPAPriya Edwards1999-07-14——2881 Bayshore Dr, San Antonio, TX, 782800.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-50445TPASean Hunter1944-01-18—61851241745604 Pine Dr, Austin, TX, 787950.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-60157TPALucia Day1980-02-11——8005 Sage Ct, Jacksonville, FL, 322780.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
TPA-61376TPAEric Sanders1959-08-27—95455796902321 Grand Ave, Orlando, FL, 328170.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51389TPABrian Edwards1983-12-09—26929268076740 Meadow Ln, Plano, TX, 750070.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53640TPADeborah Alvarado2006-02-04—49966563494970 Sunset Blvd, Denver, CO, 802010.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57510TPAPatrick Patel1985-10-17——2331 Apache Blvd, Houston, TX, 770990.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-52130TPAAlan Castillo1954-06-12—244718860036 Hillcrest Rd, Mesa, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52891TPAJulia Peterson1944-12-08——718 Palm Dr, Dallas, TX, 752550.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55305TPAMargaret Harris1971-03-16UHC-77132-48—471 River Rd, Nashville, TN, 372880.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62520TPAFrances Berry1968-02-08—20470333267190 Pine Dr, Minneapolis, MN, 554660.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
TPA-64198TPAKaren Porter2006-01-11——973 Desert Sky Blvd, Las Vegas, NV, 891370.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
14,474 rows, page 65 of 290PreviousNext