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-432000CLMRalph Mejia1955-01-02UHC-24782-4738453637829551 Willow Ct, Dallas, TX, 752280.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-403706CLMAndrea W Riley1963-04-24UHC-09555-54—5837 Willow Ct, Los Angeles, CA, 900420.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429059CLMArjun Hudson1999-04-14——4237 Sunset Blvd Apt 20, Gilbert, AZ0.64Name re-casedDate of birth reformattedUnit split from streetZIP missing+2 more
CLM-429963CLMBetty Q Sandoval1944-09-25——1080 Desert Sky Blvd, Dallas, TX, 752270.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-415392CLMMariana Valdeez1982-11-22—91426667281961 Apache Blvd, Dallas, TX, 752670.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424394CLMMariana Stewart1984-05-09UHC-55215-31—4958 Indian School Rd, Houston, TX, 770560.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-409585CLMKeith Schultz1939-09-09UHC-01231-4052943729749249 Sage Ct, Denver, CO, 802190.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418032CLMJluie M Salazar1945-11-07UHC-75947-6845682535077977 Forest Ave, Sacramento, CA0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-429362CLMKenneth S Ray1965-07-14UHC-87282-2567748135269330 Cedar Ln, Orlando, FL, 328260.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428971CLMCynthia Weber1989-03-13UHC-51670-82—4461 Pine Dr Apt 35, Tampa, FL, 336450.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-427685CLMJesse Peterson1963-11-24——3424 Maple Ave, Los Angeles, CA, 900980.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-411255CLMGabriel Gray2001-08-25UHC-14318-7233881530328384 Lincoln Way, Gilbert, AZ, 852570.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431432CLMBilly G Romero—UHC-55739-85—4647 Sunset Blvd, Gilbert, AZ, 852470.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-404751CLMNicole Bowman1978-12-16——3795 Lincoln Way, Tampa, FL, 336830.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-426421CLMMark Holmes1985-06-05UHC-10666-9865769900259633 River Rd, Houston, TX, 770890.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405873CLMNancy Stephens—UHC-48987-0166599312655003 Pine Dr, San Diego, CA, 921490.64Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+2 more
CLM-430180CLMCaroyln I Li1943-09-13UHC-24165-9350944476902737 Lake View Rd, Minneapolis, MN, 554790.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429556CLMAlexis Elliott1987-05-15—20899791461711 Canyon Rd, Tempe, AZ, 852600.64Date of birth reformattedPhone reformattedSSN last four extractedState name converted to code+2 more
CLM-415070CLMKarne Roberts1944-08-03UHC-49232-31—3071 Cedar Ln Apt 3, San Diego, CA, 921600.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-422083CLMDebbie Estrada1999-08-03UHC-32114-78—7018 Market St, Denver, CO0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426804CLMHannah Chavez1968-07-28——2210 Park Pl, Glendale, AZ, 853140.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-412360CLMJanice Hanson1966-12-14——5303 Willow Ct Apt 9, Tempe, AZ, 852710.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-423925CLMMarcus Fuller1967-12-11——9406 Indian School Rd, Scottsdale, AZ, 852910.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-431357CLMJudith G Schultz1988-05-25——3026 Ocean Ave, Seattle, WA, 981770.64Middle initial moved out of first nameName re-casedCity re-casedState name converted to code+2 more
CLM-407147CLMKathleen Obrien1953-02-15UHC-76854-65—6948 Pine Dr, Columbus, OH, 432940.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-430896CLMValentina Reid1965-04-06——4462 Lake View Rd, Phoenix, AZ, 850290.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-429103CLMWalter Gomez1945-05-22UHC-83989-3759069430612117 Camelback Rd, Chandler, AZ, 852990.64Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+2 more
CLM-402042CLMJoyce Fernandez1987-07-11UHC-59485-5031183079095478 Ocean Ave, Plano, TX, 750180.64SSN last four extractedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-409075CLMGrace Alexander1967-07-01UHC-60724-18—9454 Desert Sky Blvd, Columbus, OH, 432790.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415498CLMMaria Vazquez1954-10-10UHC-60301-52—891 Canyon Rd, Los Angeles, CA, 900420.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429171CLMTeersa Sims1970-02-08UHC-19809-9974965425729686 Indian School Rd, Los Angeles, CA, 900420.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424311CLMNathan Payne1974-09-14UHC-93464-6540999565498774 Canyon Rd, San Antonio, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418956CLMVincent Le1947-02-13—92028983591141 Ocean Ave, Tempe, AZ, 852190.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423203CLMSam Adams1960-07-20UHC-62298-66—2770 Canyon Rd, Columbus, OH, 432260.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424802CLMIsabella Collins1984-04-07——8033 Lincoln Way, San Antonio, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-404231CLMRuth McDonald1968-03-04——9368 Market St, Sacramento, CA, 958760.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408811CLMVincent G Ruiz1997-09-22UHC-15528-604182214963—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+2 more
CLM-420105CLMAshley Park1984-03-25UHC-77999-99—5422 Meadow Ln, Miami, FL, 331290.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429748CLMBradley Santiago1976-02-23UHC-26632-77—7766 Ridge Rd, San Antonio, TX, 782310.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-404638CLMAlan Branes1945-08-27UHC-40814-16—9322 Indian School Rd, Phoenix, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-425881CLMBobby Nichols1989-09-18UHC-85627-10—4382 Sunset Blvd, Miami, FL, 331640.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413931CLMNathan Y Ryan1996-09-17UHC-40820-53—8757 Desert Sky Blvd, Denver, CO, 802730.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-431776CLMMegan Moore2002-11-06——640 Maple Ave, Seattle, WA, 981300.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-422249CLMGabriel Bradley1946-03-05UHC-00034-62—1795 Church St, Fresno, CA, 937420.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428305CLMJerry I Perkins1988-01-07—80975552629878 Desert Sky Blvd, Atlanta, GA, 303800.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428306CLMJerry I Perkins1988-01-07—80975552629878 Desert Sky Blvd, Atlanta, GA, 303800.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411943CLMCynthia P Elliott1961-02-13——8657 Mountain View Dr, San Diego, CA, 921720.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-412035CLMYuki Hunter1998-10-08UHC-43336-98—730 Forest Ave, Fresno, CA, 937800.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416327CLMTheresa Herrera1945-04-08UHC-63529-87—4862 Indian School Rd, Tempe, AZ, 852430.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417439CLMSamuel Rodriguez1957-12-02UHC-96426-2938020152769608 Meadow Ln, Plano, TX, 750180.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
32,829 rows, page 136 of 657PreviousNext