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-410840CLMAmy Martin1950-07-24—28446516455564 Apache Blvd Apt 34, Mesa, AZ, 852120.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-417666CLMFrank James1954-05-28——1373 Highland Ave, Miami, FL, 331500.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408530CLMJudith Dean1998-06-17UHC-47353-9698974443037492 Market St, Mesa, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404623CLMTeresa Mendez1987-06-26UHC-99599-8480742008184688 Willow Ct # 540, Chandler, AZ, 852580.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-427717CLMDaviid D Griffin1958-07-13—50728992229704 Forest Ave, Scottsdale, AZ, 852640.60Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407620CLMMateo Rivera1958-11-09UHC-49017-4481380822223705 Spring St, Atlanta, GA, 303070.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-428215CLMRebecca Hamilton1954-02-23UHC-26416-0321551936152665 Indian School Rd # 301, Plano, TX, 750190.60Name re-casedPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-422980CLMAnna Vega1983-09-27UHC-59908-7654025613347331 Forest Ave, Nashville, TN, 372310.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-410960CLMYnag Valentina1943-08-22—86092196012679 Sunset Blvd, Seattle, WA, 981310.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-402957CLMGabriel McDonald1947-11-21UHC-21533-1687138054768474 Desert Sky Blvd, Plano, TX, 750120.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-415811CLMJoshua Simmons1974-12-28UHC-19558-3057891150471213 Main St, Seattle, WA0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424321CLMRalph T Santiago1964-01-11UHC-93505-5028751284512638 Bayshore Dr, Dallas, TX, 752400.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424515CLMSantiago Silva1955-12-21UHC-65994-6733659397442852 Valley View Dr, Tampa, FL, 336150.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-419870CLMSofia Kelley1956-01-22UHC-11034-9341264281217324 Sage Ct, Tampa, FL0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-401929CLMJean Contreras1943-05-24UHC-66804-0467961950906390 Pine Dr # 896, Orlando, FL, 328220.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-430022CLMMason Santiago1989-12-06UHC-44962-5965452143483907 Sage Ct # 696, Denver, CO, 802310.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409892CLMShirley Jimenez2002-02-10UHC-16328-4642721793302890 Ocean Ave, Minneapolis, MN, 554730.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417933CLMLarry Rogers1970-02-10UHC-32272-0941894939837957 Highland Ave, Eden Prairie, MN, 553490.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421824CLMJeffrey Green1958-05-12UHC-73338-83—6830 Church St, Columbus, OH, 432290.60Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-401776CLMTyler M Taylor2000-06-06UHC-19451-2783157810859668 Hillcrest Rd, Charlotte, NC, 282710.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-415832CLMJudy Wells1994-01-06UHC-36200-438396910901331 Grand Ave, Seattle, WA, 981070.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-410515CLMKayla Bailey1981-10-10UHC-99784-0664197401179032 Sunset Blvd, Tempe, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-415221CLMNathan L Cole——33651123922027 Sage Ct, Denver, CO, 802880.60Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-421128CLMFrances Ruiz1949-05-28UHC-20383-9344066638844560 Cedar Ln, Mesa, AZ, 852150.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-408779CLMBryan S Smith2003-10-02UHC-11693-40—8664 Ridge Rd, Nashville, TN, 372070.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419302CLMAdam Wheeler1950-10-17—78260261353569 Jefferson Ave, Houston, TX, 770560.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420826CLMGeorge Foster1972-01-04—60284373121130 Mesa Dr Apt 10, Orlando, FL, 328260.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-426971CLMTimothy Flores1980-11-12UHC-44991-41—9101 Baseline Rd, San Antonio, TX, 782600.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-424944CLMKayla Simmons2003-07-15UHC-11502-95—6651 Jefferson Ave, Tampa, FL, 336860.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-424501CLMNicholas Burns1982-06-07UHC-59582-06—2447 Grand Ave, Eden Prairie, MN, 553680.60Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
CLM-426497CLMPaul Marshall1962-10-12UHC-10623-895663160388980 Central Ave, Atlanta, GA, 303880.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
CLM-401431CLMSophia Pierce1973-09-23UHC-04501-4247666937776744 Desert Sky Blvd, Glendale, AZ, 853820.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-420950CLMHioshi Montgomery1976-04-17——1778 Ridge Rd, Miami, FL, 331230.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420772CLMElijah R Gutierrez—UHC-69658-6323257389748582 Washington St, San Antonio, TX, 782620.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
CLM-429553CLMAnna Harvey1968-10-09UHC-53608-5477757454583429 Forest Ave, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429554CLMAnna Harvey1968-10-09UHC-53608-5477757454583429 Forest Ave, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417257CLMCarl Robinson1991-05-20—53645219791417 Bayshore Dr, Los Angeles, CA, 900560.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419421CLMSharon Sanchez1996-03-09——6949 Canyon Rd, Tempe, AZ, 852710.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-427317CLMLarry Lee2005-12-19UHC-32257-04—3908 Canyon Rd, Nashville, TN0.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-431733CLMHenry Lopez1968-10-24UHC-84906-5821835617511854 Central Ave, Minneapolis, MN, 554710.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404092CLMJeremy Richards1990-07-11—54125523749885 Union St, Atlanta, GA, 303940.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-407081CLMAndrew R Fisher1976-09-27——6348 Bayshore Dr, Tampa, FL, 336220.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-408213CLMBilly Olson1974-06-21UHC-87272-6670644639242435 Main St, San Diego, CA, 921260.60Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417541CLMSusan Perkins1992-07-11UHC-70290-7063973836951937 Central Ave, Tempe, AZ, 852890.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402019CLMJanice T Adams1960-10-20UHC-49605-1825989336336917 Forest Ave, Gilbert, AZ, 852420.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405984CLMBrian V Perkins1971-11-22UHC-98944-1781453737162848 Sage Ct, Seattle, WA, 981880.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417804CLMSaan F Wright2002-05-23UHC-54869-17248949323034 Bayshore Dr, Austin, TX, 787530.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-413014CLMRoger Holmes1978-08-03UHC-75657-144724286696289 Grand Ave, Los Angeles, CA, 900870.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426991CLMMartha Jenkins1987-01-15—29447690828650 Apache Blvd, Sacramento, CA0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426873CLMJoseph Berry1999-08-25——3868 Main St, Atlanta, GA, 303720.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
32,829 rows, page 68 of 657PreviousNext