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-107968ENRDiego Q Kennedy1976-01-23UHC-25490-5543730046714159 Valley View Dr, Eden Prairie, MN, 553970.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-59909TPAGloria Dean———7637 Bayshore Dr, Glendale, AZ, 853950.48Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+4 more
CLM-425206CLMPaul Porter1941-07-27UHC-28456-8424834595164240 Church St, Plano, TX, 750250.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-127629ENRChristina Schmidt1977-07-28UHC-55081-2440492827465231 Lake View Rd, Tempe, AZ, 852050.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-425668CLMAngela Gonzalez1964-02-05—29230595091263 Meadow Ln, Tempe, AZ0.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
TPA-63048TPABetty Marshall1957-11-08UHC-98142-1894191990109766 Mesa Dr Apt 31, Gilbert, AZ, 852120.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-129618ENRTeresa H West1965-11-01UHC-07289-3323926128575088 Main St Apt 8, Mesa, AZ, 852450.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
ENR-138160ENRJohnJunk1997-05-03UHC-54344-8157459861442081 Spring St, Columbus, OH, 432960.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-108019ENRLinda Y Goemz2002-12-22UHC-79026-9583691906472234 Mesa Dr Apt 7, Gilbert, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-127720ENRDennis Park1948-06-15UHC-17765-8962398330775191 Ocean Ave, Charlotte, NC0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-425463CLMTeresa T Powell1981-09-23—82536756256134 Cedar Ln Apt 22, Orlando, FL, 328630.48Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55181TPAKim Vazquez1959-02-18—90355279087007 Church St, Mesa, AZ, 852460.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410493CLMMaria Silva1963-04-08—36077622404127 Church St, Denver, CO, 802490.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-51746TPAJsse Ryan1984-11-25—57475348021048 Mesa Dr, Glendale, AZ, 853030.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-121802ENRMadison Young2002-07-11UHC-76655-9983186364311027 Harbor Blvd # 193, Charlotte, NC, 282090.48Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
ENR-136340ENRJulie Y Bell1987-02-03UHC-17025-4141176141218754 Indian School Rd, Mesa, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-421952CLMSamuel Fisher1970-06-03UHC-59857-8435865462332380 Highland Ave, Seattle, WA, 981110.48Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+4 more
CLM-405637CLMBrandon Snydre1968-12-04UHC-55662-93—8063 Pine Dr # 281, Nashville, TN, 372480.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-409705CLMBrian Reid1972-04-13UHC-22030-1827921205137920 Valley View Dr, Orlando, FL0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416946CLMRalph Montgomery———4474 Sage Ct Apt 36, Mesa, AZ, 852540.48Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+4 more
CLM-418954CLMPeter Washington1952-06-03UHC-58356-44—9079 Meadow Ln, Glendale, AZ, 853870.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139155ENRDan P Richards1988-08-23UHC-49911-5651324509336157 Grand Ave, Austin, TX0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-27293PRVChristopher Contreras1951-12-19UHC-60511-1842097536828960 Main St Apt 14, Las Vegas, NV, 891760.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-102519ENRCharlotte Alexander2001-07-07UHC-58974-577703446462903 Meadow Ln, Houston, TX, 770490.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-431815CLMChharles Clark1989-03-17UHC-21985-1788146927708197 Mesa Dr # 112, Tempe, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-419619CLMVirginia Weaver———5687 Sage Ct, Glendale, AZ0.48Name re-casedDate of birth missingCity re-casedZIP missing+4 more
CLM-401235CLMAmanda G Sullivan1941-09-23—94649078363262 Lake View Rd, Jacksonville, FL, 322410.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-111963ENRTomy E Welhc2007-02-15UHC-45658-1395650185373687 Cedar Ln, Orlando, FL, 328740.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123994ENRYuki Barnes1957-04-03UHC-87254-53779535785363 Willow Ct Apt 27, Tucson, AZ, 857500.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-106138ENRSandra Lwis1994-04-02UHC-69787-0695653292942873 Maple Ave Apt 22, Jacksonville, FL0.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-58706TPAGeorge Delgado1984-05-02——2597 Bayshore Dr Apt 40, Seattle, WA, 981970.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-27585PRVElizabeth Walker1958-11-19UHC-96628-55—8507 Harbor Blvd, Denver, CO0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101772ENRAnna X Anderson1992-10-03UHC-58405-22—7973 Ocean Ave, Phoenix, AZ, 850940.48Middle initial moved out of first nameName re-casedPhone missing area codeStreet suffix standardised+4 more
PRV-20347PRVMark Fox1974-07-18UHC-99909-5929466193522492 Ridge Rd, Minneapolis, MN, 554220.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-129364ENRRebeccca Park1944-01-03UHC-57183-0467857693403555 Oak St Apt 14, Tempe, AZ, 852450.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-123358ENRDoris Cole1979-03-15UHC-59466-15—4228 Canyon Rd, Charlotte, NC, 282090.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-111793ENREric L Wang1977-04-02UHC-97768-3951956755362983 Hillcrest Rd, Los Angeles, CA, 900910.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-404288CLMLori Vega2002-09-02UHC-08440-55—1434 Main St, Plano, TX0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-132935ENRDenise Yang1961-03-26UHC-29623-8335742913321201 River Rd, Tucson, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-132615ENRCarol D Ward1967-07-14UHC-25200-1131182172438635 Palm Dr, Las Vegas, NV, 891590.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102499ENRKatherine Q Montgomery1996-08-07UHC-26954-3793255450906855 Sunset Blvd, Tempe, AZ, 852820.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-60030TPAJacqueline Willsi1998-05-09—63871195461671 Market St, Denver, CO0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-114038ENRValentina Nelson1985-02-09UHC-73808-5243088954107819 Baseline Rd Apt 32, Columbus, OH, 432500.48Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-60176TPARyan Soto2002-11-11——8891 Union St # 361, Tempe, AZ, 852330.48Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-116434ENRWayne A Sanchez1962-10-15UHC-45559-5423939875263186 Harbor Blvd, Los Angeles, CA, 900800.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-22085PRVRalph T Daniels2001-07-07UHC-44422-8861998445113822 Sage Ct Apt 7, Phoenix, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-108638ENRRachel Rivera1971-02-24UHC-18995-25—5236 Oak St, Charlotte, NC0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-60078TPABarbara Collins——9139945612647 Market St, Minneapolis, MN, 554680.48Name split from “Last, First”Date of birth reformattedDate of birth unreadablePhone reformatted+4 more
CLM-418261CLMJonahtan H Ferguson1981-06-09—43027983284690 Forest Ave, Gilbert, AZ, 852760.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-138099ENRKeith P Clark1960-05-21UHC-71395-7688182752435744 Apache Blvd, Seattle, WA, 981980.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 72 of 2,000PreviousNext