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-122295ENRFrances R Bryant1955-04-02UHC-39441-1451371054183296 Lake View Rd, Minneapolis, MN, 554460.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29198PRVAnthony Perkins1988-06-09——5905 Elm St, Las Vegas, NV, 891130.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-139557ENRJesse D Wang1951-05-04UHC-64399-8056279037914970 Grand Ave # 581, Chandler, AZ, 852450.52Middle initial moved out of first namePhone reformattedSSN last four extractedUnit split from street+2 more
TPA-54497TPAMark F Owens1946-08-06——6488 Cedar Ln, Fresno, CA, 937800.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-130437ENRJennifer G Aguilar1942-11-23——3751 Forest Ave, Los Angeles, CA, 900610.52Phone missing area codeState name converted to codeZIP+4 trimmedEmail lower-cased+2 more
PRV-21784PRVLinda Y Palmer——92256325914786 Sunset Blvd, Dallas, TX, 752280.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419553CLMGerald Fisher1943-06-08——268 Indian School Rd, Charlotte, NC0.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-105409ENRAnna D Moore—UHC-72564-3294827504194022 Sage Ct, Plano, TX, 750070.52Name re-casedDate of birth missingPhone reformattedZIP+4 trimmed+2 more
TPA-50028TPAFatima Lynnch2001-08-22——7675 Harbor Blvd, Columbus, OH, 432000.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-104037ENRAndrew Little1958-05-10UHC-87409-1959466731457294 Spring St, Chandler, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-109526ENRHeather K Arnold1939-10-06UHC-93459-9753681911236480 Lincoln Way # 698, San Diego, CA, 921950.52Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+2 more
ENR-113707ENRYJunk1945-01-20UHC-61792-31—9312 Indian School Rd, Orlando, FL0.52Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+2 more
ENR-118282ENRMason G Young1971-01-20UHC-08186-30—1217 Oak St, Tempe, AZ, 852620.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
PRV-26988PRVKathleen Day1982-02-23UHC-81831-31—5003 Ocean Ave, Glendale, AZ, 853900.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-406225CLMArthur M Thompson1941-09-20UHC-87768-9476463889354865 Elm St, Atlanta, GA, 303730.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-59147TPAJacob Jensen———5608 Meadow Ln, Denver, CO, 802600.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-113864ENRPhilip Butler1980-02-07UHC-93273-2648199636786519 Baseline Rd, Jacksonville, FL0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121090ENREthan Warren1983-03-11UHC-72208-5052189030193131 Elm St, Sacramento, CA, 958030.52Date of birth reformattedPhone reformattedState name converted to codeZIP+4 trimmed+2 more
TPA-53986TPAJacqueline E Truner2000-11-12UHC-69964-16—898 Lincoln Way, Austin, TX, 787890.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-28007PRVHarold N Black1953-02-20UHC-08811-16—1814 Lincoln Way, San Diego, CA, 921870.52Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-119437ENRScott D Bryant1972-08-07UHC-95355-1339435881502176 Broadway, San Antonio, TX, 782000.52Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+2 more
PRV-25756PRVOlivia Franklin2003-08-18—23083049072718 Palm Dr, Seattle, WA, 981010.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-124921ENRLauren Washington1965-10-28UHC-74755-05—6518 Harbor Blvd, Scottsdale, AZ, 852320.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-27291PRVJose T Patterson1982-09-22—84965509509395 Sunset Blvd, Houston, TX0.52Phone reformattedState name converted to codeZIP missingGender normalised+2 more
ENR-108517ENRJohn K Price1938-06-23UHC-15883-4067573164048990 Canyon Rd, Tucson, AZ, 857810.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56960TPANoah Burton1959-02-27——6852 Meadow Ln # 186, Jacksonville, FL, 322590.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-135374ENRThomas M Anderson1965-04-13UHC-56943-8053929789874269 Oak St, Tucson, AZ0.52Name re-casedPhone reformattedSSN last four extractedState name converted to code+2 more
PRV-22589PRVBrenda Alvarado1980-06-28UHC-41851-99—6602 Oak St, Jacksonville, FL, 322430.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-401591CLMKathryn T Schmidt1956-10-09UHC-18595-4664151887445650 Pine Dr # 989, Tucson, AZ, 857140.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-124140ENRRachel Fields—UHC-87438-08—3746 Valley View Dr, Gilbert, AZ, 852100.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-107274ENRNathan Tucker1982-07-18UHC-69609-125058955843573 Union St, Houston, TX, 770090.52Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-106259ENRMegan Andrews1962-05-13UHC-94788-82—8147 Mesa Dr Apt 13, Jacksonville, FL, 322330.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405633CLMMarcus Nelson1957-04-08UHC-34131-61—4225 Washington St Apt 11, Tempe, AZ, 852760.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50034TPAChristian W Contreras1983-07-26——5376 Desert Sky Blvd, Miami, FL, 331720.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-423432CLMMei Hoffman1938-05-02UHC-76616-8465634587829428 Oak St, Plano, TX, 750310.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-58436TPAGerald Little1996-11-14UHC-94042-51—3476 Ocean Ave, Columbus, OH, 432970.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-101279ENRSean Hunter1944-01-18UHC-33259-0161851241745604 Pine Dr, Austin, TX, 787950.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-113802ENRLaura Fox1975-10-04UHC-14380-64—6335 Church St, San Antonio, TX, 782700.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
ENR-140704ENRAmanda Anndrews1971-10-25UHC-57948-9573750281487758 Central Ave, Chandler, AZ, 852750.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103902ENRElizabeth G Carr1950-05-12UHC-31609-6266664472868111 Bayshore Dr Apt 22, San Antonio, TX, 782460.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-110065ENRKathy Bowman1973-10-03UHC-43848-6894830846113619 Elm St, Eden Prairie, MN0.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-56053TPAJean L Edwards1956-04-04—45273664688902 Central Ave, Mesa, AZ, 852380.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23300PRVAnthony Guerrero1972-11-10UHC-93685-6026229204006030 Main St, Austin, TX, 787330.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23399PRVDavid Y Armstrong1946-07-26UHC-93636-05—1887 Ridge Rd, Gilbert, AZ0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
ENR-107376ENRLarry F Jackson1943-03-16UHC-86916-4191789403019602 Church St # 525, Seattle, WA, 981240.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-129424ENRLarry D Riley1938-04-13UHC-29158-6631139699884797 Mountain View Dr, Orlando, FL, 328340.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-104558ENRAmber J Alexander1972-12-15UHC-39257-4332646489873079 Oak St, Fresno, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-408778CLMKaren F Jackson1947-05-22—85433793291428 Jefferson Ave, Los Angeles, CA, 900230.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-101422ENRSean Carter1989-03-09UHC-33480-8269434742948727 Union St, Phoenix, AZ, 850670.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-114151ENRPhilip Sanders1957-06-07UHC-05781-0658371343574585 Camelback Rd Apt 3, Charlotte, NC, 282020.52Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
100,000 rows, page 193 of 2,000PreviousNext