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-121778ENRAhmed Q Black1995-11-24UHC-40100-1056528723754516 Indian School Rd Apt 21, Fresno, CA, 937200.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-121927ENRKimberly L Payne1942-04-07UHC-83579-9193231413094517 Bayshore Dr # 140, Jacksonville, FL0.40Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-103287ENRMargaret E Young1969-06-14UHC-35522-23—7545 Meadow Ln, Tampa, FL, 336640.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-412734CLMEugene Richardson1956-02-08—66033506432383 Camelback Rd, Tucson, AZ, 857700.40Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-124381ENRRalph U Knight1995-10-12UHC-94711-1692396789107040 Palm Dr Apt 2, Denver, CO0.40Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-142645ENRRachel Q Carter1953-11-18UHC-82771-6492882648796729 Grand Ave # 633, San Diego, CA, 921640.40Name split from “Last, First”Two-digit birth yearUnit split from streetEmail lower-cased+2 more
CLM-411251CLMHeather B Webb———4296 Harbor Blvd, Dallas, TX, 752520.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-420409CLMAbigail Jordan1997-10-26UHC-73690-42—3737 Oak St # 136, Denver, CO, 802940.40Name split from “Last, First”SSN last four extractedUnit split from streetState name converted to code+2 more
ENR-114403ENRNatalie A Banks1989-04-09UHC-97535-4964645221477508 Jefferson Ave, Seattle, WA, 981770.40Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53945TPAMike Carter1956-09-01—75427500983476 Bayshore Dr, Columbus, OH, 432350.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-139680ENRAnthony K Martinez1940-08-19UHC-87903-1325067798109406 Ocean Ave, Miami, FL, 331660.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121812ENRAndrew Warren2007-04-07UHC-05787-7767488132815638 Canyon Rd, Jacksonville, FL0.40Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-102236ENRLarry Porter1995-06-19UHC-17643-7728428310182951 Indian School Rd, San Antonio, TX, 782120.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25364PRVEric Hayes———4894 Spring St # 773, Jacksonville, FL, 322640.40Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-417409CLMKimberly Mejia1985-02-21UHC-36570-17—5419 Park Pl, Seattle, WA, 981130.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-126913ENRJennifer Moreno1952-06-03UHC-25859-06—6647 Valley View Dr, Las Vegas, NV, 891330.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-126940ENRAnn Wood1950-12-23UHC-47789-89—2226 Forest Ave, Minneapolis, MN0.40Name split from “Last, First”Phone missing area codeZIP missingGender normalised+2 more
ENR-106803ENRAmy W Rede1945-12-14UHC-39326-2654268167706175 Canyon Rd, Austin, TX0.40Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-406739CLMKelly Richards1995-06-22UHC-61615-48—7406 Pine Dr, Orlando, FL0.40SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-124139ENRRussell F Hanson1997-11-13UHC-68963-8369195144313692 Cedar Ln, Houston, TX, 770040.40Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-105030ENRHiroshi Dominguez1942-06-23UHC-02224-5385946025179789 Central Ave # 962, Orlando, FL, 328500.40Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+2 more
CLM-425510CLMAaron Watkins1967-12-08——7721 Maple Ave, Sacramento, CA0.40Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-101662ENRFrank P Nunez—UHC-16151-75—8405 Maple Ave Apt 12, Tampa, FL, 336580.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-127070ENRPatrick K Gutierrez1994-09-25UHC-40734-6825453556452721 River Rd, Denver, CO, 802010.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-134034ENRCynthia Edwards2001-04-15UHC-03383-3978948547369713 Highland Ave # 916, San Antonio, TX0.40Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27803PRVCynthia D Carlson1997-07-15—37458512584545 Park Pl, Chandler, AZ, 852970.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-135312ENRFatima Oliver1962-01-25UHC-11964-3048750216303457 Harbor Blvd, Miami, FL, 331040.40Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123885ENRGabriiel Gray—UHC-32540-86—1051 Indian School Rd Apt 27, Minneapolis, MN, 554290.40Name split from “Last, First”Date of birth unreadableUnit split from streetStreet suffix standardised+2 more
ENR-142516ENRWillie K Stone2002-08-28UHC-76277-46—2135 Willow Ct, Austin, TX, 787630.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-113106ENRThomas Jensen—UHC-32487-1243399033202508 Maple Ave Apt 6, Mesa, AZ, 852430.40Name re-casedDate of birth missingUnit split from streetZIP+4 trimmed+2 more
TPA-51842TPAJean Gonzales1989-11-19——6660 Lake View Rd, Sacramento, CA, 958530.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-118346ENRMichelle Herreera1970-04-19UHC-13353-75—3581 Ocean Ave Apt 33, Atlanta, GA, 303510.40Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
CLM-405376CLMJeffrey B Valdez———8667 Baseline Rd, Nashville, TN, 372400.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
TPA-52526TPAChristine Elliott1956-03-08——2209 Hillcrest Rd, Charlotte, NC0.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-107585ENR—Junk1949-09-01UHC-94190-9440830158765716 Canyon Rd, Sacramento, CA, 958570.40Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-54858TPAArthur Franklin1949-08-05——350 Lake View Rd Apt 13, Denver, CO, 802890.40Name split from “Last, First”Unit split from streetZIP+4 trimmedGender normalised+2 more
ENR-123962ENRStephen N Brown—UHC-37752-51—2974 Baseline Rd, Austin, TX, 787430.40Name split from “Last, First”Date of birth unreadablePhone missing area codeStreet suffix standardised+2 more
CLM-416896CLMCaol Hall2004-04-28—95797792076376 Desert Sky Blvd Apt 3, Phoenix, AZ, 850180.40Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+2 more
CLM-421084CLMRebecca Carlson———3457 Bayshore Dr, Chandler, AZ, 852420.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-111481ENRVincent Gordon1973-01-03UHC-67709-4125581692671710 Central Ave, Miami, FL0.40Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
ENR-123766ENRRoss H Charles1992-12-15UHC-90074-48—8583 Elm St, Fresno, CA, 937710.40Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
CLM-413187CLMSteven O Wagner1938-02-24UHC-58486-0226494320642800 Highland Ave, Los Angeles, CA0.40Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
CLM-419530CLMAshley B Munoz——5102809704776 Apache Blvd # 350, Nashville, TN, 372820.40Name split from “Last, First”Date of birth unreadableUnit split from streetStreet suffix standardised+2 more
ENR-104046ENRVicky Martinez1938-06-02UHC-68159-11—5310 Baseline Rd, Orlando, FL0.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-122075ENRNancy J Contreras1988-02-04UHC-44710-83—8194 Jefferson Ave # 666, Denver, CO0.40Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-405506CLMMadison Montgomery1976-10-17UHC-92303-01—9194 Broadway # 691, Gilbert, AZ, 852190.40Name re-casedUnit split from streetState name converted to codeZIP+4 trimmed+2 more
ENR-121319ENRAustin Nelson1942-09-21UHC-36547-4294836181869020 Maple Ave Apt 2, Seattle, WA, 981270.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413002CLMAngela Watkins1997-08-02UHC-53758-5855182574882215 Canyon Rd Apt 40, Tampa, FL, 336130.40Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-110100ENRWaletr Spencer1973-03-20UHC-07750-2797592967638981 Valley View Dr, Chandler, AZ, 852280.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-134118ENRAmanda Little1989-06-12UHC-87673-57—8345 Lincoln Way, Mesa, AZ0.40Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
100,000 rows, page 35 of 2,000PreviousNext