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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-118511ENRPaul Gilbert1952-08-21UHC-18539-67—6577 Ridge Rd, Houston, TX, 770480.48Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-402761CLMLidna Oliver—UHC-29977-4422944386931038 Sunset Blvd, Eden Prairie, MN, 553750.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-410098CLMJames Cox1982-11-25UHC-14257-05—5562 Indian School Rd # 204, Denver, CO, 802540.48Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
ENR-100033ENRVincent L Oliver1973-05-14UHC-16577-4074764225646938 Apache Blvd, San Diego, CA, 921610.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
CLM-411351CLMGerald Bowman1991-02-02——8942 Desert Sky Blvd, Glendale, AZ, 853720.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-411610CLMLawrence Weaver1964-02-04UHC-26133-9892921200243519 Church St, Tempe, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-113479ENRVincent G Chapman2001-08-26UHC-05422-137213594201694 Lake View Rd, Tampa, FL, 336090.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408546CLMRobert Lewis1985-04-22UHC-37733-01—2513 Valley View Dr, Charlotte, NC, 282100.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55277TPAAlbert Butler2008-06-20—87169099984427 Jefferson Ave, Tempe, AZ, 852380.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
CLM-426624CLMDiana Hunt1949-07-28UHC-91212-74—5404 Hillcrest Rd, Jacksonville, FL, 322070.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129174ENRLucia C Wood1946-04-20UHC-62547-5932367001492088 Indian School Rd, Los Angeles, CA0.48Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
CLM-430447CLMArthur X Hell—UHC-60721-0392682535218579 Camelback Rd, Chandler, AZ, 852450.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-415564CLMLori Roberts—UHC-78605-17—9741 Canyon Rd, Houston, TX, 770710.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
CLM-426634CLMBarbara Cooper1993-09-17—49274285261440 Forest Ave, Tempe, AZ, 852450.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-60917TPAElizabeth Jones1996-02-25——9833 Oak St, Los Angeles, CA, 900870.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-20577PRVEmma L Maldonado1941-04-20UHC-15232-8956597164063063 Desert Sky Blvd, Gilbert, AZ, 852210.48Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+4 more
ENR-128036ENRCarlos M Hughes1955-05-05UHC-29904-363896114765516 Sunset Blvd Apt 37, Plano, TX, 750470.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-24679PRVFatima Moreno1957-07-16UHC-24101-2575822916477442 Oak St Apt 36, Denver, CO, 802540.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-143072ENRValentina E Garrett—UHC-90419-9291287591116804 Ocean Ave, Plano, TX, 750130.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-127481ENRNoah J Mendez1984-04-12UHC-58028-4927993121407772 Ridge Rd, Glendale, AZ0.48Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-136190ENRJoe C Day1948-02-19UHC-72292-7935889862996135 Apache Blvd, Miami, FL, 331330.48Middle initial moved out of first namePhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-141661ENRWilliam T Rodriguez1993-05-23UHC-66982-3724774206272554 Market St, Columbus, OH, 432960.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-26627PRVAmandaJunk1938-02-27—9336832337879 Sunset Blvd, Houston, TX, 770270.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62447TPABrandon Collins1981-07-08—33052091221704 Desert Sky Blvd, Tampa, FL0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117107ENRJudy Stevens1962-08-11UHC-82487-2040196889173652 Palm Dr, Los Angeles, CA, 900410.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-118684ENRBradley L Henry2003-04-13UHC-31206-7164060039777362 Park Pl # 878, Chandler, AZ, 852940.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-119674ENRTyer S Torrees2002-11-05UHC-22537-4483894130039062 Oak St, Tampa, FL, 336730.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23343PRVKeith Wells1992-08-05—24066088588900 Pine Dr, Dallas, TX, 752200.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-418489CLMBruce Sanchez1958-03-21—72449318202162 Hillcrest Rd, Sacramento, CA, 958430.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105568ENRMatthew Carroll1999-01-17UHC-31003-234908055318223 Market St, San Diego, CA0.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
TPA-56696TPABobby Porter——76657443469479 Camelback Rd, Sacramento, CA, 958340.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-53027TPAGace Vargas1954-05-26—5905289339955 Ocean Ave # 337, Minneapolis, MN0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-50493TPASara Jaes1964-06-24—51520872172639 Sage Ct, Tempe, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-120651ENRKaren Lucas1956-07-02UHC-43243-0950656610466460 Bayshore Dr Apt 23, Phoenix, AZ0.48Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-131811ENRLuis G Perry1946-06-14UHC-22698-52—8902 Park Pl, Tucson, AZ, 857550.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-54389TPAFatima Simmons———388 Church St # 621, Columbus, OH, 432390.48Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+4 more
PRV-29147PRVLucia Lawon1953-07-15—81287316824690 Highland Ave, Las Vegas, NV, 891780.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-121709ENRBeverly Mendoza2008-09-20UHC-46120-8645727213009052 Desert Sky Blvd, Tampa, FL0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133959ENRJennier K Graham1962-09-18UHC-93558-2587449619888552 Highland Ave, Houston, TX, 770640.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-20371PRVVictoria Hawkins1977-02-12—78767965391995 Spring St # 774, Las Vegas, NV, 891550.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-122588ENRLuis Nelson1972-10-11UHC-24502-41—7817 Sage Ct, Las Vegas, NV0.48Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141381ENRBeverly Henry1938-07-18UHC-07701-7888198760744245 Lake View Rd Apt 29, Scottsdale, AZ, 852600.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-417351CLMSamuel West1959-04-07UHC-29799-4841133948716720 Willow Ct, Austin, TX, 787700.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428260CLMRyan Walker1979-07-19UHC-79552-94—9299 Hillcrest Rd, Las Vegas, NV0.48Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-142354ENRJudy M Lynch1966-09-04UHC-41671-34—5926 Mesa Dr # 463, Austin, TX, 787180.48Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-412271CLMJerry Jensen1955-08-28UHC-63050-3526795865824916 Sunset Blvd, Nashville, TN, 372550.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429831CLMJesse Lewis1976-02-19UHC-25390-9978045422172263 Oak St, Gilbert, AZ, 852330.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-114465ENRDaniel Spencer1988-07-25UHC-34290-395803814153738 Grand Ave, Tucson, AZ0.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
ENR-142862ENRRobert T Ray1986-11-19UHC-38009-7570185010119442 Pine Dr, Seattle, WA, 981280.48Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-104273ENRAshhley Park1946-12-01UHC-07501-1487761704219167 Forest Ave, San Antonio, TX0.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 83 of 2,000PreviousNext