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-24432PRVDaniel K Reid1939-01-23—47752400458395 Camelback Rd, Columbus, OH, 432090.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20771PRVKen Perkins1996-07-07UHC-46973-89—6141 Maple Ave, Glendale, AZ, 853010.64Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
PRV-22616PRVMary Moreno1992-12-28UHC-34202-7591677916782055 Cedar Ln, Phoenix, AZ, 850500.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-29416PRVHarold Hart1994-04-11UHC-36348-4260023296362280 Valley View Dr, Fresno, CA, 937460.64Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
PRV-21015PRVMarry K Rgers1943-04-11UHC-81130-6647681945883310 Washington St, Scottsdale, AZ, 852020.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25305PRVDorothy E Griffin2006-12-03UHC-72937-08—3762 Market St, Glendale, AZ, 853210.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-22911PRVSofia Weaver1968-06-05UHC-51460-0835936018261381 Union St, Mesa, AZ, 852340.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-24521PRVTimothy Weber———3331 Mountain View Dr, Plano, TX, 750030.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-27649PRVDeigo Turner1988-02-28—97673028878225 Union St Apt 32, Tampa, FL, 336440.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28770PRVAlexis E Duncan1970-08-12—30372856359398 Maple Ave, Gilbert, AZ, 852840.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25414PRVJonathan Ferguson1982-06-09——4690 Forest Ave Apt 2, Gilbert, AZ, 852760.64Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+2 more
PRV-29056PRVMike Alexander1989-04-27UHC-07738-3587761828503873 Market St, Dallas, TX, 752980.64Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased+2 more
PRV-21577PRVJohn Snyder—UHC-19895-89—1460 Church St, San Diego, CA, 921810.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-22195PRVBarbara Gibson2001-09-07—24924704312335 Willow Ct, Gilbert, AZ, 852880.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-28375PRVVirginia Kim1945-08-11UHC-47194-23—4941 Mesa Dr, Las Vegas, NV, 891320.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20888PRVMargaret Bailey1998-01-13UHC-09162-9983159145019793 Elm St, Orlando, FL, 328040.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
PRV-23189PRVOlivia Remirez2002-09-06UHC-52164-9691781490363487 Oak St, Austin, TX, 787630.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27743PRVNancy Y Valdez2002-06-24UHC-34666-58—3019 Park Pl, Tucson, AZ, 857340.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-27992PRVAmanda Peters1971-12-05—30796116524865 Willow Ct, Phoenix, AZ, 850310.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28362PRVLori Stewart1945-01-20UHC-49995-6381757080035044 Broadway, Atlanta, GA0.64Name re-casedPhone reformattedCity re-casedZIP missing+2 more
PRV-20497PRVRalph C Harper1950-06-14—8224266008712 Elm St, Plano, TX, 750550.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25453PRVPhilip P Johnson1941-09-19UHC-00083-6265545449242403 Oak St, Sacramento, CA, 958280.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23804PRVSarah Olson2002-10-06—75640190996116 Willow Ct, Fresno, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-26878PRVSamuel L Hall1988-09-22UHC-61573-0621273048336266 Mesa Dr, Columbus, OH, 432810.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26544PRVCaimla Jenkins1941-05-25—71828867147506 Market St, Minneapolis, MN, 554230.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24193PRVRoger Wheeler——24743795387260 Jefferson Ave, Tucson, AZ, 857820.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22606PRVJudith Armstrong1989-03-13UHC-29429-1651271319096268 River Rd, Houston, TX, 770220.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29011PRVVincent Gray1942-01-27UHC-05842-8224178806124845 Bayshore Dr, Las Vegas, NV, 891650.64Phone reformattedCity re-casedState name converted to codeGender normalised+2 more
PRV-20283PRVMason N Reynolds1978-09-19—47138903864261 Ocean Ave Apt 11, Dallas, TX, 752090.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-25966PRVZachary Mershall2001-11-21—35290533577657 Lake View Rd, Atlanta, GA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-28232PRVCarolyn Henry1941-09-17—9687957748924 River Rd # 294, Dallas, TX, 752560.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-24577PRVSean Stephens—UHC-47949-1621335910126061 Grand Ave, Orlando, FL, 328810.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25113PRVArjun U Holmes1978-11-22——5851 Main St Apt 35, Glendale, AZ, 853330.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-20622PRVDiane Stone2000-02-21—93334014473422 Pine Dr, San Antonio, TX, 782970.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25223PRVJennifer F Henry1980-01-17—81969360192409 Oak St, Jacksonville, FL, 322160.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-25973PRVMaria E Kelly2006-04-20—89044601013877 Mesa Dr, Fresno, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-27395PRVAhmed Rose1972-11-01—90076841494535 Camelback Rd, Seattle, WA, 981430.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27114PRVDot C Rivera1958-07-18—24894634317881 Pine Dr, Nashville, TN, 372230.64Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29453PRVMary Day1985-11-24—47329769464022 Church St, Houston, TX, 770960.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21717PRVCarolyn Lopez2001-09-05UHC-67098-51—6186 Washington St, Phoenix, AZ, 850590.64Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-25076PRVEvelyn Espinoza1972-05-15UHC-88195-602864673382157 Central Ave, Fresno, CA0.64Name re-casedDate of birth reformattedZIP missingGender normalised+2 more
PRV-28147PRVMelissa T Lucas1985-03-13UHC-51145-3777686282031946 Desert Sky Blvd, Charlotte, NC0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-21224PRVLaura McDonald——94495470438089 Pine Dr, Atlanta, GA, 303820.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-28944PRVJanet Grant1991-05-18—43127372567089 Willow Ct, Los Angeles, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-28941PRVFrances Powell1968-11-17UHC-90782-5464428874897489 Sunset Blvd, Fresno, CA, 937100.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-28940PRVFrances Powell1968-11-17UHC-90782-5464428874897489 Sunset Blvd, Fresno, CA, 937100.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-24261PRVMaria Flores1989-02-23UHC-15319-5169062922957307 Oak St, Tempe, AZ, 852370.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-24771PRVRachel Colmean1981-12-28——93 Ocean Ave, Jacksonville, FL, 322620.64Name re-casedCity re-casedState name converted to codeGender normalised+2 more
PRV-23336PRVAhmed I Patal2005-02-09—61239709187258 Apache Blvd, Austin, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-27767PRVKyle Fuller1961-09-12UHC-61514-9129741133665677 Highland Ave, Sacramento, CA, 958440.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
9,596 rows, page 47 of 192PreviousNext