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-23771PRVKayla Reid2003-09-12—92772565792115 Market St, Sacramento, CA, 958450.64Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+2 more
PRV-21401PRVMarcus Hart1983-11-13——3873 Lincoln Way, Gilbert, AZ, 852790.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-28127PRVDavid D Griffin1958-07-13UHC-59486-30—9704 Forest Ave, Scottsdale, AZ, 852640.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-23608PRVGloria Meyer1997-04-17—72627637951137 Pine Dr, Houston, TX, 770080.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26013PRVEvelyn Vega1982-12-09—80089558829814 River Rd, Scottsdale, AZ, 852340.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-23820PRVKathleen Simpson1999-07-27—40994922679520 Central Ave, Columbus, OH, 432440.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-22959PRVBobby Hart1941-11-19UHC-50494-1397632593659401 Camelback Rd, Las Vegas, NV0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-23403PRVMary L Castro1960-07-19UHC-41566-60—7608 Ocean Ave, Seattle, WA, 981250.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23734PRVRobert Bradlay1977-07-08———0.64Name split from “Last, First”Date of birth reformattedEmail lower-casedGender normalised+2 more
PRV-25629PRVGrace Hall2000-05-09UHC-20965-1954569646492262 Bayshore Dr, Tempe, AZ, 852130.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-20293PRVSofia Carr1950-08-08UHC-88392-6362247373983946 Lincoln Way, San Antonio, TX, 782910.64Name split from “Last, First”Phone reformattedMember ID reformattedCity re-cased+2 more
PRV-23760PRVBobby T Rojas—UHC-80225-0579082954071537 Market St, Denver, CO, 802950.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22499PRVKayla D Robinson1970-05-04UHC-81146-8748346257119260 Canyon Rd, Plano, TX, 750640.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27971PRVLauren V Hoffman1940-07-25UHC-16769-64—1201 Meadow Ln, Jacksonville, FL, 322030.64Name re-casedDate of birth reformattedPhone missing area codeZIP+4 trimmed+2 more
PRV-28390PRVJnet L Howell2005-03-11——9379 Willow Ct, Austin, TX0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
PRV-23533PRVKatherine U Howell2006-04-08UHC-24751-0473664088356115 Indian School Rd, Los Angeles, CA, 900040.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26948PRVAshely D Lene1993-09-20—36560998144467 Indian School Rd, Las Vegas, NV, 891160.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21510PRVBrittany Campbell1954-04-18—82785177635105 Valley View Dr, Fresno, CA, 937590.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
PRV-20575PRVHeather M Fisher1961-01-07—52420703203767 Market St Apt 25, Los Angeles, CA, 900430.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
PRV-21804PRVCamila Webb1977-10-18UHC-57634-7288647794044854 Bayshore Dr, Scottsdale, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-21988PRVMaria Robinson1962-12-03——717 Grand Ave, Columbus, OH, 432810.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-26639PRVChristian Peterson1969-06-14——2683 Indian School Rd, Eden Prairie, MN, 553580.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-23516PRVHiroshi Martinez1946-08-27—37421498105606 Meadow Ln, Minneapolis, MN0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
PRV-28431PRVSusan C Hamilton1983-12-09—96834697284288 Church St # 742, Sacramento, CA, 958100.66Phone reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
PRV-26088PRVJudith L Ford1949-12-12—80737444804967 Cedar Ln, Chandler, AZ, 852630.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-23904PRVRalph Miller1968-10-17——3448 Park Pl, Orlando, FL, 328870.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
PRV-23649PRVJuan Crawford1988-02-23—39450719085169 Valley View Dr, Sacramento, CA, 958580.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-29437PRVDiane P Perkins1983-03-17UHC-00538-2756531585274580 Hillcrest Rd, Glendale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
PRV-28751PRVKyle Contreras1962-06-10UHC-17396-44——0.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
PRV-25280PRVCheryl C Buutler1972-02-27—81079935047407 Ocean Ave, Atlanta, GA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-20634PRVSara Hamilton1977-01-11UHC-62889-7550660143721559 Broadway, Seattle, WA, 981130.66Name split from “Last, First”Date of birth reformattedAddress re-casedZIP+4 trimmed+1 more
PRV-22693PRVMaria Y McDonald1978-04-27UHC-46308-892336136170266 Mountain View Dr, San Antonio, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-20782PRVSandra K Wallace1943-05-15—63838579399327 Lincoln Way, Mesa, AZ, 852280.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
PRV-25669PRVKaren S Rivera1984-05-22—64395955379144 Ridge Rd Apt 34, Fresno, CA0.66Date of birth reformattedPhone reformattedUnit split from streetZIP missing+1 more
PRV-23715PRVJudith Vasquez1995-12-01UHC-02361-56—3739 Lake View Rd # 669, Austin, TX, 787170.66Name re-casedUnit split from streetGender normalisedWhitespace trimmed+1 more
PRV-23930PRVEugene Hanson1955-06-03UHC-51392-8379943569824699 Washington St, Atlanta, GA, 303240.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
PRV-29391PRVPatricia Watson1939-08-16UHC-72592-06—5752 Desert Sky Blvd, Eden Prairie, MN, 553520.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
PRV-27397PRVLarry Duncan1989-04-28——9313 Baseline Rd Apt 31, Eden Prairie, MN, 553460.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-27398PRVLarry Duncan1989-04-28——9313 Baseline Rd Apt 31, Eden Prairie, MN, 553460.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
PRV-27641PRVRuth Ross1970-04-21UHC-60558-56—3071 Canyon Rd, Phoenix, AZ, 850960.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
PRV-24673PRVBrandon Hicks—UHC-36394-595655433767—0.66Name split from “Last, First”Date of birth unreadablePhone reformattedEmail lower-cased+1 more
PRV-27880PRVSamantha Marshall2002-11-04UHC-35254-2553878522361627 Broadway, Minneapolis, MN, 554900.66Name split from “Last, First”Two-digit birth yearPhone reformattedAddress re-cased+1 more
PRV-22757PRVEthan H Dixon1987-11-14UHC-82724-8336221049937408 Desert Sky Blvd, Seattle, WA, 981430.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-20852PRVJohhn R Ferguson1940-02-16UHC-93817-9258061815763561 Ocean Ave, Los Angeles, CA, 900420.66Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
PRV-20906PRVJoyce Hunt——24771129062307 Sage Ct, Phoenix, AZ, 850690.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-27133PRVMicahel Porter2003-09-12UHC-50791-3243125822375538 Elm St, Houston, TX, 770790.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21321PRVJerry Perry1994-05-25UHC-81449-3674782194026462 Mesa Dr, Eden Prairie, MN, 553980.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
PRV-26255PRVMartha Sullivan2007-02-09UHC-67909-7897668750874612 Valley View Dr, Denver, CO, 802540.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
PRV-20669PRVSofia Day1938-07-28—46385953132714 Ocean Ave, Chandler, AZ, 852450.66Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
PRV-26872PRVScott Hughes1997-01-24—37736695422208 River Rd, Orlando, FL, 328400.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
9,596 rows, page 57 of 192PreviousNext