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
CLM-432357CLMJose Banks1997-11-05UHC-92182-66—5571 Main St, Dallas, TX, 752750.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105311ENREugene W Yang1964-02-15UHC-43655-6946722581961127 Palm Dr # 815, Denver, CO, 802040.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-109323ENRNathan Schultz1968-02-18UHC-02679-1344380455964204 Highland Ave # 683, Miami, FL0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142918ENRMason M Ward1993-02-17UHC-71648-9238272082162679 Camelback Rd, Jacksonville, FL, 322120.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-25022PRVKaren Nunez1964-07-26UHC-53022-613893833489315 Indian School Rd, Atlanta, GA, 303240.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-427524CLMJudy Price1995-04-04—71654026353123 Palm Dr, Las Vegas, NV, 891470.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64000TPALarry N Hamilton1963-11-20——890 Apache Blvd, Gilbert, AZ, 852640.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58912TPABilly N Valdez1968-12-02—45483237451459 Hillcrest Rd, Glendale, AZ, 853100.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
CLM-413352CLMSarah M Kennedy1998-07-05——5026 Hillcrest Rd, Mesa, AZ, 852860.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-26466PRVRachel Flores2001-04-19UHC-51774-4447685152624893 Central Ave, Houston, TX, 770600.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-103117ENRKevin R Wright1974-10-25UHC-22698-6391973481354413 Canyon Rd, Tucson, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107625ENRJuliaJunk1999-01-04—90390039889310 Washington St Apt 23, Houston, TX, 770280.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-113853ENRThomas D Walker1999-03-19UHC-98355-06—5048 Market St, Glendale, AZ, 853980.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-60233TPADenise Trna1986-02-18—86495062739384 Willow Ct, Glendale, AZ, 853750.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-121138ENRLinda Robinson2002-05-22UHC-09691-48—6595 Union St, Nashville, TN, 372830.50Name re-casedPhone missing area codeMember ID reformattedState name converted to code+3 more
CLM-421804CLMNatalie Mason1992-08-24UHC-07376-13—3166 Market St, Las Vegas, NV, 891790.50Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+3 more
CLM-423932CLMSara I Wallace1992-04-20UHC-78913-2894076144541117 Baseline Rd, Tempe, AZ, 852020.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-52862TPABarbara Lynch1958-02-01——8824 Maple Ave, Austin, TX, 787420.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-427632CLMAlan Evans1941-03-07UHC-27793-94—7622 Washington St # 140, Sacramento, CA, 958270.50Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+3 more
TPA-51720TPABryan Moreno———212 Washington St, San Diego, CA, 921150.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-402856CLMRobert Contreras2000-04-08UHC-89869-73—4976 Harbor Blvd, Las Vegas, NV0.50Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-104462ENRJulia O Montgomery1953-03-18UHC-08245-4134247734088871 Harbor Blvd, Scottsdale, AZ, 852650.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-51834TPAJoseph Gray1954-08-06——907 Cedar Ln # 569, Phoenix, AZ, 850440.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
ENR-106152ENRAdam L Freeman1954-12-10UHC-15081-8885598621822392 Oak St, San Antonio, TX, 782230.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120507ENRTheresa G Gordon1944-01-11UHC-51004-21—5855 Grand Ave, Chandler, AZ, 852950.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-122768ENRWayne J Matthews1953-07-06UHC-13783-2265374513328347 Market St # 903, Scottsdale, AZ, 852950.50Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-54239TPAPatricia Phillips1963-07-20—85688477973971 Jefferson Ave, Los Angeles, CA0.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-414782CLMAbigail Schultz2005-12-14UHC-61086-64—2337 River Rd Apt 27, Chandler, AZ, 852320.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-117193ENRSarah Tucker1943-09-21UHC-46506-60—8369 Mountain View Dr, Sacramento, CA, 958190.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-109184ENREugene Porter1966-07-22UHC-60023-2282262916024072 Maple Ave, Nashville, TN, 372910.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-428436CLMShirey Gordon1945-10-15UHC-16318-59—734 Park Pl, Los Angeles, CA, 900820.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-126955ENRChristina Armstrong1977-06-05UHC-85233-3366756066437060 Park Pl # 181, Las Vegas, NV, 891130.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-421838CLMZachary Robertson1963-06-17—33658819479048 Jefferson Ave, Tucson, AZ0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-419124CLMRay Soto1970-08-18——9722 Spring St Apt 12, Tucson, AZ0.50Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-427556CLMKimberly Wuod1985-10-03UHC-47559-10—6099 Cedar Ln, Tucson, AZ, 857080.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-111284ENRSusan L Ross1982-07-18UHC-33226-1056048325394013 Oak St, Sacramento, CA, 958940.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123439ENRJim J Santiago1946-12-26UHC-83965-2889837191681506 Mountain View Dr, Glendale, AZ, 853610.50Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
ENR-103766ENRBettty I Edwards1968-05-11UHC-46319-9944238409087053 Main St, Seattle, WA, 981470.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23713PRVDebra Duncan1989-01-03UHC-10860-4159038882172197 Washington St, Tempe, AZ, 852770.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59741TPAMartha Reid1981-01-12——1230 Camelback Rd, Atlanta, GA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-129707ENRPhilip B Edwards1989-09-11UHC-82853-5582929189858327 Baseline Rd Apt 10, Columbus, OH0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-57282TPATheresa Fox1938-07-20—7204608474974 Park Pl, Dallas, TX, 752840.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124799ENRCheryl U Hudson—UHC-35698-6668838643033694 Market St, Miami, FL, 331640.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-132768ENRDanielle D Henry1950-11-16UHC-92098-203755439260863 Ocean Ave Apt 21, Tempe, AZ, 852920.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-413867CLM—Junk1986-06-11UHC-27818-1691880994949669 Mountain View Dr, Scottsdale, AZ0.50Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419251CLMAndrea F King1960-01-13UHC-14938-2232872669452238 Sage Ct # 246, San Antonio, TX, 782130.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23356PRVMason B Murphy1956-11-11UHC-40374-1921187990223805 Pine Dr Apt 28, Eden Prairie, MN, 553000.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-135621ENRBeth Z Stephens1940-06-08UHC-57401-2084672065701884 Highland Ave, San Antonio, TX0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
PRV-23244PRVTyler M Morales1959-07-02—72645911833280 Ridge Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-23245PRVTyler M Morales1959-07-02—72645911833280 Ridge Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 94 of 2,000PreviousNext