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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-61505TPAAbigail Davis2009-12-21—88621671047333 Maple Ave, Nashville, TN, 372700.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60305TPAJuliia Meyer1969-08-25UHC-95875-4793354745905564 Central Ave Apt 35, Minneapolis, MN, 554740.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-57041TPAArjun Harris1953-10-27UHC-71965-17—777 Lake View Rd, Eden Prairie, MN, 553980.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-59789TPAJeremy Richards1952-10-11——2676 Highland Ave, Tempe, AZ, 852930.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58017TPANancy Larson1977-02-14——4282 Park Pl, Nashville, TN, 372920.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61975TPAKibmerly Hart1940-11-22——1388 Spring St, San Diego, CA, 921450.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53645TPABrenda W Banks1977-01-16———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53752TPARay Helen——5923516637—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54808TPAMelissa Sims1949-08-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54807TPAMelissa Sims1949-08-02———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-54084TPABobby Edwardds2004-07-11——3734 Desert Sky Blvd, Austin, TX, 787320.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-61163TPAPhilip Bailey2006-02-08UHC-50588-65—4686 Ocean Ave, Miami, FL, 331180.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-62856TPAAmber Z Olson1965-06-20—6602446586—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-52212TPAMichelle Smith2003-05-10——5366 Main St, Fresno, CA, 937690.80City re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-63849TPAAnthony Wrd1982-02-06——1081 Pine Dr, Atlanta, GA, 303970.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63593TPABradley Chen1983-05-06UHC-87280-46——0.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51403TPADiego Nunez2001-11-26——6629 Canyon Rd, Scottsdale, AZ, 852140.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64130TPACamila Jensen1989-03-15—98440327251928 Canyon Rd, Eden Prairie, MN, 553380.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53148TPAAna Price1949-12-07——605 Broadway, Jacksonville, FL0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-51252TPAJulia Gomez1999-11-19—44583300458426 Lincoln Way, Seattle, WA, 981370.80City re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-59691TPANancy Dean1947-05-23—83474633873690 Union St, Glendale, AZ, 853590.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50011TPASarah Collins1940-09-18——6195 Camelback Rd, Mesa, AZ, 852750.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62809TPAPalmer J Anna1961-01-03——3351 River Rd, Denver, CO, 802390.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-50451TPAGarrett I Jason——2837872669—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52136TPAZachary Simpson1941-12-20—22060577067880 Ocean Ave, Denver, CO0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-50606TPAJose Olson2003-05-28UHC-32021-7697682704095299 Elm St, Jacksonville, FL, 322100.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56490TPAJose Carlson1959-11-04——2996 Elm St, Fresno, CA, 937440.80Name re-casedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-53869TPABeverly Wilson1942-07-05——6056 Forest Ave, Jacksonville, FL, 322890.80City re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55201TPAHenry Yang1987-12-03——4104 Highland Ave, Dallas, TX, 752980.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-50130TPADanielle Oliver1947-05-28——4173 Maple Ave, Dallas, TX, 752250.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-63376TPATerry Payne2007-04-07——1535 Apache Blvd, Atlanta, GA, 303230.80Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed
TPA-63271TPAAngela G Martinez1942-09-13———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-55325TPAPhilip P Banks1949-01-18——9150 Ridge Rd, Mesa, AZ, 852320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-62504TPAMatthew Nguyen1999-02-14——9648 Jefferson Ave, Columbus, OH, 432800.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-50031TPAGeorge Ellis1977-04-27UHC-39266-32—8317 Elm St, Miami, FL, 331810.80Street suffix standardisedAddress re-casedPlan code upper-casedPlaceholder values cleared
TPA-54297TPAScott Morris1976-05-10—56268687507172 Central Ave, Columbus, OH, 432230.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51038TPAElizabeth Olson1939-01-23—51941259397186 Camelback Rd, Las Vegas, NV, 891980.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53107TPAHenry Rodriguez1938-05-03——5598 Jefferson Ave, Jacksonville, FL, 322430.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-51509TPADavid Hall1948-06-04—5856060670766 Central Ave, Denver, CO, 802520.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55615TPAChristina Larson1955-07-09——4690 Ridge Rd, Scottsdale, AZ, 852550.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52825TPAPhilip Bradley1945-06-28UHC-47879-8262998444732457 Hillcrest Rd, Minneapolis, MN, 554480.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-62898TPABrandon Fox1977-08-01——7835 Meadow Ln, Phoenix, AZ, 850920.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-62004TPABryan Burke1998-09-15——8698 Bayshore Dr, Dallas, TX, 752280.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55271TPAPamela U Ortega1956-08-27——871 Baseline Rd, Seattle, WA, 981570.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57733TPAJudy E Vega1996-03-15—9157390906—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-63473TPAKevin Andrews1982-03-06——7867 Ocean Ave # 777, San Diego, CA, 921140.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-52708TPAAlan W Tran1970-06-06—41347928327475 Valley View Dr, Nashville, TN, 372920.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50452TPADiana Stevens1981-11-16——7736 Valley View Dr, Nashville, TN0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-63292TPAJonathan Parker1980-11-23UHC-32181-76—9061 Pine Dr, Orlando, FL, 328910.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-55364TPAEvelyn Gonzales1962-02-20—7034106660942 Valley View Dr, San Antonio, TX, 782740.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 190 of 290PreviousNext