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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-429624CLMMateo Riley1995-03-20UHC-78610-28—231 Cedar Ln, Eden Prairie, MN, 553130.68Name split from “Last, First”Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
CLM-412179CLMJulie B Alexander1990-01-15——8043 Pine Dr, San Diego, CA, 921640.68Middle initial moved out of first nameDate of birth reformattedState name converted to codePlaceholder values cleared
CLM-404453CLMLarry Martin2001-01-13UHC-92470-78——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-403421CLMDylan Dominguez1988-03-25UHC-56390-60—3895 Palm Dr, Gilbert, AZ, 852790.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-427540CLMJerry L Walsh1980-03-10UHC-90013-29—1562 Valley View Dr, Fresno, CA0.68State name converted to codeZIP missingWhitespace trimmedPlaceholder values cleared
CLM-408266CLMAlice W Duncan1962-04-05—80750825174992 Church St, Seattle, WA, 981610.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-414724CLMJose Carlson1959-11-04UHC-41726-72—2996 Elm St, Fresno, CA, 937440.68Name re-casedState name converted to codeGender normalisedPlaceholder values cleared
CLM-419639CLMLisa Y Young1964-10-21UHC-82516-845828696368—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-426525CLMRaymond Carpenter1968-04-14UHC-37527-46—64 Palm Dr, Tucson, AZ0.68Date of birth reformattedZIP missingGender normalisedPlaceholder values cleared
CLM-427626CLMLori Allen1970-06-02UHC-82292-56—1131 Central Ave # 932, Chandler, AZ, 852480.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-419474CLMMargaret Bryant1978-09-05UHC-57103-48—9466 Church St, Gilbert, AZ, 852270.68Date of birth reformattedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-409589CLMAdam Z Turnr1959-06-10—81996036116333 Valley View Dr, Fresno, CA, 937260.68Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
CLM-407118CLMGloria Allen1992-09-12——6590 Lake View Rd, Austin, TX, 787190.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-411463CLMAustin Padilla1938-07-03UHC-50622-9753133033322950 Desert Sky Blvd, Chandler, AZ0.68Date of birth reformattedPhone reformattedSSN last four extractedZIP missing
CLM-424681CLMDanielle Graham1985-10-18UHC-01900-593775011977—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-427869CLMCheryl Peterson1958-03-10UHC-22463-54—8368 Hillcrest Rd, Denver, CO, 802720.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-413887CLMCarol Burton1984-02-02——5385 Broadway, Orlando, FL, 328070.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-431404CLMGary Matthews1945-11-13UHC-27209-51—4842 Pine Dr, Charlotte, NC, 282660.68Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-403198CLMBrenda Estrada1963-12-15UHC-89999-03—8397 Canyon Rd, Tucson, AZ0.68Name re-casedZIP missingGender normalisedPlaceholder values cleared
CLM-415787CLMRandy G Griffin1940-09-26UHC-66717-41—3473 Pine Dr, Seattle, WA, 981290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-420899CLMElizabeth Schultz1967-12-24UHC-01992-56—9384 Pine Dr Apt 34, Fresno, CA, 937580.68Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-427162CLMAlexander Hudson1964-03-17———0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-432393CLMBevelry K Carlson1981-05-25——7248 Grand Ave Apt 25, Austin, TX, 787470.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409789CLMHannah Lewis2002-06-28—8918067254236 Church St # 728, Denver, CO, 802270.68Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-406774CLMRussell Stewart—UHC-99532-192287968735—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-404576CLMScottt Richardson1980-05-06——9172 Canyon Rd, Chandler, AZ, 852430.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-415579CLMLori Foster1993-05-17UHC-94326-05—8427 River Rd, Eden Prairie, MN, 553390.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410644CLMMateo W Marshall1967-01-02UHC-89509-52——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-409617CLMAlbert P Hayes1944-07-03——7339 Hillcrest Rd Apt 9, Plano, TX, 750910.68Unit split from streetState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-413584CLMChristian Gonzalez————0.68Name re-casedDate of birth missingGender normalisedPlaceholder values cleared
CLM-416000CLMLarry Mendoza1972-11-08UHC-94891-67—3521 Maple Ave, Charlotte, NC, 282030.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-417979CLMJordan Mitchell1971-03-02UHC-68540-72—9358 Jefferson Ave, Denver, CO, 802040.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-414376CLMAmber Welch1942-02-28——6817 Church St, Glendale, AZ, 853480.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-416999CLMDaniel Jimenez1959-01-18—25033857245471 Sage Ct, Eden Prairie, MN, 553400.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428162CLMShirley Vasquez1954-09-09——4637 Mesa Dr, Plano, TX, 750410.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-408207CLMAthony L Torres1940-10-14UHC-59591-7684531675356430 Palm Dr, Sacramento, CA, 958120.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-407259CLMLucia Woods1976-07-17———0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-418792CLM—Junk1981-11-16UHC-75031-60—3349 Union St, Eden Prairie, MN, 553900.68Street suffix standardisedAddress re-casedPlaceholder values clearedNo usable name (quarantined)
CLM-430321CLMTerry Salasar1946-12-06UHC-65903-57—1265 Desert Sky Blvd, Austin, TX, 787320.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-403941CLMElijah Pena1997-09-16——5445 Canyon Rd, Sacramento, CA, 958850.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-418334CLMAshley Nelson1996-12-25UHC-79695-849554781769417 Willow Ct, Seattle, WA, 981290.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-431761CLMRebeccaJunk1954-12-27UHC-91958-97—8352 Main St # 772, Phoenix, AZ, 850420.68Name re-casedUnit split from streetPlaceholder values clearedNo usable name (quarantined)
CLM-429730CLMBarbara Rodriguez1954-04-20UHC-58424-93—8259 Sage Ct, Phoenix, AZ, 850140.68Name split from “Last, First”Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
CLM-425150CLMBrandon Owens—UHC-82663-443977177912—0.68Name split from “Last, First”Date of birth unreadablePhone reformattedPlaceholder values cleared
CLM-403437CLMNicole Sanders1955-06-06UHC-28472-75—329 Jefferson Ave, Columbus, OH0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-423184CLMMegan Delgado1964-02-15UHC-77498-46—8796 Bayshore Dr, San Diego, CA, 921590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409974CLMTyler Sullivan1992-07-06——1500 Meadow Ln, Miami, FL, 331150.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-429496CLMLinda Hansen1943-12-04——7747 Broadway, Scottsdale, AZ0.68Two-digit birth yearZIP missingWhitespace trimmedPlaceholder values cleared
CLM-418944CLMEmma Mitchell1962-01-22UHC-83138-42—857 Cedar Ln, Jacksonville, FL, 322350.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-413072CLMDiana Jordan1997-12-17UHC-03419-47—2158 Ridge Rd, Columbus, OH, 432500.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
32,829 rows, page 208 of 657PreviousNext