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-57453TPAJack J Sanders1976-03-04UHC-47245-413625589261607 Union St, Gilbert, AZ, 852440.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50252TPAFrances Wilson1940-10-21——9472 Willow Ct, Mesa, AZ, 852270.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61641TPADenise Ryan1968-12-17——7619 Palm Dr, Denver, CO, 802050.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56210TPAGibson Michael1986-02-27—81573794516105 Main St, Los Angeles, CA, 900790.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60120TPAChristine Graham1955-05-24—65980308121820 Mesa Dr, Denver, CO, 802980.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-63332TPAOmar C Jacobs1943-10-14——1000 Washington St, Dallas, TX0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50007TPAKathryn Austin1955-03-27——4907 Spring St, Denver, CO0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61311TPALuis Green1964-04-24UHC-57723-185752658492873 Indian School Rd, Fresno, CA, 937830.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56835TPARuth Hall1968-09-24—2722957547470 Apache Blvd, Columbus, OH, 432900.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57835TPABryan Simmons1947-11-10—552793883967 Bayshore Dr, Atlanta, GA, 303640.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56305TPAGeroge Clark1957-12-20UHC-07697-40—2954 Bayshore Dr, Eden Prairie, MN, 553060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57812TPAEric Nunez—UHC-54081-90—4557 Indian School Rd, Charlotte, NC, 282540.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-59679TPACynnthia Jenkins1996-07-15——3297 Ridge Rd, San Antonio, TX0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52078TPANicole Bowman1978-12-16—83553517633795 Lincoln Way, Tampa, FL, 336830.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-57047TPARyan Elliott1962-07-01—83230839105526 Sunset Blvd Apt 8, San Antonio, TX, 782600.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-59815TPALinda Ross1969-06-14UHC-27507-9742978427659275 Ridge Rd Apt 2, Chandler, AZ, 852460.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-51875TPANaathan Greene1974-10-10——277 Cedar Ln Apt 34, Columbus, OH, 432360.50Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+3 more
TPA-51383TPAVincent Brooks1946-11-09——1195 Ridge Rd, Eden Prairie, MN, 553000.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-57486TPAJoe Q Powell———5587 Harbor Blvd, Tampa, FL0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-56913TPANoah Black1999-05-15——9551 Baseline Rd, Scottsdale, AZ, 852390.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-51344TPAMargaret James1943-09-04——831 Grand Ave # 328, Tempe, AZ, 852400.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-50332TPADouglas Morales1952-08-19—91724543532023 Maple Ave, Gilbert, AZ, 852260.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61156TPAEmily Sims1991-09-03——9820 Ocean Ave, Phoenix, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60931TPAMarucs Griffin1955-02-22——6506 Spring St, Phoenix, AZ0.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-62088TPARoger Davis1994-04-28—21141955144491 Elm St, Miami, FL, 331680.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62534TPAShirley Meyer1976-09-12—2663373260413 Cedar Ln, Seattle, WA, 981870.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-63180TPAAisha Salazar1953-11-10——2129 Jefferson Ave, Nashville, TN, 372920.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-64457TPAHarold Andarson1979-02-28—85531047399783 Market St # 413, Chandler, AZ, 852760.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-54766TPAPriya Jimenez1962-12-10——1209 Central Ave, Dallas, TX, 752420.50Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more
TPA-50969TPABetty Luccas1984-12-10——8176 Mesa Dr, Nashville, TN, 372120.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54231TPAGabriel Wagner1959-04-13—49987312256034 Apache Blvd, Jacksonville, FL, 322310.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-54892TPAPatrick Alexander1968-08-09——1326 River Rd # 958, Austin, TX, 787210.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-51900TPABradley W George1978-09-01——114 Highland Ave, Denver, CO, 802260.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61570TPALcuia Morrison1949-08-08——3272 Forest Ave, Dallas, TX, 752430.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-60721TPASteve Boyd2007-08-18——283 Spring St, Plano, TX, 750940.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53188TPARihard Santos1947-06-15——7248 Main St, Mesa, AZ, 852170.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-59830TPAMichael Reynolds2006-01-17—44272165626996 Cedar Ln, Dallas, TX, 752890.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63269TPADenise Pena1998-08-10——8859 Lake View Rd, Tucson, AZ, 857110.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-59334TPATheresa Jimenez1982-01-13—87569072202263 Bayshore Dr, Eden Prairie, MN0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-59333TPATheresa Jimenez1982-01-13—87569072202263 Bayshore Dr, Eden Prairie, MN0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-57320TPADouglas Jones1993-04-21UHC-06739-807159927250533 Willow Ct Apt 13, Chandler, AZ, 852300.50Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
TPA-54821TPAHelen McCoy2004-04-17——5375 Oak St, Mesa, AZ, 852150.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63172TPAJesse D Lewsi——78045422172263 Oak St, Gilbert, AZ, 852330.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58564TPACharlotte Vasquez1989-12-02UHC-33932-81—6142 Cedar Ln, Jacksonville, FL, 322260.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61220TPAPatrick Gilbert1986-05-26UHC-38235-14—9878 Indian School Rd Apt 12, Atlanta, GA0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-55509TPABradnon White2000-04-11—69637928141696 Apache Blvd, Las Vegas, NV, 891710.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50292TPAYuki E Berry1953-01-02——5752 Lincoln Way, Atlanta, GA, 303540.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61823TPADeborah Wallace1971-01-20—72736635537441 Ocean Ave, Nashville, TN, 372270.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58133TPABradley Powell1988-12-02——5426 Camelback Rd, Plano, TX, 750590.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64015TPAWilliam Rodriguez1993-05-23UHC-66982-37—2554 Market St, Columbus, OH, 432960.50Name split from “Last, First”Member ID reformattedSSN last four extractedStreet suffix standardised+3 more
14,474 rows, page 16 of 290PreviousNext