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-55592TPARussell Burke1959-01-18——6780 Mountain View Dr, Los Angeles, CA, 900800.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-113901ENRJennifer W Scott1990-10-11UHC-43086-65—3029 Market St, Sacramento, CA, 958390.52Name split from “Last, First”Phone missing area codeMember ID reformattedEmail lower-cased+2 more
ENR-129370ENRSarah U Kelley1946-09-03UHC-44030-4170538605709831 Mountain View Dr Apt 13, Orlando, FL, 328020.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-139405ENRGary Chapman1981-02-12UHC-89611-3562479510588674 Lake View Rd, San Diego, CA, 921450.52Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+2 more
ENR-107510ENRSadra Jackson1946-02-22UHC-13086-58—5992 Oak St Apt 20, Jacksonville, FL, 322070.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-124996ENRThomas Salazar1993-07-25UHC-08590-3765166193427441 Valley View Dr, Austin, TX, 787550.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400080CLMJonathan X Price1980-05-14UHC-44743-3290392114086450 Jefferson Ave, Eden Prairie, MN, 553690.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-432056CLMNicholas Hill1939-12-25UHC-19819-24—7755 Canyon Rd Apt 38, Los Angeles, CA, 900890.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-101508ENRKaran Baker1951-06-10UHC-03116-0147841939903263 Hillcrest Rd, Jacksonville, FL, 322380.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-101509ENRKaran Baker1951-06-10UHC-03116-0147841939903263 Hillcrest Rd, Jacksonville, FL, 322380.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405694CLMKenneth Meedina1992-03-26——4894 Ocean Ave, Las Vegas, NV, 891120.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-400032CLMLauren Williams2002-07-08——3118 Sunset Blvd, Mesa, AZ, 852930.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416679CLMDorothy W Wagner1999-11-07UHC-27472-49—1607 Forest Ave Apt 18, Tucson, AZ, 857330.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107362ENREugene Jimenez1984-02-04UHC-93297-6092543858441999 Willow Ct, Eden Prairie, MN, 553970.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-109237ENRReed Kelly1981-06-21UHC-12779-473486418768640 Washington St, Phoenix, AZ, 850500.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140067ENRRaymond A Meyer1983-01-04UHC-99901-9233351148635905 Mountain View Dr, Gilbert, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-119950ENRAaron F Evans1944-06-16UHC-51560-7569353654222320 Central Ave, Austin, TX, 787530.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-114895ENRMichelle Hernandez1989-02-27UHC-91392-4832477649367088 Mesa Dr, Glendale, AZ, 853070.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100928ENRCharlotte Bryant1993-09-22UHC-51096-9785882005124266 Union St, Denver, CO, 802300.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-407488CLMMason Ramirez1964-05-03UHC-58089-01—3165 Spring St, Fresno, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
PRV-29485PRVCheryl Gibson1999-05-15—29448190186044 Willow Ct, Los Angeles, CA, 900800.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427463CLMMaria Z Patterson1984-10-12UHC-97217-21—2117 Lake View Rd Apt 27, San Antonio, TX, 782360.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-121897ENRCatherine Lee1967-03-15UHC-31793-24—1926 Union St, Chandler, AZ, 852490.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-414513CLMJonathan Sullivan1969-06-09UHC-02849-7666688858552307 Forest Ave, Charlotte, NC, 282590.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-405735CLMBeverly H Hughes1988-06-28UHC-84048-28—3148 Cedar Ln, Plano, TX, 750030.52Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+2 more
ENR-135982ENRJames Johnston1960-06-27UHC-80069-17—3248 Mesa Dr, Nashville, TN0.52Phone missing area codeMember ID reformattedCity re-casedZIP missing+2 more
ENR-127173ENREmma S Griffin1961-04-16UHC-91839-8498886863316820 Hillcrest Rd, Los Angeles, CA, 900220.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-21788PRVDiana Berry1978-03-11UHC-53245-5368165813248859 Spring St, Miami, FL, 331970.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50876TPAMartha M Dean1989-02-17——5105 Spring St, Tempe, AZ0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-415631CLMSJunk1952-06-25UHC-75504-6440421611777190 Sunset Blvd # 502, Glendale, AZ, 853970.52Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-119193ENRSantiago M Woods1999-07-20UHC-32440-0465789355668090 Lake View Rd, Chandler, AZ, 852780.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59555TPAGrace Bishop1983-12-15——3120 Cedar Ln, Minneapolis, MN, 554500.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-107474ENROlivia U Chavez1973-01-15UHC-71126-9161566289285964 Meadow Ln Apt 17, Atlanta, GA, 303710.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431236CLMJoshua M Gonzales2001-03-06UHC-38587-47—4712 Sunset Blvd, Phoenix, AZ0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-57585TPAMak Hawkins1973-02-22——1648 Main St, Tempe, AZ, 852890.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-109162ENRDaniel N Ryan1950-03-06UHC-22573-16—8467 Cedar Ln, Jacksonville, FL, 322040.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-136558ENRMaria Cole1946-12-12UHC-57827-9561135259557219 Apache Blvd, Phoenix, AZ, 850140.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
TPA-61401TPARaymond Carlson—UHC-95664-26—9151 Church St, Houston, TX, 770590.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
PRV-23390PRVAlice Ortega1948-01-20—75676656484708 Camelback Rd, Miami, FL, 331940.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-139071ENRGrace Garza2002-11-10UHC-70601-8890065828117828 Maple Ave Apt 40, Chandler, AZ, 852810.52Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+2 more
ENR-103687ENRSandra L Wang1992-07-25UHC-11750-72—4488 Cedar Ln Apt 2, Seattle, WA, 981270.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419922CLMRalph Fernandez1943-07-07——1007 Baseline Rd, Las Vegas, NV, 891070.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142963ENRAdam M Delgado1971-09-05UHC-51736-8880035637083565 Grand Ave, Houston, TX, 770030.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109801ENRTyler C Fernandez1978-08-14UHC-64576-9266723768264638 Mountain View Dr, Los Angeles, CA, 900250.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-108897ENRNicholas Z Reyes1975-02-18UHC-88476-5925580788976595 Meadow Ln Apt 17, San Antonio, TX, 782210.52Date of birth reformattedMember ID reformattedUnit split from streetZIP+4 trimmed+2 more
PRV-28484PRVLucia B Watkins—UHC-64281-09—952 Bayshore Dr, Scottsdale, AZ, 852000.52Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-124385ENRBrandon Gibson—UHC-73891-3094183858823199 Desert Sky Blvd, Houston, TX, 770230.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-105743ENRMaria H Wilson—UHC-91464-2475525306898988 Main St, Miami, FL, 331220.52Middle initial moved out of first nameDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-131601ENRHarold K Nguyen2001-08-19UHC-44441-8028443454466451 Hillcrest Rd, Phoenix, AZ, 850810.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409811CLMJustin Warren1970-02-02UHC-50704-53—6843 Mountain View Dr, Glendale, AZ, 853500.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
100,000 rows, page 186 of 2,000PreviousNext