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-131486ENRAaron Holmes1996-05-19UHC-77158-6395086647198374 Palm Dr, Glendale, AZ, 853520.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-127905ENRShirley L Morris1985-03-17UHC-89888-3321828626117543 Canyon Rd, Atlanta, GA0.62Date of birth reformattedPhone reformattedState name converted to codeZIP missing+3 more
ENR-107301ENRBrian X Martin1955-12-12UHC-59137-20—8828 Cedar Ln, Seattle, WA, 981130.62Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-130589ENRVicky G Cook1987-07-25UHC-08669-1683775695642012 Ridge Rd Apt 22, San Antonio, TX, 782400.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-102616ENRScott Z Shaw1943-09-25UHC-47109-165699184977663 Market St, Dallas, TX, 752960.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141845ENRWayne V Dean1988-12-23UHC-74792-2293943664455386 Church St, Plano, TX, 750560.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-134677ENRScott Garcia1938-10-27UHC-93685-32—5651 Market St, Mesa, AZ, 852280.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108625ENREugene G Cox1983-02-14UHC-38773-39920585189728 Spring St Apt 20, Miami, FL, 331050.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-109541ENRLisa J Bryant1997-02-06UHC-10875-8192681846285893 Meadow Ln, Nashville, TN, 372240.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103912ENRSantiago U Montgomery1957-05-16UHC-14592-1955125322876139 Sunset Blvd, Plano, TX, 750470.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-120971ENROlivya D Hunter1948-05-23UHC-36158-752374301747785 Cedar Ln Apt 40, Seattle, WA, 981660.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-114866ENRMaria Y Sngh1987-02-18UHC-25269-4742128766313060 Lincoln Way, Austin, TX, 787900.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-119356ENRCarol Bishop1992-06-15UHC-23853-9329992358848981 Church St, Columbus, OH, 432320.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135516ENRAnna P Ortiz1950-04-27UHC-17770-7249552888437138 Forest Ave, Jacksonville, FL, 322930.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137194ENRDenise D Dominguez1972-05-01UHC-13081-7380451148952833 Palm Dr, Jacksonville, FL, 322760.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142871ENRCarol X Montgomery1940-02-12UHC-00036-5659681472297758 Desert Sky Blvd, Tampa, FL, 336970.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-121898ENRValentina Y Johnson1952-12-16UHC-30272-8678833670919880 Canyon Rd, San Diego, CA, 921910.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-118171ENRAlexis F Peterson1971-06-13UHC-41655-0328627882403155 Camelback Rd, Austin, TX, 787660.62Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
ENR-105955ENRTorres Janet1984-02-13UHC-48740-5659299556834107 Bayshore Dr, Phoenix, AZ, 850140.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112485ENRMargaret L Stone1979-11-12UHC-82032-3550385177905524 Pine Dr, Plano, TX, 750140.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-115160ENRKimberly T Berry1983-04-14UHC-52540-5267798486318813 Apache Blvd, Mesa, AZ, 852260.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120255ENRWalter Aguilar2001-02-15UHC-45116-9290197743332327 Ridge Rd, Dallas, TX, 752470.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-123128ENRJesse Walsh1944-08-24UHC-06548-56—5398 Willow Ct, Seattle, WA, 981510.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111975ENRWillie Stephens1957-11-02UHC-37196-3260051210329514 Maple Ave, Mesa, AZ0.62Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+3 more
ENR-119151ENRJeffrey Morales1946-12-07UHC-24187-9160069024136273 Harbor Blvd, Tempe, AZ, 852460.62Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-128388ENRJustin Maldonado1979-10-04UHC-51965-788946478089199 Washington St, Miami, FL0.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-126660ENRElijah A Willaims1995-05-03UHC-10327-0746553124473403 Valley View Dr, Phoenix, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-101432ENRSandoval P Willie2000-02-15UHC-46612-21—5599 River Rd, Fresno, CA, 937490.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107683ENRRandy Reid1953-07-28UHC-70283-3141434374628551 Washington St, Las Vegas, NV, 891010.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127921ENRRebecca Park1981-01-12UHC-63041-075574085092119 Market St, Fresno, CA, 937580.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111261ENRAnna Mason1996-04-17UHC-83078-5025468204065640 Harbor Blvd, Tucson, AZ, 857810.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-124340ENRBruce R Sanchez1958-03-21UHC-55488-7272449318202162 Hillcrest Rd, Sacramento, CA, 958430.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109186ENRRoy M Burke1983-06-10UHC-62696-4695333279513888 Oak St, Orlando, FL, 328650.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-120095ENRJeremy X Vegga1977-08-14UHC-89426-04—3125 Sunset Blvd, Denver, CO, 802140.62Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+3 more
ENR-112707ENRBishop Kathleen1956-12-25UHC-56849-4645329938289143 Grand Ave, San Antonio, TX, 782060.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131733ENRCharles P Murray1952-01-15UHC-35400-6667032950308544 Apache Blvd, Nashville, TN, 372080.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133441ENRDiego Kennedy—UHC-03807-2041462034936394 Central Ave, Los Angeles, CA, 900710.62Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-103429ENRNatalie Payne1987-09-12UHC-22342-2264937871702230 Palm Dr, Mesa, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-130408ENRJoseph F Rice1940-03-25UHC-28149-3424459732182675 Ocean Ave, Austin, TX0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106241ENRAmanda P Ward1970-02-23UHC-44504-283816714921177 Park Pl, Columbus, OH, 432780.62Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-128679ENRAndrew K Tucker1980-06-07UHC-92091-728538245953336 Indian School Rd, Sacramento, CA, 958420.62Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
ENR-131386ENRWillie G Schmidt2001-04-01UHC-48367-5266862920857045 Desert Sky Blvd, Jacksonville, FL, 322100.62Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-117648ENRBarbara C Edwards1951-10-01UHC-91524-1886996642054467 Ocean Ave, Seattle, WA, 981740.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-106405ENRKayla G Rojas1987-03-19UHC-99967-49—2708 Bayshore Dr, Denver, CO, 802510.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110306ENRChristopher I Santos1995-05-06UHC-66123-933859521845609 Spring St, Eden Prairie, MN, 553320.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102445ENRFrances Ray1988-10-13UHC-36209-5325337958892798 Mesa Dr Apt 34, Charlotte, NC, 282630.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-107547ENRAnna Meyer1938-09-23UHC-27108-4875290640131046 Palm Dr, Houston, TX, 770070.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117446ENREric S Barnes1982-03-02UHC-25921-677614412740927 Palm Dr # 906, Charlotte, NC, 282600.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-133401ENRKevin Warren1988-06-20UHC-45262-7159559161481936 Indian School Rd, Columbus, OH, 432680.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-127443ENRPaul D Benett1970-06-17UHC-74898-509694094238479 Camelback Rd, Austin, TX, 787720.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
43,101 rows, page 141 of 863PreviousNext