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-412231CLMJennifer K Le1952-03-04——3020 Lake View Rd, Tampa, FL, 336030.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-418281CLMAbigail Aguilar1997-05-25—77637862078621 Hillcrest Rd, Las Vegas, NV, 891840.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424371CLMRoger Sanders1954-05-05—22833174955786 Grand Ave, San Antonio, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-415288CLMAlbert S Knight1994-08-07UHC-52355-58—6424 Mesa Dr Apt 10, Tempe, AZ0.64Name re-casedUnit split from streetCity re-casedZIP missing+2 more
CLM-417571CLMLucia Hernandez—UHC-88709-1229660763261139 Mountain View Dr, Seattle, WA, 981460.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431502CLMMartha Harvey1988-01-08UHC-12386-4980389147346664 Union St, Denver, CO0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-419968CLMJudy U Ward1978-11-04UHC-61206-39—931 Sunset Blvd, San Antonio, TX0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-425646CLMRoy Brooks2006-11-27UHC-54707-20—6646 Sunset Blvd, Orlando, FL, 328790.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424607CLMJose Ford1992-03-16——7094 Jefferson Ave, Mesa, AZ, 852120.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407062CLMChristopher Duncan2003-06-26UHC-75482-87—5806 Oak St, Dallas, TX, 752230.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-414397CLMSatiago Miller1969-04-28—32796448923679 Meadow Ln, Mesa, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422556CLMBenjamin V Payne1991-12-09—33049426269168 Ocean Ave, Austin, TX, 787790.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415208CLMJulia N Kelly1974-10-24—37452374147439 Washington St, Phoenix, AZ, 850200.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415719CLMLuica Russell2001-11-13UHC-89539-23—3497 Oak St, Tampa, FL, 336520.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-403472CLMAndrea K Scott1947-02-12UHC-70977-09—4760 Mesa Dr, Glendale, AZ, 853480.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-400168CLMBryan Webbb1961-10-09UHC-61894-9625152267925836 Central Ave, Charlotte, NC, 282690.64Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+2 more
CLM-429955CLMAisha H King1980-07-14UHC-01605-2846043344002857 Lincoln Way Apt 7, Chandler, AZ, 852080.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429773CLMMateo Guerrero2001-04-08UHC-46112-25—955 Elm St, San Antonio, TX, 782400.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-402862CLMJason White1971-04-05——4266 Forest Ave, Scottsdale, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-423671CLMDonna Owens1956-08-12UHC-44246-61—7269 Pine Dr, Scottsdale, AZ, 852540.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-424950CLMJoe Ramos1969-08-23UHC-60247-7630585354166532 Mountain View Dr, San Antonio, TX, 782810.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413602CLMJason Phillips1986-08-11UHC-16875-64—6367 Maple Ave, Houston, TX, 770510.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-418877CLMCarl Marshall1963-07-22UHC-27566-0368945271111078 Forest Ave # 973, Gilbert, AZ, 852460.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-428435CLMShirley Gordon1945-10-15UHC-16318-593555738550734 Park Pl, Los Angeles, CA, 900820.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-413437CLMAlan Sanchez1966-11-25UHC-35719-69—5421 Hillcrest Rd, Phoenix, AZ, 850640.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-420390CLMLaura Smith2008-02-11—33677125013423 Park Pl, Las Vegas, NV, 891350.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403890CLMRaymond Aguilar1951-04-03UHC-81281-2641187605791291 Highland Ave, Chandler, AZ, 852500.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419875CLMMary Williams1960-06-08UHC-91552-92—975 Mesa Dr, Denver, CO, 802540.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413781CLMLogan Wang2001-03-04UHC-72381-1056197204199242 Park Pl, Phoenix, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-426271CLMKelly Mitchell1991-07-13UHC-46965-75—256 Sunset Blvd, Seattle, WA, 981470.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-422360CLMBrian Barnes1984-10-09—30544986821011 Meadow Ln, San Antonio, TX, 782810.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-430320CLMJoyce Santos1986-04-08——9522 Central Ave, Orlando, FL, 328150.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426834CLMJustin I Rios1940-03-24UHC-51097-31—3324 Jefferson Ave, Sacramento, CA, 958780.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400719CLMDonna Stevens1950-02-07UHC-33728-2020376660124021 Harbor Blvd Apt 35, Denver, CO, 802940.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-402114CLMAlbert Crawford1942-11-20UHC-09010-78—2926 Ocean Ave Apt 33, Glendale, AZ, 853470.64Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-422221CLMHenry Foster1976-04-11UHC-39147-4563187563992845 Forest Ave, Glendale, AZ, 853520.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407587CLMCharles H Thomas1941-07-20—88626801113700 Washington St # 424, Dallas, TX, 752030.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431953CLMDougals Castillo1962-12-03UHC-86309-17—81 Mesa Dr, Phoenix, AZ, 850500.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-426078CLMLauren Peters1984-07-16——1420 Oak St, Glendale, AZ, 853920.64Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-419919CLMAlbert Dean1990-11-20UHC-88054-8652732132885601 Market St, Sacramento, CA, 958290.64Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-402847CLMRonald Q Smith2004-07-06UHC-43052-53—9385 Park Pl, Atlanta, GA, 303320.64Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+2 more
CLM-406977CLMEmily Cooper1987-04-08UHC-31685-70—246 Mountain View Dr, Los Angeles, CA, 900870.64SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-427346CLMScott Boyd1961-05-06—57889933878030 Forest Ave, Jacksonville, FL, 322990.64Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-408742CLMAlice Tran2006-04-18UHC-63134-9826320053235978 Market St, Gilbert, AZ, 852760.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411980CLMHiroshi J Lawrence1943-01-16UHC-54967-01—5431 Hillcrest Rd, San Antonio, TX, 782000.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429275CLMJoyce Howard1969-01-06UHC-64162-9071238397419252 Lake View Rd, Houston, TX, 770440.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428761CLMShirley Patel1990-11-08UHC-16580-02—8596 Mountain View Dr # 412, Fresno, CA, 937400.64Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-414697CLMNicholas Ellis1982-03-16UHC-59410-03—7082 Willow Ct, Mesa, AZ, 852980.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408702CLMAnn Gray1981-06-26—76865547154566 Camelback Rd # 691, Houston, TX, 770230.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400226CLMEvelyn Knight1989-08-28UHC-87537-12—4135 Church St, Glendale, AZ, 853720.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
32,829 rows, page 108 of 657PreviousNext