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-61217TPACarol Watkins1997-02-06——7919 Broadway, San Antonio, TX, 782900.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-61216TPACarol Watkins1997-02-06——7919 Broadway, San Antonio, TX, 782900.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-62573TPAJessica Welch1952-01-27——1213 Apache Blvd Apt 9, Dallas, TX, 752840.70Unit split from streetZIP+4 trimmedPlaceholder values cleared
TPA-52690TPALaura Perkins1956-09-28——5448 Baseline Rd # 300, Minneapolis, MN0.70Unit split from streetZIP missingPlaceholder values cleared
TPA-63988TPAJacqueline V Richards2004-09-10—33520607182754 Main St, Dallas, TX, 752980.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-64466TPAValentina H Jacobs1974-08-06——7801 Spring St Apt 36, Las Vegas, NV, 891330.70Two-digit birth yearUnit split from streetPlaceholder values cleared
TPA-64330TPALaura Torres1972-04-11——3253 Willow Ct, Columbus, OH0.70ZIP missingGender normalisedPlaceholder values cleared
TPA-57523TPAYuki Rios1979-11-21UHC-04431-12—2827 Central Ave Apt 10, Orlando, FL, 328830.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
TPA-64062TPACharles Stevens2004-01-25—35861529629425 Jefferson Ave, Atlanta, GA, 303820.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-63650TPARichard E Roebrtson————0.70Date of birth missingGender normalisedPlaceholder values cleared
TPA-57842TPAMaria Wagner1983-05-02—40591796349202 Camelback Rd, Seattle, WA, 981840.70Name split from “Last, First”SSN last four extractedPlaceholder values cleared
TPA-55983TPAGregory Price1944-02-04UHC-92493-94—2317 Church St # 594, Houston, TX, 770500.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
TPA-52871TPAYuki Santiago1941-04-09———0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
TPA-52831TPAJoan Bryant1976-01-01—34777816337618 Meadow Ln, Tucson, AZ, 857260.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-59794TPAJacob C Anderson1939-07-06—50255477682590 Maple Ave, Seattle, WA, 981940.70Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-53390TPAJennifer Martinez1975-04-05——3815 Highland Ave # 906, Nashville, TN, 372790.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
TPA-51307TPAJoe Gray1949-02-23—52437363002333 Apache Blvd, Mesa, AZ, 852830.70ZIP+4 trimmedGender normalisedWhitespace trimmed
TPA-63691TPAAnn Castro1997-07-15——8768 Washington St, Charlotte, NC, 282370.70Name split from “Last, First”ZIP+4 trimmedWhitespace trimmed
TPA-60892TPAPatricia L Gibson1979-12-07——7601 Hillcrest Rd, Atlanta, GA, 303270.70State name converted to codeGender normalisedPlaceholder values cleared
TPA-61576TPAAbigail Gibson1947-09-22——8715 Mesa Dr, Dallas, TX, 752390.70Name split from “Last, First”Street suffix standardisedAddress re-cased
TPA-60563TPADenise Jackson1949-03-07——3077 Valley View Dr, Tampa, FL, 336260.70State name converted to codeGender normalisedPlaceholder values cleared
TPA-59252TPABruce Lawson1951-01-03——4529 Church St # 236, Los Angeles, CA, 900630.70Two-digit birth yearUnit split from streetPlaceholder values cleared
TPA-57983TPAKayla Perez1964-12-11UHC-80886-56——0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
TPA-62179TPAJoshua Gibson1987-11-05——4752 Washington St, Tempe, AZ, 852320.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-57421TPAKathleen Howard1986-01-21——3370 Oak St, Houston, TX, 770600.70Name split from “Last, First”Phone missing area codePlaceholder values cleared
TPA-55449TPAHeather Berry————0.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
TPA-52883TPAKevin Martin1983-05-19——3725 Park Pl, Dallas, TX, 752620.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-54753TPAEric Lane1948-11-21—59863732461483 Meadow Ln, Fresno, CA, 937560.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-60520TPAJohn Hamilton1939-02-07—63658204363945 Main St, Tucson, AZ, 857490.70Name split from “Last, First”State name converted to codePlaceholder values cleared
TPA-60798TPAEric Castillo1996-03-25——8778 Ocean Ave # 605, Minneapolis, MN, 554000.70Unit split from streetGender normalisedPlaceholder values cleared
TPA-56415TPAJoyce A Tran1939-04-24—54462905683124 Grand Ave, Miami, FL, 331620.70State name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-51167TPASandra Wallace1943-05-15—63838579399327 Lincoln Way, Mesa, AZ, 852280.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-59365TPALawrence Shaw1968-10-26——1839 Ridge Rd, Columbus, OH, 432050.70Two-digit birth yearZIP+4 trimmedPlaceholder values cleared
TPA-60174TPAJeremy A Wong1939-09-08UHC-88270-98—4708 Grand Ave Apt 26, Seattle, WA, 981410.70Unit split from streetState name converted to codePlaceholder values cleared
TPA-64311TPAChristina Cooper1958-05-08——6821 Sage Ct, Miami, FL, 331790.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
TPA-50475TPAJack Hudson1946-12-16——5259 River Rd, Gilbert, AZ, 852650.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
TPA-57822TPAJoseph Wheeler1991-05-12——3173 Willow Ct, Sacramento, CA, 958920.70State name converted to codeGender normalisedPlaceholder values cleared
TPA-51277TPARonaldJunk2003-05-26UHC-91719-11—373 Oak St, Eden Prairie, MN0.70ZIP missingPlaceholder values clearedNo usable name (quarantined)
TPA-55578TPALuis Lee1965-04-28UHC-56887-73—7876 Bayshore Dr, Phoenix, AZ, 850750.70Two-digit birth yearPhone missing area codeWhitespace trimmed
TPA-57191TPASean Estrada1976-12-02——6902 Washington St # 282, Atlanta, GA, 303600.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
TPA-62481TPAGerald L Parker1970-07-24——7751 Mesa Dr, Chandler, AZ, 852280.70State name converted to codeGender normalisedPlaceholder values cleared
TPA-56922TPAWalter T Davis1950-11-05——5197 Cedar Ln, Las Vegas, NV, 891090.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
TPA-50520TPAKatherine Carpenter1949-04-23—67068394294824 Lake View Rd, Plano, TX, 750460.70Phone reformattedZIP+4 trimmedGender normalised
TPA-57560TPAJesse Dean1985-05-24——8179 Ridge Rd, Chandler, AZ, 852060.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
TPA-63582TPAJesse Bryant1948-07-25—57142827389551 Sunset Blvd # 549, Los Angeles, CA, 900890.70Unit split from streetGender normalisedPlaceholder values cleared
TPA-57399TPAFatima I Bryant2001-06-19UHC-81628-53—5830 Willow Ct Apt 23, Fresno, CA, 937000.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
TPA-60208TPAKyle Carlson2002-02-21——7284 Harbor Blvd, Glendale, AZ, 853980.70State name converted to codeGender normalisedPlaceholder values cleared
TPA-60238TPAAisha U Davis1941-09-24UHC-53783-77—7376 Broadway, Orlando, FL0.70Name split from “Last, First”ZIP missingPlaceholder values cleared
TPA-55783TPAZachary Morales1995-08-08——9060 Washington St, Tampa, FL0.70Two-digit birth yearZIP missingPlaceholder values cleared
TPA-50428TPACarolyn Lewis1996-08-27UHC-83255-14—5024 Spring St # 381, Charlotte, NC, 282540.70Unit split from streetState name converted to codePlaceholder values cleared
14,474 rows, page 102 of 290PreviousNext