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-402191CLMStephen I Burke1948-02-12UHC-69911-23—1851 Highland Ave, Columbus, OH, 432670.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417328CLMMichael R Flores2000-05-13—71631718867802 Oak St, Charlotte, NC0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420024CLMKayla Richards1976-01-10UHC-42568-66—2779 Pine Dr, Dallas, TX, 752560.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425766CLMAnthony Hernandez——57365128919401 Central Ave, Orlando, FL, 328450.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-426585CLMStephen Alvarado1990-04-08UHC-69270-127345033997580 Grand Ave, Scottsdale, AZ, 852170.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403837CLMChristopher H Walsh1987-01-11UHC-69478-9669350551165458 Indian School Rd, Scottsdale, AZ, 852860.62Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more
CLM-408405CLMMarilyn Meyer1969-04-26UHC-34872-28—7037 Forest Ave, Fresno, CA, 937450.62Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
CLM-412930CLMNicholas Price1942-09-03UHC-89676-4482668685305158 Baseline Rd, Fresno, CA, 937940.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-406876CLMEugene Fisher1969-09-25UHC-45550-42—8143 Baseline Rd, Chandler, AZ, 852580.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410790CLM—Junk1956-04-26UHC-38202-11—361 Palm Dr, Orlando, FL, 328970.62Date of birth reformattedPhone missing area codeCity re-casedState code upper-cased+3 more
CLM-402423CLMMargaret D Franklin1941-10-02UHC-75474-2980072453474443 Central Ave, Gilbert, AZ, 852740.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423355CLMCynhia A Luna1962-05-06UHC-52161-93—8928 Oak St, Gilbert, AZ, 852670.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424627CLMAnn Ferguson1972-06-28UHC-46867-34—5384 Hillcrest Rd # 706, Columbus, OH, 432780.62Date of birth reformattedMember ID reformattedUnit split from streetState code upper-cased+3 more
CLM-405579CLMHiroshi Espinoza1970-07-02UHC-80972-01—689 Pine Dr, San Diego, CA, 921170.62Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+3 more
CLM-412941CLMPamela H Collins1942-09-03UHC-20336-2234164224631992 Meadow Ln, Mesa, AZ, 852420.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413394CLMElliott Tyler1954-01-14UHC-10283-5861925872926868 Hillcrest Rd, Plano, TX, 750380.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-432811CLMValentina Jacobs1974-08-06UHC-49399-4189570166167801 Spring St, Las Vegas, NV, 891330.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425613CLMLauren Ray1956-01-12UHC-59761-2635680977389749 Meadow Ln, Orlando, FL, 328220.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416326CLMDeborah Maldonado1958-04-28UHC-25667-878394392191904 Canyon Rd, Fresno, CA, 937860.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-429578CLMJacob Peters1997-09-09UHC-44382-28—7610 Highland Ave, Denver, CO, 802560.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
CLM-414241CLMGabriel B Roberts1981-03-20UHC-70715-12—5611 Maple Ave, Nashville, TN0.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423049CLMAlan Adams1967-08-10—28049517663569 Meadow Ln, Minneapolis, MN, 554800.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-418008CLMJanet W Dixon—UHC-87234-89—6173 Jefferson Ave, Jacksonville, FL, 322290.62Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-426059CLMCarol Arnold1994-11-22UHC-29564-5543177512428501 Central Ave, Minneapolis, MN, 554610.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412707CLMRandy Dixon1991-08-06UHC-17679-69—6924 Willow Ct, Atlanta, GA, 303810.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406322CLMTerry Dunn1970-06-22UHC-54521-89—1568 Cedar Ln, San Antonio, TX, 782020.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400280CLMHeather F Foster2000-04-09UHC-18247-4682260728967943 Central Ave, Miami, FL, 331080.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-422899CLMJoan Hayes2007-06-19——1258 Oak St, Tucson, AZ, 857220.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421853CLMEric Watson2005-01-05UHC-38780-556615613429—0.62Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-410913CLMDiana Chapman——63222728105964 Apache Blvd, Tucson, AZ, 857710.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
CLM-425145CLMCarlos Jordan2006-09-02UHC-81783-75—86 Oak St, Sacramento, CA, 958860.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424307CLMWei Morrison1956-07-26UHC-11160-33—5478 Canyon Rd, Plano, TX, 750310.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-421976CLMThomas Wheeler1951-03-02—62723825415073 Market St, Chandler, AZ, 852800.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-424194CLMDavid Lynch1968-09-13UHC-56000-7073866796947366 Union St, Tempe, AZ, 852070.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-428169CLMKevin Matthews1965-08-15UHC-84075-27—6609 Mesa Dr, Houston, TX, 770740.62Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+3 more
CLM-411968CLMBrian Hoffman1965-06-22——3389 Baseline Rd Apt 30, Gilbert, AZ, 852450.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-431673CLMJacqueline Singh2006-02-07—57961031694215 Church St, Tampa, FL, 336930.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-414596CLMSean N Sandoval1955-05-28UHC-11554-69—8736 Harbor Blvd, Gilbert, AZ, 852030.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423929CLMEthan Wood1961-04-06UHC-73564-9138192289015108 Lincoln Way, Nashville, TN, 372580.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-427999CLMDaniel Gilbert1938-08-24UHC-92037-28—9403 Market St, Tampa, FL, 336240.62Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-419079CLMRandy Harrison—UHC-87479-8925925091327261 Hillcrest Rd, Denver, CO, 802210.62Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+3 more
CLM-417331CLMCatherine Andrews1959-08-12—89762506877499 Bayshore Dr, Denver, CO, 802720.62Name split from “Last, First”Date of birth reformattedPhone reformattedState code upper-cased+3 more
CLM-426988CLMWalter J Sandoval1977-11-24——6499 Canyon Rd # 545, Tampa, FL, 336900.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-425573CLMJanet Tucker1972-06-26UHC-36190-80—4988 Indian School Rd, Minneapolis, MN, 554600.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-420910CLMChristopher Castro2005-02-27UHC-53454-4030143251481841 Maple Ave, Las Vegas, NV0.62Date of birth reformattedPhone reformattedMember ID reformattedCity re-cased+3 more
CLM-415111CLMDylan Carpenter1997-09-04UHC-57619-6038987777072472 Ridge Rd, Minneapolis, MN, 554520.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406185CLMEugene Sanchez2000-07-06UHC-18080-6388581489132820 Palm Dr Apt 34, Fresno, CA, 937290.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-402665CLMYuki Herrera1996-01-20UHC-52366-248004292011301 Elm St, San Diego, CA, 921480.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408957CLM—Junk1988-07-02——6828 Oak St, Sacramento, CA, 958780.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-419819CLMArthur Munoz1956-01-04UHC-55142-03—4160 Sage Ct, Tampa, FL, 336910.62Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
32,829 rows, page 82 of 657PreviousNext