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-414091CLMNatalie Collins1957-07-26UHC-61521-4048563654138209 River Rd, Las Vegas, NV0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-104164ENRRussell L Tucker1953-03-14UHC-79982-50—7821 Central Ave, Scottsdale, AZ, 852620.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
CLM-414595CLMDiego Castillo1949-12-03UHC-99368-8580979570305556 Central Ave, Columbus, OH, 432850.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-111076ENRJacqueline Grant1978-12-02UHC-43018-8371081288309887 Spring St # 854, Charlotte, NC, 282690.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
PRV-25622PRVRussell Valedz1968-04-09UHC-94337-1063682164551589 Willow Ct, Tampa, FL, 336520.52Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-413806CLMWillie Robinson1967-08-05——5548 Valley View Dr, Jacksonville, FL, 322950.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-124421ENRRussell Powell1939-10-22UHC-73379-98—8283 Willow Ct, Fresno, CA0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124405ENRAngela J Alvarado1957-08-09UHC-25514-9956141312122119 Church St, Chandler, AZ, 852970.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-429098CLMEmily Ramirez1959-12-05——2364 Broadway, Tempe, AZ, 852940.52Two-digit birth yearAddress re-casedState name converted to codeGender normalised+2 more
CLM-415935CLMBen I Dunn1962-04-25—75073491603300 Oak St, Eden Prairie, MN, 553190.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21430PRVZachary Ortega1947-11-11UHC-23727-64—7811 Washington St, Fresno, CA0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-25633PRV—Junk2002-03-22——4094 Apache Blvd, Los Angeles, CA, 900850.52Date of birth reformattedPhone missing area codeState name converted to codeWhitespace trimmed+2 more
ENR-108054ENRFrank L Murray2006-09-23UHC-51068-9560358820376786 Mountain View Dr, Fresno, CA0.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-419154CLMTerry Fernandez1985-03-27UHC-26247-59—6649 Grand Ave, Jacksonville, FL, 322500.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-126626ENRJoe Olson—UHC-47916-6739058154098847 Market St, Scottsdale, AZ, 852450.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
ENR-129542ENRBobby L Payne1988-08-17UHC-54861-7623158603187432 Palm Dr, Columbus, OH, 432480.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430361CLMMariana Garrett2003-11-15——6949 Sunset Blvd Apt 4, Mesa, AZ, 852580.52Two-digit birth yearUnit split from streetCity re-casedGender normalised+2 more
ENR-140161ENREugene J Jacobs1947-06-19UHC-70574-6249485072831650 Meadow Ln, Jacksonville, FL, 322630.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420883CLMPaul Bennett1970-06-17UHC-74898-509694094238—0.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
ENR-100467ENRChristina O Gray1982-06-23UHC-11437-6021161837638282 Cedar Ln, Charlotte, NC, 282850.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133548ENRBradley Flores—UHC-20706-40—3417 Indian School Rd, Gilbert, AZ, 852960.52Name re-casedDate of birth unreadableSSN last four extractedStreet suffix standardised+2 more
CLM-416750CLMJordan Fisher1949-10-12UHC-55830-11—7641 Mesa Dr, Denver, CO0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-111395ENRAlexis Garza1969-02-17UHC-59195-323157024133141 Bayshore Dr, Tucson, AZ, 857060.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-421895CLMEthan L Jackson—UHC-62313-89—801 Main St, San Antonio, TX, 782690.52Date of birth missingStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-121856ENRMarcus Nguyen1981-01-17UHC-61216-0860442112218499 Forest Ave, Houston, TX, 770370.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-123058ENREmily N Williams1964-02-18UHC-97981-1444891485499305 Cedar Ln, Atlanta, GA, 303050.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
CLM-411977CLMFrank Castillo2005-01-02——3298 Jefferson Ave, Miami, FL, 331290.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-117401ENRTomy Mendoza2007-04-23UHC-73410-8486399368164060 Grand Ave, Eden Prairie, MN, 553930.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63163TPADensie Lynch1965-06-12—87062804984354 Sunset Blvd, Phoenix, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57935TPADebra Hudson1999-06-22——8828 Union St Apt 14, Atlanta, GA, 303270.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425348CLMDot Patterson———3384 Cedar Ln, Nashville, TN, 372660.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-139250ENRAlexis D Elliott1988-12-28UHC-17655-37—3400 Ridge Rd, Miami, FL, 331490.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-410789CLMDeborah McDonald1956-04-26——361 Palm Dr, Orlando, FL, 328970.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-109533ENRDylan Y Rojas1974-10-07UHC-97077-1581228846904391 Camelback Rd, Austin, TX, 787620.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-128007ENRCynthia Baker1938-09-16UHC-45011-8045478011815643 Park Pl, Phoenix, AZ, 850440.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-29531PRVDot U Fernandez1958-06-18——4640 Pine Dr Apt 37, San Diego, CA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57651TPAMichael Flores2000-05-13—71631718867802 Oak St Apt 14, Charlotte, NC0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-26398PRVFrank Arnold1969-03-10UHC-80971-8268134218052031 Central Ave, San Antonio, TX, 782980.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50085TPASahron Patel1955-09-08——400 Washington St, Chandler, AZ, 852070.52Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+2 more
ENR-131031ENRTeresa P Burton1956-04-24UHC-61347-45—5876 Indian School Rd # 546, Minneapolis, MN, 554670.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426690CLMCarl Ray1963-08-05UHC-21904-36—1930 Harbor Blvd # 457, Mesa, AZ, 852080.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426643CLMNancy Richards1948-06-12UHC-93715-4981295667028910 Mountain View Dr Apt 19, Dallas, TX, 752340.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-423665CLMJanice A Banks1964-06-22——7977 Elm St, Orlando, FL, 328470.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-120043ENRSantiago Padilla1981-11-04UHC-48047-31—6082 Grand Ave, San Diego, CA, 921470.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-130095ENREvelyn Perez1999-04-20UHC-48058-7655273605193972 Ocean Ave, Los Angeles, CA, 900770.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-62448TPADylan King1938-09-20—42764989072534 Market St, Columbus, OH, 432750.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413335CLMDouglas T Henderson1997-01-10UHC-07476-51—1129 Market St, Eden Prairie, MN0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-425086CLMJoan Z Bennett1943-02-10UHC-27960-11—6070 Union St, San Diego, CA, 921460.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103152ENRTheresa Andrews1998-05-22UHC-47418-4049124953143267 Central Ave, Austin, TX, 787490.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-431215CLMSophia Daniels1983-05-06——9788 Jefferson Ave, Denver, CO, 802750.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
100,000 rows, page 158 of 2,000PreviousNext