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-431374CLMRoger Contreras1975-05-15UHC-06935-9083274970892705 Indian School Rd, San Diego, CA, 921230.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-408535CLMKathleen Matthews1998-02-01——5746 Church St, Fresno, CA, 937310.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421075CLMAdams Madisun1984-01-18UHC-70742-0548363347005739 Oak St, Gilbert, AZ, 852580.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
CLM-422502CLMLauren Powell1999-02-04UHC-87679-57—126 Harbor Blvd, Eden Prairie, MN, 553530.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-418908CLMCheryl Wells2002-03-22UHC-16740-0168157124784094 Apache Blvd, Los Angeles, CA, 900850.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414005CLMDonna Ortega1970-05-14UHC-71161-86—7419 Church St, Glendale, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-400866CLMZachary George1999-07-23UHC-99695-66—4326 Sage Ct Apt 16, Austin, TX, 787840.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-413940CLMAlbert Marshall1991-07-04UHC-01330-32—8011 Maple Ave, Plano, TX, 750580.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412583CLMRichard Simmons1979-11-13UHC-95902-92—7176 Market St, Houston, TX, 770500.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422800CLMKye Freeman1958-03-26UHC-61797-7860897367411330 Jefferson Ave, Tucson, AZ, 857550.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-403935CLMFrances Ross1996-02-24UHC-77600-96—1901 Sage Ct, Jacksonville, FL, 322660.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-407260CLMLucia Woods1976-07-17—81297989053667 Grand Ave, Jacksonville, FL, 322120.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-410171CLMLauren Gutierrez1989-01-04—85458829559548 Broadway, Orlando, FL, 328310.66Two-digit birth yearPhone reformattedAddress re-casedState name converted to code+1 more
CLM-428474CLMHarold Sanders2006-04-26——498 Park Pl, Sacramento, CA, 958130.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425853CLMDougas Sims1987-01-18UHC-75923-1765545365885046 Indian School Rd, Gilbert, AZ, 852520.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-418612CLMDouglas F Day1946-08-13UHC-15264-54—3209 Washington St, Orlando, FL, 328140.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-409645CLMCarol N Howell1942-02-16UHC-35472-3443359362427900 Mesa Dr, Glendale, AZ, 853400.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
CLM-432133CLMMaria W Welch1950-04-01UHC-40855-94—5189 Camelback Rd # 798, Jacksonville, FL, 322540.66Member ID reformattedUnit split from streetCity re-casedGender normalised+1 more
CLM-416029CLMLuri Gibson1960-08-15—81742595758161 Ridge Rd, Austin, TX, 787150.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430215CLMTimothy Castillo1982-04-22UHC-63334-7256993404856656 Hillcrest Rd # 707, Scottsdale, AZ, 852800.66Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+1 more
CLM-417717CLMJordan Brooks1968-03-04UHC-43996-98—6544 Mesa Dr, Chandler, AZ, 852150.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-428244CLMJacqueline West1985-05-28——9211 Park Pl, Fresno, CA, 937020.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-423159CLMRyan U Soto2002-11-11—33737175028891 Union St, Tempe, AZ, 852330.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429012CLMNathan Santiago1943-12-11UHC-27681-55—2615 Lake View Rd, Tucson, AZ, 857790.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-401844CLMMadisno Wood1998-01-25UHC-82152-4090478808237666 Sunset Blvd, Minneapolis, MN0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-414935CLMTyler Gray2005-10-24UHC-40253-8871079610233159 Harbor Blvd, Glendale, AZ, 853260.66Name re-casedSSN last four extractedGender normalisedWhitespace trimmed+1 more
CLM-406086CLMBrandon Hyll1984-07-26UHC-22856-42—9744 Maple Ave, Scottsdale, AZ, 852230.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411552CLMDanielle M Tucker1953-06-27UHC-36926-50—3682 Central Ave, Gilbert, AZ, 852890.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-412579CLMShirley Sanchez1948-12-12——5839 Apache Blvd, Fresno, CA0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-429122CLMAmy Morrison1977-02-06UHC-29243-33—4055 Palm Dr, Austin, TX, 787940.66Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
CLM-421572CLMPaamela Scott2003-06-02UHC-72353-9439439443815921 Harbor Blvd, Tucson, AZ, 857610.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-413156CLMZachary Morales1995-08-08UHC-95210-09—9060 Washington St Apt 37, Tampa, FL, 336560.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-407351CLMNicholsa Romero1978-12-26——5771 Harbor Blvd, Denver, CO, 802150.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-420664CLMThomas Scott1970-07-24—71347475622385 Park Pl, Eden Prairie, MN, 553740.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-421606CLMJoseph Lucas1988-09-18——8962 Main St, Tempe, AZ, 852590.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-414517CLMKimberly Z Cooper1983-09-12——9356 Central Ave, Sacramento, CA, 958650.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422627CLMTimothy Wheeler1939-02-03UHC-43507-18—3238 Jefferson Ave, San Antonio, TX, 782390.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-427965CLMJeffrey B Hunter1974-07-13UHC-42787-34—3234 Sage Ct, San Diego, CA, 921760.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-402083CLMPeter Walker1985-04-18UHC-17729-51—5541 Palm Dr, Glendale, AZ, 853860.66Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised+1 more
CLM-420288CLMCatherine Wong1986-10-01UHC-29121-3533065241655747 Grand Ave, Jacksonville, FL, 322630.66Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+1 more
CLM-417368CLMSusan Bishop1972-05-10UHC-19257-2554355859952549 Jefferson Ave, Los Angeles, CA, 900730.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-415404CLMJean Young1940-05-22UHC-88826-0637843748778587 Hillcrest Rd, Las Vegas, NV, 891100.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-423209CLMSean Webb2001-10-08UHC-33759-1281021798803689 Willow Ct, Tucson, AZ, 857680.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-417660CLMLauren Scott2001-02-27UHC-72511-1927748870114131 Central Ave, San Antonio, TX, 782350.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-422374CLMJessica Sanchez1948-01-19UHC-54681-25—2365 Mountain View Dr, Sacramento, CA, 958880.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-418470CLMMadison I McCoy1979-04-23UHC-54920-7374180681867606 Camelback Rd, Jacksonville, FL, 322680.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-413725CLMJennifer Padilla2000-05-19UHC-67801-3871491391188500 Park Pl, San Antonio, TX, 782890.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-416555CLMChristine N Stewart1946-01-03UHC-62819-226954879216—0.66Name split from “Last, First”Email lower-casedGender normalisedWhitespace trimmed+1 more
CLM-419282CLMBrittany D Fuller1964-06-05UHC-60596-7239439589417598 Grand Ave, Orlando, FL, 328170.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-407431CLMStepen Montgomery1965-05-01UHC-38299-58—535 Maple Ave, Fresno, CA, 937690.66SSN last four extractedStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
32,829 rows, page 177 of 657PreviousNext