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-411736CLMVincent Oliver1992-04-28UHC-78409-8362740306589366 Main St, San Antonio, TX, 782640.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-430591CLMFrank Willis1973-10-01—64172642759768 Spring St, Tucson, AZ, 857550.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430481CLMAlan Lopez1983-04-13——6719 Union St Apt 38, Gilbert, AZ, 852950.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-411102CLMSofia King1959-10-18UHC-08034-3045460295071813 Valley View Dr, Scottsdale, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-406331CLMBetty Richards1964-11-14UHC-44493-32—3269 Apache Blvd Apt 29, Denver, CO, 802690.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-412059CLMLisa Soto1980-08-16UHC-28518-828755444993264 Elm St, Sacramento, CA, 958760.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416958CLMSharon Little2004-07-03UHC-04514-9989345276658702 Pine Dr, Houston, TX0.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430115CLMIsabella Gardner1997-09-23—74384521832017 Sunset Blvd, Dallas, TX, 752080.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422211CLMVincentJunk1986-08-06—60197590136852 Union St, Phoenix, AZ, 850970.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-416675CLMDbera Wilson1992-06-22UHC-67369-44—5727 River Rd, Glendale, AZ, 853580.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-420015CLMTrery Burns1971-09-12——8343 Main St # 102, Tampa, FL, 336010.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407683CLMRobertson Mark1956-05-14UHC-79068-41—3376 Indian School Rd, Phoenix, AZ, 850530.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431099CLMJose Chapman1986-04-28UHC-83579-0266788760824506 Park Pl, San Diego, CA, 921140.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429806CLMJessica L Hunt—UHC-73352-6577641915393711 Valley View Dr, Miami, FL, 331710.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-422623CLMSofia Mitchell——48546615483017 Meadow Ln, San Diego, CA, 921860.62Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more
CLM-420297CLMCatherine Gonzeles1976-10-27UHC-71670-98—8551 Lake View Rd, Los Angeles, CA, 900320.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-417015CLMAlice Soto1970-05-14—66967810033964 Baseline Rd, Eden Prairie, MN, 553060.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-412261CLMRalph Fox1970-06-04UHC-07336-81—2658 Indian School Rd, Orlando, FL, 328000.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412713CLMBryan Hicks1953-04-25UHC-57811-46—856 Valley View Dr, Los Angeles, CA, 900130.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-415133CLMJeremy Long—UHC-77442-7875678501882147 Market St, Miami, FL, 331380.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-424541CLMNoah O Dixon1968-05-24UHC-37800-5452678177485291 Camelback Rd, Atlanta, GA, 303960.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-427440CLMDanielle Crawford2002-09-25UHC-73270-5766558355783798 Desert Sky Blvd, Phoenix, AZ, 850330.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415331CLMBruce Bryant2000-04-09UHC-31867-7243545167069841 Meadow Ln, Chandler, AZ, 852360.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-412493CLMYuki Morris2003-08-09UHC-25204-2334847717487731 Forest Ave, Columbus, OH0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426368CLMChristian M Wilson1960-12-20—42082863344665 Elm St, Las Vegas, NV, 891660.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403435CLMRyan Patel2008-04-15——2016 Pine Dr, San Antonio, TX, 782700.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422251CLMDaniel Schmidt1942-09-14—67364888756725 Cedar Ln, Dallas, TX, 752320.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424965CLMAlice Butler1948-01-25UHC-00725-73—7764 Main St, Austin, TX, 787490.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421429CLMMaria X Delgado1996-06-14—24659137799693 Highland Ave # 842, Nashville, TN, 372850.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-431523CLMChristina Rios1973-07-13—70358554664772 Main St # 306, San Antonio, TX, 782690.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-402946CLMFrances Bailey1996-09-28UHC-91801-04—8364 Park Pl, Nashville, TN, 372260.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431797CLMCatherine Carroll1972-09-27—42930870501286 Broadway, Chandler, AZ, 852360.62Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
CLM-415632CLMMei D Wallace2005-01-01UHC-94738-1257497018264583 Cedar Ln, Seattle, WA, 981720.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411638CLMAbigail Hill1992-09-20—76653231886087 Grand Ave, Charlotte, NC0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-414998CLMBrenda Martin1947-08-27——1423 Forest Ave, Charlotte, NC, 282410.62Name re-casedDate of birth reformattedCity re-casedState name converted to code+3 more
CLM-414532CLMPamela Lynch1939-11-19UHC-10784-9873283078918061 Sunset Blvd, Tempe, AZ, 852080.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401271CLMMason Porter1984-11-16UHC-76399-31—9563 Ocean Ave, Scottsdale, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426158CLMRoy Watson1981-02-16—59696106337291 Hillcrest Rd, Glendale, AZ, 853030.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424055CLMTimothy Griffin—UHC-74484-31—3387 Hillcrest Rd, Austin, TX, 787610.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-401173CLMCarl Cole1943-08-19UHC-70721-52—2452 Oak St, Columbus, OH, 432160.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401299CLMFrank Park1940-10-09UHC-71024-0664327029249254 Cedar Ln, Sacramento, CA, 958860.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-406978CLMRalph Howell1978-12-28—38999589496338 Mountain View Dr, Los Angeles, CA, 900300.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-409551CLMAngela Ray——77350850247226 Sage Ct, Tampa, FL, 336160.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-403717CLMWillie Le2006-12-02UHC-57029-9249073027853352 Forest Ave Apt 16, Las Vegas, NV, 891050.62Name re-casedPhone reformattedUnit split from streetCity re-cased+3 more
CLM-410253CLMFrank Cater1947-02-18UHC-10287-5144689080328754 Meadow Ln, Tempe, AZ, 852770.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410484CLMCarolyn Price2005-12-07—63029916988651 Ridge Rd, Atlanta, GA, 303910.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411458CLMTerry N Arnold1952-02-27UHC-57242-43—5298 Elm St, Sacramento, CA, 958770.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-423277CLMMaria Clark1949-12-07—69475988338006 Apache Blvd, Columbus, OH, 432890.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401130CLMGabriel Lane1997-11-04UHC-54367-0953452325068839 Lincoln Way, Columbus, OH, 432680.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420078CLMMaidson Flores—UHC-58663-08—4481 Mountain View Dr, Gilbert, AZ, 852520.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 85 of 657PreviousNext