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-59225TPABrittany Hudson1966-07-21——1462 Canyon Rd, Minneapolis, MN, 554470.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-52378TPABobby Foster1999-04-05——8924 Oak St, Los Angeles, CA, 900260.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53318TPADaniel Wong1981-07-10——4430 Meadow Ln, Jacksonville, FL, 322350.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57567TPAHarold Simmons1948-07-21——1157 Desert Sky Blvd, Gilbert, AZ, 852270.80Name re-casedSSN last four extractedState code upper-casedPlaceholder values cleared
TPA-50173TPARalph Elliott1993-06-26UHC-06749-672268174021—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-51831TPAKevin Baker2001-01-12——9150 Church St, Jacksonville, FL, 322250.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61613TPADiane Cox1947-05-26UHC-99365-35—4429 Harbor Blvd, Phoenix, AZ, 850310.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64201TPATim Nunez1982-04-25UHC-87616-0671092596993333 Church St, Los Angeles, CA, 900150.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56945TPADiana Fields1990-09-26UHC-61484-5040432114881618 Jefferson Ave, Chandler, AZ, 852050.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56555TPADroothy Hudson1988-11-08——3077 Meadow Ln, Minneapolis, MN, 554370.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63259TPAAdam Burns1964-04-28—69822699287744 Willow Ct, Atlanta, GA, 303950.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62509TPAAngela Johnston1938-09-11——6887 Forest Ave, Fresno, CA, 937540.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50528TPABob Anderson1993-09-12——7064 Sunset Blvd, Denver, CO, 802940.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56898TPAAisha Gordon1975-06-12UHC-01782-66—1950 Canyon Rd, Chandler, AZ0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
TPA-62640TPADonald Gomez1938-04-07——6300 Ocean Ave, Plano, TX, 750110.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51182TPAThomas Soto1907-03-01UHC-25252-21—3604 Spring St Apt 14, Tempe, AZ, 852010.80Name re-casedDate of birth reformattedUnit split from streetPlaceholder values cleared
TPA-62814TPABeverly E Bradley1977-11-02—25840056342313 Desert Sky Blvd, Fresno, CA, 937000.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-53953TPAMaria Hansen1939-04-07——1426 Washington St, Seattle, WA, 981390.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-56639TPAHiroshi Sims2007-10-27——6745 Grand Ave, San Antonio, TX, 782970.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61770TPANancy Richards1948-06-12UHC-93715-498129566702—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-62514TPAFrances Hunter2005-04-16——3674 Oak St, Glendale, AZ, 853530.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60776TPAJames Burke2001-04-16—39382048451454 Elm St, Phoenix, AZ0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-64151TPAJulia Hill1956-09-02——8677 Indian School Rd, Chandler, AZ, 852590.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55882TPACharlotte Carrroll1940-04-25UHC-85517-38—886 Broadway, San Antonio, TX, 782070.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58138TPAKyle U Gray1998-02-04UHC-48658-50—2344 Cedar Ln, Houston, TX, 770090.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55096TPAMichael Parker1942-08-22——2195 Church St, Seattle, WA, 981580.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55095TPAMichael Parker1942-08-22——2195 Church St, Seattle, WA, 981580.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52903TPARay N Garza1963-07-27——7988 Bayshore Dr, Jacksonville, FL, 322130.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62536TPADaniel Yang1950-03-26——8826 Valley View Dr, Tucson, AZ, 857350.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61406TPADiego Snyder1944-01-08—39893418772917 Washington St, Seattle, WA, 981010.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
TPA-57857TPALuis Hoffman1991-12-19——7925 Sage Ct, Dallas, TX, 752040.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62026TPAArthur Rice2005-03-06—2665327781—0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55222TPAPatrick Le2007-07-13———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56714TPACarlos Richardson1994-06-02——9280 Forest Ave, Minneapolis, MN, 554580.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52499TPASharon Lynch1977-12-04UHC-62183-25—8452 Desert Sky Blvd, Miami, FL, 331570.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57020TPAEugene Hall1955-04-30—38391358428430 Palm Dr, Orlando, FL, 328680.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57866TPAAisha Nguyen1985-06-09———0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55547TPARoy Hart1938-02-10——241 Forest Ave, San Antonio, TX, 782020.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54080TPAEthan Dixon1987-11-14——7408 Desert Sky Blvd, Seattle, WA, 981430.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-59402TPASandra Foster2001-07-19——2551 Pine Dr, Columbus, OH, 432520.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63851TPACynthia Martinez1996-09-25——7315 Broadway, Gilbert, AZ, 852270.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-63852TPACynthia Martinez1996-09-25——7315 Broadway, Gilbert, AZ, 852270.80Name re-casedDate of birth reformattedState name converted to codePlaceholder values cleared
TPA-58538TPAEthan J Dean1958-02-12——8968 Elm St, Mesa, AZ, 852690.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63677TPATimothy Robinson1984-01-20——2406 Maple Ave, Miami, FL, 331380.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57440TPAKevin Reid1941-06-13——7948 Meadow Ln, Scottsdale, AZ, 852320.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51615TPAJessica G Rios1950-07-04——552 Spring St, Charlotte, NC, 282380.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61758TPABeverly Morris1960-03-26UHC-42035-49—502 Mesa Dr, Mesa, AZ, 852200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59351TPAMari P Luna1998-08-15——801 Indian School Rd, Glendale, AZ, 853320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59985TPAEdward Jenkins1970-06-11—62144376117960 River Rd, Minneapolis, MN0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
TPA-58483TPAGloria Ross1983-08-24UHC-95778-74—4616 Forest Ave, Minneapolis, MN, 554980.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
14,474 rows, page 179 of 290PreviousNext