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-25099PRVWillie Elliott1943-01-20UHC-22957-6942361073029782 Ridge Rd, Tempe, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-20453PRVHannah Patterson1981-05-01UHC-91930-094365168470801 Hillcrest Rd, Los Angeles, CA, 900720.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-23063PRVCarol Hart1945-05-28UHC-35612-34—7981 Pine Dr, Austin, TX, 787890.66Date of birth reformattedSSN last four extractedState name converted to codeEmail lower-cased+1 more
PRV-20001PRVLaura Alvarado1939-03-06——4347 Church St Apt 36, Plano, TX, 750860.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-25258PRVRobert Palmer1977-11-13—89032214002089 Ocean Ave, Miami, FL0.66Phone reformattedState name converted to codeZIP missingWhitespace trimmed+1 more
PRV-24239PRVEmma McDonald2004-12-11—34730941692008 Central Ave, Jacksonville, FL, 322170.66Name split from “Last, First”Two-digit birth yearCity re-casedWhitespace trimmed+1 more
PRV-25185PRVMark Larson—UHC-26773-8842240149537442 Indian School Rd, Scottsdale, AZ, 852230.66Name re-casedDate of birth missingPhone reformattedGender normalised+1 more
PRV-21451PRVPeter Wallace1974-02-10UHC-28274-41——0.66Name split from “Last, First”Date of birth reformattedSSN last four extractedWhitespace trimmed+1 more
PRV-25880PRVNoeh Hunt2004-06-14UHC-24276-3743693898183532 Highland Ave # 266, Seattle, WA, 981170.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-21367PRVMorgan Benjamin1941-05-03——8904 Main St Apt 25, Fresno, CA, 937090.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-23220PRVJean Thomas1942-09-05—22992082572362 Mesa Dr, Tempe, AZ, 852090.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-25854PRVJulia Sanchez2004-12-07—26874248975416 Forest Ave, Glendale, AZ, 853430.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
PRV-26042PRVAshley Ramos1994-03-27—93859219021140 Forest Ave, Jacksonville, FL, 322830.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-20578PRVHill Joyce1955-12-15—43040808924645 Park Pl, Scottsdale, AZ, 852810.66Phone reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
PRV-21474PRVJanice Cox1955-09-19UHC-66627-6742942394626590 Elm St, Eden Prairie, MN, 553040.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21591PRVValentina B Dnucan1952-02-08UHC-28239-7633176674185220 Indian School Rd, Los Angeles, CA, 900890.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-26407PRVCynthia Q Ortega1943-02-04—43875706278531 Mountain View Dr, Atlanta, GA0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
PRV-26471PRVRyan Nuneez1950-10-06—69531164203715 River Rd, Sacramento, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-27443PRVLawrence Moris2001-02-01——3862 Meadow Ln, Denver, CO0.66Name split from “Last, First”Date of birth reformattedZIP missingWhitespace trimmed+1 more
PRV-23173PRVMateo I Weber1955-04-19——3648 Elm St, Miami, FL, 331840.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-21543PRVRalph Castro1969-02-21—22537055921774 Elm St # 851, Mesa, AZ, 852270.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-21164PRVAhmed Y Perez——96622424433435 Broadway, Sacramento, CA, 958110.66Name split from “Last, First”Date of birth unreadableCity re-casedWhitespace trimmed+1 more
PRV-29008PRVAndrea N Kim1939-01-18UHC-58093-272789198035152 Market St, Houston, TX, 770220.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-28974PRVMaria Alexander1979-05-05UHC-74312-70—7164 Camelback Rd, Houston, TX, 770370.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-20687PRVRussell U Jensen1960-08-26UHC-60553-9786462834163170 Main St, Scottsdale, AZ, 852740.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24784PRVVictoria Mitchell1998-08-11——2965 Forest Ave, Chandler, AZ, 852640.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-24828PRVJonathan Weaver——86893331577790 Park Pl, Nashville, TN, 372210.66Name re-casedDate of birth unreadablePhone reformattedZIP+4 trimmed+1 more
PRV-28954PRV—Junk1968-08-11UHC-98509-1525765198072551 Willow Ct, Seattle, WA, 981540.66Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared+1 more
PRV-27517PRVRuth Rose1997-12-20—95293172425846 Washington St, Miami, FL, 331430.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
PRV-21047PRVMatthew Snyer2004-11-13UHC-33098-1460394457237898 Sage Ct, Miami, FL, 331430.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-20701PRVDebra Bennett1990-11-07UHC-53451-2492083130516161 Union St, Sacramento, CA, 958380.66Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+1 more
PRV-25266PRVJose Scott1979-05-02—79154527891716 Ridge Rd, Nashville, TN0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-27073PRVMaria V Vazquez1990-06-01UHC-44744-4484491668317929 Union St, Charlotte, NC, 282300.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
PRV-20838PRVJustin Vega1963-07-18—71185336908801 Washington St, Austin, TX, 787940.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-25449PRVDavid M Larson1986-04-27UHC-94457-6850447966235735 Valley View Dr, Houston, TX, 770070.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-26565PRVRichard Morales2008-06-20——3133 Indian School Rd, Gilbert, AZ, 852670.66Phone missing area codeCity re-casedGender normalisedWhitespace trimmed+1 more
PRV-24486PRVLawrence Q Rice1963-11-14—25248959917553 Harbor Blvd, Tampa, FL0.68Phone reformattedZIP missingGender normalisedPlaceholder values cleared
PRV-26879PRVEvans Vincent2007-02-09UHC-91535-79——0.68Name re-casedPhone missing area codeGender normalisedPlaceholder values cleared
PRV-25026PRVGregory U Woods1998-03-11—85441623562736 Oak St, San Diego, CA, 921360.68Two-digit birth yearCity re-casedGender normalisedPlaceholder values cleared
PRV-28442PRVLawrence I Yang1962-11-07———0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-29115PRVTheresa Bradley1954-11-05UHC-33427-4828941788868604 Forest Ave, Sacramento, CA, 958100.68Phone reformattedState name converted to codeGender normalisedPlaceholder values cleared
PRV-21188PRVChristine Coleman1988-07-15——3974 Desert Sky Blvd, Tampa, FL0.68Name split from “Last, First”ZIP missingPlan code upper-casedPlaceholder values cleared
PRV-28203PRVMaeto Q Miller2000-08-15UHC-99133-7277185824291423 Spring St # 916, Nashville, TN, 372990.68Unit split from streetCity re-casedGender normalisedPlaceholder values cleared
PRV-26113PRVMelissa Hansen1996-03-18——5176 Lincoln Way, Las Vegas, NV, 891090.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
PRV-25724PRVLisa Hudson—UHC-49171-42719276323619 Broadway, Phoenix, AZ, 850680.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
PRV-24096PRVKyle Young1957-11-24UHC-38709-5121170344915907 Harbor Blvd Apt 6, San Antonio, TX, 782310.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-25264PRVOlivia Duncan1983-01-27UHC-66759-582285278900894 Mountain View Dr, Tampa, FL0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
PRV-22351PRVMadizon Jordan1940-07-06—62560311443870 Church St Apt 12, Chandler, AZ, 852810.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28648PRVNatalie Weber1966-08-06——3991 Hillcrest Rd, Fresno, CA, 937680.68Name re-casedTwo-digit birth yearPhone missing area codePlaceholder values cleared
PRV-29529PRVLaura U Fox1942-12-04—25425331193669 Spring St, Minneapolis, MN, 554740.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
9,596 rows, page 70 of 192PreviousNext