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-409165CLMJuan Murphy——6846278951147 Canyon Rd, Tampa, FL, 336680.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407551CLMSamantha Greene1976-09-02UHC-56755-0822792611661516 Highland Ave # 290, San Diego, CA, 921510.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-416377CLMBruce T Torres1958-06-07UHC-04706-642874096040974 Forest Ave, Houston, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426115CLMMato P Sims1959-11-11—95443726087841 Bayshore Dr, Phoenix, AZ, 850070.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430330CLMAshley Hunter1962-01-15UHC-27397-7995759981854675 Mesa Dr, Columbus, OH, 432030.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429462CLMLucia Le1959-09-08—51047092117725 Pine Dr, Las Vegas, NV, 891680.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-403696CLMChristina Burke1976-06-13——5791 Cedar Ln, Glendale, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-421272CLMBrittany Mendez1946-05-27UHC-75234-10—5701 Baseline Rd, Columbus, OH, 432340.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423650CLMMason Vasquez1952-12-01——7154 Maple Ave, Los Angeles, CA, 900970.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-428000CLMDaniel E Gilbert1938-08-24—26584411569403 Market St, Tampa, FL, 336240.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409411CLMKathleen Watson1959-07-27—58473427513553 Mountain View Dr, San Diego, CA, 921950.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414310CLMElijah S Stone1944-04-03——250 Washington St # 399, Tempe, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-410890CLMKatherine Bell1997-07-13—90279140608466 Bayshore Dr, Tempe, AZ, 852650.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420406CLMSara Harvey1984-02-18—62454314628811 Church St, Denver, CO, 802570.50Name split from “Last, First”Two-digit birth yearPhone reformattedCity re-cased+3 more
CLM-431145CLMCharles M Hoffman1986-03-16UHC-28425-9688495584701089 Bayshore Dr, Jacksonville, FL, 322690.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401096CLMEmma Reyes1992-04-17UHC-53606-4324646150506614 Lake View Rd, Sacramento, CA, 958270.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-415943CLMAbby B Olson1944-07-07UHC-32653-3548637154904859 Hillcrest Rd, Nashville, TN, 372640.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-404747CLMMateo Rivera1977-04-04UHC-03884-6353744703696701 Church St, Austin, TX0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432695CLMDenise Rogers1996-05-21UHC-63267-3639351286842232 Forest Ave, Las Vegas, NV, 891360.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410325CLMKeith Torres—UHC-89886-91—8102 Main St, Houston, TX, 770180.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405096CLMMarilyn Romero1954-08-02UHC-22595-4055590005692973 Main St, Eden Prairie, MN, 553380.50Name split from “Last, First”Member ID reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-430741CLMSamantha Payne2001-06-24UHC-99063-40—4292 Washington St, Gilbert, AZ, 852000.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431609CLMCarolyn Flores1964-05-16——2384 Apache Blvd Apt 34, Los Angeles, CA, 900370.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406812CLMVincent Lewis1977-02-13UHC-59903-8976945085507484 Bayshore Dr, Glendale, AZ0.50Name split from “Last, First”Date of birth reformattedMember ID reformattedZIP missing+3 more
CLM-400293CLMValentina Austin1980-11-05UHC-16705-3642589318396663 Highland Ave, Gilbert, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428168CLMKevin D Matthews1966-08-15UHC-84075-27—6609 Mesa Dr, Houston, TX, 770740.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422159CLMSantiago Johnston1951-11-11——2725 Washington St, Chandler, AZ, 852840.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-405996CLMDonna Moore1983-06-07UHC-26588-3822096558485727 Lake View Rd, Plano, TX, 750900.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-425309CLMArthur Carter1953-09-20UHC-46569-38—7582 Washington St, Chandler, AZ, 852720.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-421241CLMWeber K Frances1963-02-15UHC-72878-47—4716 Camelback Rd Apt 35, Los Angeles, CA, 900130.50Name re-casedTwo-digit birth yearUnit split from streetState name converted to code+3 more
CLM-429983CLMJulie Romero———5486 Central Ave, Nashville, TN, 372920.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-402891CLMGrace Hawkins1938-07-27UHC-70840-06—1559 Willow Ct, Fresno, CA, 937010.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-400461CLMDiana McDonald2001-02-15UHC-97280-61—5119 Canyon Rd, Nashville, TN, 372830.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405255CLMAlexis Washington1997-12-03—26270644805669 Valley View Dr, Columbus, OH0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415828CLMWilliam Scott1938-04-20UHC-86572-89—2049 River Rd, Dallas, TX, 752070.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-419254CLMChristopher Perkins1980-12-20—90879193828198 Baseline Rd Apt 6, Scottsdale, AZ, 852560.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414474CLMJean Marquez1976-10-18UHC-24571-4352589968805307 Desert Sky Blvd # 337, Columbus, OH, 432200.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-429239CLMSandra Brown2005-02-05UHC-38120-34—4287 Central Ave, Mesa, AZ, 852780.50SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-404414CLMWayne Johnson—UHC-32196-1261873174264894 Palm Dr, Charlotte, NC, 282220.50Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-420625CLMDoris Hatr1999-03-26UHC-42027-01—793 Lake View Rd # 378, Eden Prairie, MN, 553880.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416710CLMLogan Green1972-01-18—513446785632 Willow Ct # 353, Chandler, AZ, 852660.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413560CLMCheryl Ward1986-10-26——1170 Spring St, Nashville, TN0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-407292CLMJoyce Thompson1952-02-17——2819 Pine Dr, Fresno, CA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412224CLMPriya R Henry1997-12-11UHC-78896-2662679441096340 Mountain View Dr, Gilbert, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425964CLMAshley Bryant2006-10-04UHC-46537-8355361071507372 Pine Dr Apt 13, Miami, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-419434CLMJonathan Q Silva2006-05-10UHC-97068-21—8190 Cedar Ln, Fresno, CA, 937520.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-431016CLMRandy Bishop1982-05-13UHC-81792-57—7863 Oak St, Tempe, AZ0.50Name re-casedDate of birth reformattedState name converted to codeZIP missing+3 more
CLM-428236CLMDiane Little1956-02-14UHC-00503-91—9056 Washington St # 639, Orlando, FL, 328450.50Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-431038CLMJeremy Dominguez1972-02-12UHC-31668-7996891358328548 Hillcrest Rd, Mesa, AZ0.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-409201CLMEvelyn Kelley1980-04-19UHC-08989-78—7191 Park Pl, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 37 of 657PreviousNext