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-414125CLMMatthew Sullivan1959-03-27UHC-21478-3157670141731146 Indian School Rd, Glendale, AZ, 853150.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-430687CLMSharon V Bell2006-07-20UHC-77136-2922891949156511 Sage Ct, Houston, TX, 770180.64Name split from “Last, First”Date of birth reformattedState code upper-casedGender normalised+2 more
CLM-405247CLMKaith Hernandez1998-11-21UHC-09533-2943535180611394 Apache Blvd, Scottsdale, AZ, 852390.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405246CLMKaith Hernandez1998-11-21UHC-09533-2943535180611394 Apache Blvd, Scottsdale, AZ, 852390.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429004CLMVirginia Johnston1978-09-20——6385 Ridge Rd, Nashville, TN, 372710.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405062CLMAustin Berry2007-04-07UHC-63286-32—4427 Washington St, Nashville, TN, 372760.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403308CLMHannah Mendoza1995-08-01—29092547567245 Baseline Rd # 382, Chandler, AZ, 852240.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-418868CLMBarbara Castillo1940-11-11UHC-29086-9076446192242447 Mesa Dr, Columbus, OH, 432920.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-430969CLMSharon Webb1974-10-26——6290 Cedar Ln, Denver, CO, 802690.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411876CLMTheresa W Cruz1962-06-06——8152 Camelback Rd, Jacksonville, FL, 322800.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415840CLMJudy Franklin1940-09-15UHC-60428-8748240377307597 Sage Ct # 191, Atlanta, GA, 303220.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427053CLMBryaan Castro1947-12-01—68559914843934 Central Ave, Dallas, TX, 752000.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420825CLMGeorge Foster1972-01-04UHC-93150-4360284373121130 Mesa Dr, Orlando, FL, 328260.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428333CLMDanielle C Grant1943-09-06—74365388969196 Harbor Blvd, Charlotte, NC0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418197CLMDiana Black1988-01-22UHC-32855-08—4681 Forest Ave, Phoenix, AZ, 850700.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-415041CLMRonald Evans1987-01-25——8732 Meadow Ln # 417, Gilbert, AZ, 852960.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420955CLMDenise White1963-07-19UHC-43105-62—1157 Washington St, Columbus, OH, 432830.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424626CLMDiana Martinez1964-05-19UHC-43768-5562548537138091 Highland Ave, Houston, TX0.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408420CLMZachary Weber1945-01-21UHC-61312-9546364115101671 Elm St, Miami, FL, 331420.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406485CLMRalph Schultz1980-08-17UHC-47566-06—8278 Elm St, Miami, FL, 331400.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-424085CLMJean Owenns1956-07-14UHC-67566-52—4511 Cedar Ln, San Diego, CA, 921560.64Name re-casedCity re-casedZIP+4 trimmedGender normalised+2 more
CLM-426985CLMChristine Hunter—UHC-88464-1643345378507386 Forest Ave, Jacksonville, FL, 322280.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403937CLMJerry W Vasquez2000-12-19UHC-81842-70—3137 Willow Ct # 888, Fresno, CA, 937010.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429758CLMBetty Henderson——76378169175407 Willow Ct, Fresno, CA, 937240.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428451CLMHeather Jackson1992-04-01UHC-20288-1356845395929590 Mesa Dr, Minneapolis, MN0.64Name re-casedDate of birth reformattedState name converted to codeZIP missing+2 more
CLM-425512CLMArthur Contreras1948-04-08UHC-49476-5030345214901470 Canyon Rd, Charlotte, NC, 282990.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401687CLMBryan Walsh1980-07-19UHC-16393-7375569009125966 Central Ave, Phoenix, AZ, 850350.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-415937CLMRalph Lynch1951-05-27——7455 Cedar Ln, Chandler, AZ, 852460.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-412593CLMJordan Weeler1976-05-20—37467473427792 Sage Ct, Dallas, TX, 752470.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430344CLMMargaret Fowler1959-12-03UHC-04517-2354355511323661 Main St, Austin, TX, 787210.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-405550CLMLawrence Warren1961-05-03UHC-31399-31—7599 Indian School Rd, Miami, FL, 331500.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410751CLMZachary Shaw1965-07-13UHC-32514-98—6728 Market St, Mesa, AZ, 852830.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-427607CLMRichard A Lawrence1953-06-20UHC-05636-56—7375 Sage Ct # 614, Eden Prairie, MN, 553710.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-414657CLMElijah Murphy1978-04-02UHC-76725-58—409 Harbor Blvd, Charlotte, NC, 282280.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411536CLMKenneth Santos1944-04-09UHC-35521-445226564984—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-419486CLMRaymond Sullivan1989-08-22—4874231313—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-432339CLMChristian Moreno1939-05-17—44748124229892 Lake View Rd, Scottsdale, AZ, 852130.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-402846CLMRonald Smith2003-07-06UHC-43052-53—9385 Park Pl, Atlanta, GA, 303320.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406579CLMAlexis Schultz1942-08-23UHC-14389-28—4330 Sage Ct, Minneapolis, MN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410220CLMDavid Y Yang2008-01-27UHC-06564-81—7936 Park Pl, Atlanta, GA, 303130.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412022CLMPatricia G Munoz1947-10-21—92941535863866 Union St, Tucson, AZ, 857570.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402663CLMYuki Herrera1996-01-20UHC-52366-24—301 Elm St, San Diego, CA, 921480.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415056CLMRaymond Kim2002-05-10—76781301371535 Main St, Tempe, AZ, 852970.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424981CLMOlivia King1954-02-21UHC-33741-5140137252096000 Cedar Ln, Scottsdale, AZ, 852810.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422227CLMPatrick Ortega2001-07-02UHC-45462-688212622405348 Cedar Ln, Atlanta, GA, 303050.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404325CLMBrenda Kelley1939-09-06UHC-29633-0223760158301801 Park Pl, Dallas, TX, 752070.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-431464CLMLaryr Hunt2006-04-09——7696 Desert Sky Blvd, San Antonio, TX0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-424581CLMAmy Collins1970-09-28UHC-11297-50—4997 Maple Ave, Minneapolis, MN, 554930.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-415064CLMJackson I Marilyn1975-03-27—56143131405334 Hillcrest Rd, Nashville, TN, 372370.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-406875CLMJonathan Ferguson1945-06-13UHC-93124-89—8474 River Rd, San Diego, CA, 921900.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
32,829 rows, page 114 of 657PreviousNext