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-138331ENRMegan Jordan—UHC-30587-3333885883912809 Valley View Dr, Atlanta, GA, 303190.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111247ENRBobby O Hanson2001-03-07UHC-43003-2798947918415986 Forest Ave, Houston, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116995ENRCheryl Guzman2008-10-09UHC-71613-4296771662589620 Main St # 128, Minneapolis, MN0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-138668ENRGeorge F Walker2006-09-14UHC-22901-2487294236054176 Washington St, Sacramento, CA, 958640.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-107649ENRRachel G Long1987-01-10UHC-19067-7235372248171076 River Rd Apt 12, Mesa, AZ0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-400938CLMKevin Payne2008-05-06UHC-21244-878747611782288 Spring St, Tucson, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423998CLMFrank L Richards1983-06-28UHC-92254-8638348506097748 Meadow Ln, Jacksonville, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-129432ENRMichael Grant1978-08-20UHC-99299-0360944518705329 Palm Dr, Las Vegas, NV, 891040.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430241CLMAustin Robinson1955-04-05—24399025971519 Ridge Rd, Tampa, FL, 336610.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117151ENRPatrick Perez1975-05-24UHC-74189-6848755718966266 Cedar Ln, Gilbert, AZ0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-425243CLMFerguson Michelle1945-01-23UHC-84132-54—1578 Harbor Blvd, San Antonio, TX, 782700.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-119394ENREmma K Brooks1972-05-01UHC-09562-952039757599453 Canyon Rd, Sacramento, CA0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63329TPAKyle Kennedy1994-02-14—5887905978357 Canyon Rd, Eden Prairie, MN, 553870.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-132266ENRMarcus Q Brown1977-03-14UHC-58114-5825343908553581 Bayshore Dr, Plano, TX, 750450.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-432620CLMWalter Rios1956-10-13UHC-18644-9992035960473523 Broadway Apt 36, Chandler, AZ, 852610.50Name re-casedUnit split from streetCity re-casedState name converted to code+3 more
CLM-432052CLMAbigail Wbeb—UHC-21830-2477671837807718 Harbor Blvd, Chandler, AZ0.50Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-126673ENRLaura Walsh1952-02-18UHC-49583-56—7897 Palm Dr, Plano, TX, 750110.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-406330CLMVictoria Mitchell1952-10-11UHC-81119-5347194958795839 Desert Sky Blvd, Orlando, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136040ENRBarbara F Armstrong—UHC-32868-1877558539344485 Canyon Rd, Dallas, TX, 752600.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-432586CLMJose Walker1967-09-02UHC-06820-75—687 Baseline Rd # 629, Dallas, TX, 752460.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
PRV-21166PRVWillie V Schmidt1942-05-12UHC-28576-152516074968446 Maple Ave Apt 5, Houston, TX, 770300.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-410100CLMTheresa Roberts1951-02-05UHC-10775-373672731143432 Ocean Ave, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-414936CLMTyler Gray2005-10-24——3159 Harbor Blvd # 564, Glendale, AZ0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-128376ENRStephen Bowman1994-02-08UHC-77717-8946154512298981 Pine Dr, Plano, TX, 750800.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-142143ENRAlan Hart—UHC-90707-5742028080585735 Elm St, Denver, CO0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402086CLMThomas V Johnston1982-01-26—95170466772797 Market St, Scottsdale, AZ, 852730.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422589CLMEdwardJunk1994-11-09—23847915381320 River Rd, Seattle, WA, 981540.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64266TPAOlivia Richards1954-07-12——303 Ocean Ave, Tempe, AZ, 852560.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-121845ENRChristopher RJunk1963-03-15UHC-54205-35—5048 Indian School Rd, Las Vegas, NV0.50Street suffix standardisedAddress re-casedState code upper-casedZIP missing+3 more
ENR-142895ENRKenneth Y Black1982-04-26UHC-44296-79—4825 Valley View Dr, Orlando, FL, 328040.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60627TPAGerald Ellis1997-07-28——3286 Washington St, Phoenix, AZ, 850330.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109692ENRStephanie T Bishop1982-12-17UHC-68940-4172770180295282 River Rd, Las Vegas, NV, 891630.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-63203TPAKathryn P Padilla1991-02-26UHC-78549-2368225664055993 River Rd, Gilbert, AZ, 852240.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-424232CLMStephanie Porter1974-01-20——3850 Jefferson Ave, Los Angeles, CA, 900860.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416528CLMMartha Flores—UHC-46994-53—5204 Palm Dr Apt 32, Plano, TX, 750330.50Date of birth missingMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-106856ENRRuht Gray1970-01-21UHC-61211-20—2395 Cedar Ln, Charlotte, NC, 282900.50Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+3 more
ENR-106869ENRDorothy Moreno1944-06-07UHC-95806-4580336582104861 Washington St, Gilbert, AZ, 852390.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-410205CLMJulia Woong1994-10-19UHC-71698-2055530908448868 Main St, Seattle, WA, 981080.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-117600ENRDoris Mendoza1955-09-11UHC-31677-40—1438 Spring St, Houston, TX, 770230.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-23105PRVRuth Ray1953-06-22——3090 Harbor Blvd, Las Vegas, NV, 891140.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-430331CLMChukc X Butler1963-10-19UHC-33196-9384628010307058 Central Ave, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431664CLMJames Porter—UHC-83196-0979338352087495 Ocean Ave, Tempe, AZ, 852530.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52087TPAMei Jordaan——41929147818617 Desert Sky Blvd, Glendale, AZ, 853330.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-133562ENRJack Kennedy1955-03-14UHC-82804-5781198035531930 Valley View Dr, Orlando, FL0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-138347ENRAlan E Nelson1946-12-20UHC-18575-5086520422925466 Canyon Rd, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429202CLMBetty Ray1991-11-10—84862256226922 Cedar Ln # 149, San Diego, CA, 921380.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423567CLMAjun V Howell—UHC-84566-928139412648—0.50Middle initial moved out of first nameDate of birth missingPhone reformattedGender normalised+3 more
ENR-127509ENRJacqueline L Campbell1942-06-26UHC-50807-8734893756481998 Broadway # 806, Seattle, WA, 981190.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
PRV-24607PRVSofia Carpenter1954-12-27UHC-23990-079727895012204 Ocean Ave Apt 9, Dallas, TX, 752710.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-133715ENRBilly L Nuunez2002-05-24UHC-37928-09—3112 Desert Sky Blvd, Miami, FL, 331960.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
100,000 rows, page 113 of 2,000PreviousNext