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-428303CLMBrittany Moore1952-10-22—67726506942008 Park Pl Apt 6, Atlanta, GA, 303230.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424201CLMJake Wood1989-04-24UHC-23540-39—1377 Willow Ct, Scottsdale, AZ, 852040.50Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-402053CLMNancy Munoz1947-05-03—94895086573307 Elm St, Plano, TX, 750940.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401836CLMCynthia Ray2001-07-12——846 Highland Ave, San Diego, CA, 921340.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-418556CLMDoris McCoy1962-10-10UHC-01922-8231532497596408 Union St, Las Vegas, NV, 891460.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431123CLMJacob Allen1999-06-02—67721576416532 Ridge Rd, Tampa, FL, 336260.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-404992CLMAndrew Wooods2001-06-02UHC-24692-84—4197 Union St Apt 15, Eden Prairie, MN, 553360.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-430941CLMMichelle Bowman1971-10-24UHC-64949-34—7317 Oak St, Tampa, FL0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-427691CLMPriya Howell1942-08-10UHC-99815-1961668651955682 River Rd # 860, San Antonio, TX, 782880.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-414695CLMJohn Sims1979-06-09UHC-98485-4298723946087970 Main St, San Diego, CA, 921380.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403918CLMWayne Marshall—UHC-10389-4233991881216503 Highland Ave, Los Angeles, CA, 900220.50Date of birth reformattedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-407692CLMArthur Espinoza2003-07-16—45335708469292 Indian School Rd # 446, Tampa, FL, 336900.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-401992CLMElizabeth Hamilton1950-12-01UHC-48977-8678547423644500 Maple Ave, Seattle, WA, 981960.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-417950CLMWeber Laura1944-09-22UHC-07611-10—5370 Sage Ct, Sacramento, CA, 958420.50Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418726CLMCatherine Smith1969-04-03UHC-24248-3333090310796032 Market St, Dallas, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-418727CLMCatherine Smith1969-04-03UHC-24248-3333090310796032 Market St, Dallas, TX0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-411061CLMPriya P Rivera1991-01-18UHC-73259-4163167684227262 Ocean Ave, Orlando, FL, 328800.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-420529CLMDiego Jimenez2005-03-07UHC-89670-4090747188856107 Palm Dr, Houston, TX, 770970.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-410145CLMThereza M Diaz1940-08-20UHC-13273-59—1367 Highland Ave # 759, Nashville, TN, 372150.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408630CLMTheresa Munoz1941-06-25UHC-11208-80—5154 Harbor Blvd, Tampa, FL, 336710.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-423064CLMHannah R Santos1999-07-04UHC-76256-4162939632196379 Camelback Rd, Eden Prairie, MN, 553820.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429822CLMEthan Munoz1976-07-13UHC-06062-99—866 Harbor Blvd Apt 28, Tucson, AZ, 857430.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-409540CLMMari Park1979-04-01UHC-74024-31—1510 Grand Ave, Phoenix, AZ, 850340.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430464CLMEmily T Gonzalez1986-09-26UHC-10003-8960788714374296 Willow Ct, San Antonio, TX, 782600.50Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403719CLMJessica Rios1949-07-04UHC-96873-05—552 Spring St, Charlotte, NC, 282380.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403720CLMJessica Rios1949-07-04UHC-96873-05—552 Spring St, Charlotte, NC, 282380.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422581CLMHelen Sanders1964-07-24—58234223815250 Oak St, San Antonio, TX, 782930.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427528CLMAisha Martin1972-02-24UHC-24039-328456994850449 Indian School Rd, Fresno, CA0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410655CLMTerry Brooks1939-10-25UHC-76049-7467862574566223 Cedar Ln # 372, Gilbert, AZ, 852900.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-431101CLMKimbrly Baker1956-01-26——8898 Lake View Rd, San Diego, CA, 921190.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-403858CLMMei Rogers1954-02-16UHC-86487-5251497943714173 Pine Dr, San Antonio, TX, 782730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427288CLMMarcus Jensen1968-07-11UHC-67757-3049886498852794 Pine Dr # 182, San Antonio, TX, 782420.50Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+3 more
CLM-415095CLMNathan Burton1997-10-09UHC-04380-9998567645773629 Union St # 220, Atlanta, GA, 303080.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418813CLMMariana Ferguson1992-09-24UHC-69580-2640950104913155 Pine Dr # 264, Jacksonville, FL, 322950.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421966CLMJeffrey Harrison———6635 Canyon Rd, Las Vegas, NV, 891890.50Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422191CLMAlexander Wells1997-01-06UHC-49517-10—5592 Broadway, Los Angeles, CA, 900670.50Name re-casedTwo-digit birth yearAddress re-casedCity re-cased+3 more
CLM-411619CLMOlivia G Espinoza1998-06-06UHC-99981-1867297381634233 Apache Blvd # 461, Fresno, CA, 937300.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-408445CLMBobby Jacobs1942-09-25UHC-37001-9829494386311545 Jefferson Ave # 934, San Antonio, TX, 782850.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-417970CLMFrances Y Hanson—UHC-45521-79—6548 Willow Ct, Phoenix, AZ, 850410.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-409746CLMBruce Rios1943-12-01—37286992504181 Baseline Rd, Charlotte, NC0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-418156CLMAnthony O Simmons1986-12-03UHC-84844-4145528123838393 Pine Dr, Plano, TX, 750530.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415572CLMDennis Dominguez1966-12-28UHC-79255-89—7029 Union St, San Diego, CA, 921710.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-408777CLMGary Jimenez1976-03-26UHC-29986-9164080899604951 Jefferson Ave Apt 10, Tampa, FL, 336390.50Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406794CLMJulie Pena———59 Mountain View Dr, Tucson, AZ, 857390.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-423348CLMStephen Fernandez1944-08-17UHC-00238-9094834542675103 Lake View Rd, Phoenix, AZ, 850720.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-423114CLMJonathan V Santiago1966-04-23——3230 Market St, San Diego, CA, 921850.50Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+3 more
CLM-415606CLMBeverly Garza1973-04-17UHC-81899-1157351856831411 Indian School Rd, Scottsdale, AZ, 852730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401216CLMEthan Maldonao1970-10-25—56773781722378 Sunset Blvd Apt 39, Phoenix, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-400042CLMEric James2006-07-22——6336 Hillcrest Rd # 398, San Diego, CA, 921450.50Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-420737CLMRebecca Henry—UHC-09021-94—8916 Spring St, Los Angeles, CA, 900170.50Date of birth missingPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 26 of 657PreviousNext