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-129961ENRKayla Mills—UHC-01587-5288678569193905 Apache Blvd, Miami, FL, 331310.50Name re-casedDate of birth missingPhone reformattedSSN last four extracted+3 more
ENR-129678ENRBetty Cox1944-01-01UHC-09867-5028336299983527 Central Ave, Jacksonville, FL, 322750.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-124204ENRJoshua X Contreras1959-04-17UHC-14116-3831894282568975 Ocean Ave # 849, Denver, CO, 802710.50Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+3 more
ENR-135193ENRAna T Carroll—UHC-84457-1965756247639223 Ridge Rd # 982, San Diego, CA0.50Date of birth reformattedDate of birth unreadablePhone reformattedMember ID reformatted+3 more
ENR-114920ENRCarol Lewis1949-07-22UHC-11461-8728034869272415 Lincoln Way, Las Vegas, NV, 891870.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-134976ENRRalph T Jacobs1999-04-07UHC-82994-1833989603381278 River Rd # 398, Phoenix, AZ, 850900.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-110138ENRAnn G Murray1986-04-18UHC-04228-652434482550847 Maple Ave, Sacramento, CA, 958520.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-105484ENRDylan C Hawkins2003-12-21UHC-82949-4536162350785395 Lincoln Way Apt 7, Tucson, AZ, 857990.50Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-133801ENRJoshua V Rios1968-05-18UHC-07268-3751995776406349 Indian School Rd Apt 35, Charlotte, NC, 282630.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-139999ENRStephen U Herrera1950-05-18UHC-99274-5793041058751373 Park Pl Apt 33, Minneapolis, MN, 554490.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-132343ENRBobby Riley1960-03-26UHC-22969-34—2284 Main St, Denver, CO, 802050.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-141327ENRDiego C Carter1992-04-21UHC-63998-384759726757450 Main St, Eden Prairie, MN, 553820.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
ENR-137696ENRMaria G Hayes1977-08-17—2553187151541 Apache Blvd, Atlanta, GA, 303810.50Middle initial moved out of first nameTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-107378ENRAbby Arnold1980-05-19UHC-79863-6126133354754960 Jefferson Ave Apt 9, Gilbert, AZ, 852320.50Phone reformattedMember ID reformattedSSN last four extractedUnit split from street+3 more
ENR-100929ENRCharlotte Bryant—UHC-51096-9785882005124266 Union St, Denver, CO, 802300.50Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-109883ENRMaria F Cooper1963-02-22UHC-53767-89—7528 Desert Sky Blvd Apt 35, Miami, FL0.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-125966ENRJoshua Walker1948-12-24UHC-45586-7271441196421765 Lincoln Way # 231, Orlando, FL, 328060.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-127834ENRMichelle R Price1983-08-09UHC-08987-6096240082705625 Pine Dr, Glendale, AZ, 853590.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104763ENRJoe Bishop1987-04-18UHC-19037-06706287731469 Highland Ave Apt 8, Tampa, FL, 336780.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-111267ENRRonald Lawrence1981-05-22UHC-29293-4348433793223578 Central Ave, Scottsdale, AZ, 852830.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-139600ENRNicholas J Bishop2008-12-10UHC-32869-3481033793027846 Washington St # 686, Scottsdale, AZ, 852810.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-120983ENRMadison Jenssen2001-08-22UHC-93265-2696648720717460 Baseline Rd, Scottsdale, AZ, 852120.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-104596ENRJonathan T Hanson—UHC-12906-8493842829035052 Washington St, Plano, TX, 750730.50Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
ENR-126010ENRGeorge Valdez1998-11-25UHC-34806-1789091283333498 Church St # 539, Charlotte, NC, 282450.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-108967ENRBryan Mitchell1992-03-14UHC-82450-6986445691836130 Sunset Blvd, Atlanta, GA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-109397ENRAmber D King1944-08-22UHC-33875-3183595050474702 Lake View Rd, Gilbert, AZ0.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142627ENRJuan Snyder1939-04-17UHC-15581-31—7663 Spring St, Las Vegas, NV, 891640.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-125780ENRGerald Z Willis1957-08-12UHC-23329-0381525171307465 Church St, Houston, TX, 770080.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108009ENRAmber M Valdez—UHC-35139-2678097882087773 Highland Ave, Miami, FL, 331030.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-113837ENRDanielle A Ford2006-12-08UHC-47400-4986421547979012 Central Ave, Plano, TX, 750810.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-116191ENRIsabella O Black1988-09-02UHC-19050-028686574633521 Spring St, San Diego, CA0.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-118586ENRRebecca J Perry1949-08-01UHC-79876-1994081426862918 River Rd, Seattle, WA, 981230.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-124266ENRGarry U Perez1980-08-18UHC-00936-2944568951975936 Park Pl, Tempe, AZ, 852980.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-130679ENRAna Thomas1983-07-19—32849167616256 Apache Blvd Apt 13, Tampa, FL0.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-120137ENROmar G Nichols1974-12-28UHC-45484-8750664034521161 Ridge Rd, Denver, CO, 802730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120018ENRSusan Padilla1965-01-07UHC-62689-0622089110438745 Cedar Ln, Glendale, AZ, 853680.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106434ENRKyle Curz—UHC-67404-3374273260304360 Broadway, Glendale, AZ, 853540.50Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone reformatted+3 more
ENR-141923ENRTyler Fisher1970-10-15UHC-12257-4059772420027191 Forest Ave, Fresno, CA, 937960.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-102159ENROlivia F Carter—UHC-78576-0167493289787159 Desert Sky Blvd, San Antonio, TX, 782290.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127517ENRTyler Perry1954-06-03UHC-60694-52—9309 Desert Sky Blvd, San Antonio, TX, 782910.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125620ENRAlice Delgado1984-09-11UHC-45437-5662542104456296 Washington St Apt 18, Minneapolis, MN, 554890.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-102771ENRMarcus M Woods2003-01-14UHC-97464-0856968364925181 Harbor Blvd # 561, Orlando, FL, 328570.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-142321ENREric Castro1948-07-16UHC-70681-72—575 Apache Blvd, Austin, TX0.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-132889ENRBrenda Cruz2006-05-16UHC-82459-6164669855512625 Sunset Blvd, Plano, TX0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137366ENRTerry Hughes2002-02-18UHC-96369-8921589558113241 Valley View Dr, Phoenix, AZ, 850180.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-134405ENRJack Brooks1981-01-26UHC-28522-727917222951391 Market St, Las Vegas, NV, 891940.50Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-114940ENRMary Fields1941-09-09UHC-14826-97—6672 Elm St, Denver, CO, 802380.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-132015ENRFatima Y Stephens1995-07-04UHC-06221-6426444757591103 Main St, Sacramento, CA, 958620.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-108466ENR—Junk1988-10-03UHC-47094-1238432456562590 Sage Ct, Glendale, AZ, 853190.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-114643ENRMaria G Kelly1970-02-25UHC-02887-027049041430478 Spring St, Minneapolis, MN, 554560.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
43,101 rows, page 64 of 863PreviousNext