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-428770CLMSandra Bradley1970-05-25—7829315135216 Lake View Rd, Denver, CO0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411057CLMDoris E Yang1968-12-03UHC-09369-7922824482213736 Pine Dr Apt 39, Phoenix, AZ, 850140.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-411056CLMDoris E Yang1968-12-03UHC-09369-7922824482213736 Pine Dr Apt 39, Phoenix, AZ, 850140.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-417248CLMRussell Guerrero1975-09-04—3544674783675 Mountain View Dr, Tucson, AZ, 857020.64Name split from “Last, First”Date of birth reformattedCity re-casedZIP+4 trimmed+2 more
CLM-408068CLMMary Hunter1948-03-07—75725565149548 Palm Dr, Plano, TX, 750010.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403448CLMMateo Johnson1986-09-05UHC-24566-34—9534 Spring St, San Diego, CA, 921840.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407349CLMGeorge K Murphy1998-10-14UHC-12080-519648052507707 Apache Blvd, Sacramento, CA, 958980.64Name split from “Last, First”Phone reformattedState name converted to codePlan code upper-cased+2 more
CLM-426855CLMLarry Singh2004-07-15UHC-55360-97—3589 Main St, Los Angeles, CA, 900360.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414334CLMMariana Parker2008-11-14UHC-18863-5286764212349046 Church St, Gilbert, AZ, 852240.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400467CLMWayne Carpenter1993-02-01——6771 Bayshore Dr, Eden Prairie, MN, 553750.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-422222CLMHeather Munoz1971-02-03UHC-96240-4032966546942548 Washington St, Orlando, FL, 328240.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422731CLMBenjamin Fuller1964-03-15UHC-11971-67—4702 Spring St, Nashville, TN, 372370.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-422732CLMBenjamin Fuller1964-03-15UHC-11971-67—4702 Spring St, Nashville, TN, 372370.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-421589CLMAndrea Bennett1946-05-13UHC-64984-58—241 Spring St, Jacksonville, FL, 322920.64Name re-casedTwo-digit birth yearMember ID reformattedState code upper-cased+2 more
CLM-432629CLMMargaret B Vasquez1962-10-26UHC-19632-97—7899 Church St, Scottsdale, AZ, 852940.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-426913CLMSusan Morrison1959-02-28UHC-92801-47—2746 Apache Blvd, Denver, CO, 802520.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400175CLMAnthony Maldonado1958-06-17UHC-57454-9888162984597136 Sage Ct, Dallas, TX, 752460.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422450CLMDylan Carpenter2001-05-19—59427347181683 Desert Sky Blvd, Jacksonville, FL, 322450.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424212CLMPeter V Harris1990-09-28UHC-53556-75—7620 Highland Ave, Fresno, CA, 937170.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402881CLMEugene Tran1985-09-05UHC-63592-24—7045 Forest Ave, Las Vegas, NV, 891850.64Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
CLM-401281CLMCharlotte Guzman1985-05-17UHC-77788-73—9180 Oak St, Miami, FL0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-429200CLMMacus Turnar1939-12-12UHC-68746-15—7122 Sage Ct, Phoenix, AZ, 850480.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401762CLMBradley Gilbert2001-03-25—38550379595498 Church St # 592, Jacksonville, FL, 322090.64Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
CLM-409189CLMAnna Hall2001-04-04UHC-10415-23—1680 Jefferson Ave, Miami, FL, 331140.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423566CLMAlbeert Lynch1960-04-25UHC-64593-1334388714751108 Maple Ave, Seattle, WA, 981430.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426504CLMJordan Walker1988-02-19UHC-96381-0425245092373465 Union St, Columbus, OH, 432910.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416545CLMChristopher Adams1945-11-23UHC-52332-699377433810301 Church St, Denver, CO, 802720.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-410001CLMPriya McDonald2007-08-25——5470 Market St, Tucson, AZ, 857080.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-429606CLMKimberly Hayes1991-10-13UHC-03076-95—1773 Ocean Ave, Columbus, OH0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427034CLMLuis Snyder1956-03-26UHC-14530-18—350 Maple Ave, Mesa, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-417007CLMMadison Taylor1957-06-12—88177844554368 Sage Ct, Sacramento, CA, 958470.64Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-404032CLMKyle Simpson2007-04-15—7722251125621 Palm Dr, Plano, TX, 750920.64Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
CLM-431894CLMYuki Harvey1957-05-01——4883 Oak St, Sacramento, CA, 958990.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429310CLMBruce Fox1979-09-06UHC-44206-81—4844 Cedar Ln, Austin, TX, 787440.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
CLM-414004CLMSamuel Berry1941-01-06UHC-82531-52—9512 Indian School Rd, Tampa, FL, 336570.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-430227CLMAisha Gray1983-12-18——8462 Main St, Minneapolis, MN0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423660CLMGloria Wilsson1984-11-23UHC-54456-13—4217 River Rd, Austin, TX, 787850.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-423027CLMSamantha F Valdez1950-02-09UHC-09139-9729960512626880 Park Pl, Glendale, AZ, 853620.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425805CLMScott P Sullivan———4342 Mesa Dr, San Diego, CA, 921150.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-430821CLMKim Wang1988-01-05UHC-99271-57—935 Jefferson Ave, Sacramento, CA, 958090.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423440CLMJacob Harvey1991-02-10UHC-30103-8034221327519345 Main St Apt 38, San Diego, CA, 921680.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418964CLMWei Greene1945-01-21—961386304263 Lincoln Way, Jacksonville, FL0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428785CLMChristina Dominguez1985-09-15UHC-80528-85—949 Pine Dr, Dallas, TX, 752510.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-401592CLMKathryn Schmidt1956-10-09UHC-18595-46—5650 Pine Dr, Tucson, AZ, 857140.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400057CLMLara Hamilton1956-01-17—20470512897386 River Rd, Las Vegas, NV, 891910.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-402383CLMHeather Boyd1954-10-26UHC-21223-18—4167 Ridge Rd, Minneapolis, MN, 554920.64Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised+2 more
CLM-425777CLMLnida Butler—UHC-41974-427433734203735 Apache Blvd, Atlanta, GA, 303680.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-400201CLMRoger Ortiz1970-12-19——7441 Bayshore Dr, Minneapolis, MN, 554110.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423475CLMWalter Hudson1939-11-17—95470872697989 Lake View Rd, Houston, TX, 770530.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
CLM-416745CLMLisa Reid—UHC-20648-68—4559 Apache Blvd, Las Vegas, NV, 891200.64Date of birth unreadableStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
32,829 rows, page 123 of 657PreviousNext