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-406213CLMMaria E Little1969-04-02UHC-16279-83—1839 Apache Blvd, Columbus, OH, 432380.48Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403944CLMSean Carter1949-03-08UHC-65097-4273967858957966 Grand Ave, Tucson, AZ, 857190.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405123CLMKathleenJunk—UHC-42417-2497387383838881 Pine Dr, Fresno, CA, 937620.48Name re-casedDate of birth unreadableMember ID reformattedStreet suffix standardised+4 more
CLM-412597CLMKathleen V Brown1994-08-14UHC-43169-47—3092 Sage Ct Apt 8, Orlando, FL, 328540.48Name split from “Last, First”Date of birth reformattedMember ID reformattedUnit split from street+4 more
CLM-418701CLMPaul AJunk1953-03-19UHC-85993-86—2801 Grand Ave Apt 18, Fresno, CA, 937390.48Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-432059CLMKevin P Hughes1944-07-02UHC-58283-90—7328 Bayshore Dr # 332, Glendale, AZ, 853190.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
CLM-425990CLMDebra Marshall2003-04-13UHC-06922-26—5514 Canyon Rd, Seattle, WA, 981350.48Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+4 more
CLM-409856CLMEric Fisher1942-10-10UHC-76932-93—799 Lake View Rd, Chandler, AZ, 852440.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405886CLMEthan R Robertson——53633028244600 Canyon Rd, Seattle, WA, 981060.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-423457CLMJustin Shaw1942-04-02UHC-89927-08—5769 Oak St, Las Vegas, NV, 891120.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-415689CLM—Junk1946-11-15UHC-44057-3155230880241746 Mountain View Dr, Phoenix, AZ, 850030.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407204CLMJanet Boyd1976-01-03—7848160075711 Desert Sky Blvd, Nashville, TN, 372710.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-401868CLMNicholas K Andrews1985-11-19——4409 Lincoln Way, Dallas, TX0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401869CLMNicholas K Andrews1985-11-19——4409 Lincoln Way, Dallas, TX0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412689CLMIsabella P Wilson—UHC-32664-9827859961028501 Spring St, San Diego, CA, 921130.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420023CLMAshley Grrett1975-10-05UHC-61998-34—5074 Sage Ct, Phoenix, AZ, 850000.48Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411339CLMAnthony Hill2003-07-19UHC-15437-91—7834 Palm Dr Apt 26, Mesa, AZ0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409649CLMElijah Owens1989-06-04UHC-32230-666147492074428 Church St, Scottsdale, AZ, 852760.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418800CLMMadison Vazquez1994-10-09UHC-54474-8726978149706427 Mesa Dr Apt 14, Miami, FL, 331090.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-403474CLMKtahryn Piarce1939-02-21UHC-95401-16—9528 Washington St, Tampa, FL0.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
CLM-414372CLMBrian G Lynch1980-12-15——6503 Harbor Blvd, Jacksonville, FL, 322670.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-428569CLMAngela Burns1959-02-14UHC-19715-2249094473033613 Elm St Apt 24, Tucson, AZ, 857610.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-402554CLMHarold Soto1999-02-06UHC-32025-8466228330635478 Elm St, Miami, FL, 331230.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416381CLMJoshua Gibson1945-05-01UHC-44042-2994463886315857 Oak St, Nashville, TN0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424309CLMLinda Moore1983-05-10UHC-97227-77—2502 Valley View Dr, Gilbert, AZ, 852330.48Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-426814CLMKeith Watson1991-02-08UHC-99757-95—907 Central Ave # 294, San Antonio, TX, 782650.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-423751CLMKelly Harris1961-03-22UHC-15595-6469193970313408 Hillcrest Rd, Minneapolis, MN, 554900.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408489CLMMadison X Patel2000-01-10—84573459644495 Union St, Glendale, AZ0.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-413990CLMGabriel Luna1959-09-13UHC-01468-90—3187 Oak St, San Antonio, TX, 782780.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-425593CLMSandra Davis1965-02-20—4305948939680 Maple Ave, Houston, TX, 770460.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-425594CLMSandra Davis1965-02-20—4305948939680 Maple Ave, Houston, TX, 770460.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-429382CLMCheryl Robertson1960-03-26UHC-65707-9344331829322346 Lincoln Way, Scottsdale, AZ, 852030.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-402206CLMJulie Hansen1973-09-25UHC-11629-44—667 Oak St, Eden Prairie, MN0.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407766CLMKimberly Robinson2008-05-16UHC-32138-4988525595841348 Mountain View Dr, Minneapolis, MN0.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-410971CLMSandra Peterson1970-06-24UHC-01975-4263120632299822 Washington St, Los Angeles, CA, 900970.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-425809CLMGary Kelly1969-12-25—90059105749565 Valley View Dr, San Antonio, TX, 782370.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-410013CLMTeresa Santos1959-12-22UHC-28319-23—194 Oak St, Dallas, TX, 752560.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-424766CLMCamila Washington—UHC-17485-33—456 Market St, Las Vegas, NV0.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
CLM-429014CLMCharlotte Perry1983-12-12UHC-56932-15—6577 Spring St, Scottsdale, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-414495CLMAisha R Wright1949-02-26UHC-95172-81—3424 Spring St, Plano, TX, 750440.48Name split from “Last, First”Date of birth reformattedMember ID reformattedSSN last four extracted+4 more
CLM-409486CLMMargaret Stone1979-11-12—50385177905524 Pine Dr, Plano, TX0.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-422796CLMShirley Hunter1958-03-17UHC-87251-2083446627224214 Spring St, San Diego, CA, 921730.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-420562CLMPriya L Wagner1987-09-09—48389255054010 Park Pl, Scottsdale, AZ, 852400.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430459CLMBen Ferguson1947-02-20—52823235656269 Willow Ct, Eden Prairie, MN, 553250.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-405287CLMPatrick V Armstrong1982-03-02UHC-19406-8156046417862334 Jefferson Ave Apt 15, Nashville, TN, 372310.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-406560CLMAshley Hernandez1948-03-21—33191893303595 Forest Ave # 358, Chandler, AZ, 852820.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-405963CLMShirley Hall1944-03-18UHC-69762-7225456128533326 Baseline Rd, Charlotte, NC, 282830.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-427996CLMRaymond Reed1997-07-04UHC-01048-26—8798 Lincoln Way, Orlando, FL, 328560.48Name split from “Last, First”Date of birth reformattedMember ID reformattedSSN last four extracted+4 more
CLM-414518CLMJose Owens1987-02-07UHC-85056-73—1384 Pine Dr, Plano, TX, 750610.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-405627CLMEdward T Franklin1972-08-05UHC-16332-5693128795642087 Hillcrest Rd, Scottsdale, AZ, 852240.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
32,829 rows, page 16 of 657PreviousNext