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
ENR-127232ENRMarilyn Fernandez1945-10-12UHC-92069-1928270253752694 Meadow Ln, Dallas, TX, 752510.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-414594CLM—Junk1963-06-14UHC-45096-59—3449 Forest Ave, Plano, TX, 750170.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-128686ENREthan L Jackson1954-04-10UHC-62313-895583013069801 Main St, San Antonio, TX, 782690.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408906CLMKevin Rice2000-08-06——8670 Main St, Chandler, AZ, 852650.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-112210ENRBrian Bailey1953-03-26UHC-51571-5582396010594358 Indian School Rd, Los Angeles, CA, 900330.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-416966CLMAlice Baliey1959-05-04UHC-91287-15—1607 Union St, Phoenix, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-138313ENRMarcus Hudson1977-06-02UHC-54432-4871773416864570 Oak St, Minneapolis, MN, 554670.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-101871ENRMelissa D Cruz1996-09-15UHC-43441-5372246734088804 Mesa Dr, Gilbert, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-142029ENRCamila I Jensen1989-03-15UHC-92035-13—1928 Canyon Rd, Eden Prairie, MN, 553380.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-126279ENRAndrew Morgan1955-09-21UHC-71082-1647144075519628 Apache Blvd, Glendale, AZ, 853600.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404399CLMNoah Vasquez1962-02-27UHC-16757-75—8356 Camelback Rd # 449, San Antonio, TX0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428687CLMCynthia V Fuller1974-01-03UHC-17057-28—2479 Park Pl, Charlotte, NC0.52Name re-casedTwo-digit birth yearZIP missingGender normalised+2 more
ENR-113603ENRAbigail Y Martinez1967-03-08UHC-84886-9775125229002815 River Rd, Mesa, AZ, 852120.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127143ENRJack X Alvarez1998-07-06UHC-88924-1539194484948357 Cedar Ln, Charlotte, NC, 282680.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405720CLMMary Schmidt1977-05-21——6452 Harbor Blvd, Miami, FL, 331320.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-60905TPADylan F Parker1988-11-15——539 Harbor Blvd, San Diego, CA, 921600.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-407303CLMKayla Graham1955-06-10——1485 Baseline Rd, Columbus, OH, 432880.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
PRV-25261PRVTheresa L Garza1942-10-28——877 Cedar Ln # 244, Atlanta, GA, 303190.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-114650ENRDiana G Boyd1955-04-18UHC-11471-5560882626691473 Sage Ct, San Antonio, TX, 782900.52Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55987TPACarlos P Le1944-10-15UHC-07359-80—7655 Lake View Rd, Charlotte, NC0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107687ENRJudith G Thompson1961-01-17UHC-57935-70—6875 Valley View Dr, Los Angeles, CA, 900200.52Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone missing area code+2 more
PRV-24471PRVFrank F Nelson1997-09-14——9185 Elm St, Chandler, AZ, 852220.52Phone missing area codeSSN last four extractedCity re-casedState name converted to code+2 more
CLM-427302CLMLogan Vargas1965-06-07UHC-17983-8681192874032581 River Rd, Las Vegas, NV, 891390.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404533CLMHiroshi Kelley1950-10-21——2695 Indian School Rd Apt 9, Phoenix, AZ, 850040.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-116624ENRPriya P Morgan1945-08-17UHC-69874-2878527824222195 Lake View Rd, Dallas, TX, 752090.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-125870ENRStephanie Ross1990-12-11UHC-04168-7033629984891376 Ridge Rd, Jacksonville, FL, 322390.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-22463PRVJanet Holmes2001-05-05—76081325715096 River Rd, Las Vegas, NV0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-63004TPAMartha Carpenter2001-04-23——8661 Valley View Dr, Seattle, WA, 981220.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416795CLMElijah Tucker1958-10-28UHC-81872-55—6906 Harbor Blvd, Plano, TX0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59947TPAJuan Banks1967-11-12——9425 Mesa Dr, Fresno, CA, 937620.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401659CLMTimothy Carpenter1991-02-01——9850 Mesa Dr, San Antonio, TX, 782520.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-128101ENRRoonald Guerrero1953-09-22UHC-63884-9681499493208347 Market St, Scottsdale, AZ, 852620.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421708CLMLauren D Montgomery1963-12-10—74283554492528 Desert Sky Blvd Apt 4, Minneapolis, MN, 554950.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418237CLMEdward C Peterson1965-05-18UHC-86064-90—1428 Maple Ave, Orlando, FL, 328890.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-118985ENRKenneth Y Holmes1945-05-17UHC-49321-6692826804435668 Church St, Los Angeles, CA0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-400471CLMMei Harvey1954-12-02——4291 Harbor Blvd, Orlando, FL, 328210.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-124319ENRJacqueline Mason1993-07-08UHC-70522-4680821424735140 Cedar Ln Apt 8, Minneapolis, MN, 554560.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-127035ENRBruce J Wrigt1963-11-10UHC-57010-3631390775381735 Sage Ct, Mesa, AZ, 852050.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-141062ENRRussell F Schultz—UHC-35071-0264989107794539 Market St, Scottsdale, AZ, 852270.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51350TPADiana Reid2000-02-01——9358 Desert Sky Blvd, Sacramento, CA, 958440.52Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+2 more
CLM-404756CLMJesse Gardner1984-12-15UHC-82310-034489826754149 Forest Ave, Los Angeles, CA, 900480.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121520ENRLisa H Rice1975-07-12UHC-13130-09—1330 Ridge Rd, Phoenix, AZ, 850940.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-55698TPARuth W Payne1977-11-16—69680556886794 Church St, Jacksonville, FL, 322900.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-119507ENRChristina Ortega1971-07-03UHC-06273-6147274789912874 River Rd, Tucson, AZ, 857650.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-54908TPAKeith Jones1956-01-16——4325 Church St, Gilbert, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427294CLMCheryl M Pena1992-06-08UHC-77349-09—5459 Valley View Dr, Minneapolis, MN, 554800.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411109CLMAdam Rogers1991-02-14UHC-08320-64—550 Valley View Dr, Tampa, FL, 336790.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-62361TPAJose Williams1949-06-05UHC-68499-83—4096 Oak St, Las Vegas, NV, 891250.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-129934ENRRichard D Kim1945-09-14UHC-66923-3636491125689847 Oak St, Dallas, TX, 752340.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431256CLMAndrew Lopez2007-07-26——6398 Spring St Apt 26, Scottsdale, AZ, 852510.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 184 of 2,000PreviousNext