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

Claims, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-413538CLMWalter Howard1989-11-06UHC-62014-9046461302119868 Cedar Ln Apt 6, Dallas, TX, 752160.30Name re-casedDate of birth reformattedPhone reformattedUnit split from street+7 more
CLM-416822CLMNancy Hnsen1975-08-24—58740524858671 Harbor Blvd # 965, Charlotte, NC, 282820.30Name re-casedDate of birth reformattedPhone reformattedUnit split from street+7 more
CLM-426649CLMFatima James1959-08-22UHC-15235-618116194760751 Ridge Rd # 666, Atlanta, GA0.32Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
CLM-430410CLMBetty Berry1990-10-16UHC-56376-6840731152959242 Desert Sky Blvd Apt 9, Scottsdale, AZ, 852960.32Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more
CLM-407242CLMKyle Lopez1956-05-05UHC-73389-1194420250835858 Sage Ct Apt 23, Chandler, AZ, 852190.32Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+6 more
CLM-401736CLMJohn Gardner1994-01-21—4755491673249 Mesa Dr # 559, Houston, TX, 770280.32Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+6 more
CLM-428831CLMNicholas King1992-05-02UHC-48082-6524659858612780 Oak St, San Antonio, TX, 782310.32Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+6 more
CLM-419847CLMAmy Gonzales1969-01-15—43825930467108 Willow Ct, San Antonio, TX, 782360.32Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+6 more
CLM-400593CLMDaniel Burton1962-04-20UHC-24083-79—8924 Canyon Rd Apt 18, Phoenix, AZ, 850210.32Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+6 more
CLM-402942CLMRalph Little1971-04-28—37042304208807 Jefferson Ave, Plano, TX0.32Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-402364CLMPeter L Vazquez2002-04-11—82285979558624 Cedar Ln # 159, Tempe, AZ, 852190.32Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more
CLM-408248CLMSamuel Kennedy2001-10-07UHC-13635-82—3167 Church St, Tempe, AZ, 852310.32Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+6 more
CLM-423401CLMCarolyn Martin1986-03-17UHC-41069-5242827904625919 Church St Apt 11, Plano, TX, 750080.32Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more
CLM-423139CLMDylan Martin—UHC-41516-35—3591 Lake View Rd, Tampa, FL, 336220.32Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+6 more
CLM-414218CLMAndrew Hickks1956-02-16—96156908607761 Apache Blvd # 603, Phoenix, AZ, 850770.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-405092CLMJonathan P Bell1988-02-22UHC-75396-8965590206714740 Forest Ave, Sacramento, CA, 958960.32Name split from “Last, First”Middle initial moved out of first nameTwo-digit birth yearPhone reformatted+6 more
CLM-425489CLMKelly Stephens1994-10-12UHC-33651-42—5799 Main St Apt 33, Fresno, CA, 937330.32Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+6 more
CLM-404261CLMBevverly Cruz1984-09-25UHC-18244-8352443386836302 Harbor Blvd # 691, Seattle, WA, 981890.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-427327CLMMelissa Anderson1947-01-17UHC-80083-7043023456426687 Baseline Rd # 400, Seattle, WA, 981030.32Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+6 more
CLM-414589CLMLaryr Franklin—UHC-07734-4589450555158091 Sunset Blvd Apt 17, Atlanta, GA, 303110.32Name re-casedDate of birth missingPhone reformattedUnit split from street+6 more
CLM-403169CLMAnn Gilbert2004-10-07UHC-20636-06—2196 Sage Ct, Chandler, AZ0.32Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+6 more
CLM-420757CLMKenneth Dunan1946-12-23—66684269316472 Indian School Rd # 106, Orlando, FL0.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-400338CLMRalph Little1941-02-04—84878061623843 Elm St # 201, Tucson, AZ, 857600.32Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more
CLM-400233CLMAusttin Stone1949-11-17UHC-55219-4846255305744169 Jefferson Ave # 603, Chandler, AZ, 852520.32Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-430427CLM—Junk1968-03-23—88957938375967 Willow Ct, Eden Prairie, MN, 553290.34Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
CLM-414853CLMPeter Gilbert1961-12-23—31825301044458 Canyon Rd, Tucson, AZ0.34Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-403740CLMGerald Cunningham1983-06-15—53921547187237 Camelback Rd Apt 4, Nashville, TN, 372950.34Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+5 more
CLM-416065CLMRalph Myers1966-04-05—40939835823366 Hillcrest Rd Apt 38, Glendale, AZ0.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
CLM-420582CLMCral Smith1960-09-16UHC-10143-60—1255 Jefferson Ave, Minneapolis, MN, 554610.34Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-421015CLMAdam Williamson—UHC-12020-33—2283 Valley View Dr, Miami, FL0.34Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+5 more
CLM-403639CLMDorothy Gonzalez—UHC-11908-7971144796862871 Elm St, Tempe, AZ, 852510.34Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-427890CLMEmily Palmer1961-07-18—44994928387132 Forest Ave Apt 21, Nashville, TN, 372240.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
CLM-423140CLMVirginia C Boyd2006-01-27—28786545807938 Harbor Blvd, San Antonio, TX, 782390.34Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-422779CLMDylan Luna1956-01-18UHC-88278-1553055406519845 Camelback Rd Apt 21, Plano, TX, 750730.34Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-407867CLMAngela Park2004-01-02UHC-74100-6742772926162773 River Rd, Columbus, OH0.34Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-427935CLMAmber Guerrero1956-05-07—77554030525676 Jefferson Ave, Phoenix, AZ, 850530.34Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-431795CLMAmber Jordan1987-03-10——6220 Cedar Ln, Tempe, AZ, 852080.34Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+5 more
CLM-422802CLMSharon T Sims———6678 Canyon Rd, Atlanta, GA, 303490.34Name re-casedDate of birth missingPhone missing area codeStreet suffix standardised+5 more
CLM-413846CLMMei Lee1978-11-25—79283509364010 Central Ave, Denver, CO, 802740.34Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-413343CLMJoe R Rose2000-03-27UHC-80700-6521395380873430 Hillcrest Rd Apt 29, Los Angeles, CA, 900870.34Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+5 more
CLM-414723CLMLuis Cruz1954-04-05UHC-82624-5666645839301564 Grand Ave # 838, Nashville, TN, 372830.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
CLM-423313CLMElizabeth Simpson1942-05-15UHC-88527-17—7249 Valley View Dr, Las Vegas, NV0.34Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+5 more
CLM-417949CLMJudy Hart2006-05-28UHC-11656-0787693786522376 Meadow Ln, Scottsdale, AZ, 852630.34Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-413124CLMFrank Howard1971-07-01—25466838035872 Jefferson Ave Apt 25, Nashville, TN, 372530.34Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
CLM-419862CLMWayne D Campbell1980-01-10UHC-79401-10—8279 Desert Sky Blvd # 844, Columbus, OH, 432310.34Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
CLM-419861CLMWayne D Campbell1980-01-10UHC-79401-10—8279 Desert Sky Blvd # 844, Columbus, OH, 432310.34Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
CLM-403732CLMJessica Alexander1939-07-15UHC-53980-3660447014023491 Pine Dr # 497, Atlanta, GA, 303230.34Name re-casedPhone reformattedSSN last four extractedUnit split from street+5 more
CLM-409064CLMGloria Murray1944-07-13UHC-15058-9244480560284605 Cedar Ln, Chandler, AZ, 852180.34Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-414299CLMMarilyn Hicks1943-02-26UHC-38790-5620298909594833 Mountain View Dr Apt 30, Austin, TX, 787990.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
CLM-415884CLMChristopher Nguyen1994-01-27UHC-96313-1988781755001738 Meadow Ln # 202, Tempe, AZ0.34Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+5 more
32,829 rows, page 2 of 657PreviousNext