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-400429CLMBradley Carroll2004-12-02—69476208971790 Highland Ave Apt 26, Columbus, OH, 432330.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-409459CLMJustin Shaw1985-07-27UHC-22694-54—861 Ridge Rd, Dallas, TX0.62Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-422827CLMSharon T Garza1952-02-28UHC-52770-07—6046 Oak St # 437, Miami, FL, 331340.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404071CLMRyan Jimenez1955-06-10—27650957532708 Forest Ave, Denver, CO, 802940.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-421278CLMElizabeth Santiago1974-02-24UHC-79914-4446341656651713 Ridge Rd, Mesa, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-416111CLMRoger Reyes1951-02-02—79350328031755 Valley View Dr, Mesa, AZ, 852870.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-416655CLMDlan Carroll1991-03-20UHC-34004-6454055581904376 Central Ave, Phoenix, AZ, 850320.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-408409CLMLuis Peterson1981-09-10UHC-91715-296365374820807 Canyon Rd Apt 18, Los Angeles, CA, 900470.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-422399CLMAbigail Sanders1975-03-11UHC-08668-77—9314 Baseline Rd # 669, Tucson, AZ, 857460.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-411682CLMBarbara Robinson1958-02-05—26622184851109 Hillcrest Rd, Los Angeles, CA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-419904CLMChristine Hawkins1963-02-21—47132140891463 Palm Dr, Miami, FL, 331380.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-410617CLMRonald Sanders1978-08-24—49947785917520 Church St, Minneapolis, MN, 554140.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-407317CLMElizabeth Smith—UHC-74794-1532992034686705 Sunset Blvd, Plano, TX, 750860.62Name re-casedDate of birth reformattedDate of birth unreadableCity re-cased+3 more
CLM-432076CLMEmily Z Shaw1992-02-13UHC-67683-28—1137 Washington St # 546, Gilbert, AZ0.62Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+3 more
CLM-401346CLMVincent Roberts1986-05-22—41462984034910 Mountain View Dr # 166, Sacramento, CA, 958520.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-404730CLMLuis Jimenez1980-12-13UHC-81143-69—4600 Forest Ave, Tampa, FL, 336610.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-424114CLMJanice Ortega1989-12-12UHC-16709-3725428464247739 Canyon Rd, Orlando, FL0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-403581CLMFrank Thompson1992-04-06—44693091827457 Spring St Apt 10, Tucson, AZ, 857100.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-428945CLMPamela Baker1947-03-10—79732046418610 Baseline Rd, Dallas, TX, 752120.62Phone reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
CLM-403268CLMKenneth Coopar1999-04-06UHC-97521-3244747745166394 Baseline Rd, Mesa, AZ, 852340.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425841CLMDorothy Wang1974-07-20——4129 Bayshore Dr, Columbus, OH, 432680.62Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
CLM-423754CLMSantiago Welch2005-05-16UHC-58279-6332448393931935 Maple Ave # 245, Nashville, TN, 372190.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-406197CLMAnn Gonzalez1965-09-11UHC-64011-6344175777012303 Pine Dr, Nashville, TN, 372130.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430999CLMJudy Oliver1939-04-05UHC-16714-1560755648459763 Harbor Blvd, Plano, TX, 750890.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-419874CLMJessica Reid1980-05-01——5218 Washington St, Seattle, WA, 981670.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417474CLMWilliam Patterson1974-02-18UHC-70673-52—9035 Sunset Blvd, Miami, FL, 331720.62Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417125CLMJordan J Carr1977-09-07——4252 Park Pl, Jacksonville, FL, 322010.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-420618CLMNathan Tran2003-06-21—80033410534071 River Rd, Los Angeles, CA, 900610.62Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+3 more
CLM-423003CLMRobert Maldonado1994-03-20UHC-70978-88—8660 Valley View Dr, Orlando, FL, 328500.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409407CLMMason Munoz2007-02-11—31126218752110 Apache Blvd, Charlotte, NC, 282770.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-417423CLMJimmy Crawford1974-01-28UHC-30066-1392255689123463 Washington St, Tampa, FL, 336700.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-432720CLMMarcus Carter1973-12-02UHC-88098-4529227190332539 Desert Sky Blvd, Columbus, OH, 432720.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-418201CLMDeborah W Estrada1991-03-10—73185275945054 Park Pl, San Antonio, TX, 782100.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-408557CLMJerry Lawosn1992-06-03—55962059886696 Spring St, Los Angeles, CA, 900100.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423438CLMStephen E Weber1966-02-18UHC-21091-7646595021624771 Grand Ave, Eden Prairie, MN, 553760.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-423439CLMStephen E Weber1966-02-18UHC-21091-7646595021624771 Grand Ave, Eden Prairie, MN, 553760.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-412354CLMDeborah V Gilbert1966-05-12UHC-22494-0971529971275353 Church St, Minneapolis, MN, 554120.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-420710CLMKathleen Castillo1998-11-21——3704 Sage Ct, Dallas, TX, 752490.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401423CLMMaria Singgh1983-05-20UHC-69979-7059635823878998 Jefferson Ave, Las Vegas, NV0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413765CLMVirginia Park1957-02-18UHC-36087-6690388914748609 Canyon Rd, Tampa, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-430974CLMDiane Olson1981-07-11——4637 Lake View Rd # 174, Jacksonville, FL, 322570.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
CLM-416963CLMJudith U Powell1970-10-21UHC-41358-5186030088108553 Canyon Rd, Scottsdale, AZ, 852660.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420113CLMRebecca K Griffin1980-04-17—94395141889239 Bayshore Dr, Houston, TX, 770280.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-401028CLMSara X Ortega1976-02-06UHC-81674-85—5180 Church St, Fresno, CA, 937290.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405285CLMDaniel Perkins2003-03-06UHC-34433-037527978181275 Palm Dr, Tucson, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-424120CLMJudy Watkins1973-04-08UHC-12017-24—5633 Market St, Columbus, OH, 432700.62Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-407376CLMDiana Jacobs2008-11-10—88837372885990 Mountain View Dr, Orlando, FL, 328180.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-409001CLMAlice Reid1950-07-06UHC-19821-2925070128843716 Harbor Blvd, Orlando, FL, 328610.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-410051CLMAhmed Simmons2003-11-04UHC-02922-0598348995704902 Main St, Dallas, TX0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-400106CLMCharles Hall1983-05-04UHC-31175-8056648806209101 Sage Ct, Tucson, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
32,829 rows, page 80 of 657PreviousNext