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-131717ENRScott N Anderson1987-07-26UHC-38641-4023140120794712 Hillcrest Rd, Glendale, AZ, 853480.56Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased
ENR-113525ENR—Junk1995-08-28UHC-81219-28—7640 Spring St, Scottsdale, AZ, 852900.56Street suffix standardisedAddress re-casedGender normalisedNo usable name (quarantined)
ENR-106414ENRArthur H Harris1984-02-13UHC-20418-2985660584656027 Church St, Scottsdale, AZ0.56Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-142202ENRSharon E Alvarado1977-06-14UHC-10575-8679274240943441 Mountain View Dr, Eden Prairie, MN, 553460.56Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-140079ENREthan Ramos1996-07-20UHC-82654-9054198926946394 Main St, Eden Prairie, MN, 553270.56Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised
ENR-129975ENRHarris Charlotte1983-09-03UHC-33150-5488346423158326 Lake View Rd, Miami, FL, 331900.56SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised
ENR-141096ENRMei P Bishop1982-09-12UHC-14148-9230231989818239 Park Pl Apt 5, Plano, TX, 750210.56Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased
ENR-110733ENRPaul R Kelley1970-01-07UHC-52485-3786067160453925 Hillcrest Rd # 518, Jacksonville, FL0.56Two-digit birth yearPhone reformattedUnit split from streetZIP missing
ENR-103347ENRKeith X Wells1951-03-11UHC-14936-0627490004239270 Camelback Rd, San Antonio, TX, 782870.56Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardisedAddress re-cased
ENR-102820ENRGloria K Romero1963-12-16UHC-06754-11—6990 Sunset Blvd Apt 29, Dallas, TX0.56Unit split from streetState name converted to codeZIP missingPlaceholder values cleared
ENR-140130ENRKathryn Ray—UHC-54991-2193894589839164 Apache Blvd, San Diego, CA, 921750.56Date of birth missingStreet suffix standardisedAddress re-casedGender normalised
ENR-119003ENRSophia Peterson1949-12-06UHC-37400-9493655413572121 Grand Ave, Houston, TX0.56Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing
ENR-114533ENRBrenda Z Reed1998-12-09UHC-48758-6150870303704270 Valley View Dr Apt 33, San Antonio, TX, 782210.56Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased
ENR-118342ENRTom W Watson—UHC-88577-54—7825 Lincoln Way, Phoenix, AZ, 850720.56Name split from “Last, First”Date of birth unreadablePhone missing area codeMember ID reformatted
ENR-110690ENRDonald P McDonald—UHC-51117-14—6074 Baseline Rd, Dallas, TX, 752190.56Name split from “Last, First”Date of birth unreadablePhone missing area codeWhitespace trimmed
ENR-116068ENREdward Z Nichols1997-04-26UHC-26667-4492391423404601 Ridge Rd, Dallas, TX, 752160.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-106749ENRSara Dominguez1993-07-02UHC-80907-68—1562 Oak St, Jacksonville, FL, 322910.56Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code
ENR-125226ENRDiego E Renolds1965-08-28UHC-43474-8678167919163944 Market St, Phoenix, AZ, 850560.56Phone reformattedSSN last four extractedState name converted to codeGender normalised
ENR-131697ENRPaul J Singh1983-03-04UHC-57553-4263050547185711 Union St Apt 25, Seattle, WA, 981860.56SSN last four extractedUnit split from streetState code upper-casedGender normalised
ENR-131696ENRPaul J Singh1983-03-04UHC-57553-4263050547185711 Union St Apt 25, Seattle, WA, 981860.56SSN last four extractedUnit split from streetState code upper-casedGender normalised
ENR-136869ENRSandra Mendoza—UHC-30072-32—2553 Apache Blvd, Sacramento, CA, 958130.56Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised
ENR-142189ENRGeorge N Berry2006-06-25UHC-53417-41—2479 Broadway, San Diego, CA, 921350.56Two-digit birth yearState name converted to codeZIP+4 trimmedWhitespace trimmed
ENR-127786ENRGary Guerrero1985-12-10UHC-18725-7141059451495571 Jefferson Ave, Los Angeles, CA, 900700.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-120868ENRCamila A Marshall—UHC-89742-0633470205236341 Baseline Rd, Phoenix, AZ, 850660.56Date of birth unreadableState name converted to codeGender normalisedWhitespace trimmed
ENR-113703ENRJerry Woods1995-08-03UHC-83700-12—3422 Oak St, Jacksonville, FL, 322800.56Name split from “Last, First”SSN last four extractedState name converted to codePlaceholder values cleared
ENR-127969ENRKathryn P Banks2002-05-26UHC-81761-6573750919697242 Maple Ave Apt 35, Phoenix, AZ, 850160.56Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code
ENR-123837ENR—Junk1996-12-25UHC-68253-14—6487 Sunset Blvd # 848, Orlando, FL, 328660.56Date of birth reformattedPhone missing area codeUnit split from streetNo usable name (quarantined)
ENR-101465ENRAdm Z Torres1994-02-07UHC-94361-6423374499037693 Forest Ave # 677, San Antonio, TX, 782400.56Date of birth reformattedUnit split from streetState name converted to codeZIP+4 trimmed
ENR-135001ENRMatthew D Reyas1955-11-13UHC-49750-83—8544 Central Ave Apt 16, Austin, TX, 787420.56Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased
ENR-140344ENRJudith Morgan1942-12-17UHC-85227-494493674179112 Meadow Ln, Chandler, AZ0.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-137741ENRJohn Banks1954-12-04UHC-23402-4820335751436295 Jefferson Ave, Houston, TX, 770060.56Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised
ENR-141773ENRRyan R Butler2001-07-04UHC-03130-9338756058628043 River Rd, Tucson, AZ0.56Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing
ENR-122641ENRFrances N Moreno1978-09-23UHC-65118-03—3535 Grand Ave, Tempe, AZ, 852890.56Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised
ENR-101570ENRMateo Snyder1984-08-13UHC-26840-1676473979887355 Pine Dr # 524, Dallas, TX, 752400.56Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed
ENR-108547ENRJoan Estrada1989-09-22UHC-34172-3872644513915173 Highland Ave # 435, Nashville, TN, 372980.56Phone reformattedUnit split from streetZIP+4 trimmedGender normalised
ENR-128312ENRAndrea Y Grant1989-02-09UHC-84060-6562424160084241 Baseline Rd, Dallas, TX, 752700.56Phone reformattedState name converted to codeZIP+4 trimmedGender normalised
ENR-121152ENRAngela E Bailey1948-09-23UHC-80041-2874264052638818 Lincoln Way, Atlanta, GA, 303270.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-101691ENRLisa G Soto1954-12-01UHC-72865-7793122853678026 Bayshore Dr, Miami, FL, 331860.56Phone reformattedSSN last four extractedZIP+4 trimmedGender normalised
ENR-122607ENRJerry Richadrson1966-12-11UHC-82086-33—8049 Broadway, Denver, CO, 802140.56Two-digit birth yearPhone missing area codeZIP+4 trimmedWhitespace trimmed
ENR-103346ENRPaul E Lopez1947-02-01UHC-63875-6169136347515959 Sage Ct # 730, Tampa, FL, 336740.56Unit split from streetStreet suffix standardisedAddress re-casedGender normalised
ENR-133631ENRNancy U Peterson1982-01-24UHC-74186-8066750512344126 Highland Ave # 214, Los Angeles, CA, 900520.56SSN last four extractedUnit split from streetStreet suffix standardisedAddress re-cased
ENR-135895ENRBtety U Ruiz1976-10-12UHC-44496-29—4796 Oak St, Plano, TX, 750820.56Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised
ENR-100256ENRAaron O Lawrence1961-02-02UHC-70537-9072657457167528 Apache Blvd, Chandler, AZ0.56Middle initial moved out of first nameStreet suffix standardisedAddress re-casedZIP missing
ENR-138290ENRAdam Fox1964-01-19UHC-51786-3639378261339484 Indian School Rd, Mesa, AZ, 852160.56Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed
ENR-132328ENRPaul Harper1964-03-14UHC-17112-43—7744 Ridge Rd # 529, Scottsdale, AZ, 852090.56Two-digit birth yearPhone missing area codeMember ID reformattedUnit split from street
ENR-130813ENRJason H Flores1986-04-25UHC-47912-6971029455518992 Central Ave Apt 12, Orlando, FL, 328280.56Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
ENR-135871ENRLaura Simpson1948-01-26UHC-59203-2985327447907788 Sunset Blvd Apt 16, Chandler, AZ, 852710.56Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased
ENR-137035ENRAisha Jimenez1974-11-06UHC-92482-0646838401489077 Highland Ave, Minneapolis, MN, 554230.56Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased
ENR-130822ENRSean Davis1949-06-01UHC-58231-3075340791811123 Indian School Rd # 277, Dallas, TX, 752920.56Name split from “Last, First”Unit split from streetGender normalisedWhitespace trimmed
ENR-125500ENRMarilyn Ray1980-11-13UHC-54757-66—6694 Sage Ct, Charlotte, NC0.56Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing
43,101 rows, page 110 of 863PreviousNext