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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-412674CLMMaria Perry1978-04-28UHC-32511-5625397482666760 Willow Ct, Sacramento, CA, 958850.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409028CLMLogan Vega1999-02-16UHC-11562-5593655142632873 Cedar Ln, Austin, TX, 787670.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-408908CLMJose D Crafword1991-06-13——2181 Willow Ct # 513, Chandler, AZ, 852410.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419877CLMMariana Nguyen1974-09-10UHC-30578-857332586892789 Highland Ave, Glendale, AZ0.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
CLM-406793CLMBradley Taylor1977-02-24UHC-96928-9863179586774774 Meadow Ln, Plano, TX, 750450.64Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-417610CLMMari Perkins1947-08-16——9426 Camelback Rd, Charlotte, NC, 282020.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414591CLMVincent Vasquez1990-10-25——9056 Willow Ct, Orlando, FL, 328680.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422809CLMCarlos Daniels1975-11-06—72920726077882 Harbor Blvd, San Diego, CA, 921320.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426596CLMJudy Robinson1984-04-18—21258193281766 Maple Ave, Jacksonville, FL, 322580.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-422302CLMFrank A Payne1995-07-16UHC-69731-21—7646 Washington St, Phoenix, AZ, 850700.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411824CLMWillie Balck2001-09-22UHC-22972-70—4399 Sunset Blvd, Tucson, AZ, 857890.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-432167CLMAndrew Mitchell1963-11-28UHC-95456-0343578277404626 Elm St, Eden Prairie, MN, 553390.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420564CLMVincent Gutieerrez1950-01-08—82028061535152 Washington St, Orlando, FL, 328290.64Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-417254CLMJerry Contreras1983-12-09—93442805337457 Canyon Rd, Nashville, TN, 372080.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427362CLMNaathan Gilbert—UHC-54667-70—9116 Sunset Blvd, Charlotte, NC, 282170.64Date of birth reformattedDate of birth unreadableMember ID reformattedStreet suffix standardised+2 more
CLM-413991CLMGabriel Luna1959-09-13UHC-01468-9089347714113187 Oak St Apt 13, San Antonio, TX, 782780.64Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-413507CLMScott Fuller1965-02-05——7273 Mountain View Dr, Miami, FL, 331150.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-426835CLMElijah Weaver1954-12-01UHC-12057-36—2757 Cedar Ln, Seattle, WA, 981800.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-400926CLMPriya F Chen1999-03-03——6678 Ridge Rd, Nashville, TN, 372620.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431775CLMDorothy P Freeman1996-01-26—59572020617184 Market St, Tucson, AZ, 857820.64Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+2 more
CLM-409347CLMAissha Gonzalez1950-12-05UHC-12855-78—1930 Forest Ave, Tempe, AZ, 852160.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429504CLMSusan S Boyd—UHC-70334-03—8404 Elm St, Gilbert, AZ, 852070.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414347CLMHenry Jenkisn1952-06-23——8487 Washington St, San Diego, CA, 921000.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415868CLMNoah Burton1959-02-27——6852 Meadow Ln, Jacksonville, FL, 322590.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-420579CLMChristine Munoz1954-10-19UHC-75708-7071232091348026 Forest Ave, Mesa, AZ, 852560.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403151CLMDiego K Jones1981-07-13—4194872571—0.64Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+2 more
CLM-419085CLMScott H Tran1976-08-06UHC-47745-7386969953291201 Palm Dr, Houston, TX, 770310.64Middle initial moved out of first nameStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426659CLMLaura Q Collins1953-05-24UHC-74766-94—9697 Ridge Rd, Scottsdale, AZ, 852920.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-418038CLMBrandun Gilbert1979-12-13UHC-89487-0748022180442482 Market St, Phoenix, AZ, 850210.64Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+2 more
CLM-414922CLMJessica Cunningham1978-09-04UHC-94194-72—6160 Central Ave, Phoenix, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423433CLMValentina Freeman1967-01-26UHC-64211-4168447211035602 Harbor Blvd, Las Vegas, NV, 891390.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-414304CLMKnight Kathleen1981-08-22—23368736243149 Park Pl, Dallas, TX0.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-419207CLMAdam Roberts1976-02-27UHC-76557-89—5241 Lincoln Way, Minneapolis, MN, 554130.64Date of birth reformattedPhone missing area codeEmail lower-casedGender normalised+2 more
CLM-406401CLMElijah X West1967-12-05UHC-13763-06—1172 Mesa Dr, Tampa, FL, 336580.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-417120CLMTerry Snyder2007-04-01UHC-52224-9078494364595679 Park Pl, Denver, CO, 802010.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409031CLMPatricia O Andrews1996-05-07UHC-97038-28—9097 Washington St, Orlando, FL, 328730.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-424870CLMNancy C Mills1950-02-27UHC-50104-8178746799684406 Sunset Blvd, Chandler, AZ, 852510.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412464CLMMeyer Gloria1998-04-17UHC-03153-24—1137 Pine Dr, Houston, TX, 770080.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409111CLMZachary Ray2007-06-03—2036671378557 Bayshore Dr, Miami, FL, 331720.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421580CLMBruce Garza1983-07-07UHC-57480-49—5857 Spring St, Houston, TX, 770560.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425498CLMAmber Henry1992-07-12UHC-75407-58—5490 Indian School Rd, Chandler, AZ, 852060.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406676CLMWilliam Vasquez1939-01-24UHC-36379-12—3942 Union St, Minneapolis, MN, 554110.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413213CLMFrances Fields1952-11-04—4146613290565 Main St, Tempe, AZ, 852390.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-429395CLMAlexis Price1997-10-10UHC-53316-852034729259300 Bayshore Dr # 703, Atlanta, GA, 303580.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419796CLMEvelyn Hart2002-11-11UHC-67231-575626768152—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-408648CLMDebra Chavez1977-11-01UHC-26552-93—1967 Highland Ave, Sacramento, CA, 958310.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417521CLMDick E Kelley1963-12-07UHC-11767-95—68 Desert Sky Blvd, Tucson, AZ, 857190.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404856CLMBobby D Romero2001-02-09UHC-25052-40—8742 Park Pl, Seattle, WA, 981540.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-419306CLMWillie Harrison1984-07-13UHC-17637-8851395158237270 Harbor Blvd, Dallas, TX, 752030.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427184CLMAlbert U Johnston1961-05-09UHC-58242-5755487785045512 Highland Ave, Tucson, AZ, 857500.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 145 of 657PreviousNext