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-424271CLMJack Barnes1940-07-25UHC-58851-08—5734 Washington St, Atlanta, GA, 303560.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-415236CLMJacqueline Hansen1978-12-04—67565647109569 Desert Sky Blvd, Nashville, TN, 372940.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408732CLMKathleen Harris1996-05-02UHC-29359-2953325266897651 Ocean Ave, Charlotte, NC0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-412479CLMSamuel Kelley1955-07-10—70461103855846 Mountain View Dr, Phoenix, AZ, 850120.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403452CLMAbigail McDnald1969-07-26UHC-91015-76—2735 Washington St, Fresno, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420515CLMJim Wright1993-08-27UHC-88515-11—8840 Cedar Ln Apt 33, Columbus, OH, 432250.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400137CLMDoris Mendoza1986-11-26UHC-29920-87—5813 Willow Ct, Charlotte, NC0.64Name re-casedMember ID reformattedCity re-casedState name converted to code+2 more
CLM-430117CLMJuan Alexander1989-04-28UHC-51910-62—9353 Main St Apt 13, Plano, TX, 750610.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400021CLMTimothy Lae1980-03-16UHC-70224-52—2915 Mountain View Dr, Miami, FL, 331570.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422904CLMEugene Adams1963-11-13—81046429902728 Desert Sky Blvd, San Antonio, TX, 782970.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-432599CLMBruce K Fuller1968-08-22UHC-60457-9644641788331619 Forest Ave, Tucson, AZ, 857730.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415357CLMWilliam Thomas1950-10-27UHC-66305-24—8887 Palm Dr # 569, Miami, FL, 331020.64Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+2 more
CLM-417310CLMLinda Gray1944-09-06UHC-13908-56—8805 Ridge Rd, Houston, TX0.64Street suffix standardisedAddress re-casedCity re-casedZIP missing+2 more
CLM-424007CLMBrenda Patterson2003-09-07UHC-55114-0423196477206271 Willow Ct Apt 36, Dallas, TX, 752480.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-410235CLMJanice Lopez1947-05-11UHC-64105-0478831634282564 Lincoln Way, San Antonio, TX, 782930.64Name re-casedDate of birth reformattedPhone reformattedState name converted to code+2 more
CLM-403479CLMSam Evans2003-06-19——4995 Maple Ave, Phoenix, AZ, 850210.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-411363CLMBradley Meyer1978-02-03UHC-39806-76—2160 Central Ave, Jacksonville, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-419400CLMTyler J Peters1952-03-28——3062 Main St, Fresno, CA, 937430.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400569CLMStephanie Campbell1960-03-15UHC-45143-3839978867908660 Central Ave, Atlanta, GA, 303680.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403370CLMJerry Franklin1983-12-02UHC-03734-38—4905 Mountain View Dr, Columbus, OH, 432020.64Name split from “Last, First”Date of birth reformattedMember ID reformattedState name converted to code+2 more
CLM-418597CLMJessica N Adams1961-07-22UHC-97802-4743695505981007 Oak St, Columbus, OH0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418596CLMJessica N Adams1961-07-22UHC-97802-4743695505981007 Oak St, Columbus, OH0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430780CLMRebecca Jacobs1971-06-11——6100 Spring St, Glendale, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-423173CLMKenneth James1941-08-01UHC-79845-7397556034232485 Baseline Rd, Gilbert, AZ, 852290.64Date of birth reformattedPhone reformattedZIP+4 trimmedGender normalised+2 more
CLM-403369CLMRobert Ford1980-01-19UHC-14799-77—1726 Harbor Blvd, Tucson, AZ, 857370.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431157CLMChristina Griffin1941-11-08UHC-88176-08—7775 Oak St, Minneapolis, MN, 554050.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410306CLMLawrence Hicks1954-03-16UHC-52129-95—1518 Canyon Rd, Eden Prairie, MN, 553230.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428925CLMKimberly T Bell2003-09-01UHC-86763-2259790337043424 Central Ave, Tempe, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-429561CLMBruce Alexander1988-07-25—91988031557801 Apache Blvd # 873, Scottsdale, AZ, 852750.64Name re-casedDate of birth reformattedPhone reformattedUnit split from street+2 more
CLM-421260CLMDorothy M Bradley1952-09-12UHC-61130-896219104998634 Canyon Rd, Seattle, WA, 981000.64Middle initial moved out of first nameName re-casedPhone reformattedEmail lower-cased+2 more
CLM-400359CLMAnna Stevens1970-11-09UHC-64371-858123424815582 Union St, Orlando, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-401624CLMLori Carlson1945-09-28UHC-83409-06—2001 Elm St, Scottsdale, AZ, 852700.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-421394CLMMason Miller1955-12-23UHC-52836-22—825 Mountain View Dr, Houston, TX, 770050.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403377CLMRoy Vazquez1941-01-06UHC-90646-4873562334766604 Central Ave, Austin, TX, 787570.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428086CLMArthur Kelley1988-04-25UHC-28863-8143782134114444 Spring St, Tempe, AZ, 852160.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-406187CLMEugene Sanchez2000-07-06UHC-18080-6388581489132820 Palm Dr, Fresno, CA, 937290.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415603CLMJacqueline Gonzales1997-03-13—54322961785010 Cedar Ln, Mesa, AZ, 852260.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411370CLMDiana Grant1941-09-26UHC-53597-9652157561519206 Apache Blvd, Glendale, AZ, 853500.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425069CLMCamila McDonald1988-10-08—81833684962173 Ocean Ave # 104, Houston, TX, 770130.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427188CLMPriya Rodriguez1963-11-16UHC-00786-93—7200 Indian School Rd, Las Vegas, NV, 891540.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427187CLMPriya Rodriguez1963-11-16UHC-00786-93—7200 Indian School Rd, Las Vegas, NV, 891540.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-413115CLMBecky Fuller1952-05-22UHC-12980-5961036217571662 Mesa Dr, Eden Prairie, MN0.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-428122CLMSophia I Rojas1999-11-18UHC-12553-08—4947 Mesa Dr, Nashville, TN, 372990.64Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405348CLMBryan Stevens1967-08-25UHC-54937-27—745 Mountain View Dr, Jacksonville, FL, 322650.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-422479CLMDorothy Wood1949-05-01—47533065467288 Mesa Dr, Jacksonville, FL, 322930.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423056CLMBen Barnes1943-11-28——8722 Ridge Rd, Sacramento, CA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-424708CLMDiane Stephens1971-04-01UHC-27084-1835860561082642 Highland Ave, Chandler, AZ, 852220.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429877CLMLuis Stevens2002-07-18—30826978857599 Grand Ave, Sacramento, CA, 958500.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-432737CLMAna Y Gutierrez1971-09-20UHC-10479-883429411580384 Forest Ave, Austin, TX, 787340.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414820CLMAustin Wood1985-10-06——5714 Cedar Ln, Atlanta, GA, 303560.64Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 121 of 657PreviousNext