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-406723CLMKathleen Bailey1983-04-15UHC-81568-33—6841 Park Pl, Eden Prairie, MN0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-415978CLMMegan Burton1962-12-19UHC-70543-77—2945 Hillcrest Rd, Columbus, OH, 432220.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-427339CLMBrian Adams1954-04-02UHC-63493-1878574307254847 Ridge Rd, Minneapolis, MN, 554700.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-403923CLMMargaret Kelley1961-12-02UHC-54895-40—6289 Jefferson Ave, Las Vegas, NV, 891380.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-412092CLMBilly Miller1959-04-28UHC-85481-64—3528 Baseline Rd, Scottsdale, AZ0.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-432232CLMDanielle Herrera1964-01-22UHC-21597-0183239541019155 Bayshore Dr, Phoenix, AZ, 850830.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-425952CLMJennifer Graham1962-09-18—87449619888552 Highland Ave, Houston, TX, 770640.66Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-409729CLMSamantha U Patterson1974-10-20——1608 Sage Ct, Scottsdale, AZ, 852900.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-428614CLMAndrea Harvey1975-03-08——7038 Valley View Dr, Phoenix, AZ, 850750.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413430CLMGabriel Gray1962-05-03UHC-31656-924787614161868 Sage Ct, Columbus, OH, 432660.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-406508CLMJordan V Garcia1983-04-26——8139 Harbor Blvd, Chandler, AZ, 852670.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408099CLMBryan Sanders1976-04-21UHC-11135-76—1169 Market St, Orlando, FL, 328170.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-406662CLMPamela Q Black1969-01-06UHC-33930-18—8059 Park Pl, Denver, CO, 802570.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-422535CLMSteven Watkins1956-06-02UHC-18796-43—5142 Broadway # 231, Mesa, AZ, 852240.66Name split from “Last, First”Unit split from streetState code upper-casedWhitespace trimmed+1 more
CLM-404790CLMRoy Q Bennett1950-11-23UHC-17845-80—4687 Central Ave, Scottsdale, AZ, 852700.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429351CLMJeremy Dunn1989-07-21UHC-55421-5081747697078291 Maple Ave, Houston, TX, 770800.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-423270CLMBrittany O Sandoval1970-02-25UHC-22787-3391264134419784 Jefferson Ave, Charlotte, NC, 282530.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-418723CLMWei Schultz1995-09-03UHC-71252-5761436183187300 Grand Ave, Seattle, WA, 981260.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405953CLMCarlos Salazar1992-08-07—40797028872954 Canyon Rd, Phoenix, AZ, 850170.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413319CLMKevin Thompson1948-01-11UHC-76614-91—484 Meadow Ln, Las Vegas, NV, 891380.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-427140CLMJulia Brown1989-05-17UHC-01468-2195023038138084 Main St, Sacramento, CA, 958850.66Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+1 more
CLM-407183CLMHelen N Kelley—UHC-08411-81—9444 Valley View Dr, Columbus, OH, 432480.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-418995CLMAnthony Weber1986-11-02UHC-65934-3543072457351777 River Rd, Mesa, AZ, 852770.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-431933CLMAustin Bradley1943-08-01—76260664299838 Palm Dr Apt 21, Austin, TX, 787990.66Date of birth reformattedPhone reformattedUnit split from streetGender normalised+1 more
CLM-423480CLMBradley R Castillo1952-01-27UHC-47513-77—8189 Bayshore Dr, Eden Prairie, MN0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
CLM-430328CLMWilliam Owens1961-11-09UHC-98562-613963899560235 Ridge Rd, Eden Prairie, MN, 553690.66Name split from “Last, First”Street suffix standardisedAddress re-casedPlan code upper-cased+1 more
CLM-421584CLMHeln Williams1996-06-22——6789 Canyon Rd, Houston, TX, 770460.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-414479CLMEdward Ford—UHC-01186-5847779687813257 Broadway, Tampa, FL, 336470.66Name re-casedDate of birth unreadableAddress re-casedGender normalised+1 more
CLM-408461CLMBrenad Garrett1985-09-28UHC-01984-24—3668 Ridge Rd, Phoenix, AZ, 850180.66Name split from “Last, First”Date of birth reformattedSSN last four extractedPlan code upper-cased+1 more
CLM-429776CLMDanielle H Stevens1944-02-13——4873 Ocean Ave, Chandler, AZ, 852150.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416994CLMWilliam Gonzales1977-08-17UHC-92544-37—2689 Market St, Minneapolis, MN, 554750.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
CLM-421671CLMScott Henderson1987-01-24——3317 Forest Ave Apt 39, Gilbert, AZ, 852730.66Name re-casedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-430027CLMCarolyn P Li1947-07-28——6525 Highland Ave, Nashville, TN, 372050.66Name split from “Last, First”Two-digit birth yearCity re-casedWhitespace trimmed+1 more
CLM-412868CLMNancy Johnson—UHC-08685-37—7906 Broadway, Tucson, AZ, 857890.66Name split from “Last, First”Date of birth unreadableCity re-casedWhitespace trimmed+1 more
CLM-411349CLMAlexander Ray1996-05-06——5159 Ridge Rd, Tampa, FL, 336390.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-403220CLMDiana McDonald1981-10-18UHC-42901-26—9636 Mountain View Dr Apt 29, Charlotte, NC, 282730.66Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-424636CLMAustin Bell1953-01-18UHC-52108-19—775 Canyon Rd, Eden Prairie, MN, 553720.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-418691CLMBilly Anderson1984-05-10UHC-19774-9378674735596050 Park Pl Apt 37, Sacramento, CA, 958810.66Phone reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
CLM-423525CLMPamela Patel1970-03-25——5691 Palm Dr, San Antonio, TX, 782300.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-418266CLMBrenda Soto1938-11-18UHC-22397-556445396041508 Forest Ave, Miami, FL, 331580.66Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+1 more
CLM-407865CLMDenise M Cooper———974 Washington St, Tampa, FL, 336120.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-424497CLMCarol Peterson1988-03-27——7116 Central Ave, Columbus, OH, 432300.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-411649CLMCynthia Baker1940-05-26UHC-09215-77—2238 Grand Ave # 807, Nashville, TN, 372630.66Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+1 more
CLM-422275CLMLuis Tuker1953-09-13UHC-25918-17—4409 Hillcrest Rd, Atlanta, GA, 303070.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-432098CLMJesse Coleman1983-02-04UHC-37560-46—8018 Camelback Rd, Phoenix, AZ, 850430.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-401476CLMGerald P Sullivan1938-07-08UHC-32009-7848870593775553 Grand Ave, Dallas, TX0.66Phone reformattedSSN last four extractedCity re-casedZIP missing+1 more
CLM-409959CLMKyle Taylor2006-05-28UHC-63974-95—8390 Market St, Tampa, FL, 336710.66Name split from “Last, First”Email lower-casedGender normalisedWhitespace trimmed+1 more
CLM-431738CLMArthur Valdze1996-08-18UHC-18114-77—8255 Ocean Ave, Columbus, OH, 432010.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-427348CLMWillie Chavez2007-02-03UHC-34974-9951470863634782 Pine Dr, Denver, CO, 802890.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-420767CLMBryan Graham1999-09-04UHC-39222-667656448229301 Baseline Rd, Denver, CO, 802510.66Name split from “Last, First”Phone reformattedCity re-casedGender normalised+1 more
32,829 rows, page 172 of 657PreviousNext