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-411991CLMValentina Ortiz1953-05-05—50868201396321 Mesa Dr, Nashville, TN, 372560.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-431755CLMAnn J Espinoza1943-08-06UHC-65635-7048079053792040 Desert Sky Blvd, Sacramento, CA0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405412CLMHannah G Garrett1993-01-09UHC-32176-426057650156478 Sunset Blvd, Minneapolis, MN0.62Member ID reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-427514CLMKimberly Gordon2006-12-28UHC-89560-9578458452601992 Mountain View Dr, Charlotte, NC, 282880.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-429530CLMValentina Duncan2007-12-15—57170079665071 Maple Ave, Minneapolis, MN, 554110.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401068CLMNathan Delgado1947-12-17—20560786632913 Willow Ct, Chandler, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432590CLMChrystina Martinez2000-02-25——704 Central Ave, Minneapolis, MN, 554230.62Name re-casedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-422423CLMThomas U Baker1955-02-04UHC-94453-11—9431 Desert Sky Blvd, Eden Prairie, MN, 553920.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403002CLMGary B Barnes1955-08-21UHC-36095-5760576124714992 Ridge Rd, Mesa, AZ, 852650.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-407584CLMHannah Clark1981-05-15UHC-95602-2968199262182713 Jefferson Ave, Fresno, CA, 937370.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425135CLMMarcs Wallace1954-02-11——5894 Bayshore Dr, Miami, FL0.62Name re-casedDate of birth reformattedCity re-casedZIP missing+3 more
CLM-402756CLMLucia D Bryant1975-06-09UHC-06528-43—7161 Canyon Rd, Houston, TX, 770780.62Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
CLM-427830CLMWayne Z Cruz1965-09-07—47843117185670 Indian School Rd, Seattle, WA, 981790.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426432CLMAbigail W Baks1942-09-20UHC-27644-46—9274 Oak St, Tempe, AZ, 852000.62Date of birth reformattedPhone missing area codeMember ID reformattedStreet suffix standardised+3 more
CLM-423999CLMFrank Richards1983-06-28—38348506097748 Meadow Ln, Jacksonville, FL, 322010.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408440CLMRalph Carpenter1967-06-11—78949092669818 Baseline Rd, Jacksonville, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409390CLMJonathan Gardner1959-12-22—26070697864766 Canyon Rd, Dallas, TX, 752440.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426994CLMHarold Matthews1967-11-23UHC-47451-7688146011461371 Elm St # 725, Nashville, TN, 372120.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-414201CLMSantiago Black1982-03-02UHC-79415-28—1674 Meadow Ln, Miami, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408464CLMAmber G Perez1969-03-01UHC-63575-65—2888 Mesa Dr, Mesa, AZ, 852180.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410856CLMSusan Burke1985-02-25UHC-70463-1128242282924081 Oak St, Mesa, AZ, 852660.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-410857CLMSusan Burke1985-02-25UHC-70463-1128242282924081 Oak St, Mesa, AZ, 852660.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-420551CLMKevin G Richards1963-12-08UHC-68933-7130977787678866 Union St, Los Angeles, CA, 900440.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405248CLMElijah X Wright1994-09-07UHC-48082-0564734429625458 Jefferson Ave, Los Angeles, CA, 900500.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405471CLMRaplh G Kim1997-02-20UHC-75355-51—4191 Valley View Dr, Scottsdale, AZ, 852900.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-424493CLMRyan Ramirez—UHC-68274-9124133391162106 Cedar Ln, Sacramento, CA, 958450.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-403533CLMMateo Kim1983-07-15—41439748121057 Mountain View Dr, Atlanta, GA, 303380.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408497CLMJudy Wells2007-04-08——7975 Elm St, Eden Prairie, MN, 553720.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429536CLMArthur Vasquez2002-12-15—30567332222169 Baseline Rd, Mesa, AZ, 852710.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-401314CLMAhmed Schultz2005-09-27—60796071086157 Hillcrest Rd, Las Vegas, NV0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408606CLMJonathan Ward2003-10-01—78668407205264 Mesa Dr, San Antonio, TX, 782800.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413884CLMPatricia Petel1958-07-09—70337246023400 Central Ave, Nashville, TN, 372560.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408749CLMPatty Gomez1940-10-24UHC-71807-52—3964 Highland Ave, Scottsdale, AZ, 852990.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404256CLMRussell R Warren1989-02-01—31569822611252 Market St, Gilbert, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404494CLMJonathan V Cunningham1988-01-15UHC-32520-9185281823738972 Union St, Minneapolis, MN0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-430574CLMArthur Robertson1989-05-18UHC-01568-3722653069341370 Baseline Rd # 756, Houston, TX, 770450.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
CLM-424375CLMMari Bowman1966-12-13——6396 Indian School Rd, Eden Prairie, MN, 553750.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409381CLMAnna Carlson1992-01-24—66029474812529 Sunset Blvd, Gilbert, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-409382CLMAnna Carlson1992-01-24—66029474812529 Sunset Blvd, Gilbert, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-401118CLMPatricia Hamilton1979-09-02UHC-61712-73—2061 Pine Dr, Nashville, TN, 372860.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419692CLMJeremy Hunter——30786429656322 Market St, Charlotte, NC, 282480.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-420172CLMJoseJunk2001-01-14UHC-54396-76—238 Harbor Blvd, Columbus, OH, 432560.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416259CLMBeverly Sanchez1980-11-10UHC-76900-91—5540 Mesa Dr, Jacksonville, FL, 322210.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403800CLMFrances E Jacobs1986-09-08——9439 Baseline Rd, Atlanta, GA, 303730.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420157CLMAshley F Stephens1972-08-09UHC-84789-1636033910286868 Lake View Rd, Chandler, AZ, 852140.62Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
CLM-431885CLMRussell Harris1995-03-11UHC-43669-93—6007 Bayshore Dr, Columbus, OH, 432860.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429904CLMJanice Prk1971-10-21UHC-86194-2174855124007404 Meadow Ln, Eden Prairie, MN, 553630.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416568CLMStephanie Lane—UHC-25162-8444749423327072 Baseline Rd, Atlanta, GA, 303150.62Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407604CLMSarah Delgado1978-12-28UHC-09654-90—3922 Maple Ave, Seattle, WA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423146CLMBobby Adams1972-01-12UHC-70130-54—8522 Spring St, Plano, TX, 750700.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 75 of 657PreviousNext