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-425873CLMJudy Rogers1984-01-17——1643 Bayshore Dr, Plano, TX, 750480.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-417225CLMSean Nguyen2004-05-04UHC-10988-10—3327 Mesa Dr, Miami, FL, 331660.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-413016CLMGabriel Dominguez1961-06-01UHC-64727-3625662514823778 Spring St # 849, Scottsdale, AZ, 852820.68Unit split from streetCity re-casedGender normalisedPlaceholder values cleared
CLM-429293CLMEthan Ruiz1968-03-27——9415 Willow Ct, Gilbert, AZ, 852150.68Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased
CLM-425211CLMAndrea Q Hudon—UHC-74064-92—2166 Lake View Rd, Los Angeles, CA, 900670.68Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased
CLM-424653CLMDebra Mendez1960-06-24UHC-40056-84—1756 Cedar Ln, Glendale, AZ, 853420.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-413098CLMWayne Stewart1958-11-25UHC-01428-01—6154 Indian School Rd, Scottsdale, AZ, 852880.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-401175CLMEmma Vasquez1986-08-05——1098 Market St, Dallas, TX, 752490.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-403153CLMPatrick Carter1994-02-05——6994 Cedar Ln, Miami, FL0.68Name split from “Last, First”City re-casedZIP missingPlaceholder values cleared
CLM-405975CLMZachary Romero1987-08-21UHC-63280-47—7869 Camelback Rd, Sacramento, CA, 958330.68Name split from “Last, First”State name converted to codeWhitespace trimmedPlaceholder values cleared
CLM-428622CLMMartha B Washington2001-09-04UHC-25585-33—8987 Grand Ave, Denver, CO, 802000.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-404502CLMKathy Sandoval1962-05-14UHC-84252-16—5904 Central Ave, Tempe, AZ, 852420.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-426992CLMMartha Jenkins1986-01-15——8650 Apache Blvd, Sacramento, CA, 958210.68State name converted to codeZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-419983CLMJozeph Carroll1970-10-05UHC-92686-44—319 Jefferson Ave, Fresno, CA, 937890.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-421381CLMBekky Murray2002-09-21—50555456876746 Lake View Rd, San Antonio, TX, 782730.68Name re-casedStreet suffix standardisedAddress re-casedGender normalised
CLM-401730CLMYuki Brown1968-10-15——6134 Canyon Rd, Austin, TX, 787080.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-422019CLMCynthia Kelley1951-10-26—33555132452490 Meadow Ln Apt 28, Sacramento, CA0.68Phone reformattedUnit split from streetZIP missingPlaceholder values cleared
CLM-427875CLMMaria Palmer1972-06-09UHC-45838-69—9185 Highland Ave, Las Vegas, NV, 891660.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-401602CLMDouglas Carr—UHC-34967-07—8779 Highland Ave, Phoenix, AZ, 850200.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-432535CLMAndrew Barnes1971-12-07UHC-77094-40—2579 Baseline Rd, Los Angeles, CA, 900030.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412969CLMHeather Pierce1976-03-11UHC-29304-05—1540 Maple Ave, San Antonio, TX, 782530.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-404294CLMCarlos Gray1941-08-12UHC-64484-7372863151968227 Grand Ave, San Diego, CA, 921460.68Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased
CLM-400936CLMBrenda Weaver1950-07-25UHC-49595-3895964603105530 Grand Ave, Tampa, FL, 336170.68Two-digit birth yearStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-416811CLMAnthony Jackson1996-11-11UHC-47435-53—7175 Mesa Dr, Dallas, TX, 752630.68Phone missing area codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-406025CLMJesse Fields1948-04-01—2475310915829 Central Ave, Dallas, TX, 752880.68Name re-casedStreet suffix standardisedAddress re-casedState name converted to code
CLM-429296CLMAdam Murray1965-11-04UHC-44804-057455147526474 Pine Dr, Columbus, OH, 432420.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-405710CLMZachary D Thompson1973-11-22UHC-15871-31—1881 Ridge Rd, Scottsdale, AZ, 852130.68Name re-casedTwo-digit birth yearGender normalisedPlaceholder values cleared
CLM-416167CLMPriya Gonzalz1965-07-20UHC-98742-51—12 Main St, Mesa, AZ0.68Name split from “Last, First”ZIP missingWhitespace trimmedPlaceholder values cleared
CLM-417838CLMAutsin Henry2004-05-03UHC-64407-01——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421861CLMJudith Murray—UHC-15847-88—235 Main St # 245, Columbus, OH, 432890.68Date of birth unreadableUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-412854CLMAisha McCoy1988-10-09——5542 River Rd # 636, Atlanta, GA, 303150.68Unit split from streetCity re-casedZIP+4 trimmedPlaceholder values cleared
CLM-427727CLMAlexander Q Smth1958-09-25UHC-06478-925583827401—0.68Two-digit birth yearPhone reformattedGender normalisedPlaceholder values cleared
CLM-400319CLMAnthony K Armstrong1939-07-20——5629 Harbor Blvd, Houston, TX, 770550.68Name split from “Last, First”Date of birth reformattedState name converted to codePlaceholder values cleared
CLM-403406CLMMariana Webb1960-07-07—95623589509040 Canyon Rd, Houston, TX, 770260.68Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised
CLM-429670CLMWayne Ortiz2005-03-01UHC-34770-98—8399 Grand Ave, Atlanta, GA, 303900.68Name split from “Last, First”ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-405171CLMJanice Robertson2007-08-28UHC-69570-52—8290 Broadway, Charlotte, NC, 282240.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-422420CLMJustin Franklin1940-06-22UHC-07882-41—5435 Palm Dr # 459, Columbus, OH, 432350.68Name re-casedTwo-digit birth yearUnit split from streetPlaceholder values cleared
CLM-405091CLMPJunk1988-02-22UHC-75396-89—4740 Forest Ave, Sacramento, CA0.68ZIP missingWhitespace trimmedPlaceholder values clearedNo usable name (quarantined)
CLM-420005CLMAngela Sims2005-08-22———0.68Name split from “Last, First”Two-digit birth yearWhitespace trimmedPlaceholder values cleared
CLM-404407CLMAlice Morris1995-06-09UHC-55977-01—9349 Ocean Ave, Chandler, AZ, 852640.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-418263CLMZachary Montgomery—UHC-85166-96—8393 Ocean Ave, Glendale, AZ, 853920.68Date of birth unreadableSSN last four extractedWhitespace trimmedPlaceholder values cleared
CLM-408746CLMGerald Rose1982-08-05——7637 Forest Ave, Mesa, AZ, 852830.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-429779CLMElizabeth Grent1975-08-09—97762314977355 Palm Dr Apt 34, Sacramento, CA, 958820.68Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-412834CLMWilliam Black1967-03-21——5405 Sunset Blvd Apt 11, Jacksonville, FL, 322430.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-425755CLMDouglas Q Murphy1972-01-12UHC-39901-92—1082 Pine Dr, Orlando, FL, 328960.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-422869CLMEugene Anderson1963-08-20UHC-70469-53—7952 Union St, Chandler, AZ, 852510.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-411107CLMCarol D Thumas1955-07-27UHC-25221-325184709440621 Apache Blvd Apt 36, San Diego, CA, 921130.68Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased
CLM-419747CLMTyler Grant1949-11-28UHC-48953-93—3984 Harbor Blvd, Charlotte, NC, 282890.68SSN last four extractedStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404134CLMMaria T Dunn1964-08-17UHC-04782-32—3948 Hillcrest Rd, Fresno, CA, 937720.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404755CLMJason Boyd1989-11-16—39060715018446 Jefferson Ave, Tampa, FL, 336240.68Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed
32,829 rows, page 205 of 657PreviousNext