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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-52051TPAAhmed Vega2002-10-16—3932206753—0.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-59039TPAAustin A Matthews1998-04-17—790974151385 Union St, Tampa, FL, 336150.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63274TPABenjamin Taylor1965-12-19—90283459918247 Lake View Rd, Gilbert, AZ, 852170.80Name split from “Last, First”Phone reformattedState code upper-casedPlaceholder values cleared
TPA-54877TPANancy Davis1976-04-16—7686375785487 Pine Dr, Minneapolis, MN, 554800.80Street suffix standardisedAddress re-casedEmail lower-casedPlaceholder values cleared
TPA-59730TPAAmy Davis1987-11-28—6658721312—0.80Name split from “Last, First”Date of birth reformattedPhone reformattedPlaceholder values cleared
TPA-50583TPARaymond U Foster1973-06-17—28698694049571 Sunset Blvd # 201, Jacksonville, FL, 322620.80Name re-casedPhone reformattedUnit split from streetPlaceholder values cleared
TPA-50838TPAKyle Phillips1964-08-19——4114 Cedar Ln, Chandler, AZ, 852350.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55643TPAEric Phillips1951-12-09—66885163138796 Ridge Rd, Seattle, WA, 981490.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62776TPACheryl Weaver1965-09-19——5516 Lake View Rd, Miami, FL, 331260.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63855TPALogan Porter1973-10-07—31471835041265 Valley View Dr, Mesa, AZ, 852080.80Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed
TPA-55359TPAEvelyn Ortiz2000-03-11——5848 Sage Ct, Plano, TX, 750250.80Date of birth reformattedEmail lower-casedGender normalisedPlaceholder values cleared
TPA-58196TPASusan Alvarez1965-11-01———0.80Name re-casedDate of birth reformattedGender normalisedPlaceholder values cleared
TPA-61026TPAJoseph Y Reid1953-04-24——7309 Washington St, Dallas, TX, 752690.80Two-digit birth yearPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-58307TPAGry Vaga1996-03-01—9553631305—0.80Name re-casedPhone reformattedGender normalisedPlaceholder values cleared
TPA-50980TPALucia Espinoza1971-11-16——2739 Union St, Columbus, OH, 432070.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57362TPAThomas Black1962-10-13——9730 Oak St, Glendale, AZ, 853210.80Street suffix standardisedAddress re-casedPlan code upper-casedPlaceholder values cleared
TPA-54704TPAAmnada Washington1958-08-18—71380308241751 Lake View Rd, Jacksonville, FL, 322360.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-60543TPATyler Edwards1988-03-04——8005 Church St, Los Angeles, CA, 900560.80ZIP+4 trimmedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-55726TPAKathleen Brooks1987-01-02—34433155948400 Broadway, Tempe, AZ, 852160.80Name split from “Last, First”Phone reformattedCity re-casedPlaceholder values cleared
TPA-58664TPAArthur Sanders1946-01-06———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55538TPACharles Patel1997-03-15——8381 Hillcrest Rd, Tempe, AZ, 852190.80Name re-casedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-55528TPAElizabeth Ward1947-08-04———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53384TPAEmma Sims1963-11-28——7059 Sage Ct, Gilbert, AZ, 852220.80Date of birth reformattedZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-58124TPASophia Munoz1980-02-11—20969527863607 Mountain View Dr, Chandler, AZ, 852480.80Phone reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60453TPADonald O Jones1995-03-24———0.80Date of birth reformattedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62387TPAJacob McDonald1976-03-22—7204908175730 Central Ave, San Antonio, TX, 782420.80Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63362TPAJacob Dominguez1995-08-07——3852 Elm St, Chandler, AZ, 852150.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56872TPASamantha Coleman1974-01-06—82331362948594 Pine Dr, Dallas, TX0.80Date of birth reformattedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-57530TPARussell Evans1960-09-28——996 Oak St, Scottsdale, AZ, 852640.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56055TPACatherine T Robertson1941-07-02——4634 Desert Sky Blvd, Fresno, CA, 937660.80Name split from “Last, First”Date of birth reformattedWhitespace trimmedPlaceholder values cleared
TPA-61580TPAHannah Maartinez1944-05-13——6560 Lincoln Way, San Diego, CA, 921590.80SSN last four extractedEmail lower-casedWhitespace trimmedPlaceholder values cleared
TPA-54576TPAGregory Ellis1983-09-22——6057 Union St, Charlotte, NC, 282240.80Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53023TPABrandon Coleman1945-02-20——3945 Lake View Rd, Mesa, AZ, 852610.80Gender normalisedPlan code upper-casedWhitespace trimmedPlaceholder values cleared
TPA-56101TPAAmanda Johnston1994-09-04—66134932114504 Valley View Dr # 504, Scottsdale, AZ, 852530.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-63522TPATimothy Simmons1970-01-17——1641 Washington St, Glendale, AZ, 853620.80Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared
TPA-51494TPARyan C Patel2008-04-15—5068686599—0.80Name split from “Last, First”Phone reformattedWhitespace trimmedPlaceholder values cleared
TPA-60610TPAWei Austin1994-08-27UHC-88017-5161586034651250 River Rd # 127, Orlando, FL, 328140.80Phone reformattedUnit split from streetWhitespace trimmedPlaceholder values cleared
TPA-63907TPARebecca W Adams1965-02-17——7683 Meadow Ln, Tempe, AZ, 852130.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53553TPAChristopher Henderson1952-06-11——1971 Meadow Ln, Los Angeles, CA, 900520.80Name re-casedZIP+4 trimmedEmail lower-casedPlaceholder values cleared
TPA-52851TPARalph Schultz1980-08-17——6360 Ridge Rd, Minneapolis, MN0.80Name re-casedZIP missingWhitespace trimmedPlaceholder values cleared
TPA-64453TPARyan Stephens1975-11-12———0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51993TPANancy Castro2005-10-27——340 Canyon Rd, Tucson, AZ, 857670.80Date of birth reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57093TPAMarcus Valdez1994-01-05—52820522106287 Broadway, Denver, CO, 802210.80Name re-casedState code upper-casedGender normalisedPlaceholder values cleared
TPA-63570TPABrittany Banks1948-07-03UHC-86957-86——0.80Name re-casedGender normalisedWhitespace trimmedPlaceholder values cleared
TPA-61724TPAJoseph Spencer1986-06-21——8039 Central Ave, Orlando, FL, 328920.80Name re-casedCity re-casedState name converted to codePlaceholder values cleared
TPA-58850TPAAndrea Kim1945-04-05UHC-46800-074242687065—0.80Name re-casedTwo-digit birth yearPhone reformattedPlaceholder values cleared
TPA-54935TPAJoyce Q Spencer1948-01-17—97123809335919 Broadway, Sacramento, CA, 958000.80Name re-casedPhone reformattedSSN last four extractedPlaceholder values cleared
TPA-52745TPAArjun Wang1953-11-17——8871 Lincoln Way, Las Vegas, NV, 891610.80Date of birth reformattedState name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-52368TPADouglas Sims1955-11-20—85359420989415 Baseline Rd, Chandler, AZ, 852380.80Name re-casedPhone reformattedState name converted to codePlaceholder values cleared
TPA-58084TPALogan Morgan1975-11-03——5987 Ocean Ave, Glendale, AZ, 853590.80Name split from “Last, First”State code upper-casedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 193 of 290PreviousNext