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-58635TPAAnrold Mariana1973-01-18—62086091397880 Ocean Ave, Tempe, AZ, 852160.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60365TPARyan Cox1954-05-17——8127 Desert Sky Blvd, Phoenix, AZ, 850560.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59708TPAGary J Young2001-11-25UHC-27384-74—9289 Meadow Ln, Plano, TX, 750750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59604TPAEric James1977-02-03UHC-07217-69—1977 Lincoln Way, Houston, TX, 770000.78Member ID reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58129TPAMaria F Castillo1955-10-06——3511 Ocean Ave, Seattle, WA, 981610.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63140TPALauren Franklin1954-12-22———0.78Name split from “Last, First”Date of birth reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-60324TPAJames Smith1942-08-18—73457102973221 Oak St, Chandler, AZ, 852420.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-54391TPAAmber E Hamilton1974-09-16———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-55753TPAKevin Mendoza1943-10-03—95977014724415 Lincoln Way, Chandler, AZ, 852530.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52008TPABrian McCoy1948-03-27UHC-41653-5386068731615981 Hillcrest Rd, Seattle, WA, 981020.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58235TPALuis Nichols1972-03-13UHC-68522-2725182779993220 Apache Blvd, Nashville, TN, 372810.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-63078TPADoris James1972-03-15——9312 Pine Dr, Glendale, AZ, 853590.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55564TPAMark Hamilton1957-09-22—8333017423775 Willow Ct, Denver, CO, 802070.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-59701TPADaniel D Sanchez1968-03-01——1280 Mesa Dr, Eden Prairie, MN, 553960.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52673TPAAndrea Woood2008-06-21——2241 Desert Sky Blvd, Minneapolis, MN, 554050.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52537TPAElijah Sims1991-05-19——2636 Highland Ave, Sacramento, CA, 958890.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50147TPAJoe X Hudson1988-08-22——22 Grand Ave, Scottsdale, AZ, 852130.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64339TPAKimberly Gutierrez1944-05-12——8251 Sage Ct, Tucson, AZ, 857960.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-50826TPATimothy Jensen1976-10-04—55958146751467 Harbor Blvd, Charlotte, NC, 282800.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59178TPAAna Ortiz1959-05-28—62474251181779 Central Ave, Atlanta, GA, 303360.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52532TPAPeggy Bryant1965-09-06—27940777121180 Union St, Houston, TX, 770990.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51588TPADonna Myers1946-06-08UHC-96895-1894925552286536 Lake View Rd, Charlotte, NC, 282090.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59451TPAJesse U Cunningham1968-06-09——7036 Grand Ave, Tampa, FL, 336020.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55986TPASuphia Hill1975-08-12UHC-72031-8929084164654128 Spring St, Denver, CO, 802180.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51742TPABrenda Dominguez1938-09-27—97743739972854 Maple Ave, Miami, FL, 331200.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52184TPASara Padilal1981-07-06——690 Main St, Tampa, FL, 336830.78Name re-casedDate of birth reformattedCity re-casedGender normalised+1 more
TPA-61246TPAAmber Baker1975-02-20—95829584418203 Bayshore Dr, Austin, TX, 787270.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61245TPAAmber Baker1975-02-20—95829584418203 Bayshore Dr, Austin, TX, 787270.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55278TPABrian Hoffman1965-06-22——3389 Baseline Rd, Gilbert, AZ, 852450.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53655TPATom Richardson1996-01-21UHC-44503-57—8105 Bayshore Dr, Tucson, AZ, 857750.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62996TPAAlice Lynch1989-07-03UHC-35217-7589425124396986 Baseline Rd, Mesa, AZ, 852760.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-56029TPAKaren Luna1990-04-10——4710 Sage Ct, Los Angeles, CA, 900310.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61747TPAKeith Dixon1996-03-02UHC-52659-75——0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-53160TPAAlan W Lynch1971-03-12UHC-94055-27—1005 Desert Sky Blvd, Orlando, FL, 328370.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54188TPAJoan Garrett1950-03-20——9201 Cedar Ln, Austin, TX, 787500.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55296TPAMichael Johnston2000-12-13UHC-29125-148518116559590 Bayshore Dr, Columbus, OH, 432390.78Phone reformattedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-57044TPADaniel Oliver1977-10-05UHC-94684-5138193000063603 Union St, Tampa, FL, 336680.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62093TPADeborah Perry1941-09-28—48160850491929 Oak St, Fresno, CA, 937770.78Phone reformattedState code upper-casedGender normalisedWhitespace trimmed+1 more
TPA-54105TPAChristian Rojas2002-10-10UHC-82285-2877399203812152 Oak St, Phoenix, AZ0.78Phone reformattedCity re-casedZIP missingWhitespace trimmed+1 more
TPA-60004TPAMichelle Burns1938-06-03——4095 Park Pl, Dallas, TX, 752050.78Name re-casedDate of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-63556TPASarah Evans2005-06-24——834 Cedar Ln, Eden Prairie, MN, 553560.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-64027TPADanielle Rodriguez1978-12-08——4491 Pine Dr, Columbus, OH, 432500.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56749TPAPamela Wilson1942-07-21—9678349119175 Camelback Rd, San Antonio, TX, 782800.78Name re-casedDate of birth reformattedPhone reformattedState name converted to code+1 more
TPA-56424TPAAmy M Romero1953-04-25——5444 Union St, Phoenix, AZ, 850610.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55661TPARobert Hall1946-03-22——1833 Oak St, Sacramento, CA, 958930.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55662TPARobert Hall1946-03-22——1833 Oak St, Sacramento, CA, 958930.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55558TPAJanet Young1976-05-24—24257051943328 Oak St, Nashville, TN, 372800.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50844TPARachel Duncan1956-12-06—44630541757976 Meadow Ln, Denver, CO, 802060.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-62576TPAMegan Y Edwards2006-06-04—65867940404207 Spring St, Phoenix, AZ, 850580.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55681TPALucia Brown1972-06-26—23474505635327 Maple Ave, Houston, TX, 770920.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 142 of 290PreviousNext