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-26404PRVDebra I Holmes2003-01-12UHC-55286-1660247963036762 River Rd, Eden Prairie, MN, 553260.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26563PRVPat Ortega2001-07-20UHC-45462-68—348 Cedar Ln, Atlanta, GA, 303050.80Name split from “Last, First”Date of birth reformattedState code upper-casedPlaceholder values cleared
PRV-28151PRVAustin Gibson1985-01-01—9874511269—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
PRV-25306PRVDorothy E Griffin2006-12-03—27584753943762 Market St, Glendale, AZ, 853210.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-22114PRVRyan M Duncan2002-11-20—50023636688674 Willow Ct, Plano, TX, 750240.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28925PRVRoger Wallace2007-10-20UHC-81010-8746741444599216 Lake View Rd, Las Vegas, NV, 891310.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-25294PRVHiroshi Wheeler1997-03-16UHC-60484-5333758695457748 Palm Dr, Chandler, AZ, 852140.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20737PRVJerry X Johnson1966-05-03—56533900965614 Palm Dr, San Diego, CA, 921250.80Name re-casedPhone reformattedSSN last four extractedPlaceholder values cleared
PRV-24290PRVBeverly U Colllins1978-09-17UHC-66499-96—2916 Park Pl, Scottsdale, AZ, 852330.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28285PRVCatherine T Taylor1942-11-26—96153334017794 Park Pl, Las Vegas, NV, 891460.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
PRV-28353PRVBetty Weber1956-07-23—55079619979852 Spring St, Miami, FL, 331180.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-20664PRVNancy Bennett1940-03-16UHC-28664-9241225559217655 Bayshore Dr, Denver, CO, 802440.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28323PRVSarah Lewis2001-04-11—58422714632010 Sunset Blvd, Dallas, TX, 752400.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21726PRVNoah Pena1977-02-21—70344085653855 Harbor Blvd, Glendale, AZ, 853500.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-24005PRVDoris Dominguez2001-12-16—79162070646256 Sunset Blvd, Scottsdale, AZ, 852200.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23918PRVEdward Cook1976-03-25UHC-04537-80504735088539 Mesa Dr, Eden Prairie, MN, 553020.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-23917PRVEdward Cook1976-03-25UHC-04537-80504735088539 Mesa Dr, Eden Prairie, MN, 553020.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-24753PRVDoris Anderson1940-06-16UHC-85647-3047646832275796 Broadway, Sacramento, CA, 958280.80Date of birth reformattedPhone reformattedGender normalisedPlaceholder values cleared
PRV-21764PRVEmmily Wong1977-02-10—52786879533028 Maple Ave, Tampa, FL, 336240.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24077PRVAnn Mendez1964-02-12UHC-31441-4631684899599039 Hillcrest Rd, Plano, TX, 750420.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21216PRVAmy Marshall1994-10-07UHC-80245-87—555 Main St, Eden Prairie, MN, 553440.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-22034PRVJustni Greene1999-05-08—2496667165198 Harbor Blvd, Nashville, TN0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
PRV-29467PRVPeter Marhall1968-10-23——6560 Camelback Rd, Tampa, FL, 336460.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27283PRVSusan C Wang1949-05-05——7919 Sage Ct, Scottsdale, AZ, 852690.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27701PRVLogan Lucas1974-09-21UHC-41254-21—6921 Harbor Blvd, Plano, TX, 750410.80Name re-casedDate of birth reformattedPhone missing area codePlaceholder values cleared
PRV-26826PRVAmanda Cole2005-10-28—2293378957593 Cedar Ln, Seattle, WA, 981420.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26994PRVAlice Foster1950-02-06——6836 Maple Ave, Orlando, FL, 328010.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-28748PRVKevin Guzman——2788808571—0.80Date of birth unreadablePhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22263PRVJacob U Mills1972-01-05—61638735214896 Mountain View Dr, Houston, TX, 770340.80Phone reformattedCity re-casedZIP+4 trimmedPlaceholder values cleared
PRV-26923PRVRyan Gutierrez1987-10-13UHC-52264-23—9692 Market St, Fresno, CA, 937320.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27328PRVLuis Cole1976-05-18—51274296011216 Grand Ave, Charlotte, NC, 282790.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27573PRVDavis Zechary1984-02-12—82096050836064 Main St, Charlotte, NC, 282930.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
PRV-26607PRVJose Hernandez2008-07-01—70467664398649 Camelback Rd, Columbus, OH, 432710.80Name re-casedPhone reformattedZIP+4 trimmedPlaceholder values cleared
PRV-25159PRVBetty Mason1987-07-19——4776 Hillcrest Rd, Tempe, AZ, 852620.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-24319PRVJohn M Hicks1949-02-26—4809016447582 Ocean Ave, Austin, TX, 787370.80Name re-casedDate of birth reformattedZIP+4 trimmedPlaceholder values cleared
PRV-20600PRVRoger Bryant1995-03-09——1117 Forest Ave, Gilbert, AZ, 852120.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27885PRVSandra F Roberts1941-06-03UHC-36051-3149379199742636 Union St, Austin, TX, 787510.80Phone reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-20935PRVRonald F Johnston2002-02-06UHC-85701-3477590285059032 Ocean Ave, San Antonio, TX, 782940.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
PRV-28533PRVPatrick Castro1996-09-04UHC-42767-7629242057016815 Canyon Rd, Dallas, TX, 752010.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-24498PRVDoris Lee1970-03-07UHC-29225-43—5764 Lake View Rd, Charlotte, NC, 282110.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-28351PRVDon Nguyen1986-12-16——4619 Camelback Rd, Minneapolis, MN, 554240.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25680PRVJudith Li1976-04-07UHC-83073-6627076598913151 Ridge Rd, Eden Prairie, MN, 553550.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28870PRVDeborah Gordon1995-09-18UHC-25449-9530195836695176 Mesa Dr, San Diego, CA, 921580.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-29336PRVRalph W Wood—UHC-68877-1129082996885440 Lake View Rd, Charlotte, NC, 282500.80Name re-casedDate of birth missingPhone reformattedPlaceholder values cleared
PRV-22599PRVJack Mitchell1965-09-25—7042190444—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25033PRVWalter Washington1981-12-16UHC-34661-9250979854186312 Park Pl, Nashville, TN, 372850.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-26005PRVSteven Espinoza1947-08-14UHC-18936-718096724689116 Lake View Rd, Dallas, TX, 752250.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21363PRVSean O Turner1965-02-11—67048658992219 Bayshore Dr, Tampa, FL, 336180.80Name re-casedDate of birth reformattedCity re-casedGender normalised
PRV-26209PRVKatherine Adams1942-07-08—6486388366—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22208PRVBrenda Stephens1965-07-27—57368722523910 Forest Ave # 565, Phoenix, AZ, 850330.80Name re-casedUnit split from streetWhitespace trimmedPlaceholder values cleared
9,596 rows, page 136 of 192PreviousNext