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-124136ENRJustin Coleman1971-12-12UHC-68642-6053699497533927 Valley View Dr, Mesa, AZ, 852790.52Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+2 more
ENR-139599ENRAlice I Lopez1993-01-01UHC-78452-1083733807947408 Mesa Dr, Jacksonville, FL, 322480.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-124342ENRJustin P Li1939-12-07UHC-25803-73—540 Palm Dr, Austin, TX, 787990.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-412729CLMMateo Flores1975-04-04UHC-34251-40—486 Highland Ave, Jacksonville, FL, 322490.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425878CLMChavez Ethan1989-09-10—71993029377974 Lincoln Way, Denver, CO, 802500.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-122012ENRBrandon F Morris1961-09-27UHC-64581-7458296311753009 Maple Ave, Tampa, FL, 336260.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-117466ENRBrian H Ford1998-09-28UHC-83014-8363164789693178 Harbor Blvd, Houston, TX, 770710.52Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
CLM-419315CLMPriya Murray1978-02-02UHC-60074-18—995 Washington St, Miami, FL, 331560.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-137039ENRGary Herrera1983-11-17UHC-69117-245483689686589 Mountain View Dr # 352, Plano, TX, 750170.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-138472ENRJose Day2004-10-04UHC-65678-01—3940 Desert Sky Blvd, Plano, TX, 750350.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113830ENRAdam Bailey2000-08-10UHC-61330-5468040428556587 Jefferson Ave Apt 5, Scottsdale, AZ, 852220.52Name re-casedUnit split from streetCity re-casedState code upper-cased+2 more
TPA-52041TPAKeith Hall1966-04-03——1725 Cedar Ln # 423, Dallas, TX, 752430.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426946CLMVega Ahmed1953-09-25UHC-03347-2697736008605743 Bayshore Dr, Scottsdale, AZ, 852450.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56485TPATyler Jones1946-04-21——4500 Indian School Rd, Phoenix, AZ, 850690.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424429CLMDaniel Dean1952-03-07——497 Camelback Rd, Gilbert, AZ, 852260.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-102678ENRNatalie W Graham1969-01-02UHC-06183-5538882610898770 Oak St, Jacksonville, FL, 322280.52Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+2 more
ENR-126277ENRJean J Vargas1990-06-03UHC-91924-50—3267 Oak St, Mesa, AZ, 852610.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60389TPAPatrick Knight1978-08-19——4240 Indian School Rd, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-123611ENRKevin Cunningham1962-09-09UHC-16646-6526089730934566 Forest Ave # 209, Phoenix, AZ, 850990.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-137918ENRKaayla Lucas1977-08-04UHC-47421-0965379738958456 Valley View Dr, Eden Prairie, MN, 553770.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112124ENRJack W Delgado—UHC-17106-676297836156928 Harbor Blvd, Tucson, AZ, 857100.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-103484ENRMarcus Richards2008-01-28UHC-72468-4974759560228720 Market St Apt 18, Atlanta, GA0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432708CLMJeremy Sims—UHC-18079-22—3402 Washington St, Chandler, AZ, 852380.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-132100ENRBrandon M Rose1976-05-22UHC-85159-6424363685921264 Valley View Dr, Tucson, AZ, 857640.52Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
CLM-419082CLMMagaret Parker1970-03-03UHC-49124-6081191256732902 Willow Ct, Fresno, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-20123PRVJacqueline Chen1997-08-07——5143 Grand Ave, Los Angeles, CA, 900110.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-107611ENRStephen Lewis1958-03-04UHC-80754-67—7899 Church St, Miami, FL, 331770.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-120223ENRDiana A Aguilar1958-08-04UHC-33485-4277740061914656 Elm St Apt 6, Chandler, AZ, 852770.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55047TPATerry N Arnold1952-02-27——5298 Elm St, Sacramento, CA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-63449TPARalph Phillips1983-08-09——6178 Park Pl, Austin, TX, 787120.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-61097TPAAmber Lawson1989-08-18——6226 Indian School Rd, Orlando, FL, 328720.52Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-425297CLMRoger Le1987-12-14UHC-84334-48—9800 Cedar Ln, Austin, TX, 787390.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58059TPAEvelyn Evans1988-03-04——549 Grand Ave, Gilbert, AZ, 852490.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-418819CLMBeverly Martinez1985-09-20UHC-52759-66—127 Valley View Dr, Phoenix, AZ, 850450.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-133721ENRDaniele Bradley1998-02-18UHC-78142-72—670 Pine Dr, Denver, CO, 802010.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-133001ENRScott T Welch1959-08-19UHC-58824-4792685724773195 Baseline Rd, Atlanta, GA, 303890.52Name split from “Last, First”Two-digit birth yearPhone reformattedEmail lower-cased+2 more
PRV-26360PRVHelen Williams1996-06-22—78980986146789 Canyon Rd, Houston, TX, 770460.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-104967ENRRobert Wels1957-10-10UHC-36855-1625883413983675 Mountain View Dr # 443, San Antonio, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-110913ENRMatthewJunk1992-09-05UHC-62583-9155275627086539 Highland Ave, Plano, TX, 750360.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-404497CLMHeather Soto1972-04-28UHC-92949-9197425593714780 Union St, Tampa, FL0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107923ENRGerald W Richardson1957-04-11UHC-52791-3529988256601747 Sage Ct # 988, Gilbert, AZ, 852540.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58258TPAAisha Snyder1967-03-11——7756 Hillcrest Rd, Atlanta, GA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-121296ENRBrittany K Ferguson1990-09-21UHC-84955-92—8269 Baseline Rd, Minneapolis, MN, 554330.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-119363ENRTeresa J Jimenez1989-01-10UHC-32575-9966331163743894 Meadow Ln, Fresno, CA, 937700.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118984ENREevlyn Munoz1971-10-06UHC-08992-3778961263526463 Ocean Ave, Glendale, AZ, 853330.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-139291ENRRachel M Fowler1983-05-20UHC-83408-0224388327168542 Forest Ave Apt 39, Minneapolis, MN, 554050.52Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-403375CLMEmma Castillo—UHC-27180-71—382 Highland Ave, San Diego, CA, 921310.52Name split from “Last, First”Date of birth reformattedDate of birth unreadableStreet suffix standardised+2 more
CLM-410690CLMRobertson M Ahmed1973-04-27——9758 Valley View Dr, Sacramento, CA0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410977CLMDennis Hamilton1990-08-17UHC-00203-27—4256 Ocean Ave, Columbus, OH, 432700.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-112369ENRBrenda M Phillips1945-10-26UHC-36458-2551177607745189 Grand Ave, Orlando, FL, 328840.52Middle initial moved out of first nameName re-casedPhone reformattedZIP+4 trimmed+2 more
100,000 rows, page 171 of 2,000PreviousNext