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-137394ENRSarrah Obrien1979-03-22UHC-18352-6928333815935148 Maple Ave, Minneapolis, MN, 554740.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-104352ENRJamas M Espinoza1998-01-19UHC-93856-60—5887 Central Ave, San Antonio, TX, 782680.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-431602CLMBradley U Carpenter1948-08-08UHC-06430-16—9271 Mountain View Dr, Fresno, CA, 937390.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-432484CLMWei Marshall1979-11-21UHC-81522-17—9172 Sunset Blvd, Tempe, AZ0.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-122084ENRSara Ramos2008-11-19UHC-62520-52—2967 Highland Ave, San Diego, CA, 921230.52Name re-casedPhone missing area codeState name converted to codeGender normalised+2 more
PRV-20084PRVChristine Salazar1973-11-05UHC-75118-47—7127 Sunset Blvd, Plano, TX, 750200.52Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+2 more
CLM-409990CLMTimothy O Lucas1939-02-26UHC-65767-0879535802226117 Grand Ave, Las Vegas, NV0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135346ENRNicholas Diaz2004-04-09UHC-37468-7722399823539304 Elm St # 560, Seattle, WA, 981390.52Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-104473ENRKathelen Baker1943-04-12UHC-40436-4971353463399748 Washington St, Atlanta, GA, 303290.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
PRV-26511PRVMadison H Ramos1994-04-06—29397888942845 Market St, Columbus, OH0.52Name re-casedPhone reformattedState name converted to codeZIP missing+2 more
CLM-416957CLMSantiago Lynch1998-06-15UHC-94650-0832531730922281 River Rd # 188, Las Vegas, NV, 891170.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418274CLMJacob Vazquez1971-07-14—55986488462247 Park Pl, Glendale, AZ, 853510.52Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+2 more
CLM-404670CLMMargaret Smith1976-01-15UHC-25071-63—1446 Ridge Rd, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-404669CLMMargaret Smith1976-01-15UHC-25071-63—1446 Ridge Rd, Chandler, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411548CLMMartha Washington1951-06-12——8382 Palm Dr Apt 19, Glendale, AZ, 853940.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-140613ENRRaymond Q Alvarado1940-05-14UHC-63639-3121149116031325 Market St, Dallas, TX, 752300.52Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more
ENR-104662ENRKelly SJunk2002-11-22UHC-86692-9181834981882310 Highland Ave, Columbus, OH, 432860.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112085ENREmily T Rose1981-08-12UHC-79044-5297498472047724 Grand Ave # 881, Nashville, TN, 372290.52Middle initial moved out of first nameName re-casedUnit split from streetState name converted to code+2 more
ENR-126556ENRDonald B Vzquez1967-07-25UHC-46967-7081358085793799 Indian School Rd, Miami, FL, 331550.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56736TPABobby J Daniels1959-10-15UHC-88164-3784198430812303 Desert Sky Blvd, Chandler, AZ, 852560.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-51512TPASamuel Evans2003-06-19——4995 Maple Ave, Phoenix, AZ, 850210.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-51185TPAMaria Kim1998-12-22——322 Mountain View Dr, Columbus, OH, 432020.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21302PRVPatricia T Gonzales2002-07-18UHC-73800-42—5925 Cedar Ln, Minneapolis, MN0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-114595ENREthan Wood2008-02-15UHC-34077-3950132586903802 Indian School Rd, Fresno, CA0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-106054ENRStephanie Reed1994-02-26UHC-72165-5587947939047279 Bayshore Dr, Seattle, WA, 981030.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-109506ENRLaura B Vasquez—UHC-24014-4456455589125673 Harbor Blvd, Glendale, AZ, 853440.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-54378TPARoy Carlson1981-10-05——1263 Harbor Blvd, Gilbert, AZ, 852770.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-52084TPAHelen Cruz1988-11-02——756 Central Ave, Orlando, FL, 328890.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-20886PRVJonathan L Sullivan1976-01-10UHC-13997-3126948715647212 Mesa Dr # 208, Gilbert, AZ, 852310.52Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+2 more
ENR-112993ENRSarah C Crawford1967-09-27UHC-35859-85—7164 Hillcrest Rd, Austin, TX, 787680.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-407897CLMAlexis B Burton1975-10-05UHC-80754-22—6768 Oak St, Dallas, TX, 752780.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-129141ENRPatrick Ortega2001-07-20UHC-45462-68—348 Cedar Ln, Atlanta, GA, 303050.52Name re-casedDate of birth reformattedPhone missing area codeState name converted to code+2 more
CLM-403593CLMMarilyn Hart1953-09-01—7133791846689 Spring St, Denver, CO, 802120.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-111974ENRNaoh O Moore1987-04-28UHC-57675-7452489290322448 Lincoln Way, Phoenix, AZ, 850840.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-121655ENRAndrew W Cooper1983-06-12—8329935777805 Desert Sky Blvd, Charlotte, NC, 282110.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-114134ENRLawrence P Romero1947-12-28UHC-11868-3539738576674907 Apache Blvd # 703, Eden Prairie, MN, 553950.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-118323ENRJudith Foster—UHC-34522-4553965666616667 Elm St # 433, Dallas, TX, 752430.52Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-417104CLMWest Jacqueline2001-11-06UHC-85592-57—6379 Cedar Ln, Orlando, FL, 328380.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420468CLMJanet T Hicks1980-06-24UHC-23608-8442832261848500 Apache Blvd, Tucson, AZ, 857110.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
ENR-116452ENRPamela Gordon1978-11-04UHC-80712-5593754859804998 Canyon Rd, Denver, CO, 802440.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-125304ENRZachary Payne1948-03-24UHC-70686-7498536000444827 Baseline Rd, Eden Prairie, MN, 553980.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-406804CLMAhmed Davis2003-01-10UHC-86559-6886161831163163 Church St, Glendale, AZ, 853910.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121279ENRYuki D Jones1987-04-24UHC-69070-0258263730802363 Maple Ave # 476, Jacksonville, FL, 322600.52Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+2 more
ENR-135514ENRSofia U Andrews1996-02-17UHC-65628-976905613448377 Spring St, Charlotte, NC0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-135819ENRHarold Herrera1958-11-09—37537627376162 Canyon Rd, Plano, TX, 750850.52Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-126144ENRMason R Morales1999-10-26UHC-64421-0239276611557153 Washington St, Plano, TX, 750910.52SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-106593ENRCarl V Dean1972-03-28UHC-87857-8957684437609585 Oak St # 839, Tampa, FL, 336420.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
ENR-114300ENRCarol Hughes1979-02-28UHC-70476-1533754774902280 Bayshore Dr # 570, Seattle, WA, 981280.52Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-116838ENRLisa Hayes1985-07-09UHC-46841-84459444979233 Grand Ave, Gilbert, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-416397CLMAisha Chapman1961-09-18UHC-86057-3922546979444462 Cedar Ln # 123, Miami, FL, 331910.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 188 of 2,000PreviousNext