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-416001CLMSharon A Valdez1983-05-27UHC-61180-43—5645 Highland Ave, Phoenix, AZ, 850000.64Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+2 more
CLM-406645CLMDenise King1989-06-10—96442564351882 Forest Ave, Mesa, AZ, 852340.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-423208CLMWillie Munoz1960-01-08——1335 Willow Ct, Jacksonville, FL0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413426CLMElizabeth Nichols1954-10-10—74877129355521 River Rd, Nashville, TN, 372030.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-420914CLMRichard Franklin1939-01-20UHC-17661-3821670509541935 Grand Ave, San Diego, CA, 921160.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-403712CLMJoshua Rse1976-07-10UHC-06457-96—6255 Meadow Ln, Los Angeles, CA, 900540.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410474CLMCheryl Moore1945-05-15UHC-22464-21—861 Ocean Ave, Scottsdale, AZ, 852100.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-409202CLMDennis Byrant1949-10-22UHC-30043-1557538657671329 Hillcrest Rd, Dallas, TX, 752340.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-404459CLMKelly Baker2006-08-28——4218 Sunset Blvd # 126, San Diego, CA, 921800.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-422034CLMAngela Cox1944-04-26UHC-63260-82—1497 Elm St, Plano, TX, 750140.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-402194CLMKatherine Bowman1957-01-08UHC-33795-38—9411 Jefferson Ave, Las Vegas, NV0.64Name re-casedZIP missingGender normalisedPlan code upper-cased+2 more
CLM-402193CLMKatherine Bowman1957-01-08UHC-33795-38—9411 Jefferson Ave, Las Vegas, NV0.64Name re-casedZIP missingGender normalisedPlan code upper-cased+2 more
CLM-404069CLMAbigail Hnut1979-11-28UHC-64284-36—8501 Park Pl, Houston, TX, 770020.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418076CLMSalazar Niccole1999-06-23UHC-15589-83—2170 Harbor Blvd, Sacramento, CA, 958380.64Name re-casedDate of birth reformattedSSN last four extractedZIP+4 trimmed+2 more
CLM-422702CLMJJunk1991-09-09UHC-86266-54—7229 Harbor Blvd, Dallas, TX, 752890.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-403378CLMRoy W Vazquez1941-01-06—73562334766604 Central Ave, Austin, TX, 787570.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410142CLMWilliam Contreras2002-04-08——3013 Grand Ave, Seattle, WA, 981160.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402551CLMRussell Walker1990-03-18UHC-74532-9743728655713949 Main St, Orlando, FL, 328350.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-401572CLMJeffrey Q Myers1950-09-19UHC-03305-03—7510 Hillcrest Rd, Austin, TX, 787770.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-423851CLMMadison Bennett1987-08-09UHC-18742-54—8827 Highland Ave, Las Vegas, NV, 891130.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-418845CLMDavid Masn1938-07-25—79096479334860 Mountain View Dr, Jacksonville, FL0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431621CLMVirginia Medina2005-07-18UHC-77003-3472528529328811 Camelback Rd Apt 7, Chandler, AZ, 852580.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-422128CLMMayr Walker1979-11-20UHC-48770-0954751976608097 Hillcrest Rd, Nashville, TN0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410974CLMNicholas Aguilar1977-02-10—53846718944295 Park Pl, Austin, TX, 787730.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425443CLMMaria F Estrada1944-03-01——4694 Baseline Rd, Gilbert, AZ, 852160.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415057CLMRaymmond F Kim2002-05-10UHC-89856-22—1535 Main St, Tempe, AZ, 852970.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-428995CLMAlert Reed1989-09-14——1113 Bayshore Dr, Fresno, CA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-424043CLMAlexander Robertson1986-05-01—55668650457728 Lincoln Way, Chandler, AZ, 852220.64Date of birth reformattedPhone reformattedState name converted to codeEmail lower-cased+2 more
CLM-432568CLMWillie Reyse1967-07-18UHC-22077-99—9120 Mountain View Dr, Nashville, TN, 372250.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-428262CLMBryan Perry1991-09-11UHC-39713-31—3050 Ocean Ave, Austin, TX, 787330.64SSN last four extractedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409870CLMAddam Owens1968-12-11—66081324031894 Lake View Rd, Fresno, CA, 937110.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-420350CLMHelen Wright1968-04-24——1666 Sunset Blvd, Phoenix, AZ, 850190.64Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+2 more
CLM-430151CLMLogan F McDonald1979-12-13UHC-23240-38—900 Sunset Blvd, San Antonio, TX, 782090.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426494CLMAmanda U McDonald1961-09-28——6337 Apache Blvd, Miami, FL, 331780.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-407427CLMWiill Burns2002-02-08UHC-17222-9730647442654216 Apache Blvd, Fresno, CA, 937810.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400436CLMEmma Cox1996-05-09UHC-99349-98—4137 Canyon Rd, Jacksonville, FL, 322110.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-426439CLMChristopher Burke1960-05-08UHC-49095-58—9054 Cedar Ln # 783, Denver, CO, 802430.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-427873CLMAmanda Ford1946-05-22UHC-93605-256678105602251 Baseline Rd, Tucson, AZ, 857260.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425736CLMShaaron Stevens1948-08-04——5794 Jefferson Ave, Los Angeles, CA, 900840.64Two-digit birth yearStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-417426CLMDonna A Evans——52062163934193 Forest Ave, Denver, CO, 802160.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-408337CLMGary Q West1998-01-17UHC-19798-12—6358 Ocean Ave, Columbus, OH, 432780.64Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-407282CLMJames Price—UHC-64093-04—4016 Maple Ave, Charlotte, NC, 282100.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-417320CLMAlexis Walker1962-07-15——2604 Highland Ave, Phoenix, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-407523CLMJeffrey Jensen1965-08-17UHC-12236-9127646217896869 Willow Ct, Tempe, AZ0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-410316CLMDebra G Green2007-10-20UHC-25289-02—4502 Spring St, Miami, FL, 331990.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-411530CLMBeverly Herrera1980-11-28UHC-28703-4666356789527783 Elm St, Fresno, CA, 937260.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-417692CLMSophia B Martinez1950-04-27UHC-22861-8547377233959261 Lake View Rd, Mesa, AZ, 852580.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407018CLMDavdJunk1964-01-25UHC-48679-36—4431 Harbor Blvd, Charlotte, NC, 282020.64Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-414846CLMChristina Gardner1973-08-26UHC-75792-5825249661843126 Central Ave, Gilbert, AZ, 852310.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-411724CLMJulia Jensen1964-03-28UHC-01842-5688569560438676 Sunset Blvd, Tampa, FL, 336670.64Phone reformattedCity re-casedState name converted to codeGender normalised+2 more
32,829 rows, page 116 of 657PreviousNext