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-414813CLMHarold Tucker1979-09-07UHC-07451-42—8239 Lake View Rd, Denver, CO, 802770.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-420161CLMAbigail V Gonzalez1980-11-06——6210 Highland Ave, San Antonio, TX, 782000.68Phone missing area codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-406824CLMAmy Andrews1986-08-10UHC-27865-67—6269 Market St, Minneapolis, MN, 554300.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-430287CLMJoe Anderson1955-07-18UHC-19479-04—862 Valley View Dr, Chandler, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-428425CLMOlivia Gilbert1972-07-07——2339 Oak St, San Antonio, TX, 782410.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-421178CLMWillie K Le—UHC-73240-855725184926—0.68Date of birth unreadablePhone reformattedGender normalisedWhitespace trimmed
CLM-421206CLMRice Kayla1959-09-14UHC-12753-25—1790 Park Pl, Denver, CO, 802270.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404005CLMRyan Thompson1943-03-11——2844 Camelback Rd, Glendale, AZ, 853900.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-411500CLMJack Clark1957-06-05UHC-74308-55—6822 Harbor Blvd, Atlanta, GA0.68Date of birth reformattedState name converted to codeZIP missingPlaceholder values cleared
CLM-411201CLMMei Valdez1972-07-24UHC-72383-79—6670 Highland Ave, Jacksonville, FL, 322250.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-415230CLMCarlos Hendersoon1938-09-10UHC-04658-8388877343143916 Washington St, Plano, TX0.68Phone reformattedZIP missingGender normalisedPlaceholder values cleared
CLM-422662CLMCarlos Nelson—UHC-50499-80——0.68Date of birth unreadablePhone missing area codeMember ID reformattedPlaceholder values cleared
CLM-410707CLMDlan Espinoza1955-06-26UHC-01683-02——0.68Two-digit birth yearEmail lower-casedGender normalisedWhitespace trimmed
CLM-400278CLMAmber Soto2010-06-04——1088 Hillcrest Rd, Denver, CO0.68City re-casedZIP missingGender normalisedPlaceholder values cleared
CLM-417676CLMChristopher Johnson1938-01-19——8530 Cedar Ln, Minneapolis, MN, 554120.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-405816CLMDavid Lewis1981-04-09UHC-05353-8545632885855645 Apache Blvd, Eden Prairie, MN0.68Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing
CLM-402773CLMGabriel J Contreras2001-04-16——868 Desert Sky Blvd, Tampa, FL, 336830.68Phone missing area codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-403051CLMLarry K Carpenter1945-06-21UHC-87326-29—9390 Valley View Dr, Miami, FL, 331290.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-416827CLMMelissa Daniels1998-01-01UHC-79454-55—7050 Lincoln Way # 530, Los Angeles, CA, 900700.68Date of birth reformattedUnit split from streetState name converted to codePlaceholder values cleared
CLM-401409CLMLaura M Young1995-05-27UHC-15182-93—7598 Meadow Ln, Gilbert, AZ, 852580.68SSN last four extractedState name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-425029CLMRussell Moore1962-03-14UHC-97911-12—5932 Bayshore Dr, Orlando, FL, 328700.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-425030CLMRussell Moore1962-03-14UHC-97911-12—5932 Bayshore Dr, Orlando, FL, 328700.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-410184CLMWilliam Robinson1980-09-06UHC-37175-59—1200 Valley View Dr, Nashville, TN, 372280.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408005CLMAmy Franklin1995-06-08——2923 Washington St, Mesa, AZ0.68Name re-casedSSN last four extractedZIP missingPlaceholder values cleared
CLM-416002CLMAmanda Mendoza1941-02-24UHC-89922-24—11 Bayshore Dr, Gilbert, AZ, 852480.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-424907CLMDiego Knight1952-03-13——6387 Indian School Rd, Dallas, TX, 752330.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-421277CLMElizabeth Santiago1974-02-24UHC-79914-44—1713 Ridge Rd, Mesa, AZ, 852740.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-402069CLMDonald L Sims1998-04-09UHC-69817-94——0.68Middle initial moved out of first nameName re-casedGender normalisedPlaceholder values cleared
CLM-416378CLMLarry Peez1982-05-22UHC-26253-85—6800 Main St, Gilbert, AZ, 852330.68Phone missing area codeStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-428015CLMJeffrey Harvey1990-09-09UHC-72004-42—7611 Oak St, Dallas, TX, 752830.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-403733CLMKathryn S Wang2007-01-19——7432 Mountain View Dr, Chandler, AZ, 852160.68Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed
CLM-429630CLMAmber Banks1975-11-16—52781662122815 Lincoln Way # 936, Fresno, CA, 937920.68Phone reformattedUnit split from streetState name converted to codePlaceholder values cleared
CLM-407509CLMAndrea Kennedy—UHC-99655-87—7806 Market St, Phoenix, AZ, 850200.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409565CLMLinda Parker1947-11-06——5542 Sunset Blvd Apt 16, Minneapolis, MN, 554550.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-400016CLMMargret Bell2006-07-25——4859 Elm St, Tampa, FL, 336180.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409580CLMAdam Li1959-01-03—52965019469474 Union St, Atlanta, GA, 303530.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-422013CLMSofia Lawrence2001-04-24UHC-25799-28—3103 Apache Blvd, Los Angeles, CA, 900440.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-428363CLMBradley J Warren2005-07-23—588372712093 Valley View Dr, Atlanta, GA, 303850.68Name split from “Last, First”Date of birth reformattedGender normalisedPlaceholder values cleared
CLM-412031CLMKeith Lopez1954-12-07UHC-85819-384926077912—0.68Name split from “Last, First”Member ID reformattedGender normalisedPlaceholder values cleared
CLM-412020CLMTimothy Z Young1949-07-22—80067147482331 Jefferson Ave, Tampa, FL, 336560.68Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed
CLM-417158CLMMichael Robinson1959-07-08UHC-13400-89728752516655 Union St, Orlando, FL, 328390.68Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-417159CLMMichael Robinson1959-07-08UHC-13400-89728752516655 Union St, Orlando, FL, 328390.68Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code
CLM-426056CLMRuh Perez2002-04-14—45047788978217 Pine Dr, Glendale, AZ, 853770.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-405651CLMMaria Griffin1989-06-25———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-424101CLMBrenda K Loepz1990-02-18UHC-93886-29—8704 Lincoln Way, Mesa, AZ, 852330.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-421102CLMJeremy Garcia1967-05-14——5842 Forest Ave, Sacramento, CA, 958620.68Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised
CLM-402310CLMDiego Carter1966-08-09UHC-45682-26—2201 Desert Sky Blvd, Phoenix, AZ0.68Street suffix standardisedAddress re-casedZIP missingPlaceholder values cleared
CLM-427598CLMPrice S Jennfer1965-04-26UHC-20738-60—5802 Washington St # 611, Phoenix, AZ, 850300.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432292CLMNathan Hernandez—UHC-99827-06—7224 Cedar Ln # 282, Columbus, OH, 432270.68Date of birth unreadableUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-431025CLMAmanda G Gibson1938-02-15UHC-89438-327508292181—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
32,829 rows, page 198 of 657PreviousNext