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, junk only, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-107560ENROJunk1991-05-19—33546682492636 Highland Ave, Sacramento, CA, 958890.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105726ENRUJunk1966-03-12UHC-76518-547278331495733 Spring St, Los Angeles, CA, 900890.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131549ENRLori WJunk1951-03-15UHC-50744-7144565177973221 Canyon Rd, Minneapolis, MN, 554060.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-111507ENR—Junk1997-08-09UHC-17258-15—7205 Central Ave, Nashville, TN, 372850.52Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-116535ENRNJunk1959-01-02UHC-04096-4180671981494598 Spring St, Dallas, TX, 752620.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-125990ENREvelynJunk1943-05-11UHC-35484-1854836913404609 Desert Sky Blvd, Tempe, AZ, 852130.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-141235ENR—Junk2002-09-26UHC-55937-6042285731475295 Main St, Mesa, AZ, 852410.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-123012ENRPatricia RJunk1992-08-25UHC-68939-9490897613945270 Highland Ave, Chandler, AZ, 852270.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-109011ENR—Junk—UHC-18966-01—2701 Mesa Dr, Tempe, AZ, 852400.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124986ENRElizabethJunk1985-06-17UHC-07694-8992576537549041 Baseline Rd, Fresno, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-132413ENRIJunk2007-02-06UHC-55057-0567651843527501 Apache Blvd, Seattle, WA, 981630.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119862ENR—Junk1970-03-25UHC-26068-2947251750806252 Valley View Dr, Minneapolis, MN, 554480.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-108250ENRYJunk1949-11-20UHC-71270-8033447360839156 Church St, Tucson, AZ, 857920.52Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
ENR-126267ENRXJunk1994-02-07UHC-72104-0586035194478276 Spring St, Las Vegas, NV0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-126268ENRXJunk1994-02-07UHC-72104-0586035194478276 Spring St, Las Vegas, NV0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121170ENRDonald OJunk1999-01-19UHC-13344-8043769137795902 Broadway # 844, Eden Prairie, MN, 553220.52Name re-casedDate of birth reformattedUnit split from streetGender normalised+2 more
ENR-121484ENRDylanJunk1959-09-19UHC-37245-6725287082998950 Apache Blvd, Houston, TX, 770250.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-110913ENRMatthewJunk1992-09-05UHC-62583-9155275627086539 Highland Ave, Plano, TX, 750360.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-111654ENRBJunk2000-07-15UHC-49072-2453545991226548 Bayshore Dr, Mesa, AZ, 852450.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-115215ENRBJunk1966-06-21UHC-05736-0441173089276799 Desert Sky Blvd, Jacksonville, FL, 322320.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-136633ENRJamesJunk1966-02-24UHC-52508-51—9781 Harbor Blvd, Phoenix, AZ0.52Name re-casedState name converted to codeZIP missingWhitespace trimmed+2 more
ENR-126172ENRAna TJunk1940-12-03UHC-78398-3248232537067129 Washington St, Orlando, FL, 328300.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-104662ENRKelly SJunk2002-11-22UHC-86692-9181834981882310 Highland Ave, Columbus, OH, 432860.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-125183ENRTerryJunk1994-07-21UHC-97302-8437478248981875 Indian School Rd, Dallas, TX, 752540.52Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-139115ENRKJunk1940-07-15UHC-71964-5387378102526331 Ocean Ave, Dallas, TX, 752910.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119223ENRKJunk1971-03-15UHC-94640-273012390145547 Oak St, Plano, TX, 750880.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113707ENRYJunk1945-01-20UHC-61792-31—9312 Indian School Rd, Orlando, FL0.52Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+2 more
ENR-101141ENRJoan IJunk1949-03-16——573 Willow Ct, Plano, TX, 750010.54Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared+1 more
ENR-123681ENRYJunk—UHC-57515-4657934894593912 Central Ave, Los Angeles, CA, 900100.54Date of birth missingPhone reformattedGender normalisedWhitespace trimmed+1 more
ENR-116543ENR—Junk—UHC-13913-4068323536542548 Cedar Ln, Eden Prairie, MN, 553400.54Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-113202ENRPJunk1985-01-23UHC-31708-6494133724762064 Pine Dr, Tempe, AZ, 852180.54Phone reformattedSSN last four extractedGender normalisedWhitespace trimmed+1 more
ENR-136696ENRCaroln QJunk1976-01-16UHC-52262-4454374059572854 River Rd, Dallas, TX, 752350.54Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-137631ENR—Junk1961-01-16UHC-52644-6477542830092216 Oak St, Sacramento, CA, 958500.56Street suffix standardisedAddress re-casedZIP+4 trimmedNo usable name (quarantined)
ENR-113525ENR—Junk1995-08-28UHC-81219-28—7640 Spring St, Scottsdale, AZ, 852900.56Street suffix standardisedAddress re-casedGender normalisedNo usable name (quarantined)
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-122408ENRFJunk1958-08-17UHC-62486-6221140883978094 Market St, Chandler, AZ, 852370.56Street suffix standardisedAddress re-casedGender normalisedNo usable name (quarantined)
ENR-133378ENR—Junk1981-06-26UHC-89323-18—1295 Broadway, Minneapolis, MN, 554920.56Phone missing area codeAddress re-casedGender normalisedNo usable name (quarantined)
ENR-122015ENRJaniceJunk1981-01-11UHC-29648-88—8146 Lincoln Way, Tucson, AZ, 857360.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-137817ENROJunk1961-10-13UHC-77677-0845222818787897 Palm Dr, Nashville, TN, 372760.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-135786ENRDebraJunk1981-02-07UHC-22689-5360692986721474 Ocean Ave, Mesa, AZ0.60Name re-casedPhone reformattedMember ID reformattedCity re-cased+4 more
ENR-124585ENRHeather JJunk1979-10-22UHC-85304-1431572395159293 Apache Blvd, Chandler, AZ, 852400.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-120107ENRRebeccaJunk1958-11-12UHC-46812-6788223717427931 Washington St, Atlanta, GA, 303120.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108266ENRCJunk1953-10-08UHC-26846-5694152820953747 Ocean Ave, San Antonio, TX, 782460.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122129ENR—Junk1978-03-13UHC-39687-1744522929002215 Valley View Dr, Orlando, FL, 328580.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-101820ENRLarryJunk1970-10-10UHC-13292-2831022166916320 Baseline Rd, Eden Prairie, MN, 553580.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-123846ENRAshley YJunk1953-01-27UHC-59839-2627760988524201 Broadway Apt 25, Dallas, TX, 752020.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-135742ENR—Junk1946-07-23UHC-26724-6170474469232736 Lake View Rd, San Antonio, TX, 782940.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-123517ENR—Junk1988-10-04UHC-99904-7798921238727873 Union St, Las Vegas, NV, 891620.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-116598ENRNathanJunk1946-03-25UHC-29005-7037092537135454 Elm St, Los Angeles, CA, 900310.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142501ENRJackJunk1970-07-24UHC-08046-2481674427885407 Camelback Rd, Denver, CO, 802360.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
230 rows, page 2 of 5PreviousNext