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-427425CLMBradley Elliott1981-03-20——8883 Mesa Dr, Tucson, AZ, 857370.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425711CLMRonald D Morales1948-01-28——2228 Church St, Phoenix, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-115661ENRAlbert L Luna1957-11-14UHC-70680-689658069568908 Pine Dr, Columbus, OH, 432060.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-132796ENRJacob Riley1943-04-26UHC-23169-11—1862 Hillcrest Rd, Seattle, WA, 981790.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-134321ENRBarbara E Dunn—UHC-34994-9842539544878620 Cedar Ln, Miami, FL, 331980.54Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-103102ENRJames K Welch1940-10-26UHC-63981-3725389358062755 Canyon Rd, Austin, TX, 787710.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-103103ENRJames K Welch1940-10-26UHC-63981-3725389358062755 Canyon Rd, Austin, TX, 787710.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-53485TPAMichelle Lee1952-02-03——88 Highland Ave, Charlotte, NC, 282110.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-424899CLMDiego Freeeman1971-12-28UHC-98952-98—3303 Ocean Ave, Glendale, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-405133CLMRichhard Silva2000-07-04——1302 Meadow Ln Apt 23, San Diego, CA, 921430.54Two-digit birth yearPhone missing area codeUnit split from streetWhitespace trimmed+1 more
CLM-410846CLMLaura Powell1969-05-21——3187 Harbor Blvd Apt 27, Eden Prairie, MN0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-112016ENRGloria U Hofffman1978-12-18UHC-25518-9195557564759333 Hillcrest Rd, Minneapolis, MN, 554930.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-139213ENRJoe Chen1947-11-23UHC-65483-4627148425033130 Camelback Rd, Eden Prairie, MN, 553580.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-109106ENRChristine C Rojas1958-09-05UHC-29975-3882122699409123 Spring St, Nashville, TN0.54Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+1 more
CLM-416897CLMCarl Hall2004-04-28UHC-68238-77—6376 Desert Sky Blvd # 229, Phoenix, AZ, 850180.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-64238TPALarry Webb2004-10-23——6503 Church St, Orlando, FL0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-112500ENRMarcus Howell1970-01-07UHC-10024-33—521 Mountain View Dr, Denver, CO, 802400.54Name re-casedPhone missing area codeMember ID reformattedState name converted to code+1 more
ENR-105844ENRMcDonald M Brittany1983-12-04UHC-98964-0591990033569355 Willow Ct # 382, Atlanta, GA0.54Middle initial moved out of first nameDate of birth reformattedUnit split from streetZIP missing+1 more
ENR-140253ENRChristian Gonzales1965-07-03UHC-94858-357919397589457 Park Pl, Las Vegas, NV, 891190.54Name split from “Last, First”Phone reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-120818ENRMegan Ortiz1971-11-08UHC-52814-98—3042 Palm Dr, Columbus, OH, 432020.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-54887TPAJustin Mason2002-01-09—76042262728634 Sunset Blvd, Dallas, TX0.54Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+1 more
TPA-54886TPAJustin Mason2002-01-09—76042262728634 Sunset Blvd, Dallas, TX0.54Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+1 more
ENR-102014ENRSamantha Meyer1992-03-20UHC-98383-4081559488158827 Main St, Chandler, AZ, 852400.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-132940ENRPtaricia E Dominguez1990-10-19UHC-15071-6044877133468768 Canyon Rd, Los Angeles, CA, 900340.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-133930ENRGregory Weber1974-08-25UHC-50200-6350180305494286 Church St # 935, Dallas, TX, 752720.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-102050ENRVincent D Goerge1946-11-07UHC-32875-1555778783612954 Lincoln Way # 206, Phoenix, AZ, 850290.54Phone reformattedUnit split from streetState name converted to codeGender normalised+1 more
ENR-102002ENRRichard N James1952-10-02UHC-64647-0888899763466005 Camelback Rd, Plano, TX, 750430.54Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
ENR-114355ENRSarah Fernandez—UHC-46404-5973942653143509 Willow Ct, Denver, CO0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-135730ENRCatherine R Payne1963-09-07UHC-51686-1067184569541795 Central Ave Apt 40, San Antonio, TX, 782290.54Phone reformattedSSN last four extractedUnit split from streetStreet suffix standardised+1 more
ENR-135587ENRJudith A Jenkins1971-08-10UHC-83319-718803860100253 Highland Ave Apt 9, Phoenix, AZ, 850350.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-115396ENRRandy Z Maldonado1999-08-04UHC-32441-2491939528345269 Church St # 762, Tucson, AZ, 857820.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-141993ENRBilly P Contreras1958-07-26UHC-74899-953096847475556 Mountain View Dr Apt 19, Miami, FL, 331240.54Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+1 more
ENR-120664ENRJeffrey G Sullivan2001-12-17UHC-01818-1044173220718471 Elm St, Houston, TX, 770540.54Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more
CLM-431726CLMAhmed Sims1972-07-07UHC-36382-81—7759 Harbor Blvd, Dallas, TX, 752570.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-117870ENRBobby Watson1949-06-19UHC-95185-4952967799791172 Main St # 977, Denver, CO, 802040.54Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-115224ENRSantiago L Miller1951-02-23UHC-98037-769432530574963 Mountain View Dr, Sacramento, CA, 958930.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-142869ENRAhmed Q Hughes1976-07-24UHC-53596-5127863032657300 Highland Ave, Dallas, TX, 752330.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-116264ENRAmebr G Lawson1962-09-26UHC-27031-7196792140702988 Sunset Blvd, Orlando, FL, 328370.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-119545ENRGloriia D Ramirez2008-09-21UHC-49725-2067356692446554 Highland Ave # 803, Seattle, WA, 981330.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431190CLMTerry Williams1939-10-17UHC-02175-3280362814799227 Cedar Ln # 376, Nashville, TN0.54Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+1 more
TPA-50067TPAEvelyn Singh1976-01-08——9466 Union St, Minneapolis, MN, 554770.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-428409CLMNancy Rojas2007-10-03UHC-59612-318799502293309 Ocean Ave, Austin, TX, 787000.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-24364PRVRyan M Daniels1949-03-16UHC-67026-8329086820032759 Bayshore Dr Apt 13, Glendale, AZ, 853310.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
ENR-141966ENRAnthonny Fields1940-01-11UHC-31593-8365773557315442 Main St, Glendale, AZ, 853890.54Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more
TPA-54273TPAHiroshi Rice———5783 Oak St, Jacksonville, FL, 322710.54Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-107689ENRSofia O Duncan1938-06-28—75764232812365 River Rd, Denver, CO, 802170.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
TPA-56708TPAAnn Gonzalez1960-10-27UHC-34996-4927883622924617 Grand Ave, Sacramento, CA, 958550.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-120240ENRWillam H Thomas1950-10-27UHC-66305-2443769976618887 Palm Dr, Miami, FL0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-114156ENRBryan West—UHC-06733-8798188146835578 Main St, Minneapolis, MN, 554200.54Date of birth unreadableStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-419493CLMBrittany Turnre1962-11-15UHC-11003-49—2023 Pine Dr, Jacksonville, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
100,000 rows, page 215 of 2,000PreviousNext