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-124193ENRRuth Harrison2005-09-04UHC-44564-9535931363357712 Lake View Rd # 642, Orlando, FL, 328490.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-21281PRVLogan N Bell1970-08-22—22475983458447 River Rd Apt 1, Miami, FL, 331450.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-134772ENRZachary G Delgado1993-04-17UHC-61679-399088226788305 Elm St, Las Vegas, NV, 891680.50Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-428236CLMDiane Little1956-02-14UHC-00503-91—9056 Washington St # 639, Orlando, FL, 328450.50Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-129739ENRBrandon V Park1974-03-06UHC-98562-4892329959366348 Ocean Ave, Houston, TX, 770340.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
PRV-27057PRVAaron Nguyen1980-01-03UHC-97529-0926449346967123 Baseline Rd, Minneapolis, MN, 554180.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-431038CLMJeremy Dominguez1972-02-12UHC-31668-7996891358328548 Hillcrest Rd, Mesa, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-409201CLMEvelyn Kelley1980-04-19UHC-08989-78—7191 Park Pl, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104355ENRShirley M Hanson2007-03-04—95731033111453 Camelback Rd, Tucson, AZ, 857810.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119348ENRMason U Pierce1970-10-14UHC-14486-4575841837265979 Maple Ave, San Antonio, TX, 782710.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417429CLMMaria Jenkins1941-07-28UHC-97871-08—771 Ridge Rd, Denver, CO, 802020.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-100773ENRDon H Morris1942-04-15UHC-50338-69—8022 Elm St, San Antonio, TX0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-123494ENRBeverly Romero1963-02-22UHC-08319-0767841324517088 Ocean Ave, Miami, FL, 331820.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429041CLMMei Thompson1980-10-20UHC-34224-4970025223553545 Harbor Blvd, San Antonio, TX, 782320.50Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+3 more
ENR-134303ENRAbigaail Nguyen1983-08-14UHC-73153-328667394037293 Harbor Blvd, Phoenix, AZ, 850900.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-133929ENRTyler E Warren1998-12-20UHC-28073-3374459828601338 Grand Ave, Chandler, AZ, 852410.50Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+3 more
TPA-51486TPADylan Dominguez———3895 Palm Dr, Gilbert, AZ, 852790.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-415598CLMRuth Hall——2722957547470 Apache Blvd, Columbus, OH, 432900.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57531TPAGary Carr1957-05-06UHC-25634-04—9019 Washington St, Scottsdale, AZ, 852090.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-141405ENRMelissa Dominguez1955-10-15UHC-07165-119855304738953 Baseline Rd, Sacramento, CA, 958390.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-106093ENRYuki Burns1954-07-12UHC-79691-4626480570261160 Jefferson Ave # 442, Austin, TX, 787030.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
PRV-25380PRVSantiago Q Warren——2874099329542 Harbor Blvd, Mesa, AZ, 852480.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-134372ENRStephanie Singh1974-07-10UHC-26939-0353834498653553 Ocean Ave, San Diego, CA, 921570.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-129724ENRRobert Q Torres1954-09-05UHC-04834-0550234690115873 Lake View Rd # 793, Chandler, AZ, 852540.50Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-404556CLMSean Moreno1989-08-28UHC-94786-19—8250 Elm St Apt 4, San Diego, CA, 921880.50Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-139195ENREdward E Davis1969-12-02UHC-71730-0522157097163287 River Rd # 623, Sacramento, CA0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-406292CLMNathan Powell1989-03-17UHC-58381-414416767283683 Willow Ct, Seattle, WA, 981770.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105665ENRGeorge V Crewford1976-11-08UHC-99216-3577290358255515 Park Pl Apt 30, Los Angeles, CA, 900500.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130309ENRCarolyn Butler1996-09-24UHC-60274-913125361293116 Meadow Ln Apt 3, Denver, CO, 802500.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-413067CLMStephen Montgumery1975-11-13UHC-57923-64—2336 Church St, Dallas, TX, 752190.50Phone missing area codeStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-55829TPARonald J Snyder1957-07-20——1398 Harbor Blvd, Tampa, FL, 336050.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-129456ENRDorothy Wood1950-05-01UHC-31545-27—7288 Mesa Dr, Jacksonville, FL, 322930.50Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-142717ENRDoris McDonald1977-06-19UHC-00910-815318250759566 Church St, Chandler, AZ, 852030.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105013ENRKathryn Z Edwards1960-06-06UHC-87671-7652995046134681 Ocean Ave, Atlanta, GA, 303820.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-414828CLMHenry V Perkins1980-07-05—45190605105280 Camelback Rd, Miami, FL0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60207TPAJose Cook1954-04-10——7755 Union St, Las Vegas, NV, 891040.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-107926ENRPriya Harvey1989-08-15UHC-41050-4759826117183080 Apache Blvd Apt 31, Dallas, TX0.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-137577ENRGabriel G Riley1973-07-26UHC-30685-6578861894837975 Washington St, Miami, FL, 331400.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124771ENRLucia Franklin1961-12-27UHC-71285-8538596345154600 Ridge Rd, Nashville, TN, 372630.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108973ENRJoe J Hart1969-06-25UHC-94161-6570488068853185 Pine Dr # 174, Jacksonville, FL, 322990.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126228ENRCynthia Jimenez1989-07-14UHC-68580-4097856841517864 Market St, Columbus, OH0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-103456ENRVirginia M Moore1952-11-16UHC-66744-7873663928746835 Pine Dr Apt 26, Miami, FL, 331720.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-111815ENRShirley Hamilton1965-04-13UHC-34685-8620130635787853 Ridge Rd, Atlanta, GA, 303280.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-105977ENRAhmed R Hill1939-10-14UHC-13347-11—6465 Spring St, Tempe, AZ, 852490.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-403651CLMEvelyn Ray1914-10-09UHC-12550-9323132908121967 Camelback Rd Apt 33, Eden Prairie, MN, 553300.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-137913ENRKimberly T Bell2003-09-01UHC-86763-2259790337043424 Central Ave # 416, Tempe, AZ, 852770.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-430950CLMTimothy Robinson1984-01-20—60924185862406 Maple Ave, Miami, FL0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-106775ENRLina R Elliott—UHC-90738-3255777419286169 Lake View Rd, Atlanta, GA, 303230.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-405135CLMSara Pena1957-03-18UHC-34572-9062027557661798 River Rd, Tampa, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62486TPASophia Morgan1989-01-15——504 River Rd, Houston, TX, 770480.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 135 of 2,000PreviousNext