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-25352PRVLinda Y Lucas1952-03-06—40027111366009 Bayshore Dr # 516, Eden Prairie, MN, 553260.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-24794PRVOmar Robertson1968-09-14UHC-90322-3078236385443455 Meadow Ln, Seattle, WA, 981780.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25199PRVChristopher Powell1982-01-17UHC-31697-6482139564081288 Park Pl, Plano, TX, 750350.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29218PRVValentina Castillo1975-01-19——2097 Sunset Blvd, San Antonio, TX, 782680.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20539PRVJordan Armstrong1990-06-22—72249671675162 Bayshore Dr Apt 35, San Antonio, TX, 782760.64Name split from “Last, First”Phone reformattedUnit split from streetEmail lower-cased+2 more
PRV-28352PRVAlexander Kennedy1962-10-17UHC-46150-1528186689005630 Forest Ave, Miami, FL0.64Name split from “Last, First”Phone reformattedMember ID reformattedZIP missing+2 more
PRV-20831PRVTyler Crawford1968-08-07UHC-49693-6472550150119252 Ridge Rd, Plano, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26907PRVBetty Gray1982-10-01UHC-11992-1626895511811627 Mesa Dr, Miami, FL, 331860.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-26128PRVAndrew Bradley1951-04-22UHC-41862-4589026056779405 Washington St, Tempe, AZ, 852050.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26506PRVAlexander Turner1965-08-27—3384743391429 Pine Dr, Sacramento, CA, 958970.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-23259PRVPatricia Kennedy1991-09-17——6142 Harbor Blvd, Los Angeles, CA, 900150.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26512PRVPriya Allen—UHC-44110-1557527969994591 Maple Ave, Tampa, FL, 336880.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
PRV-20273PRVJanet Wright1966-09-20UHC-45348-0231531854164019 Maple Ave, Minneapolis, MN, 554150.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-22406PRVAustin C Tucker2004-03-02UHC-85356-5187855712336741 Cedar Ln, Tampa, FL, 336210.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20274PRVMary Payne1948-01-25—33180088692881 Apache Blvd, Seattle, WA, 981200.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24839PRVSamantha Graham1950-02-18—38428042436339 Mountain View Dr, Glendale, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22521PRVAlan O Howell1999-05-27—79825104528558 Valley View Dr, Tucson, AZ, 857360.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-21982PRVGloria Stone1965-04-03UHC-46016-1848633769742107 Park Pl, Charlotte, NC, 282020.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23082PRVJeffrey N Simmons1977-03-08UHC-64891-4788094836266175 River Rd, Tempe, AZ, 852400.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20520PRVMateo Warren1972-02-18—66285648489718 Elm St Apt 32, Sacramento, CA, 958600.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-29457PRVJose Banks1997-11-05UHC-92182-6671631799335571 Main St # 201, Dallas, TX, 752750.64Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
PRV-23495PRVKyle Harvey1976-10-27UHC-55261-2889042717694135 Sage Ct, San Diego, CA, 921960.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-25441PRVSteven West1968-04-02UHC-27799-40—16 Mesa Dr, Gilbert, AZ, 852680.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-27809PRVDeborah S Burns1980-01-12—22024245052696 Willow Ct, Fresno, CA, 937270.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
PRV-28297PRV—Junk1985-02-21UHC-13034-0855658501212552 Maple Ave, Jacksonville, FL, 322300.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
PRV-20564PRVTeresa Harvvey1995-07-24—33478364434064 Palm Dr, Mesa, AZ, 852610.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-25121PRVBrittany Aguilar2000-11-16UHC-06610-3474826441774574 Willow Ct, Gilbert, AZ, 852080.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-25238PRVWei G Harris1954-03-16UHC-52056-9453947487605028 Ridge Rd, Columbus, OH, 432120.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-27658PRVLucia Alvarado2005-01-16—64657843251364 Palm Dr, Jacksonville, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-28692PRVCharles McDonald1943-08-24—6962489850841 Spring St, Orlando, FL, 328510.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24341PRVDenise Stephens1988-01-26UHC-00197-62—538 Bayshore Dr, Atlanta, GA, 303200.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-27190PRVAmy Parker1963-04-23UHC-88714-3433940109009756 Lincoln Way, Los Angeles, CA, 900670.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-23349PRVLawrence K Weaver1964-02-04—92921200243519 Church St, Tempe, AZ, 852190.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
PRV-25097PRVAshley W Snyder1941-10-24UHC-84216-8935984571453146 Sage Ct # 677, Nashville, TN, 372090.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-28887PRVEmily Garcia1950-12-25——9327 Union St, Chandler, AZ, 852830.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
PRV-24752PRVMark Hart——80499338339124 Park Pl, Atlanta, GA, 303130.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20955PRVBetty Vega1988-10-12——5155 Camelback Rd, San Antonio, TX, 782150.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-21393PRVBillly Gibson2008-04-13——3004 Sunset Blvd, Tucson, AZ, 857910.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-22403PRVSarah V Hudson2008-11-07—82297728953760 Willow Ct, Denver, CO, 802070.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27858PRVDebra Lee1995-07-27—43333426708651 Jefferson Ave, Eden Prairie, MN, 553300.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29579PRVJulie Ross1939-11-28—38295628247517 Meadow Ln, Chandler, AZ, 852800.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25535PRVGary Brown1950-01-24—45884767315247 Jefferson Ave, Tucson, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24847PRVBettty B Soto2008-12-20—49959257202184 Sage Ct, Jacksonville, FL, 322340.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20755PRVAlbart Myers1959-03-01——2650 Mountain View Dr, Denver, CO, 802240.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-26636PRVSean Gardner—UHC-33476-72—9447 Lake View Rd, Seattle, WA, 981120.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-21106PRVMark Fox1993-04-05—74791839051877 Indian School Rd, Atlanta, GA, 303020.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
PRV-20242PRVMark Y Freeman2006-04-11—64832638598601 Jefferson Ave, Scottsdale, AZ, 852770.64Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
PRV-23644PRVSarah Sngh2004-10-21—93238546836395 Bayshore Dr Apt 39, Nashville, TN, 372240.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-27697PRVMateo Sims1959-11-11——7841 Bayshore Dr, Phoenix, AZ, 850070.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23329PRVJack N Crater1997-04-23—69394006909198 Mountain View Dr, Tucson, AZ, 857540.64Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
9,596 rows, page 56 of 192PreviousNext