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-419625CLMDonna Young1959-04-09UHC-09777-5420522212339562 Grand Ave, Tampa, FL, 336400.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428060CLMJoyce Ramirez1983-06-25UHC-92711-12—5983 Park Pl, Orlando, FL, 328990.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-429022CLMNancy Martin1947-07-28UHC-66350-7481854492607326 Highland Ave, Tempe, AZ, 852430.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407374CLMSantiago Elliott1989-06-01—70820621975848 Elm St, Orlando, FL, 328320.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402764CLMFrank Ramirez1947-10-18UHC-29023-3582852379233119 Camelback Rd, Tampa, FL, 336450.64Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more
CLM-408762CLMJeff Ortiz1986-10-08UHC-55126-776715436453—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedEmail lower-cased+2 more
CLM-410281CLMDonald Bennett1977-02-28UHC-07240-3490896968222493 Elm St, Fresno, CA, 937020.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-402359CLMPhilip O Morgan1939-11-19——5281 River Rd, Minneapolis, MN, 554320.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-431104CLMKathryn Garza1950-12-02UHC-35299-1670028354043592 Park Pl, Chandler, AZ, 852090.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-427263CLMRob Singh1975-01-16UHC-01396-3722986203436850 Baseline Rd, Nashville, TN, 372610.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-430211CLMAlan Gilbert1965-01-14——7071 Union St, Columbus, OH, 432980.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423041CLMRandy Reid1997-10-25UHC-02401-36—6483 Highland Ave Apt 9, Austin, TX, 787200.64Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420435CLMBrenda Adaams1953-06-22UHC-68921-36—2980 Washington St, Charlotte, NC, 282730.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-401148CLMVictoria I Wilson1951-06-12—9346631750—0.64Name re-casedTwo-digit birth yearPhone reformattedGender normalised+2 more
CLM-402882CLMGloria Flores1949-06-18—7023135329700 Willow Ct, Chandler, AZ, 852220.64Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+2 more
CLM-422729CLMBenjamin V Fuller1964-03-15UHC-11971-67—4702 Spring St, Nashville, TN, 372370.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-432589CLMAmy Ortega2000-08-14UHC-71099-7465241277489469 Main St, Houston, TX, 770790.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411176CLMBetty Wheeeler2002-10-15UHC-47951-04—2733 Church St, Charlotte, NC, 282880.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-400507CLMWill M Ferguson1965-09-19UHC-03740-18481211040029 Market St, Austin, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-431793CLMAnthony Ortiz1962-11-28——3514 Sage Ct, Austin, TX, 787580.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426521CLMKelly Robinson1981-07-19UHC-76289-7992450589857506 Cedar Ln, Orlando, FL, 328830.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-407153CLMRussell Dunn2006-05-24UHC-33552-97—2113 Spring St, Minneapolis, MN, 554940.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400705CLMBrian Mitchell1995-06-11—4789224164351 Oak St, Chandler, AZ, 852540.64Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-410038CLMJoan Y Clark1967-11-09UHC-92120-58—3163 Grand Ave, Atlanta, GA, 303080.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-419205CLMCharlotte Burns1970-12-25—46641509921008 River Rd, Glendale, AZ, 853680.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426492CLMAmanda McDonald1961-09-28UHC-80724-5630748637896337 Apache Blvd, Miami, FL, 331780.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426493CLMAmanda McDonald1961-09-28UHC-80724-5630748637896337 Apache Blvd, Miami, FL, 331780.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-426388CLMJudy Delgado2005-03-05UHC-10925-71—9895 Jefferson Ave, Los Angeles, CA, 900530.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-427037CLMKyle Cuok—UHC-80562-1994721634958422 Hillcrest Rd, Tampa, FL, 336710.64Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406036CLMLrry Barnes1958-04-09——2481 Mesa Dr, San Antonio, TX, 782070.64SSN last four extractedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-406037CLMLrry Barnes1958-04-09——2481 Mesa Dr, San Antonio, TX, 782070.64SSN last four extractedStreet suffix standardisedAddress re-casedPlan code upper-cased+2 more
CLM-417502CLMJustin Reyes———4889 Spring St, Glendale, AZ, 853370.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-428628CLMKenneth Brooks1945-07-27—32152937173545 Lincoln Way, Denver, CO, 802780.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-420984CLMEmily B Owens2002-03-03—32625640188088 Lake View Rd, Tampa, FL, 336570.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407506CLMDaniel Le1973-04-26—22532703647309 Oak St, Tucson, AZ, 857820.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-422764CLMFatima U Alvarado—UHC-94101-36—2711 Desert Sky Blvd, Chandler, AZ, 852770.64Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409730CLMHelen Wrd1998-10-21UHC-75310-08—1861 Jefferson Ave, Charlotte, NC, 282400.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421411CLMPhilip Rodriguez1939-08-18UHC-28391-7827177912054856 Desert Sky Blvd Apt 18, Atlanta, GA, 303340.64Name re-casedPhone reformattedSSN last four extractedUnit split from street+2 more
CLM-415368CLMDaniel Warren2007-05-06——6802 Camelback Rd, Tucson, AZ, 857870.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-415774CLMCarlos D Aguilar1938-04-25——9373 Maple Ave, Nashville, TN, 372500.64Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
CLM-425588CLMDouglas Edwards1962-05-28UHC-96258-7266762983036463 Palm Dr, Denver, CO, 802460.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-421419CLMJeen Jones1941-09-09UHC-18287-0996423546631357 Union St, Tempe, AZ0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416561CLMPriya Ellis1996-01-11UHC-47259-0991942132687290 Lake View Rd, Miami, FL, 331310.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416382CLMGrace Soto1948-12-28UHC-03021-42—3732 Highland Ave, Scottsdale, AZ, 852060.64Name re-casedState name converted to codeGender normalisedPlan code upper-cased+2 more
CLM-409010CLMJennifer Scott1999-04-26——4552 Apache Blvd, Plano, TX, 750060.64Name re-casedDate of birth reformattedPhone missing area codeZIP+4 trimmed+2 more
CLM-407663CLMShirley Dean1993-10-19UHC-15898-83—3967 Mesa Dr, Miami, FL, 331400.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-403148CLMMargaret James1943-09-04——831 Grand Ave Apt 13, Tempe, AZ, 852400.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430560CLMGeorge Estrada1989-06-18—22350029193618 Canyon Rd Apt 12, Atlanta, GA, 303000.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-422053CLMAlan P Perry1958-11-22UHC-67699-5424373544745216 Desert Sky Blvd, Austin, TX, 787390.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-406795CLMGloria Estrada1945-01-03—91593946959236 Spring St, Houston, TX, 770130.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
32,829 rows, page 126 of 657PreviousNext