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-142033ENRSara Spencer1992-08-11UHC-86653-96—4028 Oak St # 476, Nashville, TN, 372900.52Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+2 more
ENR-142034ENRSara Spencer1992-08-11UHC-86653-96—4028 Oak St # 476, Nashville, TN, 372900.52Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+2 more
CLM-430251CLMAshley Q Mejia1969-02-05UHC-53643-77—4736 Desert Sky Blvd, Scottsdale, AZ, 852860.52Name re-casedPhone missing area codeZIP+4 trimmedGender normalised+2 more
CLM-424266CLMJess Dominguez1987-06-07UHC-00531-6071865100016559 Indian School Rd, San Antonio, TX, 782390.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118169ENRMaeo Berry1954-09-13UHC-37284-1543888171333004 Hillcrest Rd, Las Vegas, NV, 891590.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-138150ENRSaa Y Greene—UHC-27441-3331948601368734 Willow Ct, Los Angeles, CA0.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123559ENRTricia V Bradley2000-08-04UHC-03687-10—5690 Forest Ave Apt 34, Houston, TX, 770230.52Name split from “Last, First”Date of birth reformattedPhone missing area codeUnit split from street+2 more
CLM-411506CLMElijah Hudson1984-08-09UHC-86992-5594051491757178 Desert Sky Blvd, Charlotte, NC0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-133111ENRPatricia Patel1989-12-23UHC-55189-29—7904 Sage Ct Apt 31, Minneapolis, MN, 554650.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
PRV-21214PRVCarlos Gray1941-08-12UHC-64484-73—8227 Grand Ave, San Diego, CA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
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
PRV-20810PRVGerald P Li1954-12-24—79132136257477 River Rd, Jacksonville, FL0.52Middle initial moved out of first namePhone reformattedStreet 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
CLM-420872CLMDonna Cook1978-02-12—87987082986955 Maple Ave # 791, Scottsdale, AZ, 852560.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-61957TPALauren Reyes1969-12-25—63245817666923 Main St Apt 21, Las Vegas, NV, 891230.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+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
CLM-421086CLMPatrickJunk1992-05-21UHC-25254-36—1167 Cedar Ln, Columbus, OH, 432610.52Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+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
PRV-21987PRVAaron Willis1938-05-01UHC-70017-39—8138 Ridge Rd, Los Angeles, CA, 900210.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-423759CLMJudith F Oliver1994-10-18——7142 Forest Ave, Tampa, FL, 336770.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
PRV-24817PRVAmanda Washington2000-07-01UHC-98242-3477378831722909 Spring St, Charlotte, NC0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431198CLMWayne Romero1945-03-26—44678681917933 Maple Ave, Seattle, WA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-423578CLMArthur Garrett1991-02-17UHC-98433-73—4997 Camelback Rd, Miami, FL, 331220.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+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
PRV-20457PRVMateo Shaw1955-06-19—93855708061818 Church St # 860, San Antonio, TX, 782810.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-416884CLMDanielle Garza1996-10-19UHC-85381-1660628649363040 Spring St # 890, Glendale, AZ, 853710.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+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
TPA-62240TPACarol Brooks1953-08-03UHC-66153-3921054151313003 Oak St, Dallas, TX, 752660.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+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
CLM-415370CLMMichelle Gutierrez1979-03-25——7289 Lincoln Way, Jacksonville, FL, 322730.52SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+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
CLM-402992CLMCarl Morgan1992-08-12UHC-90910-902293914072459 Indian School Rd, Los Angeles, CA0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429946CLMNathan Stephens1963-05-09UHC-96209-03—4241 Mesa Dr, Minneapolis, MN, 554990.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-405470CLMNathan Obrien—UHC-35857-33—9887 Apache Blvd, Tempe, AZ, 852000.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-420649CLMRalph Nichols1962-06-14UHC-69144-34—5689 Lincoln Way, Chandler, AZ, 852690.52Name re-casedSSN last four extractedStreet 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
CLM-405955CLMEugene Carlson1993-08-18UHC-73643-65—7646 Ridge Rd, Phoenix, AZ, 850510.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+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
100,000 rows, page 161 of 2,000PreviousNext