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-60074TPATony Hunter2003-02-28—43280520347734 Desert Sky Blvd, Atlanta, GA, 303380.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61558TPAJessica Pierce1960-03-20——1226 Jefferson Ave, Los Angeles, CA, 900200.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51530TPAGary Richardson1954-08-03——5154 Mountain View Dr, Eden Prairie, MN, 553360.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-53266TPALawrence Li1995-04-25—77853380972804 Cedar Ln, Phoenix, AZ, 850240.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62029TPACarlos Lane2005-05-06——8291 Desert Sky Blvd, Nashville, TN, 372440.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50897TPADaniel Lawrence1978-07-10UHC-97508-2287266984998162 Spring St, Plano, TX, 750040.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-53530TPACarolyn W Kelley1991-02-21—87878649143821 Market St, Tucson, AZ, 857150.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60153TPADonald Weaver1967-07-01—87198820239560 Valley View Dr, Columbus, OH, 432030.76Date of birth reformattedPhone reformattedGender normalisedPlan code upper-cased+2 more
TPA-51174TPAChris Fox1950-04-28——3691 Hillcrest Rd, Atlanta, GA, 303200.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52038TPAShirley Gomez1997-05-20—44356659714826 Bayshore Dr, Glendale, AZ, 853830.76Phone reformattedCity re-casedGender normalisedPlan code upper-cased+2 more
TPA-64436TPAJacob Wagner1987-08-08——6552 Cedar Ln, Denver, CO, 802390.76Name re-casedDate of birth reformattedCity re-casedState name converted to code+2 more
TPA-58528TPATheresa Carroll2008-02-25—63032692397403 Baseline Rd, Scottsdale, AZ, 852730.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50225TPAJoseph Jordan1959-10-27—24182465988423 Palm Dr, Las Vegas, NV, 891430.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52484TPAMason Morales1942-02-27——9675 Indian School Rd, Tempe, AZ, 852700.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51101TPAJanet A Graham1965-01-05—20756436927239 Lincoln Way, Phoenix, AZ, 850340.76Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
TPA-58592TPAGerald Gerrero1960-07-06—89751142499677 Sunset Blvd, Las Vegas, NV, 891350.76Street suffix standardisedAddress re-casedCity re-casedPlan code upper-cased+2 more
TPA-54919TPARoy Olsson1956-12-13——6965 Indian School Rd, Houston, TX, 770290.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61490TPAValentina Morris2000-09-25——1890 Mesa Dr, Austin, TX, 787940.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63779TPADebra Bennett1984-09-06——5322 Indian School Rd, Columbus, OH, 432910.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60089TPAKathleen Fisher1940-06-22—40525612738461 Harbor Blvd, San Diego, CA, 921080.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63803TPANiicholas Holmas1951-03-17—97674011166938 Bayshore Dr, Eden Prairie, MN, 553730.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58552TPAKelly Perry1963-08-16——6792 Maple Ave, Fresno, CA, 937830.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54104TPATimothy Perez1940-01-24——3824 Oak St, Miami, FL, 331970.76Date of birth reformattedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
TPA-58775TPAKathryn Y Robinson1968-05-13——3930 Palm Dr, Las Vegas, NV, 891710.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60871TPABradley Russell1977-02-07——3277 Bayshore Dr, Sacramento, CA, 958330.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-51667TPAFtima Green1971-01-19—8975855235764 River Rd, Minneapolis, MN, 554420.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54309TPAAna Cunningham1972-03-03UHC-35095-3545479994631845 Desert Sky Blvd, Scottsdale, AZ, 852990.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-61419TPABetty Bennett1983-07-08—77850391195946 Forest Ave, Tempe, AZ, 852050.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62678TPAMaria Payne1975-10-03——820 Canyon Rd, Scottsdale, AZ, 852700.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59030TPAPriya Gutierrez2005-09-07——2606 Elm St, Charlotte, NC, 282790.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60210TPAJudith Q Hicks1972-05-26——7709 Desert Sky Blvd, Sacramento, CA, 958010.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60461TPABarbara Hudson1946-06-16——3512 Forest Ave, Fresno, CA, 937470.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55428TPABarb Schultz1997-02-25—73034326271266 Spring St, Dallas, TX, 752940.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57495TPARoss Ruth1973-06-03——4968 Lincoln Way, Chandler, AZ, 852850.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50900TPADanile Lawrence1978-07-10—87266984998162 Spring St, Plano, TX, 750040.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54735TPADanielle R Clark1984-08-14——8705 Palm Dr, Scottsdale, AZ, 852230.76Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57169TPAJames Myers1980-04-20UHC-80186-79—493 Market St, Miami, FL, 331850.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54625TPASean Silva1959-05-03—76733565257819 Church St, Chandler, AZ, 852210.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59375TPAEmma Hayes1947-11-22——7363 Cedar Ln, Charlotte, NC, 282150.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50133TPAEdward Wilson2006-07-10—72173110268344 Bayshore Dr, Denver, CO, 802150.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-64190TPASharon Alvarado1977-06-14——3441 Mountain View Dr, Eden Prairie, MN, 553460.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57024TPABrenda Harper1940-05-15—92085326467291 Ocean Ave, Mesa, AZ, 852540.76Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50875TPARichard Wright1972-01-03UHC-96272-7289045037895994 Ridge Rd, Sacramento, CA, 958660.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52295TPARobert Ross1997-08-18——6404 Central Ave, Gilbert, AZ, 852240.76Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60131TPARalph Washington1977-07-06——3498 Meadow Ln, Plano, TX, 750770.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57064TPAJerry I Salazar1990-01-10——6001 Ridge Rd, San Antonio, TX, 782190.76Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58523TPAAustin Cunningham2005-12-11——4366 Forest Ave, Phoenix, AZ, 850020.76Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
TPA-57287TPAAhmed Black1995-11-24UHC-40100-1056528723754516 Indian School Rd, Fresno, CA, 937200.76Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55253TPACarol R Walker1986-08-16—2052651534384 Grand Ave, Orlando, FL, 328700.76Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-50647TPAMarcus Mendez1998-01-10—7578791239878 Camelback Rd, Chandler, AZ, 852870.76Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
14,474 rows, page 127 of 290PreviousNext