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-424211CLMAnna Hamilton1982-06-21UHC-04826-7543078662896670 Apache Blvd, Atlanta, GA, 303260.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-416593CLMJohn Larson1979-08-14UHC-27245-80—6872 Palm Dr, Phoenix, AZ0.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-421463CLMDenise Arnold1939-08-26—72351395191440 Ridge Rd, Fresno, CA, 937470.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-402749CLMFuller Serah1989-03-28UHC-79653-1645783903045473 Hillcrest Rd, Plano, TX, 750760.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-422983CLMOmar Schultz1966-11-10UHC-58276-6371740569456554 Park Pl, Austin, TX, 787270.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-409831CLMMei A Tuurner1965-10-04UHC-09846-2677896722977497 Spring St Apt 22, Tempe, AZ, 852250.60Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
CLM-410686CLMMyers Thomas1988-01-26—79844467504476 Desert Sky Blvd, Atlanta, GA, 303530.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431475CLMEmily F Dean1938-09-11UHC-59103-27809575390645 Oak St, Denver, CO, 802590.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-406113CLMJuan S Banks——82696593377773 Forest Ave, Las Vegas, NV, 891640.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-406592CLMMateo B Castro1969-09-04UHC-93344-27—9205 Apache Blvd, Phoenix, AZ0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422916CLMJustin Hamilton1945-09-22——9352 Church St # 770, Fresno, CA, 937630.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409471CLMBetty Mendez1998-09-03UHC-07773-92—5766 Spring St, Dallas, TX0.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411906CLMJonathan B Harris1997-12-08UHC-49757-3554149390084530 Indian School Rd, Las Vegas, NV, 891490.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403645CLMJulie Carr1968-10-10UHC-32531-56—8954 Ridge Rd # 189, Los Angeles, CA, 900440.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-425290CLMPatrick Collins1974-11-27UHC-70965-5973083912451406 Maple Ave, Jacksonville, FL, 322220.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-402214CLMRebecca V Clark2004-07-06UHC-91106-0630970281714900 Market St, San Antonio, TX, 782630.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-427133CLMSteven Welch2002-11-08UHC-34050-0881931491224193 Market St, Los Angeles, CA, 900370.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416205CLMHannah Valdez1981-05-11——5846 Canyon Rd, Nashville, TN, 372020.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403314CLMBeverly Flores1948-09-02UHC-34954-61—107 Pine Dr, Las Vegas, NV, 891480.60Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-421946CLMEmma Castillo1946-04-21UHC-53809-2889070325152824 Park Pl, Glendale, AZ, 853510.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421282CLMTerry Hall1988-07-22UHC-83199-4476147968069208 Mesa Dr, San Antonio, TX, 782880.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-403383CLMJacob Guerrero2004-01-18UHC-78856-8733173664221954 Grand Ave, Plano, TX, 750790.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-409816CLMHiroshi Rice1947-09-04—65334236675783 Oak St, Jacksonville, FL, 322710.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411933CLMAna Mejia1990-02-18UHC-35659-03—8489 River Rd, San Diego, CA, 921430.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426485CLMJesse Freeman2001-09-26UHC-54492-80—3400 Grand Ave, Tucson, AZ, 857530.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429016CLMBrenda P Green1966-08-06—24646199234014 Canyon Rd, Eden Prairie, MN, 553480.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-421126CLMFrnces P Ruiz1949-05-28UHC-20383-9344066638844560 Cedar Ln, Mesa, AZ, 852150.60Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-423273CLMBruce Carter1968-03-28UHC-29998-4954476475033127 Mountain View Dr, San Diego, CA, 921190.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-407039CLMJudith Mendez1952-03-15—83398062454935 Pine Dr, Austin, TX, 787740.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416901CLMMichelle Andrews1993-08-24UHC-95441-1523778711996315 Highland Ave, Orlando, FL, 328740.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428908CLMJanice Rose1962-07-21—85230328954623 Highland Ave, Chandler, AZ, 852340.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-426147CLMDiana R Mills1989-02-06UHC-78735-8796057425785029 Union St, Los Angeles, CA, 900530.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425450CLMJudy K Snyder2001-04-21UHC-49523-70—4775 Baseline Rd, Austin, TX, 787410.60Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
CLM-427913CLMDenise Little1975-11-22——3747 Market St, Mesa, AZ, 852070.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-425549CLMAisha Maldonado1965-04-08UHC-43714-1824063084386060 Sage Ct, Orlando, FL, 328670.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412370CLMCharles Franklin1997-06-08UHC-12070-1674680428913188 Cedar Ln, Scottsdale, AZ, 852360.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-424994CLMAlice Gomez1939-01-07—64781360035999 Sage Ct, Fresno, CA, 937110.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-431781CLMMarcus Coleman1994-10-28UHC-81728-733907759461304 Pine Dr Apt 19, Plano, TX, 750450.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-411623CLMWei Schmidt1999-03-17UHC-77674-7533553311284870 Pine Dr, Tempe, AZ, 852100.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-409981CLMWei Bradley1962-09-24UHC-76357-55—2524 Baseline Rd, Columbus, OH, 432970.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-417295CLMBrittany Aguilar2000-11-16—74826441774574 Willow Ct, Gilbert, AZ, 852080.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-415667CLMMei Hunt1946-12-20—46034160527787 Baseline Rd, Phoenix, AZ, 850530.60Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-407295CLMDebra Rojas1989-11-06UHC-98536-76—1359 Desert Sky Blvd Apt 25, Atlanta, GA, 303590.60Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-422368CLMDiane Evans1960-08-13UHC-63208-5239789187203144 Church St, Austin, TX0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-415633CLMMei Wallace2005-01-01—57497018264583 Cedar Ln, Seattle, WA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417151CLMMaria T Hansen1977-08-11UHC-09268-6044776457507203 Central Ave, Los Angeles, CA0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418820CLMMarilyn Garrett1941-06-07—23956118662901 Cedar Ln, San Diego, CA0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-414864CLMSctot Gibson1966-11-03—46358589371015 Willow Ct, Glendale, AZ, 853900.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424357CLMJulie Alexander1996-01-22UHC-03560-0279835547186091 Highland Ave, Miami, FL, 331030.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422998CLMPat Marshell1981-06-08—61244282367133 Cedar Ln, Houston, TX, 770720.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
32,829 rows, page 69 of 657PreviousNext