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-411798CLMCamila Harrison1995-09-12UHC-38431-2669320455712903 Main St, Phoenix, AZ, 850220.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-431390CLM—Junk1957-01-13UHC-15907-3720123180413649 Ridge Rd, Fresno, CA, 937180.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-417353CLMIsabella HJunk1941-05-22——9391 Ridge Rd, Sacramento, CA, 958680.64Street suffix standardisedAddress re-casedPlan code upper-casedWhitespace trimmed+2 more
CLM-409350CLMTeersa Williamson1981-01-26UHC-54512-54—2913 Lincoln Way Apt 6, Dallas, TX, 752570.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413225CLMCharlotte Tomas1985-04-14UHC-46370-0593460246508922 Spring St Apt 5, Mesa, AZ, 852320.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418260CLMMariana Fowler1986-11-05UHC-92162-53—6958 Mountain View Dr, Scottsdale, AZ, 852920.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429409CLMMartha Carpenter2001-04-23UHC-56556-7952987983615056 Lincoln Way, Fresno, CA, 937260.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416266CLMJonathan Weaver1970-01-17UHC-41663-2186893331577790 Park Pl, Nashville, TN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-420246CLMEthan Body1990-12-17UHC-52979-83—7978 Sage Ct, Atlanta, GA, 303720.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423924CLMMarcus Fuller1967-12-11—91299122799406 Indian School Rd # 551, Scottsdale, AZ, 852910.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-407732CLMBeverly Padilla1954-10-26UHC-35803-1553953481706136 Park Pl, Mesa, AZ, 852250.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421297CLMJerry O McDonald1969-01-06UHC-06839-0685451360549110 Jefferson Ave, San Diego, CA, 921600.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-401368CLMScott Rynolds1944-05-06UHC-58037-43—9018 Harbor Blvd, Jacksonville, FL, 322810.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432483CLMValentina Mejia1965-08-16UHC-25585-49—7607 Hillcrest Rd, Eden Prairie, MN, 553860.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-408379CLMRalph Graham1981-01-27—40144090123792 Palm Dr Apt 22, San Diego, CA, 921270.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-402479CLMLawrence Hansen1979-06-08—47190345267582 Valley View Dr, Austin, TX, 787680.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404194CLMJason Green1941-11-27—59390841467548 Harbor Blvd, Tucson, AZ, 857380.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430374CLMJacqueline Gomez1967-02-17UHC-57063-1692547037631869 Palm Dr, Charlotte, NC, 282460.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-400766CLMSamuel Price1987-11-25——3203 Central Ave, Atlanta, GA, 303650.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407843CLM—Junk1968-09-13UHC-72065-17—3206 Meadow Ln, Scottsdale, AZ, 852050.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-407842CLM—Junk1968-09-13UHC-72065-17—3206 Meadow Ln, Scottsdale, AZ, 852050.64Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-408801CLMTheresa Wheeler1953-07-08——8531 Camelback Rd, San Diego, CA, 921870.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400146CLMKatherine Young1985-06-08UHC-45033-96—9786 Mountain View Dr, Austin, TX, 787650.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426281CLMNathan Crawford2002-06-03—83773774599803 Baseline Rd, Tempe, AZ, 852480.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430455CLMRalph Phillips1983-08-09—46360045766178 Park Pl, Austin, TX, 787120.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409668CLMBarara Hansen1980-06-28—96566358758572 Bayshore Dr Apt 2, Dallas, TX, 752180.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-409667CLMBarara Hansen1980-06-28—96566358758572 Bayshore Dr Apt 2, Dallas, TX, 752180.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418683CLMWillyam Reid2005-08-01—87770967267293 Elm St, Houston, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405989CLMJoshua B Marshall———8078 Canyon Rd, Mesa, AZ, 852660.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-419054CLMRandy Flores1949-04-14UHC-96097-0388797285929683 Indian School Rd Apt 4, Orlando, FL, 328760.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425721CLMKethleen Day1966-11-21—41467530983932 Meadow Ln Apt 11, Tampa, FL, 336600.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-416500CLMGary Vazquez1974-01-17—93325719419390 Bayshore Dr, Austin, TX, 787200.64Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-411811CLMMichelle Romero1939-12-08UHC-14494-77—2821 Harbor Blvd, Nashville, TN, 372190.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-409135CLMJacqueline Turner2000-11-12——898 Lincoln Way, Austin, TX, 787890.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-414278CLMZachary Watkins1962-03-15——9266 Ridge Rd, Atlanta, GA, 303220.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407666CLMKevin Scott1977-09-05UHC-95333-52—4444 Willow Ct, Nashville, TN, 372510.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422706CLMVirginia Cunningham1956-10-16UHC-75540-38—2093 Bayshore Dr, Charlotte, NC0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-402717CLMWayne Lwrence1941-10-10—49593151406617 Hillcrest Rd Apt 15, Chandler, AZ, 852280.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-424706CLMNathan E Yang1957-05-21UHC-79738-9149492714014848 Hillcrest Rd, Los Angeles, CA, 900020.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416284CLMJason Montgomery1998-09-24UHC-17328-7282562527928845 Park Pl, Orlando, FL, 328910.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-428642CLMCarlos Henry1980-07-13UHC-01106-0777039733821706 Jefferson Ave, Minneapolis, MN, 554190.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-431743CLMJudith Mendez1988-03-27—77083645566691 Meadow Ln, Miami, FL, 331710.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404456CLMBrittany KJunk1943-04-15UHC-13360-017207147632199 Grand Ave, Scottsdale, AZ, 852680.64Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+2 more
CLM-400243CLMPamela Gonzalez1996-12-18UHC-32865-9482987413202138 Highland Ave, San Diego, CA, 921480.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-428531CLMVirginia Kim1945-08-11UHC-47194-2393345910234941 Mesa Dr, Las Vegas, NV0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423366CLMYuki Z Wright1986-02-22UHC-59968-8694668355889017 Pine Dr, Jacksonville, FL, 322410.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-411311CLMAlexander Y Reynolds1990-08-03—69930425777344 Cedar Ln Apt 7, Glendale, AZ, 853330.64Date of birth reformattedPhone reformattedUnit split from streetGender normalised+2 more
CLM-414440CLMEvelyn Q Guzman1993-10-24——8001 Pine Dr, San Diego, CA, 921580.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421348CLMMichelle Cooper1958-06-26—67575708473137 Sunset Blvd # 723, Houston, TX, 770980.64Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-403635CLMHenry Marshall1954-10-23UHC-90506-2565873319208683 Forest Ave, Orlando, FL, 328730.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
32,829 rows, page 106 of 657PreviousNext