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-401177CLMJerry West2005-09-21UHC-63267-0123858819163779 Baseline Rd, Dallas, TX0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-410658CLMJacqueline Jenkins1954-01-08UHC-69211-438249375053995 Baseline Rd, Minneapolis, MN, 554520.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-400922CLMSantiago Reid1991-05-21UHC-51553-43—8160 Willow Ct, Sacramento, CA, 958740.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
CLM-400358CLMLauren Hansen1979-04-21UHC-05841-1767378384671365 Valley View Dr, Minneapolis, MN0.46Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-409099CLMLuis Greene2000-06-15UHC-14290-02—5329 Lincoln Way Apt 17, Atlanta, GA, 303720.46Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more
CLM-423595CLMChristine Hoffman2003-05-09UHC-38010-16—5855 Spring St, Phoenix, AZ, 850220.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-417775CLMPatricia K Phillips1964-04-13UHC-42386-79—6649 Hillcrest Rd, Plano, TX, 750210.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-406672CLMNicole V Burke1985-04-14UHC-61538-7490498542777663 River Rd, Orlando, FL0.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-417459CLMIsabella Gutierrez1951-12-15UHC-20838-77—4325 Elm St, Fresno, CA, 937900.46Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-415286CLMEdwards Janice1951-03-03UHC-49570-052073584379207 Park Pl, Dallas, TX, 752390.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-432482CLMLuis Jonees1948-05-16UHC-28777-7997780472512298 Sage Ct, Phoenix, AZ, 850960.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-419689CLMRyan Wong1941-03-06UHC-57924-2347727071956303 River Rd, Atlanta, GA, 303370.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-418300CLMGloria Dean2002-02-17UHC-59777-5151855328393807 Meadow Ln, Plano, TX0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-432551CLMRobert Ramos1946-11-20UHC-34491-97—5876 Indian School Rd, San Antonio, TX, 782390.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-401590CLMGloria Chapman1945-07-20UHC-02870-2363431530939217 Elm St, Phoenix, AZ0.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-417542CLMJacob Cooper1976-06-10UHC-40451-3998295743037873 Jefferson Ave # 788, San Diego, CA, 921670.46Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-422885CLMKimberly Hart1995-12-05UHC-93318-2570128465216600 Indian School Rd, Tempe, AZ0.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-426522CLMSteven Spencer1973-06-20—32591856737438 Cedar Ln, San Diego, CA0.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-419153CLMTerry Fernandez1985-03-27UHC-26247-5978443087066649 Grand Ave, Jacksonville, FL0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-408570CLMTimothy Obrien1994-05-22UHC-68603-349698669011631 Sunset Blvd, Mesa, AZ, 852320.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
CLM-424363CLMCharlotte T Turner1962-12-18UHC-11473-2761393560987851 Union St Apt 20, Nashville, TN, 372710.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-421170CLMPriya Ortega1998-10-25UHC-14105-3140572653472401 Park Pl, Charlotte, NC, 282970.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-403522CLMMarcus Nichols2004-08-26UHC-44150-48—7644 Ridge Rd, Minneapolis, MN, 554610.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-418559CLMLauen Graham1979-06-03UHC-12369-4843470873617492 Jefferson Ave Apt 18, Scottsdale, AZ, 852070.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-410539CLMJanet Wood—UHC-90445-014788274782230 Ocean Ave, Phoenix, AZ, 850700.46Name split from “Last, First”Date of birth unreadablePhone reformattedMember ID reformatted+5 more
CLM-430773CLMJose K Owens1982-09-22UHC-76682-9629265374172057 Indian School Rd # 132, Seattle, WA, 981910.46Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+5 more
CLM-424381CLMHeather Brooks1978-07-08UHC-62227-5482258787418233 Indian School Rd, Plano, TX0.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
CLM-432822CLMMargaret Patel1991-06-28UHC-64158-82—6042 Hillcrest Rd Apt 27, Austin, TX0.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-412294CLMGregory K Torres1984-02-22UHC-36621-45—4772 Ocean Ave, Eden Prairie, MN0.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-400231CLMAustin Stone1949-11-17—46255305744169 Jefferson Ave, Chandler, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-416467CLMLisa Lewis1951-03-27UHC-05664-7134636812612672 Park Pl, Jacksonville, FL, 322020.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-420079CLMJasoon A Powwell1964-02-12UHC-18174-8046469378785736 Meadow Ln, Miami, FL, 331520.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-405615CLMAmber S Garza1950-05-04——6737 Apache Blvd, Phoenix, AZ, 850010.46Middle initial moved out of first nameName re-casedDate of birth reformattedPhone missing area code+5 more
CLM-414358CLMAna P Wong1980-05-28UHC-13625-7639559593764229 Pine Dr # 246, Scottsdale, AZ, 852770.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-417284CLMAaaron Ramos1994-06-24UHC-51082-43—1086 Desert Sky Blvd, Orlando, FL, 328540.46Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-413709CLMSantiago Moore1963-11-19—57778466573960 Spring St, Nashville, TN0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-427351CLMWillie Chavez2007-02-03UHC-34974-9951470863634782 Pine Dr, Denver, CO, 802890.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-423470CLMDiiego Fields1958-05-17——7626 Union St # 230, Los Angeles, CA, 900920.46Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
CLM-429314CLMValentina Stevens1943-01-26—21699986085643 Meadow Ln, Eden Prairie, MN, 553580.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-419468CLM—Junk1962-03-27—84543559255075 Spring St Apt 12, Austin, TX, 787870.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-426081CLMMason Smith1961-02-15UHC-13514-3526625256693073 Jefferson Ave, Tempe, AZ, 852890.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-424924CLMDoris T Ford1958-02-28UHC-97244-05—1242 Lake View Rd # 450, Scottsdale, AZ, 852240.46Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
CLM-414448CLMEmily Wels1971-03-28—87982403102695 Mountain View Dr, San Diego, CA, 921550.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
CLM-403067CLMAlexis Garza1972-01-15—65641501997046 Pine Dr, Eden Prairie, MN0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-415239CLMAisha Owens2002-06-26UHC-84488-9623170753187806 Main St, Orlando, FL, 328680.46Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-427674CLMGrace Wong2000-12-03UHC-13056-47—3571 Spring St, Sacramento, CA0.46Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+5 more
CLM-430178CLMEthan EJunk1961-03-01UHC-07381-6875838119828361 Indian School Rd, Nashville, TN, 372480.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-410288CLMAndrew McDonald—UHC-38489-9143743425557493 Sunset Blvd, Chandler, AZ, 852820.46Name split from “Last, First”Date of birth missingPhone reformattedStreet suffix standardised+5 more
CLM-400369CLMGrace Burton1981-01-26UHC-52024-7528894499938064 Maple Ave, Columbus, OH0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-405921CLMSteven Ortaga1941-03-27—28286261061456 Jefferson Ave, Tempe, AZ, 852390.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
32,829 rows, page 12 of 657PreviousNext