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-431434CLMSusan Welch1983-01-10UHC-59072-4396381510446930 Cedar Ln Apt 40, Minneapolis, MN, 554640.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414539CLMBoobby L Carroll1998-09-03UHC-56827-6045961408928355 Palm Dr, Chandler, AZ, 852540.62Name re-casedDate of birth reformattedPhone reformattedState name converted to code+3 more
CLM-410700CLMBrandon Q Armstrong1959-11-13——2641 Apache Blvd, Denver, CO0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-426627CLMJennifer Cox1939-01-08UHC-06372-33—9324 Baseline Rd, Glendale, AZ, 853740.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
CLM-413061CLMJoshua Stone1977-08-07UHC-36434-3374152937549296 Jefferson Ave, Plano, TX, 750960.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402760CLMJames Ortiz1965-01-02——78 Willow Ct, Houston, TX, 770430.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412144CLMDoris Guerrero1951-01-14UHC-32145-61—1029 Spring St, Las Vegas, NV, 891470.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-419237CLMSamuel K Daniels1987-06-15UHC-88956-842857256352423 Ocean Ave, Seattle, WA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428846CLMKelly Contreras2004-02-22UHC-37940-69—6369 Maple Ave, Eden Prairie, MN, 553460.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-417737CLMWayne Castro1950-09-06—81499129852524 Baseline Rd, Sacramento, CA, 958620.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415610CLMSam Y Boyd1976-11-27UHC-62289-2039344409469801 Jefferson Ave, Tucson, AZ, 857910.62Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-412717CLMJustin Wilson1974-03-27——5123 Camelback Rd, Plano, TX, 750010.62Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-423709CLMWillie Griffin1973-05-18UHC-28365-715478550900458 Sage Ct, Phoenix, AZ, 850560.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407550CLMJanice G Rojes2005-10-21UHC-88398-8323179123516773 Washington St, Denver, CO, 802900.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407549CLMJanice G Rojes2005-10-21UHC-88398-8323179123516773 Washington St, Denver, CO, 802900.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417232CLMMariana Taylor2005-04-02UHC-39730-4620367795964501 Spring St, Orlando, FL, 328760.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-428652CLMCharles Williams1971-09-12—48826028436059 Washington St # 538, Atlanta, GA, 303810.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-431249CLMWilliam Oliver1951-01-11UHC-98569-6524929068039799 Pine Dr, Tampa, FL, 336240.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429107CLMJohn Wood1997-05-03—57459861442081 Spring St, Columbus, OH, 432960.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406124CLMReid Teresa1988-07-24UHC-23512-0461663251397882 Market St, Nashville, TN0.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-422274CLMJames Hanson1984-11-23—62225284626778 Ocean Ave, Miami, FL0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418759CLMGary Vega1996-03-01UHC-43920-25—6269 Canyon Rd # 245, Denver, CO, 802770.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-418996CLMAnthuny Weber1986-11-02—43072457351777 River Rd, Mesa, AZ, 852770.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403466CLMArthur Gibson1996-10-28UHC-76549-1973052643478100 Maple Ave, San Antonio, TX0.62Name re-casedPhone reformattedMember ID reformattedState name converted to code+3 more
CLM-426233CLMRussell J Holmes1969-07-10—41138583486297 Sage Ct, Atlanta, GA0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423831CLMJustin Ryan1974-11-04UHC-83356-98—1898 Camelback Rd, Plano, TX, 750180.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427010CLMJoe Dean2007-12-13—58984122831160 Desert Sky Blvd, Austin, TX, 787500.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401187CLMJoe Crawford1977-07-08UHC-55441-33—1032 Sunset Blvd, Denver, CO, 802180.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401186CLMJoe Crawford1977-07-08UHC-55441-33—1032 Sunset Blvd, Denver, CO, 802180.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412148CLMRoger O Bishop1958-03-26UHC-15509-76—695 Canyon Rd, Austin, TX, 787980.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424837CLMBrittany B Jenkins1951-09-02UHC-52134-9655961333252783 Apache Blvd, Jacksonville, FL, 322610.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403611CLMJoseph Cunningham1939-09-10—9199684150979 Bayshore Dr, Minneapolis, MN, 554950.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408258CLMWalteer Weber1988-01-16——3286 Hillcrest Rd, Dallas, TX, 752900.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-408199CLMTheresa P Torres1990-03-18UHC-55258-87—4431 Highland Ave # 930, San Antonio, TX, 782020.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-423141CLMVirginia Boyd2006-01-27—28786545807938 Harbor Blvd, San Antonio, TX, 782390.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-411545CLMMaria Snyder1966-05-27UHC-84820-9784487808965805 Mountain View Dr # 934, Denver, CO, 802550.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425022CLMAustin Bennett1948-10-24—23182733587038 Mesa Dr, Gilbert, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403285CLMJudith Gilbert———7478 Market St, Austin, TX, 787150.62Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-419868CLMSanitago Farnklin1961-12-08UHC-54865-20—8471 Cedar Ln, Scottsdale, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-404129CLMCheryl Simmons2002-12-17UHC-92867-01—3156 Baseline Rd, Sacramento, CA, 958960.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-404027CLMJeffrey Padilla1977-04-04UHC-92939-82—7220 Main St, Tampa, FL, 336390.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-418777CLMRichard Hicks1987-02-15——6440 River Rd Apt 15, Eden Prairie, MN, 553210.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-419021CLMJulia Rose1943-06-25—67744621274918 Church St Apt 25, Denver, CO, 802810.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-405681CLMGrace Kennedy1952-02-07UHC-94262-16—3820 Indian School Rd, Fresno, CA0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432010CLMLisa Knight2000-08-02UHC-55792-79—2320 Palm Dr, Dallas, TX, 752150.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412542CLMDebra Powell1945-02-07—79481012994358 Forest Ave, Tampa, FL, 336220.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402880CLMDiego A Valdez1962-04-06—5768453658315 Palm Dr, Tucson, AZ, 857990.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427896CLMAaron Knight1983-07-13UHC-95721-0952462276558293 Spring St, Nashville, TN, 372190.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426329CLMOlivia Alvarado1999-06-28UHC-69185-073887701580374 Forest Ave, Minneapolis, MN, 554170.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409187CLMAlexander Pena1965-11-10UHC-14599-26—9573 Indian School Rd, Minneapolis, MN0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
32,829 rows, page 102 of 657PreviousNext