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-113531ENRMegan T Garcia1979-11-28UHC-85835-9482965065879530 Forest Ave # 859, Austin, TX, 787230.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-22106PRVDylan Watkins2007-10-27—8029169881343 Bayshore Dr, Seattle, WA, 981910.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117623ENRRobert Li1958-02-14UHC-01999-78—9518 Desert Sky Blvd, Chandler, AZ, 852800.52Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+2 more
ENR-124420ENRJean Wang1965-07-21UHC-49440-9179582278712348 Elm St, Glendale, AZ, 853680.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420870CLMDonna Cook———6772 Desert Sky Blvd, Nashville, TN0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-64065TPALisa White1939-07-16——6103 Hillcrest Rd, Tucson, AZ, 857680.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-64066TPALisa White1939-07-16——6103 Hillcrest Rd, Tucson, AZ, 857680.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-105600ENRGabriel Russell—UHC-05189-6161758840344477 Washington St, Columbus, OH, 432580.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
CLM-403063CLMAngela Franklin1956-01-13UHC-82634-27—8529 Lake View Rd, Scottsdale, AZ0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-114402ENRGerald Wright1998-09-24UHC-16903-15—223 Church St, Miami, FL, 331140.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-53094TPASantiago Lewis1973-11-02——1083 Sage Ct, Fresno, CA, 937760.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26229PRVDoris Bell—UHC-49343-4462776602853718 Forest Ave, Nashville, TN, 372650.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-140694ENRMichelle Phillips1946-10-01UHC-44626-2258990447524100 Lake View Rd Apt 37, Miami, FL, 331480.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
TPA-60968TPAKenneth West1989-04-08——8925 Pine Dr, Austin, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-60967TPAKenneth West1989-04-08——8925 Pine Dr, Austin, TX0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-425423CLMBarbara S Park1982-05-01UHC-16638-8433269726214177 Pine Dr, Scottsdale, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415320CLMMichelle Riley1941-10-16UHC-24426-58—3847 Highland Ave # 897, Plano, TX, 750090.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-116607ENRAmanda U Santos—UHC-26059-183486712651723 Meadow Ln, Austin, TX, 787290.52Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-407520CLMPatricia Grant1978-09-07—74859310646500 Ridge Rd Apt 27, Miami, FL, 331720.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-131455ENRPatricia Q Ross1949-05-22UHC-68744-18775851139552 Desert Sky Blvd # 609, Glendale, AZ, 853940.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-416997CLMAbigail H Gomez1954-05-20——9733 Apache Blvd, Tempe, AZ0.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-107535ENRRandy Franklin1939-02-21UHC-11089-4069192443288402 Canyon Rd, Scottsdale, AZ, 852460.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111886ENRCarlos E Black1984-07-05UHC-87243-2245466461461501 Willow Ct, Houston, TX0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-107964ENRNicole Sullivan2005-09-21UHC-05239-5856163507185598 Valley View Dr, Tempe, AZ, 852350.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-125967ENRMariana Guzamn1954-06-03UHC-05958-1265774604693575 Hillcrest Rd, Columbus, OH, 432660.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-104570ENRCarl M Robertson—UHC-16735-8453228496433388 Jefferson Ave, Phoenix, AZ, 850030.52Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
ENR-131529ENRDorothy N Hayes2007-11-07UHC-27529-3133269177056272 Bayshore Dr, Tucson, AZ, 857290.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-26098PRVBarbara Z Fields——31831965595933 Oak St, Glendale, AZ0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-405600CLMJames Day1956-11-11UHC-69120-9266993764885159 Maple Ave # 115, Los Angeles, CA, 900910.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-60849TPAAmy Collins1970-09-28——4997 Maple Ave # 315, Minneapolis, MN, 554930.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432475CLMJuan Snyder1939-04-17UHC-15581-31—7663 Spring St, Las Vegas, NV, 891640.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429355CLMIsabella Shaw1942-11-09——1072 Maple Ave, Tampa, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-406396CLMLinda U Harvey1965-12-27UHC-26634-20—8129 Central Ave, Denver, CO, 802790.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-126326ENRAisha Salazar1967-12-18UHC-25890-6084043352349703 Willow Ct, Las Vegas, NV, 891930.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-133159ENRLiz Z Pierce1965-07-21UHC-28078-4842843309343566 Central Ave, San Antonio, TX, 782130.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110763ENRTimothy L Ortega1995-11-14UHC-61342-1554658069249713 Park Pl, Los Angeles, CA, 900550.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-61958TPASofia U Andrews1996-02-17——377 Spring St # 447, Charlotte, NC, 282180.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142710ENRArjun J Hanson1962-01-24UHC-47578-8862873269317609 Spring St, Seattle, WA, 981090.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-134984ENRKatherine G King1976-10-05UHC-75429-9760827173207807 Baseline Rd, Atlanta, GA0.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-117520ENRLogan U Gibson1999-08-16UHC-61944-9744482203821387 Lake View Rd, Miami, FL, 331270.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-118326ENRChris U Andrews2002-04-17UHC-48839-3988161325889864 Washington St Apt 31, San Diego, CA, 921110.52Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more
ENR-128161ENRMarshall Wayne1983-10-09UHC-19370-1939122030856085 Church St, San Antonio, TX, 782950.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115706ENRAna X Scott1990-09-23UHC-07807-145164151717569 Hillcrest Rd, Scottsdale, AZ, 852160.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-55086TPARachel Harrison1956-09-25——5938 Cedar Ln, Eden Prairie, MN, 553660.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-117397ENRMarilyn Thompson1964-03-13UHC-26376-2082271638313010 Market St, Tampa, FL, 336090.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-139497ENRRoegr Carroll2003-09-20UHC-99287-9255079488428485 Meadow Ln, Minneapolis, MN, 554020.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407734CLMVincent Maldonado1997-04-01UHC-63268-01—8069 Spring St, Nashville, TN, 372050.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-412591CLMJordan Wheeer—UHC-68353-50—7792 Sage Ct, Dallas, TX0.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-141268ENRDennis Bryant1960-10-25UHC-89581-2489359693729389 Central Ave, Plano, TX, 750800.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-431415CLMCarolyn Richards1955-06-02—45373408617689 Market St, Columbus, OH, 432660.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
100,000 rows, page 170 of 2,000PreviousNext