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-52156TPAAmy McDonald——79178476223775 Valley View Dr, Sacramento, CA, 958490.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-60571TPAKenneth Piarce1955-03-28UHC-87501-9095228792903947 Harbor Blvd, Dallas, TX, 752160.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54917TPANancy Wright1988-08-12—23383542247666 Oak St, Los Angeles, CA, 900400.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60658TPAMichelle Black1997-12-14—88091570488695 Lincoln Way, Atlanta, GA, 303980.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52004TPAJason Q King1976-08-06——9255 Palm Dr # 995, Fresno, CA, 937510.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51287TPACarolyn Ward2004-03-16UHC-59025-3251622976299472 Desert Sky Blvd, Chandler, AZ, 852980.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61838TPAEllijah L Montgomery1993-03-04—24990777657134 Jefferson Ave, Nashville, TN, 372340.62Name re-casedPhone reformattedState name converted to codeEmail lower-cased+3 more
TPA-53026TPARuth Hoffman1997-04-14——1820 Market St, Mesa, AZ, 852440.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60384TPAAmy Myers1950-09-21——5533 Valley View Dr, Charlotte, NC, 282230.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-55518TPAJason Gutierrez1971-06-19——4563 Mesa Dr, Glendale, AZ, 853020.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-55294TPADouglas Obrien1966-08-26——6471 Church St, Chandler, AZ, 852310.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53562TPABill Weaver2005-10-15UHC-50237-8152629845408974 Indian School Rd # 851, Atlanta, GA, 303550.62Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51879TPAWillis Patrick1966-07-03—41144048271850 Cedar Ln, Denver, CO, 802330.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53229TPAGeorge Mrphy1998-10-14——2791 Elm St, Fresno, CA, 937780.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-61765TPABarbara Cooper1993-09-17—49274285261440 Forest Ave, Tempe, AZ, 852450.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50186TPAHarold Sullivan1988-06-21——7597 Pine Dr, San Antonio, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54492TPAJanet Wagner1975-06-23—90630793489750 Meadow Ln, Sacramento, CA, 958090.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51761TPARyan Jimenez1955-06-10—27650957532708 Forest Ave, Denver, CO, 802940.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54971TPADanielle Fernandez1975-04-03——46 Meadow Ln, Eden Prairie, MN0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51718TPAHiroshi Dean1990-01-21UHC-65896-8741379832348478 Lincoln Way Apt 10, Austin, TX, 787840.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-60242TPALaura Schmidt2005-07-10—56997521194315 Union St, Mesa, AZ, 852300.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58179TPARussell Brown1941-07-27—2794659772654 Forest Ave, Orlando, FL, 328040.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57174TPAMadison Taylor1957-08-22—296798565916 Ocean Ave, Jacksonville, FL, 322990.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55898TPAAmber Alexander1960-05-26—23063840438353 Oak St, Jacksonville, FL, 322300.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-51885TPAMadison Simmons1964-01-08—61167408966893 Sage Ct, Denver, CO0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59733TPABilly Collins1941-06-06——1834 Mountain View Dr, Austin, TX, 787620.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54740TPAAshley Gibson2005-08-12——8818 Maple Ave, Phoenix, AZ, 850450.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57978TPASharon Ortiz———8541 Main St, Miami, FL, 331500.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
TPA-60944TPALiz Nunez2008-08-01—40687181955625 Washington St, Sacramento, CA, 958320.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-53661TPABrandon Johnston1993-03-05——5819 Jefferson Ave, Minneapolis, MN, 554790.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-61606TPACamila Chen1977-01-12UHC-66437-324166840302130 Harbor Blvd Apt 23, Glendale, AZ, 853270.62Name re-casedPhone reformattedMember ID reformattedUnit split from street+3 more
TPA-62831TPAEmily Nichols1955-03-08UHC-42390-8596220227559636 Union St, Scottsdale, AZ, 852570.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-58094TPATheresa Cooper1955-01-21—40553674145258 Lake View Rd Apt 21, Tempe, AZ, 852210.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-61852TPAJacob Harris1938-07-16—50795452953560 Indian School Rd, Tempe, AZ, 852260.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55656TPACarol Russell2000-08-10—68031310191060 Apache Blvd, Nashville, TN, 372210.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58864TPANicholas Hughes1972-12-17UHC-36357-5531698364174572 Maple Ave, Eden Prairie, MN, 553150.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58100TPAJoe Florse1994-08-08——6068 Sunset Blvd, Charlotte, NC, 282830.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59306TPABradley U Foster1961-10-06—48929453185329 Ridge Rd # 658, Orlando, FL, 328910.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-60274TPAMadison Kelly1952-05-25UHC-20054-54—5238 Sage Ct, Nashville, TN0.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63206TPABarbara Peters1951-04-10—62239284104436 Maple Ave, Tampa, FL, 336500.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53872TPAVincent Riz1997-09-22——2484 Central Ave, Eden Prairie, MN0.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-50847TPACharlotte Alexander2001-07-07—7703446462903 Meadow Ln, Houston, TX0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64305TPATeresa A Roberts1955-11-12—50328472237920 Main St, Glendale, AZ, 853210.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59808TPARyn Reed1955-01-18——7022 Elm St, Charlotte, NC, 282890.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-63584TPAJudith Knight1991-09-15UHC-83763-8898768781809676 Sage Ct, Columbus, OH, 432690.62Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
TPA-51069TPAWei W Ruiz1994-04-06—93572133605871 Church St, Columbus, OH, 432240.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-54540TPAJeremy Cook1948-08-19—50557156907234 Indian School Rd, Columbus, OH, 432390.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53524TPAChristine X Chen1943-01-02—90129377867525 Apache Blvd, Atlanta, GA, 303970.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60062TPAWilliam Reyes1940-08-06—23143690336141 Union St, Jacksonville, FL, 322560.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50839TPAKyle Phillips1964-08-19——4114 Cedar Ln, Chandler, AZ, 852350.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
14,474 rows, page 36 of 290PreviousNext