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-408730CLMMaria Fernandez1962-12-10UHC-85600-60—9762 Forest Ave, Gilbert, AZ, 852550.50Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405323CLMFrances Miller1989-06-26UHC-20698-1542829309842646 River Rd, Minneapolis, MN0.50Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-418935CLMHelen Jimenez—UHC-73267-49—6644 Mesa Dr, Fresno, CA, 937970.50Name split from “Last, First”Date of birth unreadableMember ID reformattedStreet suffix standardised+3 more
CLM-423012CLMHiroshi R Peterson1968-09-04UHC-61159-02—2708 Oak St, Miami, FL, 331310.50Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-427141CLMShirley Powell1949-02-22UHC-95313-9090099779027038 Main St Apt 36, Sacramento, CA, 958590.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407064CLMStephanie V Hart1987-08-13—88229669849207 Park Pl, Austin, TX0.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412185CLMChristina Hayes1990-03-27UHC-00491-7793837727218571 Mesa Dr # 927, Plano, TX0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412186CLMChristina Hayes1990-03-27UHC-00491-7793837727218571 Mesa Dr # 927, Plano, TX0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404227CLMJean Gonzales1989-11-19——6660 Lake View Rd, Sacramento, CA, 958530.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432156CLMKelly Gutierrez1990-10-16—89079175056693 Maple Ave, Las Vegas, NV0.50Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-402270CLMCamila Martinez1995-03-24——3375 Mesa Dr, Atlanta, GA, 303750.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-412240CLMFrances Franklin1938-06-05UHC-89412-6845027941859513 Sage Ct, Dallas, TX, 752430.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-414360CLMNathan Fowler2000-07-09UHC-98829-17—8976 Pine Dr, Nashville, TN, 372330.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407206CLMShirley Cruz1978-01-23UHC-86255-78—7175 Ridge Rd, Glendale, AZ, 853550.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411154CLMJoyce N Pierce1945-02-01UHC-17185-78—3413 Spring St, Scottsdale, AZ, 852620.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-418204CLMTommy Barnes1958-12-14UHC-50248-95—4530 Ridge Rd, Plano, TX, 750410.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-430770CLMAndrea Kim1939-01-18UHC-58093-27—152 Market St, Houston, TX, 770220.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-401714CLMAndrea Holes1965-05-05——1113 River Rd, Atlanta, GA, 303360.50Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-423080CLMScott Sanchez2004-01-20UHC-28082-1481293409772598 Ocean Ave, Scottsdale, AZ, 852780.50Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-406195CLMFatima Perkins1992-04-14—6414426679107 Central Ave Apt 40, Jacksonville, FL, 322100.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-400938CLMKevin Payne2008-05-06UHC-21244-878747611782288 Spring St, Tucson, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423998CLMFrank L Richards1983-06-28UHC-92254-8638348506097748 Meadow Ln, Jacksonville, FL0.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430241CLMAustin Robinson1955-04-05—24399025971519 Ridge Rd, Tampa, FL, 336610.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425243CLMFerguson Michelle1945-01-23UHC-84132-54—1578 Harbor Blvd, San Antonio, TX, 782700.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432620CLMWalter Rios1956-10-13UHC-18644-9992035960473523 Broadway Apt 36, Chandler, AZ, 852610.50Name re-casedUnit split from streetCity re-casedState name converted to code+3 more
CLM-432052CLMAbigail Wbeb—UHC-21830-2477671837807718 Harbor Blvd, Chandler, AZ0.50Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-406330CLMVictoria Mitchell1952-10-11UHC-81119-5347194958795839 Desert Sky Blvd, Orlando, FL0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432586CLMJose Walker1967-09-02UHC-06820-75—687 Baseline Rd # 629, Dallas, TX, 752460.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410100CLMTheresa Roberts1951-02-05UHC-10775-373672731143432 Ocean Ave, Gilbert, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-414936CLMTyler Gray2005-10-24——3159 Harbor Blvd # 564, Glendale, AZ0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402086CLMThomas V Johnston1982-01-26—95170466772797 Market St, Scottsdale, AZ, 852730.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-422589CLMEdwardJunk1994-11-09—23847915381320 River Rd, Seattle, WA, 981540.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424232CLMStephanie Porter1974-01-20——3850 Jefferson Ave, Los Angeles, CA, 900860.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416528CLMMartha Flores—UHC-46994-53—5204 Palm Dr Apt 32, Plano, TX, 750330.50Date of birth missingMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410205CLMJulia Woong1994-10-19UHC-71698-2055530908448868 Main St, Seattle, WA, 981080.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430331CLMChukc X Butler1963-10-19UHC-33196-9384628010307058 Central Ave, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431664CLMJames Porter—UHC-83196-0979338352087495 Ocean Ave, Tempe, AZ, 852530.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429202CLMBetty Ray1991-11-10—84862256226922 Cedar Ln # 149, San Diego, CA, 921380.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-423567CLMAjun V Howell—UHC-84566-928139412648—0.50Middle initial moved out of first nameDate of birth missingPhone reformattedGender normalised+3 more
CLM-403304CLMDavid Garcia2008-01-09UHC-62582-3426356536856698 Mesa Dr, San Diego, CA, 921470.50Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-419163CLMSofia Weber1987-11-14UHC-90595-76—9275 Union St, Sacramento, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-407930CLMDiego Bryant1939-09-25—83081954671522 Willow Ct, Eden Prairie, MN, 553340.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416043CLMChristian Edwards1977-03-19UHC-82513-3544585771075119 Maple Ave, Plano, TX, 750900.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-432242CLMPriya S Williams1972-03-23UHC-70691-50—6515 Willow Ct, Charlotte, NC, 282470.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-404597CLMGary Hansen1975-05-10——4171 Bayshore Dr, Minneapolis, MN, 554230.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402230CLMDaniel Obrien1993-07-25——3776 Main St # 342, Denver, CO, 802420.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
CLM-421703CLMPaul Bryant1975-01-19——7916 Meadow Ln, Denver, CO0.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403334CLMJanice B Harper1981-07-04—93029244789455 Canyon Rd, Gilbert, AZ, 852870.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-413259CLMDennis P Brooks1956-10-04UHC-34952-1626997827654878 Camelback Rd Apt 28, Austin, TX, 787670.50Name split from “Last, First”Phone reformattedUnit split from streetState code upper-cased+3 more
CLM-408911CLMMegan P Wheeler1971-03-12UHC-61260-0688587098158380 Sunset Blvd Apt 40, Houston, TX, 770600.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
32,829 rows, page 31 of 657PreviousNext