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-417366CLMLinda Z Garrett1979-03-06UHC-28085-18—9696 Pine Dr, Glendale, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427922CLMWalter Duncaan——74739882644410 Apache Blvd, Chandler, AZ, 852330.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401440CLMBruce Chavez1940-08-25——6883 Indian School Rd, Fresno, CA, 937350.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420904CLMRandy Gardner1958-06-08UHC-99224-7463329127013483 Palm Dr, Chandler, AZ0.64Date of birth reformattedPhone reformattedState name converted to codeZIP missing+2 more
CLM-420060CLMJim Wilson1998-04-08UHC-29080-5683727029241459 Mesa Dr, Fresno, CA, 937000.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-420811CLMZachary Hawkins1948-08-11UHC-34301-5963134793807927 Willow Ct, Scottsdale, AZ, 852680.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-419470CLM—Junk1997-02-12——5330 Park Pl, Miami, FL, 331860.64Street suffix standardisedAddress re-casedState code upper-casedWhitespace trimmed+2 more
CLM-402361CLMCheryl T Henry2000-07-14—58772590339407 Oak St, Fresno, CA, 937880.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419667CLMKeith T Munoz1963-11-07UHC-81023-7154496503303507 Washington St, Phoenix, AZ, 850500.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404396CLMRyan Rojas1967-03-17UHC-73873-9391576745233825 Apache Blvd, San Diego, CA, 921250.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-406945CLMAaron McDonald1941-09-11—76989192765762 Desert Sky Blvd, Glendale, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-418969CLMKelly Kelley1950-06-24UHC-41100-02—6704 Church St # 710, Seattle, WA, 981220.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-429820CLMMateo Chen1996-08-28——2874 Ocean Ave, Charlotte, NC, 282570.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410399CLMAna K Robinson1955-02-02UHC-45904-17—3989 Indian School Rd, San Diego, CA0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-426840CLMGary Hlmes1991-05-26UHC-63810-47—8860 Lincoln Way, Orlando, FL, 328330.64Name re-casedTwo-digit birth yearCity re-casedGender normalised+2 more
CLM-430318CLMEthan Peters1971-06-14UHC-28291-35—4909 Meadow Ln, Seattle, WA, 981520.64Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401257CLMLinda O Carr1950-10-05UHC-14169-74818648022827 Forest Ave, Columbus, OH, 432090.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421248CLMAmanda Phillips1987-07-18——9582 Cedar Ln, Los Angeles, CA0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-413981CLMKayla H Watkins1977-02-06——5154 Harbor Blvd, Mesa, AZ, 852670.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-409679CLMRoy Hall1952-10-16—95351403976334 Apache Blvd, San Antonio, TX, 782540.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407665CLMCarolyn J Shaw1950-11-15UHC-40375-0166676224971489 Cedar Ln, Tampa, FL, 336940.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425629CLMLius Green1964-04-24UHC-57723-18—873 Indian School Rd, Fresno, CA, 937830.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-427076CLMJack Jordan1957-07-13UHC-50049-24—6754 Canyon Rd, Columbus, OH, 432780.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407129CLMChristian Yang1945-08-01UHC-31026-3490024771028005 Willow Ct, Austin, TX, 787850.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402140CLMBruce Johsnton1975-08-10—24528311453273 Harbor Blvd, Dallas, TX, 752750.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400861CLMMunooz J Brandon1965-08-06UHC-24440-974199034858466 Desert Sky Blvd, Jacksonville, FL, 322530.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422300CLMKimberly U Armstrong1969-10-12——5404 Maple Ave # 642, Sacramento, CA, 958970.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430430CLMAna Garcia1951-12-14UHC-82557-56—4292 Mesa Dr, Plano, TX, 750080.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-430433CLMJoan Mdeina1968-02-10——4462 Oak St, Orlando, FL, 328900.64Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
CLM-412238CLMJulie Lewis1963-03-22UHC-04157-392862880696161 Bayshore Dr, Mesa, AZ, 852670.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430376CLMSamanhta Ruiz1978-04-18——3319 Harbor Blvd, San Antonio, TX, 782950.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428111CLMZachary Scott1995-07-02——2531 Canyon Rd, Nashville, TN, 372810.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-406274CLMJack Jimenez1973-04-22UHC-37921-42—2186 Camelback Rd, Fresno, CA, 937470.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-417447CLMKathhleen Morgan1994-04-23——5250 Spring St, Fresno, CA, 937540.64SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409849CLMMadison C Washington1976-11-19UHC-75175-92—8244 Hillcrest Rd, Glendale, AZ, 853910.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-402391CLMJustin S Ross1967-06-09——3558 Market St, Sacramento, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-411407CLMNancy Castillo1967-03-21UHC-50056-60—8927 Pine Dr, Tucson, AZ0.64Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404798CLMBilly C Gibson2008-04-13——3004 Sunset Blvd, Tucson, AZ, 857910.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-416273CLMSantiago Jensen1992-05-26UHC-40660-0779175635748713 Meadow Ln Apt 26, Seattle, WA, 981370.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431168CLMElizabeth Myers1980-12-18UHC-25672-9236636429339332 Ridge Rd # 802, Dallas, TX, 752920.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413840CLMAustin Nelson1974-06-14UHC-77457-34—9886 Park Pl Apt 4, Nashville, TN, 372610.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-412960CLMScott U Jordan1965-02-17—53575792102014 Pine Dr, Miami, FL, 331900.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430635CLMFrances Burke2000-04-23UHC-81574-0676674353442627 Desert Sky Blvd # 492, Mesa, AZ, 852700.64Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-420415CLMCamila Richardson1972-05-10—74022652471818 Sage Ct, Sacramento, CA, 958790.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425554CLMEimly White1942-09-14UHC-52127-728232470038208 Apache Blvd, Tempe, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-407154CLMSarra Cooper1938-07-03UHC-45515-3436946764931053 Pine Dr, Minneapolis, MN, 554020.64Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409290CLMMoreno V Benjamin2000-08-10UHC-43144-6148977665309459 Highland Ave, Glendale, AZ, 853640.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-401814CLMTheresa Fowler1979-04-14UHC-19141-3139962986966465 Broadway Apt 2, Las Vegas, NV, 891880.64Two-digit birth yearPhone reformattedUnit split from streetAddress re-cased+2 more
CLM-427955CLMChristine Young1978-10-04UHC-29927-75—6594 Sunset Blvd, Orlando, FL, 328700.64Member ID reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-409006CLMJacqueline Williams1947-08-08UHC-10689-0388728109147124 Camelback Rd, Tucson, AZ, 857560.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
32,829 rows, page 122 of 657PreviousNext