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-422348CLMBarbara Howard1979-03-23UHC-25098-80—3433 Highland Ave, Fresno, CA, 937360.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-402244CLMNicholas Santiago1991-10-19UHC-71532-02—7444 Bayshore Dr, San Diego, CA, 921730.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-420238CLMKatherine Patel1968-05-21——4167 Main St, Houston, TX, 770920.66Name re-casedTwo-digit birth yearZIP+4 trimmedPlan code upper-cased+1 more
CLM-403655CLMCamila Montgomery2007-10-20UHC-03721-09—8901 Pine Dr, Minneapolis, MN, 554320.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-421495CLMCarol Garza1993-10-02UHC-47943-41—7562 Sunset Blvd, Plano, TX, 750370.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-417818CLMRalph Gibson1987-03-21—56984475712194 Baseline Rd Apt 31, Miami, FL, 331430.66Two-digit birth yearUnit split from streetCity re-casedState code upper-cased+1 more
CLM-407698CLMCarol K Stephens1964-07-24UHC-03862-38265616282781 Cedar Ln, Sacramento, CA, 958870.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401516CLMAlice Le1943-01-22——845 Bayshore Dr, Charlotte, NC0.66Date of birth reformattedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-404170CLMJean Walsh1949-10-02——2051 Canyon Rd, Los Angeles, CA, 900590.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-401751CLMAgnela Fowler1969-11-24UHC-91761-70—1269 Sage Ct, Tempe, AZ, 852830.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411179CLMJean Morrison1942-01-18—89297075341239 Spring St, Tampa, FL, 336150.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
CLM-417035CLMLaura Diaz1949-03-22UHC-36829-6177553293503940 Bayshore Dr # 785, Phoenix, AZ, 850990.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-404690CLMAhmad Vega2002-10-16——3061 Maple Ave, Tucson, AZ, 857390.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400322CLMPeter C Garrett1981-03-11UHC-70030-7933278542448443 Oak St, Fresno, CA, 937830.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425116CLMSean Larson1990-01-19—39639924863183 Camelback Rd, Sacramento, CA, 958440.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-416181CLMMari Castro1973-08-17UHC-68892-31—571 Maple Ave, Denver, CO, 802490.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-408805CLMGerald Mendez1938-07-14UHC-57711-14—6822 Baseline Rd, Columbus, OH, 432440.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-416074CLMElijah R Price1986-12-26UHC-50102-3223231590743333 Palm Dr, Phoenix, AZ, 850240.66Middle initial moved out of first nameTwo-digit birth yearPhone reformattedWhitespace trimmed+1 more
CLM-420087CLMBetty Vega1946-04-04UHC-40806-3429375390211690 Bayshore Dr, Columbus, OH, 432480.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412045CLMLorri E Perkins1969-01-03UHC-69897-97——0.66Name split from “Last, First”Date of birth reformattedPhone missing area codeWhitespace trimmed+1 more
CLM-430469CLMTimoty Spencer1995-07-19UHC-67042-5771696609148036 Lake View Rd, Eden Prairie, MN, 553140.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-410312CLMBenjamin Jones1991-05-27UHC-38434-13—4261 Sunset Blvd, Columbus, OH, 432630.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-405783CLMDoris Robertson1951-03-03—62681738021581 Canyon Rd # 667, Houston, TX, 770970.66Date of birth reformattedPhone reformattedUnit split from streetGender normalised+1 more
CLM-403005CLMDavid J Turner2008-02-01UHC-49519-18—6730 Sage Ct, Tampa, FL, 336290.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-428747CLMPeter H Perry1943-06-26——5594 Elm St, Orlando, FL, 328360.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409528CLMMatthew Hanson1944-12-11—29276074821870 Spring St, Glendale, AZ, 853250.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-424217CLMBrandon Guzman1948-12-09UHC-75095-65—3766 Sunset Blvd, Tempe, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-418340CLMDoulgas Gomez1989-08-20UHC-25187-4768997965291670 Ocean Ave, San Antonio, TX, 782420.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431742CLMJason Brown1949-07-18UHC-16548-66—1334 Palm Dr, Nashville, TN, 372050.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-429478CLMTheresa Rogers1966-02-03UHC-93439-8378168745815959 Forest Ave, Mesa, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-402138CLMBruce B Johnston1957-08-10——3273 Harbor Blvd, Dallas, TX, 752750.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-412566CLMKathleen Lane—UHC-31114-80—7643 Highland Ave, Miami, FL, 331930.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-415285CLMJanice Edwarsd1951-03-03UHC-49570-052073584379207 Park Pl, Dallas, TX, 752390.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-405388CLMMaria P Ramso1947-07-08UHC-85846-5046227164644261 Maple Ave, Tucson, AZ, 857070.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-425947CLMJustin Bennett1996-11-06UHC-31433-79—7156 Broadway, Tampa, FL, 336670.66Two-digit birth yearMember ID reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-414056CLMAmanda Chapman1950-09-03UHC-94916-7776678759676464 Maple Ave # 624, Miami, FL, 331370.66Name split from “Last, First”Phone reformattedUnit split from streetWhitespace trimmed+1 more
CLM-425472CLMDiana I Howell1946-09-28UHC-87462-4878255177196018 Apache Blvd, Dallas, TX0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-428709CLMHiroshi Herrera1979-01-23—48227353604577 Union St, Plano, TX, 750180.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
CLM-407664CLMChris Bowman1955-10-13—88870682091409 Jefferson Ave, Denver, CO, 802380.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-429917CLMMelissa Soto1979-06-25UHC-47899-58—4356 Jefferson Ave, Fresno, CA, 937230.66Street suffix standardisedAddress re-casedState name converted to codePlan code upper-cased+1 more
CLM-406162CLMJordna Harvey1943-08-22UHC-83802-5561522078308555 Jefferson Ave, Las Vegas, NV, 891830.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-402095CLMNatalie Graham1969-01-02UHC-06183-5538882610898770 Oak St, Jacksonville, FL, 322280.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-405523CLMCheryl N Munoz1946-05-05UHC-39247-4684987148885559 Sage Ct, Mesa, AZ, 852760.66Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-418245CLMAmy McCoy1971-10-19—64621149007151 Broadway, Chandler, AZ0.66Two-digit birth yearAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-413956CLMNoah Espinoza1942-02-16UHC-52234-98——0.66Phone missing area codeMember ID reformattedGender normalisedWhitespace trimmed+1 more
CLM-431566CLMLawrence J Davis1987-06-12——9021 Highland Ave, Plano, TX, 750270.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-428056CLMSteven Matthews1997-12-04UHC-10194-8292087861893860 Highland Ave, Phoenix, AZ, 850910.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-400142CLMJudy C Alvarez1941-02-13—42133525962526 Washington St, Eden Prairie, MN0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-421596CLMTerry L Li1965-05-07—46233774668628 Oak St, San Antonio, TX, 782450.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-410567CLMCarol Luna1974-03-25UHC-13714-3429562662276623 Harbor Blvd, Atlanta, GA, 303200.66Member ID reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
32,829 rows, page 157 of 657PreviousNext