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-50685TPAJohnny Santiago2005-10-04———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52491TPARay Patel1947-12-18——5334 Meadow Ln, Denver, CO, 802920.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59084TPAJuan Hunter2000-02-24——7276 Lake View Rd, Mesa, AZ, 852660.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58234TPAElizabeth Hansun1981-10-23——1726 Elm St, San Antonio, TX, 782470.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-52819TPAMelissa Carroll1977-10-15——8073 Sunset Blvd, Sacramento, CA, 958050.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53235TPARobert Patel1998-01-08——7450 Lake View Rd, Seattle, WA, 981460.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58794TPAArjun Jones1979-06-19——5653 Spring St, Mesa, AZ, 852230.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51028TPAMargaret D Franklin1941-10-02——4443 Central Ave, Gilbert, AZ, 852740.80Date of birth reformattedCity re-casedGender normalisedPlaceholder values cleared
TPA-51360TPADiego Daniels1953-10-13——3198 Highland Ave, Eden Prairie, MN, 553570.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62795TPALori Miller1942-02-11——138 Harbor Blvd, Nashville, TN, 372420.80Date of birth reformattedCity re-casedState name converted to codePlaceholder values cleared
TPA-63115TPAChristine Snyder1993-04-25——5818 River Rd, Gilbert, AZ, 852990.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53549TPAAisha Myers1995-02-19—44342121305623 Sage Ct, Fresno, CA, 937440.80Name re-casedPhone reformattedSSN last four extractedPlaceholder values cleared
TPA-50013TPASara Contreras1973-04-10——4401 River Rd, Seattle, WA, 981590.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56226TPAWalter Hunt1952-06-14—97169958001006 Sage Ct, Phoenix, AZ, 850520.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54039TPAMadison Graham1967-03-23——4121 Jefferson Ave, Atlanta, GA, 303250.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59195TPASamantha Ward1988-04-23——2150 Church St, Gilbert, AZ, 852110.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52169TPAKimberly Wilis1954-04-24——5805 Park Pl, San Diego, CA, 921060.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-54520TPAEvelyn McDonald1960-11-01UHC-62319-26—1973 Sage Ct, Chandler, AZ, 852420.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56688TPAKyle Harrison1967-05-15——2106 Mountain View Dr, Gilbert, AZ, 852170.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53077TPAJkae Kim1958-07-15——8072 Elm St, Jacksonville, FL, 322910.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-58975TPAChristian Cruz1992-06-03—3976202117—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-56987TPAArthur Kim1948-09-28——1383 Maple Ave, Phoenix, AZ, 850950.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59007TPATerry Ford1994-10-01——9719 Market St # 759, Dallas, TX, 752860.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-63996TPADiane Fuller1957-04-08—26035604585890 Apache Blvd, Houston, TX, 770640.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54496TPAMartha Price——8369054353—0.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-50090TPAIsabella Fernandez1959-07-24——9875 Forest Ave, Eden Prairie, MN, 553040.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54790TPATimothy Y Ward1976-11-04——2898 Broadway, Austin, TX, 787690.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53998TPAGerald Walker1988-02-15UHC-73481-57—4371 Apache Blvd, Glendale, AZ, 853220.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63554TPAOlivia Myers2008-06-12——369 Apache Blvd, Los Angeles, CA, 900230.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-54041TPAJason Gordon1952-06-05—2277306812—0.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
TPA-63132TPAMarcus Luna1955-03-12—23488319945242 Lake View Rd, Tampa, FL, 336230.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63495TPALiz Riley1963-05-28——2183 Bayshore Dr, Denver, CO, 802250.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-53375TPAArthur Espinoza2003-07-16——9292 Indian School Rd, Tampa, FL, 336900.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-62104TPARandy Lawrence1968-05-03—91240500854645 Washington St, Seattle, WA, 981530.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58980TPACamila L Miller1956-04-10——9117 Willow Ct, Tucson, AZ, 857270.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61301TPAAnn Harrison1944-09-10—26671806414159 Market St, Sacramento, CA, 958660.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-56358TPAJulie Ellis1997-11-19UHC-11000-88—444 Baseline Rd, Charlotte, NC, 282470.80Date of birth reformattedPhone missing area codeEmail lower-casedPlaceholder values cleared
TPA-62561TPAAshley Hill1960-06-11——3073 Jefferson Ave, Phoenix, AZ, 850000.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-62271TPAJoan Clark1944-05-16—40553375901521 Lake View Rd, Columbus, OH, 432060.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-55822TPAJanice E Weber1972-01-16—29046259174750 Grand Ave, Tucson, AZ, 857150.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
TPA-57085TPAKimberly Powell1978-12-05——2043 Spring St, Gilbert, AZ, 852050.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60512TPASean Garrett1941-08-10—75095546763081 Indian School Rd, Tampa, FL, 336620.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59249TPASanttiago Patterson1978-05-19——6551 Mesa Dr, Charlotte, NC, 282480.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51976TPASofia Lynch1995-01-03——2142 Meadow Ln, Dallas, TX, 752700.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51975TPASofia Lynch1995-01-03——2142 Meadow Ln, Dallas, TX, 752700.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52001TPAJudith Carroll1939-03-06——9103 Church St, Phoenix, AZ, 850750.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52669TPACheryl Snyder1988-09-06—97727238446293 Palm Dr, Houston, TX, 770970.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52668TPACheryl Snyder1988-09-06—97727238446293 Palm Dr, Houston, TX, 770970.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-54479TPAOlivia Sanders1948-04-06——9646 Church St, Tampa, FL, 336040.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51605TPAVictoria Moore2003-01-28———0.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
14,474 rows, page 167 of 290PreviousNext