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-55802TPALori Butler1989-02-02——1700 Spring St, Atlanta, GA, 303830.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56196TPASam Garcia1939-05-05——8620 Meadow Ln, Seattle, WA, 981370.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55099TPAEvelyn Martinez1976-09-16—91485077101377 Mesa Dr, Tempe, AZ, 852760.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56328TPALinda Weaver2008-05-21—50027178063756 Meadow Ln Apt 40, Plano, TX, 750570.78Name re-casedUnit split from streetCity re-casedWhitespace trimmed+1 more
TPA-54092TPANancy Carr1992-05-05——8493 Oak St, Seattle, WA, 981580.78Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-54244TPAHannah Jodan1999-12-14——278 Hillcrest Rd, San Diego, CA, 921230.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-55176TPAKevin W Andrews1969-12-10——3176 Washington St, San Diego, CA, 921410.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50581TPASara Gomez2002-04-12—65365452305624 Elm St, Columbus, OH, 432980.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61900TPAJuan Hunter1965-09-22——5057 Valley View Dr, Chandler, AZ, 852490.78Street suffix standardisedAddress re-casedCity re-casedWhitespace trimmed+1 more
TPA-50511TPAJerry West2005-09-21UHC-63267-0123858819165719 Willow Ct, Chandler, AZ, 852780.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63666TPAEugene Edwards1968-07-25—85928262766041 Ridge Rd, Mesa, AZ, 852180.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55118TPALaura Ramirez1953-01-09——2889 Pine Dr, Miami, FL, 331940.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-57363TPAKathryn Henderson1953-11-28—31248460624192 Market St, Las Vegas, NV, 891340.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51606TPAMichelle Lane1940-12-15——7817 Lake View Rd, Phoenix, AZ, 850500.78City re-casedState name converted to codeEmail lower-casedWhitespace trimmed+1 more
TPA-52258TPASophia Anderson1944-05-23——2387 Sage Ct, Houston, TX, 770740.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-52181TPAMaria Vargas1996-10-16——6130 Canyon Rd, Orlando, FL, 328100.78Street suffix standardisedAddress re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-55512TPAHenry Pierce2007-07-20UHC-46617-499179138692—0.78Name re-casedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-52006TPAAmber Mejia1953-02-17—49536261455149 Mesa Dr, Gilbert, AZ, 852650.78Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+1 more
TPA-54051TPABryyan Boyd1956-09-28—97498555224755 Central Ave, Nashville, TN, 372880.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-57969TPADavid E Lewis2006-06-05——8861 Mesa Dr, Los Angeles, CA, 900940.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59837TPAStephanie Williamson1961-09-28——9825 Mesa Dr, Las Vegas, NV, 891030.78Date of birth reformattedCity re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-62978TPAMargaret Knight1952-08-24—63843747255141 Harbor Blvd, Columbus, OH, 432940.78Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-62658TPALisa Burton1945-11-17UHC-23382-54—913 Lake View Rd, San Diego, CA, 921450.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58673TPAKaren Sanchez1979-08-25UHC-09664-1995970700088145 Main St, Plano, TX, 750740.78Date of birth reformattedMember ID reformattedState name converted to codeWhitespace trimmed+1 more
TPA-54184TPAJacob Chavez1996-07-24UHC-06319-2750996391318356 Mesa Dr, Las Vegas, NV, 891830.78Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-61522TPADouglas Woods1940-01-07———0.78Date of birth reformattedGender normalisedPlan code upper-casedWhitespace trimmed+1 more
TPA-50261TPABrandon Bryatn1980-12-13—95334002312086 Maple Ave, Atlanta, GA, 303420.78Name re-casedTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
TPA-52213TPADonna Torres1978-02-11———0.78Name re-casedDate of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-63215TPAFrances Hansen1958-11-10UHC-28727-85—8848 Lincoln Way, San Diego, CA, 921790.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60129TPAKathleen Hughes1949-12-20—69684089505289 Oak St, Phoenix, AZ, 850650.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59675TPAWilliam Black1956-04-12——3862 Canyon Rd, Houston, TX, 770980.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50797TPAKyle Li1966-03-10UHC-58094-35—7657 Elm St # 388, Austin, TX, 787740.78Name re-casedDate of birth reformattedUnit split from streetWhitespace trimmed+1 more
TPA-56230TPAHenry Reynolds2002-08-03—9764888719698 Mountain View Dr, Dallas, TX, 752730.78Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+1 more
TPA-58880TPAMari Armstrong1965-02-02—56892350026800 Maple Ave, Tampa, FL, 336770.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50762TPAYuki Brown1968-10-15——6134 Canyon Rd, Austin, TX, 787080.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62632TPABnejamin Hicks1968-09-17UHC-96945-10—3782 Jefferson Ave, Tucson, AZ, 857010.78Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60637TPAFatima Fisher1971-07-19—8483242784740 Cedar Ln, Tucson, AZ, 857830.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55049TPAAnthony Guerrero1972-11-10UHC-93685-6026229204006030 Main St, Austin, TX, 787330.78Phone reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60110TPAMason Reynolds1983-10-14UHC-91476-92—3585 Mountain View Dr, Scottsdale, AZ, 852700.78Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-60664TPABrandon Guzman1948-12-09——3766 Sunset Blvd, Tempe, AZ, 852260.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63707TPASandra Cunningham1962-04-13——2627 Jefferson Ave # 820, Los Angeles, CA, 900690.78Name re-casedUnit split from streetCity re-casedWhitespace trimmed+1 more
TPA-61601TPAAan Greene1943-11-23—53973317499748 Oak St, Columbus, OH, 432430.78Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-53915TPAMichael M Patel1960-12-08——4190 Forest Ave, Tempe, AZ, 852600.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58123TPAGary Perez1980-08-18—4456895197—0.78Date of birth reformattedPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-61230TPAElizabeth Weaver1985-07-09UHC-21629-88—2357 Ocean Ave, San Antonio, TX, 782390.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61231TPAElizabeth Weaver1985-07-09UHC-21629-88—2357 Ocean Ave, San Antonio, TX, 782390.78Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53708TPARonald Garza1959-09-25——1160 Highland Ave, Sacramento, CA, 958490.78Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-62128TPASharon Collins1974-04-03——3328 Camelback Rd, Charlotte, NC0.78Name re-casedDate of birth reformattedZIP missingWhitespace trimmed+1 more
TPA-61134TPAIsabella Garrett1940-11-15—9362653325571 Camelback Rd, Plano, TX, 750960.78Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60852TPAMason Garrett1942-05-13—53840330792814 Desert Sky Blvd, Tucson, AZ, 857510.78Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
14,474 rows, page 148 of 290PreviousNext