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-426385CLMShirley Soto1948-09-15UHC-96595-31—6577 Baseline Rd, Nashville, TN0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-419889CLMDiana Flores1943-09-06UHC-29823-1555095075568278 Hillcrest Rd, Tucson, AZ, 857500.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-418624CLMEdward B Russell1991-02-21UHC-31057-9440299660997133 Meadow Ln # 217, Tucson, AZ0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-424867CLMHiroshi Q Brooks1990-08-15UHC-65032-33—741 Canyon Rd, Nashville, TN, 372320.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-429085CLMThomas Snyder1999-07-18—51498563682100 Baseline Rd, Las Vegas, NV, 891160.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422482CLMBobby Wilson1980-12-08——2048 Lake View Rd, San Antonio, TX, 782460.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-429140CLMCarl Gibson1986-02-04——1931 Camelback Rd, Jacksonville, FL, 322360.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-415488CLMRebecca U Hart1962-03-15——2012 Jefferson Ave, Dallas, TX, 752840.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-414236CLMLori I Austin2003-07-23UHC-45897-76—500 Camelback Rd, San Diego, CA, 921210.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407771CLMBrian Wang1954-12-26UHC-03998-29—2019 Valley View Dr # 248, Eden Prairie, MN, 553560.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401095CLMDaniel Bailey1967-02-12——6151 Desert Sky Blvd, Mesa, AZ, 852760.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419850CLMMcDonald Eric2006-08-23—75027900874372 Central Ave, Minneapolis, MN, 554640.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-403187CLMYuki A Herrera2004-09-05—22091782551268 Palm Dr, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-400484CLMSantiago Peters1999-11-21——8248 Willow Ct Apt 7, San Antonio, TX, 782100.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-406511CLMKayla Henry1969-11-11UHC-88085-99—5247 Spring St, Columbus, OH0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-406859CLMWalter Murray—UHC-21262-70—9728 Mesa Dr, Las Vegas, NV, 891660.52Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-420482CLMDorothy Hall—UHC-15763-54—6357 Highland Ave, Las Vegas, NV, 891310.52Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-429160CLMJason Z Thompson1994-08-22—59130302331783 Indian School Rd, Nashville, TN, 372410.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-423213CLMAndrea Stewart1963-09-05——9243 Pine Dr # 435, Chandler, AZ, 852020.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-424245CLMGabriel Freeman1997-01-10——8222 Park Pl, Las Vegas, NV, 891590.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-400052CLMDiane Lee1970-01-11UHC-83472-9183877247254401 Sunset Blvd, Scottsdale, AZ, 852000.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427464CLMJacqueline Bennett—UHC-63718-39—5967 Washington St, Tempe, AZ, 852710.52Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-400574CLMKyle Williams—UHC-29313-6781398072614352 Indian School Rd, Tampa, FL, 336820.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-431573CLMCatherine Wright———4260 Lake View Rd, Jacksonville, FL, 322560.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-405833CLMSara Carr1982-05-24UHC-76869-45—3915 Washington St, Nashville, TN, 372930.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-409656CLMDylan Berry—UHC-73876-98—7702 Harbor Blvd, Plano, TX, 750590.52Date of birth unreadableMember ID reformattedState name converted to codeZIP+4 trimmed+2 more
CLM-413190CLMFrank Salazar———7978 Desert Sky Blvd, Tucson, AZ, 857180.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-413191CLMFrank Salazar———7978 Desert Sky Blvd, Tucson, AZ, 857180.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-406338CLMFrank Guzman2006-10-09UHC-66444-28—1500 Spring St, Fresno, CA, 937230.52Name split from “Last, First”Two-digit birth yearState name converted to codePlan code upper-cased+2 more
CLM-422647CLMPhilip Vasquez1942-01-18UHC-19675-29—1135 Sage Ct, Jacksonville, FL, 322370.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-432796CLMStephen C Murray1962-05-26UHC-92761-0181138487024148 Main St, Seattle, WA, 981010.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-414320CLMAngela E Woods—UHC-24555-87—3702 Central Ave, Los Angeles, CA, 900470.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-411939CLMKeith Ramirez1954-06-19UHC-39559-25—339 Broadway, Tucson, AZ, 857050.52Name split from “Last, First”City re-casedState name converted to codeGender normalised+2 more
CLM-428368CLMTJunk1991-02-02UHC-14684-42—2259 Union St, Seattle, WA, 981730.52Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403408CLMVirginia Nelson1942-06-13—33790334835994 Ridge Rd # 606, Tempe, AZ, 852830.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-416222CLMDonna Edwards2006-07-13UHC-93006-6939877020807842 Harbor Blvd, Gilbert, AZ0.52Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+2 more
CLM-415975CLMMegan Burton1962-12-19UHC-70543-77——0.52Name split from “Last, First”Date of birth reformattedPhone missing area codeGender normalised+2 more
CLM-421366CLMNicholas Jacobs—UHC-63369-61—3122 Bayshore Dr, Sacramento, CA, 958210.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-409804CLMKnight Wayne1983-04-27UHC-95604-13—6599 Market St # 292, Chandler, AZ0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411601CLMChristian U Walker1987-07-26UHC-49864-1335323289314100 Baseline Rd, San Diego, CA, 921120.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424089CLMJack Franklin1968-02-01—22243802553069 Mountain View Dr, Tampa, FL, 336400.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
CLM-422002CLMSara J Garcia1995-02-24—7497694651107 Maple Ave, Orlando, FL, 328620.52Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+2 more
CLM-404506CLMNathan W Clark1967-04-01UHC-59130-6750222981479074 Hillcrest Rd, Denver, CO, 802020.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-424783CLMCarolyn Price—UHC-44884-39—524 Broadway, Nashville, TN, 372520.52Date of birth unreadableAddress re-casedState name converted to codeGender normalised+2 more
CLM-427456CLMJack Daniels1952-12-08—67647841726951 Church St Apt 7, Atlanta, GA, 303130.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415213CLMLucia L Holmes2007-02-04——8617 Highland Ave, Glendale, AZ, 853140.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-405793CLMWalter Mejia1953-04-24——2777 Indian School Rd, Houston, TX0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-412142CLMSean A Roberts1959-07-19UHC-73892-4421648101497042 Ocean Ave, Eden Prairie, MN0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-429211CLMRonald Henry—UHC-15188-9465730507008751 Park Pl, Chandler, AZ0.52Date of birth unreadablePhone reformattedMember ID reformattedZIP missing+2 more
CLM-420395CLMChristian Simmons1942-08-17——2759 Main St, Atlanta, GA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
32,829 rows, page 47 of 657PreviousNext