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-416789CLMFatima Bryant2001-06-19UHC-81628-53—4766 Main St, Minneapolis, MN0.68ZIP missingGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-418403CLMOmar Evans1971-06-08UHC-04207-13——0.68Name split from “Last, First”Member ID reformattedGender normalisedPlaceholder values cleared
CLM-430997CLMLawrence Moore1994-07-19UHC-61864-11—4563 Elm St # 643, Dallas, TX, 752600.68Unit split from streetState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-401135CLMKayla Mejia2003-09-22UHC-37503-44—6725 Baseline Rd, Seattle, WA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-401134CLMKayla Mejia2003-09-22UHC-37503-44—6725 Baseline Rd, Seattle, WA0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-411803CLMZachary Simpson1964-12-08UHC-83668-28—5711 Church St, Miami, FL, 331830.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-403549CLMCarolyn O Jackson2002-11-02—39647722552843 Mesa Dr, Atlanta, GA, 303050.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-418273CLMPhilip Singh1975-11-10UHC-22844-24—9171 Canyon Rd, Jacksonville, FL, 322610.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-432494CLMRachel Q Carter1953-11-18——6729 Grand Ave, San Diego, CA, 921640.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
CLM-423058CLMJanice Rice———7691 Forest Ave, Glendale, AZ, 853250.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-424532CLMBryan Hanson2007-11-19——6628 Church St, Eden Prairie, MN, 553890.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404525CLMRachel S Pirce1954-08-12UHC-44054-68—2152 Oak St, Orlando, FL, 328710.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-403033CLMKeith Morales1973-08-27UHC-51608-34—9255 Washington St # 573, Plano, TX, 750090.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421781CLMKyle D Burns1946-02-23—59042359217723 Hillcrest Rd, Tucson, AZ, 857250.68Phone reformattedSSN last four extractedZIP+4 trimmedPlaceholder values cleared
CLM-431172CLMZachary Adamms1959-02-12—80831521345796 Broadway Apt 21, Orlando, FL, 328410.68Name split from “Last, First”Unit split from streetWhitespace trimmedPlaceholder values cleared
CLM-409765CLMJeremy Owens1977-12-27——1683 Washington St, Plano, TX0.68City re-casedZIP missingGender normalisedPlaceholder values cleared
CLM-402299CLMFatima Carlson1980-12-19UHC-32664-63——0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-412802CLMWells Anna1951-09-16UHC-60237-17—1368 Indian School Rd, San Antonio, TX, 782040.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428817CLMBatty Stephens2006-12-15UHC-08557-91—2735 Lincoln Way, Atlanta, GA, 303370.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-423816CLMSamantha Lawson—UHC-59223-01——0.68Name split from “Last, First”Date of birth unreadableWhitespace trimmedPlaceholder values cleared
CLM-424426CLMAndrea Bryant1955-03-03UHC-85336-01——0.68Date of birth reformattedPhone missing area codeGender normalisedPlaceholder values cleared
CLM-427095CLMJulia Kellly1938-12-28UHC-69821-83—4420 Union St, Tampa, FL, 336620.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-414155CLMDaniel G Bennett2008-08-12———0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-418793CLMLarry Chapman1981-11-16UHC-75031-60—3349 Union St Apt 29, Eden Prairie, MN, 553900.68Member ID reformattedUnit split from streetZIP+4 trimmedPlaceholder values cleared
CLM-424633CLMDylan Welch1956-07-05UHC-40221-3360292605465659 Ocean Ave, San Diego, CA, 921150.68Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased
CLM-400983CLMDavid Moreno1968-02-28——7932 Willow Ct # 668, Plano, TX, 750470.68Name re-casedPhone missing area codeUnit split from streetPlaceholder values cleared
CLM-416245CLMNicholas Alexander1989-04-25UHC-55928-14——0.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
CLM-406771CLMRuzsell Stewart1938-12-17—228796873579 Union St, Denver, CO0.68Name split from “Last, First”Date of birth reformattedZIP missingPlaceholder values cleared
CLM-419914CLMJohn Mendez1971-06-11UHC-77811-84—9735 Church St, Tempe, AZ, 852760.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430360CLMJean Campbell————0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-412339CLMJudy Cooper1964-09-18——3369 Apache Blvd, Gilbert, AZ, 852210.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-406976CLMEmily Cooper1987-04-08UHC-31685-70——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-420256CLMJoe Olson1986-02-15UHC-47916-67—8847 Market St # 779, Scottsdale, AZ0.68Unit split from streetCity re-casedZIP missingWhitespace trimmed
CLM-405216CLMCarol Davis1951-10-03—91553480328959 Cedar Ln, Nashville, TN, 372330.68Name split from “Last, First”City re-casedGender normalisedWhitespace trimmed
CLM-426864CLMBrandon Carter2005-03-20UHC-57023-2481945361296856 Sage Ct, San Antonio, TX, 782330.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-429090CLMPeter I Carlson1949-05-26——206 Maple Ave, Tempe, AZ, 852300.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-400833CLMGary Miller1942-11-20—45088973996849 Apache Blvd, Minneapolis, MN, 554900.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-427290CLMVincent S Graham1998-05-26UHC-40247-98—2048 Hillcrest Rd, Jacksonville, FL, 322080.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-424416CLMNoah Cooper1993-07-02——1754 Sage Ct, Las Vegas, NV, 891540.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-429421CLMAustin Rogers1986-07-06UHC-96104-2364774304937743 Sage Ct, San Antonio, TX0.68Phone reformattedStreet suffix standardisedAddress re-casedZIP missing
CLM-428608CLMMadison Lawson1995-11-02——8044 Elm St, Tempe, AZ, 852830.68Name split from “Last, First”City re-casedState name converted to codePlaceholder values cleared
CLM-406849CLMAbigail Mason2003-07-27UHC-12071-842627423699—0.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-427059CLMAmada Singh1946-10-03UHC-34285-94—2132 Baseline Rd, Dallas, TX, 752740.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411291CLMMegan Brown1999-05-07UHC-23638-9576737775366811 Grand Ave, Tempe, AZ, 852190.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-426721CLMGeorgeJunk——7047922841—0.68Date of birth missingPhone reformattedPlaceholder values clearedNo usable name (quarantined)
CLM-409327CLMAnna Thhompson1973-04-05——3663 Willow Ct, Sacramento, CA, 958590.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-416887CLMJerry K Huhes1983-05-26——1707 Hillcrest Rd, Seattle, WA, 981470.68Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased
CLM-425191CLMBradley Wells1980-12-02UHC-44434-27—1813 Elm St, Jacksonville, FL, 322800.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-413777CLMElizabeth Martinez1998-12-22——2780 Desert Sky Blvd, Atlanta, GA, 303430.68Name re-casedTwo-digit birth yearSSN last four extractedPlaceholder values cleared
CLM-424109CLMOmar Ferguson1950-11-04——7551 Harbor Blvd, Los Angeles, CA, 900220.68Two-digit birth yearPhone missing area codeWhitespace trimmedPlaceholder values cleared
32,829 rows, page 206 of 657PreviousNext