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-426896CLMStephen Lawrence1974-12-08UHC-90352-6464421448065363 Park Pl Apt 13, Plano, TX, 750870.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-129913ENRWillie D Matthews1980-12-05UHC-09213-6537378559813400 Forest Ave, San Antonio, TX0.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
PRV-29029PRVBrenda H Gordon1965-06-14—47932388326342 Harbor Blvd # 846, Jacksonville, FL, 322270.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-60922TPASamantha S Adams1997-01-12—61347124506922 Sage Ct, Fresno, CA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139807ENREthan Peters1971-06-14UHC-28291-3587256584344909 Meadow Ln # 261, Seattle, WA, 981520.48Name re-casedTwo-digit birth yearMember ID reformattedUnit split from street+4 more
CLM-419268CLMBradley Powell1958-08-26—50984788461114 Highland Ave, Gilbert, AZ0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-407539CLMVirginia G Yang1988-08-28UHC-41415-62—200 Jefferson Ave, Mesa, AZ, 852870.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-52582TPAMadison Foster1955-03-28——8828 Spring St, Atlanta, GA, 303930.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408895CLMAisha Robinson1961-10-19UHC-79685-7820730042021393 Spring St # 483, San Antonio, TX, 782060.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-131608ENRTerry Obrien1975-01-07UHC-51549-18—4141 Union St, Mesa, AZ, 852440.48Name split from “Last, First”Name re-casedSSN last four extractedStreet suffix standardised+4 more
TPA-59946TPAWilliam Miller1998-08-23—40629114842824 Grand Ave, Miami, FL, 331610.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-137306ENRShirley Y Gordon—UHC-16318-593555738550734 Park Pl, Los Angeles, CA, 900820.48Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-104340ENRPaul Little1984-11-06UHC-44878-8221279819733698 Bayshore Dr, Los Angeles, CA, 900100.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123536ENRLogan Carlson—UHC-21993-1339988601003760 Main St, Mesa, AZ0.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-24218PRVLogan Knight1947-11-19——2515 Oak St, Miami, FL0.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-116350ENREthan Torres1965-03-17UHC-32591-84—7779 Maple Ave, Columbus, OH, 432240.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-111477ENRVirginia J Le1958-01-16UHC-66102-1522387094354073 Forest Ave, Scottsdale, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-139934ENRJessica P Ball1969-08-14UHC-71411-11—262 Spring St, Mesa, AZ, 852160.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-115551ENRPeter George1970-12-27UHC-53360-7065592526047796 Oak St, San Antonio, TX, 782140.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-431586CLMMarilyn G Dominguez1991-04-14UHC-83227-42—6157 Camelback Rd, Fresno, CA, 937450.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-20841PRVKaren White1986-12-06UHC-50270-0596056629019809 Ridge Rd, Jacksonville, FL, 322850.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-137251ENRAaron Gonzalez1962-11-03UHC-18772-4525389120289680 Mountain View Dr, Seattle, WA, 981030.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-406213CLMMaria E Little1969-04-02UHC-16279-83—1839 Apache Blvd, Columbus, OH, 432380.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
PRV-27937PRVTeresa Porter1948-04-03—27839766169635 Maple Ave, Eden Prairie, MN0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403944CLMSean Carter1949-03-08UHC-65097-4273967858957966 Grand Ave, Tucson, AZ, 857190.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111811ENRJustin Anderson1986-12-28—86952677903886 Church St, Glendale, AZ, 853730.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-108954ENRMark T Johnston1981-04-13UHC-91112-5969151837569121 Ridge Rd, Atlanta, GA, 303380.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-129207ENRLuis B Thompson1969-01-01UHC-10698-3260791169125642 Indian School Rd, Chandler, AZ, 852620.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-120778ENRMelissa E James2004-12-15UHC-20496-59—5275 Church St, Los Angeles, CA, 900860.48SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-110474ENRNoah H Clark1948-07-26UHC-89607-2227737092276089 Hillcrest Rd, Seattle, WA, 981210.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-122616ENRShirley Bennett—UHC-38488-5339191418018915 Canyon Rd, Plano, TX, 750240.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115360ENRArthur L Rice—UHC-25386-5458123718634090 Market St, Los Angeles, CA, 900020.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-405123CLMKathleenJunk—UHC-42417-2497387383838881 Pine Dr, Fresno, CA, 937620.48Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+4 more
ENR-126692ENRNoah Yang—UHC-35553-4233934663281662 Main St, Sacramento, CA, 958920.48Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+4 more
ENR-109639ENRBrian G Vazquez1970-07-16UHC-12630-1836466159984314 Washington St, Sacramento, CA, 958310.48Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-106498ENRCatherine X Garcia1965-03-14UHC-49707-14673609332495 Baseline Rd, Chandler, AZ0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-57294TPAZachary Baker1988-07-16——6101 Desert Sky Blvd, Orlando, FL, 328140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-23139PRVCarolyn H Wong1977-01-09—91842508152259 Highland Ave, Sacramento, CA, 958400.48Middle initial moved out of first nameName re-casedTwo-digit birth yearStreet suffix standardised+4 more
PRV-26764PRVCharlotte Hanson1963-05-10—79942572412618 Ridge Rd, Denver, CO, 802720.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-118784ENRPaul D Collins—UHC-68079-9577054654992464 Central Ave, San Diego, CA, 921240.48Date of birth unreadablePhone reformattedCity re-casedState code upper-cased+4 more
CLM-412597CLMKathleen V Brown1994-08-14UHC-43169-47—3092 Sage Ct Apt 8, Orlando, FL, 328540.48Name split from “Last, First”Date of birth reformattedMember ID reformattedUnit split from street+4 more
ENR-112089ENRAnthony Z Herrera1955-09-22UHC-04422-4631835766388996 Apache Blvd, Columbus, OH0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59335TPARandy Carlosn1948-01-28—31146005379624 Baseline Rd, Dallas, TX, 752070.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-137249ENRAnn Bowman1970-06-15UHC-58657-8845084440636414 Ridge Rd, Phoenix, AZ, 850230.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-418701CLMPaul AJunk1953-03-19UHC-85993-86—2801 Grand Ave Apt 18, Fresno, CA, 937390.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-133359ENRGrace Armstrong—UHC-66399-35—6118 Sage Ct, Scottsdale, AZ, 852880.48Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
CLM-432059CLMKevin P Hughes1944-07-02UHC-58283-90—7328 Bayshore Dr # 332, Glendale, AZ, 853190.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
ENR-115316ENRTerry K Coleman1939-09-10UHC-28889-0375535338189252 Lake View Rd, Gilbert, AZ0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-113709ENRAnna Hamilton1947-07-28UHC-64350-0257230823981273 Mesa Dr, Chandler, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-25397PRVTerry A Medina1965-02-08——9633 Sage Ct, Eden Prairie, MN, 553160.48Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 59 of 2,000PreviousNext