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-404390CLMJoe M Flores1977-12-18UHC-45040-71—8481 River Rd, Plano, TX, 750080.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416779CLMAdam Li1945-01-18UHC-03793-43378254689451 Oak St # 934, Houston, TX, 770500.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-427578CLMDane Ortega2003-07-13——913 Valley View Dr, Chandler, AZ, 852330.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419371CLMMateo A Nichols——38525897398569 Sunset Blvd, Miami, FL, 331830.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430449CLMLucia Hicks1969-08-25UHC-33115-56—9284 Bayshore Dr, San Antonio, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411967CLMBrian Hoffman1965-06-22——3389 Baseline Rd, Gilbert, AZ, 852450.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412653CLMCharlotte Fox1978-03-10UHC-60940-57—657 Jefferson Ave Apt 31, San Antonio, TX, 782010.64Date of birth reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
CLM-406701CLMKeith Dixon2004-11-24UHC-14813-19—8405 Meadow Ln, Las Vegas, NV, 891760.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-403896CLMJoyce Sanchez1955-04-11UHC-08012-6559366632599217 Ocean Ave # 387, Austin, TX, 787490.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426594CLMKeith Dixon1996-03-02—62581338146543 Indian School Rd, Mesa, AZ, 852040.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412897CLMGregory Delgado1968-04-21——4695 Lincoln Way, Austin, TX, 787420.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-413508CLMJoyce Z Hanson1949-10-10—70998527277845 Jefferson Ave, Mesa, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405354CLMLawrence Hamilton1949-01-17UHC-23883-35—8701 Sunset Blvd, Sacramento, CA, 958810.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-427660CLMMason Hamilton1988-11-25—80454349953651 Ocean Ave, Gilbert, AZ, 852690.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429647CLMKennneth Cox1953-06-17—32163879043484 Maple Ave, Glendale, AZ, 853310.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414653CLMWatkins Jacob1948-01-23UHC-84596-8098252317421221 Church St, Fresno, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421651CLMMrk Washington2006-12-27——8968 Willow Ct, Miami, FL, 331730.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-417286CLMMicheelle Walker2003-08-05UHC-17580-1430158388487539 Bayshore Dr, Jacksonville, FL, 322590.64Phone reformattedCity re-casedState name converted to codeGender normalised+2 more
CLM-406631CLMLori Q Lane2006-03-28——5174 Church St Apt 34, Atlanta, GA, 303920.64Unit split from streetStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-413924CLMJessica Perez1997-02-15UHC-75199-96—9284 Willow Ct, Dallas, TX, 752770.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-406821CLMMelissa Fox1979-01-22UHC-13839-3548487367452330 Ridge Rd, Fresno, CA, 937440.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428366CLMJonathan Brooks1999-03-02UHC-27135-67—4731 Sunset Blvd, Los Angeles, CA, 900890.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424764CLMMartha I Knight1949-02-09UHC-46240-42—9616 Valley View Dr, Denver, CO, 802760.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403520CLMMarcus Nichols2004-08-26—77887494687644 Ridge Rd, Minneapolis, MN, 554610.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404481CLMWillie Johnson1938-10-17UHC-36023-3796185830131333 Indian School Rd, Seattle, WA, 981690.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430005CLMYuki F Vasquez1976-10-23UHC-11306-0858136351946384 Willow Ct, Denver, CO, 802170.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-421777CLMDennis Y Morris—UHC-83204-1050934294081592 Cedar Ln, Seattle, WA, 981620.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411435CLMAndrew Edwards1957-06-19UHC-43496-8246924882956231 Bayshore Dr, Glendale, AZ0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-411434CLMAndrew Edwards1957-06-19UHC-43496-8246924882956231 Bayshore Dr, Glendale, AZ0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-424754CLMScott Singh2006-10-16—7792045030—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
CLM-430970CLMSharon Webb1974-10-26UHC-86487-27—6290 Cedar Ln, Denver, CO, 802690.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-408070CLMJames O Rodriguez2001-03-20UHC-66449-14204963259344 Meadow Ln, Charlotte, NC, 282890.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415871CLMJose Black1963-09-14UHC-66821-16—4276 Cedar Ln, Fresno, CA, 937070.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417854CLMLori Patel2001-10-19UHC-75874-0837994116194018 Indian School Rd, Orlando, FL, 328120.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413528CLMValentina Q Baker1998-03-24——1465 Apache Blvd, Scottsdale, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403594CLMHarold Adams——94891536942472 Spring St, Atlanta, GA, 303960.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413166CLMLogan A Phillips1966-04-21—46091964793710 Mountain View Dr, Orlando, FL, 328510.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431509CLMLisa Castro1991-01-19UHC-96067-72—4502 Lake View Rd Apt 29, San Diego, CA, 921180.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431510CLMLisa Castro1991-01-19UHC-96067-72—4502 Lake View Rd Apt 29, San Diego, CA, 921180.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-430696CLMRachel Wagner1981-04-09UHC-43793-67—8428 Indian School Rd, Austin, TX, 787490.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-418810CLMAlice Vazquez1939-02-06UHC-55168-96—9804 Indian School Rd, Seattle, WA, 981830.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401979CLMBobby Cooper1940-02-01UHC-01816-03—9529 Hillcrest Rd, Gilbert, AZ, 852860.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-417825CLMVirginia Hart1980-05-04UHC-92459-2059295848642284 Central Ave, Glendale, AZ, 853150.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426202CLMBarbara Dunn2007-01-04UHC-34994-98—8620 Cedar Ln, Miami, FL, 331980.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-431746CLMLauren Jones1990-08-01UHC-47493-6091433269515472 Mountain View Dr, Sacramento, CA, 958490.64Name re-casedPhone reformattedSSN last four extractedGender normalised+2 more
CLM-404908CLMKathryn Carpenter1943-01-12UHC-20206-20—9041 Palm Dr Apt 18, Gilbert, AZ, 852160.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432092CLMSam Fuller1941-11-24—24570971604633 Cedar Ln, Charlotte, NC, 282220.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407396CLMArthur A Lucas1954-04-24UHC-21109-1765174133449504 River Rd, Atlanta, GA, 303000.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423410CLMNicole Shaw1945-12-13UHC-95009-8598942689578639 Indian School Rd, Gilbert, AZ, 852960.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411433CLMHarold Nguyen1994-06-13UHC-06434-7532922915178987 Central Ave, Los Angeles, CA, 900500.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 109 of 657PreviousNext