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-56685TPAKathryn Price1987-02-12—87369818145333 Lincoln Way, Plano, TX, 750490.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55090TPAJohn Rivera2006-11-10—92958475981199 Sage Ct, San Diego, CA, 921260.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62106TPAGloria Ward1968-09-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-63752TPASandra Patel1950-08-26—5909219151—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58520TPAKelly Espinoza1989-05-10—85860214249183 Central Ave, Jacksonville, FL, 322860.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50029TPADenise E Elliott1948-09-26——7529 Camelback Rd, Austin, TX, 787950.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52118TPACaarolyn Lane1965-12-27——9646 Mesa Dr, Sacramento, CA0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
TPA-63929TPAMason Sttone1983-10-10——5591 Park Pl, Glendale, AZ, 853920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59429TPAAustin Burton1983-12-17——2738 Hillcrest Rd, Las Vegas, NV, 891370.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56567TPAMark Brradley1976-07-04——7469 Mountain View Dr, Charlotte, NC, 282070.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51928TPAJon Turner1939-06-23——7967 Lake View Rd, Chandler, AZ, 852300.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55908TPAJeremy Oliver1975-08-04——6752 Palm Dr Apt 1, Chandler, AZ, 852720.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-55909TPAJeremy Oliver1975-08-04——6752 Palm Dr Apt 1, Chandler, AZ, 852720.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-62766TPADaniel Ward1941-04-15——2104 Palm Dr, Denver, CO0.80Date of birth reformattedCity re-casedZIP missingPlaceholder values cleared
TPA-55626TPABrittany Hernandez1972-01-22———0.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-60214TPALogan L Greene1965-08-04—21651076837931 Canyon Rd Apt 36, Minneapolis, MN, 554760.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-50944TPARyan Cooper1995-07-25—6345758109—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54015TPAFrances T Simpson2006-12-03—34478944354657 Forest Ave, Plano, TX, 750840.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54014TPAFrances T Simpson2006-12-03—34478944354657 Forest Ave, Plano, TX, 750840.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57013TPABrenda Nelson1946-06-04——1315 Market St, Gilbert, AZ, 852220.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-50263TPAAllan Contreras1939-06-09——7196 Bayshore Dr, Tampa, FL, 336270.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61297TPAMason Morales1966-12-11—24161455264948 River Rd, Gilbert, AZ, 852490.80City re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56578TPABenjamin Contreras1980-06-23—94645556957408 Sage Ct, Gilbert, AZ, 852100.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58773TPAYuki Ross1982-03-01——2922 Park Pl, Las Vegas, NV, 891900.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59311TPAAlex Larson2005-11-23UHC-49440-40—8136 Elm St, Seattle, WA, 981350.80Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-59982TPABobby Simpson1980-03-27—69248500624772 Highland Ave, Tempe, AZ, 852200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54281TPAMei A Turner1965-10-04UHC-09846-267789672297—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-54542TPAAna Robinson1955-02-02—48798606913989 Indian School Rd, San Diego, CA0.80Phone reformattedCity re-casedZIP missingPlaceholder values cleared
TPA-54854TPAKimberly E Duncan1999-07-10——6835 Jefferson Ave, Jacksonville, FL, 322840.80Middle initial moved out of first nameDate of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61662TPADorothy Alexander1946-07-26——4659 Ocean Ave, Atlanta, GA, 303030.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54855TPAJessica Evans1974-08-13——2157 River Rd, Dallas, TX, 752420.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-57930TPAEugene N Greene1979-09-16UHC-12315-94—7677 Highland Ave, Tampa, FL, 336150.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-57929TPAEugene N Greene1979-09-16UHC-12315-94—7677 Highland Ave, Tampa, FL, 336150.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-51960TPAYkui Mitchell1976-08-27——6923 Main St, Denver, CO, 802550.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-58782TPAAnthony G Hansen1963-05-16UHC-17160-06—8380 Elm St, Orlando, FL, 328340.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62205TPAAmber Lee2004-04-08—53626515595091 Church St, Sacramento, CA, 958830.80Name split from “Last, First”City re-casedPlan code upper-casedPlaceholder values cleared
TPA-56603TPAEugene Kennedy1955-02-04——4602 Grand Ave, Fresno, CA, 937270.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58651TPAShirley Rogers1944-05-12——6321 Harbor Blvd, Scottsdale, AZ, 852920.80ZIP+4 trimmedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-62740TPAHannah Santiago1963-03-04—72247720814555 Washington St, Eden Prairie, MN, 553620.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56248TPAEspinoza Angela2005-12-14—4256206749764 Cedar Ln, Gilbert, AZ, 852190.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-59248TPASantiago E Patterson1978-05-19UHC-98029-22—6551 Mesa Dr, Charlotte, NC, 282480.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-51902TPANathan J Alvarez2004-08-06——5083 Market St, Eden Prairie, MN, 553710.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53494TPAKevin Lucas1946-07-04——7668 Indian School Rd, Mesa, AZ, 852880.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-61786TPACarl Ray1964-08-05——1930 Harbor Blvd, Mesa, AZ, 852080.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-58146TPAArthur Gray1972-04-02——7246 Church St, Tempe, AZ, 852210.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59736TPAMegan Ford1985-05-10—39836776158879 Market St, Atlanta, GA, 303600.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63616TPAAndrea M Harrison1956-06-22——1180 Meadow Ln, Phoenix, AZ, 850540.80Name split from “Last, First”Date of birth reformattedEmail lower-casedPlaceholder values cleared
TPA-62902TPAKathleen Le1987-06-08—91245840308323 Bayshore Dr # 160, Tucson, AZ, 857820.80Date of birth reformattedUnit split from streetCity re-casedPlaceholder values cleared
TPA-60764TPABradley Morris1956-11-20—5946223359—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61269TPANancy P Vega2000-02-12—67151204159590 Highland Ave, Tampa, FL, 336790.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 170 of 290PreviousNext