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-402007CLMPatricia Knight2007-09-18UHC-45826-06—3958 River Rd, Chandler, AZ, 852170.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418206CLMDylan C Reed2005-08-19UHC-39800-7531574499194465 Desert Sky Blvd, Austin, TX, 787350.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-419128CLMEthan G Wood1959-11-23UHC-70586-1454390062352316 Washington St, Austin, TX, 787530.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-419588CLMKaren R Stewart——3985202442—0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-424559CLMKimberly Austin1982-01-28—59467328691515 Maple Ave, Nashville, TN, 372910.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-422994CLMBetty G Gomez1977-06-09UHC-79259-25—347 Main St, Tampa, FL0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
CLM-431208CLMSamanta Burton1966-06-09—96769263983599 Church St, Gilbert, AZ, 852860.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-427969CLMHannah Bell1960-01-21UHC-89444-279192858875—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-426685CLMNicole U Lee1974-01-26UHC-13335-65—7184 Hillcrest Rd, Dallas, TX, 752690.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408398CLMAhmed Wagner1981-01-01UHC-20384-48—212 Bayshore Dr, Seattle, WA, 981210.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411930CLMJose Oliver1951-03-24UHC-66497-2137384560782340 Church St, Glendale, AZ, 853860.68Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-401041CLMAna E Barnes1955-12-26UHC-78790-02—8964 Mesa Dr, Eden Prairie, MN, 553570.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-429710CLMRobert Walker1988-05-09UHC-76321-6567182624071063 Mesa Dr, San Antonio, TX, 782490.68Phone reformattedStreet suffix standardisedAddress re-casedGender normalised
CLM-408537CLMJohn Reyes2004-01-07UHC-52250-13—1791 Elm St, Tempe, AZ, 852530.68Two-digit birth yearZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-430760CLMPaul Aguilar1977-02-06UHC-80837-0783480620361823 Willow Ct, Denver, CO, 802650.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-423557CLMSean N Davis1949-06-01UHC-58231-30—1123 Indian School Rd Apt 7, Dallas, TX, 752920.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409191CLMJerry Rojas1995-09-22——4528 Maple Ave, Mesa, AZ, 852930.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-409192CLMJerry Rojas1995-09-22——4528 Maple Ave, Mesa, AZ, 852930.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-426153CLMTyler Webb1969-11-25UHC-69644-36—9487 River Rd, Mesa, AZ, 852120.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-429220CLMAisha Larson1949-09-22——3250 Broadway, Eden Prairie, MN0.68SSN last four extractedZIP missingWhitespace trimmedPlaceholder values cleared
CLM-405361CLMSantiago Day1998-05-03UHC-69311-39—9850 Church St, Las Vegas, NV, 891310.68Two-digit birth yearMember ID reformattedSSN last four extractedPlaceholder values cleared
CLM-417570CLMLucia Hernandez2003-08-05UHC-88709-1229660763261139 Mountain View Dr, Seattle, WA, 981460.68Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased
CLM-420082CLMLuis Kelley2000-06-18UHC-29471-9153295001632091 Pine Dr, Eden Prairie, MN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-410733CLMCarolyn Taylor1999-12-28UHC-94825-21—3614 Jefferson Ave, Houston, TX, 770070.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-411112CLMAlbert T Burton1982-06-17UHC-66153-7458636074609508 Mesa Dr, Denver, CO, 802770.68Middle initial moved out of first namePhone reformattedGender normalisedPlaceholder values cleared
CLM-413706CLMBeverly Ruiz1972-02-15——159 Church St, Tempe, AZ, 852890.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-411165CLMKevin L Soto1955-12-09——3195 Meadow Ln, San Antonio, TX, 782610.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-423341CLMRobert Watkins2001-07-07UHC-29270-37——0.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-421922CLMTheresa Henry1991-12-11——8184 Meadow Ln Apt 13, San Diego, CA, 921750.68Unit split from streetZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-427681CLMKaren Carr2004-09-19UHC-18067-47—3110 Ocean Ave, Las Vegas, NV, 891510.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-427725CLMAlbert C Delgado1939-08-14———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421251CLMAshley R Peters1941-04-21UHC-83509-19—6353 Canyon Rd, Columbus, OH, 432150.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-431094CLMElijah Owens1953-05-21UHC-18979-40—8030 Cedar Ln Apt 30, Mesa, AZ, 852780.68Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-417008CLMCharles Porter2004-04-09UHC-37973-20—9313 Forest Ave, Sacramento, CA, 958290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-413506CLMStephen X Hansen1939-05-11UHC-67426-32—8089 Pine Dr, Fresno, CA, 937390.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-407779CLMJaon Grant1946-01-06UHC-51451-9158959815457783 Indian School Rd, Denver, CO, 802930.68Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-427870CLMCheryl Peterson1958-03-10UHC-22463-54—8368 Hillcrest Rd, Denver, CO, 802720.68Name re-casedTwo-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-410060CLMYuki F Meyer1950-06-01UHC-39552-52——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-428870CLMWalter Carlson1955-10-26UHC-39159-1942954065492773 Mountain View Dr, Phoenix, AZ, 850670.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-401190CLMSofia Yang1962-03-20—81959653007983 Maple Ave # 887, Denver, CO, 802100.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-424140CLMSofia Walker1997-10-01——3784 Oak St, Mesa, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-416574CLMEthan Welch1949-09-13UHC-59122-39—1962 Mesa Dr, San Antonio, TX, 782210.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-409573CLMHeathar Welch1979-04-06UHC-33964-1520820196064656 Pine Dr, Fresno, CA, 937900.68Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-409572CLMHeathar Welch1979-04-06UHC-33964-1520820196064656 Pine Dr, Fresno, CA, 937900.68Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-429443CLMMegan Luna1962-09-26UHC-51148-57—5143 Hillcrest Rd, Scottsdale, AZ, 852590.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-409876CLMJason Guerrero1949-07-19UHC-14738-35——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-428965CLMCheryl Parker2003-03-02——6087 Lincoln Way, Nashville, TN, 372700.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-426339CLMEugene C Grant1972-01-10——680 Sage Ct, Chandler, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-411647CLMJonathan Ortega1993-09-14UHC-09877-57—8757 Desert Sky Blvd, Mesa, AZ, 852070.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-430071CLMLawrence Hoffman1971-02-10UHC-12016-65——0.68Two-digit birth yearMember ID reformattedGender normalisedPlaceholder values cleared
32,829 rows, page 215 of 657PreviousNext