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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-56959TPAGeorge Bennett1984-02-09UHC-71808-02—4299 Mountain View Dr, Orlando, FL, 328170.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56440TPANicole Long1966-04-13——200 Grand Ave, Chandler, AZ, 852030.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63295TPAJennifer Bowman1995-06-08——9289 Canyon Rd, Mesa, AZ, 852440.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-63930TPAMason Q Stone1983-10-10——5591 Park Pl, Glendale, AZ, 853920.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-57527TPABrian Gutirerez1995-03-11——6475 Central Ave, Sacramento, CA0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-57755TPAHenry Jacobs1983-09-26—33347961399810 Palm Dr, Houston, TX, 770830.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57112TPALarry Richardson1968-09-23——5408 Ocean Ave, Atlanta, GA, 303180.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53431TPASuphia Bowman1983-01-26UHC-12484-24—1910 Forest Ave, San Diego, CA, 921670.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50074TPARick Kelley1961-01-10——1539 Spring St # 849, Atlanta, GA, 303070.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
TPA-53353TPAEmma Graham1978-09-13——6542 Central Ave, Glendale, AZ, 853060.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58961TPAPaul Brooks1952-12-01——5911 Lake View Rd, Tucson, AZ, 857620.68Name split from “Last, First”City re-casedState name converted to codePlaceholder values cleared
TPA-55514TPAAmber Castro1997-08-04——6391 Elm St, Atlanta, GA, 303580.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60488TPAAnna Wong————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-55828TPASusan Adams1992-09-01—53881365628014 Valley View Dr, Minneapolis, MN, 554100.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-60008TPARussell Gutierrez1986-01-15——1669 Market St, Minneapolis, MN, 554540.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51951TPAWillie Boyd2004-10-16UHC-34280-19—2977 River Rd, Gilbert, AZ, 852610.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-64324TPARoger G Martinez1990-03-15——6998 Cedar Ln, Phoenix, AZ, 850490.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53459TPAJanice Simpson1998-06-25—2879244771—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-60868TPADorothhy C Fox1960-10-15——6342 Willow Ct, Minneapolis, MN, 554300.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58072TPALawrence Lane2006-08-09—95023983032237 Camelback Rd, Los Angeles, CA, 900830.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56026TPAAlexis Stephens1946-11-14——7276 Harbor Blvd, Denver, CO, 802950.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59069TPAElizabeth Daniels1976-05-23——605 Lincoln Way, Austin, TX, 787510.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50726TPAAhmed K Hart1960-03-01——4445 Jefferson Ave, Los Angeles, CA, 900390.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56824TPAOlivia K Perez1963-04-16——1737 Union St, Tampa, FL, 336890.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54128TPAAdam Evans1989-10-10—8297865093—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58909TPAMateo Simpson1977-01-14UHC-30934-6651249014715376 Broadway, Los Angeles, CA, 900180.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-64005TPAMari Tran1982-06-18UHC-00957-09—5726 Park Pl, Phoenix, AZ, 850610.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-58566TPAJerry Lane1949-10-23——2060 Ocean Ave, Orlando, FL, 328200.68Name split from “Last, First”Date of birth reformattedPhone missing area codeWhitespace trimmed
TPA-63875TPAPriya Santos1994-05-09——686 Canyon Rd, Tampa, FL, 336150.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-57824TPARobert Palmer1977-11-13—89032214005226 Forest Ave # 180, Tucson, AZ, 857350.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
TPA-51861TPAVirginia Lopez1984-07-02——9805 Maple Ave, Charlotte, NC, 282770.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53565TPAJudith Peters————0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
TPA-54151TPAJacob R Aguilar—UHC-45993-8238254392358043 Palm Dr, Tampa, FL, 336220.68Name split from “Last, First”Date of birth missingPhone reformattedPlaceholder values cleared
TPA-57404TPADaniel P Patel1995-10-17——8966 Sunset Blvd, Las Vegas, NV, 891960.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62472TPARoy Vargas1985-08-04—57656079754832 Canyon Rd, Los Angeles, CA, 900370.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51546TPATeresa Wilson1977-09-18UHC-45385-63—456 Canyon Rd, Tucson, AZ, 857750.68Name split from “Last, First”Member ID reformattedState name converted to codePlaceholder values cleared
TPA-61918TPAChristine Hunter——43345378507386 Forest Ave, Jacksonville, FL, 322280.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-50572TPAAmy Hayes1953-06-10——8700 Maple Ave, Atlanta, GA, 303920.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55173TPAKelly Martinez1999-11-10——2305 Apache Blvd, Seattle, WA, 981600.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62121TPAMartha Campbell1970-12-14—41760779193970 Harbor Blvd, Gilbert, AZ, 852010.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55313TPAMariana Scott1995-02-26UHC-73872-667708316082221 River Rd, Eden Prairie, MN, 553100.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-56769TPACheryl Walker1944-07-15——4512 Oak St, Tucson, AZ, 857330.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61064TPAMartha Y Dixno2007-02-09———0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-50053TPANathan Q Yang1989-12-19——7436 River Rd Apt 16, Seattle, WA, 981900.68Name split from “Last, First”Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-61481TPADorothy Salazar————0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-60171TPABobby Adams1972-01-12—20825047978522 Spring St Apt 23, Plano, TX, 750700.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
TPA-62553TPAJoyce Murray1984-04-01—4663273964—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-53158TPAChristine Munoz——2215303664—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-50905TPAAnthony Z Gray1947-05-21—49841691693721 Park Pl, Miami, FL, 331020.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55952TPAEugne Hanson1955-06-03——4699 Washington St, Atlanta, GA, 303240.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
1,488 rows, page 19 of 30PreviousNext