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-431032CLMLauren Snyder1956-08-01——4984 Lincoln Way, Chandler, AZ, 852660.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-419107CLMGregory Reid1943-07-18UHC-65879-0767688433802914 Maple Ave, Atlanta, GA, 303990.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409787CLMCheryl Welch1938-01-06UHC-07157-2841482870966366 Hillcrest Rd, Miami, FL, 331540.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432536CLMAhmed Adams1986-11-16UHC-27067-82—670 Meadow Ln, San Antonio, TX, 782690.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-406924CLMLauren Mason1953-05-25UHC-58084-9328249569762872 Church St, Tempe, AZ, 852050.68Name re-casedStreet suffix standardisedAddress re-casedGender normalised
CLM-414289CLMValentina Coleman1984-04-09UHC-82461-63—5143 Market St Apt 28, Nashville, TN, 372070.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-429050CLMChristopher Mendez1989-01-10UHC-78590-93—8230 Willow Ct, Miami, FL, 331990.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-414480CLMBruce Weavar1955-03-27——7058 Sage Ct, Tucson, AZ, 857310.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-408986CLMBetty Walalce1938-07-14UHC-94593-87—4159 Harbor Blvd, Houston, TX, 770410.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
CLM-424087CLMTyler Silva1993-01-21UHC-89750-63—3953 Maple Ave, Denver, CO, 802340.68Name re-casedTwo-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-427593CLMSofia Price1970-08-23UHC-91931-9672880388012370 Spring St, Phoenix, AZ, 850010.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-413564CLMSophia V Roberts1977-02-18—6162537893—0.68Name split from “Last, First”Phone reformattedSSN last four extractedPlaceholder values cleared
CLM-407178CLMAhmed Wallace—UHC-37460-16—4100 Cedar Ln, Scottsdale, AZ, 852200.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421648CLMAaron Johnston1990-12-22—8618678536721 Canyon Rd, Scottsdale, AZ, 852070.68Name split from “Last, First”Phone reformattedGender normalisedWhitespace trimmed
CLM-430217CLMVirginia Hansen—UHC-14278-08—3692 Sunset Blvd, Jacksonville, FL0.70Date of birth unreadableZIP missingPlaceholder values cleared
CLM-429510CLMNatalie Freeman1951-03-18——9006 Sage Ct # 621, Columbus, OH, 432190.70Unit split from streetState name converted to codePlaceholder values cleared
CLM-410454CLM—Junk1962-07-15UHC-95184-37——0.70Two-digit birth yearPlaceholder values clearedNo usable name (quarantined)
CLM-402905CLMAnderson Jnaice1981-10-10UHC-06664-40——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-425893CLMMaria Freeman2004-03-22—94038920198019 Harbor Blvd Apt 13, Tampa, FL, 336860.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
CLM-426762CLMBrian Stone1973-10-20UHC-93876-66—1030 Highland Ave, San Diego, CA0.70Name split from “Last, First”ZIP missingPlaceholder values cleared
CLM-414580CLMKayla Thompson1966-10-13———0.70SSN last four extractedGender normalisedPlaceholder values cleared
CLM-417370CLMEvelyn Jensen2005-05-28——9886 Sage Ct, Phoenix, AZ, 850520.70Two-digit birth yearState name converted to codePlaceholder values cleared
CLM-402718CLMRaymond Smith1940-04-03——240 Spring St Apt 8, Tempe, AZ, 852730.70Unit split from streetGender normalisedPlaceholder values cleared
CLM-404923CLMJanice Ferguson1969-07-25UHC-35301-41—3531 Ridge Rd, Miami, FL, 331130.70Street suffix standardisedAddress re-casedState name converted to code
CLM-421856CLMNatalie Taylor1990-05-01——3265 Main St, Atlanta, GA, 303720.70SSN last four extractedState name converted to codePlaceholder values cleared
CLM-414121CLMHenry Reynolds2002-08-03UHC-89188-18——0.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-424618CLMLogan Sandoval1986-12-12UHC-05320-44——0.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-406902CLMBrian J Taylor1941-09-09UHC-39486-76—3111 Mesa Dr, Columbus, OH, 432070.70Street suffix standardisedAddress re-casedZIP+4 trimmed
CLM-428483CLMKeith Graham1954-04-20UHC-75505-45——0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-409413CLMLori Riley1951-07-08——5708 Grand Ave, Nashville, TN0.70State name converted to codeZIP missingPlaceholder values cleared
CLM-400740CLMJuan Vega1967-02-28UHC-78778-54—5043 Park Pl Apt 21, Gilbert, AZ, 852230.70Name split from “Last, First”Unit split from streetPlaceholder values cleared
CLM-421035CLMLori Ruiz2004-02-12UHC-96459-94——0.70Name split from “Last, First”Two-digit birth yearPlaceholder values cleared
CLM-418247CLMJuan S Estrada1965-08-13———0.70Name split from “Last, First”Middle initial moved out of first namePlaceholder values cleared
CLM-412177CLMAlbert J Smith1976-12-05UHC-58594-50—2107 Harbor Blvd, Mesa, AZ, 852130.70Name split from “Last, First”SSN last four extractedPlaceholder values cleared
CLM-405015CLMCamila Murphy1977-05-27UHC-32185-1276480763607655 Forest Ave Apt 11, Scottsdale, AZ, 852530.70Unit split from streetStreet suffix standardisedAddress re-cased
CLM-401347CLMRebecca H Sims1938-07-04——9430 Broadway, Seattle, WA0.70ZIP missingGender normalisedPlaceholder values cleared
CLM-404264CLMNicholas Fuller1983-02-08UHC-17681-4932460935014462 Sage Ct, Las Vegas, NV0.70ZIP missingGender normalisedWhitespace trimmed
CLM-401832CLMRyan Brooks2008-12-27——3718 Main St, Fresno, CA, 937730.70Two-digit birth yearState name converted to codePlaceholder values cleared
CLM-419939CLMMateo Diaz1952-06-25UHC-92907-25—2968 Apache Blvd, Houston, TX0.70Name split from “Last, First”ZIP missingPlaceholder values cleared
CLM-402940CLMPatrick McDonald1916-09-01UHC-20249-57—8384 Baseline Rd, Jacksonville, FL, 322860.70Phone missing area codeStreet suffix standardisedAddress re-cased
CLM-410537CLMAdam Bailey———6587 Jefferson Ave Apt 36, Scottsdale, AZ, 852220.70Date of birth missingUnit split from streetPlaceholder values cleared
CLM-424716CLMDaniel Jordan1970-02-07——2166 Mountain View Dr, Plano, TX, 750150.70State name converted to codeZIP+4 trimmedPlaceholder values cleared
CLM-412702CLMAbby U Alexander1940-03-04——6190 Indian School Rd, Atlanta, GA, 303920.70Name split from “Last, First”ZIP+4 trimmedWhitespace trimmed
CLM-401643CLMDonna G Perez2005-06-03UHC-15786-23——0.70Middle initial moved out of first nameTwo-digit birth yearPlaceholder values cleared
CLM-401644CLMDonna G Perez2005-06-03UHC-15786-23——0.70Middle initial moved out of first nameTwo-digit birth yearPlaceholder values cleared
CLM-425485CLMPriya Smith1955-02-13UHC-16634-84—743 Ridge Rd, Tucson, AZ, 857460.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
CLM-428600CLMDvid P Simmons1980-07-07UHC-57111-043589680219741 Lincoln Way, Sacramento, CA, 958840.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-425550CLMJean N Martin1946-02-06UHC-91488-52—6665 Broadway # 825, Gilbert, AZ, 852610.70Two-digit birth yearUnit split from streetPlaceholder values cleared
CLM-424491CLMFatima Stephens1995-07-04UHC-06221-64—1103 Main St, Sacramento, CA, 958620.70Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-422175CLMVincent Holmes1942-09-03UHC-45761-46—2193 Maple Ave, Seattle, WA, 981700.70Name split from “Last, First”Gender normalisedPlaceholder values cleared
32,829 rows, page 220 of 657PreviousNext