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-61099TPAAhmed Rose1972-11-01—90076841494535 Camelback Rd, Seattle, WA, 981430.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54043TPAAnna Thompson1973-04-05—63450697723663 Willow Ct, Sacramento, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61298TPALauren Ray1956-01-12—35680977389749 Meadow Ln, Orlando, FL, 328220.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57434TPABeverly Bennett1948-08-14—36457883234158 Indian School Rd, Denver, CO, 802910.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53809TPAJerry Lee2002-06-25—79124153088472 Main St, Mesa, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50542TPANanccy S Delgado1969-01-08——6958 Park Pl, Orlando, FL0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50753TPAJuan Hill1973-11-18UHC-37787-3376571842085687 Washington St, Phoenix, AZ, 850040.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56175TPAJudith Foster1972-07-03——6667 Elm St, Dallas, TX, 752430.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62512TPAPeter Shaw1945-03-03——4193 Baseline Rd, Charlotte, NC, 282970.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59589TPAAshley Watkins1991-02-15UHC-85690-41—35 Central Ave, San Diego, CA0.62Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-59625TPAVincent Hart1959-07-15——2540 Meadow Ln Apt 26, Nashville, TN, 372360.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50213TPAJudith Gonzales1995-04-21—9635281129144 Canyon Rd, Seattle, WA, 981950.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59924TPAJohn C Hughes1947-09-08—32833529631769 Mesa Dr, Tempe, AZ, 852160.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54836TPAAna Delgado1953-02-25—58763382781797 Oak St, Las Vegas, NV, 891670.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59514TPARobert Walsh1970-02-25UHC-24675-769523490553984 Forest Ave, Sacramento, CA, 958120.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-61023TPASofiia L Smith1988-05-13—38293828766410 Oak St, Tempe, AZ, 852570.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-54546TPAAlbert Stephens1967-02-04—29682974615794 Ridge Rd, Columbus, OH, 432130.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57158TPALarua Dunn——46822951747113 Central Ave, Atlanta, GA, 303750.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
TPA-58926TPASophia Russell1999-02-02——7724 Apache Blvd, Phoenix, AZ, 850200.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54247TPAMegan Hunter1970-08-18——7085 Mountain View Dr Apt 5, Orlando, FL, 328570.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-52420TPAGrace Rmaos1989-10-27—94127752388508 Maple Ave, Minneapolis, MN0.62Name re-casedDate of birth reformattedPhone reformattedCity re-cased+3 more
TPA-55530TPARoy X Sanders1941-06-11——1470 Willow Ct, Orlando, FL, 328180.62Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+3 more
TPA-51305TPAKatherine Castillo1953-04-28—5018561956782 Highland Ave, Houston, TX, 770920.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50298TPAFrances Dominguez1956-08-15——7201 Mountain View Dr, Minneapolis, MN, 554840.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53245TPASantiago Morales2004-08-22——8916 Meadow Ln, Orlando, FL, 328510.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51171TPAFrances Berrry1944-11-28—58781886561982 Desert Sky Blvd Apt 8, Dallas, TX, 752310.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-56761TPAKathy Watkins1972-05-26—8113903013630 Desert Sky Blvd, Charlotte, NC, 282970.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50765TPAAnna King1941-01-11——251 Main St, Eden Prairie, MN, 553230.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55485TPAAngela Marquez2001-07-12—27165831706514 Harbor Blvd, Austin, TX, 787170.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51387TPAPriya West——21541214537070 Oak St, Charlotte, NC, 282520.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
TPA-54417TPAPriya Aguilar2000-10-24—66523041596298 Pine Dr, San Diego, CA, 921430.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60882TPAJoyce Coleman1971-05-08—73554718425607 Meadow Ln # 325, Los Angeles, CA, 900680.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-54896TPAWei Carter1957-07-01UHC-20693-9763142395433729 Jefferson Ave, Phoenix, AZ, 850070.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54992TPAJose Daniels1954-04-14—51540770643947 Desert Sky Blvd, Mesa, AZ, 852930.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57645TPARaymond E Howell1980-05-23——9124 Highland Ave, Denver, CO, 802420.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59811TPASamantha Peters1997-12-01——4730 Mountain View Dr, Miami, FL, 331420.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59148TPAJacob Jensen1942-01-19—42373266495608 Meadow Ln, Denver, CO, 802600.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-55240TPANicholas Morgan1977-02-06——4559 Union St, Sacramento, CA, 958390.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-53042TPACarol Reed2001-08-23——9423 Union St, Austin, TX, 787050.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59948TPAPhilip Vasquez1942-01-18—62589858151135 Sage Ct, Jacksonville, FL, 322370.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-63408TPAKeith Kennedy2007-04-08—40485915328920 Palm Dr, Houston, TX, 770030.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62629TPADavid Price1938-01-09—65244341757458 Bayshore Dr, Columbus, OH, 432450.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64145TPAKevin Hughes1944-07-02—20640373577328 Bayshore Dr, Glendale, AZ, 853190.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60965TPAGabriel Stone1960-03-14——8339 Washington St, San Antonio, TX, 782320.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55083TPAJuan Willlis——80371773155963 Maple Ave, Phoenix, AZ, 850010.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
TPA-51265TPAPat McDonald1961-09-01——8384 Baseline Rd, Jacksonville, FL, 322860.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51368TPANatalie James1972-03-18—76894676895951 Desert Sky Blvd, Scottsdale, AZ, 852370.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-56489TPALuis Cruz1954-04-05UHC-82624-56—1564 Grand Ave, Nashville, TN, 372830.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60100TPASoto Arthur1963-03-10——487 Maple Ave, Austin, TX, 787960.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-61462TPASantiago Shaw1950-05-04——6613 Harbor Blvd, Phoenix, AZ, 850840.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 39 of 290PreviousNext