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-425174CLMJames Richardsno—UHC-80635-1636583971854127 Highland Ave, Gilbert, AZ, 852290.58Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+5 more
CLM-412850CLMKathleen Butler1997-07-03—57434130847271 Jefferson Ave, Jacksonville, FL, 322630.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-416886CLMGregory Young1988-10-01—65746843597653 Baseline Rd, Houston, TX, 770220.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-412821CLMTeresa Reynolds1957-06-02UHC-27736-3320969711366445 Park Pl, Plano, TX, 750290.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-431416CLMZachary L Jenkins1986-03-05UHC-48075-097163638531911 Apache Blvd, Austin, TX, 787520.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-419125CLMHarold Marquez1987-02-02UHC-77141-5893498337597215 Highland Ave, Charlotte, NC0.58Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-403603CLMPeter Rose1939-04-16—74940002017632 Maple Ave, Sacramento, CA, 958840.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-416032CLMMarc J Tucker2000-11-21—60691592666343 Palm Dr, Austin, TX, 787990.58Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
CLM-411321CLMRoy Simmons2005-01-21UHC-73280-2355866560581753 Baseline Rd, Scottsdale, AZ, 852720.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-412953CLMRachel Diaz1999-12-10UHC-34219-6752665248559301 Highland Ave, Nashville, TN, 372320.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-423083CLMMark Day—UHC-40883-2686947620109298 Bayshore Dr, Charlotte, NC, 282760.58Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
CLM-417011CLMJustin Jackson2000-09-20—8585457206446 Highland Ave, San Antonio, TX0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-416717CLMJery Y Montgomery1973-01-26—69698473239637 Valley View Dr, San Diego, CA, 921370.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-412845CLMJerry Romero1964-03-24UHC-98312-99—855 Lake View Rd Apt 2, Tucson, AZ, 857860.58Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-412844CLMJerry Romero1964-03-24UHC-98312-99—855 Lake View Rd Apt 2, Tucson, AZ, 857860.58Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-425522CLMJean L Kennedy1943-08-20UHC-41234-2998066391813458 Maple Ave, Phoenix, AZ, 850330.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-419410CLMDebra Cox1993-06-22UHC-62132-1528290831258967 Desert Sky Blvd, Columbus, OH, 432970.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-431908CLMZachary I Ramos2005-02-23—46599333399573 Valley View Dr, Miami, FL, 331730.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-406948CLMVincent Torres1943-05-28—9349163273867 Spring St, Minneapolis, MN, 554370.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-403427CLMJessica Burns2007-05-20UHC-28147-7348636337358189 Sage Ct # 415, Seattle, WA, 981140.58Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+5 more
CLM-412160CLMBen Rice2001-11-22UHC-00900-4087452655265390 Baseline Rd, Los Angeles, CA, 900590.58Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-416776CLMBryan Stavens1997-05-16UHC-77358-206423989218287 Lincoln Way, Eden Prairie, MN0.58Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-411313CLMJudy Rivera1960-05-09——6789 Main St, Charlotte, NC, 282090.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-432003CLMMatthew P Guerrero1986-04-08—92488999083291 Ridge Rd, Fresno, CA, 937890.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-410416CLMTheresa Foster1965-09-06UHC-25697-0646066312438878 Lincoln Way, San Antonio, TX0.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-421006CLMAdam McDoonald1986-08-22—68152304565555 Sunset Blvd, Columbus, OH, 432140.58Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
CLM-422086CLMJoyce I Duncan1994-06-08UHC-27486-9980441944901676 Baseline Rd, Seattle, WA, 981390.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-401918CLMMary Mason1994-08-06UHC-85232-94—9474 Lake View Rd, Austin, TX, 787330.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-404495CLMHeather Soto1972-04-28UHC-92949-9197425593714780 Union St, Tampa, FL, 336620.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-427051CLMIsabella Singh1949-11-14—91625092208764 Baseline Rd, Columbus, OH, 432960.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-426676CLMBetty Pena1979-03-21UHC-94994-5967751510789749 Pine Dr, Jacksonville, FL, 322300.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-415099CLMEmily Lane2003-12-27—74690338926535 Mountain View Dr, Atlanta, GA0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-426362CLMMarcus Taylor1995-03-07UHC-98273-96—2498 Harbor Blvd, Austin, TX, 787870.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-425705CLMJack Coleman1964-09-02UHC-66711-7637793674668122 Main St, Phoenix, AZ, 850880.58Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-430668CLMDoris Lynch1946-01-01UHC-46221-837339846398905 Mountain View Dr, San Diego, CA, 921750.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-407593CLMJoe Turner1997-09-21UHC-65327-3961176243903679 Lincoln Way, Denver, CO, 802270.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-420939CLMJudith N Soto1995-03-06UHC-74540-84—580 Jefferson Ave, San Antonio, TX, 782240.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-420185CLMBrenda Clark1987-12-05UHC-60924-4094646994946334 Bayshore Dr, Gilbert, AZ0.58Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-410160CLMAustin Schmidt1973-01-04UHC-91220-4842729608626057 Palm Dr, Gilbert, AZ, 852860.58Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
CLM-416974CLMJose Q Williamson1947-04-24UHC-42690-5951772438566243 Ridge Rd, Tucson, AZ, 857510.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-409852CLMDenise Stephens1995-08-16UHC-99350-1691468494852140 Baseline Rd, Tucson, AZ, 857520.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-405926CLMVaalentina Knight1972-03-19UHC-33721-2893853318398232 Elm St, Miami, FL, 331660.58Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
CLM-415283CLMKeith I Cook1957-07-25—65073169811901 Ocean Ave, Tempe, AZ, 852590.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-430092CLMYuki Spencer1939-06-28UHC-90438-72—1176 Ocean Ave, Miami, FL, 331860.58Name split from “Last, First”Two-digit birth yearState name converted to code
CLM-419930CLMSamuel Sullivan2006-01-05UHC-70445-3235653451982208 Indian School Rd, Seattle, WA, 981820.58Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-413760CLMAndrea Wilson2006-01-08UHC-84921-80—4292 Pine Dr, Tempe, AZ0.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-423884CLMMason Rios1980-07-07UHC-58394-4570524572598660 Central Ave, Houston, TX, 770950.58Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
CLM-415696CLMJudy Burns1980-12-09—28991482053367 Maple Ave # 582, Seattle, WA, 981090.58Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-428355CLMKeith Thompson1963-12-21UHC-58395-71—6960 Indian School Rd, Jacksonville, FL0.58Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-412903CLMBarbara Boyd1966-09-24—63361463389280 Valley View Dr, Las Vegas, NV, 891180.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
32,829 rows, page 63 of 657PreviousNext