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-50586TPACatherine Ellis1939-12-19—75137687123991 Park Pl, Chandler, AZ, 852020.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56362TPAJanice Richards1938-06-13UHC-36443-23—2622 Jefferson Ave, Charlotte, NC, 282540.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-56554TPAScott Gibson1966-11-03—4635858937—0.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-55619TPABradley W Bradley1955-04-08UHC-50612-81—4906 Lake View Rd, Los Angeles, CA, 900170.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56021TPAPriya Williams2001-04-12——7123 Ocean Ave, Glendale, AZ, 853720.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59218TPAWilliam Freeman1954-03-22——765 Highland Ave, Plano, TX, 750710.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60081TPADoris Mejia1971-01-16—30233891225866 Maple Ave, Atlanta, GA, 303150.80Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased
TPA-54005TPAMegan Meyer1945-04-12——4769 Park Pl, Atlanta, GA, 303300.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54004TPAMegan Meyer1945-04-12——4769 Park Pl, Atlanta, GA, 303300.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52450TPAHarold Little1943-05-17——298 Mountain View Dr, Austin, TX, 787820.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-52451TPAHarold Little1943-05-17——298 Mountain View Dr, Austin, TX, 787820.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-53184TPAKatherine Banks1965-10-15——914 Willow Ct, Tucson, AZ0.80State code upper-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-60890TPADennis Reyes1995-09-03——4946 Mesa Dr, Charlotte, NC, 282540.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63190TPACatherine Larson1971-12-20UHC-21179-85—2721 Sunset Blvd, San Diego, CA, 921090.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-59601TPAPatricia Olson1953-11-07UHC-37185-653932248539941 Apache Blvd, Houston, TX, 770040.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-59636TPABevrely Vasquez—UHC-14586-30——0.80Name re-casedDate of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-63368TPAJanet Carpenter1945-03-16——3704 Canyon Rd, Austin, TX, 787100.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-60691TPAScott Anderson1987-07-26—2314012079—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-53010TPARoger Fuller1975-07-09——1014 Mountain View Dr, Charlotte, NC, 282310.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63195TPABrenda Henderson1966-09-27UHC-12811-60—4171 Ridge Rd, Plano, TX, 750500.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57626TPAAdam Dunn2005-09-13—9466266907232 Lincoln Way, Atlanta, GA, 303660.80Name re-casedEmail lower-casedGender normalisedWhitespace trimmed
TPA-57625TPAAdam Dunn2005-09-13—9466266907232 Lincoln Way, Atlanta, GA, 303660.80Name re-casedEmail lower-casedGender normalisedWhitespace trimmed
TPA-60794TPAAbigail Luna1940-11-08UHC-74464-69—4651 Hillcrest Rd, Jacksonville, FL0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-51483TPATheresa Phillips1968-10-22UHC-72370-07—7237 Church St, San Antonio, TX, 782510.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56743TPAAlice Patterson2007-07-08—39762847929575 Washington St, Chandler, AZ, 852580.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-58039TPASteven Taylor2003-03-25——9165 Palm Dr, Gilbert, AZ, 852580.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-61884TPANathan Sanchez1961-05-19——9173 Cedar Ln, Las Vegas, NV, 891940.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60253TPADot Phillips1989-06-10—7893481548701 Sunset Blvd, San Antonio, TX, 782800.80Street suffix standardisedAddress re-casedCity re-casedPlaceholder values cleared
TPA-50120TPALauren Castro1964-01-22———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-50582TPAMateo Weaver1952-04-01UHC-06209-31——0.80Name re-casedTwo-digit birth yearMember ID reformattedPlaceholder values cleared
TPA-60929TPAFatima Ford1971-04-08———0.80Email lower-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-64093TPAPatrick Jenkins1987-04-22——975 Valley View Dr, Jacksonville, FL, 322340.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-52712TPALuis Porter2006-06-17—66585785712013 Lake View Rd, Jacksonville, FL, 322860.80Name re-casedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-59006TPADiane Jones1945-02-18—84829233028790 Broadway, Tempe, AZ, 852290.80Two-digit birth yearPhone reformattedWhitespace trimmedPlaceholder values cleared
TPA-52781TPALori Griffin1968-10-22UHC-27335-8535298411783594 Valley View Dr, Houston, TX, 770590.80Phone reformattedSSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-58408TPAAshley Hall2002-03-15——5373 Jefferson Ave, Nashville, TN, 372810.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62808TPAHelen Bishop1992-01-16——1149 Forest Ave, Chandler, AZ, 852530.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62925TPAAmy Bryant1959-06-18—5296876883—0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62956TPABruce Fox1979-09-06——4844 Cedar Ln, Austin, TX, 787440.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53438TPASofia Bishop2008-10-21—96285637887068 Mountain View Dr, Plano, TX0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54823TPANicholas J Little1996-03-25——2786 Bayshore Dr, Scottsdale, AZ, 852790.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60976TPALucia Morrison1945-10-17——889 Sage Ct, Plano, TX, 750650.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-57299TPALogan Bailey2001-10-07UHC-62349-08—2684 Grand Ave, Jacksonville, FL, 322090.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-53140TPAChristina Garza1981-02-15—2033280584305 Church St, Tampa, FL0.80Phone reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-55964TPABryan Jimenez1961-03-08UHC-52341-82—1671 Bayshore Dr, Phoenix, AZ, 850540.80Member ID reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54600TPAAustin Herrera2002-09-12———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55032TPAAngela King1988-12-23——6442 Main St, Mesa, AZ, 852690.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-63794TPAZachary Armmstrong1978-01-27——5977 Broadway, Phoenix, AZ, 850970.80Name split from “Last, First”City re-casedWhitespace trimmedPlaceholder values cleared
TPA-58272TPARussell Luna1991-11-16——3367 Elm St, Columbus, OH, 432180.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52489TPAStephen Chavez1993-06-01——3236 Jefferson Ave, San Antonio, TX0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
14,474 rows, page 182 of 290PreviousNext