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-129712ENREric G Perkins1999-11-12UHC-46947-7951031456533992 Lincoln Way, Dallas, TX, 752290.58Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-118330ENROlivia J Hunt2002-12-18UHC-49329-8623178365711027 Oak St Apt 29, Mesa, AZ, 852410.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-139149ENRKelly H Franklin1964-11-28UHC-27283-77—215 Pine Dr, Dallas, TX, 752640.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-139074ENRCharles Shaw1966-02-13UHC-76406-2773755524728905 Willow Ct, Scottsdale, AZ, 852860.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-118031ENRGabriel A Hudson1940-02-22UHC-76138-3398559864771178 Sunset Blvd, Austin, TX, 787050.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-143064ENRSara T Baker1998-08-02UHC-05605-6631047329339166 Market St, Atlanta, GA, 303310.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-133771ENRJanet Z Yang1971-10-02UHC-47290-1838585844689686 Cedar Ln, Sacramento, CA, 958240.58Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-111690ENRDiego L Parker1984-07-04UHC-95280-4967882044681959 Church St, Los Angeles, CA0.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-139963ENRFrances F Ortega1967-12-23UHC-57356-5063671877855402 Valley View Dr, Charlotte, NC, 282750.58Two-digit birth yearSSN last four extractedGender normalised
ENR-114061ENRVirginia M Freeman1960-09-05UHC-43411-2540769035669052 Cedar Ln, Nashville, TN, 372750.58Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-108664ENRWilliam McDonald1942-03-01UHC-29786-393038461638424 Church St, Fresno, CA, 937180.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-122373ENRDaniel X Jimenez1959-01-18UHC-38087-8425033857245471 Sage Ct, Eden Prairie, MN, 553400.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-111249ENRCheryl Gonzalez1949-08-23UHC-13571-2640430311255689 Spring St, Phoenix, AZ0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-119213ENRArthur D Williams1988-11-19UHC-22670-8384085037076510 Ocean Ave, Gilbert, AZ, 852690.58Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-124777ENRPeter Harris1960-02-13UHC-60151-6070447675794696 Apache Blvd, Columbus, OH, 432070.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-119350ENRRandy Simson1953-11-15UHC-07224-4983029864554237 Camelback Rd, San Antonio, TX, 782580.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-113455ENRLori Coooper1954-12-05UHC-56472-3757271980197740 Washington St, Las Vegas, NV, 891910.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-102832ENRGary Munoz1965-10-25UHC-01867-7373760188158538 Ocean Ave, Nashville, TN, 372250.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-101788ENRDouglas Carlson1939-01-28UHC-97519-33—3127 Washington St Apt 34, Austin, TX, 787180.58Two-digit birth yearUnit split from streetGender normalised
ENR-105044ENRGeorge Li1949-06-15UHC-37341-96—8656 Elm St, Los Angeles, CA0.58Name split from “Last, First”ZIP missingGender normalised
ENR-136280ENRThomas C Chavez1964-11-24UHC-88059-408137306586146 Sunset Blvd, Columbus, OH, 432820.58Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+5 more
ENR-123041ENRJohn Romero1990-02-19—38661656325768 Lincoln Way, Phoenix, AZ0.58Name re-casedDate of birth reformattedPhone reformattedCity re-cased+5 more
ENR-118630ENRPriya A Ford1955-04-27UHC-64152-5765486570263794 Hillcrest Rd, San Diego, CA0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-105402ENRAaron S Larson1996-05-07UHC-81833-8468399198053534 Union St, Nashville, TN, 372560.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-114847ENRGrace K Harrison1956-10-08UHC-04847-634546100957592 Ocean Ave # 488, Mesa, AZ, 852560.58Unit split from streetZIP+4 trimmedGender normalised
ENR-115658ENRJerry Z Smith1960-02-22UHC-94989-3453267502043768 Union St, Tempe, AZ, 852400.58Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-100137ENRFrank L Bell1985-05-03UHC-66685-9993789363293666 Elm St, Seattle, WA, 981960.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-114243ENRSue R Turner1978-10-05UHC-41608-9926948565098534 Main St, Scottsdale, AZ, 852090.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-133726ENRDylan K Alvarez1952-05-02UHC-67671-3952046689231148 Park Pl, Sacramento, CA, 958260.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-141922ENRDigo Dominguez1985-01-01UHC-90646-4166672321383937 Lake View Rd # 689, Austin, TX, 787840.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-105294ENRGregory O Pierce1958-11-16UHC-05854-2331520553968670 Union St, Eden Prairie, MN, 553700.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-110894ENRWayne A Franklin1967-01-01UHC-44075-8249842968008723 Baseline Rd, Tempe, AZ, 852520.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-103839ENRJulie Boyd2003-12-06UHC-44414-0766880570581427 Camelback Rd # 433, Seattle, WA, 981090.58Name split from “Last, First”Unit split from streetZIP+4 trimmed
ENR-119315ENRBrian Reid1948-01-24UHC-56799-6448397647953427 Meadow Ln, Tempe, AZ, 852470.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-137643ENRJooyce Hanson1963-01-25UHC-16292-8259293655547610 Mountain View Dr, Plano, TX, 750190.58Name split from “Last, First”ZIP+4 trimmedGender normalised
ENR-131022ENRJean O Foster1954-01-08UHC-22005-7330224438901817 Lake View Rd Apt 13, Atlanta, GA, 303180.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-125070ENRGregory Pierce1951-01-12UHC-34020-292314566487807 Mesa Dr, Dallas, TX, 752440.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-134565ENRHeather K Pena—UHC-96232-4491555613406554 Baseline Rd, Tucson, AZ, 857080.58Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
ENR-131965ENREmma V Rogers—UHC-68885-1340190852731807 Forest Ave, Tucson, AZ, 857000.58Date of birth unreadablePhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-122015ENRJaniceJunk1981-01-11UHC-29648-88—8146 Lincoln Way, Tucson, AZ, 857360.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-100413ENREmma Z Hill1974-02-09UHC-72136-5498356481555231 Central Ave, Tempe, AZ, 852420.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-131538ENRJack Rose1954-02-02UHC-37958-4582747870531069 Park Pl, Chandler, AZ, 852310.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-129583ENRVictoria Robertson1946-04-04UHC-63552-8773489763157529 Canyon Rd, Denver, CO, 802290.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-128295ENRPeter Z Ford1991-10-23UHC-45344-0348357065503506 Central Ave Apt 35, Columbus, OH, 432490.58Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
ENR-127319ENRChristina J Munoz1957-05-08UHC-25323-5947137022836317 River Rd, Minneapolis, MN, 554040.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-127250ENRCynthia Hill2006-08-21UHC-85055-6120360476673680 Indian School Rd Apt 33, Tucson, AZ, 857540.58Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
ENR-114860ENRJerry Fox1977-06-23UHC-41328-0867388081829700 Camelback Rd, Mesa, AZ, 852450.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-104874ENRJustin Hansen1988-07-23UHC-01798-5923749285817600 Cedar Ln, Phoenix, AZ, 850210.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-142629ENREmma H Maldonado1997-11-02UHC-45716-2364787131992613 Central Ave # 489, San Diego, CA, 921480.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-126210ENRValentina O Maldonado1979-09-28—54657816285268 Camelback Rd, San Diego, CA, 921740.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
43,101 rows, page 114 of 863PreviousNext