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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
PRV-26208PRVAna Hamilton—UHC-11133-362183834671176 Baseline Rd, Las Vegas, NV, 891210.68Date of birth missingState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-22525PRVJose P Dean1950-05-02UHC-46188-06——0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
PRV-23527PRVSean Fuller1986-08-24UHC-36745-7694242633668628 Spring St, Charlotte, NC, 282000.68Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code
PRV-21979PRVRuth Mason1990-01-14—75580122302577 Maple Ave, Eden Prairie, MN, 553810.68Phone reformattedState name converted to codeZIP+4 trimmedPlaceholder values cleared
PRV-21499PRVCharlotte D Pierce1952-11-13——6045 Meadow Ln, San Antonio, TX, 782650.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22576PRVAlexander N Hall1964-08-13UHC-37831-18—1436 River Rd, Nashville, TN, 372920.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-25112PRVMartha Henderson2008-10-26—38963772686710 Washington St, Minneapolis, MN0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
PRV-28398PRVMariana K Henry1946-04-24—23682915884336 Desert Sky Blvd, Mesa, AZ, 852370.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-25863PRVTeresa Lawrence1988-05-24UHC-66781-07—5047 Pine Dr, Houston, TX, 770820.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
PRV-27544PRVAaron Nnez1987-02-13——4931 Market St, Tucson, AZ, 857390.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20710PRVGrace Mills1984-07-03UHC-19336-6426623297851298 Main St, Tempe, AZ, 852170.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-25036PRVWil Gonzales1977-08-17UHC-92544-3746293918252689 Market St, Minneapolis, MN, 554750.68Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed
PRV-21608PRVBrian X Martin1955-12-12—2929755523—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-21831PRVBilly N Austin1944-10-09—7098406444386 Ocean Ave, San Diego, CA, 921710.68Middle initial moved out of first namePhone reformattedGender normalisedWhitespace trimmed
PRV-21269PRVScott Moreno1984-10-06—80985236323320 Cedar Ln, Dallas, TX, 752450.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-28521PRVLuis Blakc1993-12-20—86539413916457 Broadway # 676, Tempe, AZ, 852760.68Phone reformattedUnit split from streetState name converted to codePlaceholder values cleared
PRV-25555PRVKJunk2001-03-24UHC-80415-305789416159—0.68Two-digit birth yearPhone reformattedPlaceholder values clearedNo usable name (quarantined)
PRV-28849PRVOmar CJunk1943-10-14—95671789181000 Washington St, Dallas, TX, 752470.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
PRV-22099PRVJeffrey Roberts1942-04-13——2278 Hillcrest Rd, Gilbert, AZ, 852740.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
PRV-27727PRVHannah Munoz1942-11-28UHC-67975-18—9778 Ridge Rd, Plano, TX0.68Phone missing area codeMember ID reformattedZIP missingPlaceholder values cleared
PRV-22181PRVMaria I Estrada1953-05-25—67237126565526 Valley View Dr, Jacksonville, FL0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-23627PRVDennis X Silva1974-02-09UHC-33614-22—5392 Market St, Mesa, AZ, 852380.68Name re-casedPhone missing area codeGender normalisedPlaceholder values cleared
PRV-20379PRVDonald J Brown2007-05-16UHC-36042-295009602474—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27220PRVBryan Hanson2007-11-19—5988138737—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28977PRVMaria M Dunn1994-05-25—4276668119—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
PRV-28976PRVMaria M Dunn1994-05-25—4276668119—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
PRV-22692PRVEugene Jones1966-02-20UHC-84030-43—1907 Broadway, Chandler, AZ, 852950.68Name split from “Last, First”SSN last four extractedAddress re-casedPlaceholder values cleared
PRV-25548PRVMichelle Carpenter2004-12-26UHC-19794-4044662478221416 Spring St, Scottsdale, AZ, 852150.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-28591PRVJohn F Bell1979-07-03—31260683124113 Market St # 328, Tucson, AZ, 857850.68Phone reformattedUnit split from streetState name converted to codePlaceholder values cleared
PRV-23578PRVHenry Gmez1957-07-16——8724 Bayshore Dr, Scottsdale, AZ, 852110.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27836PRVIsabella Lopez1942-02-10UHC-11066-76—2688 Maple Ave, Nashville, TN, 372800.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28697PRVGloria Martin1989-09-15UHC-38570-4365967318756216 Canyon Rd, Miami, FL, 331550.68Name split from “Last, First”Phone reformattedState name converted to codePlaceholder values cleared
PRV-20553PRVEmily Warren1996-07-11UHC-27010-24—2811 Central Ave, Austin, TX, 787300.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29527PRVGeorge Y Ramos1962-03-15——2114 Willow Ct, Seattle, WA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-26119PRVMary Nunez1967-06-23—4078082756326 Willow Ct, Houston, TX, 770490.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
PRV-20118PRVWilliam G Burton——39086480157872 Main St, Nashville, TN, 372240.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27050PRVRyan Myers1951-06-28UHC-22890-6852251742933563 River Rd Apt 30, Plano, TX, 750310.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-28347PRVCheryl Armstrong1967-04-06UHC-23457-56—1762 Lake View Rd, San Diego, CA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
PRV-28686PRVStephen Kelley1976-11-11—6827089888—0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
PRV-22380PRVThomas Espinoza1980-07-04UHC-83698-81—8979 Market St, Eden Prairie, MN, 553020.68Phone missing area codeState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-29137PRVKathryn Watkins1957-03-14UHC-05724-6734345259902121 Union St, Nashville, TN, 372610.68Name split from “Last, First”Phone reformattedSSN last four extractedPlaceholder values cleared
PRV-26516PRVBrittany P Garcia1976-07-09UHC-27108-6185948708869096 Meadow Ln, Phoenix, AZ, 850070.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28647PRVRebecca E Cox1997-02-09UHC-65252-8835825090378322 Sage Ct, Orlando, FL, 328580.68Middle initial moved out of first nameStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27868PRVHannah Ford1986-05-08UHC-68283-9336696981435236 Willow Ct, Fresno, CA, 937520.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-29159PRVBrandon Z Johnson1987-01-18UHC-07574-4622872492303554 Park Pl Apt 25, Tucson, AZ, 857380.68Phone reformattedUnit split from streetState name converted to codePlaceholder values cleared
PRV-24565PRVTyler Luna1977-07-09—85691581431937 Meadow Ln, Atlanta, GA, 303610.68Phone reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
PRV-25347PRVJordan Z Perry1955-11-17—62095296526145 Sunset Blvd Apt 15, Phoenix, AZ0.68Phone reformattedUnit split from streetZIP missingPlaceholder values cleared
PRV-28623PRVBranndon Davis1984-01-06UHC-42245-62—1491 Jefferson Ave, Glendale, AZ, 853710.68City re-casedState name converted to codeGender normalisedPlaceholder values cleared
PRV-27834PRVJanet A Jimenez1962-03-12—30087207174320 Ocean Ave, Las Vegas, NV, 891750.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20145PRVLawrence Sanchez—UHC-61874-0722370782936912 Baseline Rd, Tucson, AZ, 857160.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 71 of 192PreviousNext