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-28825PRVDouglas Flores1961-07-08UHC-54916-5936440057218010 Maple Ave, Fresno, CA, 937040.92Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased
PRV-25730PRVVincent C Dixon1985-07-10UHC-85495-0721631643677753 Pine Dr, Seattle, WA, 981400.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
PRV-22118PRVRoger Z Jackson1949-04-16—2054284245—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25177PRVJoyce Snyder1961-01-07UHC-38342-0567825399777991 Meadow Ln, Glendale, AZ, 853500.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
PRV-27500PRVMegan Ferguson1988-08-10—70967766783570 Grand Ave, Seattle, WA, 981520.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22266PRVDylan J Guerrero1944-04-17UHC-70949-3356936450229202 Spring St, Las Vegas, NV, 891190.92Name re-casedPhone reformattedState code upper-casedPlaceholder values cleared
PRV-20567PRVSara R Holmes1941-12-28—439437922931 Cedar Ln, Fresno, CA, 937360.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-25647PRVOmar Hunt1938-05-20—45436298659314 Bayshore Dr, Los Angeles, CA, 900850.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23703PRVCamila Baker1946-03-09—9009578885815 Ocean Ave, Las Vegas, NV, 891950.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-27463PRVAlexis M Hawkins1977-04-17—40041625278718 Bayshore Dr, Jacksonville, FL, 322420.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-23137PRVMegan Alvarez1971-03-13—9853997516—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-21668PRVMatthew A Fuller1986-01-08UHC-61724-23—3540 Apache Blvd, Austin, TX, 787040.92Name re-casedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-20627PRVNoah Howard2005-11-15—4859150806—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23746PRVAmy Armstrong1999-05-08—69423931984161 Apache Blvd, Phoenix, AZ, 850690.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-25480PRVBetty L Johnson1948-12-12—72978060198542 Central Ave, Eden Prairie, MN, 553980.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-21109PRVHiroshi Dean1990-01-21UHC-65896-8741379832348478 Lincoln Way, Austin, TX, 787840.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
PRV-20519PRVJudith Santiago1952-03-24UHC-25546-7338668955542694 Market St, Denver, CO, 802160.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-20193PRVWalsh Willie1959-01-26—24143279544995 Broadway, Los Angeles, CA, 900950.92Name re-casedDate of birth reformattedCity re-casedPlaceholder values cleared
PRV-22620PRVSrah Henderson1972-04-16UHC-24133-9357169004318426 Cedar Ln, Mesa, AZ, 852380.92Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted
PRV-20898PRVDiego N Williams1978-12-01UHC-21645-1868276591001963 Willow Ct, Chandler, AZ, 852520.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21509PRVFrances Jenkins1987-09-19UHC-08557-8749623800415036 Broadway, Miami, FL, 331490.92Phone reformattedAddress re-casedWhitespace trimmedPlaceholder values cleared
PRV-27447PRVRichard Cruz2008-02-16UHC-30512-3066393997599194 Mesa Dr, Houston, TX, 770080.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21431PRVKathryn Turner1952-02-22UHC-15096-045217913689—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25608PRVRachel Jimenez1964-05-08UHC-73124-8647430899987348 Harbor Blvd, Charlotte, NC, 282240.92Date of birth reformattedPhone reformattedCity re-casedPlaceholder values cleared
PRV-28712PRVJeremy Moore1995-09-27UHC-26263-459455731222—0.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-26030PRVWillei Carlson1985-10-01—92425640549215 Ocean Ave, Minneapolis, MN, 554270.92Name re-casedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-21212PRVCharlotte Dunn1987-10-01—58743416696874 Broadway, Denver, CO, 802500.92Name re-casedPhone reformattedAddress re-casedPlaceholder values cleared
PRV-27284PRVIsabella Collins1984-04-07—9093956781—0.92Name re-casedPhone reformattedEmail lower-casedPlaceholder values cleared
PRV-20323PRVTerry Wells1948-08-06——6231 Sage Ct, Sacramento, CA, 958690.92Name re-casedDate of birth reformattedWhitespace trimmedPlaceholder values cleared
PRV-21551PRVRonald Sims1983-08-21UHC-85514-6377532085932231 Church St, Fresno, CA, 937290.92Name re-casedPhone reformattedCity re-casedPlaceholder values cleared
PRV-27408PRVSofiia Guerrero1958-11-24—7436579225—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-23593PRVSteven G Simmons1956-04-13UHC-50809-847293810193763 Valley View Dr, Tempe, AZ, 852920.92Date of birth reformattedPhone reformattedState code upper-casedPlaceholder values cleared
PRV-23906PRVChristine James1957-02-26UHC-90879-9363022363627804 Apache Blvd, Chandler, AZ, 852640.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-23632PRVAnthony Harrison1983-09-08—32083943485047 Canyon Rd, Las Vegas, NV, 891720.92Phone reformattedCity re-casedState code upper-casedWhitespace trimmed
PRV-21488PRVSara W Pena1957-03-18UHC-34572-9062027557661798 River Rd, Tampa, FL, 336940.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-22797PRVLucia Cook1950-10-17—50079575314149 Indian School Rd, Mesa, AZ, 852710.92Phone reformattedCity re-casedWhitespace trimmedPlaceholder values cleared
PRV-20174PRVBrandon Bryant1980-12-13UHC-78047-959533400231—0.92Name re-casedPhone reformattedMember ID reformattedPlaceholder values cleared
PRV-21974PRVBen Montgomery1993-08-16UHC-75056-8340486939154860 Union St, Los Angeles, CA, 900810.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-27737PRVAbigail Spencer1969-09-15—31757534218550 Lincoln Way, Dallas, TX, 752090.92Name re-casedCity re-casedEmail lower-casedPlaceholder values cleared
PRV-23501PRVSamuel Graham2007-03-12—8797557655—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-28736PRVRonald Mejia1977-06-28UHC-84706-9886392724522775 Desert Sky Blvd, Nashville, TN, 372350.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-21692PRVAhmed Turner1971-09-27UHC-43070-4968682420487916 Bayshore Dr, Mesa, AZ, 852110.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-21693PRVAhmed Turner1971-09-27UHC-43070-4968682420487916 Bayshore Dr, Mesa, AZ, 852110.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-27362PRVAshley Moore1966-04-16—27390359235502 River Rd, Nashville, TN, 372680.92Name re-casedPhone reformattedState code upper-casedPlaceholder values cleared
PRV-24068PRVTheresa Kelly1950-01-02UHC-26103-496876560179—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-29075PRVAbigail Moore1998-03-11—510362269159 Mountain View Dr, Charlotte, NC, 282410.92Name re-casedDate of birth reformattedPhone reformattedPlaceholder values cleared
PRV-20761PRVDona G Torres1981-10-11UHC-70484-1141199596688447 Willow Ct, Orlando, FL, 328790.92Phone reformattedState code upper-casedWhitespace trimmedPlaceholder values cleared
PRV-23169PRVSofia P Li2003-01-08—4445333176—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-25363PRVKimberly Vargas1986-06-22UHC-30183-372466468926—0.92Date of birth reformattedPhone reformattedWhitespace trimmedPlaceholder values cleared
PRV-22838PRVDebbie Berry1940-01-16UHC-77773-425867850565—0.92Name re-casedPhone reformattedWhitespace trimmedPlaceholder values cleared
9,596 rows, page 163 of 192PreviousNext