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-423422CLM—Junk1969-08-25UHC-95875-47—5564 Central Ave, Minneapolis, MN0.48Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-408014CLMAna Ortega1951-06-23UHC-19282-90—2539 Palm Dr, Scottsdale, AZ, 852300.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-427134CLMCarolyn Sullivan1992-02-06UHC-26152-569034196631695 Indian School Rd Apt 18, Tempe, AZ, 852800.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-407270CLMPeter W Moore1945-10-03UHC-56208-0823576307561771 Canyon Rd, Miami, FL, 331400.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421876CLMMaria H Simpson2008-12-22UHC-29411-66—2468 Union St, Houston, TX, 770560.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-413596CLMAmanda Y McCoy1969-01-12UHC-80480-018678939961428 Mesa Dr # 176, Houston, TX, 770160.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-402888CLMMark Cole1958-09-01UHC-08276-88—9515 Sunset Blvd, Nashville, TN, 372860.48Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416152CLMNathan Le—UHC-58783-6452191340346482 Forest Ave, Las Vegas, NV, 891820.48Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
CLM-420405CLMSara Harvey1984-02-18UHC-26372-6062454314628811 Church St, Denver, CO0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-415767CLMMazon Castro1957-09-28UHC-01653-7276440396754926 Main St, Austin, TX, 787680.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-432175CLMAnthony Park2001-02-22UHC-76242-392763139632379 Oak St, Dallas, TX, 752310.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-431403CLMGary Matthews1945-11-13UHC-27209-5168186657924842 Pine Dr, Charlotte, NC, 282660.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-415453CLMLawrence Richards1964-11-21UHC-84652-73—6040 Main St, Columbus, OH, 432360.48Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418564CLMGeorge Z Li1955-11-01—65225429579770 Jefferson Ave, Atlanta, GA, 303490.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422951CLMBradley Bryant1990-12-16UHC-99924-03—3422 Lake View Rd, Atlanta, GA, 303700.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400543CLMBryan Valdez1986-09-17—51898392145624 Canyon Rd, Columbus, OH, 432730.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-428426CLMRachel CJunk1961-03-10——1832 Grand Ave, Seattle, WA, 981540.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-428427CLMRachel CJunk1961-03-10——1832 Grand Ave, Seattle, WA, 981540.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-403184CLMGabriel Yang1960-04-14UHC-81771-20—1130 Elm St, Columbus, OH0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
CLM-402040CLMMark Palmer2008-07-25—66045130546191 Oak St Apt 3, Gilbert, AZ, 852980.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-419757CLMLukia Patel1982-11-08UHC-19806-9952092535533367 Meadow Ln Apt 11, Atlanta, GA0.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-429938CLMLauren I Johnson1991-06-20UHC-39409-51—1441 Central Ave Apt 3, Tempe, AZ, 852000.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-416437CLMAnna F Baker1944-10-27UHC-10154-5872278878473705 Palm Dr, Chandler, AZ, 852890.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-425714CLMTeresa Fisher1959-04-26UHC-20504-8153576863085150 Main St, Scottsdale, AZ, 852990.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-430558CLMValentina Johston1981-12-19—46654317928285 Apache Blvd, Dallas, TX, 752450.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417285CLMAaron Ramos1994-06-24UHC-51082-4335898806221086 Desert Sky Blvd, Orlando, FL, 328540.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-402696CLMAnthony Martin1982-10-23——2343 Oak St, Phoenix, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419893CLMLawrence Jackson—UHC-33336-5843029335148802 Harbor Blvd, Nashville, TN0.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-430512CLMRuth Schutz2007-02-04UHC-03534-7074652808561937 Bayshore Dr, San Antonio, TX0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-403397CLMJeremy Munoz—UHC-92193-2992186020351606 Church St, Eden Prairie, MN, 553140.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-412070CLMKevin Mejia——87490239626452 Ridge Rd, Minneapolis, MN, 554860.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-419012CLMGeorge Washington1982-02-08UHC-44790-08—3555 Grand Ave Apt 12, Miami, FL, 331220.48Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
CLM-415017CLMArthur Harvey1976-03-14UHC-78370-2190469839225334 Elm St # 811, Seattle, WA, 981040.48Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-427586CLMCarl Gardner2004-02-12UHC-45737-6269331806513562 Hillcrest Rd, Glendale, AZ0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-410438CLMMertha Chapman1938-04-06——1455 Mountain View Dr, Tempe, AZ, 852180.48Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
CLM-411515CLMCarl McCoy2008-07-20—40239181259103 Palm Dr, Tampa, FL, 336970.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403951CLMBobby Cooper1998-12-01UHC-84475-104882831996379 Church St, Chandler, AZ, 852780.48Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
CLM-415972CLMPeter Padilla1985-05-25—75844332803373 Mountain View Dr, Phoenix, AZ0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401163CLMSara Guzman1958-06-21—81540870093218 Hillcrest Rd, Eden Prairie, MN, 553540.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400262CLMRonald Estrada1972-07-19——8013 Market St # 880, Mesa, AZ, 852960.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-414052CLMIsabella Z Watkins1967-06-02UHC-63631-99—1407 Ocean Ave # 261, Mesa, AZ, 852230.48Date of birth reformattedSSN last four extractedUnit split from streetStreet suffix standardised+4 more
CLM-410870CLMGerald I Bennett——51080651934382 Canyon Rd, Columbus, OH, 432340.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-430059CLMChristine Phillips1989-02-18UHC-86842-73—3969 Hillcrest Rd # 129, Gilbert, AZ, 852910.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-419307CLMNoah Roberts1953-07-09UHC-09396-3868583620985412 Main St Apt 9, Mesa, AZ, 852160.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-431333CLMRebecca Stewart1941-09-21UHC-12215-275966087482378 Willow Ct, Plano, TX, 750590.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425633CLMJoyce Williams1955-08-15UHC-83998-1340994407577046 Oak St Apt 36, Dallas, TX, 752430.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-430051CLMGary Chapman1981-02-12——8674 Lake View Rd, San Diego, CA, 921450.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-409043CLMLogan Hart2000-06-10UHC-52400-4861576470739697 Sage Ct, Sacramento, CA, 958220.48Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-409279CLMJason Franklin2003-03-23UHC-91114-2480252478049488 Forest Ave, Tucson, AZ, 857880.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405375CLMSara M Ray1970-06-23—55048008792228 Jefferson Ave, Las Vegas, NV, 891200.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
32,829 rows, page 20 of 657PreviousNext