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-106072ENRKathy M Guzman2004-11-07UHC-40091-8450152253653914 Market St, Fresno, CA0.54Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-58558TPADiane Schmidt1938-12-10——2641 Broadway, Miami, FL, 331660.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-102248ENRJan Hill1973-11-18UHC-37787-3376571842085687 Washington St, Phoenix, AZ, 850040.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-135368ENRBarbara T Carr2000-03-19UHC-71429-3559538870544270 Jefferson Ave, Orlando, FL, 328450.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-120206ENRBruce V Brown1946-05-18UHC-63047-4824791542892426 Cedar Ln # 982, Minneapolis, MN, 554830.54Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-116512ENRChristine Maldonado1999-01-18UHC-29569-2395369807969770 Meadow Ln, Houston, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-132419ENRBenjamin Henry2008-01-09UHC-63829-0734695011066289 Desert Sky Blvd # 957, Plano, TX, 750930.54Name split from “Last, First”Phone reformattedUnit split from streetZIP+4 trimmed+1 more
ENR-111660ENRJuan Ellis1996-07-02—67931892753402 River Rd, Eden Prairie, MN, 553620.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-110529ENRDiane N Perez1968-05-22UHC-33040-3987389540544520 Spring St # 384, Plano, TX, 750970.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-415740CLMJonathan L Li1953-03-23UHC-13181-99—5572 Mesa Dr, Charlotte, NC0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-427405CLMBetty Hwell1946-06-14UHC-12924-59—8049 Highland Ave, Gilbert, AZ0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-414868CLMDorothy Hudson1988-11-08UHC-18183-88—3077 Meadow Ln, Minneapolis, MN, 554370.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-111007ENRAlexander Perez1993-06-05UHC-58073-3375665441011775 Lincoln Way, Phoenix, AZ0.54Phone reformattedMember ID reformattedState name converted to codeZIP missing+1 more
CLM-423325CLMAustin D Wong1979-03-20UHC-43391-4422367910959008 Willow Ct, Las Vegas, NV0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-107173ENRKathryn Allen1967-10-10UHC-03261-39—1368 Main St, Austin, TX, 787470.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-58823TPASteen Turner1940-04-27——7023 River Rd, Gilbert, AZ0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-125221ENRJesse Fisher1982-08-26UHC-84739-4849458501635232 Elm St Apt 37, Houston, TX, 770410.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-63430TPAOmar V Fisher1995-03-19——8386 Ocean Ave, Las Vegas, NV0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-137405ENRHannah B Mitchell1942-01-23UHC-69310-9774283875367772 Willow Ct, Phoenix, AZ, 850810.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-123493ENRRaymond L Palmer1983-06-22UHC-07780-397574499563728 Apache Blvd, Austin, TX, 787420.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-427061CLMAamnda Singh1946-10-03——2132 Baseline Rd, Dallas, TX, 752740.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-407324CLMMichael Ray1942-10-25UHC-73727-67—6408 Desert Sky Blvd, Dallas, TX0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-137598ENRRalph Arnold1998-08-26UHC-79978-65—1334 Jefferson Ave, San Antonio, TX, 782540.54Phone missing area codeStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
ENR-124227ENROmar Y Evans1971-06-08UHC-04207-1377055045233145 Jefferson Ave, Charlotte, NC, 282420.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-120304ENRKeith Williamson1976-03-27UHC-70723-03—1299 Valley View Dr, Phoenix, AZ0.54Name split from “Last, First”Date of birth reformattedZIP missingGender normalised+1 more
CLM-426687CLMFrances B Ross1987-12-11——379 Washington St, Las Vegas, NV, 891880.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-116806ENRLogan S Evans1999-03-16UHC-46383-5045342773997167 Valley View Dr Apt 16, Fresno, CA, 937660.54Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+1 more
CLM-424720CLMJoan Weber—UHC-41593-57—2151 Canyon Rd, Los Angeles, CA0.54Date of birth unreadableZIP missingGender normalisedWhitespace trimmed+1 more
TPA-56464TPASusan Carr2005-06-19——8577 Spring St # 747, Charlotte, NC, 282630.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-21061PRVMariana Bradley1960-08-08UHC-30373-4871593177683194 Sunset Blvd, Seattle, WA, 981560.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-105987ENRWilliam X Vargas1983-02-24UHC-98408-0695920225355685 Baseline Rd, Atlanta, GA, 303040.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425112CLMRichard West1945-06-02UHC-77633-09—7522 Desert Sky Blvd, Glendale, AZ0.54Name re-casedTwo-digit birth yearZIP missingGender normalised+1 more
ENR-117574ENRPriya Hamilton1971-06-27UHC-51752-3841774906375118 Apache Blvd, Atlanta, GA, 303810.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-63098TPAAmber Delgado1972-11-06——1854 Union St, Seattle, WA, 981500.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-108261ENRStephanie Q Crawford1961-05-03UHC-48820-47972584905319 Pine Dr Apt 21, Nashville, TN, 372010.54Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-414957CLMTyler S Torres2002-11-05UHC-22537-44—9062 Oak St Apt 26, Tampa, FL0.54Unit split from streetCity re-casedState name converted to codeZIP missing+1 more
CLM-427480CLMWayne X Castillo1957-03-05UHC-95042-59——0.54Middle initial moved out of first nameTwo-digit birth yearPhone missing area codeWhitespace trimmed+1 more
CLM-427481CLMWayne X Castillo1957-03-05UHC-95042-59——0.54Middle initial moved out of first nameTwo-digit birth yearPhone missing area codeWhitespace trimmed+1 more
ENR-128462ENRCynthia Q Ortega1943-02-04UHC-81402-2743875706278531 Mountain View Dr, Atlanta, GA, 303110.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400603CLMKatherine B Spencer1941-12-05UHC-92145-04—7159 Jefferson Ave, Eden Prairie, MN0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-141437ENRJoyce Contreras1938-04-24UHC-80912-70—675 Church St, Eden Prairie, MN, 553990.54Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+1 more
ENR-117704ENRIsabella J Burns1972-07-13UHC-88154-85—4757 Union St, Tempe, AZ, 852060.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-420075CLMVictoria Salazar1970-06-13UHC-74312-4941784079619172 Lake View Rd, Los Angeles, CA, 900710.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-141856ENRBlily Z Lawrence1989-11-08UHC-01909-1260861813114754 Willow Ct # 874, Denver, CO, 802990.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-116692ENRBrian A Larson—UHC-88524-2155829606965233 River Rd Apt 20, Jacksonville, FL, 322050.54Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-112416ENRCatherine C Boyd1960-06-01UHC-83433-44—8601 Sage Ct, Nashville, TN, 372230.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-109733ENRPriya Ortiz—UHC-99723-31—3345 Baseline Rd # 550, Tucson, AZ, 857830.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-111199ENRStephanie Valdez1982-02-19UHC-06509-6840347085716959 River Rd, Gilbert, AZ0.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-100768ENRJanicce Kelley1960-05-25UHC-15572-9048365415925743 Pine Dr, Los Angeles, CA0.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-430706CLMAhmed Cooper1942-03-08UHC-91936-3184472841138482 Valley View Dr # 486, Los Angeles, CA, 900280.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
100,000 rows, page 206 of 2,000PreviousNext