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-420653CLMJacob Z Carpenter—UHC-24720-46—5511 Mountain View Dr, Tempe, AZ0.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-409599CLMDebra J Olson1973-11-04—62472237648781 Indian School Rd, Orlando, FL, 328280.42Name split from “Last, First”Two-digit birth yearZIP+4 trimmedGender normalised+1 more
CLM-415699CLMJudy Burns1980-12-09——3367 Maple Ave Apt 35, Seattle, WA, 981090.42Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-404291CLMCarlos Gray1941-08-12UHC-64484-7372863151968227 Grand Ave, San Diego, CA, 921460.42Name split from “Last, First”SSN last four extractedState name converted to codeZIP+4 trimmed+1 more
CLM-405164CLMBian Fernandez1989-07-08UHC-94270-72—7051 Lincoln Way # 655, Orlando, FL0.42Phone missing area codeUnit split from streetZIP missingGender normalised+1 more
CLM-406926CLMJose K Medina—UHC-85752-84—4922 Sunset Blvd, San Diego, CA, 921100.42Name split from “Last, First”Date of birth missingZIP+4 trimmedGender normalised+1 more
CLM-428685CLMCynthia V Fuller1974-01-03——2479 Park Pl Apt 3, Charlotte, NC, 282990.42Name split from “Last, First”Unit split from streetZIP+4 trimmedGender normalised+1 more
CLM-413189CLMSophia Estrada1992-09-22UHC-67827-54—2462 Elm St, Tucson, AZ, 857790.42Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-412922CLMLucia Little2008-01-04UHC-70129-2595421856455507 Mesa Dr, Miami, FL, 331150.42Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-426209CLMZachary Schultz1966-05-06UHC-17530-09—9272 River Rd, Seattle, WA, 981700.42Name split from “Last, First”State name converted to codeZIP+4 trimmedGender normalised+1 more
CLM-431824CLMTyler D Garza1981-11-03UHC-04182-51—4587 Maple Ave # 722, San Antonio, TX, 782070.44Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+6 more
CLM-425458CLMEdward Reyes2004-09-24UHC-07461-95—8191 Pine Dr Apt 7, Denver, CO, 802040.44Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+6 more
CLM-408907CLMGerald Maldonado1995-11-12UHC-91427-57—1415 Indian School Rd, Las Vegas, NV, 891110.44Name re-casedDate of birth reformattedMember ID reformattedSSN last four extracted+6 more
CLM-402488CLMSusan Bell1980-04-10UHC-59959-1926589958026313 Jefferson Ave, Los Angeles, CA, 900230.44Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
CLM-425779CLMMark Long1976-08-26UHC-50062-613155420342365 Camelback Rd # 468, Seattle, WA, 981710.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-420844CLMJacob Jensen1942-01-19UHC-74692-4142373266495608 Meadow Ln, Denver, CO0.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-406009CLMGerald Richardson1957-04-11UHC-52791-3529988256601747 Sage Ct # 324, Gilbert, AZ, 852540.44Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more
CLM-412268CLMDavid W Hansen2004-02-20UHC-62023-7683235979138251 Apache Blvd, Jacksonville, FL, 322550.44Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+6 more
CLM-423639CLMEugene Morales1976-03-11UHC-18419-7055599341767390 Bayshore Dr Apt 30, Austin, TX, 787660.44Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more
CLM-413217CLMMark F Maldonado1990-06-11UHC-07588-915335139184925 Central Ave, Eden Prairie, MN, 553250.44Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+6 more
CLM-415276CLMCamila Brown1951-11-17UHC-87174-4960998035563113 Forest Ave, Orlando, FL, 328320.44Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+6 more
CLM-432054CLMAmy H Gilbert1973-11-04UHC-06665-7156536316054705 Mountain View Dr Apt 18, San Antonio, TX, 782290.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-400712CLMStephen Murphy1955-10-14UHC-00291-4368372026019309 Ridge Rd, Nashville, TN0.44Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more
CLM-417084CLMRussell Matthews1964-12-28UHC-68793-97—8711 Union St Apt 5, San Antonio, TX, 782450.44Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+6 more
CLM-413656CLMAmy Sandoval1978-01-28UHC-15452-4848820548747809 Sunset Blvd, Charlotte, NC0.44Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
CLM-409594CLMIsabella Parker1955-02-11UHC-22975-4138031554983506 Grand Ave, Glendale, AZ0.44Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more
CLM-406806CLMPatty Hart1974-05-14—28882723926473 Jefferson Ave, Phoenix, AZ0.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-410506CLMJoyce Roberts2007-01-12UHC-91571-6033770748402751 Jefferson Ave, Los Angeles, CA, 900460.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-406590CLMMateo Castro1969-09-04—61025965818933 Bayshore Dr, Mesa, AZ, 852780.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-422843CLMKathleen Alvarado2006-09-04UHC-63954-8991079865331905 Sage Ct, Columbus, OH, 432260.46Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+5 more
CLM-400939CLMRoger Clark1985-04-20—74851587321018 Grand Ave # 590, Nashville, TN, 372210.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-419121CLMJake Espinoza1942-06-20UHC-07841-7757048382082984 Desert Sky Blvd # 755, Tempe, AZ0.46Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+5 more
CLM-419178CLMJordan P Flores1964-08-10—80371338068436 Jefferson Ave, Tempe, AZ, 852300.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-426877CLMAlexander Estrada2004-12-02UHC-81386-3684356918032506 Indian School Rd, Houston, TX, 770360.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-420211CLMDenise Berry1943-01-02UHC-93903-6170399311596018 Maple Ave, Nashville, TN0.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
CLM-411775CLMEric Elliott1950-09-19—37739313276054 Forest Ave Apt 37, Las Vegas, NV, 891460.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-408173CLMKenneth Kellly1966-06-27UHC-11325-9448958813996640 Indian School Rd # 198, Tucson, AZ, 857220.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-409127CLMRobert Pierce1988-03-04—24437130213041 Hillcrest Rd, Houston, TX, 770720.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-426990CLMMartah P Jenkins—UHC-38108-7329447690828650 Apache Blvd Apt 4, Sacramento, CA, 958210.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
CLM-408088CLMKathryn Perry1971-07-27UHC-90777-0576949111174230 Pine Dr, Atlanta, GA0.46Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-425287CLMAna A Banks1964-10-09—62179605332552 Union St, Houston, TX, 770450.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-419750CLMGerald Maldonado1946-04-17——3295 Pine Dr # 915, Charlotte, NC0.46Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
CLM-404575CLMJudith Carroll1939-03-06UHC-51003-0122025383589103 Church St, Phoenix, AZ, 850750.46Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-409318CLM—Junk2003-09-10UHC-74908-5051994996513540 Forest Ave, Mesa, AZ, 852320.46Date of birth reformattedPhone reformattedCity re-casedState name converted to code+5 more
CLM-407790CLMJonathan O Maldonado2002-06-14UHC-46045-0992031302657897 Highland Ave, Scottsdale, AZ, 852210.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-406712CLMJessica Johnson1979-10-05——222 Harbor Blvd, Las Vegas, NV, 891220.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-421829CLMSamantha West1987-11-13—98495281503597 Elm St, Las Vegas, NV0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
CLM-422533CLMJoan Harvey1994-03-15UHC-56570-62—2921 Forest Ave # 116, Tampa, FL, 336440.46Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
CLM-401059CLMCharles Hunter1989-06-08—52387368585023 Elm St Apt 17, Tempe, AZ, 852670.46Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
CLM-417561CLMMarcus J Allvarado1949-06-12UHC-99938-50—53 Union St, San Antonio, TX, 782720.46Middle initial moved out of first nameName re-casedDate of birth reformattedStreet suffix standardised+5 more
32,829 rows, page 11 of 657PreviousNext