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-406580CLMDenise Perkins2003-07-02UHC-99174-55—6478 Meadow Ln, Jacksonville, FL, 322910.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402059CLMAlexander Carlson1940-06-07UHC-21277-9385226951695227 Ridge Rd, Fresno, CA, 937420.66Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
CLM-409277CLMSamuel Harrison1979-07-20UHC-41931-54—2689 Mountain View Dr, Charlotte, NC, 282470.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-432384CLMGary F Santos1957-03-08UHC-60618-102328547760947 Grand Ave, Miami, FL, 331680.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-412276CLMSimpson Catherine1979-08-26—55381248072256 Oak St, Tempe, AZ, 852700.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
CLM-416361CLMBetty Rodriguez———9758 Forest Ave, Houston, TX, 770370.66Date of birth missingStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431846CLMRuth Hudson1966-02-12——6660 Market St, Eden Prairie, MN, 553840.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-416019CLMFatima Butler1972-06-01—58881606335607 Church St Apt 24, Charlotte, NC, 282030.66Two-digit birth yearUnit split from streetState code upper-casedWhitespace trimmed+1 more
CLM-416020CLMFatima Butler1972-06-01—58881606335607 Church St Apt 24, Charlotte, NC, 282030.66Two-digit birth yearUnit split from streetState code upper-casedWhitespace trimmed+1 more
CLM-405023CLMWille Colle1985-09-21—50266216781476 Sunset Blvd, Nashville, TN, 372960.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-409225CLMValentina Moore1979-09-23UHC-89782-29—6292 Meadow Ln, Austin, TX, 787110.66Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-428582CLMMelissa Valdez1958-04-10——1948 Lincoln Way, Fresno, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-416054CLMBrenda Harpre1940-05-15——7291 Ocean Ave, Mesa, AZ, 852540.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419518CLMKaren Padilla1999-05-28—27739309138532 Forest Ave, Tucson, AZ, 857400.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411843CLMPatrick Le2007-07-13UHC-86550-3078136291885819 Washington St, Gilbert, AZ, 852330.66Phone reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-431729CLMKevin Q Washington2008-09-28UHC-24205-78—7626 Ridge Rd, Plano, TX, 750460.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-400266CLMCharlotte Ortiz2002-10-16—45944797627944 Canyon Rd, Columbus, OH, 432390.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413784CLMGerald Scott1942-08-24UHC-63185-93—8050 Washington St, Chandler, AZ, 852810.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-401552CLMJesse T Jorddan1968-10-10UHC-91740-18—9252 Indian School Rd, Austin, TX, 787610.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-428845CLMHenry Q Harrisno1986-07-18UHC-33101-68—7019 Washington St, Chandler, AZ, 852340.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-408664CLMMary George1953-01-20UHC-99908-37——0.66Name re-casedSSN last four extractedGender normalisedWhitespace trimmed+1 more
CLM-418563CLMSean Adams1968-12-24—83576269256127 Indian School Rd, Los Angeles, CA, 900010.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-420445CLMPatricia Vazquez1967-02-22——4205 Market St, Houston, TX, 770980.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-415294CLMLucia Schmidt1955-03-08——6822 Church St, Glendale, AZ, 853720.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-426265CLMCamla Green1991-08-15UHC-53157-96—8860 Willow Ct, Phoenix, AZ, 850670.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408319CLMRaymond McDonald1965-06-24——8053 Broadway, San Antonio, TX, 782930.66Name split from “Last, First”Date of birth reformattedPhone missing area codeWhitespace trimmed+1 more
CLM-418692CLMMartha Warren—UHC-61710-65—3383 Lake View Rd, Scottsdale, AZ, 852390.66Name re-casedDate of birth unreadableZIP+4 trimmedWhitespace trimmed+1 more
CLM-408587CLMJoshua D Gordon1983-11-03UHC-19807-30—7170 Willow Ct, Sacramento, CA, 958170.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
CLM-431177CLMStephen Robertson1974-04-26UHC-28049-09—4568 Canyon Rd, Fresno, CA, 937350.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-419760CLMMei Moreno———4287 Mountain View Dr, Denver, CO, 802860.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
CLM-420796CLMAaron Pierce1942-09-19——7423 Park Pl Apt 12, Houston, TX0.66Name re-casedDate of birth reformattedUnit split from streetZIP missing+1 more
CLM-420085CLMBetty Vega1946-04-04——1690 Bayshore Dr, Columbus, OH, 432480.66Name re-casedTwo-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
CLM-403269CLMJoe Hunter1947-03-27——1811 Canyon Rd Apt 11, Los Angeles, CA, 900020.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-415909CLMAlexis Reynolds1988-03-04——5890 Harbor Blvd, Glendale, AZ, 853870.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-431436CLMDennis Y Bryant1960-10-25——9389 Central Ave, Plano, TX, 750800.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-419536CLMMariana V Porter2006-09-19UHC-17545-7186935844066954 Pine Dr, Phoenix, AZ, 850820.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-420643CLMSarah Schmidt1965-01-28—46082070298051 Willow Ct, San Diego, CA, 921660.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411297CLMSantiago Gray1979-02-26UHC-93351-32—4158 Spring St, Dallas, TX, 752410.66Two-digit birth yearMember ID reformattedCity re-casedGender normalised+1 more
CLM-409405CLMOlivia Campbell1986-10-04——5315 Indian School Rd, Glendale, AZ, 853190.66Name re-casedPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-421484CLMNoah S Torres1979-09-16——2460 Grand Ave, Eden Prairie, MN0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-410087CLMHelen Guzman——4839340028939 Meadow Ln, Minneapolis, MN, 554160.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412649CLMJanet J Young———3328 Oak St, Nashville, TN, 372800.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-414931CLMAbby Phillips1964-04-10UHC-38548-43—6592 Baseline Rd, San Antonio, TX, 782110.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-424640CLMMary Reed1955-06-18UHC-36246-28—4582 Mesa Dr, Phoenix, AZ, 850660.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-420936CLMJudith Stoo1995-03-06UHC-74540-847712855888580 Jefferson Ave Apt 22, San Antonio, TX, 782240.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-427337CLMKelly Tucker1999-01-03UHC-00488-72—4186 Central Ave, Chandler, AZ, 852190.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-427264CLMRobert Singh1975-01-16UHC-01396-37—6850 Baseline Rd, Nashville, TN0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-419569CLMDebra Kelley1975-12-19UHC-04884-3645221116021550 Sage Ct, San Antonio, TX, 782540.66Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412809CLMSantiago A Wong1969-01-19UHC-35346-7768552420334049 Washington St, Houston, TX, 770810.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-413657CLMFrances Hayes1985-11-06UHC-79363-7979848061818483 Ridge Rd, Sacramento, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
32,829 rows, page 185 of 657PreviousNext