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-114075ENREthna Jacobs1943-12-05UHC-87152-4172443544598666 Mountain View Dr, Glendale, AZ0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406338CLMFrank Guzman2006-10-09UHC-66444-28—1500 Spring St, Fresno, CA, 937230.52Name split from “Last, First”Two-digit birth yearState name converted to codePlan code upper-cased+2 more
ENR-124988ENRJuan C Powll1986-03-20UHC-26955-3670772659483389 Pine Dr, Fresno, CA, 937360.52Middle initial moved out of first namePhone reformattedMember ID reformattedSSN last four extracted+2 more
ENR-121198ENRGeorge C Sanchez1970-05-24UHC-75107-9022571964521944 Park Pl Apt 15, Seattle, WA0.52Date of birth reformattedPhone reformattedUnit split from streetState name converted to code+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-116061ENRArjun O Wong1993-08-22UHC-77127-4142939483461565 Sunset Blvd, Gilbert, AZ, 852420.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-127954ENRVictoria G Kelley2004-12-11UHC-58308-81—3826 Washington St, Glendale, AZ, 853210.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-59142TPAKaren Martin1984-04-01——3754 Main St, Miami, FL, 331490.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142495ENRAna N Mendoza—UHC-36196-3355187274962702 Lake View Rd, Atlanta, GA, 303070.52Middle initial moved out of first nameDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-111645ENRMarilyn A Contreras1977-05-23UHC-19912-8938295764401227 Highland Ave, San Antonio, TX, 782650.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-422647CLMPhilip Vasquez1942-01-18UHC-19675-29—1135 Sage Ct, Jacksonville, FL, 322370.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
PRV-24739PRVRivera Logan1976-05-01UHC-27810-9577477955878658 Elm St Apt 11, Phoenix, AZ0.52Date of birth reformattedMember ID reformattedUnit split from streetZIP missing+2 more
ENR-134254ENRJese P Park1950-02-11UHC-31353-2494872256765096 Valley View Dr, Charlotte, NC0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-139045ENRDon Hudson1964-02-07UHC-48273-26—6118 Lake View Rd, Minneapolis, MN, 554440.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-104001ENRAnn O Adams1964-03-09UHC-49487-8994766135654774 Broadway, Scottsdale, AZ0.52Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
CLM-432796CLMStephen C Murray1962-05-26UHC-92761-0181138487024148 Main St, Seattle, WA, 981010.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414320CLMAngela E Woods—UHC-24555-87—3702 Central Ave, Los Angeles, CA, 900470.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-411939CLMKeith Ramirez1954-06-19UHC-39559-25—339 Broadway, Tucson, AZ, 857050.52Name split from “Last, First”City re-casedState name converted to codeGender normalised+2 more
CLM-428368CLMTJunk1991-02-02UHC-14684-42—2259 Union St, Seattle, WA, 981730.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403408CLMVirginia Nelson1942-06-13—33790334835994 Ridge Rd # 606, Tempe, AZ, 852830.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-123399ENRAnthony J Ramirez1948-04-19UHC-63508-4463684777926106 Spring St, Dallas, TX, 752850.52Middle initial moved out of first nameName re-casedPhone reformattedSSN last four extracted+2 more
ENR-134691ENRDennis Warren1969-11-23UHC-83107-2687189280535204 Bayshore Dr, Dallas, TX0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-116002ENRSharon J Duncan1994-04-22UHC-94928-4885867557961226 Mountain View Dr, Gilbert, AZ, 852280.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-104853ENRCole Jack1966-03-02UHC-23453-2633437297453178 Desert Sky Blvd, Seattle, WA, 981970.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-106091ENRScott Q Singh1941-06-19UHC-63799-3443348968452352 Oak St Apt 18, Nashville, TN, 372050.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-106085ENREugene Perkins1991-05-21UHC-74376-0940926401958300 Canyon Rd, San Antonio, TX, 782430.52Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+2 more
CLM-416222CLMDonna Edwards2006-07-13UHC-93006-6939877020807842 Harbor Blvd, Gilbert, AZ0.52Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+2 more
CLM-415975CLMMegan Burton1962-12-19UHC-70543-77——0.52Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+2 more
ENR-136187ENRJoyce V Chapman2007-02-23UHC-27758-5735144924777447 Canyon Rd, Tempe, AZ, 852220.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-51660TPADoris Matthews1944-07-09——8753 Pine Dr, Orlando, FL, 328800.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-124089ENRDenise S Ward1959-07-06UHC-58871-56—8358 Lake View Rd, Miami, FL, 331130.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-103198ENRSandra Morris1976-08-19UHC-98911-1662283487888039 Valley View Dr, Minneapolis, MN, 554280.52Name split from “Last, First”Two-digit birth yearPhone reformattedZIP+4 trimmed+2 more
TPA-52827TPAMason Litle1947-02-26——840 Market St, Gilbert, AZ, 852040.52SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53166TPAPriya U Hunt1992-04-15——9005 Ocean Ave, Denver, CO, 802510.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-56516TPABilly L Little2002-08-12——5327 Canyon Rd, Columbus, OH, 432960.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-51964TPAChuck Jones1950-06-21—60770128161193 Ocean Ave, Mesa, AZ, 852090.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-22066PRVHeather P Wagner1991-12-14UHC-68131-4744734708164720 Canyon Rd, Miami, FL, 331740.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421366CLMNicholas Jacobs—UHC-63369-61—3122 Bayshore Dr, Sacramento, CA, 958210.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-120007ENRRoy K Snyder1975-04-16UHC-03945-17—3787 Jefferson Ave # 531, Seattle, WA, 981510.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-108051ENRDonald Meyer1987-07-10UHC-63332-2985295180135980 Washington St # 386, Columbus, OH, 432110.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-107187ENRBilly J Crawford1958-10-03UHC-98380-2422422059208274 Market St, Sacramento, CA, 958160.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-409804CLMKnight Wayne1983-04-27UHC-95604-13—6599 Market St # 292, Chandler, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-101637ENRJeffrey Q Parker1957-09-12UHC-89349-27—408 Oak St, Orlando, FL, 328580.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-411601CLMChristian U Walker1987-07-26UHC-49864-1335323289314100 Baseline Rd, San Diego, CA, 921120.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113446ENROmar T Matthews1974-12-10UHC-66764-3388834316187558 Washington St Apt 10, Chandler, AZ, 852520.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-125074ENRGerald Little—UHC-94042-5169159416523476 Ocean Ave, Columbus, OH, 432970.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-102391ENRCarolyn Jimenez1943-02-17UHC-13964-6144182283487201 Meadow Ln # 227, Houston, TX, 770540.52Date of birth reformattedUnit split from streetCity re-casedState name converted to code+2 more
PRV-21962PRVJudith K Daniels1940-03-13—5416562075862 Sunset Blvd, Phoenix, AZ, 850150.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-23666PRVDennis Castro2000-05-06—32684423295520 Washington St Apt 16, Miami, FL, 331740.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424089CLMJack Franklin1968-02-01—22243802553069 Mountain View Dr, Tampa, FL, 336400.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
100,000 rows, page 168 of 2,000PreviousNext