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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-63357TPASofia McCoy1945-07-01——2722 Willow Ct, Scottsdale, AZ, 852890.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-59367TPAJerry O McDonald1969-01-06——9110 Jefferson Ave, San Diego, CA, 921600.78Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+1 more
TPA-51464TPAGary Austin1949-04-24—30794996162402 Ridge Rd, Austin, TX, 787350.78Date of birth reformattedPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-61882TPAGrgeory Lawson1948-12-27—2648652193—0.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-55596TPAJuudy Jackson1966-08-27—5255895129645 Lake View Rd, Sacramento, CA0.78Name re-casedPhone reformattedZIP missingWhitespace trimmed+1 more
TPA-63969TPAJack Gray1966-11-25——6736 Church St, Sacramento, CA, 958370.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-60641TPASue Contreras1964-09-27—46121403761830 Maple Ave, San Diego, CA, 921960.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-55148TPALisa Sanchez1951-01-20——3976 Mesa Dr, Gilbert, AZ, 852530.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-51195TPAJoseph Alexander1951-07-26—21961230309203 Camelback Rd, San Antonio, TX, 782750.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53623TPADiana Johnson1981-10-10—90381874123368 Central Ave, Jacksonville, FL, 322690.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51867TPAAndrea Medina1987-08-16—61222411284090 Church St, Tucson, AZ, 857570.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54568TPABryan Pattersoon1971-04-18——6888 Elm St, Denver, CO, 802250.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-62218TPAKenneth Dixon1964-05-17——6482 Indian School Rd, Tampa, FL, 336930.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55628TPAPeter Salazar1985-08-06—7429682169624 Grand Ave, Dallas, TX, 752460.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50491TPAJacqueline Kelley1980-06-05—40420300744235 Highland Ave, Houston, TX, 770140.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58161TPASimpson Keith2007-11-19——6732 Church St, Fresno, CA, 937760.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53844TPAAnn Pattel1977-06-01——7149 Bayshore Dr, Orlando, FL, 328390.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-51211TPAJessica Armstrong1952-04-19—87564909407306 Oak St, Fresno, CA, 937680.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62475TPABobby Morgan2005-12-26——5906 Maple Ave, Fresno, CA, 937380.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60421TPASantiago Pice1978-05-09——8949 Mesa Dr, Houston, TX, 770590.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-59270TPAElizabeth Dean1989-06-12—69350472844310 Church St, Austin, TX, 787470.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51362TPARyan Tran1990-06-27——5180 Apache Blvd, Fresno, CA, 937960.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-52463TPADenny Lawson1939-01-09—56334010847739 Desert Sky Blvd, Glendale, AZ, 853110.78Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-55374TPAEdward Nichols1997-04-26—92391423404601 Ridge Rd, Dallas, TX, 752160.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59584TPALarry C Morales1941-06-09——3047 Main St, Nashville, TN, 372220.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-52010TPARussell Elliott2002-09-26—76351656158498 Camelback Rd, San Diego, CA, 921560.78Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-51636TPAAshley Larson1970-12-10——9382 Jefferson Ave, Dallas, TX, 752790.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-54556TPAChristian Griffni2008-04-24—98535038593553 Highland Ave, Glendale, AZ, 853510.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-53240TPACharlotte Sanchez1994-04-17UHC-17804-0474586450917218 Washington St, Orlando, FL, 328450.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53937TPABrittany Wheeler1971-09-05—96170438301233 Forest Ave, Miami, FL, 331620.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51281TPAJohn W Young1955-02-28—67352016424204 Ridge Rd, Columbus, OH, 432040.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57008TPAAaron Hoffman2008-10-12UHC-55595-67—9350 Market St Apt 20, Tucson, AZ, 857580.78Name re-casedUnit split from streetCity re-casedWhitespace trimmed+1 more
TPA-59579TPACamila Lawrence1967-10-12—5237219460—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-56612TPAArjun Rojas1996-08-22—47639926931443 Lake View Rd, Sacramento, CA, 958530.78Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51013TPARandy Harrison1985-11-20—71245528935559 Sage Ct, Chandler, AZ, 852260.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57972TPASusan Murphy1969-07-25—38354929586103 Meadow Ln, Eden Prairie, MN, 553160.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-63489TPABeverly Cruz1993-01-11——5450 Mountain View Dr, Houston, TX, 770890.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63091TPAAlbert Richardson1959-07-23—62786589284270 Hillcrest Rd, Tempe, AZ, 852110.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54889TPADaniel M Owens1958-01-04—55986937321513 Cedar Ln, Atlanta, GA, 303130.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63588TPAMari Schmidt1957-04-28——8387 Willow Ct, Columbus, OH, 432000.78Name re-casedCity re-casedGender normalisedWhitespace trimmed+1 more
TPA-59207TPAMurray Jason1983-04-12——4758 Market St, Dallas, TX, 752780.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62708TPADiego Hart1945-05-14——6882 Indian School Rd, Denver, CO, 802250.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56363TPASophia Hart1959-04-24——8220 Ocean Ave, Denver, CO, 802430.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62363TPARalph O Luna2001-08-04——8713 Main St, Atlanta, GA, 303410.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53285TPADoris Murpy1953-03-22——9130 Lincoln Way, Tampa, FL, 336870.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60625TPAJack Rose1954-02-02UHC-37958-458274787053—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-60666TPADebra Howell1942-03-16——9725 Mesa Dr, Austin, TX, 787430.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-50244TPATyler Moreno1994-11-12——1312 Ridge Rd, Seattle, WA, 981200.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60076TPADouglas Kim1940-07-09—62175646495295 Market St, Fresno, CA, 937110.78Name re-casedPhone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-53991TPAMary Ellis1946-12-19—24481584866195 Desert Sky Blvd, Chandler, AZ, 852090.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 152 of 290PreviousNext