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, flag “Name split from “Last, First””, lowest dq score first

AllENRCLMTPAPRV
Junk onlyFlagName split from “Last, First”Clear
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-106513ENRZachary Ortega1947-11-11UHC-23727-6470131076297811 Washington St, Fresno, CA, 937780.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
ENR-129427ENRNatalie R Myers2006-05-19UHC-44376-5066157600515100 Main St, Miami, FL, 331280.68Name split from “Last, First”Two-digit birth yearState code upper-casedWhitespace trimmed
ENR-104966ENRStephaine G Carlson1977-04-16UHC-71608-0148898178829790 Cedar Ln, Gilbert, AZ, 852050.68Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted
ENR-128597ENRMarilyn D Chapman1992-01-07UHC-95524-1951650173996465 Desert Sky Blvd, Houston, TX, 770710.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
ENR-122095ENRBrittany R Freeman2007-03-10UHC-48392-2572547406288544 Valley View Dr, Denver, CO, 802080.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-400239CLMEmily Rice1955-12-08UHC-52218-454108956746—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
PRV-29137PRVKathryn Watkins1957-03-14UHC-05724-6734345259902121 Union St, Nashville, TN, 372610.68Name split from “Last, First”Phone reformattedSSN last four extractedPlaceholder values cleared
ENR-104729ENRJustin K Fox1999-09-25UHC-85137-13—5157 Cedar Ln, Nashville, TN, 372480.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-26516PRVBrittany P Garcia1976-07-09UHC-27108-6185948708869096 Meadow Ln, Phoenix, AZ, 850070.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
ENR-134933ENRJesse P Moreno1941-07-17UHC-10876-97—2244 Harbor Blvd, San Diego, CA, 921720.68Name split from “Last, First”Phone missing area codeEmail lower-casedWhitespace trimmed
TPA-56026TPAAlexis Stephens1946-11-14——7276 Harbor Blvd, Denver, CO, 802950.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410150CLMMatthew Mason1975-11-09UHC-38038-76—1967 Indian School Rd, Fresno, CA, 937380.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412589CLMJesse Ross1940-07-10UHC-10623-58——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
ENR-117786ENRDoris J Daniels1973-07-21UHC-54276-3850337607052694 Ocean Ave, Fresno, CA, 937140.68Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased
CLM-421156CLMRandy Alvarado2000-02-01UHC-90506-58—5022 Sunset Blvd, Orlando, FL, 328300.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
ENR-125241ENRJudith W Herrera2000-05-21UHC-70889-4652442783631589 Meadow Ln, Austin, TX, 787520.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-419587CLMKaren R Stewart2001-02-02UHC-89576-14——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
ENR-101786ENRGloria Bowman1938-09-24UHC-19730-0624467694474761 Elm St, Miami, FL, 331840.68Name split from “Last, First”Phone reformattedState code upper-casedGender normalised
ENR-133026ENRJustni Montgomery1946-04-08UHC-40036-6327293267146268 Cedar Ln, Los Angeles, CA, 900910.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
CLM-420547CLMBruce J Wright1963-11-10UHC-57010-363139077538—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
TPA-59069TPAElizabeth Daniels1976-05-23——605 Lincoln Way, Austin, TX, 787510.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
PRV-27868PRVHannah Ford1986-05-08UHC-68283-9336696981435236 Willow Ct, Fresno, CA, 937520.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418728CLMCatherine Smith1969-04-03UHC-24248-33—6032 Market St Apt 31, Dallas, TX, 752990.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
ENR-141671ENRJose Q Rodriguez1970-01-05UHC-27459-4052068822186126 Camelback Rd, Houston, TX, 770740.68Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased
TPA-50726TPAAhmed K Hart1960-03-01——4445 Jefferson Ave, Los Angeles, CA, 900390.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-405571CLMLawrence Sullivan—UHC-85120-50——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
ENR-102441ENRLucia Campbell1947-06-23UHC-88386-26—3984 Broadway, Glendale, AZ, 853820.68Name split from “Last, First”Phone missing area codeMember ID reformattedAddress re-cased
ENR-123097ENRMarilyn S King1970-10-14UHC-52925-80—7092 Pine Dr, Houston, TX, 770780.68Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased
ENR-142227ENRArjun E Harris1956-09-01UHC-30276-0267622207668466 Apache Blvd, Minneapolis, MN, 554860.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-424487CLMSamuel Simmons1945-05-25UHC-47169-69—519 Grand Ave, Orlando, FL, 328850.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
ENR-108224ENRFatima K Nguyen1965-07-25UHC-99893-1522860797478557 Camelback Rd, Miami, FL, 331040.68Name split from “Last, First”Phone reformattedZIP+4 trimmedPlan code upper-cased
CLM-415048CLMDanielle A Ramirez1966-02-11UHC-72750-1375991782178031 Spring St, Miami, FL, 331070.68Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed
ENR-109906ENRLarry X Ortega1967-02-18UHC-85464-5184629043022939 Sage Ct, Plano, TX, 750140.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
ENR-106536ENRHarold F Weber1978-05-20UHC-31261-9883671437086327 Elm St, Tempe, AZ, 852360.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-56824TPAOlivia K Perez1963-04-16——1737 Union St, Tampa, FL, 336890.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
ENR-140519ENRMichael A Padilla1982-03-20UHC-55203-1395076221118386 Pine Dr, Miami, FL, 331360.68Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased
TPA-54128TPAAdam Evans1989-10-10—8297865093—0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58909TPAMateo Simpson1977-01-14UHC-30934-6651249014715376 Broadway, Los Angeles, CA, 900180.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
CLM-412923CLMTimothy Rice1947-03-03UHC-83864-45—4346 River Rd, Plano, TX, 750950.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-430737CLMDorothy Hansen1951-06-26UHC-58649-64—5235 Willow Ct, Gilbert, AZ, 852430.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412959CLMScott U Jordan1965-02-17UHC-14875-5553575792107935 Desert Sky Blvd, Fresno, CA, 937440.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
ENR-107591ENRCarl C Silva1973-05-06UHC-81611-01—7969 Lincoln Way, Denver, CO, 802930.68Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed
ENR-111303ENRJuhn Hudson1999-01-25UHC-10482-82—9203 Broadway, Miami, FL, 331990.68Name split from “Last, First”Phone missing area codeWhitespace trimmedPlaceholder values cleared
ENR-118470ENRCollins T Natalie1957-07-26UHC-61521-4048563654138209 River Rd, Las Vegas, NV0.68Name split from “Last, First”Phone reformattedCity re-casedZIP missing
CLM-403836CLMMark Brown1952-05-07UHC-62184-34—1243 Meadow Ln, Mesa, AZ, 852480.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
ENR-113599ENRKeith A Torres1955-12-22UHC-89886-91—8102 Main St, Houston, TX, 770180.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
ENR-124199ENRMichelle O Hill1945-11-05UHC-12950-3221959163277958 Park Pl, Sacramento, CA, 958600.68Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code
CLM-431985CLMMatthew Greene1950-01-01UHC-91766-10——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-420756CLMJacob Maldonado1996-07-26UHC-78781-64—4546 Ridge Rd Apt 30, San Diego, CA, 921210.68Name split from “Last, First”Date of birth reformattedUnit split from streetPlaceholder values cleared
CLM-432736CLMRichard Lucas1947-06-12UHC-24488-26—6760 Hillcrest Rd, Las Vegas, NV, 891430.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
9,980 rows, page 133 of 200PreviousNext