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-403352CLMJeremy Torres1982-06-17UHC-01486-0979664530958802 Jefferson Ave, Plano, TX, 750170.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-431491CLMKimberly Little1941-09-26UHC-05525-1684943753365743 Valley View Dr, Las Vegas, NV, 891400.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407268CLMKenneth J Gordon1939-07-13UHC-62055-4220561838608838 Sage Ct # 778, Chandler, AZ, 852280.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404180CLMRyan Rivera1974-02-14UHC-04975-49—6236 Desert Sky Blvd Apt 6, Mesa, AZ, 852580.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-406833CLMPhilip Woods2001-02-24UHC-83948-75—8935 Valley View Dr, Eden Prairie, MN0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-418087CLMMargaret Mills1980-01-24—55757132132628 Market St, Phoenix, AZ, 850230.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-418232CLMEugene Soto1991-01-02UHC-38273-8034032532469360 Lake View Rd, Eden Prairie, MN, 553340.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415440CLMJackie Owens1994-08-23UHC-62366-83—2104 Mountain View Dr, Gilbert, AZ, 852420.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432526CLMAhmed Hoffman1991-01-20UHC-79652-3273247120296488 Desert Sky Blvd, Eden Prairie, MN, 553450.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-415660CLMJerry Cox1957-06-05——1970 Baseline Rd, Columbus, OH, 432330.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429614CLMMason Carlson1946-09-16UHC-73897-98—9434 Willow Ct, Orlando, FL0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414050CLMOmar D Nguyen1997-06-08UHC-18431-18—5478 Lake View Rd Apt 21, Tampa, FL, 336210.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
CLM-419198CLMDeborah West1945-06-11UHC-15597-12—479 Oak St, San Diego, CA, 921070.50Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+3 more
CLM-424286CLMAisha P Walker1952-12-22UHC-06107-1230025607597821 Ocean Ave, Atlanta, GA, 303050.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410876CLMHiroshi Elliott1970-05-26——9492 Maple Ave, Chandler, AZ, 852390.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-417935CLMJulie Myers1971-06-16UHC-98913-91—2119 Apache Blvd, Fresno, CA, 937060.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-415888CLMAlan Mills1998-02-18——6345 Church St # 156, Eden Prairie, MN0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-405191CLMBenjamin Hunt1993-07-05UHC-46402-7049232716078179 Indian School Rd, Atlanta, GA, 303720.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-405544CLMWilliam S Rose1961-12-13UHC-42141-5689531027564362 Ocean Ave, Fresno, CA, 937620.50Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+3 more
CLM-413655CLMEmily Wallace2004-10-05—85582198144775 Camelback Rd, Denver, CO, 802110.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-431577CLMNatalie Ryan2004-06-05UHC-86274-6430955225149790 Washington St, Minneapolis, MN, 554210.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401713CLMMichael Clark2006-12-17UHC-54207-07—4197 Washington St, Nashville, TN, 372620.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-423065CLM—Junk1999-07-04UHC-76256-4162939632196379 Camelback Rd Apt 12, Eden Prairie, MN, 553820.50Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-401775CLMTyler Taylor2000-06-06UHC-19451-2783157810859668 Hillcrest Rd, Charlotte, NC, 282710.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-404633CLMDeborah Day1955-06-07——4202 Washington St, Tucson, AZ, 857180.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413790CLMHenry Dean1970-09-10UHC-91438-57—2175 Jefferson Ave Apt 4, Glendale, AZ, 853470.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-426741CLMDanny Powell1981-10-07UHC-81002-4121432766388638 Highland Ave, Glendale, AZ, 853650.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-426740CLMDanny Powell1981-10-07UHC-81002-4121432766388638 Highland Ave, Glendale, AZ, 853650.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-431627CLMSanitago Hoffman1988-02-13UHC-83483-1072450165992511 Harbor Blvd # 508, Orlando, FL0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402972CLMYuki White1954-11-15UHC-76332-1534622366344932 Maple Ave # 361, Denver, CO, 802550.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-413549CLMRachel Richardson1991-01-22——2199 Hillcrest Rd # 533, Denver, CO, 802550.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-423704CLMDoris Barnes1980-03-13UHC-22231-79——0.50Name re-casedDate of birth reformattedPhone missing area codeMember ID reformatted+3 more
CLM-424668CLMLarry Crawford1982-09-02—72092591628183 Mesa Dr # 601, Scottsdale, AZ, 852640.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-405621CLMHirohsi Kennedy———4777 Ocean Ave, Nashville, TN, 372940.50Name re-casedDate of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
CLM-415558CLMRussell X Burton1948-06-02—33384926965524 Valley View Dr # 484, Seattle, WA, 981520.50Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+3 more
CLM-430613CLMOlivia Rose1995-09-20UHC-69550-0487478126619001 Pine Dr, Tucson, AZ, 857160.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-405316CLMSofia Ortiz—UHC-21428-8694446031858551 Market St, Fresno, CA, 937760.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408397CLMWilliam Harvy—UHC-66390-2650765324776888 Meadow Ln, Atlanta, GA, 303010.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403389CLMBrian Castillo1966-06-21——5969 Willow Ct, Austin, TX, 787500.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-425455CLMLaura Obrien2000-08-16——3657 Desert Sky Blvd, Los Angeles, CA, 900290.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-419016CLMReid I Joyce1965-10-13UHC-05392-1034672669793296 Sunset Blvd Apt 29, Scottsdale, AZ0.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-428018CLMAndrew M James1938-01-24UHC-35033-4776753075557426 Forest Ave, Jacksonville, FL0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404436CLMCharlotte U Day1981-10-02—8648823337948 Valley View Dr, Glendale, AZ, 853030.50Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+3 more
CLM-432362CLMAmy Sanchez1972-07-02UHC-63205-92—7045 Desert Sky Blvd, Sacramento, CA, 958920.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-403872CLMAaron Schultz1952-07-11——5848 Bayshore Dr, Los Angeles, CA, 900700.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-426958CLMJoan Sanders2008-11-07—83070964423502 Forest Ave, Chandler, AZ0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400903CLMEmma Z Rogers1970-04-14UHC-12078-576834028241156 Lake View Rd Apt 22, Fresno, CA, 937270.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-408311CLMArjun Gibson1957-05-23UHC-37494-6774630641562796 Bayshore Dr, Glendale, AZ0.50Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
CLM-405906CLMGregory Webb1977-01-26—5949277879462 Meadow Ln, Miami, FL0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
CLM-407383CLMMari S Price1986-05-12UHC-97503-98943708169772 Mesa Dr, Atlanta, GA, 303880.50Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+3 more
32,829 rows, page 27 of 657PreviousNext