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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
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
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
ENR-106775ENRLina R Elliott—UHC-90738-3255777419286169 Lake View Rd, Atlanta, GA, 303230.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-116989ENRNicholas Price1942-09-03UHC-89676-44—4129 Maple Ave, Fresno, CA, 937850.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-101568ENREthan Maldonado1970-10-25UHC-81823-6356773781722378 Sunset Blvd, Phoenix, AZ, 850280.50Name re-casedPhone reformattedSSN last four extractedState name converted to code+3 more
ENR-134481ENRCynthia T Robinson1969-08-26UHC-25770-4423341504991360 Meadow Ln, Houston, TX, 770370.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-104787ENRSean Clark1973-12-09UHC-83360-30—6639 Mountain View Dr, Sacramento, CA, 958130.50Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-134319ENRBarbara Richards1996-08-19UHC-03646-0125490378058224 Grand Ave, Tampa, FL0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-123919ENRDiana H Black—UHC-32855-08—4681 Forest Ave, Phoenix, AZ, 850700.50Name split from “Last, First”Date of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
ENR-118488ENRAmanda Shaw—UHC-91321-7286399110507331 Washington St, Columbus, OH, 432560.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104543ENRBetty Alvarez1972-04-14UHC-47990-27—5477 Mountain View Dr, Scottsdale, AZ, 852230.50Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+3 more
ENR-132050ENRKenneth Reynolds1948-05-04UHC-87659-0167835980881528 Jefferson Ave Apt 14, Gilbert, AZ, 852110.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-116625ENRElizabeth N Chapman1944-12-23UHC-12513-3086769775432615 Ridge Rd, San Antonio, TX0.50Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+3 more
ENR-136550ENRMason T Lawrence1946-08-12UHC-62902-1460272104668662 Forest Ave Apt 3, Glendale, AZ, 853080.50Member ID reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
ENR-105859ENRAnna Z Reyes—UHC-62772-759174886248273 Highland Ave, Austin, TX, 787750.50Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+3 more
ENR-131111ENRCamila Rice1963-08-13UHC-37080-0785596837295371 River Rd, Columbus, OH, 432080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109722ENRNatalie W Wang2000-08-13UHC-11557-2748850654065773 Baseline Rd Apt 33, Minneapolis, MN, 554890.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-111855ENRRuth Lewis1970-09-20UHC-46141-6674881330124673 Market St, Sacramento, CA, 958010.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-138385ENRLucia P Ellis1972-09-15UHC-81593-4692978061901316 Sage Ct, Chandler, AZ, 852520.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136786ENRAmber Tran1950-07-23UHC-66499-5021764146897892 Highland Ave # 733, Nashville, TN, 372020.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-120826ENRKeith White1950-05-09UHC-00331-8552293179855603 Jefferson Ave, Denver, CO, 802150.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-136006ENRSharon Williamson—UHC-81879-835442846180938 Camelback Rd, Eden Prairie, MN, 553040.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-106118ENRMary A Wilson2008-01-16UHC-13806-99—5888 Canyon Rd Apt 34, Los Angeles, CA0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-123407ENRFatima S Garza1972-11-26UHC-26672-9373468317731370 Lincoln Way Apt 6, Scottsdale, AZ, 852850.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-141005ENRBruce T Garrett1962-07-12UHC-64079-018223304412383 Central Ave, Miami, FL, 331140.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
ENR-141052ENRThomas M Luna1997-10-20UHC-95083-8788862756904011 Main St # 201, Orlando, FL, 328030.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-122629ENREugene K Parker1988-06-25UHC-32909-2775757222352035 Ocean Ave, Minneapolis, MN0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102596ENRRobert T Chen1981-09-28UHC-20989-0494440412523700 Willow Ct, Las Vegas, NV, 891390.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-117405ENREddie Alvarez1948-01-05——9770 Highland Ave, Fresno, CA, 937450.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-108646ENREmma X Meyer1997-06-18UHC-13185-0922273022955206 Sunset Blvd, Columbus, OH, 432250.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-135217ENRSean X Barnes1988-07-02UHC-81350-5998272990228435 Mesa Dr, Las Vegas, NV, 891540.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120735ENRRonald Li2005-05-05UHC-48215-1832474429867592 Canyon Rd, Chandler, AZ, 852090.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-104861ENRAmber R Lawrence1997-10-14UHC-47479-45—6010 Indian School Rd, San Diego, CA, 921610.50Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedCity re-cased+3 more
ENR-102212ENRKylle Q Wang1939-09-22UHC-43409-2726061720075461 Indian School Rd, Fresno, CA, 937410.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120406ENRSteve I Aguilar1938-03-08UHC-51621-7054739245668456 Baseline Rd, Gilbert, AZ, 852030.50Middle initial moved out of first namePhone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-138726ENRJulia B Lucas1981-07-20UHC-72844-783215592607504 Sunset Blvd, Minneapolis, MN, 554470.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105506ENRDaniel Matthews1942-11-06UHC-84431-1579939577272893 Church St # 942, Tucson, AZ, 857140.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-137593ENRKathy Palmer1986-09-15UHC-42607-4186332790322434 Sunset Blvd Apt 11, Phoenix, AZ, 850690.50Phone reformattedMember ID reformattedSSN last four extractedUnit split from street+3 more
ENR-100558ENRTerry I Martinez1970-10-08UHC-27731-5367238616085456 Park Pl, San Antonio, TX, 782510.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-117769ENRSephen N Miller1973-09-12UHC-27582-633896210901800 Central Ave, Sacramento, CA, 958110.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141123ENRJoe Graham1972-07-05UHC-78221-8881150514068873 Harbor Blvd, Tampa, FL0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117379ENRRyan K Edwards—UHC-00951-1225222587067275 Harbor Blvd, Glendale, AZ, 853670.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141428ENRHannah G Luna1948-02-25UHC-64545-1995747527307909 Spring St, Dallas, TX, 752120.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135044ENRJennifer Bishop1971-11-19UHC-66354-2872993198618524 Lake View Rd # 125, Charlotte, NC, 282650.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
ENR-133032ENRKyle R Allen1975-06-13UHC-18084-5635189176861239 Sage Ct, Tempe, AZ, 852600.50Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
43,101 rows, page 68 of 863PreviousNext