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-423577CLMPeter Y Hernandez——88946005737574 Baseline Rd, Gilbert, AZ, 852040.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413459CLMJason Johnston1987-07-21——5392 Highland Ave Apt 30, San Diego, CA, 921020.50Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
CLM-404228CLMWilile N Gonzalez1938-08-11—49975649278463 Indian School Rd Apt 13, Seattle, WA, 981600.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-427523CLMJudith Guzman1944-02-20——3680 Church St, Glendale, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-415966CLMJean Yang1955-02-15UHC-55015-0776830894285899 Main St, Atlanta, GA, 303030.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-409771CLMAnn O Jacobs1982-08-04UHC-08255-9759154757065062 Lake View Rd, Fresno, CA0.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416526CLMCharles Griffin1970-05-26UHC-14601-2361632102339665 Maple Ave, Mesa, AZ0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429888CLMAlan Olson1953-01-19—40322493959036 Ridge Rd, San Antonio, TX, 782010.50Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
CLM-405115CLMJesse Carroll1995-04-15UHC-51047-789658492887291 Bayshore Dr, Houston, TX, 770170.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-418389CLMMary Fuller1963-10-05UHC-43878-4673867999356246 Church St, Sacramento, CA, 958340.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-409625CLMAnn Kelley1967-01-18——2306 Union St, Scottsdale, AZ, 852360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425312CLMRyan Ruiz1957-02-17——1962 Central Ave Apt 14, Minneapolis, MN, 554690.50Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-423346CLMMadison D Kelly1952-05-25UHC-20054-54—5238 Sage Ct Apt 9, Nashville, TN, 372750.50Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+3 more
CLM-415578CLMMark H Jones1987-07-17——1605 Central Ave, Glendale, AZ, 853130.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-424863CLMMaria Weaver1980-05-17UHC-03750-8143659754698311 Valley View Dr, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424523CLMBruce Obrien1991-04-12UHC-80024-15—8188 Desert Sky Blvd, Eden Prairie, MN, 553890.50Name split from “Last, First”Name re-casedStreet suffix standardisedAddress re-cased+3 more
CLM-418347CLMMadison P Watsn2001-01-27UHC-15705-4349454299253991 Pine Dr, Phoenix, AZ, 850370.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-426278CLMNancy Valdez2002-06-24——3019 Park Pl, Tucson, AZ, 857340.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-419532CLMJack Vazquez2006-09-18—72374372297549 Broadway Apt 24, San Antonio, TX, 782820.50Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+3 more
CLM-431495CLMRebecca W Adams1965-02-17UHC-04443-52—7683 Meadow Ln, Tempe, AZ, 852130.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
CLM-419573CLMDylan O Robinson2007-07-15UHC-25806-40—3396 Maple Ave, Orlando, FL, 328190.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-422046CLMCampbell Carlos1961-06-18UHC-89227-34—1159 Bayshore Dr Apt 18, Austin, TX, 787620.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-425829CLMWalter Guerrero2001-02-15UHC-26876-3435487031928015 Apache Blvd # 113, Minneapolis, MN, 554690.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408783CLMEugene Arnold1945-12-07——8379 Valley View Dr, Gilbert, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-424240CLMRebecca I Myers1985-12-02UHC-44550-43—2515 Palm Dr, Tucson, AZ, 857670.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-422062CLMJanet Aguilar1958-11-13——4575 Church St # 766, Tucson, AZ, 857140.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407694CLMRobert Weber1982-03-12UHC-94741-69—5930 Maple Ave, Chandler, AZ0.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-404260CLMRamos Maria1940-05-22UHC-48526-6625579358783571 Sage Ct, Tempe, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-416830CLMPriya Reynolds1995-05-20UHC-03653-5137554156563380 Camelback Rd, Tucson, AZ0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-423752CLMKelly H Harris1961-03-22UHC-15595-64—3408 Hillcrest Rd, Minneapolis, MN, 554900.50Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432237CLMCarl West1992-01-06——3663 Grand Ave Apt 38, Glendale, AZ, 853530.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-420313CLMGregory Smith1987-10-09—40266049222142 Indian School Rd, Charlotte, NC, 282070.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429180CLMMegan Richardson1959-05-13UHC-31006-11—2569 Indian School Rd, Orlando, FL, 328550.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-430185CLMRonald Thomas1999-03-07UHC-18112-046868544321700 Grand Ave, Los Angeles, CA, 900540.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-407241CLMGrace Patterson1983-05-26UHC-32210-74—3189 Maple Ave Apt 3, Austin, TX0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-418987CLMAhmed Sanders1960-10-26—42099771322821 Sunset Blvd, Sacramento, CA, 958770.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-400283CLMWalter Estrada1987-03-07UHC-13603-42—1573 Indian School Rd, Eden Prairie, MN0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-410859CLMSusan Burke1985-02-25UHC-70463-11—4081 Oak St, Mesa, AZ, 852660.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-415601CLMJacqueline Gonzales1997-03-13UHC-44443-96—5010 Cedar Ln # 809, Mesa, AZ, 852260.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-431632CLMAustin Henderson1941-12-22——4815 Mesa Dr, Charlotte, NC, 282500.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-417843CLMWalter Dominguez1944-11-03UHC-68577-83—7860 Palm Dr, Atlanta, GA, 303040.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-409950CLMDouglas Schultz1974-07-19UHC-55063-3177231707733366 Elm St, Miami, FL, 331810.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414338CLMLucia V Welch1983-09-18UHC-74680-1159456306771802 Spring St, Mesa, AZ, 852130.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415102CLMMichelle Lee1942-09-04UHC-24537-632074848993182 Canyon Rd # 653, Los Angeles, CA, 900300.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
CLM-426016CLMAlbert Larson1939-03-03UHC-99616-93—197 Park Pl, Glendale, AZ, 853990.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431323CLMJack N Jordan——81236203547965 Washington St, Houston, TX0.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-409059CLMDonna Gutierrez1958-05-06UHC-64677-45—3046 Indian School Rd, Gilbert, AZ0.50Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-422009CLMEdward Sanchez1951-09-13—92258852929732 Market St, Nashville, TN0.50Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
CLM-431045CLMChristine Sullivan2007-09-24——4856 Indian School Rd, Eden Prairie, MN, 553320.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-426614CLMElizabeth Rodrigeuz1963-12-06—27871509217374 Sage Ct, Tampa, FL, 336020.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 28 of 657PreviousNext