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-57061TPAHenry W Kennedy1990-11-13——9131 Oak St, Fresno, CA, 937000.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-51001TPASandra Wouds1950-04-09UHC-62281-29—2795 Broadway, Denver, CO, 802320.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-52670TPAGeorge Hawkins1952-08-07——6268 Ridge Rd, Chandler, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-50858TPATyler Mitchell1981-06-17———0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-50934TPAGary Munoz1965-10-25—73760188158538 Ocean Ave, Nashville, TN, 372250.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58204TPACharles James1985-01-01——6831 Desert Sky Blvd, Miami, FL, 331070.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-53194TPAHeather K Arnold1939-10-06UHC-93459-97——0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-54608TPATimothy Martin1985-02-15——5826 Maple Ave, Fresno, CA0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54842TPAAlice J Vasquez2002-04-17———0.82Date of birth reformattedSSN last four extractedPlaceholder values cleared
TPA-61418TPABobby Graham1946-06-21UHC-35937-07—7881 Palm Dr, Nashville, TN, 372720.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64412TPABen Olson1977-02-25——3921 Lincoln Way, Jacksonville, FL0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54248TPAAnn Jecobs1982-08-04——5062 Lake View Rd, Fresno, CA, 937380.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-54204TPAJessica Grant2004-10-17———0.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-51783TPAEmily Jenkins2001-03-17——7216 Canyon Rd # 636, Austin, TX, 787000.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-54075TPAAlan Nichols1964-11-07———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-50901TPARay Scott1988-07-05—22331222217866 Lincoln Way, Denver, CO, 802280.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-61797TPAJacob Stone1974-08-15——3481 River Rd, Atlanta, GA, 303790.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-54534TPAAlice Marshall1988-11-22UHC-34390-2866986418065036 Bayshore Dr, Plano, TX, 750090.82Member ID reformattedZIP+4 trimmedPlaceholder values cleared
TPA-50123TPAJacob Hamilton1987-09-19—72521737769073 Grand Ave, Columbus, OH, 432140.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-62967TPABryan C Rose1991-01-28—48138863383255 Broadway, Chandler, AZ, 852550.82Phone reformattedSSN last four extractedWhitespace trimmed
TPA-61854TPACharlotte Kennedy————0.82Date of birth missingWhitespace trimmedPlaceholder values cleared
TPA-55766TPAEric Cox1958-03-26UHC-62852-94—1825 Meadow Ln, Chandler, AZ, 852970.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55765TPAEric Cox1958-03-26UHC-62852-94—1825 Meadow Ln, Chandler, AZ, 852970.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-63735TPADiana V Dixon1999-02-21——6630 Washington St, San Antonio, TX, 782460.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61275TPADenise Adams——8638571973—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-60952TPAElizabeth Meyre————0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-55351TPAJoshua Jensen2002-08-16—81322175625857 Cedar Ln, Dallas, TX, 752520.82Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-52595TPABenjamin W Brown1951-08-19———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-60297TPAVirginia Guerrero1945-06-21—5128171485—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-55146TPAAnn Williamson1963-04-10——402 Elm St, Miami, FL, 331070.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55145TPAAnn Williamson1963-04-10——402 Elm St, Miami, FL, 331070.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57042TPASean H Walsh1940-11-14——1571 Union St, Glendale, AZ, 853470.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50145TPAAmber Berry1946-10-13——7840 Hillcrest Rd, Minneapolis, MN, 554750.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61754TPAHannah Daniels1985-05-22——73 Bayshore Dr, Phoenix, AZ, 850610.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-58251TPAChristian James1977-10-08UHC-82723-91—9378 Oak St, Tempe, AZ, 852420.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-57056TPAMaria Fernandez1991-07-03——3638 Canyon Rd, Gilbert, AZ, 852800.82Email lower-casedGender normalisedPlaceholder values cleared
TPA-56995TPAJesse Keley1954-06-03——6169 Camelback Rd, San Antonio, TX, 782170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56608TPASofia Rice1966-12-03——7745 Meadow Ln, Charlotte, NC, 282500.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54411TPAJulie Sims1980-02-25—51269447074819 Valley View Dr, San Antonio, TX, 782200.82Name split from “Last, First”Date of birth reformattedPhone reformatted
TPA-52684TPAWei Daniels2007-10-20UHC-15768-48——0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-57388TPAZachary Kennedy2001-01-05—5616811350505 Oak St, Mesa, AZ, 852970.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-62613TPAHaroold O Perkins2007-02-14—8162288594—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-52754TPAAlexis L Rodriguez1965-01-09——8359 Camelback Rd, Seattle, WA, 981990.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-59772TPAChristina Payne1944-11-02———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-57758TPAMason Espinoza1941-11-26——9727 Canyon Rd, Scottsdale, AZ, 852560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62544TPAArthur Rivera1966-04-15UHC-43347-56—8948 Apache Blvd, Houston, TX, 770540.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-59952TPANatalie Dixon1946-12-08——2013 Forest Ave, Scottsdale, AZ, 852080.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59427TPATimothy J Hicks1998-07-05———0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-56437TPADouglas ZJunk1972-11-26———0.82Name re-casedPlaceholder values clearedNo usable name (quarantined)
TPA-59040TPACal Rivera1980-12-03——5451 Grand Ave, Eden Prairie, MN, 553700.82Street suffix standardisedAddress re-casedPlaceholder values cleared
14,474 rows, page 203 of 290PreviousNext