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-50951TPABenjamin Obriien1938-08-21UHC-68311-7350193480703925 Central Ave, Glendale, AZ0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-59900TPAWillie Myers1941-07-13——283 Lake View Rd, Las Vegas, NV, 891890.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55042TPAMateo Harrison1960-10-10——7955 Maple Ave, Scottsdale, AZ, 852310.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55457TPAWei Dunn1980-05-05——8050 Jefferson Ave, Chandler, AZ, 852200.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55474TPASusan Clark1983-12-06——9001 River Rd # 391, Houston, TX, 770350.78Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more
TPA-59105TPAVirginia Anderson2004-06-06—72564400549727 Baseline Rd # 447, Tampa, FL, 336840.78Date of birth reformattedUnit split from streetEmail lower-casedWhitespace trimmed+1 more
TPA-54462TPASandra Tucker1962-06-06——4843 Grand Ave, San Diego, CA, 921760.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51015TPAMary Bennett1943-09-13——7846 Main St, Scottsdale, AZ, 852140.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-53925TPAJoyce Watkins1994-02-16——8082 Apache Blvd, Houston, TX, 770920.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53644TPAMark Crawford2007-09-21UHC-01977-3776923210872051 Grand Ave, Las Vegas, NV, 891180.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-57306TPANoah Turner1949-03-28——441 Palm Dr, Chandler, AZ, 852870.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-56765TPAKeith Williamson1976-03-27—30087778321299 Valley View Dr, Phoenix, AZ, 850150.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62505TPADennis Dean1974-02-06——863 Forest Ave, Gilbert, AZ, 852730.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52238TPAKaren Salazar1977-11-07UHC-08069-2343993196825885 Jefferson Ave, Columbus, OH, 432170.78Name re-casedDate of birth reformattedPhone reformattedGender normalised+1 more
TPA-61241TPACarl N Coleman1970-03-15—98476691393129 Church St, San Antonio, TX, 782880.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59824TPAMarcus Yang1959-05-24——4981 Lake View Rd, Columbus, OH, 432500.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-62291TPADylan Cole2004-07-01UHC-93588-47—6513 Cedar Ln, Phoenix, AZ, 850860.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50499TPAWayne B Dunn1945-09-03——3943 Grand Ave, Tampa, FL, 336280.78Date of birth reformattedEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-51531TPAGary Richardson1954-08-03——5154 Mountain View Dr, Eden Prairie, MN, 553360.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-58283TPAStephen Alexander1977-05-25—91656363711435 Indian School Rd, Austin, TX, 787010.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57579TPAJudith Cole1994-02-04—53743402684995 Mountain View Dr, Denver, CO, 802410.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-55038TPACharles A Little1951-04-09UHC-26339-1258435171302376 Washington St, Fresno, CA, 937400.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52651TPAAlbert Maldonado1950-08-11—22138952603570 Main St, Scottsdale, AZ, 852900.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60025TPAWilliam O Kelly2007-10-22UHC-90416-44—1416 Jefferson Ave, Gilbert, AZ, 852160.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-59638TPANacy Howard1994-02-07—38064225531720 Willow Ct, Las Vegas, NV, 891120.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52807TPABilly Bennett1953-01-25——1043 Sage Ct, Seattle, WA, 981270.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54441TPAEthan Green1996-12-01—7945294957714 Canyon Rd, Jacksonville, FL, 322120.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52429TPABruce Ramos1984-03-06——6296 Main St, Glendale, AZ, 853470.78Name re-casedDate of birth reformattedPhone missing area codeWhitespace trimmed+1 more
TPA-53532TPAYuki Dominguz1982-09-13UHC-20110-2357335522652794 Camelback Rd, Nashville, TN, 372910.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50142TPARussell Delgado1987-05-25——6154 Church St, Nashville, TN, 372210.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57847TPAAlbeert Hunt2002-08-01——5402 Park Pl, Eden Prairie, MN, 553240.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62513TPADanielle C Grant1943-09-06——9196 Harbor Blvd, Charlotte, NC, 282870.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52460TPAJean Mills1961-04-07——6528 Grand Ave, Columbus, OH, 432320.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62517TPAScott Medina1938-03-06——637 Spring St, Orlando, FL, 328550.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59047TPABenjamin Weaver1996-08-10—96357969133047 Willow Ct, Columbus, OH, 432040.78Two-digit birth yearPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-57384TPASamuel Montgomery1946-10-24——1004 Pine Dr, Sacramento, CA, 958790.78Street suffix standardisedAddress re-casedState code upper-casedEmail lower-cased+1 more
TPA-51237TPAMaria A Palmer1989-09-08UHC-46148-48—7366 Palm Dr, Scottsdale, AZ, 852740.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-64007TPAWilliam Vargas1981-12-28——24 Forest Ave, Gilbert, AZ, 852070.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63468TPAEvelyn Hudson1989-06-07UHC-95299-09—1021 Grand Ave, Plano, TX, 750340.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-57485TPASara Burton1941-10-24—4926145177—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-52440TPALawrennce Warren1961-05-03——7599 Indian School Rd, Miami, FL, 331500.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59288TPAStephen C Vega1962-12-18——8354 Maple Ave, Denver, CO, 802520.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58108TPABrittany Feguson1960-11-14——8443 Valley View Dr, Fresno, CA, 937290.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61491TPACamila Herrera1946-01-08——6176 Park Pl, Glendale, AZ, 853800.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53381TPARoger George1983-01-10——1902 Washington St, Atlanta, GA, 303620.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54325TPAMartha G Gonzaales1941-04-22UHC-09453-25—1995 Church St, Atlanta, GA, 303750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58861TPALauren F Diza1956-12-14——6254 Bayshore Dr, Nashville, TN, 372770.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51334TPANicholas Carter1938-12-23——8213 Apache Blvd, Orlando, FL, 328430.78Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-50055TPAPhilip Santos1947-01-20UHC-90436-31—5673 Broadway, Austin, TX, 787610.78Date of birth reformattedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-58110TPALucia Dixon1993-11-24——7092 Highland Ave, Dallas, TX, 752910.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 133 of 290PreviousNext