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-115709ENRLawrence Q Ramirez1998-06-26UHC-12458-1155869179245181 Desert Sky Blvd, Scottsdale, AZ, 852680.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50635TPASandra P Alvarez1948-03-21—77967528523403 Ridge Rd # 203, Tampa, FL, 336220.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-51093TPAKelly Carter1964-06-03—7283671484405 Maple Ave, San Antonio, TX, 782690.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-412835CLMWilliam Black1967-03-21—21093421095405 Sunset Blvd, Jacksonville, FL, 322430.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-405764CLMPeter Mendoza1959-08-05UHC-10519-6373364882444978 Valley View Dr, Austin, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-421568CLMAlexander Rivera1958-07-12UHC-52912-99—298 Washington St, Phoenix, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-401399CLMGabriel Robertson1946-05-09——5918 Mountain View Dr, Glendale, AZ, 853350.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-103215ENRHeather Howard1954-04-18UHC-56509-498185394398784 Forest Ave # 867, Houston, TX, 770480.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-432559CLMAmanda Bennett2004-01-08UHC-35446-77—6065 Union St, Columbus, OH, 432510.50Name re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-104024ENRChristina U Meyer1955-03-22UHC-19804-1677862795882100 Meadow Ln # 291, Los Angeles, CA, 900390.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126261ENRArjun T Jones1979-06-19UHC-20049-5376189943815653 Spring St, Mesa, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-58902TPADiego M Lawrence2005-03-13UHC-68548-0844650485571001 Hillcrest Rd Apt 36, Tempe, AZ, 852030.50Middle initial moved out of first nameDate of birth reformattedMember ID reformattedUnit split from street+3 more
ENR-136838ENRWilliam M Hughes1978-01-02UHC-08089-6982245637919230 Canyon Rd, Minneapolis, MN, 554260.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-25094PRVHanah Lucas1986-12-09UHC-54951-7071456553619358 Mountain View Dr, Plano, TX, 750670.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
PRV-28866PRVMaria Reed1944-03-19—87773276137228 Ridge Rd, Jacksonville, FL, 322570.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418910CLMRonald Ray1980-08-21UHC-88813-34—1776 Park Pl, Houston, TX, 770010.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
ENR-115882ENRRandy Graham1965-11-03UHC-32783-4337024373084838 Highland Ave, Fresno, CA, 937850.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115883ENRRandy Graham1965-11-03UHC-32783-4337024373084838 Highland Ave, Fresno, CA, 937850.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-20857PRVAllice Wallace1939-07-04UHC-88572-65—1501 Main St, Orlando, FL, 328750.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-21498PRVSophia M Anderson1944-05-23UHC-17148-9870691637602387 Sage Ct, Houston, TX0.50Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
ENR-105336ENRJonathan Reed—UHC-35512-9194673843381324 Camelback Rd Apt 1, Tucson, AZ, 857990.50Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+3 more
ENR-142637ENRKayla Bradley1979-03-19UHC-37557-8124795971568373 Church St # 326, Las Vegas, NV0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-111532ENRAlice Tran2006-04-18UHC-63134-9826320053235978 Market St, Gilbert, AZ, 852760.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-409918CLMGerald Cllins2008-05-28—46633584924668 Oak St, Glendale, AZ, 853810.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-103048ENRKaren C Silva1950-07-12UHC-48582-8498033265671395 Maple Ave, Glendale, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
PRV-23633PRVKathleen Lane2001-01-26—49497250277643 Highland Ave Apt 13, Miami, FL, 331930.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-123151ENRKeith C Sanders—UHC-17016-66—6170 Willow Ct, Atlanta, GA, 303420.50Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-122449ENRThomas H Chen2004-08-09UHC-89520-2027697879655392 Jefferson Ave, Chandler, AZ0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-105819ENRRian Rojas1967-03-17UHC-73873-9391576745233825 Apache Blvd, San Diego, CA, 921250.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417440CLMSamuel Rodriguez1957-12-02UHC-96426-29—9608 Meadow Ln, Plano, TX, 750180.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-27410PRVGloria Watkins1974-11-18UHC-01940-8057136831337662 Church St, San Antonio, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421951CLMSamuel Fisher1970-06-03UHC-59857-84—2380 Highland Ave, Seattle, WA0.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-116433ENRWayne A Sanchez——23939875263186 Harbor Blvd, Los Angeles, CA0.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52987TPAThomas F Freeman2006-04-07——1119 Pine Dr, Charlotte, NC0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131867ENRSteven U Campbell1987-11-27UHC-83825-1772571928354595 Union St, Plano, TX, 750990.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-423583CLMHarold O Howell1975-09-21UHC-51378-74—2564 Valley View Dr, Tucson, AZ, 857550.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58016TPAVincent Thomas1939-06-11UHC-72529-9889937979261569 Elm St, Las Vegas, NV, 891770.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113795ENRPhilip C Rodriuez1953-05-16UHC-24881-73—473 Washington St, Tempe, AZ, 852470.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-59910TPASusan Gray1975-12-26——9559 Lincoln Way, Seattle, WA0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-417701CLMMargaret Morales1955-04-15UHC-83089-0655029680083331 Jefferson Ave, Miami, FL, 331610.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
PRV-29359PRVKyle J Bishop1940-01-05UHC-06507-6682377040501367 Grand Ave, Chandler, AZ, 852800.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-121053ENRJason W Vasquez2007-07-06UHC-22579-4688248096674450 Sage Ct # 631, Los Angeles, CA, 900400.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-24370PRVLawrence Carter———1881 Jefferson Ave, Scottsdale, AZ, 852060.50Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-120965ENRDiane Lewis1952-01-14UHC-42576-07—7809 Broadway, Dallas, TX0.50Two-digit birth yearAddress re-casedCity re-casedZIP missing+3 more
ENR-115733ENRSandra Reyes—UHC-77075-9882491835948178 Market St, Dallas, TX, 752300.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116324ENRAndrew Foster1955-10-12UHC-85895-3263942653306503 Cedar Ln, Las Vegas, NV, 891730.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-128506ENRValentina Jackson1965-01-20UHC-77916-695397472494462 Lake View Rd, Eden Prairie, MN, 553670.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-115143ENRKala S Carter1970-04-24UHC-01830-9840046545633471 Apache Blvd # 448, Miami, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-20462PRVNatalie J Simpson1940-11-11UHC-12051-8349470905294332 Maple Ave, Jacksonville, FL0.50Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+3 more
ENR-100424ENRDouglas W George1985-12-18UHC-91044-2921464805329884 River Rd, Tempe, AZ, 852170.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
100,000 rows, page 109 of 2,000PreviousNext