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-418898CLMWei Willys1967-01-27UHC-15137-52—4703 Indian School Rd, Eden Prairie, MN0.68Two-digit birth yearCity re-casedZIP missingWhitespace trimmed
CLM-419642CLMJacob Herrera1962-03-22——8167 Highland Ave, Nashville, TN, 372980.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-416400CLMJeremy O Bishop1971-03-21UHC-33995-1239680422037906 Lake View Rd, Minneapolis, MN, 554500.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-420007CLMPatricia Dixon1980-05-05——4078 Elm St, Charlotte, NC, 282100.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-403428CLMAisha Cole1975-04-01——4922 Cedar Ln, Minneapolis, MN, 554100.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-426635CLMJanet Delgado1978-07-16UHC-23589-5096083194182078 Willow Ct, Los Angeles, CA, 900330.68Name re-casedTwo-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-409160CLMEvelyn Austin1953-04-15—66540450536261 Church St, Gilbert, AZ, 852990.68Phone reformattedState name converted to codeGender normalisedPlaceholder values cleared
CLM-401093CLMDonald Park1995-07-25UHC-31519-50—8179 Church St, Miami, FL, 331750.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430588CLMJanet Grrant1991-05-18UHC-09003-41—7089 Willow Ct, Los Angeles, CA, 900800.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-406360CLMLucia Lynch1968-04-09UHC-33985-3956048615468941 Forest Ave, Atlanta, GA, 303020.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
CLM-423878CLMAshley Nunez1990-04-28UHC-90338-03—8208 Park Pl Apt 10, Nashville, TN, 372790.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425444CLMLiz Weaver1985-07-09UHC-21629-88—2357 Ocean Ave # 446, San Antonio, TX, 782390.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-418583CLMChristian Chavez1996-01-20UHC-18389-7350379203667834 Oak St # 623, Seattle, WA, 981130.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402630CLMGregory Hudson1972-10-10UHC-64213-6060775187624533 Camelback Rd, Eden Prairie, MN, 553530.68Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed
CLM-413853CLMKaren Wong2001-09-25UHC-75927-48—672 Hillcrest Rd # 206, Minneapolis, MN, 554470.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400600CLMCarolyn Dixon1973-10-21UHC-69047-67—1496 Camelback Rd, Austin, TX0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-418014CLMBruce Cole1952-03-11UHC-76142-82—7356 Harbor Blvd, Los Angeles, CA, 900000.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-408913CLMTheresa Morrison1942-12-17——9222 Baseline Rd, Las Vegas, NV, 891650.68Two-digit birth yearState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-407737CLMBetty E Boyd2001-09-14—50541819731692 Sage Ct, Mesa, AZ, 852800.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-407757CLMDoris Brown1963-07-09UHC-03661-81—5032 Lake View Rd, Tempe, AZ0.68ZIP missingGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-420192CLMWei Miller1949-03-27—6977770510967 Canyon Rd # 466, Tempe, AZ, 852230.68Two-digit birth yearPhone reformattedUnit split from streetPlaceholder values cleared
CLM-413751CLMGregory Mendez1947-05-15UHC-93422-08—3586 Harbor Blvd, Houston, TX, 770030.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-424865CLMAshley Cox1973-08-17UHC-39698-83—4384 Spring St, Denver, CO, 802340.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428076CLMDeborah Z Johnston1963-05-04UHC-79873-3932653424611122 Central Ave, Los Angeles, CA, 900110.68Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed
CLM-404441CLMGregory Ward1981-01-22UHC-42600-61—886 Bayshore Dr, Miami, FL, 331590.68Name re-casedTwo-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-414263CLMJudith X Gomez1944-02-18UHC-71940-96——0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-414353CLMRebecca Lewis1967-03-26——6545 Maple Ave, Nashville, TN0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-400965CLMMary Wilils1939-06-26UHC-39266-51—1470 Apache Blvd, Austin, TX, 787050.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-422932CLMDouglas Kim1940-07-09UHC-49616-13—5295 Market St, Fresno, CA, 937110.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-413438CLMAlan Sanchez1966-11-25———0.68Name re-casedSSN last four extractedGender normalisedPlaceholder values cleared
CLM-420074CLMVicky Salazar1970-06-13UHC-74312-49—9172 Lake View Rd, Los Angeles, CA, 900710.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412094CLMNoah O Coleman—UHC-80842-13—3319 Maple Ave, Charlotte, NC, 282690.68Date of birth missingStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-410618CLMRonald Sanders1978-08-24UHC-31632-29—7520 Church St, Minneapolis, MN, 554140.68Name split from “Last, First”Two-digit birth yearMember ID reformattedWhitespace trimmed
CLM-407753CLMKayla Wheeler1938-11-09UHC-62250-44—5670 Valley View Dr, Las Vegas, NV, 891690.68Name split from “Last, First”City re-casedGender normalisedPlaceholder values cleared
CLM-411830CLMDebra Cook1943-11-19UHC-39496-64—4011 Palm Dr # 888, Orlando, FL, 328600.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-414942CLMBenjamin Contreras1980-06-23UHC-74433-78—7408 Sage Ct, Gilbert, AZ, 852100.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432727CLMSarah Fuller1958-03-06UHC-44743-03—5274 Maple Ave, Glendale, AZ, 853340.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-426983CLMCatherine N Wheeler1952-10-07UHC-48380-89—3516 Harbor Blvd, Tampa, FL, 336960.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-422125CLMDonald Patel1989-03-28—7724414294958 Cedar Ln, Denver, CO0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-400260CLMJonathan Edwards1969-10-03UHC-24676-5493293932042491 Palm Dr Apt 15, Denver, CO, 802610.68Name split from “Last, First”Unit split from streetCity re-casedPlaceholder values cleared
CLM-401539CLMJeffrey Silva1978-08-05——4836 Pine Dr Apt 11, Glendale, AZ, 853990.68Unit split from streetGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-400642CLMYuki Berry1953-10-02——5752 Lincoln Way, Atlanta, GA, 303540.68Name split from “Last, First”State code upper-casedGender normalisedPlaceholder values cleared
CLM-402765CLMLori V Santos1944-01-14UHC-54330-79—5363 Union St, San Antonio, TX, 782870.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-420258CLMSandra Powell1996-04-25UHC-02733-47—9548 Main St, Los Angeles, CA, 900260.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-418951CLMOmar Hunt1938-05-20UHC-97434-5145436298659314 Bayshore Dr, Los Angeles, CA, 900850.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-409442CLMTimothy Roberts2003-12-25UHC-57913-02—5853 Church St, Mesa, AZ, 852380.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-425044CLMPatrick Jordan1948-08-20UHC-27638-2990096363895088 Mesa Dr, San Antonio, TX, 782690.68Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed
CLM-422240CLMMeidna J Juan1967-05-10UHC-12396-73—1799 Bayshore Dr, Los Angeles, CA, 900750.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-429290CLMVirginia Wong1971-03-07—67143572186349 River Rd, Chandler, AZ0.68Phone reformattedZIP missingGender normalisedPlaceholder values cleared
CLM-411162CLMBecky George1977-02-07UHC-12353-35—7053 Maple Ave, Eden Prairie, MN, 553770.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
32,829 rows, page 219 of 657PreviousNext