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-123893ENRAhmed I Adams2001-12-06UHC-61442-8264222621153121 Union St Apt 1, Las Vegas, NV, 891390.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-132161ENRPeter Patel1945-04-20UHC-99963-636857987644981 Union St, Chandler, AZ, 852640.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-138097ENRArjun Hudson1999-04-14UHC-69955-6736638623444237 Sunset Blvd, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-105315ENRNicole Harris1955-08-04UHC-21324-9081298159763260 Cedar Ln, Fresno, CA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-113613ENREmma F Simpson—UHC-99558-8796758758323337 Valley View Dr, Scottsdale, AZ, 852910.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-113099ENRBryan W Lawson2006-03-27UHC-80563-5064988139379354 Pine Dr, Houston, TX, 770710.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133166ENRLawrence U Gutierrez1960-06-19UHC-20067-8584995691597369 Forest Ave, Dallas, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123121ENRFatima Sanchez1985-06-10UHC-51322-7122040033244361 Elm St, Denver, CO, 802380.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-112860ENRValentina T Bryant2007-10-01——2973 Jefferson Ave, Mesa, AZ, 852180.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-114028ENRJonathan R Butler1952-01-17UHC-31719-3763661150929213 Valley View Dr, Orlando, FL, 328520.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-142298ENRAlexis T Nunez1962-05-04UHC-93711-0929298321659582 Grand Ave, Denver, CO, 802100.50Middle initial moved out of first nameDate of birth reformattedPhone reformattedState name converted to code+3 more
ENR-111111ENRMichael Alvarado1981-06-25UHC-14405-57—3038 Baseline Rd # 899, Houston, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-116602ENRAndrea T Sanders1976-03-15UHC-23556-4387566136606103 Market St, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-106460ENRChristina Gomez1971-09-20UHC-11504-2660690015523559 Harbor Blvd, Houston, TX, 770620.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103161ENRBryan Fernendez1985-05-08UHC-38196-0137161411271556 Canyon Rd, Minneapolis, MN, 554320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111107ENRLauren Rberts1985-08-02UHC-80177-29—2732 Palm Dr, Denver, CO, 802160.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-108813ENRGloria E Nichols1998-05-17UHC-58730-814856129268328 Willow Ct # 370, Dallas, TX, 752020.50Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-131605ENRPriya Ford1969-05-03UHC-66719-8023630448146295 Indian School Rd, Denver, CO0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-139147ENRSara Simpson1949-08-27UHC-10556-5624335464794334 Church St # 863, Tampa, FL0.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-110064ENRChristopher Diaz1940-11-27UHC-69730-9346186523433368 Oak St, Mesa, AZ, 852180.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-100342ENRSofia Woods—UHC-13736-2568648548976262 Forest Ave # 867, Chandler, AZ, 852380.50Name re-casedDate of birth unreadablePhone reformattedUnit split from street+3 more
ENR-124621ENRAlexis Peyne2003-05-01UHC-10731-0870895134786949 Market St, Columbus, OH0.50Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
ENR-124622ENRAlexis Peyne2003-05-01UHC-10731-0870895134786949 Market St, Columbus, OH0.50Street suffix standardisedAddress re-casedState name converted to codeZIP missing+3 more
ENR-135115ENRBrian E Stone1973-10-20UHC-93876-6672085770521030 Highland Ave, San Diego, CA, 921380.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-103321ENRMartha I Cox1979-02-18UHC-85585-1893490764771474 Oak St, Columbus, OH, 432320.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103927ENRAustin Warren2008-07-28UHC-54396-7036981484625121 Mesa Dr Apt 30, Tampa, FL, 336250.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-104519ENRGregory H Gordon1957-03-06UHC-03362-9368493429338156 Mountain View Dr # 815, Tempe, AZ, 852690.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-119305ENRTerry X Cook1972-05-04UHC-61203-5327681744441367 Forest Ave, Fresno, CA0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142701ENRAhmed W Hoffman1991-01-20UHC-79652-32—6488 Desert Sky Blvd # 368, Eden Prairie, MN, 553450.50Name re-casedPhone missing area codeMember ID reformattedUnit split from street+3 more
ENR-136873ENRMegan Z Maqruez1990-06-14UHC-86538-0279646739884790 Washington St # 163, Mesa, AZ, 852380.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136874ENRMegan Z Maqruez1990-06-14UHC-86538-0279646739884790 Washington St # 163, Mesa, AZ, 852380.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-103487ENRIsabella E Stone1983-06-14UHC-62989-4178771906357196 Apache Blvd, Scottsdale, AZ, 852450.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
ENR-131072ENRPhilip U Spencer1953-12-04UHC-13092-606415105709238 Highland Ave, Tempe, AZ, 852690.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127943ENREmma Hayes1947-11-22UHC-08659-9343861844407363 Cedar Ln, Charlotte, NC, 282150.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116863ENREryc Phillips1951-12-09UHC-15080-4166885163138796 Ridge Rd, Seattle, WA, 981490.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136970ENRAmy W Greene1973-10-15UHC-32627-2658786995062894 Canyon Rd, Austin, TX, 787070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136161ENRKatherine L Palmer1982-02-11UHC-33792-4235374044094419 Camelback Rd Apt 20, Plano, TX, 750470.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-108669ENRAmber Mejia1973-08-10UHC-47303-9838097041898584 Jefferson Ave # 876, Fresno, CA, 937290.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-129937ENRIsabella Munoz1982-05-16UHC-41188-9993263574064246 Main St # 400, Nashville, TN, 372740.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-109354ENRHenry Jackson1975-09-28UHC-76377-4681392784946258 Forest Ave Apt 7, Columbus, OH, 432540.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-134095ENRKathryn Gray1969-12-14UHC-34431-1362346178516391 Camelback Rd, Scottsdale, AZ, 852130.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-102710ENRBrian G Hamilton1940-08-14UHC-68025-63—7947 River Rd # 235, Scottsdale, AZ, 852270.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-142051ENRHeather Jones1985-02-01UHC-44914-8236654286581863 Lake View Rd, Phoenix, AZ, 850710.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123054ENRSantiago Jimenez1956-04-15UHC-32526-9396262345926514 Central Ave Apt 28, Chandler, AZ, 852600.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102719ENRDiana D Butler—UHC-83959-1034975665071810 Indian School Rd, Scottsdale, AZ, 852940.50Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+3 more
ENR-135782ENRHart S Michelle—UHC-85075-2954899117082271 Lake View Rd, Houston, TX, 770960.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-142445ENRJudith V Sandoval1983-09-26UHC-66168-1987224597285058 Lake View Rd, Charlotte, NC, 282040.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-110605ENRShirley K Ramirez1978-03-10UHC-48562-2341136178557240 Valley View Dr # 940, Tempe, AZ, 852740.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-142159ENRJoan P Kelly2000-02-05UHC-83052-1687943058563036 Washington St, Gilbert, AZ, 852080.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-114486ENRAmy N Woods2006-11-16UHC-17540-2761983997663130 Cedar Ln, Seattle, WA, 981420.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 52 of 863PreviousNext