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-416359CLMGabriel Estrada1989-03-12UHC-50678-72—1134 Broadway, Charlotte, NC0.62Name re-casedDate of birth reformattedAddress re-casedZIP missing+3 more
CLM-427072CLMDeb Obrien1991-02-05UHC-77787-12—6867 Main St, Los Angeles, CA, 900990.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431540CLMWilliam Webb1986-01-20UHC-85317-53—2004 Willow Ct, San Diego, CA, 921210.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403331CLMTeresa Hayes1962-10-05—26236785462774 Pine Dr # 533, Gilbert, AZ, 852360.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430998CLMPatricia J Campbell2005-01-09UHC-11831-882884738339921 Jefferson Ave, Miami, FL, 331410.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-403538CLMAhmed Moore—UHC-96359-72—5163 Valley View Dr, Houston, TX, 770250.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-429743CLMJanice Nichols1956-07-20UHC-09999-74—5197 Indian School Rd # 227, Houston, TX, 770640.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430744CLMLarry Hansen1999-08-13——5799 Union St, Tucson, AZ, 857520.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427168CLMDoris Pierce1947-07-28—66385386379815 Palm Dr, Atlanta, GA, 303960.62Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-420571CLMLinda McDonald1980-04-09—65565505586056 Highland Ave, Atlanta, GA, 303850.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425077CLMElijah Williams1959-10-23UHC-93427-23—1960 Apache Blvd, Houston, TX, 770660.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401116CLMCamila Austin2001-05-25UHC-06304-1829120875113279 Sage Ct, Mesa, AZ, 852230.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425437CLMEric Wang1975-11-25UHC-55140-3556756304139887 Mountain View Dr, Austin, TX, 787970.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402535CLMAndrea S Cook1969-03-28UHC-23088-7568773793738650 Maple Ave, Scottsdale, AZ, 852980.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401105CLMJames Sara1964-06-24—51520872172639 Sage Ct, Tempe, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400517CLMEvelyn Rodriguz1946-12-04UHC-93535-65915651132644 Palm Dr, Austin, TX, 787670.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405222CLMWelch Lisa——63279750837329 Maple Ave, Tempe, AZ, 852610.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-404258CLMJulie Garza—UHC-95660-0376756964876575 Meadow Ln, Seattle, WA, 981910.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-401872CLMAlbert Rogers1965-11-21UHC-07011-4569640075557894 Cedar Ln, Mesa, AZ, 852260.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-425891CLMRandy Edwards1967-04-07——1054 Washington St, Miami, FL, 331280.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414668CLMDoris Watson—UHC-23249-9652647653446258 Forest Ave, Charlotte, NC, 282670.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-408045CLMRichard Gonzalez1948-08-23UHC-95484-1328162497123331 Church St, Eden Prairie, MN, 553960.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414015CLMDavid Martin1966-07-04—20444247257248 Grand Ave, Sacramento, CA, 958760.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-417788CLMWei F Shaw1947-06-24UHC-62420-46—5446 Market St, Plano, TX, 750990.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432743CLMJoan Weber1973-06-08UHC-20455-7873362226839509 Park Pl, San Diego, CA, 921530.62Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-429137CLMRoger Lawrence1963-10-28UHC-53970-06—305 Pine Dr, Las Vegas, NV, 891080.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-420009CLMEdward Elliott1979-05-08UHC-33180-88—2976 Park Pl, Tempe, AZ, 852300.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404374CLMBetty Soto1974-12-06UHC-59887-21—8097 Bayshore Dr, Miami, FL, 331580.62Date of birth reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-429312CLMBetty Wright1996-05-07UHC-97501-9660766401206345 Desert Sky Blvd, Miami, FL, 331020.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406110CLMAdam Contreras1973-04-05UHC-75072-2628448251125706 Indian School Rd, Plano, TX, 750910.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-429428CLMGary Dominguez1991-10-24UHC-20825-2577437563275896 Camelback Rd Apt 20, Austin, TX, 787980.62Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-432387CLMMargaret Ramoos1995-07-26——4658 Mesa Dr, Columbus, OH, 432220.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-408235CLMWillie Fox1959-07-18UHC-90861-56—6086 Harbor Blvd, Mesa, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406156CLMStephens Katherine—UHC-94512-4477071533492233 Pine Dr, Scottsdale, AZ, 852830.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-425336CLMLarry Li2001-07-08—77160606883403 Willow Ct, Miami, FL, 331610.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-411636CLMSuan Coleman1952-10-13UHC-57625-863484770801355 Mountain View Dr, Tempe, AZ, 852080.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418192CLMBrandon Reid1968-11-07UHC-76294-1955359394034052 Indian School Rd, Glendale, AZ, 853880.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-418110CLMBetty X Valdez2006-06-04UHC-98999-6180943974706270 Oak St, Minneapolis, MN, 554620.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429110CLMChristopher Stevens1992-09-21——6186 Elm St, Plano, TX, 750060.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409211CLMJeffrey P Clark1962-10-22——353 Elm St, Sacramento, CA, 958210.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427227CLMMichelle Soto1948-06-18—45967150374713 Lincoln Way, Scottsdale, AZ0.62Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
CLM-415692CLMBryan K Scott1969-06-16UHC-62566-0128989243157540 Jefferson Ave, Chandler, AZ, 852420.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406186CLMEugene Sanchez2000-07-06—88581489132820 Palm Dr, Fresno, CA, 937290.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-431306CLMAmber Milsl1988-04-07UHC-83923-0246445490856809 River Rd, San Diego, CA, 921820.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416496CLMAisha Gibson1942-12-19—87736347953743 Church St, Atlanta, GA, 303590.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-419897CLMLinda Hill1999-06-21UHC-06589-71—1446 Bayshore Dr, Denver, CO, 802220.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-413608CLMLucia N Castillo2001-02-21——769 Hillcrest Rd, Minneapolis, MN, 554430.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-402745CLMYuki Collins1983-01-13UHC-91200-0735979759661167 Camelback Rd, Jacksonville, FL, 322480.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405442CLMJason Mills1948-12-08UHC-87174-7428124752911493 Sage Ct Apt 29, Columbus, OH, 432030.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-403157CLMEdward X King1959-11-13UHC-04608-196485705403183 Grand Ave, Sacramento, CA, 958600.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 78 of 657PreviousNext