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
TPA-50063TPAJennifer H Cole1962-10-12—63965727175396 Elm St, Charlotte, NC0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-108855ENRAhmed M Hudson2000-03-10UHC-80428-7098179442664171 Valley View Dr Apt 33, Sacramento, CA, 958090.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-426723CLMGeorgeJunk1944-02-26UHC-26152-27—4249 Union St, Scottsdale, AZ, 852130.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128247ENRDoris Guzman1956-10-23UHC-56787-5936427223553126 Indian School Rd, Minneapolis, MN, 554660.50Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-128246ENRDoris Guzman1956-10-23UHC-56787-5936427223553126 Indian School Rd, Minneapolis, MN, 554660.50Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-126423ENRAshley Murray1984-07-27UHC-29306-7049152974528578 Harbor Blvd, Orlando, FL, 328910.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-140600ENRDyylan R Stephens1982-08-03UHC-29218-2338780700188540 Meadow Ln, Plano, TX0.50Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-56361TPAGeorge M Torres1964-05-20UHC-42020-0992941626494804 Market St, Mesa, AZ, 852670.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-57982TPAKayla Perez1964-12-11——5951 Forest Ave, Plano, TX, 750250.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-126422ENRPirya Y Ramos1960-03-13UHC-54011-482178346182814 Apache Blvd, Miami, FL, 331790.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-101934ENRRobert C Alexander1959-03-08UHC-08776-21—814 Camelback Rd, Orlando, FL, 328660.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428923CLMGrace Y Palmer2008-06-23UHC-85177-5983774571006124 Hillcrest Rd, Tempe, AZ, 852530.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-54367TPASteve McCoy1976-03-10—46375248888878 Market St, Scottsdale, AZ, 852600.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-52872TPACarl Pnea1953-07-21——6299 Central Ave, Tempe, AZ, 852830.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-402427CLMJames Chen1961-02-13UHC-30142-5285940095012201 River Rd, Tucson, AZ, 857040.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135018ENRJose L Harvey1991-04-12UHC-37133-7424356404488461 Elm St, San Diego, CA, 921360.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-414181CLMMason Russell——95121859923902 Apache Blvd, Miami, FL, 331460.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-26195PRVHenry Myeers1953-05-04—21320714182969 Cedar Ln, Las Vegas, NV, 891000.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-21656PRVAnna Carpenter1952-02-03UHC-11448-93—5759 River Rd, Jacksonville, FL0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115276ENRBilly Grant1958-09-19UHC-16300-5376873211053323 Mountain View Dr # 467, Scottsdale, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102243ENRAndrea Holmes1965-05-05UHC-52048-24—1113 River Rd Apt 37, Atlanta, GA, 303360.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-107374ENRHeather G Black1983-01-18UHC-29594-7365554865323321 Washington St, Los Angeles, CA, 900400.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-107373ENRHeather G Black1983-01-18UHC-29594-7365554865323321 Washington St, Los Angeles, CA, 900400.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-106474ENRJason Nelson1990-01-28UHC-26606-9787745499675012 Desert Sky Blvd # 887, San Diego, CA, 921870.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-138536ENRRoger V Taylor1996-11-08UHC-26029-9868773467584847 Church St, Dallas, TX, 752920.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-109418ENRHenry Roberts1969-10-21UHC-17992-7568560785237955 Sage Ct, Chandler, AZ, 852850.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-50700TPABrandon E Porter1947-04-22—75759763247764 Pine Dr, Miami, FL, 331650.50Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+3 more
PRV-20891PRVJudith Rivera1968-04-15——5604 Ridge Rd, Los Angeles, CA, 900050.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-136413ENRWillie Bailey1973-10-24UHC-45370-8767328645369548 Union St, San Antonio, TX, 782840.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418393CLMMaria Reid1943-06-02UHC-95329-63—8664 Mountain View Dr, Las Vegas, NV, 891980.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-422422CLMThomas U Baker1955-02-04——9431 Desert Sky Blvd Apt 39, Eden Prairie, MN, 553920.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-121028ENRKelly L Contreras1992-03-23UHC-65136-0367974631009844 Valley View Dr, Las Vegas, NV0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-121027ENRKelly L Contreras1992-03-23UHC-65136-0367974631009844 Valley View Dr, Las Vegas, NV0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-106676ENRMadison V Hawkins1987-01-09UHC-63822-7939951501648810 Lake View Rd, Minneapolis, MN, 554650.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-408402CLMPatricia Chavez1998-04-09UHC-71200-9335150978043111 Desert Sky Blvd Apt 39, Denver, CO, 802370.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117058ENRHarold Gonzales1980-06-19UHC-74823-6327257681156248 Camelback Rd # 635, Tucson, AZ, 857130.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412024CLMDieggo X Kennedy1961-05-03UHC-16765-65—9183 Apache Blvd, Austin, TX0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-119719ENRGeorge S Hernandez1955-03-23UHC-67581-9022863177096868 Ridge Rd # 437, Mesa, AZ, 852970.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-420862CLMJaon R Meyer1967-01-24UHC-84985-1673832959704967 Hillcrest Rd, Gilbert, AZ, 852090.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53002TPAMary Cox1963-06-09—44655565362441 Canyon Rd, Eden Prairie, MN, 553750.50Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more
TPA-56327TPALuis Riley1971-06-19——8644 Apache Blvd, Los Angeles, CA0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-26269PRVDiana Lane1990-09-25UHC-80512-9782430774123391 Indian School Rd # 279, Mesa, AZ, 852650.50Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+3 more
CLM-402772CLMJoseph Alexander1951-07-26—21961230306930 Washington St, Austin, TX, 787520.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416758CLMWalter Black—UHC-18775-66—5693 Palm Dr, Glendale, AZ, 853360.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-54093TPAAhmed T Le2003-06-10—25292967838017 Indian School Rd Apt 26, Tucson, AZ, 857420.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-420671CLMRussell Hart1977-05-15——6357 Cedar Ln, Dallas, TX, 752180.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-138201ENRNatalie Harrys2007-04-14UHC-83927-1075073186484586 Cedar Ln, San Antonio, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432748CLMMaria Fields1944-03-23——7659 Hillcrest Rd, Minneapolis, MN, 554890.50Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-103344ENRJoseph QJunk1991-08-04UHC-11166-1096160669209484 Highland Ave, Tucson, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429323CLMJordan Robertson1979-09-13——1875 Ocean Ave, Tempe, AZ, 852160.50Name re-casedDate of birth reformattedSSN last four extractedZIP+4 trimmed+3 more
100,000 rows, page 123 of 2,000PreviousNext