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-419881CLMElizabeth Dunn2003-09-28——6988 Mesa Dr, Seattle, WA, 981970.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-409116CLMEugene Edwards2006-06-04—97553098433717 Mesa Dr, Plano, TX, 750780.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400868CLMCatherine Ford—UHC-79361-303644097615975 Main St, Gilbert, AZ, 852870.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416442CLMCynthia Brooks1971-07-03——9713 Park Pl, Minneapolis, MN, 554100.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-406193CLMFatima R Perkins1992-04-14UHC-00138-756414426679107 Central Ave, Jacksonville, FL, 322100.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-418339CLMAaron Torres2005-10-11——6393 Mountain View Dr, Minneapolis, MN, 554680.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430008CLMJacqueline Hansen1998-02-28——7272 Forest Ave, Minneapolis, MN, 554370.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427253CLMCarolyn L Smith1946-04-21UHC-59178-5396134354548220 Ocean Ave, Jacksonville, FL, 322190.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410527CLMJoan Wheeler1996-12-21——1955 Park Pl, Fresno, CA, 937290.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-406981CLMCarlos Maldonado1954-08-02UHC-50356-95—2025 Valley View Dr, Columbus, OH, 432570.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-402164CLMBrenda Campbell2004-07-04UHC-47470-5856792857129082 Lincoln Way, Houston, TX, 770280.64Name split from “Last, First”Phone reformattedMember ID reformattedGender normalised+2 more
CLM-402109CLMEmily Adams2000-07-22—46663486589365 Sage Ct, Orlando, FL, 328230.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426422CLMAlan Ryan1940-06-15UHC-68642-08—5901 Grand Ave, San Diego, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-401060CLMCharles Hunter1989-06-08UHC-17944-9052387368585023 Elm St, Tempe, AZ, 852670.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421347CLMBenjamin Dean1952-07-17——2589 Church St, Dallas, TX, 752780.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418286CLMRyan Soto1994-04-04UHC-95153-7250527102803892 Hillcrest Rd, Seattle, WA, 981580.64Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-418842CLMCharles Ramos1960-11-01UHC-32017-7067742393705609 Camelback Rd Apt 23, Glendale, AZ, 853090.64Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+2 more
CLM-406832CLMPhilpi Woods2001-02-24—98771773268935 Valley View Dr, Eden Prairie, MN, 553200.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428888CLMAmber Sandoval1965-06-05UHC-51743-96—6060 Sunset Blvd, Fresno, CA, 937640.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-405382CLMArjun Bradley1959-04-16—74195737641459 Ocean Ave, Dallas, TX0.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-418501CLMKeith N Simpson2007-11-19UHC-20710-22—6732 Church St, Fresno, CA, 937760.64Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
CLM-419034CLMBarbara Espinoza1953-03-07UHC-74131-0292742972741702 Lincoln Way, Jacksonville, FL, 322140.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419062CLMSamuel Salazar1980-09-13—46665355338284 Harbor Blvd # 317, Sacramento, CA, 958510.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-428901CLMBarbara Weber—UHC-24739-99—4863 Ocean Ave, Eden Prairie, MN, 553360.64Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+2 more
CLM-400927CLMPriya Chen1999-03-03UHC-87411-86—6678 Ridge Rd, Nashville, TN, 372620.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416460CLMJonathan H Mason1958-03-06UHC-16686-90—8561 Mesa Dr, Minneapolis, MN, 554670.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-411385CLMNathan Gutierrez1996-06-12UHC-41662-035735190216834 Pine Dr, Scottsdale, AZ, 852750.64Date of birth reformattedPhone reformattedState name converted to codeGender normalised+2 more
CLM-429830CLMBrandon Valdez1941-03-13UHC-15383-3579153895606227 Apache Blvd, Denver, CO0.64Name re-casedPhone reformattedZIP missingGender normalised+2 more
CLM-423721CLMOmar Sanchez2007-08-22UHC-70219-0931823030921184 Pine Dr # 247, Austin, TX, 787970.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-432643CLMHiroshi Peterson1947-08-28—37438638176875 Apache Blvd, Gilbert, AZ, 852340.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-404237CLMEvelyn Gomez1964-11-10UHC-57767-40—9527 Broadway Apt 25, Orlando, FL, 328760.64Name re-casedUnit split from streetState code upper-casedGender normalised+2 more
CLM-413253CLMJason Larson1960-12-28—79582669921155 Broadway, Mesa, AZ, 852030.64Name re-casedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-431891CLMBeverly Singh1958-07-28UHC-78091-79—8154 Sunset Blvd, Seattle, WA, 981320.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-414407CLMGeorge Torres1964-05-20UHC-42020-09—4804 Market St, Mesa, AZ, 852670.64Name re-casedDate of birth reformattedCity re-casedState name converted to code+2 more
CLM-418591CLMArjun Ward1958-02-24UHC-59588-89—5039 Washington St, Minneapolis, MN, 554490.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-405773CLMJack V Armstrong1966-07-16UHC-92872-2425775599699598 Oak St, Atlanta, GA, 303560.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-410384CLMMark Patterson1976-09-13——6095 Desert Sky Blvd, Denver, CO, 802890.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411013CLMGloria D Gordon1952-09-04——9544 Camelback Rd, Orlando, FL, 328490.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-414772CLMWillie McCoy1994-10-23UHC-22083-4487598473591428 Cedar Ln # 597, Fresno, CA, 937810.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-423609CLMChristian McCoy1971-12-15UHC-69126-94—3749 Park Pl, Los Angeles, CA, 900760.64Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404001CLMArjun Ray1963-03-12UHC-68947-52—5602 Camelback Rd, Atlanta, GA, 303050.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414197CLMKathryn A Ortiz1976-06-15—80230728302638 Indian School Rd, Austin, TX, 787770.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-422416CLMGary Espinoza1941-02-25UHC-09582-4442346650721967 Union St, Scottsdale, AZ, 852370.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424306CLMMorrison Wei1956-07-26UHC-11160-3395468318725478 Canyon Rd, Plano, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427336CLMKelly O Tucker1999-01-03UHC-00488-72—4186 Central Ave, Chandler, AZ, 852190.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-427335CLMKelly O Tucker1999-01-03UHC-00488-72—4186 Central Ave, Chandler, AZ, 852190.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-427790CLMPaul E Schmidt1957-07-26UHC-33818-80—6695 Washington St, Nashville, TN, 372290.64Name re-casedDate of birth reformattedState name converted to codeGender normalised+2 more
CLM-430890CLMChris Yang1961-08-27UHC-11124-73—6043 Church St, Chandler, AZ, 852890.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-431812CLMLucia Robertson1985-09-01UHC-90498-9859931454054263 Cedar Ln, Tempe, AZ, 852890.64Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+2 more
CLM-427816CLMTeresa Z Coleman2005-06-26UHC-01517-2781494498455737 Maple Ave, Phoenix, AZ, 850290.64Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+2 more
32,829 rows, page 151 of 657PreviousNext