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-403517CLMLuis Richards1960-12-26UHC-82338-954119719559810 Jefferson Ave # 824, Orlando, FL, 328590.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419433CLMSingh Jennifer1962-11-02UHC-83847-54—4343 River Rd, Minneapolis, MN, 554130.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-428960CLMYuki Vazquez1960-04-08UHC-48005-22—6603 Camelback Rd, Miami, FL, 331920.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-417000CLMDaniel X Jimenez1959-01-18——5471 Sage Ct, Eden Prairie, MN, 553400.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400327CLMRebecca F Little1942-01-15UHC-55146-08—7903 Desert Sky Blvd, Austin, TX, 787220.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413147CLMAnn McCoy1972-11-10UHC-89695-64—1589 Mesa Dr, Columbus, OH, 432350.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407782CLMMark Harper1987-01-24——6905 Ocean Ave, Seattle, WA, 981860.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-422195CLMLuis P Freeman1990-03-27UHC-20455-1429466187123146 Canyon Rd # 789, Gilbert, AZ, 852740.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-431461CLMJesse Bennett1940-12-16UHC-57219-2394883403923288 Forest Ave, Jacksonville, FL, 322010.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402988CLMJoan Masno1986-06-01—20266484123372 Hillcrest Rd, Gilbert, AZ, 852560.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-419687CLMDiego Nguyen1963-10-15UHC-76302-57—4782 Lake View Rd, Las Vegas, NV, 891850.64Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised+2 more
CLM-419567CLMBradley Patterson1990-01-05UHC-69031-53—859 Valley View Dr, Scottsdale, AZ, 852410.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-409086CLMKathryn Knight1952-12-09—60996506488540 Lake View Rd, Dallas, TX, 752380.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407667CLMKevin R Sott1977-09-05——4444 Willow Ct Apt 33, Nashville, TN, 372510.64Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+2 more
CLM-415482CLMCatherine Lawrnce1957-05-18—37070437299836 Canyon Rd Apt 22, Chandler, AZ, 852490.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-425192CLMKeith A Perez1944-10-15UHC-42466-0877065268001839 Indian School Rd # 109, Dallas, TX, 752620.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-422108CLMMegan Park1948-12-04——3187 Maple Ave, Seattle, WA, 981840.64Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-420866CLMSteephen Harrison1955-03-22UHC-14162-8537528473389547 Indian School Rd, San Antonio, TX, 782260.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-401658CLMFatima T Taylor1979-11-28——9519 Desert Sky Blvd, San Antonio, TX, 782830.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-431884CLMGoria Richardson—UHC-52235-63—1011 Indian School Rd, Tempe, AZ, 852270.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-401363CLMCheryl Chen1997-10-27—32133107973073 Park Pl, Plano, TX, 750930.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418338CLMDorothy Griffin—UHC-53734-03—3855 Spring St, Orlando, FL, 328860.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-418337CLMDorothy Griffin—UHC-53734-03—3855 Spring St, Orlando, FL, 328860.64Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
CLM-422763CLMOmar Freeman1968-07-21UHC-21072-58—6603 Highland Ave, Seattle, WA, 981780.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-414553CLMGrace Stone1991-10-07UHC-67144-84—8990 Elm St, San Antonio, TX, 782480.64Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-409666CLMBarb Hansen1980-06-28UHC-50547-71—8572 Bayshore Dr, Dallas, TX, 752180.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-430842CLMKatherine Gonzalez———3627 Highland Ave, Tampa, FL, 336370.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-425541CLMJason Rose1967-10-22UHC-44955-22—4069 Pine Dr, Mesa, AZ0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-413698CLMKlely Perez1990-08-15UHC-12316-2922770781621759 Mountain View Dr, Los Angeles, CA, 900000.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-404209CLMKatherine D Robinson1975-05-01UHC-61326-69—7828 Church St, Plano, TX, 750870.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-413368CLMRachel Marshall1988-03-07—72390510218677 Washington St # 697, Gilbert, AZ, 852140.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-426532CLMRalph Armstrong1957-02-11——7059 Desert Sky Blvd, Glendale, AZ, 853670.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-416605CLMAbigail Palmer2007-09-23UHC-54190-01—5914 Palm Dr, Dallas, TX, 752350.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406490CLMRalph Nguyen1958-05-12—71846334522076 Lake View Rd, Scottsdale, AZ, 852160.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401444CLMSusan Andrews1986-06-20UHC-26506-2497849890228184 Spring St, Austin, TX0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-409985CLMDanielle Parker1944-05-13——8373 Church St, Tampa, FL, 336910.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
CLM-430270CLMAnna Knight1952-02-05UHC-17139-80—523 Valley View Dr, Sacramento, CA, 958660.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-429547CLMJacob C Coleman1952-08-26——7965 Palm Dr Apt 38, Jacksonville, FL, 322680.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413310CLMMaria P Dean2007-10-07——6450 Lincoln Way, Tempe, AZ, 852960.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-414212CLMZachary Aguialr1985-09-04—66258721879862 Palm Dr, San Diego, CA, 921890.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418464CLMBetty Z Gilbert2008-10-14UHC-74971-3356630131269021 Broadway Apt 16, Phoenix, AZ, 850050.64Name re-casedDate of birth reformattedUnit split from streetAddress re-cased+2 more
CLM-427515CLMCatherine Chen1914-03-06UHC-58328-78—3233 Sunset Blvd, Plano, TX, 750410.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-407760CLMPaul P Ortega1951-04-19—79298313437282 Cedar Ln, Los Angeles, CA, 900330.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406017CLMDeborah Riley2002-05-03—37467566146318 Palm Dr, Glendale, AZ, 853380.64Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-424315CLMMichelle Luna2005-10-19UHC-78389-7372332442386521 Spring St, Columbus, OH, 432990.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-402935CLMJames Reid2008-10-13UHC-04022-72—5685 Sage Ct Apt 13, Scottsdale, AZ, 852690.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-402396CLMBrittany S Watkins1940-07-23UHC-36211-475227907510642 Sage Ct, Chandler, AZ, 852800.64Phone reformattedMember ID reformattedZIP+4 trimmedGender normalised+2 more
CLM-421759CLMIsabella Kennedy1951-08-10—40523665272989 Ridge Rd, Chandler, AZ, 852170.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-421473CLMCheryl Knight—UHC-48893-14—7882 Lake View Rd, San Diego, CA, 921280.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-427502CLMVincent Bishop1981-04-20UHC-95571-57—2787 Sage Ct, Austin, TX0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
32,829 rows, page 111 of 657PreviousNext