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-123091ENRArjun M Carr1967-04-15UHC-90273-7791777054401500 Desert Sky Blvd, Fresno, CA, 937670.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-101141ENRJoan IJunk1949-03-16——573 Willow Ct, Plano, TX, 750010.54Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared+1 more
ENR-102147ENRNathan M Armstrong1942-02-06UHC-15778-11—5140 Highland Ave, Orlando, FL0.54Two-digit birth yearZIP missingGender normalisedWhitespace trimmed+1 more
ENR-110845ENRBarbara H Bishop1979-04-22UHC-14889-8395388478264698 Willow Ct # 585, Mesa, AZ, 852070.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-137685ENRLori P Simpson1941-10-25UHC-23112-1061657507091352 Cedar Ln Apt 7, Austin, TX, 787650.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-106456ENRLinda N Murray1957-10-15UHC-87160-2042366006589085 Washington St Apt 28, Mesa, AZ, 852500.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-109811ENRAbigail N Hicks2001-04-05UHC-46842-79—251 Hillcrest Rd, Seattle, WA, 981760.54Name split from “Last, First”Two-digit birth yearState name converted to codeEmail lower-cased+1 more
ENR-130751ENRRoy Ross1976-06-23UHC-03594-93—2156 Main St, Sacramento, CA, 958960.54Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+1 more
ENR-108006ENRAnn Anderson—UHC-38548-51—3585 Union St, Nashville, TN0.54Name re-casedDate of birth unreadableState name converted to codeZIP missing+1 more
ENR-114815ENRDebbie P Schultz1954-10-18UHC-70429-412169276479944 Lake View Rd, Glendale, AZ, 853300.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-110633ENRKelly Evans1967-07-23UHC-44014-0532349039184597 Sunset Blvd, Houston, TX, 770930.54Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+1 more
ENR-131587ENRMark G Reyes1985-09-11UHC-44839-3662628322175171 Sage Ct Apt 18, Gilbert, AZ, 852040.54Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+1 more
ENR-126190ENRMary X Williams1960-06-08UHC-91552-924679682584975 Mesa Dr, Denver, CO, 802540.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-102774ENRAhmed Gutierrez—UHC-99150-7423367218366178 Forest Ave, Columbus, OH, 432040.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-136903ENRSteven Z Banks1996-02-04UHC-07451-5138943306543470 Bayshore Dr, Eden Prairie, MN, 553480.54Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
ENR-139192ENRMontgomery Judith1999-11-01UHC-20121-6092186157353781 Bayshore Dr, Charlotte, NC, 282530.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-102390ENRAnthony V Hernandez2003-01-03UHC-96290-7466823709438512 Mesa Dr, Scottsdale, AZ, 852690.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-138415ENRNoah D Marquez1954-02-05UHC-44909-1474776869863964 Cedar Ln, Columbus, OH0.54Name split from “Last, First”Two-digit birth yearPhone reformattedZIP missing+1 more
ENR-123681ENRYJunk—UHC-57515-4657934894593912 Central Ave, Los Angeles, CA, 900100.54Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
ENR-133116ENRArthur P Carter1953-09-20UHC-46569-3850485826517582 Washington St, Chandler, AZ, 852720.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-136361ENRAlbert C Delgado1939-08-14UHC-47612-0265944654497963 Meadow Ln Apt 28, Plano, TX, 750950.54Name split from “Last, First”Date of birth reformattedUnit split from streetGender normalised+1 more
ENR-120142ENRJanice U Edwards1951-03-03UHC-49570-052073584379207 Park Pl Apt 30, Dallas, TX, 752390.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-121644ENRJean P Lynch1996-12-23UHC-03327-1773586443715840 Spring St, Sacramento, CA, 958600.54Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+1 more
ENR-141637ENRCamila Cook1993-11-17UHC-38400-9054073923348990 Willow Ct, San Diego, CA, 921840.54Two-digit birth yearSSN last four extractedCity re-casedGender normalised+1 more
ENR-104173ENRAlice Black1953-05-07UHC-76795-83—2038 Camelback Rd, Atlanta, GA, 303910.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-133926ENRBenjamin Brown1979-03-15UHC-21896-7166089417557984 Park Pl, Tempe, AZ, 852090.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-121121ENRSean Allen1967-11-11UHC-74463-6869728926739243 Union St # 273, Seattle, WA0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-135524ENRJames S Banks1999-03-22UHC-39366-9883533431742151 Ocean Ave Apt 1, Nashville, TN, 372800.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
ENR-140457ENRMelissa Patterson1982-09-23UHC-00168-0653779976336288 Harbor Blvd, Austin, TX, 787210.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-111899ENRChristina R Daniels1975-11-09UHC-78180-71—8725 Highland Ave, Orlando, FL, 328780.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-107557ENRJanet H Tran2005-01-12UHC-47381-7144120584276574 Pine Dr, Chandler, AZ, 852680.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-135503ENRHannah Wallace1969-01-26UHC-22335-822517309342693 Union St # 627, San Diego, CA0.54Phone reformattedMember ID reformattedUnit split from streetZIP missing+1 more
ENR-127419ENRStephen M Harrison1955-03-22UHC-14162-8537528473389547 Indian School Rd, San Antonio, TX, 782260.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-138504ENRJason P Herrera—UHC-70832-1953722799344295 Oak St, Sacramento, CA, 958620.54Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
ENR-136781ENRBerbara D Rojas1989-01-04UHC-46818-7838668489205644 Forest Ave Apt 19, Nashville, TN, 372870.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-130456ENRCynthia H Jensen1989-10-18UHC-41535-2143948179921517 Ridge Rd # 408, Denver, CO, 802250.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-133328ENRVirginia Graham1965-09-01UHC-41763-3427645738924205 Indian School Rd, Plano, TX, 750530.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-139232ENRTerry G Wells1979-08-25UHC-40621-574764683172818 Baseline Rd, Minneapolis, MN, 554970.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-110692ENRElijah Brown1957-07-13UHC-79098-8576331068029090 Palm Dr, Miami, FL, 331610.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-111235ENRTyler Thomas1948-08-01UHC-19916-1472372389776416 Pine Dr, San Antonio, TX, 782640.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-117479ENRTerry Stephens1946-12-02UHC-30868-70—156 Indian School Rd, Fresno, CA0.54Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-116958ENRAmanda Cuok1967-05-04UHC-27610-615578452757802 Sage Ct, Miami, FL, 331230.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-135491ENRBryan Bryant1940-08-23UHC-64075-409323895451625 Willow Ct, Chandler, AZ, 852530.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-117173ENRKathryn Moreno—UHC-94649-01—9188 Grand Ave Apt 13, Columbus, OH, 432390.54Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-122957ENRMaria H Baker1972-02-28UHC-25029-7865090383825242 Hillcrest Rd, Nashville, TN0.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-143078ENRAndrew Holmes1963-06-16UHC-90169-7641547916744855 Mountain View Dr, Gilbert, AZ, 852910.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-106211ENRZachary G Jimenez1982-08-04UHC-69199-85—4427 Valley View Dr, Plano, TX, 750100.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-118847ENRJordan Stone1989-11-22UHC-29838-90—2253 Sage Ct, Fresno, CA0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-111584ENRArnold Eugene1945-12-07UHC-30243-3862960559458379 Valley View Dr # 593, Gilbert, AZ, 852040.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-117437ENRCarl Park1963-01-14UHC-65013-1963725633939297 Ocean Ave, Fresno, CA, 937410.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
43,101 rows, page 98 of 863PreviousNext