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-432545CLMJdy Wells1989-06-18——5771 Indian School Rd, Scottsdale, AZ0.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
CLM-402845CLMJanet W Lopez—UHC-53522-2351361974587540 Mountain View Dr, Miami, FL, 331400.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
CLM-429334CLMBarbara Kennedy1967-03-23UHC-82530-0254261642664915 Elm St, Tampa, FL0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-423417CLMEmily Snyder1990-07-08——5701 Hillcrest Rd, Seattle, WA, 981500.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-408836CLMCharles F Edwards1939-11-15UHC-50789-0768469646157460 Bayshore Dr Apt 26, San Antonio, TX, 782200.46Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+5 more
CLM-430644CLMRebecca Gardner1948-03-04UHC-93513-5341638473869408 Union St, Eden Prairie, MN0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-415715CLMCharlotte Lopez1943-04-20UHC-02280-0265345224221647 Spring St, Tempe, AZ, 852360.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-402068CLMKevin Gozales1980-04-17UHC-66033-8276321678982112 Hillcrest Rd Apt 6, Chandler, AZ, 852600.46Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
CLM-422653CLMLori Li2000-05-16UHC-86987-5621375292887785 Ocean Ave, San Diego, CA, 921240.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-421623CLMOlivia Gonzales1943-12-08UHC-00411-18—8846 Apache Blvd # 256, Seattle, WA0.46Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more
CLM-414522CLMMateo Perez——90093943522630 Maple Ave, Tampa, FL, 336360.46Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+5 more
CLM-416927CLMJeremy L Reed1948-03-21UHC-59517-3434648006668795 Valley View Dr # 754, Nashville, TN, 372370.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-417712CLMLori Contreras1964-02-14UHC-34891-7285947202355981 Maple Ave, Dallas, TX0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-406778CLMAlexander L Hunt2003-02-22UHC-71385-5351867288752344 Church St, Miami, FL, 331660.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-431909CLMZachary Ramos2005-02-23—46599333399573 Valley View Dr, Miami, FL, 331730.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-402266CLMCamila Snyder1953-12-15—34199190785462 Union St, Austin, TX, 787760.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-406098CLMPhilip White1963-09-19UHC-62738-03—9889 Canyon Rd, Chandler, AZ0.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-414468CLMWill Allen1953-06-12—3647074187430 Highland Ave # 819, Dallas, TX, 752670.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409533CLMSharno Morrison1990-09-15UHC-24318-5874945162322424 Cedar Ln Apt 26, Seattle, WA, 981570.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-404683CLMValentina Ward1990-11-26UHC-06830-3576139351828511 Harbor Blvd, Charlotte, NC0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-404454CLMLarry F Martin2001-01-13——4620 Valley View Dr, San Antonio, TX, 782560.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411966CLMMegan Herrera1991-02-23—70871729704453 Indian School Rd Apt 40, Denver, CO0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-404851CLMRussell M Elliott2003-09-13——1646 Grand Ave, Atlanta, GA, 303300.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-421746CLMAlan G Bradley1971-09-10—44951704825458 Oak St, Tampa, FL, 336330.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403443CLMDonna Berry1994-09-24UHC-30521-3384652549558353 Bayshore Dr, Atlanta, GA, 303290.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423625CLMEric Simpson1998-10-18UHC-65773-7098437521108776 Canyon Rd, Columbus, OH, 432890.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-417175CLMShirley Bennnett1955-08-22——8915 Canyon Rd, Plano, TX, 750240.48Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-406850CLMDiego Gonzales1982-03-26——3904 Market St, Minneapolis, MN, 554080.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-427172CLMBryan Black1940-01-26—3844308523985 Apache Blvd # 477, Minneapolis, MN0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-423096CLMKaren Green1953-06-27—67261323241578 Camelback Rd, Dallas, TX, 752980.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402074CLMMichael Boyd1992-07-23UHC-19257-78—5328 Ridge Rd, San Antonio, TX, 782310.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408368CLMMason Maldonado1982-10-08UHC-54625-2327228623841570 Union St, Tampa, FL, 336040.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421741CLMNatalie Ward1959-04-17—59492895952490 Apache Blvd, Gilbert, AZ, 852640.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417606CLMArthur Gibson1982-09-25UHC-31926-06—6998 Cedar Ln, Austin, TX0.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
CLM-420233CLMKaren Q Ruiz1943-08-01UHC-25421-2591932301215995 Sage Ct, Austin, TX, 787820.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-432778CLMNicole M Robertson1982-10-04UHC-44037-37556998175070 Lake View Rd Apt 32, Nashville, TN, 372760.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-413427CLMChristine James1957-02-26—63022363627804 Apache Blvd, Chandler, AZ0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-411571CLMGlora Lynch1980-11-13UHC-57656-6737797579754678 Grand Ave Apt 17, Tempe, AZ, 852260.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-427352CLM—Junk1966-06-01UHC-51600-7178620619202572 Hillcrest Rd, Miami, FL, 331110.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-409235CLMLogan Hamilton1972-01-12UHC-20469-9134478250107925 Pine Dr, Charlotte, NC, 282170.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-431143CLMVictoria Watson1965-04-28UHC-16748-1361529454365576 Sunset Blvd, Glendale, AZ, 853670.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-413779CLMGloria Ray—UHC-76213-90823277365864 Central Ave, Tucson, AZ, 857120.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-427850CLMDlyan Cole2004-07-01UHC-93588-47—6513 Cedar Ln, Phoenix, AZ, 850860.48Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-416040CLMKathryn A Hayes1971-09-11UHC-11060-8955840577339284 Cedar Ln, Jacksonville, FL, 322610.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
CLM-423729CLMHarold Q Vasquez1944-08-02UHC-80565-93—1180 Sage Ct, Phoenix, AZ, 850280.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410749CLMGloria A Luna2000-10-22UHC-66011-868468266485104 Ocean Ave, San Antonio, TX, 782210.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-427365CLMPeterJunk1976-01-23UHC-85220-8645048369056884 Maple Ave, Gilbert, AZ, 852650.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420572CLMAustin Matthews1998-04-17—790974151385 Union St # 715, Tampa, FL, 336150.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-424805CLMMarcus Griffin1955-02-22UHC-16047-81—6506 Spring St # 242, Phoenix, AZ0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-427009CLMKimberly Vargas1956-12-08UHC-25104-4294199865975780 Sage Ct, Tampa, FL0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
32,829 rows, page 14 of 657PreviousNext