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

Provider network, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-27970PRVLauren Hoffman1940-07-25UHC-16769-64—1201 Meadow Ln, Jacksonville, FL, 322030.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24987PRVJean Z Collins1917-03-07——4646 Main St, Tucson, AZ, 857550.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22255PRVGregory Wagner1987-12-28UHC-51627-2294183834236925 Broadway, Miami, FL, 331050.80Two-digit birth yearPhone reformattedCity re-casedPlaceholder values cleared
PRV-20387PRVMorrison H Carl1989-06-26UHC-22994-76—7763 Hillcrest Rd, Tempe, AZ, 852910.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-25297PRVMadison Stephens1951-08-04—48232491841893 Washington St, Chandler, AZ, 852430.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20863PRVPeter E Ryan1976-02-24—55172287055547 River Rd, Tampa, FL, 336960.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20494PRVEric Wood1994-08-23UHC-89956-8935182412566996 Canyon Rd, Denver, CO, 802880.80Phone reformattedMember ID reformattedZIP+4 trimmedWhitespace trimmed
PRV-29261PRVGerald Gordon2005-01-03—43030977059126 Main St, Mesa, AZ, 852010.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24053PRVGrace Elliott1991-04-24UHC-39662-0542431809368435 Grand Ave, Dallas, TX, 752640.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26834PRVMatt Jordan1964-05-25UHC-11158-75—9371 Camelback Rd, Scottsdale, AZ, 852400.80Two-digit birth yearMember ID reformattedEmail lower-casedPlaceholder values cleared
PRV-21800PRVTerry A Berry1992-11-05UHC-47331-4865275575657774 Maple Ave, Houston, TX0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-23520PRVPeter Gomez2006-03-07UHC-23915-8485444065647109 Apache Blvd, Tampa, FL, 336760.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-21758PRVSteven Hoffman1980-11-13———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-25567PRVWillie Walsh1986-02-01——408 Sage Ct, Scottsdale, AZ, 852490.80Date of birth reformattedCity re-casedGender normalisedPlaceholder values cleared
PRV-27776PRVAnna Boyd1965-11-09UHC-73892-2854424141186021 Broadway, Dallas, TX0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-28990PRVBradley Matthews1992-07-15UHC-27612-44—6175 Highland Ave, San Antonio, TX, 782740.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26975PRVScott U Delgado1964-08-08UHC-84050-7120191285722628 Mountain View Dr, Nashville, TN, 372740.80Street suffix standardisedAddress re-casedState code upper-casedPlaceholder values cleared
PRV-21659PRVRoy Stephens2007-03-23UHC-69885-6345140380739170 Cedar Ln, Denver, CO, 802270.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-22900PRVAhmed Santiago1975-11-24UHC-80195-11—4213 Willow Ct, Tampa, FL, 336750.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28822PRVMelissa B Maldonado1971-06-16UHC-80701-5866049877887835 Church St, San Antonio, TX, 782720.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28115PRVFrank Q Hansen1998-04-09UHC-07640-6292189931131390 Mesa Dr, Los Angeles, CA0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-22304PRVDavid Marshall2008-01-19—4303141225—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-21855PRVJoseph P Sanchez1950-03-16UHC-03075-13—1777 Central Ave, San Antonio, TX, 782720.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25133PRVAndrew C Johnson1988-02-15—3665129442845 Pine Dr, Plano, TX, 750130.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-29320PRVDiana Chavez1980-02-02UHC-06047-056112894481—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29321PRVDiana Chavez1980-02-02UHC-06047-056112894481—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-20774PRVAaron Harvey2001-07-05UHC-57296-5181995997525852 Apache Blvd, Glendale, AZ0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-20667PRVLawrence Montgomery1986-11-18—5985851297201 Church St, Phoenix, AZ, 850430.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-21718PRVAlexis Q Yang1997-12-20UHC-98520-5269876306046129 Sunset Blvd, San Antonio, TX, 782000.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27489PRVPatrick Gilbert1968-05-26UHC-38235-1478170517279878 Indian School Rd, Atlanta, GA, 303000.80Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed
PRV-21848PRVMason Wagner1962-08-16UHC-02115-55——0.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-24787PRVSteve Q Taylor1995-01-19UHC-02047-8771632589712493 Desert Sky Blvd, Fresno, CA, 937810.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29052PRVJonathan Simmons1988-05-11UHC-03464-9579151502084316 Mesa Dr, Nashville, TN, 372520.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28218PRVJacob Graham1996-10-18UHC-88516-2127344261458551 Meadow Ln, Mesa, AZ, 852490.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28739PRVDonald W Alvarez1944-10-03UHC-12281-7334355732862697 Central Ave, Gilbert, AZ, 852440.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25690PRVJason Garrett1947-05-05——3428 Highland Ave, Austin, TX, 787670.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28833PRVJesse D Wang1951-05-04UHC-64399-8056279037914970 Grand Ave, Chandler, AZ, 852450.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-23196PRVAmy Woods2006-11-16UHC-17540-2761983997663130 Cedar Ln, Seattle, WA, 981420.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25561PRVAmanda McCoy2002-05-06—21371068011066 Lake View Rd, Scottsdale, AZ, 852450.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28984PRVBryan Rbinson1961-03-19—38624103566564 Maple Ave, Seattle, WA, 981910.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26542PRVJames Reid1961-07-16—74160264472241 Church St, Gilbert, AZ, 852850.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28534PRVStephanie N Ruiz1960-09-07—52487001347665 Mesa Dr, Los Angeles, CA, 900930.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20105PRVDeborah Williams1967-12-27UHC-53086-0747499144776972 Grand Ave, Miami, FL, 331640.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27596PRVRaymond Q Carlson2003-12-03—4156626976—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28071PRVDouglas Ortegga1991-01-22UHC-67942-7920923151473035 Baseline Rd, Charlotte, NC, 282670.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-24570PRVDiego U Schmiidt1989-02-24—5554641793—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24038PRVLawrence Wright1981-12-16—60458442162780 Harbor Blvd, Scottsdale, AZ, 852420.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-23792PRVKevin Mendoza1943-10-03UHC-89100-7695977014724415 Lincoln Way, Chandler, AZ, 852530.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-25536PRVChristian James1977-10-08—44291672119378 Oak St, Tempe, AZ, 852420.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27545PRVAustin V Peterson1941-12-07UHC-36139-82—879 River Rd, Glendale, AZ, 853000.80Date of birth reformattedPhone missing area codeWhitespace trimmedPlaceholder values cleared
9,596 rows, page 134 of 192PreviousNext