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-24355PRVMadison Garcia1984-09-25——6656 Church St, Tampa, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27004PRVAmy Warren1940-12-08—75038526028408 Palm Dr, Columbus, OH, 432080.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-20880PRVJose E Richardson1960-08-27——9388 Cedar Ln, Nashville, TN0.64Name split from “Last, First”Date of birth reformattedZIP missingPlan code upper-cased+2 more
PRV-21262PRVMatthew Y White——47846442068059 Valley View Dr, Gilbert, AZ, 852240.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21263PRVMatthew Y White——47846442068059 Valley View Dr, Gilbert, AZ, 852240.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23554PRVJohn Z Armstrong2003-06-27—2117248758143 Sunset Blvd, Glendale, AZ, 853600.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22207PRVChristian Reynolds—UHC-02582-565332542224—0.64Date of birth unreadablePhone reformattedEmail lower-casedGender normalised+2 more
PRV-20956PRVAnn Dominguez1959-12-03UHC-89013-5755120548112671 Grand Ave, Los Angeles, CA, 900420.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
PRV-24530PRVGeorge Q Dominguez2001-04-12—45456342324593 Ocean Ave, Glendale, AZ, 853630.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-27972PRVAmy E Hicks1960-03-21UHC-14831-1295965420636886 Palm Dr, Gilbert, AZ, 852770.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
PRV-23468PRVSofia R Montgomery2007-02-17UHC-68722-6546560110909524 Apache Blvd, Tampa, FL, 336960.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23615PRVMegan Rivera1959-08-21——1707 Baseline Rd, Mesa, AZ, 852040.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-24274PRVMason Weaver1946-08-27—3287084598248 Palm Dr, Fresno, CA, 937060.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23510PRVJean W Hamlton1965-02-08UHC-77149-1841671433834244 Oak St, Tempe, AZ0.64Name split from “Last, First”Phone reformattedMember ID reformattedZIP missing+2 more
PRV-24928PRVRaymond Stone1944-04-18UHC-79612-6728183294648000 Park Pl, Tampa, FL, 336700.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-25131PRVJudith Castro1946-06-18—33892494189281 Baseline Rd, San Diego, CA, 921800.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-25115PRVAndraw Jimenez1966-02-28UHC-47325-4557987907793408 Spring St, Dallas, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-28360PRVJack James1957-03-03—89568869501297 Maple Ave, Tampa, FL, 336620.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-26573PRVTerry Z Kennedy2004-08-12—56595422951735 Forest Ave, Austin, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25281PRVRalph Gibson1987-03-21UHC-51268-5556984475712194 Baseline Rd, Miami, FL, 331430.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20535PRVRussell Z Watkins1990-08-22——8736 Bayshore Dr, Las Vegas, NV, 891040.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-22982PRVJean Ruiz1965-01-26——6029 Sunset Blvd, San Diego, CA, 921750.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23416PRVEugene Freeman1940-02-19—89845014908536 Oak St, Austin, TX, 787320.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25012PRVJake X Hughes1979-12-21—68441448377401 Washington St, Atlanta, GA, 303910.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22849PRVMason Wood2006-11-17—37123431119111 Cedar Ln, San Diego, CA0.64Name re-casedCity re-casedState name converted to codeZIP missing+2 more
PRV-26926PRVPeter Harper1957-04-15—25221072414191 Grand Ave, Columbus, OH, 432840.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
PRV-28040PRVAdam Richards2008-09-20—77645573431893 Sage Ct, Miami, FL, 331110.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21792PRVJacqueline Payne1952-08-12—76648211458478 Sunset Blvd, Plano, TX, 750910.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-22533PRVSamantha Alvarado1987-10-11—61024222462471 Sunset Blvd # 195, Fresno, CA, 937770.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26442PRVKatherine Z Wilson1991-03-22—59431829249140 Union St, Nashville, TN, 372720.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26891PRVAustin A Hayes——56425265067703 Palm Dr, Denver, CO, 802010.64Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
PRV-25876PRVValentina A Estrada1981-09-04—90678946923708 River Rd, Nashville, TN, 372360.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-23307PRVSarah Olson2000-06-19——5496 River Rd, Seattle, WA, 981810.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-23891PRVEthan Cook2003-03-18UHC-76119-1264979475719366 Mesa Dr # 982, Tucson, AZ, 857360.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
PRV-24361PRVScott Gibson1966-11-03UHC-21871-2746358589371015 Willow Ct, Glendale, AZ, 853900.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27357PRVRalph Morris1971-12-28—47197397932055 Forest Ave, Austin, TX0.64Name re-casedPhone reformattedZIP missingGender normalised+2 more
PRV-20187PRVDiane Hart2008-02-04——7848 Ridge Rd, Miami, FL0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26935PRVLaura Tran——41043949528093 Baseline Rd, Jacksonville, FL, 322630.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26799PRVAshley Hudson1972-10-24——56 Central Ave, Dallas, TX, 752230.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-26993PRVTimothy Bradley1982-01-14UHC-38160-4480689002724594 Baseline Rd, Nashville, TN, 372850.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-29286PRVRebecca Espinoza1954-12-27—90554327498352 Main St, Phoenix, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20731PRVAustin C Holmes1976-02-25—38993216962810 Spring St # 349, San Diego, CA, 921230.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-28202PRVRuth X Jacobs2004-07-10——6862 Sage Ct, Tempe, AZ, 852660.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-26598PRVLarry Marshall1971-07-04UHC-53367-5752842090871466 Grand Ave, Minneapolis, MN, 554100.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27276PRVRachel Daniels1994-12-06UHC-53886-7693051625411557 Cedar Ln, San Antonio, TX, 782250.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-24004PRVPamela A Tucker1974-08-08—21890757487360 Jefferson Ave, Atlanta, GA, 303850.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
PRV-20419PRVJustin Rodriguez1953-06-15UHC-92157-5583845295218205 Baseline Rd, Chandler, AZ, 852670.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-22110PRVJanice Harvey1968-12-21—46934790546297 Sage Ct, Dallas, TX, 752970.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26468PRVNancy Howard1994-02-07UHC-08853-2938064225531720 Willow Ct, Las Vegas, NV, 891120.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-27647PRVAmnada Johnson1946-07-03UHC-06364-6486246561053153 Mountain View Dr Apt 39, Los Angeles, CA, 900940.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
9,596 rows, page 41 of 192PreviousNext