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-419240CLMDanielle Brooks—UHC-25272-645736317541533 Maple Ave, Scottsdale, AZ, 852530.68Name re-casedDate of birth unreadablePhone reformattedGender normalised
CLM-424487CLMSamuel Simmons1945-05-25UHC-47169-69—519 Grand Ave, Orlando, FL, 328850.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-426460CLMCynthia D Cralson1997-07-15———0.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-415048CLMDanielle A Ramirez1966-02-11UHC-72750-1375991782178031 Spring St, Miami, FL, 331070.68Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed
CLM-402523CLMDannis Lopez1962-10-07UHC-83888-95—2194 Church St, Seattle, WA, 981060.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-424456CLMMaason Kelley1980-09-23UHC-70526-07—176 Lake View Rd, Charlotte, NC, 282240.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-431322CLMBradley Silva2006-03-08—80558831957257 Broadway, Mesa, AZ, 852350.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
CLM-400419CLMAmanda Jensen1965-12-05UHC-53230-53—4743 Park Pl, Columbus, OH, 432200.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-413378CLMJesse Richards1969-03-05UHC-63467-7470831781571959 Lincoln Way, Las Vegas, NV, 891350.68Two-digit birth yearPhone reformattedZIP+4 trimmedPlaceholder values cleared
CLM-414662CLMSue Carr2004-06-19——8577 Spring St # 711, Charlotte, NC, 282630.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400874CLMTimohy Kelly1989-07-01UHC-36460-96—2193 Mountain View Dr, Seattle, WA, 981320.68Name re-casedTwo-digit birth yearSSN last four extractedPlaceholder values cleared
CLM-412923CLMTimothy Rice1947-03-03UHC-83864-45—4346 River Rd, Plano, TX, 750950.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-430737CLMDorothy Hansen1951-06-26UHC-58649-64—5235 Willow Ct, Gilbert, AZ, 852430.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-429263CLMNicholas Carr1989-07-01UHC-93074-69—9452 Indian School Rd, Tucson, AZ, 857420.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-422501CLMRyan Brooks1985-04-09UHC-19949-87—9135 Hillcrest Rd, Jacksonville, FL0.68Date of birth reformattedState name converted to codeZIP missingWhitespace trimmed
CLM-412959CLMScott U Jordan1965-02-17UHC-14875-5553575792107935 Desert Sky Blvd, Fresno, CA, 937440.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-421104CLMLaura White1957-09-20UHC-39998-25—693 Lincoln Way, Houston, TX, 770070.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-403836CLMMark Brown1952-05-07UHC-62184-34—1243 Meadow Ln, Mesa, AZ, 852480.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422328CLMMei Garcia1988-12-13——1271 Lake View Rd, Phoenix, AZ, 850240.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-427753CLMNancy Myers1999-06-15UHC-26902-60—1604 Sunset Blvd, Austin, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-402682CLMAlan Jacobs1988-10-28UHC-31939-59—7390 Desert Sky Blvd # 755, Eden Prairie, MN, 553880.68Unit split from streetState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-413351CLMLogan Gibson1999-08-16UHC-61944-97—1387 Lake View Rd, Miami, FL, 331270.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-431985CLMMatthew Greene1950-01-01UHC-91766-10——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-420756CLMJacob Maldonado1996-07-26UHC-78781-64—4546 Ridge Rd Apt 30, San Diego, CA, 921210.68Name split from “Last, First”Date of birth reformattedUnit split from streetPlaceholder values cleared
CLM-404705CLMSean Z Marquez1972-11-08—25591823104151 Market St, Charlotte, NC, 282950.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-428159CLMLogan Larson1944-04-19—98668874576157 Forest Ave, Phoenix, AZ, 850530.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-432736CLMRichard Lucas1947-06-12UHC-24488-26—6760 Hillcrest Rd, Las Vegas, NV, 891430.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404106CLMEmily X Jenkins2001-03-17—84364949797216 Canyon Rd # 969, Austin, TX, 787000.68Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased
CLM-424431CLMBrittany Arnold1976-06-20UHC-79114-26—2061 Apache Blvd, Nashville, TN, 372540.68Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed
CLM-432226CLMNicole Coleman1951-12-17—56754480714557 Ridge Rd, Scottsdale, AZ, 852340.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-424489CLMEugene Aguilar1957-12-24——869 Lincoln Way, Orlando, FL0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-409640CLMWillie P Hoffman1963-05-05——5145 Mesa Dr # 694, Denver, CO, 802410.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428438CLMTyler X Meyer1964-04-20UHC-06884-65——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-401455CLMAisha Allen1938-10-20——6490 Baseline Rd, Minneapolis, MN0.68Name re-casedState name converted to codeZIP missingPlaceholder values cleared
CLM-405081CLMSofia Fuller1956-08-14——9744 Cedar Ln # 821, Tucson, AZ, 857840.68Name split from “Last, First”Date of birth reformattedUnit split from streetPlaceholder values cleared
CLM-409467CLMSara E Boyd1944-07-08UHC-17819-97—6365 Sage Ct # 465, Scottsdale, AZ, 852810.68Unit split from streetEmail lower-casedGender normalisedPlaceholder values cleared
CLM-414168CLMJessica Wang2003-01-20UHC-04085-61—5652 Meadow Ln, Sacramento, CA0.68Name re-casedState name converted to codeZIP missingPlaceholder values cleared
CLM-402754CLMLawrence Bakns2004-04-05UHC-87347-98—6645 Ocean Ave, Orlando, FL, 328240.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-405118CLMMaria T Ortega—UHC-21435-18—5472 Oak St, Austin, TX, 787140.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422529CLMCarl H Hunter1979-11-24UHC-03931-77—8315 Mesa Dr, Tempe, AZ, 852480.68Name re-casedSSN last four extractedState name converted to codePlaceholder values cleared
CLM-414614CLMBeverly Collins1978-09-17—31134394332916 Park Pl, Scottsdale, AZ, 852330.68Name re-casedStreet suffix standardisedAddress re-casedState name converted to code
CLM-400824CLMAdam Sone1969-12-25——7730 Church St, Seattle, WA, 981040.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-410037CLMJoan Y Clark1967-11-09——3163 Grand Ave, Atlanta, GA, 303080.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-421365CLMLori Santiago1993-02-12UHC-83318-5448784889713583 Hillcrest Rd, Tempe, AZ, 852060.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-415477CLMJeffrey Gardner1959-02-16UHC-08046-17—9517 Highland Ave, Tampa, FL, 336710.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-426285CLMFances Morgan1953-04-15UHC-23380-8172260055927262 Park Pl, Plano, TX, 750390.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-401851CLMJacob Holmes———9299 Apache Blvd, Austin, TX, 787640.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-431169CLMTheresa Bradley1954-11-05——8604 Forest Ave, Sacramento, CA, 958100.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430214CLMAustin Millar2000-11-16UHC-05857-13—1627 Church St, Minneapolis, MN, 554760.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404081CLMAna Fuller1978-10-18UHC-64825-97—9872 Spring St, Phoenix, AZ, 850420.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
32,829 rows, page 203 of 657PreviousNext