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-418419CLMHenry S Wells1938-11-01UHC-53311-49—539 Lincoln Way, Plano, TX, 750920.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-414365CLMFrank C Garrett1994-06-20——9348 Mesa Dr, Charlotte, NC0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-406482CLMLogan Powell1961-06-22——9821 Cedar Ln, Sacramento, CA, 958450.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-417006CLMMadison Taylor1957-06-12UHC-49436-3288177844554368 Sage Ct # 282, Sacramento, CA0.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418585CLMChristian Chavez1996-01-20UHC-18389-7350379203667834 Oak St # 917, Seattle, WA, 981130.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418584CLMChristian Chavez1996-01-20UHC-18389-7350379203667834 Oak St # 917, Seattle, WA, 981130.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419741CLMBeverly Young1994-03-25UHC-66215-27—2556 Sunset Blvd, Minneapolis, MN, 554920.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-400156CLMHarold Bursn1974-12-10——8011 Ocean Ave, Miami, FL, 331500.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-405812CLMTerry James1977-02-05UHC-30688-05—851 Grand Ave, Denver, CO0.52Two-digit birth yearZIP missingGender normalisedPlan code upper-cased+2 more
CLM-429033CLMIsabella McDonald1965-02-03UHC-42587-12—4192 Willow Ct, Orlando, FL, 328160.52Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+2 more
CLM-413545CLMKelly Kelly1943-06-14——8272 Oak St Apt 15, Seattle, WA, 981580.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400056CLMSamantha Young1990-04-28—36074517385157 Harbor Blvd, San Antonio, TX, 782310.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-411481CLMSarah W Olson2000-06-19UHC-48451-84—5496 River Rd, Seattle, WA0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-419985CLMMegan G Richards2007-12-04——5739 Oak St, Tempe, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-425953CLMKathleen A Gonzalez1977-04-13UHC-75427-62—5316 Spring St, Charlotte, NC, 282910.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401863CLMEmily Warren1996-07-11UHC-27010-24—2811 Central Ave, Austin, TX0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-402762CLMKathleen Medina1942-08-15UHC-06034-54—1063 Desert Sky Blvd, Glendale, AZ, 853490.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-417803CLMCheryl Butler1972-02-27——7407 Ocean Ave, Atlanta, GA, 303200.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-422560CLMLarry Foster1965-06-28——4669 Sunset Blvd, Tucson, AZ, 857330.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-423652CLMDavid A Long1966-04-07UHC-02750-47—5155 Maple Ave, Chandler, AZ, 852400.52Middle initial moved out of first nameTwo-digit birth yearZIP+4 trimmedEmail lower-cased+2 more
CLM-432503CLMEvelyn Wright1986-04-13UHC-14032-27—7919 Harbor Blvd, Jacksonville, FL, 322360.52Two-digit birth yearPhone missing area codeCity re-casedState name converted to code+2 more
CLM-416531CLMFrances Black1973-01-08—76536437138621 Camelback Rd, Plano, TX, 750280.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-412822CLMBrandon Payne1981-10-08——3345 Apache Blvd, Seattle, WA, 981080.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400538CLMMatt Lawson1995-05-15UHC-09130-1261870710934892 Pine Dr # 147, Mesa, AZ, 852480.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-401834CLMVirginia Vazquez1995-03-27UHC-31745-21—1472 Willow Ct, Eden Prairie, MN0.52Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
CLM-405413CLMHannah Garrett—UHC-32176-42—478 Sunset Blvd, Minneapolis, MN0.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-427605CLMFrances Campbell1992-09-16UHC-98486-22456699213594 Washington St, Austin, TX, 787170.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-413975CLMMary Knight1939-11-27UHC-60578-16—6718 Valley View Dr, Atlanta, GA, 303820.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-405661CLMBrenda Harris1985-10-08UHC-30691-44—4126 Lake View Rd # 301, Plano, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-406545CLMBrian Y Nunez1966-01-09——8089 Sunset Blvd, Las Vegas, NV, 891660.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-413789CLMAlice Baker1952-04-16UHC-01066-48—2666 Church St, Gilbert, AZ0.52Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
CLM-416572CLMJake Hall2001-06-06UHC-90583-09—2618 Ridge Rd # 477, Phoenix, AZ, 850940.52Name split from “Last, First”Date of birth reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-422713CLMLarry Daniels———5621 Market St, Glendale, AZ, 853430.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-408844CLMMarilyn T Richards1995-06-26UHC-52260-31—2627 Church St Apt 15, Denver, CO, 802400.52Middle initial moved out of first nameUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-432784CLMMateo Simpson—UHC-48188-73—9683 Canyon Rd, Minneapolis, MN, 554090.52Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-414270CLMAlbert R Watson1984-01-26UHC-54144-2829240543348403 Sage Ct, Las Vegas, NV0.52Name re-casedTwo-digit birth yearPhone reformattedZIP missing+2 more
CLM-400742CLMCarolyn Hanson2008-08-09UHC-95340-585937236006300 Indian School Rd, Houston, TX, 770160.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-423004CLMJulia Schmidt1983-02-09——3498 Valley View Dr, Charlotte, NC, 282760.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
CLM-404784CLMStephen Li1994-06-25UHC-49292-64—9593 Harbor Blvd, Atlanta, GA, 303210.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-425786CLMDanielle Bradley1998-02-18——670 Pine Dr, Denver, CO, 802010.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430554CLMKathleen P Spencer1986-11-25UHC-15103-98—8175 Broadway, Charlotte, NC, 282010.52Middle initial moved out of first nameName re-casedState name converted to codeGender normalised+2 more
CLM-411319CLMBetty Rojas1976-12-27UHC-59588-79—3322 Hillcrest Rd, Sacramento, CA, 958310.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-410867CLMMegan Carpenter—UHC-78670-63—3675 Willow Ct, Nashville, TN, 372310.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416047CLMVirginia Harvey1957-05-13UHC-73952-53—5319 Indian School Rd # 324, Seattle, WA, 981010.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-419081CLMMargaret Parker1970-03-03——2902 Willow Ct, Fresno, CA0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
CLM-430922CLMBetty Perez1997-03-07UHC-12785-63—136 Mesa Dr, Minneapolis, MN, 554700.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-430003CLMPaul Hernandez1972-07-11UHC-62047-51—3778 Sage Ct, Chandler, AZ, 852860.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407266CLMJulia D George1959-01-27—46949812122430 Valley View Dr, Charlotte, NC0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405444CLMJason S Mills1948-12-08——1493 Sage Ct, Columbus, OH, 432030.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415068CLMDenise Richardson2002-10-07UHC-40221-43—6090 Spring St, Chandler, AZ, 852530.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
32,829 rows, page 49 of 657PreviousNext