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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-415215CLMJerry Armstrong1940-04-10UHC-40480-51——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-421428CLMMason Chapman1978-07-24UHC-97175-04——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-428695CLMLaura Silva1951-08-26UHC-72934-78—9641 Valley View Dr, Austin, TX, 787430.70State name converted to codeZIP+4 trimmedPlaceholder values cleared
CLM-406141CLM—Junk1943-10-27UHC-20733-31—2915 Maple Ave, Chandler, AZ, 852260.70ZIP+4 trimmedPlaceholder values clearedNo usable name (quarantined)
CLM-420718CLMMatthew Smith1972-11-15UHC-99615-97—9483 Apache Blvd, San Diego, CA, 921900.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-416165CLMRalph Simmons——3536288229—0.70Name split from “Last, First”Date of birth missingPlaceholder values cleared
CLM-429003CLMEugene V Davis1996-04-01UHC-67371-84——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-404301CLMEugene Delgado1970-03-25——4758 Main St # 529, Tampa, FL, 336840.70Unit split from streetState name converted to codePlaceholder values cleared
CLM-408417CLMJames Burke1947-01-12UHC-47425-07——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-431508CLMLuis Sanders1927-12-14UHC-37937-73—7051 Canyon Rd, Glendale, AZ, 853010.70ZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-429876CLMRalph G Wagner1987-05-28———0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-418976CLMSharon Ortega1972-05-08UHC-75713-5393663903489011 Willow Ct, Atlanta, GA, 303060.70Phone reformattedState name converted to codeGender normalised
CLM-405060CLMBryan T Marshall1959-12-05UHC-99023-50—4458 Spring St, Houston, TX, 770770.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-424039CLMMazon Schultz—UHC-06517-82—773 Church St, Seattle, WA, 981580.70Date of birth unreadablePhone missing area codePlaceholder values cleared
CLM-400557CLMAmy Hudson1994-02-15——8671 Willow Ct, Denver, CO, 802710.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
CLM-405400CLMMarilyn W Nguyen1982-03-21—95059687366415 Broadway Apt 31, Tempe, AZ, 852560.70Unit split from streetState name converted to codePlaceholder values cleared
CLM-401353CLMJulia Ortega1975-07-12UHC-75167-48——0.70Two-digit birth yearSSN last four extractedPlaceholder values cleared
CLM-415439CLMAeron Fisher1993-10-26UHC-39898-77—1654 Ocean Ave, Jacksonville, FL0.70Phone missing area codeZIP missingPlaceholder values cleared
CLM-418045CLMJennifer Lewis1973-02-23UHC-67406-74—3020 Washington St, Houston, TX, 770900.70Name split from “Last, First”ZIP+4 trimmedPlaceholder values cleared
CLM-418991CLMKelly N Gonzales1965-12-21UHC-01397-49—4772 Forest Ave, Plano, TX, 750140.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-418990CLMKelly N Gonzales1965-12-21UHC-01397-49—4772 Forest Ave, Plano, TX, 750140.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-425231CLMBradley Cole1966-12-02UHC-02912-633476095712802 Canyon Rd, Scottsdale, AZ, 852130.70Name re-casedTwo-digit birth yearGender normalised
CLM-425113CLMGray Lawrence2008-10-13UHC-31573-55——0.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-417314CLMJason Wheeler1954-08-10———0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-405903CLMAlexander Reed1960-08-02——7671 Church St, Austin, TX, 787170.70Street suffix standardisedAddress re-casedGender normalised
CLM-428529CLMMarai Wagner1975-03-09——5713 Indian School Rd, Columbus, OH0.70State name converted to codeZIP missingPlaceholder values cleared
CLM-420803CLMJulia Z Garza—UHC-69609-77——0.70Date of birth missingGender normalisedPlaceholder values cleared
CLM-405882CLM—Junk1981-01-01UHC-84724-16——0.70Two-digit birth yearPlaceholder values clearedNo usable name (quarantined)
CLM-430899CLMRichardson Grace1979-11-01UHC-05731-22—489 Ocean Ave, Scottsdale, AZ0.70State name converted to codeZIP missingPlaceholder values cleared
CLM-416224CLMAmy D Mason1974-07-27UHC-63861-38—5602 Camelback Rd, Las Vegas, NV, 891130.70Name split from “Last, First”State name converted to codePlaceholder values cleared
CLM-423926CLMEthan Wood1961-04-06UHC-73564-91—5108 Lincoln Way, Nashville, TN, 372580.70State name converted to codeGender normalisedPlaceholder values cleared
CLM-422021CLMChristina Graham2000-01-21UHC-41760-0375545389296748 Camelback Rd, Jacksonville, FL, 322500.70Street suffix standardisedAddress re-casedZIP+4 trimmed
CLM-410019CLMJoseph Fowler1950-08-18UHC-38879-72—7897 Elm St, Miami, FL, 331540.70Street suffix standardisedAddress re-casedGender normalised
CLM-401144CLMRebecca Y Garza1976-06-04UHC-50074-12—5159 Mountain View Dr Apt 28, Gilbert, AZ, 852720.70Unit split from streetStreet suffix standardisedAddress re-cased
CLM-418542CLMKayla W Cunningham1964-01-07——8778 Cedar Ln # 966, Atlanta, GA, 303560.70Unit split from streetZIP+4 trimmedPlaceholder values cleared
CLM-411833CLMSarah Nguyen2004-01-18UHC-67677-608146241762127 Lake View Rd Apt 20, Orlando, FL, 328220.70Phone reformattedUnit split from streetZIP+4 trimmed
CLM-428412CLMWilliam Bradley1938-04-02———0.70Name split from “Last, First”Phone missing area codePlaceholder values cleared
CLM-400022CLMDon R Cole2002-06-28UHC-90325-35—2476 Broadway, Columbus, OH, 432400.70Two-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-432690CLMSusan U Hart1938-10-02UHC-24309-1935560063183896 Baseline Rd, Charlotte, NC, 282960.70Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-401342CLMZachary Rodriguez1941-10-09UHC-03456-11—7339 Jefferson Ave, Los Angeles, CA, 900910.70Phone missing area codeGender normalisedPlaceholder values cleared
CLM-426155CLMRussell Schultz1964-07-04——1372 Forest Ave, Plano, TX, 750330.70Street suffix standardisedAddress re-casedZIP+4 trimmed
CLM-410135CLMAndy Little1972-07-06UHC-11547-97—7344 Oak St, Chandler, AZ, 852760.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-402242CLMJesse Stewart———6125 Oak St, Gilbert, AZ, 852580.70Name split from “Last, First”Date of birth unreadablePlaceholder values cleared
CLM-413336CLM—Junk1945-01-25UHC-69613-43——0.70Two-digit birth yearPlaceholder values clearedNo usable name (quarantined)
CLM-429379CLMMorgan Denny1955-03-02——7311 Washington St # 540, Glendale, AZ, 853860.70Unit split from streetState name converted to codePlaceholder values cleared
CLM-429378CLMMorgan Denny1955-03-02——7311 Washington St # 540, Glendale, AZ, 853860.70Unit split from streetState name converted to codePlaceholder values cleared
CLM-418467CLMBrittany Rios——2496124145—0.70Date of birth unreadableGender normalisedPlaceholder values cleared
CLM-426501CLMGregory Alvarez1982-03-27UHC-67391-14—1067 Oak St # 230, Tempe, AZ0.70Unit split from streetZIP missingPlaceholder values cleared
CLM-406851CLMDiego H Gonzales—UHC-87150-98—3904 Market St, Minneapolis, MN, 554080.70Date of birth unreadableGender normalisedWhitespace trimmed
CLM-402617CLMKeith X Wells1951-03-11UHC-14936-0627490004239270 Camelback Rd, San Antonio, TX, 782870.70Two-digit birth yearGender normalisedWhitespace trimmed
32,829 rows, page 223 of 657PreviousNext