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-63304TPACharlotte Vasquez1941-01-08—86035046355356 River Rd, Mesa, AZ, 852800.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55955TPAAshley A Arnold1960-12-17——5208 Baseline Rd, Sacramento, CA0.66Name re-casedDate of birth reformattedZIP missingGender normalised+1 more
TPA-59346TPAAmanda Phillips1987-07-18UHC-49815-50——0.66Name split from “Last, First”Two-digit birth yearEmail lower-casedPlan code upper-cased+1 more
TPA-56324TPALuis Miller1998-03-25——6417 Apache Blvd, Fresno, CA, 937950.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-56303TPAAdam Harper1995-09-18—54434575272959 Mountain View Dr, Tempe, AZ, 852210.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62907TPAJeremy Garza2000-07-21—97140044376942 Mountain View Dr, Charlotte, NC, 282890.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-61384TPARichard Burke1947-04-17—61368558087848 Central Ave, Charlotte, NC, 282830.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-50301TPAAlbert Mroales1949-06-03——4504 Lake View Rd, Gilbert, AZ, 852150.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54967TPAAmber Young1990-08-06——5945 River Rd, Nashville, TN, 372180.66Phone missing area codeEmail lower-casedGender normalisedWhitespace trimmed+1 more
TPA-58503TPAShirley Wheeler1995-08-12——8363 Sage Ct, Tucson, AZ, 857010.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-59119TPAJordan Li2004-01-13——6736 Mesa Dr, Orlando, FL, 328940.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-54245TPASamuel Carr1956-02-23——1920 Ridge Rd, Denver, CO, 802450.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57576TPAWilliam Jimenez1982-03-19——210 Valley View Dr, Los Angeles, CA, 900410.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-50639TPADylan S Wang1941-03-06——7317 Sage Ct, Mesa, AZ, 852210.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-56921TPARandy Griffin———3473 Pine Dr, Seattle, WA, 981290.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
TPA-55035TPABrenda Tran1994-10-17——9506 Lake View Rd, Tucson, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-55228TPAGarza Natalie1984-06-04UHC-86293-5351269874466728 Elm St, Austin, TX, 787940.66Name re-casedPhone reformattedZIP+4 trimmedGender normalised+1 more
TPA-61769TPANacy Richards1948-06-12——8910 Mountain View Dr, Dallas, TX, 752340.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55392TPAJulie Lewis1963-03-22—28628806967632 Church St, Seattle, WA, 981670.66Name split from “Last, First”Phone reformattedState name converted to codeEmail lower-cased+1 more
TPA-63717TPADoris Mendez1997-11-25——4014 Harbor Blvd, Miami, FL0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-63625TPAJerry Stevens1998-06-17——4239 Union St, San Diego, CA, 921620.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-57283TPAOmar Castro1938-12-18UHC-52606-73—6204 Forest Ave, Gilbert, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-59326TPAKathleen Santiago1943-10-11—50275555513108 Apache Blvd, Las Vegas, NV0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-64116TPAKaren Spencer1969-12-21——1338 Cedar Ln, Phoenix, AZ, 850040.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63392TPAAnn Williamson1963-02-12—5907757710567 Meadow Ln, Atlanta, GA, 303220.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-63844TPAElizabeth Matthews1994-08-26UHC-83163-59—8220 Bayshore Dr, Orlando, FL, 328550.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55238TPANancy Stephens2005-01-22——8008 Ocean Ave, Scottsdale, AZ, 852050.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
TPA-50714TPAJudy Schultz1971-11-05——4311 Sage Ct # 928, Mesa, AZ, 852350.66Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-58359TPALawrence Burke1981-07-17——6947 Apache Blvd, Mesa, AZ, 852510.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
TPA-56472TPARachel Ray1956-09-26——4441 Palm Dr # 535, Fresno, CA, 937910.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-54292TPAJessica Chavez2008-08-08——3793 Washington St, Phoenix, AZ, 850910.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-52621TPAThomas Armstrong1993-12-04UHC-87670-07—1436 Elm St, Austin, TX, 787090.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
TPA-60265TPASara Roberts1950-08-19——7982 Maple Ave, Fresno, CA, 937990.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-57775TPAMark Ford———2379 Lake View Rd, Eden Prairie, MN, 553520.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63641TPAJoseph Lucas1963-11-28——4555 Lincoln Way, Atlanta, GA, 303450.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61809TPARobert Harper1995-09-18——4989 Main St, Chandler, AZ, 852190.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56893TPARichard Sandoval1947-10-27—69229864237359 Harbor Blvd, San Diego, CA, 921070.66Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+1 more
TPA-56892TPARichard Sandoval1947-10-27—69229864237359 Harbor Blvd, San Diego, CA, 921070.66Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+1 more
TPA-57799TPAHelen V Bailey1953-03-28——6658 Maple Ave, Seattle, WA, 981720.66Middle initial moved out of first nameName re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52140TPAGabriel Medina1972-08-05——5361 Ocean Ave, Tempe, AZ, 852620.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-61804TPAJanice Duncan2003-08-22UHC-43398-21—1469 Central Ave, Los Angeles, CA, 900990.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-60667TPAAisha Bishop———2430 Maple Ave, Orlando, FL, 328710.66Name re-casedDate of birth unreadableCity re-casedZIP+4 trimmed+1 more
TPA-58856TPA—Junk1966-06-07——723 Camelback Rd, Chandler, AZ, 852110.66Street suffix standardisedAddress re-casedWhitespace trimmedPlaceholder values cleared+1 more
TPA-56839TPACheryl K Nunez1974-03-17—8004872922—0.66Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed+1 more
TPA-57747TPAMark George1938-12-13UHC-88108-619339409905—0.66Phone reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
TPA-58923TPABeverly Chen1946-04-03——3317 Park Pl # 825, Las Vegas, NV, 891550.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51429TPAArthur Halll———686 Church St, Glendale, AZ, 853600.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-57890TPASara Jones1965-11-04——5042 Main St, Columbus, OH, 432430.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-55350TPARonald Alexander1990-01-09——4525 Union St, Jacksonville, FL, 322290.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-60877TPAVincentJunk1973-06-20UHC-26763-5529775896488234 Jefferson Ave, San Antonio, TX, 782460.66Phone reformattedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
14,474 rows, page 78 of 290PreviousNext