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-26870PRVKaren P Hoffmman1997-12-06—83935626607045 Mesa Dr, Las Vegas, NV, 891500.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21916PRVBobby Matthews1973-05-04UHC-97499-90—5402 Grand Ave, Tempe, AZ, 852530.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25538PRVCarl Burke1952-04-12—21525808979767 Willow Ct, Minneapolis, MN, 554640.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-22751PRVWayne W Bryant1958-12-15—64445985447704 Jefferson Ave, Eden Prairie, MN, 553410.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22910PRVGary Gutierrez2008-08-03—74157879535455 Bayshore Dr, Houston, TX, 770770.80Name split from “Last, First”Phone reformattedEmail lower-casedPlaceholder values cleared
PRV-28920PRVLinda D Ross1956-08-11—44949931903198 Sunset Blvd, San Antonio, TX, 782800.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28921PRVLinda D Ross1956-08-11—44949931903198 Sunset Blvd, San Antonio, TX, 782800.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23389PRVAlice Ortega1948-01-20UHC-20128-1275676656484708 Camelback Rd, Miami, FL, 331940.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-24873PRVPriya Castro1941-10-01——1086 Oak St, Seattle, WA, 981560.80Two-digit birth yearState code upper-casedEmail lower-casedPlaceholder values cleared
PRV-20909PRVChristian N Lawson1975-02-12—65925744295942 Baseline Rd, Gilbert, AZ0.80Date of birth reformattedPhone reformattedZIP missingPlaceholder values cleared
PRV-27931PRVMartha P Jenkins1987-01-15UHC-38108-73—8650 Apache Blvd, Sacramento, CA, 958210.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23267PRVAlexander Y Reynolds1990-08-03—69930425777344 Cedar Ln, Glendale, AZ, 853330.80Two-digit birth yearPhone reformattedCity re-casedPlaceholder values cleared
PRV-26138PRVDaniel V Mendez2000-12-08——7151 Highland Ave, Scottsdale, AZ, 852690.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22832PRVGabriel Wagner1959-04-13—4998731225—0.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28386PRVKeith O Tran1998-05-08—81227633528577 Highland Ave, Fresno, CA, 937220.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28385PRVKeith O Tran1998-05-08—81227633528577 Highland Ave, Fresno, CA, 937220.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23951PRVSandra Williamson1981-10-08UHC-46877-794939425136—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24369PRVMason Lucas1969-06-01UHC-82569-2743855681432967 Mesa Dr, Chandler, AZ, 852000.80Name re-casedCity re-casedGender normalisedPlaceholder values cleared
PRV-22116PRVLogan Lane1953-01-13UHC-29585-4323347385619736 Sunset Blvd, Tampa, FL, 336640.80Phone reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-25179PRVBrittany M Kennedy1981-03-19UHC-32345-1763881789757007 River Rd, Nashville, TN, 372590.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-28649PRVGloria Lopez1942-12-10UHC-27080-0466341138641893 Central Ave, Tempe, AZ, 852230.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28378PRVJordan Moore1991-03-02UHC-88341-3783025007278323 Union St, Tampa, FL0.80Phone reformattedZIP missingEmail lower-casedPlaceholder values cleared
PRV-24957PRVAlex Ross1957-08-23—95462898562466 Harbor Blvd, Seattle, WA, 981760.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20066PRVAustin Stone1949-11-17—46255305744169 Jefferson Ave Apt 22, Chandler, AZ, 852520.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
PRV-25322PRVKvein Cunningham1962-09-09—2608973093—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23176PRVGabriel Ferguson1942-03-27UHC-41111-77—8354 River Rd, Plano, TX, 750870.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26658PRVTimothy Phillips2005-07-25UHC-10844-403038615081—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-22254PRVLogan R Burton——35227313209374 Canyon Rd, Houston, TX, 770170.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22253PRVLogan R Burton——35227313209374 Canyon Rd, Houston, TX, 770170.80Date of birth missingPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26760PRVPeter Johnson1978-09-24—23358248951545 Spring St, San Diego, CA0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-26706PRVChristina Graham1948-09-14UHC-81316-402953714632—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-25162PRVRobert Soto1978-02-19———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-20289PRVAndrew Morgan1987-12-08UHC-78457-248403931682—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21392PRVShirley Harris1973-06-03—45742269877248 Broadway, Chandler, AZ, 852690.80Phone reformattedCity re-casedState name converted to codePlaceholder values cleared
PRV-20098PRVEric Sims1947-06-04UHC-69655-072535772240—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26551PRVSean Yang1978-12-20—69890190217871 Desert Sky Blvd, Miami, FL, 331940.80Name re-casedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-22837PRVDeborah Berry1940-01-16—58678505655487 Maple Ave, Houston, TX, 770080.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28607PRVJose Day2004-10-04UHC-65678-0132841628873940 Desert Sky Blvd, Plano, TX, 750350.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20996PRVPamela Fuller1946-11-06UHC-53055-9877289595463164 Hillcrest Rd, Gilbert, AZ, 852480.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23283PRVSusan N Howard1994-01-09—30356829459163 Willow Ct, Plano, TX, 750890.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27005PRVBenjamin Stephens2000-09-03UHC-97938-4757979371967552 Sunset Blvd, Scottsdale, AZ, 852630.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24351PRVAustin Wood1985-10-06UHC-01868-34—5714 Cedar Ln, Atlanta, GA, 303560.80Name re-casedPhone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-28159PRVCheryl Ward1988-01-06UHC-07157-6434395686711620 Lake View Rd, Denver, CO, 802040.80Date of birth reformattedPhone reformattedState name converted to codePlaceholder values cleared
PRV-24638PRVDiego Jimenez1957-09-14—7204520066—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24639PRVDiego Jimenez1957-09-14—7204520066—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24713PRVTimothy Robertson1952-01-06UHC-04478-9742495150292331 Valley View Dr, Orlando, FL, 328200.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28799PRVDenise Pena1998-08-10—97479759528859 Lake View Rd, Tucson, AZ, 857110.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-22014PRVArjun Martinez1971-11-27—80751089291250 Union St, Scottsdale, AZ, 852720.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22869PRVTyler Bradley1984-12-11—55728471493905 Cedar Ln, Seattle, WA, 981780.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-26280PRVMaria Fissher1979-01-17UHC-18891-7774036815655536 Washington St, Charlotte, NC, 282280.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
9,596 rows, page 141 of 192PreviousNext