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-116255ENRCharlie Soto1980-10-08UHC-26975-033764246105833 Jefferson Ave, Eden Prairie, MN, 553520.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-111309ENRAhmed Peters1946-01-14UHC-83992-2373195676319559 Spring St, Seattle, WA, 981720.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-140415ENRSarah D Simpson1949-03-19UHC-92684-1230250347677775 Valley View Dr # 785, Austin, TX, 787980.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-109270ENRMark K Fisher1990-05-05——585 Spring St Apt 24, Chandler, AZ, 852580.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-109269ENRMark K Fisher1990-05-05——585 Spring St Apt 24, Chandler, AZ, 852580.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-142859ENRJeremy Jacobs1965-10-04UHC-51630-2858782852114442 Meadow Ln, Seattle, WA, 981340.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-115815ENRJerry Y Price1957-10-17UHC-62204-464324037551563 Desert Sky Blvd, Glendale, AZ, 853400.60Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-100485ENRMunoz Elizabeth1982-02-13UHC-40216-61—4165 Willow Ct, Columbus, OH, 432350.60Name re-casedMember ID reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-113015ENRRonald S Hunt1965-02-09UHC-85178-59—2077 Ridge Rd, Scottsdale, AZ, 852760.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130134ENRKimberly P Gutierrez2007-02-14UHC-33455-5474888369527415 Ridge Rd, Jacksonville, FL, 322040.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-125027ENRAnthony Weber1986-11-02UHC-65934-3543072457351777 River Rd, Mesa, AZ, 852770.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-104216ENRTerry Rodriugez1964-02-21UHC-76538-7934926594362114 Ocean Ave, Fresno, CA, 937910.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-104217ENRTerry Rodriugez1964-02-21UHC-76538-7934926594362114 Ocean Ave, Fresno, CA, 937910.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-125663ENRWillie X Martin1953-11-25UHC-69388-7432062062651258 Union St, Nashville, TN, 372560.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-137933ENRVictoria Nunze1991-02-24UHC-10473-0979123793085348 Central Ave, Houston, TX, 770870.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-128668ENRMegan Evans1970-09-20—35922748767587 Market St, Houston, TX, 770910.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103359ENRCatherine Mendez1966-11-23UHC-56577-772997021880125 Church St, San Diego, CA, 921350.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129929ENRRandy Stewart1955-03-05UHC-05456-20—8689 Grand Ave, San Diego, CA, 921370.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-130818ENRFranklin Saarah1979-02-19UHC-19757-4867521350095484 Central Ave, Sacramento, CA0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138236ENREvelyn Grant1977-07-28UHC-10977-2555978067491772 Mountain View Dr # 232, Minneapolis, MN, 554420.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-121532ENRGrace U Soto1948-12-28UHC-03021-42—9467 Harbor Blvd, Chandler, AZ, 852810.60Middle initial moved out of first nameName re-casedMember ID reformattedStreet suffix standardised+4 more
ENR-108810ENRMegan X Le1985-01-07—32374506063665 Washington St, Tampa, FL, 336360.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132604ENRAndrew H Palmer1939-02-02UHC-25445-6847271115524190 Meadow Ln, Sacramento, CA0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115696ENRKimberly I Hunter1983-09-07UHC-75741-7172839964733181 Forest Ave, San Antonio, TX, 782900.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-117241ENRHelen K Morales1959-10-23UHC-42089-7932529170693155 Apache Blvd, Los Angeles, CA, 900260.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-125962ENRTheresa G Ruiz1938-05-07UHC-19329-1488875609105807 Bayshore Dr, Columbus, OH, 432900.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-126565ENRMaria Gonzales1966-05-05UHC-94421-1398159027928457 Cedar Ln, Tempe, AZ, 852870.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110022ENRFrank M Tarn1951-05-03UHC-06995-3368830383991692 Sunset Blvd Apt 27, San Diego, CA, 921490.60Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-107104ENRMarcus Spencer1947-03-27UHC-75217-26—8143 Oak St, Miami, FL, 331270.60Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
ENR-134221ENRRussell L Ruiz1988-10-09UHC-24684-3669446162345862 Jefferson Ave, Sacramento, CA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-103159ENRAlexis N Nguyen1960-09-04UHC-40777-0642476150779279 Forest Ave, Houston, TX, 770400.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108298ENRBilly Lopez1986-07-01UHC-13319-9147663876855763 Hillcrest Rd, Gilbert, AZ, 852020.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-101187ENRRamos M Ryan1957-10-11UHC-44488-0857435132305901 Apache Blvd, Mesa, AZ, 852080.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-107840ENRRachel M West1951-09-13UHC-58253-4923767171446249 Harbor Blvd # 352, Houston, TX, 770670.60Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+4 more
ENR-124878ENRMaggie Banks1980-03-24UHC-08433-75—4041 Market St, Jacksonville, FL, 322340.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133999ENRDorothy R Salazar1992-09-11UHC-11013-3059058306463621 Park Pl, San Antonio, TX, 782580.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123322ENRAmy Boyd1941-04-09UHC-38686-3457932099272242 Indian School Rd, Tampa, FL, 336550.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-125481ENRPhilip Bradley1959-11-21UHC-70449-364068911868411 Sunset Blvd, Mesa, AZ, 852420.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-123063ENRNicole Maldonado2000-01-09UHC-52377-2353169625778288 Bayshore Dr, Orlando, FL, 328010.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141763ENRGary Q Peters1974-05-07UHC-57117-446122374597157 Spring St, Columbus, OH, 432300.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-105355ENRJoshua Mendoza1954-10-27UHC-08725-609532876576650 Valley View Dr, Houston, TX, 770670.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-104002ENRRanyd Ward1980-01-25UHC-24436-3979755444501813 Union St # 905, Plano, TX, 750090.60Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-115764ENRCharlotte Vargas1977-08-08UHC-37948-3194694328703912 Harbor Blvd, Minneapolis, MN, 554710.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116025ENRSarah Sullivan1968-10-17UHC-55633-9830434023804140 Highland Ave # 395, San Diego, CA, 921550.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-135978ENRHannah Z Palmer1971-02-15UHC-66921-3129836097303561 Oak St, Charlotte, NC, 282840.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-108944ENRVirginia Clark1948-02-25UHC-21787-949696052278670 Sage Ct, Glendale, AZ, 853560.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-112074ENRZachary O Nichols1973-09-11UHC-39053-2363449420607771 Harbor Blvd, Atlanta, GA, 303780.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-141931ENRMichael C Kim—UHC-02686-189009701989351 Union St, Austin, TX, 787870.60Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+4 more
ENR-132427ENRAhmed Lewis1992-06-19UHC-65200-1081074771132645 Forest Ave, Columbus, OH, 432090.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-111417ENRDanielle Warren1978-07-03UHC-02346-9521934979844650 Maple Ave, Plano, TX, 750330.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
43,101 rows, page 131 of 863PreviousNext