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-413399CLMEthan Cook2003-03-18UHC-76119-12—9366 Mesa Dr, Tucson, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-412645CLMMaria Carr1943-07-21UHC-71401-03—5483 Church St, Phoenix, AZ, 850020.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-400979CLMCamila J Rogers2004-02-15——811 Hillcrest Rd, Miami, FL, 331030.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-431053CLMDean Andrew1946-06-15UHC-73405-81—1670 Mesa Dr, Tucson, AZ0.66City re-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-421385CLMNguyen G Diane1961-03-10——3744 Ocean Ave, Orlando, FL, 328130.66Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+1 more
CLM-412089CLMPatricia Kim1998-05-23UHC-30627-19—3503 Elm St, Columbus, OH, 432510.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415534CLMKathryn Dunn2003-01-17UHC-91234-3975893259666922 Park Pl, Denver, CO, 802610.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-406659CLMJoyce P Perry1972-09-08UHC-51288-35—6984 Pine Dr, Los Angeles, CA, 900090.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-404552CLMFrank Green1974-04-24UHC-08081-74—7013 Desert Sky Blvd, Miami, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-400906CLMAdam Walsh1956-08-01—67562200016706 Lincoln Way, Denver, CO, 802210.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413409CLMBradley Martinez1998-05-14——7736 Pine Dr, Columbus, OH, 432370.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-424006CLMJordan Stewart1958-08-17UHC-47141-7346260141498097 Main St, Glendale, AZ, 853160.66Name split from “Last, First”Two-digit birth yearState code upper-casedWhitespace trimmed+1 more
CLM-429448CLMChristina Garcai1969-02-11UHC-73700-7543367488127938 Church St, Houston, TX0.66Phone reformattedMember ID reformattedState name converted to codeZIP missing+1 more
CLM-427939CLMChrristina Fields1958-04-19UHC-16525-7644681599145141 Grand Ave, Austin, TX, 787170.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-410083CLMPriya Aguilar2000-10-24UHC-54958-1466523041596298 Pine Dr, San Diego, CA0.66Name split from “Last, First”Phone reformattedZIP missingWhitespace trimmed+1 more
CLM-407164CLMLogan Lane1953-01-13UHC-29585-43—8325 River Rd, San Antonio, TX, 782640.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-418217CLMJason Mrphy1996-09-21——239 Church St, Nashville, TN, 372530.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-403355CLMWayne Sims1991-12-07UHC-57695-21—4120 Pine Dr, Columbus, OH, 432230.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419418CLMPat Padilla———4600 Ridge Rd, Tampa, FL, 336310.66Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-413157CLMZachary Morales1995-08-08——9060 Washington St Apt 24, Tampa, FL, 336560.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-425456CLMEdward Reyes2004-09-24UHC-07461-95—8191 Pine Dr, Denver, CO, 802040.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-414300CLMMaria A Kim1946-06-22UHC-55425-51—1529 Market St, Tempe, AZ, 852330.66Name re-casedPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-404295CLMCarlos Gray1941-08-12UHC-64484-7372863151968227 Grand Ave, San Diego, CA, 921460.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-406210CLMKathryn Ramirez1944-05-02——9294 Park Pl # 734, Gilbert, AZ, 852810.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402959CLMKaren G White1986-12-06UHC-50270-0596056629019809 Ridge Rd, Jacksonville, FL0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-418894CLMAisha Morrison2006-04-13UHC-15863-8535597352083540 Maple Ave # 540, Houston, TX, 770810.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-423499CLMJordan Meyer1946-01-10UHC-72377-28—2555 Valley View Dr # 970, Los Angeles, CA, 900600.66Name re-casedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-418150CLMSantiago Q Warren1976-10-01UHC-97597-12—542 Harbor Blvd, Mesa, AZ, 852480.66Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-410138CLMSamuel Tucker1993-06-19UHC-53744-2826897169615881 Apache Blvd, Chandler, AZ, 852240.66Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
CLM-401223CLMKaren Morgan1965-04-19UHC-24048-52—5824 Highland Ave, Minneapolis, MN0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-416172CLMArjun Torres1986-04-21UHC-50680-83—4920 Cedar Ln, Orlando, FL, 328050.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420101CLMDouglas Perry1943-05-20UHC-88700-98—9386 Mesa Dr, Tampa, FL, 336420.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-432140CLMRgoer S Wang1950-02-04—52873107095745 Jefferson Ave, Charlotte, NC, 282710.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-409621CLMJoan Garrett1950-03-20UHC-30737-0243695670989201 Cedar Ln, Austin, TX, 787500.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-406152CLMDonna Diaz1997-08-21UHC-14269-08—1140 Elm St, Miami, FL, 331150.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414043CLMStephen Lawson1974-09-03——5405 Valley View Dr, Denver, CO, 802440.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-417743CLMBryyan Simmons———67 Bayshore Dr, Atlanta, GA, 303640.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-402112CLMDaniel W Lawrence1978-07-10—87266984998162 Spring St, Plano, TX0.66Phone reformattedSSN last four extractedZIP missingWhitespace trimmed+1 more
CLM-403573CLMSandra Harper1946-09-10—80124660037685 Jefferson Ave, Denver, CO, 802120.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400170CLMPaul Washington1978-03-11UHC-15231-478166778754951 Washington St, Houston, TX, 770020.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-432383CLMNicole Ortega2004-03-20UHC-23371-21—2244 Maple Ave, Fresno, CA0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-423025CLMSantiago Allen—UHC-39555-75—2932 Ocean Ave, Nashville, TN, 372130.66Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-402319CLMAlan Rice1989-01-27——4973 Church St, Tucson, AZ, 857210.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-410970CLMBryan Reynolds1958-08-23UHC-54408-06—1616 Desert Sky Blvd, Glendale, AZ, 853760.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-411529CLMNancy Willis1990-11-10UHC-80349-4992588121407572 Bayshore Dr, Los Angeles, CA, 900790.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-418379CLMRebecca Fuller1939-08-19UHC-58010-49—3291 Valley View Dr, Las Vegas, NV0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-432273CLMRichard Bishoop1948-01-13UHC-11474-5961273400114532 Jefferson Ave, San Antonio, TX, 782560.66Name re-casedDate of birth reformattedSSN last four extractedZIP+4 trimmed+1 more
CLM-418831CLMJose Richards1995-02-10—75590583422591 Ocean Ave, Los Angeles, CA, 900660.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428630CLMEthan Chavez1951-07-01UHC-43527-1251183176882576 Central Ave, Tempe, AZ0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-402395CLMRandy Harrison1985-11-20——5559 Sage Ct, Chandler, AZ, 852260.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
32,829 rows, page 173 of 657PreviousNext