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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-410572CLMJessica Y Matthews1962-01-06UHC-00779-91—479 Willow Ct, Scottsdale, AZ, 852100.36Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+4 more
TPA-51413TPAJesse Morrison1941-12-22——1714 Bayshore Dr, Charlotte, NC, 282360.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
ENR-130052ENRDebra Hoffman1983-03-20UHC-18077-6357726702927106 Apache Blvd, Tampa, FL0.36Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-107035ENRRoy Sullivan2003-08-27UHC-76918-4250770477478596 Apache Blvd, Las Vegas, NV0.36Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
CLM-419609CLMIsabella Wood1988-12-17——7613 Willow Ct, Denver, CO, 802180.36Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
CLM-419701CLMRoy Fowler—UHC-48092-75—9436 Indian School Rd, Charlotte, NC, 282020.36Name split from “Last, First”Date of birth reformattedDate of birth unreadableStreet suffix standardised+4 more
TPA-53905TPAMelissa Hall1949-09-23——3608 Maple Ave, Miami, FL0.36Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-20365PRVMari Carroll2000-04-04—76580126403988 Camelback Rd, Austin, TX, 787050.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-57391TPAJulie Nunez1944-02-08—32527389964354 Camelback Rd, Nashville, TN, 372870.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424864CLMAshley Cox1973-08-17UHC-39698-8380191723764384 Spring St, Denver, CO0.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-430793CLMLawrence Silva1974-07-17——5164 Canyon Rd, Fresno, CA, 937260.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102483ENREmma A Soto1991-06-25UHC-16810-1240865083347361 Willow Ct # 632, Tampa, FL, 336650.36Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-26256PRVAshley R Peters1941-04-21UHC-83509-1947143976476353 Canyon Rd # 184, Columbus, OH0.36Middle initial moved out of first nameName re-casedPhone reformattedUnit split from street+4 more
CLM-410520CLMEvelyn West1995-12-24UHC-84463-14—1337 Forest Ave, Tempe, AZ0.36Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-419884CLMKen Daniels1952-10-27UHC-07036-99—2545 Palm Dr, Tampa, FL0.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114660ENRMegan Burke1939-06-11UHC-10284-69—5123 Camelback Rd, Phoenix, AZ0.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116006ENRRoger O Bishop1958-03-26UHC-15509-764324305118695 Canyon Rd, Austin, TX, 787980.36Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-102872ENRCheryl Stephens1971-09-11UHC-86703-5133088032757369 Ridge Rd, Dallas, TX, 752560.36Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-122479ENRTorres Kelly1948-09-25UHC-99496-7249588073454174 Ocean Ave, Eden Prairie, MN, 553040.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-55191TPAAndrew Evans1988-10-25UHC-10411-09—4471 Desert Sky Blvd # 396, Nashville, TN, 372430.36Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-60289TPAJacob Cruz1964-06-27—97329910359286 Desert Sky Blvd, Denver, CO0.36Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-130884ENRCarol G Andrews1958-07-25UHC-60572-2349457094568420 River Rd, Houston, TX0.36Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-60767TPADorisJunk1962-04-27——3850 Bayshore Dr, Dallas, TX, 752700.36Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-60878TPAGabriel Robertson1982-10-12——788 Sage Ct, Gilbert, AZ, 852600.36Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-134282ENRCarl T Sims1953-05-05UHC-71488-1352276333422766 Desert Sky Blvd, Plano, TX0.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-23541PRVJerry Jensen1955-08-28UHC-63050-35—4916 Sunset Blvd, Nashville, TN, 372550.36Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-106180ENRAlice Diaz1972-11-25UHC-82251-2450478892361830 Mesa Dr Apt 29, Jacksonville, FL, 322690.36Two-digit birth yearMember ID reformattedSSN last four extractedUnit split from street+4 more
ENR-109911ENRSophia Robinson1953-10-16UHC-79179-78—9439 Oak St # 718, Denver, CO, 802850.36Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+4 more
ENR-135460ENRBrian Rice1964-09-26UHC-93672-6891337229571370 Ridge Rd, Gilbert, AZ, 852640.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26978PRVAndrew Nunez1995-08-24UHC-64434-6221674081916814 Canyon Rd, Houston, TX, 770590.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112394ENRStephanie J Freeman—UHC-23974-4344357424668960 Spring St, Chandler, AZ, 852940.36Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-108125ENRFrank Austin2000-07-18UHC-13200-5638333421485130 Jefferson Ave, Las Vegas, NV, 891890.36Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-141518ENRDiego M Parker2001-04-22UHC-76159-3737990539477998 Cedar Ln, Miami, FL0.36Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110829ENRUJunk2001-06-04UHC-23105-7428295104678683 Oak St, Tempe, AZ0.36Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-411044CLMMei M Hudson1961-05-03UHC-21510-91—6252 Ocean Ave, Tampa, FL0.36Middle initial moved out of first nameName re-casedTwo-digit birth yearCity re-cased+4 more
ENR-113211ENRTyler V Carter1997-10-16UHC-34633-9424676958677468 Lake View Rd Apt 8, Los Angeles, CA, 900550.36Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-142211ENRIsabella K Mendoza—UHC-57834-9360772137172226 Harbor Blvd, Eden Prairie, MN, 553650.36Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
TPA-50863TPAVincent Salazar1995-11-20—84036563685492 Meadow Ln, Eden Prairie, MN, 553350.36Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+4 more
TPA-54385TPAHarold Russell1981-06-04——9253 Palm Dr, Sacramento, CA, 958700.36Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-127634ENRSharon Y Burton—UHC-21748-5066746132915056 Pine Dr # 333, Plano, TX, 750540.36Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+4 more
ENR-127633ENRSharon Y Burton—UHC-21748-5066746132915056 Pine Dr # 333, Plano, TX, 750540.36Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+4 more
CLM-420763CLMRoy Andrews—UHC-51669-56—6594 River Rd, Columbus, OH0.36Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-24118PRVDennis Contreras———1344 Mountain View Dr, Orlando, FL, 328300.36Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
ENR-113993ENRDaine Smith1964-09-06UHC-69977-88—6277 Highland Ave, Denver, CO, 802680.36Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+4 more
PRV-22958PRVRob Phillips1943-11-04—73254720074709 Indian School Rd, Scottsdale, AZ, 852550.36Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-111423ENRAhhmed Porter1967-06-01UHC-71899-0580984766905656 Mountain View Dr, Gilbert, AZ, 852990.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26301PRVSandra Fostre2001-07-19—89177088822551 Pine Dr, Columbus, OH0.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-427494CLMFrances Morales1946-02-05UHC-02273-82—7735 Broadway, Seattle, WA0.36Name split from “Last, First”Address re-casedCity re-casedState name converted to code+4 more
ENR-129959ENRSteven D McDonald2000-11-28UHC-80624-6635194822631739 Canyon Rd, San Diego, CA, 921880.36Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-121232ENRBenjamin V Hunter1963-06-25UHC-63710-502529847639984 Grand Ave, Dallas, TX0.36Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 18 of 2,000PreviousNext