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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-127814ENRBrenda E Simmons—UHC-70438-09—6890 Spring St, Sacramento, CA, 958820.52Date of birth missingPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-114270ENRKatherine L Bell1997-07-13UHC-91757-8990279140608466 Bayshore Dr, Tempe, AZ, 852650.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-124104ENRBobby Rodrigueez1967-01-04UHC-12282-5995245034082655 Bayshore Dr, Phoenix, AZ, 850520.52Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-106684ENRNathan Jacobs1946-07-04UHC-34860-0493950499353405 Pine Dr # 130, Seattle, WA, 981140.52Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+2 more
ENR-135995ENRJacob C Estrada2006-06-14UHC-26082-1127847911002004 Park Pl, Plano, TX0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-141322ENRNatalie Weaver1974-07-11UHC-92525-8281085546662600 Mountain View Dr, Jacksonville, FL, 322150.52Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-107578ENRJennifer I Vasquez1954-06-14UHC-71721-9344193040628150 Sunset Blvd, Houston, TX, 770990.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-116018ENRDeb N Harper1973-09-28UHC-63588-98—4799 River Rd, Charlotte, NC, 282910.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-134527ENRPatrick D Medina1959-01-12UHC-45150-4864767916088955 Bayshore Dr, Seattle, WA, 981280.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-123979ENRRussell O Robinson1960-03-26UHC-60313-10—4046 Lake View Rd, Eden Prairie, MN0.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-115408ENRCheryl C Hughes1944-05-15UHC-53947-9079243367386375 Mesa Dr, Atlanta, GA, 303990.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-132821ENRCynthia V McDonald—UHC-33327-9769296455371243 Bayshore Dr Apt 14, Denver, CO, 802650.52Name re-casedDate of birth missingMember ID reformattedUnit split from street+2 more
ENR-112321ENRElizabeth Carr—UHC-23409-2377943349874100 Ocean Ave, Charlotte, NC, 282260.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-143003ENRDorothy J Borwn1944-01-28UHC-75100-47—8317 Mountain View Dr, Nashville, TN, 372410.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-141529ENRDoris H Carter1972-06-24UHC-01850-5997297485193192 Cedar Ln Apt 35, Mesa, AZ, 852100.52Name re-casedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-124682ENRJanice Holmes1961-11-07UHC-79640-7732467979558847 Mesa Dr, Tucson, AZ, 857620.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-102803ENRJoyce N Russell1946-09-21UHC-98241-1143268401224220 Canyon Rd, Sacramento, CA, 958860.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140482ENRAndrea Harrison1956-06-22UHC-14709-7541245544781180 Meadow Ln, Phoenix, AZ, 850540.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129675ENRAngela R Johnston2004-11-02UHC-84941-1126455900132218 Apache Blvd, Nashville, TN, 372760.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100345ENRShirley D Reynolds1973-09-12UHC-14074-32—6472 Desert Sky Blvd, Houston, TX, 770240.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-105099ENRJessiac O Carter1950-09-14UHC-93972-21—4008 Indian School Rd, Jacksonville, FL0.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135816ENRAlexander Obrien1970-05-20UHC-27163-894972713147618 Sage Ct, Columbus, OH, 432360.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-109202ENRKathleen Li1966-09-10UHC-10889-86—3196 Sage Ct, Tampa, FL, 336540.52Date of birth reformattedPhone missing area codeSSN last four extractedState name converted to code+2 more
ENR-140265ENRGary M Willis1986-05-06UHC-32252-9597533477244272 River Rd, Miami, FL, 331950.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-124704ENRAmy H Taylor1947-07-05UHC-08045-4151426747765915 Pine Dr, San Diego, CA, 921260.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-122477ENRJordan A Ford1978-07-12UHC-27315-4197829920781158 Oak St, Minneapolis, MN, 554270.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118650ENRZachary Aguilar1985-09-04UHC-72976-9366258721879862 Palm Dr, San Diego, CA, 921890.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-109074ENRMateo Lopez1978-04-21UHC-64208-9573972978592923 Desert Sky Blvd, Dallas, TX, 752220.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126415ENRJacqueline Evans1967-02-19——9777 Elm St, Tucson, AZ, 857060.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-140591ENRSusan Snyder1943-02-09UHC-74817-71—7267 Cedar Ln, Austin, TX, 787740.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-135697ENRGreg Arnold1972-04-17UHC-68214-7293629113118907 Washington St # 407, Columbus, OH, 432450.52Name split from “Last, First”Phone reformattedUnit split from streetState name converted to code+2 more
ENR-141463ENRJerry J Porter2001-07-04UHC-76978-3854125560911252 Ocean Ave # 486, Charlotte, NC0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-112822ENRJuaan I Patterson—UHC-85494-38—6790 Lake View Rd, Dallas, TX, 752080.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-101793ENRLaura M Young—UHC-15182-9341153310877598 Meadow Ln, Gilbert, AZ, 852580.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-110961ENRFrances O Burns1977-06-07UHC-13404-9934354861439458 Pine Dr Apt 23, Glendale, AZ, 853050.52Middle initial moved out of first nameName re-casedDate of birth reformattedUnit split from street+2 more
ENR-134853ENRJoyce Wells1988-11-18UHC-37536-8173574105793694 Sage Ct, Dallas, TX, 752150.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-114466ENRRichard X Vasquez1944-10-03UHC-80242-2175742247528197 Lake View Rd, Plano, TX0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142437ENRArthur E Guerrero1959-07-27UHC-80930-8095664784871737 Highland Ave, Austin, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-137439ENRRick Tran—UHC-09404-57—7877 Oak St, Plano, TX, 750030.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-106913ENRJudith M Harris—UHC-25584-4969726329821921 Park Pl, Tucson, AZ, 857230.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-117138ENRAmy Bryant1950-02-10UHC-84464-07—2882 Oak St, Fresno, CA, 937090.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-125299ENRCynthia Z Bishop1962-06-21UHC-36612-6765564770924621 Palm Dr, Orlando, FL, 328720.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-125300ENRCynthia Z Bishop1962-06-21UHC-36612-6765564770924621 Palm Dr, Orlando, FL, 328720.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-103006ENRCamila Y Hunt1977-03-09UHC-86053-1082281427556537 Hillcrest Rd, Scottsdale, AZ, 852660.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110658ENRSofia B Rice2004-01-26UHC-99088-4944538821633177 Camelback Rd, Los Angeles, CA0.52Name split from “Last, First”Phone reformattedSSN last four extractedState code upper-cased+2 more
ENR-116248ENRAnn Morals1982-03-06UHC-02904-0592661270153142 Park Pl Apt 9, Austin, TX0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-135468ENRPaul Brooks1980-03-07UHC-19750-7749339466462313 Indian School Rd, Plano, TX, 750030.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109377ENRChristina Garza1981-02-15UHC-89482-732033280584305 Church St, Tampa, FL, 336640.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-120474ENRLaura Q Ramos1995-07-22UHC-35531-48—9515 Jefferson Ave, Tucson, AZ, 857540.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-113616ENRLinda V Martin—UHC-10140-612188808792318 Valley View Dr, Austin, TX, 787830.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 80 of 863PreviousNext