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-55867TPAEmma Mendez1954-05-08UHC-16028-3024038337415770 Indian School Rd, Eden Prairie, MN, 553480.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62627TPABrittany Fuller1965-12-07——799 Elm St, Las Vegas, NV, 891090.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52958TPASamantha Russell1943-11-13—66723906381842 Indian School Rd, Nashville, TN, 372300.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53848TPAAndrea Bell2007-01-24—22345728654106 Baseline Rd, Austin, TX, 787130.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59682TPAPatrick Nichols——58756904376749 Hillcrest Rd, Sacramento, CA, 958370.62Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56897TPAHenry Walsh1949-08-27—83194922197903 Meadow Ln, Gilbert, AZ, 852770.62Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+3 more
TPA-55290TPABrittany Diaz1974-03-08—32769126754481 Ocean Ave, San Antonio, TX, 782340.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
TPA-52481TPABruce J Fosster1942-12-16—84827875371361 Highland Ave, Chandler, AZ, 852860.62Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
TPA-51189TPAJacob Evans1971-07-14——2290 Spring St, Jacksonville, FL0.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-52049TPAAshley Gordon1983-11-11—57979967323599 Park Pl, Glendale, AZ, 853640.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57687TPAJessica Fernandez1951-04-07——3338 Highland Ave, Austin, TX0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61102TPAAndrea Delgado1950-09-04—40487133269789 Washington St, Houston, TX, 770170.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54991TPAAlexander Ray1996-05-06UHC-31410-2266836902585159 Ridge Rd, Tampa, FL0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-57716TPAKathleen Morgan1994-04-23UHC-44662-69—5250 Spring St, Fresno, CA, 937540.62Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
TPA-51597TPAAmmber Tucker1973-08-10——5701 Lake View Rd, Minneapolis, MN, 554700.62Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51534TPAJoseph Wang1976-04-25—81530472227202 River Rd, San Diego, CA0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56633TPADanielle Ramirez1966-02-11—75991782178031 Spring St, Miami, FL, 331070.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54710TPAValentina R James1958-11-14UHC-20196-87—384 Market St # 914, Mesa, AZ, 852960.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61635TPAOmar Weaver2002-02-28—70397997084595 Sage Ct, Fresno, CA, 937820.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-54538TPAJeffrey Mendez1967-05-03——5599 Sage Ct, Denver, CO, 802460.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-54537TPAJeffrey Mendez1967-05-03——5599 Sage Ct, Denver, CO, 802460.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-50378TPAKathleen Soto1939-10-26——7986 Oak St, San Antonio, TX, 782930.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59497TPAHenry U Chen1945-11-01——7603 Sunset Blvd, Dallas, TX, 752970.62Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
TPA-58187TPAEircJunk1998-07-10—61621707919184 Highland Ave, Tampa, FL, 336760.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56334TPAWei Castillo1960-11-18——2397 Willow Ct, Eden Prairie, MN, 553920.62Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-53150TPABrandon Murphy1969-03-05UHC-35997-95—5643 Valley View Dr, Houston, TX, 770690.62Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
TPA-60603TPAAaron G Holmes1996-05-19—95086647198374 Palm Dr, Glendale, AZ, 853520.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60602TPAAaron G Holmes1996-05-19—95086647198374 Palm Dr, Glendale, AZ, 853520.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59716TPAKayla Lewis1978-06-27——8719 Ocean Ave, Gilbert, AZ, 852690.62Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
TPA-53550TPAVirginia Lycnh1950-12-07—95376215442636 Ocean Ave, Tucson, AZ, 857280.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59610TPAEmily A Ross1951-05-12—75444317608776 Main St, Tampa, FL, 336840.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62297TPASean Patel1995-06-09——4719 Camelback Rd, Glendale, AZ, 853650.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51393TPAMichael S Campbell———1057 Maple Ave, Austin, TX, 787310.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-53230TPAGeorge Murphy1998-10-14—96480525072791 Elm St, Fresno, CA, 937780.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59352TPALisa Li1999-09-23——6577 Ridge Rd, San Diego, CA, 921290.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-64136TPAVirginia Carlson1993-03-18——4591 Valley View Dr, Dallas, TX, 752410.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59048TPABryan Ryan2005-03-05UHC-33706-7786842797619245 Highland Ave, Tempe, AZ, 852700.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62411TPAJohn Santiago1976-12-27——535 Canyon Rd, Glendale, AZ, 853610.62Street suffix standardisedAddress re-casedState code upper-casedGender normalised+3 more
TPA-55778TPAAustin Morgan1982-12-01UHC-70663-96—6776 Sunset Blvd, Chandler, AZ, 852580.62Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-64149TPABobby Bailey——31460302802275 Baseline Rd, Plano, TX, 750320.62Date of birth unreadablePhone reformattedCity re-casedGender normalised+3 more
TPA-63351TPAMei Reid1977-09-04—78246781947400 Meadow Ln, Eden Prairie, MN, 553820.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61152TPAPhilip Hunt1940-12-03—98537162303806 Forest Ave, Denver, CO, 802800.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-64217TPARaymond Maldonado1969-10-23——4552 Market St, Columbus, OH, 432850.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-63993TPAAnna Rice1938-09-07—37353817337568 Elm St, Mesa, AZ, 852030.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62406TPAKayla Jensen1992-05-06——3522 Park Pl, Phoenix, AZ, 850450.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-51581TPARebecca Williams1972-11-15——5115 Elm St, Dallas, TX, 752570.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53811TPALori Butler1981-02-20—4306655702405 Indian School Rd # 185, Nashville, TN, 372700.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-52853TPARalph Nguyen1958-05-12——2076 Lake View Rd, Scottsdale, AZ, 852160.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54065TPAKathryn Nichols1961-11-13—85170424789702 Main St # 228, Tampa, FL, 336040.62Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more
TPA-56014TPAWalter Scott1973-07-11—95970360536354 Canyon Rd, Las Vegas, NV, 891660.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
14,474 rows, page 42 of 290PreviousNext