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-137007ENRBeverly Gonzalez1995-11-24UHC-10930-8943289479156102 Camelback Rd, Seattle, WA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62684TPALauren Reid———4573 Willow Ct, Los Angeles, CA, 900210.52Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-142137ENRBarbara Hernandez1942-08-22UHC-51058-6589984365647256 River Rd, Glendale, AZ, 853470.52Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-429159CLMJason Z Thompson———1783 Indian School Rd, Nashville, TN, 372410.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-57860TPAGregory Smith1980-08-27——9597 Sage Ct, Charlotte, NC, 282670.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-62454TPAJerry Mendez1963-06-22——5505 Canyon Rd # 908, Las Vegas, NV, 891990.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-109847ENRJudy R Rose1991-12-22UHC-66936-9645388509882851 Sunset Blvd, Minneapolis, MN, 554170.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-431732CLMYuki Williamson—UHC-67835-3425984892704914 Sage Ct, Jacksonville, FL, 322700.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-128107ENRJack Chavez1984-03-24UHC-35215-8165420240612789 Baseline Rd, Eden Prairie, MN, 553790.52Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-408381CLMNicholas Phillips1985-06-03——804 Cedar Ln, Mesa, AZ, 852710.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61993TPAPhilip T Burke1967-07-13——5182 Apache Blvd, Plano, TX, 750680.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426681CLMJudith Larson—UHC-46251-9968364988066318 Sunset Blvd, Columbus, OH, 432370.52Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-116489ENRJanet Mason1993-12-07UHC-60080-69—5646 Highland Ave, Fresno, CA, 937690.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-141752ENRBruce Sandoval1945-12-02UHC-23741-5654962207552479 Mesa Dr, Mesa, AZ, 852820.52Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-430409CLMLucia Campbell1990-05-09UHC-20371-54—8774 Maple Ave, Fresno, CA, 937230.52Date of birth reformattedPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
CLM-421676CLMJanice K Fox1953-01-27——3828 Meadow Ln, Nashville, TN0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-119802ENRDanielle F Kelley2003-01-07UHC-50091-6490424892153285 Forest Ave, Fresno, CA, 937150.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-23803PRVSara Espinoza1997-01-27UHC-90159-047938200340859 Grand Ave, Tempe, AZ, 852010.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-124314ENRNick L Garrett1987-02-16UHC-58324-1089630325588090 Lincoln Way # 428, Tucson, AZ, 857760.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-140984ENRCarlos Thomas1984-08-16UHC-19784-3531030773839622 Washington St, Charlotte, NC, 282700.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-58073TPADenise Ward1959-07-06——8358 Lake View Rd, Miami, FL, 331130.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-138991ENRTim Simmons1957-09-16UHC-07596-2168644416594725 Ocean Ave, Orlando, FL, 328720.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-117899ENRRuth Brooks1962-11-18UHC-73684-254472187387298 Church St, Denver, CO, 802370.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
PRV-22808PRVJordan D Sandoval1984-10-14UHC-19789-28—1497 Bayshore Dr Apt 40, Tempe, AZ, 852290.52Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52099TPAAlbert Espinoza1962-06-23——2343 Central Ave Apt 6, Plano, TX, 750500.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-138740ENRCarol A Shaw2002-10-06UHC-74988-5954471739921968 Willow Ct # 833, Orlando, FL, 328260.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-51624TPAKathryn Wang2007-01-19——7432 Mountain View Dr, Chandler, AZ, 852160.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-54050TPAJoan Gilbert1995-06-14——6266 Valley View Dr # 715, Austin, TX, 787020.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-141305ENRCharles Jimenez1946-02-17UHC-25702-2298155655965023 River Rd # 250, Austin, TX, 787670.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428690CLMLucia Rios1939-04-02——5436 Camelback Rd, Denver, CO, 802480.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
CLM-428691CLMLucia Rios1939-04-02——5436 Camelback Rd, Denver, CO, 802480.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-52193TPAArthur I Contreras1943-10-20UHC-78188-71—3294 Baseline Rd, Jacksonville, FL, 322770.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-411374CLMPamela Burns—UHC-07299-885162417294—0.52Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+2 more
PRV-20942PRVArthur M Hall1938-11-24—2655323170686 Church St, Glendale, AZ, 853600.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-116552ENRCharles Patel1997-03-15UHC-51142-3579945626828381 Hillcrest Rd, Tempe, AZ, 852190.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25025PRVGregory U Woods1998-03-11UHC-74086-93—2736 Oak St, San Diego, CA, 921360.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-101642ENRBobby L Willis1977-09-23UHC-83718-0562072566195788 Camelback Rd, Eden Prairie, MN, 553120.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-407519CLMMelissa Walsh—UHC-81070-1565859286899218 Bayshore Dr, Phoenix, AZ, 850510.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-135294ENRPaul Marquez1949-10-11UHC-66457-34—2834 Indian School Rd # 749, Tampa, FL, 336610.52Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+2 more
ENR-132146ENRMary H Nguyen1990-03-12UHC-55840-85—7858 River Rd, Los Angeles, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-132145ENRMary H Nguyen1990-03-12UHC-55840-85—7858 River Rd, Los Angeles, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-431988CLMAustin Hansen2002-05-16——9390 Lincoln Way, Minneapolis, MN, 554100.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-412805CLMBrittany Hernandez1972-01-22——8092 Washington St, Miami, FL, 331520.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-108140ENRJerry S Meyer1955-02-05UHC-94668-4768188037806076 Pine Dr, Plano, TX, 750710.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118692ENRAdam Green2003-05-12UHC-08215-14—731 Market St, Austin, TX, 787430.52Name split from “Last, First”Phone missing area codeState code upper-casedZIP+4 trimmed+2 more
ENR-130994ENRElijah Alexander2005-04-15UHC-94455-0882134866162219 Palm Dr, Seattle, WA0.52Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-55604TPAChristian West1982-01-14——7534 Sage Ct, Los Angeles, CA, 900370.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-408675CLMMariana L Russell1975-04-08UHC-35952-6071723875879455 Ridge Rd, Nashville, TN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-102111ENRSophia Fox1973-06-20UHC-96989-3249894044105249 Sage Ct, Houston, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109012ENRRuth E Harvey1940-10-13UHC-80628-18—5958 Main St Apt 32, Gilbert, AZ, 852250.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
100,000 rows, page 181 of 2,000PreviousNext