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-410680CLMBobby Henderson1995-04-15—57098736709539 Mesa Dr Apt 2, Los Angeles, CA, 900270.66Date of birth reformattedPhone reformattedUnit split from streetGender normalised+1 more
CLM-423198CLMRalph Lynch2004-10-21—21356075872485 Church St, Mesa, AZ, 852860.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-425500CLMRandy Gonsales2005-02-16—40754311967227 Washington St Apt 40, Denver, CO, 802670.66Name re-casedPhone reformattedUnit split from streetGender normalised+1 more
CLM-420016CLMMark Lopez1989-03-13——7194 Park Pl, Sacramento, CA, 958430.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-421204CLMKathleen Santiago1943-10-11——3108 Apache Blvd, Las Vegas, NV, 891630.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410612CLMMei Weber2005-05-07UHC-36230-97—7138 Indian School Rd, Eden Prairie, MN, 553100.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-407627CLMFrances West1971-03-02UHC-96840-7848088902994234 Harbor Blvd, Houston, TX, 770690.66Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-426876CLMPhilip Johnston—UHC-61230-27—9556 River Rd, Tucson, AZ, 857890.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-408719CLMSusan Chavez1981-09-21UHC-26482-4232336101846323 Camelback Rd, Charlotte, NC, 282290.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411085CLMJeffrey Green1976-05-21——1429 Spring St Apt 25, Denver, CO, 802990.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428119CLMShirely Ellis1975-01-21UHC-40576-59—7905 Church St, Phoenix, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-415536CLMCharles Kelly2006-07-14——25 Jefferson Ave, Scottsdale, AZ, 852260.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415977CLMMegan Burton1962-12-19UHC-70543-77—2945 Hillcrest Rd, Columbus, OH, 432220.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428330CLMGary Schultz1974-05-01UHC-32024-80—2035 Jefferson Ave, Tucson, AZ, 857470.66Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+1 more
CLM-414519CLMJose Owens1987-02-07UHC-85056-73—1384 Pine Dr, Plano, TX, 750610.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-431854CLMMateo Q Ortiz1968-01-20—71040537849079 Grand Ave # 589, Austin, TX, 787910.66Phone reformattedUnit split from streetGender normalisedWhitespace trimmed+1 more
CLM-419331CLMSamuel Washington1976-07-18UHC-41066-05—8443 Spring St, Atlanta, GA, 303570.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-412859CLMMichael Harrison1963-07-09UHC-04868-24—7551 Lake View Rd, Los Angeles, CA, 900950.66Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412888CLMJoyce Morrison1976-09-09UHC-80236-4998020693594704 Lincoln Way, Columbus, OH, 432780.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-417920CLMPatrick Meyer1952-03-22UHC-05803-0564540299376386 Sage Ct, Dallas, TX, 752600.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
CLM-426109CLMMarcus D Gilbert1994-03-03——6817 Forest Ave, Glendale, AZ, 853580.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-431511CLMLisa H Catro1991-01-19UHC-96067-72—4502 Lake View Rd, San Diego, CA, 921180.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-416272CLMGreegory Valdez1940-07-20—47266527429392 Lake View Rd, Houston, TX, 770520.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-426030CLMJustin F Roggers2001-12-10——9050 Willow Ct Apt 17, San Diego, CA, 921220.66Middle initial moved out of first nameName re-casedUnit split from streetWhitespace trimmed+1 more
CLM-418188CLMJennifer Powell1953-10-20——5942 Forest Ave, Gilbert, AZ, 852500.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-417080CLMCamila P Hamilton—UHC-40053-43—1205 Washington St, Tempe, AZ, 852050.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-419876CLMMariana Nguyen1974-09-10——789 Highland Ave, Glendale, AZ, 853380.66Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-405659CLMRobert Z Tucker1945-03-04UHC-80868-2044662991857017 Baseline Rd, San Diego, CA, 921760.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-405817CLMDavid Lewis1981-04-09UHC-05353-85—5645 Apache Blvd, Eden Prairie, MN, 553660.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408028CLMNicholas Salazar2008-05-07——280 Union St, San Diego, CA, 921070.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-415556CLMRoy J Cole1939-01-05UHC-32635-4144945615213108 Central Ave, Sacramento, CA, 958970.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416498CLMAlice Larson1979-03-07UHC-47376-3687531200165606 Palm Dr, Austin, TX, 787360.66Name split from “Last, First”Two-digit birth yearPhone reformattedWhitespace trimmed+1 more
CLM-417718CLMJoseph Wheeler1991-05-12UHC-73218-61—3173 Willow Ct # 168, Sacramento, CA, 958920.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-417719CLMJoseph Wheeler1991-05-12UHC-73218-61—3173 Willow Ct # 168, Sacramento, CA, 958920.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-432026CLMJose K Carpenter1943-04-07UHC-84499-49—4048 Willow Ct Apt 2, Plano, TX, 750490.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-414543CLMSharon Z Walsh1952-05-11——9734 Union St, Tampa, FL, 336430.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-429526CLMBruce Blaack1996-05-13UHC-09980-64—1170 Cedar Ln, Seattle, WA, 981650.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416542CLMJanet Henderson1976-07-16UHC-29228-29—7039 Mountain View Dr # 867, Houston, TX, 770550.66Name re-casedMember ID reformattedUnit split from streetState name converted to code+1 more
CLM-409826CLMJuan Jimenez1964-10-13UHC-84918-3662094915542041 Forest Ave # 776, Dallas, TX, 752370.66Phone reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
CLM-400421CLMSophia Evans1952-02-02——5011 Maple Ave, Las Vegas, NV, 891990.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-426255CLMMarc K Matthews1990-03-08UHC-28870-27—4840 Market St, Austin, TX, 787550.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425609CLMNicle Evans1960-04-28—47066401622462 Maple Ave, Tucson, AZ, 857200.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425608CLMNicle Evans1960-04-28—47066401622462 Maple Ave, Tucson, AZ, 857200.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-429954CLMTerry Cunningham2007-03-21UHC-10855-14—7889 Lake View Rd, Jacksonville, FL, 322790.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-405494CLMLori A Fowler1972-10-21——194 Church St, Tampa, FL, 336400.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-432227CLMWayne Contreras1939-08-03UHC-45743-43—8608 Hillcrest Rd, Charlotte, NC, 282170.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-416214CLMAan O Maldonado1940-09-18UHC-40405-98—3947 Willow Ct, Fresno, CA, 937600.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-429463CLMRebecca Cox1997-02-09——8322 Sage Ct, Orlando, FL, 328580.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-412574CLMNunez N Douglas1959-01-02UHC-04096-4180671981494598 Spring St Apt 13, Dallas, TX, 752620.66Two-digit birth yearPhone reformattedUnit split from streetWhitespace trimmed+1 more
CLM-421632CLMWilliam Burton1962-03-18—74659885964536 Harbor Blvd, Houston, TX, 770700.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
32,829 rows, page 190 of 657PreviousNext