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
TPA-50673TPAHeather Kelly1971-01-25——6489 Central Ave, Nashville, TN0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-430276CLMEugene Cruz1988-03-02UHC-78205-34—1352 Cedar Ln # 525, Tucson, AZ, 857080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430277CLMEugene Cruz1988-03-02UHC-78205-34—1352 Cedar Ln # 525, Tucson, AZ, 857080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-113134ENRPhilip U Montogmery1947-11-16UHC-95197-1397245507472672 Spring St, San Antonio, TX0.50Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+3 more
ENR-141049ENRSteven Medina1945-08-08UHC-03024-42—4508 Pine Dr, San Diego, CA, 921100.50Two-digit birth yearPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
ENR-109786ENRAngela Baker1956-07-15UHC-46469-1144389801663469 Grand Ave, Miami, FL, 331040.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418248CLMLinda Warren1947-03-14UHC-15412-53—2937 Sunset Blvd, Atlanta, GA0.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-429051CLMWilliam Hall1975-07-16——1847 Pine Dr, Scottsdale, AZ, 852720.50Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+3 more
CLM-430120CLMKenneth Austin1999-05-12UHC-79067-7622955983209530 Forest Ave Apt 40, Miami, FL, 331210.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-121102ENRMelissa Rodriguez1943-03-11UHC-87826-9160445010011384 Meadow Ln # 293, Scottsdale, AZ, 852930.50Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
CLM-431042CLMDoris T Mendez1997-11-25UHC-89129-8937098177024014 Harbor Blvd Apt 40, Miami, FL, 331780.50Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+3 more
ENR-108494ENRElizabeth Fox2005-12-07UHC-85549-3020961096609575 Ocean Ave, Los Angeles, CA, 900570.50Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+3 more
PRV-21089PRVKeith Degado1945-11-19UHC-23405-4071856113832236 Forest Ave # 419, Sacramento, CA, 958840.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61822TPAAndrew Johnson1962-02-19——6062 Elm St, Sacramento, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-113032ENRBobby F Ferguson1954-07-24UHC-22343-808354778259541 Hillcrest Rd, Orlando, FL, 328960.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131020ENRMadison O Garza2005-11-04UHC-78183-73—9875 Mountain View Dr, Houston, TX, 770590.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431677CLMChristopher Q Willis—UHC-10720-18—269 Indian School Rd, Jacksonville, FL0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
PRV-22352PRVAngela X Cook—UHC-77530-8544251927795523 Forest Ave, Tucson, AZ, 857210.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-137954ENRCheryl R Harvey1954-09-11UHC-06347-2841229675641249 Hillcrest Rd, Plano, TX0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64126TPAJose K Carpenter———4048 Willow Ct, Plano, TX, 750490.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-404634CLMDeborah Day1955-06-07UHC-19228-66—4202 Washington St, Tucson, AZ, 857180.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429133CLMMurray Juan1960-12-26UHC-76789-10—9062 Park Pl, Gilbert, AZ, 852630.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-105451ENRJoseph Wright1976-04-20UHC-09052-5174361361132096 Willow Ct, Tampa, FL0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-109062ENRJudy D Rose1944-02-08UHC-90243-8053240276106538 Park Pl, Los Angeles, CA, 900100.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-138619ENRJordan L Carr1973-07-06UHC-39558-60—205 Spring St, Gilbert, AZ, 852420.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
ENR-142718ENRChristian T Price1944-08-02UHC-56714-75—1279 Church St, Tucson, AZ, 857250.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-61410TPADorothy Wang1974-07-20——4129 Bayshore Dr, Columbus, OH, 432680.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-59187TPABrenda Jenkins1998-06-28—44523474368124 Ridge Rd, Las Vegas, NV, 891730.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-140484ENRMark G Phillips1983-11-26UHC-10262-1196552140607082 Camelback Rd Apt 38, Plano, TX, 750320.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-23219PRVCarol Thomas1955-07-27——621 Apache Blvd # 471, San Diego, CA, 921130.50Name re-casedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
TPA-57461TPATommy Chapman1967-01-23—86244518244340 Canyon Rd, Chandler, AZ, 852520.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28776PRVAshley V Marquez1939-01-03UHC-56997-244835801301384 Lake View Rd Apt 8, Nashville, TN, 372790.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
PRV-25632PRVMei J Stevens——25076842297727 Highland Ave, Glendale, AZ, 853830.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-100827ENRRalph I Ortega1952-12-18UHC-17574-6764633064412079 Meadow Ln Apt 16, Mesa, AZ, 852530.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-58829TPAAlice Willis1944-06-18—70880544495380 Willow Ct, Nashville, TN, 372410.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-116158ENRWalter L Mitchell1982-09-11UHC-14812-108143449306909 Washington St Apt 8, Dallas, TX, 752740.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-123944ENRWilliam Jones2004-06-01—79958637314520 Canyon Rd, Atlanta, GA, 303490.50Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-412188CLMEd H Myers2004-08-09—42388475304250 Grand Ave, Tempe, AZ, 852030.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-419384CLMCatheryne Hart1963-09-20UHC-18151-19—7998 Desert Sky Blvd, Atlanta, GA, 303170.50Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+3 more
ENR-131341ENRJennifer I Medina2000-06-27UHC-07728-5771923724821107 Valley View Dr, Eden Prairie, MN, 553250.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-131342ENRJennifer I Medina2000-06-27UHC-07728-5771923724821107 Valley View Dr, Eden Prairie, MN, 553250.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-136105ENRGeorge Ray2001-06-05UHC-83002-5483590951352902 Union St, Houston, TX, 770450.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-129372ENRDoris Griffin1994-02-10—95968544316340 Mesa Dr, Miami, FL0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106659ENRAustin V Berry2007-04-07UHC-63286-3253757017994427 Washington St, Nashville, TN, 372760.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-107595ENREugene Q Weber1996-02-13UHC-24096-9534550335685066 Maple Ave, Minneapolis, MN, 554550.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120326ENRJulie D Thomas1980-10-02UHC-72071-1876637898571788 Oak St Apt 3, Scottsdale, AZ, 852200.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-138489ENRSean M Delgado2007-05-22UHC-78051-06—8367 Cedar Ln, Orlando, FL, 328270.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-140438ENRCarol A Jordan—UHC-04959-0924361620084129 Lincoln Way # 700, Eden Prairie, MN, 553580.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-51614TPAJessica G Rios1950-07-04—6348221949552 Spring St, Charlotte, NC, 282380.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410367CLMEdward O Peterson1969-01-12UHC-42460-1297527017164454 Harbor Blvd, Houston, TX, 770720.50Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+3 more
100,000 rows, page 89 of 2,000PreviousNext