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-134779ENRJonh D Payne1947-12-01UHC-58602-12—4417 Hillcrest Rd, Atlanta, GA, 303630.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-119222ENRSophia J Howell1982-03-08UHC-19520-7967288648293708 Mountain View Dr, Nashville, TN, 372950.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-106040ENRAmber F White1962-10-21UHC-86611-6882091176472131 Sunset Blvd, Miami, FL, 331050.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-116001ENRDoris Guerrero1951-01-14UHC-32145-6122331368141029 Spring St # 887, Las Vegas, NV0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-137499ENRBilly L Ford—UHC-13141-0141849241435605 Sunset Blvd, Tempe, AZ, 852470.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-131771ENRNathan T Ward1943-08-19UHC-63876-9969625446291774 Bayshore Dr, Gilbert, AZ0.52Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-140174ENRNancy Le1985-02-27UHC-53754-1163623548949375 Washington St, Scottsdale, AZ0.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-106697ENRJonathan P Bell1988-02-22UHC-75396-8965590206714740 Forest Ave, Sacramento, CA0.52Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
ENR-107215ENRRoger D Porter1992-03-10UHC-61167-6234572762445095 Ridge Rd, Chandler, AZ, 852560.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-111624ENRAlice Fox—UHC-49138-6975569182674968 Mountain View Dr, Charlotte, NC0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108975ENRZachary Wallace1994-02-09UHC-31902-2129693097197504 Ridge Rd, Miami, FL, 331090.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100043ENRJulie G Carter1979-07-02UHC-96665-3059390606301136 Desert Sky Blvd, Charlotte, NC, 282920.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-139026ENRBetty Henderson1979-05-25UHC-12907-6876378169175407 Willow Ct, Fresno, CA, 937240.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102106ENRBrittany V Contreras1961-08-02UHC-96678-5753720950274487 Pine Dr, Nashville, TN, 372830.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-142801ENRGeorge Y Ramos1962-03-15UHC-92611-30—2114 Willow Ct Apt 7, Seattle, WA, 981130.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-135645ENRAhmed G Harrison1977-06-08UHC-65862-40—1572 Palm Dr, Minneapolis, MN, 554850.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-114830ENRKimberly Chavez1943-06-23UHC-51576-1655652251363310 Oak St, Charlotte, NC, 282910.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-105279ENRJesse Ryan1984-11-25UHC-71476-43—1048 Mesa Dr, Glendale, AZ, 853030.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140003ENRElijah N Jensen1939-08-12UHC-95595-9489342046568686 Harbor Blvd, Houston, TX, 770090.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-107473ENROlivia Chavez1973-01-15UHC-71126-9161566289285964 Meadow Ln, Atlanta, GA, 303710.52Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more
ENR-104741ENRAaron Brown2000-01-02UHC-60711-0959393378851818 Elm St, Sacramento, CA, 958590.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103918ENRWalter Perry—UHC-37779-0289440103484439 Willow Ct, Nashville, TN, 372710.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-100649ENRAngela Palmer1967-07-24UHC-70076-8775970201198072 Church St, Mesa, AZ0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119899ENRKyle Payne1959-08-12UHC-34802-4750370257066422 Forest Ave, Gilbert, AZ, 852390.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-118770ENRRalph Reed1978-06-03UHC-28797-2932890653056164 Main St, Nashville, TN, 372050.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-120929ENRAlan Mills1998-02-18UHC-85719-06—6345 Church St, Eden Prairie, MN0.52Name re-casedPhone missing area codeCity re-casedZIP missing+2 more
ENR-136258ENRMargaret R Cook1996-09-07UHC-09865-4567036151978085 Grand Ave # 180, Orlando, FL, 328450.52Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+2 more
ENR-112819ENRYuki Lynch1963-06-01UHC-60388-32—1153 Canyon Rd Apt 20, Gilbert, AZ, 852230.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-113964ENRMei Chavez1997-10-09UHC-94469-58—3316 Mesa Dr, Austin, TX, 787990.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115534ENRBeverly Walker—UHC-69135-96—588 Baseline Rd, Orlando, FL0.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-131944ENRDennis H Ford1939-10-12UHC-80301-90—8159 Desert Sky Blvd, Fresno, CA, 937520.52Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
ENR-117737ENREugene T Hanson1955-06-03UHC-51392-8379943569824699 Washington St, Atlanta, GA, 303240.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110439ENRRandy L Murphy1944-02-26UHC-31162-508496614340243 Central Ave, Charlotte, NC, 282500.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-133873ENRAmy J Jacobs1952-01-01UHC-84427-3137098163635267 Main St, San Diego, CA, 921580.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-135603ENRGrace Davis2000-05-18UHC-22284-676634670721436 Spring St, Denver, CO0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121215ENRSara Lee1949-02-03UHC-92684-75—7622 Desert Sky Blvd, Denver, CO, 802980.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-123404ENRSusan Y Herrera—UHC-06139-0766248509511060 Meadow Ln, Las Vegas, NV, 891560.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133390ENRJeff V Soto2006-08-10UHC-86836-12—4743 Desert Sky Blvd, Fresno, CA, 937340.52Two-digit birth yearPhone missing area codeMember ID reformattedStreet suffix standardised+2 more
ENR-136204ENRVictoria F Clark1988-04-08UHC-71043-4439663566409334 Grand Ave, Minneapolis, MN, 554370.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-140759ENRJanice Z Marshall1985-02-22——5578 Bayshore Dr, Sacramento, CA, 958240.52SSN last four extractedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-131029ENRYukki Elliott1992-02-18UHC-02081-1956782898684413 Church St, Chandler, AZ, 852730.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
ENR-103791ENRChristina D Crawford1956-06-26UHC-10362-8942454444435106 Desert Sky Blvd, Eden Prairie, MN, 553100.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-107283ENRHelen Y Nichols1953-01-22UHC-51783-9828226847183877 Washington St, Plano, TX, 750160.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-142725ENRSantiago W McDonald—UHC-59608-3368966737296607 Jefferson Ave, Miami, FL, 331760.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-100146ENRAnna H McDonald1972-03-16UHC-61383-3178375943695798 Union St, Los Angeles, CA, 900150.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-114865ENRJudith M Fox1948-03-11UHC-81588-9342463302483009 Mountain View Dr, Minneapolis, MN0.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-142072ENRGrace C Oliver1954-02-20UHC-79868-4725798876255167 Willow Ct, Gilbert, AZ, 852340.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140372ENRLarry W Hudson—UHC-70621-9553721562167931 Elm St, San Diego, CA, 921610.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-139962ENRSara N Alvarado2003-01-03UHC-48967-8782390927933430 Desert Sky Blvd, Houston, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103323ENROivia R Hughes1985-02-19UHC-11245-9623797197586459 Lake View Rd, Denver, CO, 802280.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 82 of 863PreviousNext