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-20373PRVFatima Davis1997-04-15—933422874135 Cedar Ln, Chandler, AZ, 852590.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25917PRVSamel Sullivan2006-01-05—35653451982208 Indian School Rd, Seattle, WA, 981820.80Name re-casedPhone reformattedSSN last four extractedPlaceholder values cleared
PRV-24412PRVCarlos Estrada1968-05-07—90232428192063 Hillcrest Rd, San Diego, CA, 921650.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28294PRVLucia West1988-02-09UHC-68232-57—3770 Indian School Rd, Tampa, FL, 336500.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-26032PRVRaymond Mills1957-05-17UHC-11438-1549866160545768 Forest Ave, Eden Prairie, MN, 553550.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-27760PRVMariana Hamilton——8583358665—0.80Date of birth unreadablePhone reformattedEmail lower-casedPlaceholder values cleared
PRV-27189PRVMariana V Stwart1984-05-09——4958 Indian School Rd, Houston, TX, 770560.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26958PRVLarry Cox1983-06-01UHC-25922-9595537066584973 Grand Ave, Tampa, FL0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-25327PRVAnn Sims1973-12-20——3815 Palm Dr Apt 30, Phoenix, AZ, 850500.80Date of birth reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-22574PRVPaul Holmes1953-01-28UHC-05951-7344654126605401 Forest Ave, Scottsdale, AZ, 852540.80Two-digit birth yearPhone reformattedMember ID reformattedPlaceholder values cleared
PRV-27473PRVNicholas Kennedy1968-01-24UHC-20724-9270756363074906 Main St, Phoenix, AZ, 850450.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20319PRVJason I Garrett2002-09-09—28378726694930 Lincoln Way, Tucson, AZ, 857770.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
PRV-28816PRVJoshua Stewart1988-02-15—66189795341223 Sunset Blvd, Seattle, WA0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-24439PRVVirginia Jackson1958-05-09UHC-96033-993025990288—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21186PRVDaniel Matthews1942-11-06—79939577276458 Washington St, Miami, FL, 331900.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24800PRVDavid V Davis1948-04-05UHC-44621-946969462810—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21703PRVBenjamin Harvey1949-06-01—61960528922760 Apache Blvd, Tucson, AZ, 857440.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26421PRVBarb T Martniez1961-08-20—30944288873302 Sunset Blvd, Fresno, CA0.80Name re-casedPhone reformattedZIP missingPlaceholder values cleared
PRV-23562PRVSteve Evans2005-02-27—39637167194867 Central Ave, Glendale, AZ, 853770.80Street suffix standardisedAddress re-casedPlan code upper-casedWhitespace trimmed
PRV-26814PRVPhilip Fox1993-12-25—81244552509588 Highland Ave, Tucson, AZ, 857110.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-28434PRVRebecca W Riley1968-05-03—2593428950—0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-26017PRVTyler K Li1940-02-08UHC-35505-93—3573 Grand Ave, Las Vegas, NV, 891110.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23954PRVTheresa S McDonald1945-11-19—72298762659572 Baseline Rd, Glendale, AZ, 853320.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26998PRVJacqueline Wang1950-06-12—4087750630—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-20156PRVAdam Turner1942-05-16—83321315062295 Bayshore Dr, Chandler, AZ, 852700.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28899PRVRoger Bailey1992-01-21——6556 Willow Ct, Denver, CO, 802380.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-26768PRVIsabella Munoz1982-05-16—93263574064246 Main St # 707, Nashville, TN, 372740.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-24140PRVChristine Green1954-06-08—93062454672440 Market St, Los Angeles, CA, 900720.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24572PRVAmy G Reynolds1948-05-26—55561863545432 Meadow Ln, Tempe, AZ, 852250.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-20245PRVSofia Chavez1996-12-23UHC-70365-92—3709 Sunset Blvd, Los Angeles, CA, 900670.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22831PRVCheryl Daniels1974-11-24UHC-88831-9892638794925417 Palm Dr, Fresno, CA, 937820.80Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased
PRV-22248PRVJoe Turner1997-09-21—61176243903679 Lincoln Way, Denver, CO, 802270.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
PRV-27475PRVArthur Washington2000-07-27—72568027317566 Willow Ct, Gilbert, AZ, 852940.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21838PRVKatherine Gray1953-09-10UHC-59420-1867839264567566 Bayshore Dr, Gilbert, AZ, 852990.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-23687PRVSusan X Cunningham1972-05-03UHC-54309-4930289570211351 Baseline Rd Apt 33, Gilbert, AZ, 852660.80Phone reformattedUnit split from streetCity re-casedPlaceholder values cleared
PRV-20071PRVDaniel Wang1972-09-13UHC-64801-149435359067—0.80Two-digit birth yearPhone reformattedMember ID reformattedPlaceholder values cleared
PRV-29316PRVDonna Mason2002-04-14—96782611861781 Forest Ave, San Antonio, TX, 782450.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22492PRVMateo Fuller1997-07-09UHC-83792-604945434855—0.80Name re-casedTwo-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-24373PRVDoris X Carroll1985-10-24—47760281465143 Indian School Rd, Dallas, TX, 752950.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24021PRVAnna Alvarez1944-08-10UHC-05857-44—4436 Willow Ct, Eden Prairie, MN, 553470.80Phone missing area codeState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-26621PRVJudy Carroll2006-05-24UHC-24401-9890482926202492 Mountain View Dr, San Diego, CA, 921570.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
PRV-28857PRVNatalie M Johnston1963-03-03—42785567402698 Elm St, Atlanta, GA, 303060.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-25866PRVNoah Greene1950-02-17—67644169811784 River Rd, Atlanta, GA, 303000.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22393PRVRalph S Jacobs1973-08-05UHC-30664-273638756339164 Ocean Ave, San Diego, CA, 921680.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-23280PRVCharles C Bryant1969-02-06UHC-01319-0342161402495690 Lincoln Way, Sacramento, CA, 958380.80City re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-28214PRVShirley Murray1962-02-06—29772472181832 Apache Blvd, Denver, CO, 802670.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20933PRVTereesa Wanng1980-01-09—96554292321451 Spring St, Los Angeles, CA, 900510.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
PRV-23758PRVStephanie Chavez1946-04-09UHC-88000-5496257288875606 Cedar Ln, Fresno, CA, 937290.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28665PRVBrittany Patel2007-11-28UHC-64753-2072170125717747 Apache Blvd Apt 35, Mesa, AZ, 852800.80Name re-casedDate of birth reformattedUnit split from streetPlaceholder values cleared
PRV-21074PRVScott G Schultz1938-06-06UHC-40594-6843249355166925 Bayshore Dr, Tampa, FL, 336990.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
9,596 rows, page 135 of 192PreviousNext