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-406433CLMPhilip Bradley1945-06-28UHC-47879-82—2457 Hillcrest Rd, Minneapolis, MN0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-422630CLMHeenry Espinoza1955-08-15UHC-50850-98—1526 Spring St, Tucson, AZ0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-402990CLMGary Cook1970-06-01UHC-97450-5656153351226769 Central Ave, Las Vegas, NV, 891480.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-432289CLMCheryl X Johnson1973-02-07UHC-75959-53—101 Palm Dr, Sacramento, CA, 958210.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-403094CLMAnn O Adams—UHC-49487-8994766135654774 Broadway # 640, Scottsdale, AZ, 852440.54Name split from “Last, First”Date of birth unreadablePhone reformattedUnit split from street+1 more
CLM-418412CLMJudy D Soto1981-01-26——9496 Ridge Rd, Glendale, AZ, 853220.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409514CLM—Junk1945-06-27UHC-74702-5973949978413460 Forest Ave, Minneapolis, MN, 554480.54Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared+1 more
CLM-426256CLMMarc K Matthews1990-03-08UHC-28870-27—4840 Market St, Austin, TX, 787550.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405145CLMAlexis Q Ramirez1964-04-18——7736 Ocean Ave, Gilbert, AZ, 852570.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-405144CLMAlexis Q Ramirez1964-04-18——7736 Ocean Ave, Gilbert, AZ, 852570.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-428220CLMAustin Welch1963-04-23UHC-09700-72—278 Palm Dr # 115, Gilbert, AZ, 852770.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-424139CLMSofia Walker1998-10-01——3784 Oak St # 275, Mesa, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-407705CLMJohn Bradley1973-03-13UHC-80398-485965673213349 River Rd, Chandler, AZ, 852660.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-431133CLMNancy Ryos1977-12-11UHC-76965-35—9570 Broadway Apt 21, Scottsdale, AZ, 852940.54Date of birth reformattedUnit split from streetAddress re-casedZIP+4 trimmed+1 more
CLM-400302CLMLauren Davis—UHC-98479-3653430283544206 Baseline Rd Apt 26, Scottsdale, AZ, 852640.54Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-403747CLMCynthia Castro1988-10-16—855699014965 Camelback Rd # 440, Denver, CO, 802070.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-417038CLMWalter F Bayley—UHC-39646-96—9810 Market St, Houston, TX, 770090.54Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-421869CLMBrenda Grant1962-10-21—74891825439067 Baseline Rd Apt 40, Sacramento, CA, 958820.54Name split from “Last, First”Date of birth reformattedUnit split from streetZIP+4 trimmed+1 more
CLM-409622CLMLarry Moore1979-07-17——399 Sage Ct, Sacramento, CA, 958080.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422409CLMIsabella Lopez1960-01-05UHC-82562-05—3478 Bayshore Dr, Seattle, WA, 981940.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-416754CLMMark Sandoval2006-03-22UHC-24042-47—6181 Mountain View Dr, Houston, TX, 770480.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-422180CLMEvelyn X Graham1968-03-17——551 Washington St, Sacramento, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-422024CLMRyan I Edwards2000-05-08UHC-79280-23—638 Church St, Gilbert, AZ, 852600.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-417727CLMLogan Yang1967-09-12——219 Lincoln Way # 494, San Antonio, TX, 782170.54Name split from “Last, First”Two-digit birth yearUnit split from streetWhitespace trimmed+1 more
CLM-403238CLMRichard Luna1986-01-18UHC-69234-20—2149 Mesa Dr, Jacksonville, FL, 322670.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-427581CLMRalph K Peterson1995-08-04UHC-53260-0545885719841958 Market St, Sacramento, CA, 958830.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-414646CLMWlliam Powell1973-01-13UHC-92775-0345547921341719 Ridge Rd, Eden Prairie, MN, 553370.54Two-digit birth yearPhone reformattedState name converted to codeGender normalised+1 more
CLM-415530CLMRaymond Martinez1964-07-23UHC-76339-68——0.54Name re-casedTwo-digit birth yearPhone missing area codeGender normalised+1 more
CLM-400440CLMJuen Castro1979-08-01——3550 Sunset Blvd, San Antonio, TX, 782610.54Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-410770CLMAbigail C Johnston2002-06-09——5319 Meadow Ln, Dallas, TX, 752350.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-429451CLMMason Hawkins1943-07-07UHC-57852-17—6154 Palm Dr # 459, Tempe, AZ, 852380.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413647CLMJanet Dunn—UHC-23650-03—7704 Lake View Rd, Nashville, TN, 372280.54Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
CLM-427532CLMChristian Meyer2007-04-25—48345538182940 Indian School Rd # 324, Dallas, TX, 752160.54Two-digit birth yearPhone reformattedUnit split from streetGender normalised+1 more
CLM-420047CLMSamuel Alvarez1939-10-18UHC-86926-4356754115577856 Highland Ave # 429, Columbus, OH, 432820.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-432502CLMLori Roberts1948-04-24—54536822583853 Hillcrest Rd, Tempe, AZ, 852530.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-402456CLMPhilip Marshall1939-03-28UHC-88317-89—7863 Washington St, Phoenix, AZ, 850830.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-406693CLMLauren Stevens—UHC-56668-5537732831812878 Canyon Rd, Phoenix, AZ0.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412063CLMBradley Armstrong1938-01-22——9526 Park Pl, Minneapolis, MN, 554290.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-429511CLMJula Lucas1981-07-20——504 Sunset Blvd, Minneapolis, MN, 554470.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-415665CLMMei Hunt1946-12-20UHC-84600-88—7787 Baseline Rd Apt 20, Phoenix, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-415666CLMMei Hunt1946-12-20UHC-84600-88—7787 Baseline Rd Apt 20, Phoenix, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-401049CLMChristina Singh1972-07-12UHC-36281-66—1049 Harbor Blvd, Tempe, AZ0.54State name converted to codeZIP missingGender normalisedWhitespace trimmed+1 more
CLM-401048CLMChristina Singh1972-07-12UHC-36281-66—1049 Harbor Blvd, Tempe, AZ0.54State name converted to codeZIP missingGender normalisedWhitespace trimmed+1 more
CLM-424035CLMJohn Moreno1973-04-20UHC-62742-88—6704 Apache Blvd, Sacramento, CA, 958600.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-411492CLMGerald Marquez1943-05-27——7247 Valley View Dr, Tempe, AZ0.54Name re-casedTwo-digit birth yearZIP missingGender normalised+1 more
CLM-414217CLMHelen Graham1985-11-14—93081344177493 Park Pl, Miami, FL, 331370.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-404232CLMBillyJunk1956-08-02UHC-22233-15—9181 Mountain View Dr, Phoenix, AZ, 850540.54Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared+1 more
CLM-404707CLMYuki X Espinoza1951-06-16—2243679502387 Harbor Blvd, Charlotte, NC, 282060.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-431186CLMEvelyn Herrera1951-07-16UHC-76171-21—5146 Baseline Rd, Jacksonville, FL0.54Two-digit birth yearCity re-casedZIP missingGender normalised+1 more
CLM-409273CLMJustin Morgan1956-06-21UHC-81951-04—4401 Desert Sky Blvd, Tempe, AZ, 852330.54Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+1 more
32,829 rows, page 55 of 657PreviousNext