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-406822CLMCheryl Rivera1963-09-14UHC-26252-8498933507897489 Apache Blvd, Phoenix, AZ, 850390.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-403628CLMJacob Brown1984-09-17UHC-55032-13—2479 Camelback Rd, Dallas, TX, 752970.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410595CLMBetty Hunter1989-09-07UHC-84042-088756302387—0.62Name re-casedTwo-digit birth yearPhone reformattedEmail lower-cased+3 more
CLM-416996CLMAbby H Gomez1954-05-20UHC-76184-5423423804989733 Apache Blvd Apt 37, Tempe, AZ, 852560.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421314CLMEmma Hayes1947-11-22UHC-08659-93—7363 Cedar Ln # 368, Charlotte, NC, 282150.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-410597CLMMarcus Pierce1944-05-08UHC-37511-8847390667837945 Park Pl, Los Angeles, CA, 900960.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-431536CLMAmanda O Li1968-03-22——8177 Ridge Rd, Gilbert, AZ, 852820.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431537CLMAmanda O Li1968-03-22——8177 Ridge Rd, Gilbert, AZ, 852820.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423500CLMOmar Silva1962-06-26UHC-10513-4335649936744924 Mountain View Dr, Seattle, WA, 981790.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406746CLMPatricia Mendez2004-07-01UHC-77558-15—7575 Union St, Minneapolis, MN, 554040.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427553CLMAnthony C Oliver1962-09-24UHC-51791-98—697 Meadow Ln, Phoenix, AZ, 850260.62Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-410951CLMJoseph Estrada1977-05-26UHC-44142-504514839542712 Washington St, Los Angeles, CA, 900250.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-414637CLMEvelyn V Hawkins———5677 Harbor Blvd, Charlotte, NC, 282800.62Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
CLM-416125CLMDouglas Fox1960-12-20UHC-38814-4545751069238330 Forest Ave, Columbus, OH0.62Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
CLM-406823CLMAmy Andrews1986-08-10—51225670256269 Market St, Minneapolis, MN, 554300.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-425147CLMDiane Wells1941-11-24UHC-04452-6061457509293200 Highland Ave, Scottsdale, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407588CLMCharlie H Thomas1941-07-20UHC-32673-4988626801113700 Washington St, Dallas, TX, 752030.62Name re-casedPhone reformattedCity re-casedState name converted to code+3 more
CLM-425889CLMRandy B Edwwards1967-04-07——1054 Washington St, Miami, FL, 331280.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431579CLMRichard Miller1966-07-22UHC-60998-1632983776031979 Hillcrest Rd, Miami, FL, 331540.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-427974CLMChristopher Obrien1982-05-11——5265 Central Ave, Atlanta, GA, 303320.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432781CLMBrien Vazquez1956-09-26UHC-89900-1035426050106606 Oak St, Austin, TX, 787660.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427471CLMKevin Cunningham1985-04-13UHC-16391-2093571762497364 Highland Ave, Fresno, CA, 937680.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426148CLMAaron D Baker2002-01-13UHC-67046-9885775072953501 Indian School Rd, Gilbert, AZ, 852510.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-421247CLMMichael Simmons1978-04-13UHC-43803-7678555547937323 Park Pl, Dallas, TX, 752060.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-402622CLMLuis Vega1938-07-28—89842596192560 Ocean Ave, Minneapolis, MN, 554580.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411626CLMSantiago F Henry1995-11-06—3157058390226 Canyon Rd, Mesa, AZ, 852550.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400560CLMMateo Espinoza1979-03-21——2755 Central Ave, Austin, TX, 787980.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-402084CLMPeter Walker1986-04-18UHC-17729-5130950745095541 Palm Dr, Glendale, AZ, 853860.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406413CLMJack E Contreras1981-12-13UHC-94998-0927029527943703 Pine Dr, Atlanta, GA, 303140.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431297CLMStephen L Butler2000-08-09UHC-10227-9962338792351461 Pine Dr, Atlanta, GA, 303540.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-420702CLMLauren Gutierrez1942-10-10—44090837695474 Indian School Rd, Chandler, AZ, 852200.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422101CLMIsabella Kelly1959-02-25—45059334222733 Sunset Blvd, Dallas, TX, 752150.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-421832CLMLarry Hanson1959-07-28UHC-36825-9221328224225391 Mountain View Dr, Seattle, WA, 981330.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429148CLMBobby Ramos1984-08-24UHC-85174-89—963 Washington St, Atlanta, GA, 303310.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422883CLMHannah P Ramos1989-05-18UHC-00055-7739067553296381 Desert Sky Blvd, Dallas, TX, 752070.62Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-410866CLMLawrence Harper1995-05-16UHC-85664-27—3049 Broadway, Atlanta, GA, 303290.62Name split from “Last, First”Two-digit birth yearMember ID reformattedAddress re-cased+3 more
CLM-428671CLMJordan Sullivan2001-02-14—66985032922637 Ocean Ave, Gilbert, AZ, 852530.62Street suffix standardisedAddress re-casedCity re-casedGender normalised+3 more
CLM-428386CLMEric Simons1978-05-13UHC-98882-0635340140204431 Lake View Rd, Tampa, FL, 336350.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415541CLMKen Morgan1969-05-17—88162542604960 Bayshore Dr, Denver, CO, 802780.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-415542CLMKen Morgan1969-05-17—88162542604960 Bayshore Dr, Denver, CO, 802780.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423846CLMAnna Wong1955-01-13—60141536153418 Indian School Rd, Las Vegas, NV0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-432755CLMJess Sandoval1991-04-26UHC-21043-3096686445348440 Hillcrest Rd, Minneapolis, MN, 554910.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
CLM-409457CLMTimothy Perez1940-01-24UHC-45125-9187332130783824 Oak St, Miami, FL, 331970.62Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-412783CLMChristina M Herrera1954-09-19UHC-81624-09—6995 Pine Dr, Plano, TX0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423675CLMAshley J Wong1981-05-08UHC-65191-42—3178 Baseline Rd, Houston, TX, 770830.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-411166CLMJose B Morrison1962-08-14UHC-74741-2562423121313629 Park Pl, Tucson, AZ, 857710.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424261CLMLawrence Carpenter1948-04-25UHC-02642-896622215798132 Valley View Dr # 304, Columbus, OH, 432810.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-419909CLMJonathan Baker1967-06-19UHC-36841-62—4091 Sunset Blvd, Columbus, OH, 432510.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-403743CLMRaymond Park1976-12-12UHC-17523-4573240012918576 Forest Ave, Tampa, FL, 336260.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427201CLMWilliam Hansen1974-02-21UHC-24086-77—201 River Rd, Jacksonville, FL, 322470.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 97 of 657PreviousNext