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-409272CLMJustin Morgan1956-06-21UHC-81951-04—4401 Desert Sky Blvd, Tempe, AZ, 852330.54Two-digit birth yearCity re-casedZIP+4 trimmedGender normalised+1 more
CLM-400694CLMWlson Elizabeth1957-02-10UHC-61515-34—3145 Desert Sky Blvd, Phoenix, AZ, 850020.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-422672CLMWayne Parker1969-04-18——1698 Sage Ct, Tempe, AZ, 852570.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425222CLMJacqueline Hayes1983-05-03———0.54Name split from “Last, First”Phone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-416247CLMNicholas Alexander1989-04-25UHC-55928-14—6192 Canyon Rd, Mesa, AZ, 852820.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-417596CLMEugenne Henderson1993-09-17UHC-33659-08—4184 Jefferson Ave, Chandler, AZ, 852020.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-404163CLMEmily Rojas1973-08-11——3655 Market St, Las Vegas, NV, 891010.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-423817CLMYuki T Johnson—UHC-34539-08——0.54Name split from “Last, First”Date of birth unreadablePhone missing area codeWhitespace trimmed+1 more
CLM-423672CLMDorothy Ryan1973-03-15UHC-88580-12—2639 Meadow Ln # 901, Miami, FL, 331850.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-432442CLMKayla James1961-06-15UHC-27390-20—3880 Park Pl, Minneapolis, MN, 554210.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-409872CLMAna Cunningham1972-03-03UHC-35095-35—1845 Desert Sky Blvd Apt 22, Scottsdale, AZ, 852990.54Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-419843CLMLuis Holmes1967-11-14UHC-39290-46—6193 Mesa Dr # 433, Dallas, TX, 752380.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-403854CLMMargaret Torres1995-06-22UHC-34210-05—1549 Ridge Rd, Jacksonville, FL, 322920.54Name split from “Last, First”City re-casedZIP+4 trimmedGender normalised+1 more
CLM-420711CLMKathleen Castillo1998-11-21——3704 Sage Ct, Dallas, TX0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-405176CLMCharles G Jenkins1977-07-28UHC-72962-24—7771 Forest Ave # 660, Fresno, CA0.54Date of birth reformattedUnit split from streetZIP missingGender normalised+1 more
CLM-415427CLMCheryl Q Walker1944-07-15UHC-28401-8073620812697688 Valley View Dr, San Antonio, TX, 782560.54Name split from “Last, First”Phone reformattedSSN last four extractedGender normalised+1 more
CLM-415022CLMJeremy K Franklin1984-05-15UHC-73727-24—4598 Canyon Rd, Tempe, AZ, 852430.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-417836CLMMichael Lynch1940-03-05UHC-82219-8483254944104883 Park Pl, Tempe, AZ, 852020.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-416432CLMDouglas Burns1994-09-24——344 Church St, Fresno, CA, 937860.54Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-419189CLMAustin Clark2007-06-05UHC-09557-645915446811—0.54Two-digit birth yearPhone reformattedSSN last four extractedGender normalised+1 more
CLM-404685CLMPat Castillo—UHC-12275-948154560222106 Ridge Rd, Nashville, TN0.54Name re-casedDate of birth unreadableState name converted to codeZIP missing+1 more
CLM-431669CLMMichael A Howard1947-06-26UHC-16390-23—2431 Park Pl, Las Vegas, NV, 891510.54Name split from “Last, First”Two-digit birth yearMember ID reformattedState name converted to code+1 more
CLM-418272CLMShirley P Morgan1997-05-16——3737 Meadow Ln, Charlotte, NC0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-409671CLMJeffrey Garza1979-09-09UHC-77639-01—6249 Mesa Dr, Atlanta, GA, 303660.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-430039CLMTimothy P George1941-06-24UHC-62919-0124128137854259 Valley View Dr, San Diego, CA0.54Middle initial moved out of first nameState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-421977CLMKathy Garrett—UHC-28181-3132545854376193 Pine Dr, San Antonio, TX, 782590.54Name re-casedDate of birth unreadableState name converted to codeGender normalised+1 more
CLM-411282CLMMelissa Hudson———1991 Grand Ave, Miami, FL, 331000.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-411283CLMMelissa Hudson———1991 Grand Ave, Miami, FL, 331000.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-403945CLMYuki Fox1944-10-15——3744 Park Pl, Denver, CO, 802470.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-415812CLMJoshua Simmons1974-12-28UHC-19558-30—1213 Main St, Seattle, WA, 981480.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-415813CLMJoshua Simmons1974-12-28UHC-19558-30—1213 Main St, Seattle, WA, 981480.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425919CLMStephanie Martinez1978-06-25——4964 Church St, Sacramento, CA, 958100.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-424161CLMRandy Maldonado1963-10-24UHC-17028-42—8563 Apache Blvd, Glendale, AZ, 853690.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-432714CLMHarold L Hansun1959-12-11UHC-26394-19—8336 Hillcrest Rd, Plano, TX, 750750.54Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-428498CLMJose Powell1975-07-26UHC-57609-34—8444 Highland Ave, Chandler, AZ, 852860.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
CLM-407695CLMBob U Weber1982-03-12UHC-94741-69—5930 Maple Ave # 563, Chandler, AZ, 852700.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-428051CLMEthan Williamson1984-12-10——2609 Palm Dr, Seattle, WA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-417401CLMKyle Lynch1947-10-15UHC-65995-18—7672 Washington St, Phoenix, AZ, 850180.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-411617CLMChristopher E Peterson2001-06-01UHC-41454-7148270861888720 Grand Ave Apt 24, Phoenix, AZ, 850900.54Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410140CLMIsabella Le1954-04-14UHC-22656-2092981766397791 Desert Sky Blvd, Orlando, FL, 328460.54SSN last four extractedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-406309CLMJoseph Thompson1944-11-23———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-400635CLMStephen Ramirez2005-10-17UHC-34622-69—4006 Maple Ave # 169, Mesa, AZ, 852330.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-405207CLMFatima Richardson1959-12-19UHC-74401-31—3512 Elm St, Phoenix, AZ, 850060.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-408176CLMRobert Maldonado———7388 Palm Dr, Orlando, FL, 328440.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-422296CLMWei Tucker1979-12-27—23568943245189 Valley View Dr, Nashville, TN0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-418600CLMDebborah Simpson1939-04-23—39670308665622 Forest Ave, Nashville, TN, 372850.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-419417CLMJimmy Long1972-08-16UHC-80524-88—6078 Mountain View Dr, Nashville, TN, 372510.54Two-digit birth yearPhone missing area codeGender normalisedWhitespace trimmed+1 more
CLM-416379CLMLarry Perez1982-05-22UHC-26253-8537598617626800 Main St # 229, Gilbert, AZ, 852330.54Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-407991CLMSamantha Nunez——53654747173542 Hillcrest Rd Apt 18, Los Angeles, CA0.54Date of birth unreadablePhone reformattedUnit split from streetZIP missing+1 more
CLM-430218CLMNoah Bryant1967-03-10UHC-41330-6239382303955903 Palm Dr # 428, Atlanta, GA, 303430.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
32,829 rows, page 56 of 657PreviousNext