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

AllENRCLMTPAPRV
Junk only
RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-413416CLMBobby Miller1995-01-10UHC-03506-5337131432403637 Harbor Blvd, Tucson, AZ, 857590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-431114CLMDavid V Armstrong2003-07-06UHC-36225-03—6241 Hillcrest Rd # 245, Glendale, AZ, 853690.68Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared
CLM-405137CLMBobby Rios1940-05-27UHC-55415-79—4383 Apache Blvd, Houston, TX, 770830.68ZIP+4 trimmedEmail lower-casedGender normalisedPlaceholder values cleared
CLM-422075CLMTerry Lawson1974-04-04UHC-03302-69—3688 Hillcrest Rd, Eden Prairie, MN, 553830.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-430150CLMSamantha Howard1955-11-11UHC-54388-27—7572 Cedar Ln, Gilbert, AZ, 852800.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-422820CLMJonathan H Johnston1977-03-04UHC-00925-87—3559 Meadow Ln Apt 5, Orlando, FL, 328330.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412048CLMLarry Lawson1976-03-23——4261 Apache Blvd, Phoenix, AZ, 850630.68Name re-casedTwo-digit birth yearZIP+4 trimmedPlaceholder values cleared
CLM-416041CLMKathryn A Hayes1971-09-11——9284 Cedar Ln, Jacksonville, FL, 322610.68Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed
CLM-430411CLMBradley F Larson1960-11-16——9556 Maple Ave # 206, Phoenix, AZ, 850570.68Unit split from streetZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
CLM-430679CLMCamila A Castillo2000-07-24UHC-26142-58—7096 Central Ave Apt 10, Tampa, FL, 336140.68Member ID reformattedUnit split from streetGender normalisedPlaceholder values cleared
CLM-404843CLMYuki Nguyen1955-01-22——1631 Jefferson Ave Apt 28, Orlando, FL0.68Unit split from streetZIP missingWhitespace trimmedPlaceholder values cleared
CLM-421565CLMJulie M Singh1975-08-19UHC-47477-34—4749 Maple Ave # 384, Fresno, CA, 937210.68Name re-casedUnit split from streetState name converted to codePlaceholder values cleared
CLM-410880CLMAbigail Gray1998-07-12———0.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421925CLMBrenda Henry1982-05-17UHC-49567-69—62 Ridge Rd, Los Angeles, CA, 900690.68Name re-casedTwo-digit birth yearPhone missing area codePlaceholder values cleared
CLM-428176CLMGreg Rosse—UHC-54198-54——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-428175CLMGreg Rosse—UHC-54198-54——0.68Date of birth unreadableGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-410737CLMCarol Banks1999-02-17UHC-53162-5862829000927354 Mesa Dr, Scottsdale, AZ, 852530.68Name split from “Last, First”Two-digit birth yearPhone reformattedPlaceholder values cleared
CLM-419710CLMAbigail Arnnold1943-01-12—7187396828—0.68Name split from “Last, First”Phone reformattedGender normalisedPlaceholder values cleared
CLM-430719CLMEugene Reyes1966-05-18UHC-92197-11——0.68Name split from “Last, First”Gender normalisedWhitespace trimmedPlaceholder values cleared
CLM-403163CLMAmanda Fox1992-11-01UHC-00623-39—324 Highland Ave, Eden Prairie, MN, 553320.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-428575CLMNicholas L Tran2001-02-15——4942 Hillcrest Rd, Austin, TX, 787700.68Name re-casedZIP+4 trimmedGender normalisedPlaceholder values cleared
CLM-402763CLMJacob Evans—UHC-30782-04—2290 Spring St, Jacksonville, FL, 322440.68Date of birth missingGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-428441CLMTeresa Spencer1995-05-10UHC-23682-43—5215 Grand Ave, San Diego, CA, 921200.68ZIP+4 trimmedGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-410124CLMAbigail Hicks1970-08-17UHC-60211-80—5753 Union St, Miami, FL, 331050.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-421914CLMHelen Mills—UHC-72226-5669193391848254 Cedar Ln Apt 27, San Diego, CA, 921270.68Date of birth unreadablePhone reformattedUnit split from streetWhitespace trimmed
CLM-431801CLMAnn Alvarado1984-07-11——4414 Harbor Blvd, San Diego, CA, 921230.68Street suffix standardisedAddress re-casedGender normalisedPlaceholder values cleared
CLM-422310CLMOmer Myerrs1982-12-01——7679 Maple Ave, Orlando, FL, 328650.68Street suffix standardisedAddress re-casedZIP+4 trimmedPlaceholder values cleared
CLM-413587CLMWhie Melissa2000-05-10UHC-48799-02——0.68Name split from “Last, First”SSN last four extractedWhitespace trimmedPlaceholder values cleared
CLM-402637CLMJulia Nguyen1941-11-07UHC-90442-51—5856 River Rd, Plano, TX, 750850.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-417183CLMAlbert Schultz1939-12-06UHC-79247-71—8850 Hillcrest Rd, Columbus, OH, 432190.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-408092CLMWilliam Weaver2005-10-15UHC-50237-81—8974 Indian School Rd # 663, Atlanta, GA, 303550.68Date of birth reformattedPhone missing area codeUnit split from streetPlaceholder values cleared
CLM-418099CLMDenise Ortega1956-02-19UHC-05763-13—9540 Broadway, Dallas, TX, 752440.68State name converted to codeGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-402680CLMCharlotte Shaw—UHC-98731-47——0.68Name split from “Last, First”Date of birth missingWhitespace trimmedPlaceholder values cleared
CLM-401108CLMKathryn Holmes1939-02-10UHC-21580-23—1223 Canyon Rd, Austin, TX, 787170.68Two-digit birth yearCity re-casedGender normalisedPlaceholder values cleared
CLM-406703CLMLaura Murray1945-05-02—33240671825256 Cedar Ln, Austin, TX, 787230.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-426311CLMCynthia Robinson—UHC-25770-44—1360 Meadow Ln, Houston, TX, 770370.68Date of birth unreadableStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-409232CLMOlivia Ramos1998-07-18UHC-74736-34—6004 Harbor Blvd, Los Angeles, CA, 900460.68Name re-casedTwo-digit birth yearState name converted to codePlaceholder values cleared
CLM-430057CLMChristine Phillips1989-02-18UHC-86842-73—3969 Hillcrest Rd, Gilbert, AZ0.68Name re-casedTwo-digit birth yearZIP missingPlaceholder values cleared
CLM-413315CLMPaul Garza1996-02-09UHC-07864-19——0.68Name re-casedTwo-digit birth yearSSN last four extractedPlaceholder values cleared
CLM-401208CLMAna Knigth1991-03-25——3627 Lincoln Way # 531, Gilbert, AZ, 852360.68Name re-casedTwo-digit birth yearUnit split from streetWhitespace trimmed
CLM-429858CLMNoah A Tucker1993-06-02UHC-19864-11—2659 Park Pl, Columbus, OH, 432190.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-422403CLMAbigail L Soto1953-03-27UHC-46807-97—3268 Lake View Rd, Mesa, AZ, 852520.68Two-digit birth yearGender normalisedWhitespace trimmedPlaceholder values cleared
CLM-425648CLMNataalie P Ryan1965-04-26UHC-61600-45—6981 Pine Dr, Los Angeles, CA, 900590.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-412403CLMEric Jones1944-01-24UHC-34203-06—8255 Apache Blvd Apt 6, Minneapolis, MN, 554930.68Member ID reformattedUnit split from streetZIP+4 trimmedPlaceholder values cleared
CLM-424893CLMCarl Campbell1955-01-05——515 Canyon Rd, Sacramento, CA, 958700.68Name split from “Last, First”Street suffix standardisedAddress re-casedPlaceholder values cleared
CLM-401985CLMStephanie W Berry1945-05-06UHC-73453-17—7425 Main St Apt 3, Tucson, AZ, 857480.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
CLM-404815CLMBobby Rivera—UHC-50386-34—6527 Washington St, Scottsdale, AZ, 852360.68Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed
CLM-405394CLMRebecca Austin1983-03-26UHC-39143-1133326784142519 Spring St, Atlanta, GA, 303540.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-405395CLMRebecca Austin1983-03-26UHC-39143-1133326784142519 Spring St, Atlanta, GA, 303540.68Street suffix standardisedAddress re-casedState name converted to codePlaceholder values cleared
CLM-418932CLMJesse Wallace2006-06-01UHC-53717-54—6051 River Rd # 200, San Diego, CA, 921820.68Unit split from streetStreet suffix standardisedAddress re-casedPlaceholder values cleared
32,829 rows, page 217 of 657PreviousNext