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-406376CLMBrian Patel2004-10-26UHC-04047-38—2330 Maple Ave Apt 21, Orlando, FL, 328760.48Date of birth reformattedMember ID reformattedUnit split from streetCity re-cased+4 more
CLM-400208CLMMaria Martin1991-05-20UHC-36744-1585368542305568 Indian School Rd, Phoenix, AZ0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419322CLMMegan Thomas1998-10-14UHC-49695-95—2120 Highland Ave, Dallas, TX, 752210.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418380CLMGloria Johnston—UHC-03301-51—2654 Maple Ave, Orlando, FL, 328630.48Date of birth missingStreet suffix standardisedAddress re-casedState code upper-cased+4 more
CLM-408904CLMMarcus Snyder1958-10-04UHC-27788-70—7609 Central Ave Apt 1, Tampa, FL, 336720.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
CLM-402397CLMHannah Ryan1983-12-26—4523205161406 Palm Dr, Mesa, AZ, 852120.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419596CLMEmma Rodriguez2006-11-25——894 River Rd, Phoenix, AZ0.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403486CLMMegaan Y Jenkins1988-07-16UHC-29869-8091456775189484 River Rd, Gilbert, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431437CLMWayne Lopez2001-12-26UHC-76174-84—8070 Highland Ave, Dallas, TX, 752960.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-412813CLMCamila Baker——9009578885815 Ocean Ave, Las Vegas, NV, 891950.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-424425CLMSara Burke1969-04-08UHC-67629-21—95 Maple Ave, Houston, TX0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-431539CLMWilliam Webb1986-01-20UHC-85317-5339384438462004 Willow Ct, San Diego, CA, 921210.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-417221CLMGregory Dixon1989-11-13UHC-47337-39—4750 Highland Ave, Glendale, AZ, 853140.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-412382CLMScott Carroll—UHC-81901-5284475948082169 River Rd, San Diego, CA, 921250.48Name re-casedDate of birth missingPhone reformattedMember ID reformatted+4 more
CLM-406912CLMPriya Barnes———4086 Ocean Ave, Tampa, FL0.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
CLM-431939CLMDiego P Dominguez1985-01-01—66672321383937 Lake View Rd, Austin, TX0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422253CLMRuth Ford1973-12-26UHC-28799-2972195637123627 Desert Sky Blvd # 429, Tempe, AZ, 852170.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-411367CLMJonathan Wheeler2007-10-20——8429 Hillcrest Rd # 900, Scottsdale, AZ, 852850.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-422595CLMTeresa H West1965-11-01UHC-07289-33—5088 Main St Apt 27, Mesa, AZ, 852450.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-410773CLMAbigail Johnston2002-06-09UHC-13519-7570442967875319 Meadow Ln, Dallas, TX0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426268CLMBryan Y Bradley1987-05-12—21260932095040 Oak St Apt 38, Miami, FL, 331610.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-414920CLMDon Hamilton—UHC-49782-3834530841194473 Canyon Rd, Columbus, OH, 432910.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-405249CLMKathryn T Lawson1984-08-08UHC-85546-13—6848 Harbor Blvd, Phoenix, AZ, 850010.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-415339CLMMargaret N Foster1970-07-13—97324949987591 Cedar Ln, Minneapolis, MN, 554180.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-416948CLMBradley Q Sims2006-09-04—79738646405554 Cedar Ln, Atlanta, GA, 303000.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-429228CLMThomas Campbell1945-08-21UHC-19472-4325047665861644 Highland Ave, Eden Prairie, MN, 553270.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-406139CLMJacob Kim1988-11-28——3777 Cedar Ln, Los Angeles, CA, 900390.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-411735CLMJuan F Kelly2002-07-25—20585886931899 Maple Ave Apt 14, Dallas, TX0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-410092CLMWalter M Sanchez1997-08-25UHC-28330-36—6160 Elm St, Tampa, FL0.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419949CLMEvelyn Le1993-12-09UHC-70727-0553421953951620 Central Ave # 910, Glendale, AZ, 853490.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-420126CLMScott Clark1946-04-12UHC-35459-0250782464194843 Bayshore Dr, Houston, TX, 770430.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420127CLMScott Clark1946-04-12UHC-35459-0250782464194843 Bayshore Dr, Houston, TX, 770430.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402233CLMStephanie Harvey1990-03-05UHC-11287-5275831845206362 Union St, Eden Prairie, MN, 553380.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417501CLMJustin Reyes1963-09-22——4889 Spring St, Glendale, AZ, 853370.48Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-409716CLMChheryl Grraham1981-01-16UHC-72022-3897849717796905 Elm St Apt 25, Minneapolis, MN, 554110.48Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-423576CLMPeter Hernandez1986-02-20UHC-11079-43—7574 Baseline Rd # 842, Gilbert, AZ, 852040.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-428657CLMAisha Cox1948-11-27UHC-40748-2778575933633223 Harbor Blvd, Las Vegas, NV, 891520.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420507CLMJudith H Sanchez1994-04-11—32220762486227 Main St # 475, Charlotte, NC, 282010.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-432176CLMAnthony Park2001-02-22——379 Oak St Apt 20, Dallas, TX, 752310.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-424685CLMJohnson Teresa—UHC-93030-1420976418623273 Washington St, Austin, TX, 787010.48Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424333CLMSofia Patel2000-03-25—26191561135736 Ocean Ave Apt 15, Chandler, AZ, 852980.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
CLM-404919CLMCheryl M Bryant——23894749496111 Willow Ct, San Antonio, TX, 782140.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-424844CLMAaron X Payne1996-08-06UHC-08039-35—8093 Pine Dr, Tucson, AZ0.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418459CLMLawrence Russell1987-08-05—28728500741418 River Rd, Dallas, TX, 752330.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-405740CLMBobby Mason2003-05-20UHC-43823-71—2306 Mesa Dr Apt 12, Charlotte, NC, 282030.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-422792CLMJulie M Guzman1963-02-20UHC-93993-352596593030885 Church St, Glendale, AZ, 853710.48Name split from “Last, First”Middle initial moved out of first namePhone reformattedMember ID reformatted+4 more
CLM-401732CLMPriya M Bryant1995-09-20—96987443622965 Lake View Rd, Chandler, AZ, 852880.48Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+4 more
CLM-428680CLMLori Franklin1982-04-15UHC-98775-39—3386 Washington St, Jacksonville, FL, 322720.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-411346CLMWill Dunn1953-06-10UHC-72312-697783642545702 Palm Dr, Atlanta, GA, 303190.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402869CLMJennifer Phillips—UHC-74884-632782826784338 Main St, Jacksonville, FL, 322680.48Date of birth missingPhone reformattedMember ID reformattedStreet suffix standardised+4 more
32,829 rows, page 18 of 657PreviousNext