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-115274ENRAndrea A Espinoza1995-10-20UHC-38500-6182480331904990 Church St Apt 14, Eden Prairie, MN, 553120.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-142613ENRDouglas L Lucas1944-09-12UHC-56127-3778370589632791 Forest Ave Apt 37, Las Vegas, NV, 891770.50Middle initial moved out of first namePhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-126444ENRDonna Z Mitchell1966-06-07UHC-43058-432985896706723 Camelback Rd, Chandler, AZ0.50Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-139273ENRLawrence D Rojas1948-07-10UHC-94431-484986509324856 Church St, Orlando, FL, 328490.50Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-111394ENRAnthony OJunk1950-11-25UHC-06142-4756934138867510 Camelback Rd, Dallas, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130226ENRMychelle Gordon1948-04-16UHC-80137-39—470 Valley View Dr, Houston, TX, 770490.50Name split from “Last, First”Phone missing area codeMember ID reformattedStreet suffix standardised+3 more
ENR-135944ENRChristian Holmes1951-08-01UHC-55279-9854948752854067 Highland Ave Apt 4, Minneapolis, MN, 554740.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-128320ENREmily A Wagner1940-01-05UHC-20500-138417400837956 Pine Dr, Glendale, AZ, 853070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138354ENRJulie N Gray1940-07-17——9882 Hillcrest Rd, Miami, FL, 331430.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
ENR-114254ENRAmy Soto1985-05-18UHC-23381-5183166484874411 Sunset Blvd, Minneapolis, MN, 554730.50Two-digit birth yearPhone reformattedMember ID reformattedSSN last four extracted+3 more
ENR-142567ENRChristina P Williamson1977-02-26UHC-18331-3832723712182552 Apache Blvd, Minneapolis, MN, 554220.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
ENR-118158ENRAmber R Delgado2007-09-14UHC-82226-0388281465824846 Market St # 531, Chandler, AZ, 852410.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-125561ENR—Junk1969-12-14UHC-90454-5042171335686083 Sage Ct, Glendale, AZ, 853200.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-100625ENRJason Rios1953-06-27UHC-49359-3639343905355658 Pine Dr # 434, Jacksonville, FL, 322630.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-134744ENRKathleen M Miller1944-10-03UHC-61179-1564669733316044 Sage Ct Apt 14, Sacramento, CA, 958340.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-117793ENRAhmed Hayees1995-10-01UHC-59600-2524077238461557 Baseline Rd, Fresno, CA, 937020.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123129ENRBarbara Roberts1972-10-05UHC-93612-27—9857 Oak St Apt 25, Denver, CO, 802150.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115741ENRSophia S Vasquez1947-12-15UHC-21463-60—5478 Canyon Rd Apt 20, Tucson, AZ, 857610.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-142067ENRTimothy Nguyne1947-08-09UHC-94509-4839138940044564 Park Pl Apt 28, Charlotte, NC, 282130.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-115556ENRAndrew Fernandez1948-06-26UHC-04193-0196850997169020 Valley View Dr, Seattle, WA, 981690.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132696ENRKelly F Burton1980-10-12UHC-06398-61—9072 Park Pl, Dallas, TX, 752170.50Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more
ENR-109749ENRPatricia J Kelly1949-02-05UHC-46633-4182541829933338 Ocean Ave, Sacramento, CA, 958040.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112218ENRStephanie Nelson—UHC-79058-71—3566 Canyon Rd, Las Vegas, NV, 891910.50Name re-casedDate of birth reformattedDate of birth unreadablePhone missing area code+3 more
ENR-100753ENRFrances R Wilson—UHC-38544-9735558133649472 Willow Ct, Mesa, AZ0.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124105ENRCamila R Mendoza1965-10-05UHC-35550-9488976573847918 Oak St, Seattle, WA, 981460.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-103188ENRMary Allen1974-10-02UHC-94733-1694360776684111 Grand Ave # 837, Eden Prairie, MN, 553680.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-137061ENRHenry N Peters1977-01-18UHC-77157-4620567918129756 Desert Sky Blvd, Eden Prairie, MN, 553870.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-102713ENRIsabella CJunk2002-03-04UHC-51969-6059532781605677 Sunset Blvd Apt 38, Los Angeles, CA, 900820.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-123733ENRJess Morris1978-02-12UHC-05205-9474794095659584 Apache Blvd, Charlotte, NC, 282330.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-103585ENRAngela O Li1983-11-13UHC-73845-118304998351210 Cedar Ln Apt 9, Denver, CO, 802940.50Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-136032ENRMatthew H Burns1976-12-19UHC-41296-6394582617636941 Pine Dr # 520, Tucson, AZ, 857530.50Name split from “Last, First”Middle initial moved out of first namePhone reformattedUnit split from street+3 more
ENR-110624ENRKimberly K Murphy—UHC-02279-397844893230973 Canyon Rd, Glendale, AZ, 853000.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135416ENRSamantha Z Burke2000-08-27UHC-94001-9478227547638709 Lincoln Way # 146, Minneapolis, MN, 554040.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-118782ENRAmy Castro1983-12-12UHC-26944-4625425227094080 Canyon Rd, Mesa, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110683ENRZachary Harvey2004-08-10UHC-58981-2884261072398928 Apache Blvd, Tempe, AZ, 852390.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-127564ENRDeborah Barnes1995-03-09UHC-31108-3155341121078022 Hillcrest Rd, Minneapolis, MN, 554600.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-137139ENRJames Johnson1955-03-03UHC-45826-69—4782 Main St, San Antonio, TX, 782360.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-113564ENRCarl K Payne1955-10-25UHC-04139-14—3575 Willow Ct, Los Angeles, CA, 900520.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-103376ENRBryan Yang1961-08-06UHC-24123-4833598303238243 Market St Apt 9, Sacramento, CA, 958500.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-130924ENRDoris X Torres1988-08-17UHC-69907-9652439115237807 Sunset Blvd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-143091ENRJacob V Murray1995-11-28UHC-20446-3723347645461235 Highland Ave # 328, Tucson, AZ, 857470.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136498ENRAnthony Myers1978-05-08UHC-74006-3734224055154764 Sunset Blvd # 930, Eden Prairie, MN, 553340.50Name re-casedPhone reformattedSSN last four extractedUnit split from street+3 more
ENR-106744ENRRobert K Boyd2003-05-28UHC-91770-2651496064489733 Highland Ave # 625, Miami, FL, 331680.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-115948ENRHannah Lawrence1956-04-21UHC-97630-8444793702951116 Desert Sky Blvd, Mesa, AZ, 852940.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-130422ENRMichelle Mendez1967-12-20UHC-48161-41—1553 Hillcrest Rd, Sacramento, CA, 958200.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-125696ENRNicole P Luna2006-03-22UHC-74735-6343036911959760 Washington St, Tempe, AZ, 852560.50Middle initial moved out of first namePhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-123745ENRDorothy Austin1949-11-11UHC-48631-1446253374698657 Oak St, Los Angeles, CA, 900680.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140898ENRRaymond C Lee—UHC-27065-5537468310242487 River Rd, Las Vegas, NV, 891710.50Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more
ENR-140899ENRRaymond C Lee—UHC-27065-5537468310242487 River Rd, Las Vegas, NV, 891710.50Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more
ENR-114172ENRJacob Lucas1981-01-16UHC-13277-60—4313 Desert Sky Blvd, Columbus, OH, 432110.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 60 of 863PreviousNext