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-409486CLMMargaret Stone1979-11-12—50385177905524 Pine Dr, Plano, TX0.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-135401ENRRuth Young2000-10-28UHC-70377-816558933083335 Desert Sky Blvd, Gilbert, AZ, 852260.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422796CLMShirley Hunter1958-03-17UHC-87251-2083446627224214 Spring St, San Diego, CA, 921730.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-53582TPAKathryn Cook1991-07-01—30091479582631 Park Pl Apt 22, Plano, TX0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-22742PRVDanielle Anderson——42772724308155 Church St, Charlotte, NC, 282840.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-138893ENRFrank T Kelly1989-04-25UHC-92048-5265780946327013 Cedar Ln, Glendale, AZ, 853700.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-420562CLMPriya L Wagner1987-09-09—48389255054010 Park Pl, Scottsdale, AZ, 852400.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21100PRVSofia Oliver1982-08-21UHC-82300-20—3300 Meadow Ln, Las Vegas, NV, 891490.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-123639ENRSofia Ramirez1976-11-13UHC-92206-2348266153728190 Camelback Rd Apt 37, Jacksonville, FL, 322400.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-430459CLMBen Ferguson1947-02-20—52823235656269 Willow Ct, Eden Prairie, MN, 553250.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-141526ENRSharon I Ferguson1959-06-22UHC-64402-0783568861344479 Ocean Ave, Columbus, OH, 432040.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-28879PRVSofia Y Bowman1964-11-20UHC-32544-4959563841393843 Baseline Rd, Scottsdale, AZ, 852290.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-59961TPANoah Sanchez1989-10-24—63247989828247 Ridge Rd, Los Angeles, CA, 900560.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-50478TPAHiroshi Hernandez1961-11-21——1528 Central Ave, Chandler, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-125501ENRMarilyn Ray1980-11-13UHC-54757-6690557713986694 Sage Ct, Charlotte, NC, 282940.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-405287CLMPatrick V Armstrong1982-03-02UHC-19406-8156046417862334 Jefferson Ave Apt 15, Nashville, TN, 372310.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-124290ENRPatricia P Bennett1940-07-21UHC-77422-6149831431388570 Valley View Dr, San Diego, CA, 921310.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115786ENRAngela A Greene1952-05-01UHC-77777-60—3078 Sage Ct Apt 17, San Antonio, TX, 782650.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-63458TPADiane Le1952-09-26——4863 River Rd, Gilbert, AZ, 852270.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
PRV-27065PRVAisha Gilbert1971-08-08—50395668808619 Elm St Apt 13, Houston, TX, 770470.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-51987TPAJose McDonald1986-07-13——7713 Lincoln Way, Austin, TX, 787090.48Name re-casedDate of birth reformattedPhone missing area codeSSN last four extracted+4 more
ENR-137819ENRNathan Simmons2006-11-07UHC-16405-9925859767131715 Union St # 215, Tucson, AZ, 857590.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
PRV-20566PRVKatherine Montgomery1996-08-07UHC-26954-3793255450906855 Sunset Blvd, Tempe, AZ0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55871TPAPaul Patel1942-11-22—67172337078622 Bayshore Dr, Tucson, AZ0.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-135838ENRJeffrey Obrien1967-04-14UHC-07591-7438390971912023 Washington St, Miami, FL, 331740.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-138449ENRDorothy H Fowler2003-08-04UHC-66322-9347977611061971 Ridge Rd, Los Angeles, CA, 900020.48Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+4 more
ENR-138450ENRDorothy H Fowler2003-08-04UHC-66322-9347977611061971 Ridge Rd, Los Angeles, CA, 900020.48Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+4 more
CLM-406560CLMAshley Hernandez1948-03-21—33191893303595 Forest Ave # 358, Chandler, AZ, 852820.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-128799ENRCarol X Webb1993-12-23UHC-87566-8645186037492396 Washington St # 929, Chandler, AZ, 852350.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-137803ENRJonathan Z Ramirez1962-03-14UHC-25636-582168636861995 Spring St, Columbus, OH, 432760.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-136665ENRNancy James1956-09-17UHC-08079-4231426893468005 River Rd, Orlando, FL, 328280.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-405963CLMShirley Hall1944-03-18UHC-69762-7225456128533326 Baseline Rd, Charlotte, NC, 282830.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-427996CLMRaymond Reed1997-07-04UHC-01048-26—8798 Lincoln Way, Orlando, FL, 328560.48Name split from “Last, First”Date of birth reformattedMember ID reformattedSSN last four extracted+4 more
ENR-116613ENROmar Bakr1982-12-17UHC-82232-6179469558985030 Desert Sky Blvd, Orlando, FL0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115506ENRTeresa Knight1969-10-26—69854052089898 Apache Blvd, Mesa, AZ, 852080.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111922ENRSophia Harris1939-08-24UHC-07069-7161790125138447 Camelback Rd, Tampa, FL, 336650.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-414518CLMJose Owens1987-02-07UHC-85056-73—1384 Pine Dr, Plano, TX, 750610.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-106033ENRElizabeth W Reed1994-09-12UHC-75188-5089164429729403 Cedar Ln Apt 28, Seattle, WA, 981120.48Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55033TPAJennifer Le1970-11-26——5766 Park Pl, Orlando, FL0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-128703ENRRyan Burke2000-08-12UHC-76409-1233337867916464 Camelback Rd, San Diego, CA, 921690.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-103950ENRPeter Ryan1976-02-24UHC-07246-0555172287055547 River Rd # 281, Tampa, FL, 336960.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-405627CLMEdward T Franklin1972-08-05UHC-16332-5693128795642087 Hillcrest Rd, Scottsdale, AZ, 852240.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-138091ENRIsabella A Walsh2006-04-16UHC-62689-443472483522656 Cedar Ln, Seattle, WA, 981780.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-414980CLMEugene Wallace1942-06-16UHC-99190-1422073350968878 Baseline Rd, Jacksonville, FL, 322190.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-50134TPACharles Palmer1994-02-11—27831397456887 Valley View Dr, Columbus, OH, 432590.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107327ENRWayne Payne1944-02-02UHC-86755-2527944971568680 Elm St, Seattle, WA, 981180.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111234ENRTyler Thomas1948-08-01UHC-19916-1472372389776416 Pine Dr, San Antonio, TX0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416913CLMRaymond Stewart2008-08-23UHC-81012-14—7962 Hillcrest Rd, Tampa, FL, 336180.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413939CLMAlbert Marshall1991-07-04—21967059398011 Maple Ave Apt 6, Plano, TX, 750580.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-413221CLMJanice Weber1972-01-16—29046259174750 Grand Ave, Tucson, AZ, 857150.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
100,000 rows, page 63 of 2,000PreviousNext