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-61822TPAAndrew Johnson1962-02-19——6062 Elm St, Sacramento, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-64126TPAJose K Carpenter———4048 Willow Ct, Plano, TX, 750490.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-61410TPADorothy Wang1974-07-20——4129 Bayshore Dr, Columbus, OH, 432680.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-59187TPABrenda Jenkins1998-06-28—44523474368124 Ridge Rd, Las Vegas, NV, 891730.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-57461TPATommy Chapman1967-01-23—86244518244340 Canyon Rd, Chandler, AZ, 852520.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58829TPAAlice Willis1944-06-18—70880544495380 Willow Ct, Nashville, TN, 372410.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51614TPAJessica G Rios1950-07-04—6348221949552 Spring St, Charlotte, NC, 282380.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53894TPABenjamin Rivera1938-09-23—46390572812529 Cedar Ln, San Diego, CA, 921950.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-55345TPACarl Cole1962-09-09——7658 Oak St, Austin, TX0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
TPA-58653TPADebra Ray1970-06-16——9349 Meadow Ln, San Diego, CA, 921060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54760TPAKayla Thompson1963-09-26—711953873989 Park Pl # 442, Mesa, AZ, 852760.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-52302TPAMegan Watkins1997-10-10—20867083432995 Mountain View Dr, San Diego, CA, 921320.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50723TPAMartha Harrison1980-03-26——7138 Lincoln Way, Denver, CO, 802880.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-61476TPAAisha Wilson1964-02-01——2473 Bayshore Dr, Nashville, TN, 372290.50SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51578TPAMegan Little1998-09-25——2116 Washington St # 340, Dallas, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-58541TPAAmy Snyder1984-12-03—76398282459570 Sunset Blvd # 484, Miami, FL, 331430.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-58713TPAMei Moreno1945-09-16——4287 Mountain View Dr, Denver, CO, 802860.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-55579TPALuis Lee1965-04-28——7876 Bayshore Dr, Phoenix, AZ, 850750.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54249TPABetty D Fields2004-09-15—84471624076147 Lincoln Way, Columbus, OH, 432280.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50039TPAGregory Morales1977-02-09——7891 Valley View Dr, Plano, TX, 750680.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-60909TPARandy Miller1997-11-14——5877 Sunset Blvd, Dallas, TX, 752860.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-56276TPAJeffrey Payne———1553 Palm Dr, Houston, TX, 770900.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-58159TPACharlotte Elliott1996-01-01——7422 Market St, Glendale, AZ, 853220.50Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-57395TPADennis Murphy1953-03-18—48072785239734 Bayshore Dr, Charlotte, NC, 282770.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58089TPAIsabella Harvey1942-01-02——3704 Highland Ave, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54767TPADennis Watkins1951-03-20——7949 Jefferson Ave, San Diego, CA, 921970.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54201TPAAisha Stephens1996-04-17——2778 Valley View Dr, Minneapolis, MN, 554350.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51014TPARyan S Boyd1998-11-04——3945 Sage Ct, Mesa, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-52228TPALawrence Ward1983-01-07UHC-20136-99—664 Elm St, Tempe, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
TPA-62060TPARichard Harrison1988-06-17——3120 Main St, Tampa, FL0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-64000TPALarry N Hamilton1963-11-20——890 Apache Blvd, Gilbert, AZ, 852640.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58912TPABilly N Valdez1968-12-02—45483237451459 Hillcrest Rd, Glendale, AZ, 853100.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
TPA-60233TPADenise Trna1986-02-18—86495062739384 Willow Ct, Glendale, AZ, 853750.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-52862TPABarbara Lynch1958-02-01——8824 Maple Ave, Austin, TX, 787420.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51720TPABryan Moreno———212 Washington St, San Diego, CA, 921150.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-51834TPAJoseph Gray1954-08-06——907 Cedar Ln # 569, Phoenix, AZ, 850440.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
TPA-54239TPAPatricia Phillips1963-07-20—85688477973971 Jefferson Ave, Los Angeles, CA0.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-59741TPAMartha Reid1981-01-12——1230 Camelback Rd, Atlanta, GA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-57282TPATheresa Fox1938-07-20—7204608474974 Park Pl, Dallas, TX, 752840.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60215TPAJackie L Wheeler1959-05-23——8137 Bayshore Dr, Plano, TX, 750110.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52409TPAAlicce Kelley1985-01-09——666 Elm St, Tempe, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-64327TPALucia Lucas1942-09-22—89484115696590 Grand Ave, Sacramento, CA0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59544TPAMason Garrett2005-06-06UHC-88787-58—6530 Bayshore Dr, Nashville, TN, 372810.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54757TPALaura W Powell1969-05-21—76877045133187 Harbor Blvd, Eden Prairie, MN, 553560.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53441TPAJordan Ferguson1969-08-05—97467056485600 Palm Dr, Eden Prairie, MN, 553360.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-63460TPASarah Sanchez1943-03-13—58332417037645 Sage Ct Apt 27, Fresno, CA0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61541TPARaymond Hicks2007-09-22—84378696787323 Baseline Rd Apt 5, Orlando, FL, 328250.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-53298TPAKelly Nunez——69342794392972 Washington St, Phoenix, AZ, 850250.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-52774TPANancy Hoffman1945-06-23UHC-67490-98—4284 Grand Ave, Phoenix, AZ, 850620.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-51225TPASantiago Nunez1954-08-27——8018 Union St, Chandler, AZ, 852360.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
14,474 rows, page 11 of 290PreviousNext