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-404742CLMLisa Jimenez1985-04-16UHC-89522-53——0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421691CLMWillima Olson1938-04-23———0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421124CLMCarolyn Day1973-03-06UHC-57139-5946835623223750 River Rd, Seattle, WA, 981700.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410903CLMRaymondJunk1998-12-22—27354172885942 Church St, Las Vegas, NV0.68Phone reformattedZIP missingPlaceholder values clearedNo usable name (quarantined)
CLM-429809CLMDenise E Lynch1965-06-12——4354 Sunset Blvd, Phoenix, AZ, 850590.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-420821CLMRalph Andrews1946-09-20UHC-36948-36——0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-431486CLMDeborah S Sullivan1976-10-27UHC-79813-8793936373066154 Sage Ct, Orlando, FL, 328710.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-427573CLMSantiago Willis2005-07-22——6570 Mesa Dr, Scottsdale, AZ, 852930.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-413523CLMGeorge Gomez1947-02-03——5861 Highland Ave Apt 26, Glendale, AZ, 853900.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-427412CLMRaymond Fox2005-05-06——9046 Desert Sky Blvd, Minneapolis, MN, 554840.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-419665CLMBeverly Lynch1919-04-16UHC-58484-01—7879 Washington St, Sacramento, CA, 958670.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-411084CLMMei Gibson1977-07-16UHC-57095-09—4459 Mesa Dr, Los Angeles, CA, 900950.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-418983CLMAbigail Hill1972-10-10UHC-09488-2149141669768313 Camelback Rd, Gilbert, AZ, 852600.68Street suffix standardisedAddress re-casedCity re-casedState name converted to code
CLM-412549CLMRachel Coleman1949-10-19UHC-34040-77—935 Meadow Ln, Atlanta, GA, 303760.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-424990CLMDenise T Alexander1954-06-06UHC-25357-86—1316 Sunset Blvd, Nashville, TN, 372330.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-415624CLMDonna Weaver1955-03-14——9791 Park Pl, Austin, TX, 787560.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
CLM-403512CLMRonald Alvarado——5806000138—0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-406010CLMMarilyn Alexander1940-02-06UHC-20423-2579463549869678 Indian School Rd, Atlanta, GA0.68Phone reformattedZIP missingGender normalisedPlaceholder values cleared
CLM-406958CLMJean Hudson1964-09-02UHC-23947-41—2624 Elm St, Eden Prairie, MN, 553650.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-406620CLMBrenda T Porter——4488079590—0.68Date of birth unreadablePhone reformattedGender normalisedPlaceholder values cleared
CLM-417794CLMJacob Schmidt1969-03-25UHC-25356-2654139232897946 Oak St, Columbus, OH, 432110.68Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-427784CLMShirley Vasquez1997-08-15UHC-77814-687012862573—0.68Name split from “Last, First”Member ID reformattedGender normalisedPlaceholder values cleared
CLM-419112CLMJacqueline Nelson1956-08-17———0.68Name split from “Last, First”Two-digit birth yearEmail lower-casedPlaceholder values cleared
CLM-405445CLMCynthia E Tucker1999-11-04UHC-62111-7198895904288513 Baseline Rd, Plano, TX, 750650.68Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
CLM-416420CLMBryan Rogers1943-10-08UHC-70108-52——0.68Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed
CLM-417188CLMJulia L Jackson2004-09-26UHC-87854-0994741765126367 Oak St, Orlando, FL, 328000.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-427959CLMKyle Wislon1956-10-22UHC-49295-41—834 Oak St, Nashville, TN0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-408792CLMAngela Moreno1953-07-10——5173 Broadway, Atlanta, GA, 303570.68Name split from “Last, First”State code upper-casedZIP+4 trimmedPlaceholder values cleared
CLM-401150CLMAlbert Wods1954-07-09—90565575201380 Harbor Blvd # 374, Denver, CO, 802130.68Two-digit birth yearPhone reformattedUnit split from streetPlaceholder values cleared
CLM-400784CLMDebra Bishop1953-03-26UHC-74782-9431579430236435 Pine Dr, Orlando, FL, 328360.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-422466CLMJoshua Brown1941-01-13UHC-44263-868452489238—0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-411708CLMFraances Fox1960-03-25UHC-10054-324206977770—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-413847CLMCerl N Cooper1961-11-02UHC-39164-1459525177347817 Maple Ave, Denver, CO, 802940.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-424623CLMBradley Morgan1948-01-20UHC-42385-27—6148 Cedar Ln, Atlanta, GA, 303590.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-403236CLMRichard Luna1986-01-18UHC-69234-20——0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-422710CLMJenny Fisheer1979-08-18UHC-09837-45——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-415032CLMBrandon Masun1943-03-06UHC-06018-395088505003—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-423764CLMMargaret P Stevens1981-12-12UHC-74068-29—7419 Baseline Rd, Atlanta, GA, 303830.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-414861CLMNancy Rojas1999-06-09UHC-90304-33—6782 Pine Dr, Houston, TX, 770650.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-414862CLMNancy Rojas1999-06-09UHC-90304-33—6782 Pine Dr, Houston, TX, 770650.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
CLM-408330CLMBecky Wilson1982-12-21UHC-50574-7182630802613284 Valley View Dr, San Antonio, TX0.68Two-digit birth yearZIP missingEmail lower-casedWhitespace trimmed
CLM-432400CLMRonald Cox1994-08-04UHC-07390-48—1782 Camelback Rd, Scottsdale, AZ, 852310.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-409828CLMRoger Lewis1952-04-16UHC-89460-83—9404 Highland Ave, Miami, FL, 331150.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
CLM-423570CLMBenjamin Duncan1957-04-07UHC-06987-44—1120 Sage Ct, Gilbert, AZ, 852990.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-406311CLMChristine W Griffin1997-12-12UHC-79067-60—6866 Mesa Dr, Gilbert, AZ, 852430.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-413713CLMSamantha T Diaz1998-08-23UHC-92123-72—1859 Meadow Ln, Tucson, AZ, 857890.68Phone missing area codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-422992CLMBrittany Alexander1988-01-14UHC-44945-33—7028 Lincoln Way, Glendale, AZ, 853610.68Name split from “Last, First”City re-casedZIP+4 trimmedPlaceholder values cleared
CLM-425767CLMLuis S Kelley1998-05-21UHC-64251-59—4043 Spring St, Las Vegas, NV, 891280.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-425467CLMMariana Patel1956-02-11UHC-03136-3961092515832743 Apache Blvd, Gilbert, AZ0.68Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed
CLM-425172CLMBrenda Curz2006-05-16UHC-82459-61—2625 Sunset Blvd, Plano, TX, 750870.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
32,829 rows, page 200 of 657PreviousNext