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-26366PRVJacob Ramirez1979-06-01UHC-89226-7220720709686959 Willow Ct, Tempe, AZ, 852960.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
PRV-24605PRVLri Foster1993-05-17—47963265218427 River Rd, Eden Prairie, MN, 553390.80Name split from “Last, First”Email lower-casedWhitespace trimmedPlaceholder values cleared
PRV-29302PRVCarolyn Cruz1942-04-06——6979 Market St, Orlando, FL, 328760.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20988PRVNancy S Ferguson1983-09-08——3032 Highland Ave, Columbus, OH, 432410.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
PRV-24357PRVPamela Hughes1962-02-24——4681 Bayshore Dr, Sacramento, CA, 958230.80Date of birth reformattedCity re-casedState name converted to codePlaceholder values cleared
PRV-26148PRVJulia Garza1951-12-07——9030 Indian School Rd, Las Vegas, NV, 891620.80Name re-casedSSN last four extractedWhitespace trimmedPlaceholder values cleared
PRV-25233PRVCynthia W Ford1986-06-11——3753 Lincoln Way, Fresno, CA, 937910.82Gender normalisedWhitespace trimmedPlaceholder values cleared
PRV-27338PRVBrenda Garrett1979-12-19UHC-41748-23—5080 Mountain View Dr, Chandler, AZ, 852790.82City re-casedZIP+4 trimmedPlaceholder values cleared
PRV-23282PRVJacob Kelly1990-05-14—2818663241—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-23233PRVKeith B Jones1956-01-16—67367303584325 Church St, Gilbert, AZ, 852960.82ZIP+4 trimmedEmail lower-casedPlaceholder values cleared
PRV-25245PRVTimothy Gordon1967-03-04—4993464992—0.82Two-digit birth yearPhone reformattedPlaceholder values cleared
PRV-24908PRVAisha Rogers1957-09-18—94877641383115 Mountain View Dr, Sacramento, CA, 958010.82City re-casedZIP+4 trimmedPlaceholder values cleared
PRV-28389PRVJoshua S Castro1939-02-12UHC-23978-1745997786422052 River Rd, Tucson, AZ, 857870.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24452PRVNicholas Dean2003-01-24UHC-93616-96—8973 Central Ave, Miami, FL, 331230.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-24913PRVMei T Le1942-07-21—58454398851892 Forest Ave Apt 23, Sacramento, CA, 958270.82Phone reformattedUnit split from streetWhitespace trimmed
PRV-23790PRVPatrick E Schultz——4855623762—0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-28885PRVTerry Salazar1946-12-06——1265 Desert Sky Blvd, Austin, TX0.82Date of birth reformattedZIP missingPlaceholder values cleared
PRV-25661PRVCarl Q White1943-02-06——8984 Ridge Rd, Orlando, FL, 328630.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
PRV-28707PRVJames Mills1982-10-16—48967457499312 Broadway, Los Angeles, CA0.82Phone reformattedZIP missingPlaceholder values cleared
PRV-24604PRVBarbara C Fisher1938-06-16—57288192694226 Church St, Orlando, FL, 328220.82Name re-casedStreet suffix standardisedAddress re-cased
PRV-24473PRVBradley Oliver1951-09-07UHC-67161-2783861862895188 Union St, Tampa, FL, 336560.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22931PRVEmily Nguyen2005-12-28UHC-56018-98—2586 Indian School Rd, Sacramento, CA, 958360.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-25782PRVLarry Baks1946-05-21UHC-47014-15—7288 Mesa Dr, Sacramento, CA, 958400.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27158PRVBrneda Carpenter1953-05-23—3354432906—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-28210PRVRaymond Q Reed1997-07-04——8798 Lincoln Way, Orlando, FL, 328560.82Name re-casedZIP+4 trimmedPlaceholder values cleared
PRV-27042PRVJudy Montgomery1962-02-14UHC-91198-7370038757486221 Central Ave, Eden Prairie, MN, 553880.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-20377PRVMaria Simpson1939-09-04——9735 Canyon Rd, Charlotte, NC, 282690.82Phone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-22489PRVSarah Vega1972-11-12UHC-79841-4882298278009321 Meadow Ln, Plano, TX, 750740.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22948PRVCarool Kim2007-10-18UHC-04642-40—565 Meadow Ln, Tucson, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
PRV-28344PRVDay Shirley1939-05-17——8550 Cedar Ln, Plano, TX, 750970.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-20611PRVAustin Cox1973-03-17UHC-51901-8226698257906963 Maple Ave, Scottsdale, AZ, 852670.82State name converted to codeWhitespace trimmedPlaceholder values cleared
PRV-21313PRVRichard Rios1992-02-23UHC-20691-71—9572 Park Pl, Glendale, AZ, 853300.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-23045PRVMarilyn I Patterson1997-01-05UHC-43471-665688744256—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-26384PRVPatricia Ramirez1999-04-18UHC-77528-555696782858—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
PRV-25163PRVCaimla K Robertson1939-04-07UHC-95495-0192679030677795 Elm St, Plano, TX, 750100.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
PRV-21207PRVBenjamin Richardson1958-04-17—56064468796480 Indian School Rd Apt 15, Dallas, TX, 752770.82Name re-casedUnit split from streetPlaceholder values cleared
PRV-22488PRVSophia Wright1999-04-21UHC-97117-15—6459 Palm Dr, Atlanta, GA, 303410.82Phone missing area codeWhitespace trimmedPlaceholder values cleared
PRV-28313PRVJaet Y Guerrero1943-07-16——2649 Elm St, Sacramento, CA, 958390.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-20062PRVJohn Cunningham1945-02-12——1099 Palm Dr, Tempe, AZ, 852960.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-21967PRVLori Lewis———6077 Highland Ave, Atlanta, GA, 303310.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
PRV-23368PRVHeather Clark1979-05-05UHC-77791-65—5935 Market St, San Diego, CA, 921820.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-28966PRVJack Torres1949-02-10—3558995888110 Spring St, Nashville, TN, 372710.82Phone reformattedGender normalisedPlaceholder values cleared
PRV-28035PRVDeborah Perry1941-09-28UHC-90537-3848160850491929 Oak St, Fresno, CA, 937770.82Phone reformattedCity re-casedState name converted to code
PRV-28036PRVDeborah Perry1941-09-28UHC-90537-3848160850491929 Oak St, Fresno, CA, 937770.82Phone reformattedCity re-casedState name converted to code
PRV-29239PRVEthan Kim1972-01-09—43675792023734 Grand Ave, Gilbert, AZ, 852130.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-22299PRVCastro Liz1966-07-10—8217442326133 Main St, San Diego, CA, 921500.82Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-22543PRVDeborah Jenkins2002-05-05—58827343138137 Central Ave, Houston, TX, 770040.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
PRV-22874PRVDiane Johnson1961-12-02UHC-39148-3924682266572253 Broadway, Tucson, AZ, 857450.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
PRV-26327PRVPeter Ferguson1948-03-25UHC-45310-05—1560 Central Ave, Houston, TX, 770660.82Street suffix standardisedAddress re-casedWhitespace trimmed
PRV-28186PRVEmma Clark2005-11-07UHC-74207-7578269770888762 River Rd # 169, Phoenix, AZ, 850830.82Unit split from streetCity re-casedPlaceholder values cleared
9,596 rows, page 143 of 192PreviousNext