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-58960TPAKayla Hawkins1983-10-01———0.90Name re-casedDate of birth reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-59575TPAHelen Watson1971-09-09——4667 River Rd, Minneapolis, MN, 554230.90Name re-casedDate of birth reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-53605TPAMichael Wallace1939-08-27UHC-31536-4238061929141586 Cedar Ln, Los Angeles, CA, 900490.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-62788TPADavis I Beverly1976-12-19—2642854470—0.90Name re-casedDate of birth reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-53317TPAMary Howard1996-01-03—67854358293561 Desert Sky Blvd, Columbus, OH, 432530.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-59412TPAVincent Wong1946-12-15—4454922075—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-56161TPAAmber Miller1953-10-09—91121247425844 Baseline Rd, Columbus, OH, 432920.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-58247TPAJanice Morris1978-11-05—2807620499—0.90Date of birth reformattedPhone reformattedPlan code upper-casedWhitespace trimmed+1 more
TPA-60811TPAJustin G Bowman1980-11-01UHC-62449-2966632423651535 Washington St, Austin, TX, 787310.90Date of birth reformattedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-56307TPAVirginia G Delgado1938-11-13—40168795683315 River Rd, Glendale, AZ, 853670.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-57164TPAKathleen Johnston1964-01-05——1204 Highland Ave, Los Angeles, CA, 900560.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-63797TPADiego Collins2006-12-06UHC-59837-427065794686—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-58955TPAMary Garrett2007-12-22—39621122812645 Lake View Rd, Phoenix, AZ, 850180.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-54923TPANancy Wheeler1992-07-20—2838643586—0.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-62973TPADouglas Rodriguez1981-10-05——9676 Broadway, Chandler, AZ, 852980.90Name re-casedDate of birth reformattedAddress re-casedCity re-cased+1 more
TPA-50549TPACharlotte Guzman1985-05-17UHC-77788-735605303999—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-52518TPAAbigail Little1976-10-18——7922 Apache Blvd, Fresno, CA, 937880.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-51049TPAPamela Yang1973-10-23—3757099923—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-53288TPATeresa Hansen1960-05-19—51884833085250 Jefferson Ave, Minneapolis, MN, 554620.90Name re-casedPhone reformattedCity re-casedEmail lower-cased+1 more
TPA-61437TPAOlivia Hawkins1990-07-13—82577244394345 Lincoln Way, Mesa, AZ, 852330.90Name re-casedPhone reformattedCity re-casedWhitespace trimmed+1 more
TPA-62852TPAHannah Dunn2004-02-01——310 Church St, Austin, TX, 787150.90Name re-casedState code upper-casedPlan code upper-casedWhitespace trimmed+1 more
TPA-54025TPAHiroshhi Mliler1978-09-12UHC-76081-36——0.90Name re-casedDate of birth reformattedMember ID reformattedPlan code upper-cased+1 more
TPA-53000TPAKeith Valdez1972-04-23—59345255859071 Desert Sky Blvd, Austin, TX, 787430.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-62931TPASofia Alvarez1970-01-10—4097160451—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-59110TPABryan Graham1999-09-04—7656448229—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-63211TPAFatima Knight1963-09-13——2657 Market St, Eden Prairie, MN, 553020.90Name re-casedDate of birth reformattedCity re-casedWhitespace trimmed+1 more
TPA-59606TPAJoan Larson1949-09-16—97187938522943 Pine Dr, Tempe, AZ, 852590.90Date of birth reformattedCity re-casedEmail lower-casedWhitespace trimmed+1 more
TPA-61529TPAKally Woods1955-08-01——422 Willow Ct, Plano, TX, 750910.90Date of birth reformattedCity re-casedState code upper-casedWhitespace trimmed+1 more
TPA-57713TPASamuel Rodriguez1957-12-02—38020152769608 Meadow Ln, Plano, TX, 750180.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-60681TPARebecca Myers1985-12-02—52394438162515 Palm Dr, Tucson, AZ, 857670.90Name re-casedDate of birth reformattedPhone reformattedEmail lower-cased+1 more
TPA-63670TPAMarilyn Riley1961-02-05—32860261244027 Park Pl, Charlotte, NC, 282990.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-60202TPAKimberly Chapman1980-11-22—42589292993546 Meadow Ln, Mesa, AZ, 852130.90Name re-casedPhone reformattedPlan code upper-casedWhitespace trimmed+1 more
TPA-58858TPAKimberly Reynolds1995-06-10UHC-53253-1180790700955724 Elm St, Austin, TX, 787410.90Name re-casedPhone reformattedMember ID reformattedCity re-cased+1 more
TPA-59273TPASara Gordon1947-05-25—7009316062—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-62323TPAMary Herrera1973-03-20UHC-96852-3282991893127943 Palm Dr, Houston, TX, 770400.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-52354TPASandra Dixon1966-11-08—6462029251—0.90Date of birth reformattedPhone reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-59220TPAArthur Kelley1973-10-12—42667142275723 Washington St, Jacksonville, FL, 322020.90Name re-casedDate of birth reformattedState code upper-casedWhitespace trimmed+1 more
TPA-60530TPAAlice Meyer1980-10-04—4118073364—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-52641TPAPetter Simpson1980-02-20——2473 Lincoln Way, Fresno, CA, 937480.90Name re-casedCity re-casedState code upper-casedWhitespace trimmed+1 more
TPA-51203TPASophia Hayes1939-08-09—90851331454068 Harbor Blvd, Miami, FL, 331250.90Name re-casedDate of birth reformattedPhone reformattedCity re-cased+1 more
TPA-58318TPARichard Hicks1987-02-15—35149690436440 River Rd, Eden Prairie, MN, 553210.90Name re-casedDate of birth reformattedPhone reformattedCity re-cased+1 more
TPA-62385TPABenjamin Simmons1971-06-14—6653691551—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-52151TPAVincent Howard1993-07-20—6795633875—0.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-60451TPANatalie Carpenter1978-11-17—56996045418609 Cedar Ln, Eden Prairie, MN, 553680.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-62360TPASharon N Gilbert2003-05-14—68648517131467 Meadow Ln, Glendale, AZ, 853320.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-52446TPAJuan Simpson1953-03-05——4156 Sunset Blvd, Jacksonville, FL, 322110.90Name re-casedDate of birth reformattedEmail lower-casedWhitespace trimmed+1 more
TPA-53966TPADoris Stewart1968-03-04—61945110775776 Sage Ct, Minneapolis, MN, 554800.90Name re-casedPhone reformattedCity re-casedState code upper-cased+1 more
TPA-54644TPAKimberly Burns1964-05-08UHC-66985-612407424572577 Harbor Blvd, Miami, FL, 331420.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-57222TPABrandon Stevens1976-11-18—63434615004843 Palm Dr, Eden Prairie, MN, 553450.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
TPA-59554TPAJoseph Hicks1952-12-20UHC-60781-7673757815013341 Broadway, Minneapolis, MN, 554390.90Name re-casedDate of birth reformattedPhone reformattedWhitespace trimmed+1 more
14,474 rows, page 224 of 290PreviousNext