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-59841TPALori Bradley1960-07-22——75 Market St, Las Vegas, NV, 891120.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59418TPATimothy Santiago1997-05-10——720 Church St, Tampa, FL, 336340.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63848TPALogan Pierce1978-12-19—38660773857115 Elm St, Dallas, TX, 752380.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56206TPALogan Wang1943-02-10——1767 River Rd, Sacramento, CA, 958620.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64063TPADanielle Wang1941-08-26———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-59276TPADenis Holmes1981-01-15—90442373688792 Elm St, Miami, FL, 331530.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57449TPAKathryn E Willis1976-11-17—98252278981590 Sunset Blvd, Columbus, OH, 432280.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59488TPADiana Vazquez1993-07-23——5173 River Rd, Jacksonville, FL, 322920.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56975TPATimothy A Robeertson1952-01-06——2331 Valley View Dr, Orlando, FL, 328200.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57078TPAKayla Riley2004-02-12—50122110522261 River Rd # 713, Dallas, TX, 752850.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-63303TPAJustin Warren2007-01-18—35290525649861 Harbor Blvd, Atlanta, GA0.80Name re-casedDate of birth reformattedPhone reformattedZIP missing
TPA-50246TPATyler L Moreno1994-11-12——1312 Ridge Rd, Seattle, WA, 981200.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-59437TPARonald Guerrero1953-09-22——8347 Market St, Scottsdale, AZ, 852620.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-59243TPAMegan V Vazquez1977-08-06——2485 Spring St, Los Angeles, CA, 900480.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54702TPAAhmed Jacobs1983-06-07——1326 Lincoln Way, Plano, TX, 750700.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51776TPAHannah Weber1985-06-16——1040 Ocean Ave, Charlotte, NC, 282220.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56852TPAMartha Campbell———2352 Broadway, Mesa, AZ, 852870.80Date of birth unreadableAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54303TPAAndrea Sanchez1987-10-28—43544431284587 Lake View Rd, Houston, TX, 770870.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-58793TPAKathryn Harvey1939-06-06——5744 River Rd, Dallas, TX0.80Name re-casedDate of birth reformattedZIP missingPlaceholder values cleared
TPA-52659TPABarbara Mejia1972-11-14UHC-89568-776926701904132 Canyon Rd, Glendale, AZ, 853850.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-54809TPAGerald Robertson1950-10-09—7873326872—0.80Gender normalisedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-52114TPAPriya Burton1971-02-22——5714 Park Pl, Columbus, OH, 432290.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57180TPALori Delgado1974-04-12——2102 Main St, Sacramento, CA, 958570.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58679TPARobert Webb1999-07-16—2977999298—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54121TPAAbby Peterson1999-01-23UHC-63835-6939130215612967 Highland Ave, Miami, FL0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-58265TPADanniel Chavez1944-07-20UHC-08743-285519881782629 Maple Ave, Los Angeles, CA, 900800.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
TPA-56694TPAElijah Hansen1966-06-28——6700 Jefferson Ave, Phoenix, AZ, 850370.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-50732TPASamantha Edwards2001-03-22——1248 Market St, Charlotte, NC, 282300.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52278TPADanielle Schultz1946-09-04—37447034719873 Mesa Dr, Miami, FL, 331200.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56158TPAJulie Morgan1943-06-26——1606 Baseline Rd, Gilbert, AZ, 852230.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56157TPAJulie Morgan1943-06-26——1606 Baseline Rd, Gilbert, AZ, 852230.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51089TPAJennifer Nunez1983-07-19——7406 Elm St, Sacramento, CA, 958510.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-55545TPAChristopher Chavez1944-04-25——5415 Forest Ave, Los Angeles, CA, 900430.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-63580TPAFatima Bowman1989-06-08———0.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-52090TPAAndrea Jimenez1988-11-18——4934 Broadway, Denver, CO, 802250.80State name converted to codeEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-52793TPASantiago Oliver2001-09-27—75236331572408 Church St, Orlando, FL, 328610.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60426TPAAshley Wong1981-05-08——3178 Baseline Rd, Houston, TX, 770830.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57004TPAAlexander Johnston2006-02-24———0.80Name split from “Last, First”Plan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-53612TPAJacqueline Moore1995-03-14——9435 Broadway # 231, Houston, TX, 770870.80Name re-casedUnit split from streetState code upper-casedPlaceholder values cleared
TPA-58099TPASantiago Dominguez1963-04-09——9297 Forest Ave, Dallas, TX, 752140.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54422TPADebra Bradley1971-01-11——1134 Maple Ave, Scottsdale, AZ, 852540.80Name re-casedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-59570TPAIsablla Santos1985-12-02——7088 Market St, Tempe, AZ, 852110.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61803TPAGary Riley1995-08-01—9718011881833 Apache Blvd # 370, Tucson, AZ, 857030.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-51264TPAAnthoony Gilbert1968-05-02———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51293TPABetsy Allen1941-02-01——6838 Washington St, Miami, FL, 331050.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63156TPAOmar Gonzalez1968-04-12UHC-96715-90—7931 Forest Ave, Plano, TX, 750520.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-64211TPAJoe Herrera1993-11-14UHC-92339-35—9242 Willow Ct, Fresno, CA0.80Date of birth reformattedState code upper-casedZIP missingPlaceholder values cleared
TPA-55981TPAKevin Price1988-06-23—57277586978595 Broadway, Austin, TX, 787860.80Phone reformattedAddress re-casedGender normalisedPlaceholder values cleared
TPA-62630TPAMelissa Valdez1958-04-10——1948 Lincoln Way, Fresno, CA, 937400.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-54342TPAJanice Reid1952-10-16—38431083825596 Spring St, Nashville, TN, 372380.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 189 of 290PreviousNext