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-129428ENRBrittany Vasquez—UHC-60118-1656024187098014 Baseline Rd, Tampa, FL, 336840.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-120136ENRDanielle L Banks1942-10-19UHC-15373-58715886405738 Forest Ave, Los Angeles, CA0.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-127979ENREugene T Spencer1980-09-06UHC-72821-857877832098480 Bayshore Dr, San Antonio, TX, 782140.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-136244ENRZachary Fuller1969-07-13UHC-64893-75—3951 Market St, Eden Prairie, MN, 553230.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-103320ENRBryan B Estrada1939-02-12UHC-28517-4941766456712929 Valley View Dr, Columbus, OH, 432380.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-122488ENREmily N Johnston1949-03-25UHC-39586-2277461668256047 River Rd, Tempe, AZ, 852120.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-121212ENRNancy B Jones1950-05-18UHC-53125-9598271856686297 Hillcrest Rd # 320, Las Vegas, NV, 891980.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-102393ENRHyroshi I Reynolds1965-06-21UHC-14204-7139352960252054 Sunset Blvd Apt 28, Sacramento, CA, 958970.60Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-122734ENRJudy H Kennedy1943-04-08UHC-53297-0652221679174863 Park Pl Apt 39, Miami, FL, 331660.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-111057ENRDenise Olson1951-05-11UHC-65886-4423745337799865 Maple Ave, Phoenix, AZ, 850640.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139482ENRValenttina Williams1982-09-21UHC-42568-2892865125468185 Mesa Dr, Columbus, OH, 432870.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-138044ENRNancy Martin1947-07-28UHC-66350-7481854492607326 Highland Ave, Tempe, AZ, 852430.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-135744ENRDoris Ryan1981-08-24UHC-04166-3335969099502666 Sage Ct, Minneapolis, MN0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117329ENRSusan Matthews1979-01-19UHC-95229-1920132108639469 Ocean Ave, Charlotte, NC, 282320.60Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-115720ENRSofia Z Castillo1951-06-19UHC-61745-5931937910702371 Willow Ct, Jacksonville, FL, 322410.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-106225ENRJoshua V Brown1993-10-09UHC-57400-213207121797509 Sunset Blvd, Tucson, AZ, 857510.60Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-139864ENRVincent J Simpson1982-02-19—72942116762192 Meadow Ln, Charlotte, NC, 282190.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-142499ENRAmanda Yang1941-10-25UHC-99907-1825752234601855 Baseline Rd, Mesa, AZ, 852370.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118785ENRValentina B Coleman1984-04-09—64086114725143 Market St, Nashville, TN, 372070.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-139298ENRJacob M Jordan1958-09-08UHC-33868-3342167599935985 Lake View Rd, Miami, FL, 331310.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109683ENRBobby Alexander2003-03-28UHC-39102-268218710887711 Mountain View Dr, Tempe, AZ, 852420.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-140978ENRNicole Rojas1952-11-08UHC-59108-2223836352065691 Market St, Jacksonville, FL, 322670.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122107ENRKate Walsh1950-09-28UHC-91901-697788921266356 River Rd, Charlotte, NC, 282540.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131912ENRJrery A Edwards1990-05-14UHC-51204-168338180022922 Union St # 854, Atlanta, GA, 303870.60Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+4 more
ENR-112592ENRKelly Q Lucas1946-08-21UHC-43173-63—8042 Main St, Mesa, AZ, 852610.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-100973ENREdward V George1982-05-08UHC-76499-7578731531989125 Apache Blvd # 424, Houston, TX, 770900.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-142313ENRPriya U Burke1975-02-15UHC-37641-2695666595001398 Ridge Rd, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-142136ENRRachel O Vazuez1983-01-11UHC-21397-3338597294987668 Central Ave, Atlanta, GA, 303270.60Phone reformattedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-102638ENRKimberly Vazquez1971-03-08UHC-88315-802569427753866 Maple Ave, Nashville, TN, 372630.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114578ENRGary Fisher1962-11-10UHC-83061-20—3740 Forest Ave, Dallas, TX, 752440.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-138686ENRGloria Lopez1942-12-10UHC-27080-0466341138641893 Central Ave, Tempe, AZ, 852230.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-102121ENRPamela Gonzales1975-11-08UHC-32319-2945295234139831 Main St, Mesa, AZ, 852800.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-141037ENRJustin Porter2007-06-14UHC-18677-3932875979528304 Jefferson Ave, Los Angeles, CA, 900140.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-102192ENRJoe U Lynch1939-05-17UHC-56172-6756122839483000 Lake View Rd, Fresno, CA, 937190.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-102291ENROmar Z Cruz1940-12-22UHC-43088-14—6656 Desert Sky Blvd, Fresno, CA, 937400.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140271ENRMary Griffin1952-03-24UHC-26289-7362887109483078 Grand Ave, Minneapolis, MN0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-135239ENRAlexander H Stone2007-09-16UHC-33700-3936373464966478 Sunset Blvd, San Diego, CA, 921190.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-119277ENRDenise B Sanchez1994-11-02UHC-02390-9937693882568771 Market St, Scottsdale, AZ, 852930.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118102ENRValentina Green1972-08-04UHC-03315-16—7031 Jefferson Ave, Tucson, AZ, 857770.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129664ENRTimothy Rios1947-03-18UHC-68272-8441159887128728 Sage Ct Apt 36, Miami, FL, 331230.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-114059ENRDiana Reynolds1970-07-19UHC-32272-4493790636526536 Lake View Rd, Fresno, CA, 937000.60Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-124411ENREvelyn Weber1997-01-23UHC-07516-184799553598603 Mesa Dr, Los Angeles, CA, 900680.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138855ENRDylan Davis2006-03-05UHC-30152-4740578947026903 Forest Ave, Tampa, FL0.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115363ENRRalph U Arnold1951-08-10UHC-50091-3874196843181384 Canyon Rd, Plano, TX, 750890.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-137435ENRNancy Miller1980-01-18UHC-71193-3979742384211408 Central Ave, Charlotte, NC, 282680.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132429ENRDaniel Larson1993-07-09UHC-49984-0663895521472456 Market St, Charlotte, NC, 282770.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101367ENRDeborah C Riso1949-06-20UHC-57911-7320590645298210 Mountain View Dr, Las Vegas, NV, 891640.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118700ENRHenry Wells1994-05-08UHC-34465-23—7167 Highland Ave, Scottsdale, AZ, 852160.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-135923ENRRussell E Murray1946-06-02UHC-60882-05—2644 Ridge Rd, Phoenix, AZ, 850340.60Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+4 more
ENR-137594ENRMason Arnold1955-06-19UHC-61970-3165178600785848 Sage Ct, Fresno, CA, 937160.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
43,101 rows, page 133 of 863PreviousNext