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-420178CLMDonald B Vazquez1967-07-25UHC-46967-7081358085793799 Indian School Rd # 240, Miami, FL, 331550.64Two-digit birth yearPhone reformattedUnit split from streetCity re-cased+2 more
CLM-406790CLMJacqueline Burke1994-12-08—6827859387904 Baseline Rd, Tucson, AZ, 857020.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-412581CLMShirley Sanchez1948-12-12UHC-11667-88—5839 Apache Blvd, Fresno, CA, 937400.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-425461CLMWillie Sulllivan2005-02-28UHC-03086-90—5956 Central Ave, Las Vegas, NV0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-425460CLMWillie Sulllivan2005-02-28UHC-03086-90—5956 Central Ave, Las Vegas, NV0.64Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
CLM-431342CLMKayla Broosk1994-05-18—27798183874646 Camelback Rd, Seattle, WA0.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-411570CLMWei Crawford1994-12-28UHC-41748-216694884393744 Grand Ave, Minneapolis, MN, 554280.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-429295CLMValentina Singh1955-11-26——4496 Union St, Dallas, TX, 752950.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-414411CLMWalter Andrews1962-06-20UHC-25990-6497259504227531 Ocean Ave Apt 34, Phoenix, AZ, 850840.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-418444CLMPriya Reyes1960-06-21——8136 Ridge Rd, Houston, TX, 770580.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
CLM-403173CLMStephanie Oliver1978-02-19—83155912112679 Elm St, Jacksonville, FL0.64Name split from “Last, First”Date of birth reformattedPhone reformattedZIP missing+2 more
CLM-425371CLMLinda H Willis1996-05-06UHC-42566-34—4422 Union St, Denver, CO0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-427536CLMBobby Williamson1981-09-16UHC-55721-28—7659 Maple Ave, Orlando, FL, 328790.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407640CLMKevin Webb1955-11-24UHC-94348-7034855774859305 Grand Ave, Atlanta, GA, 303750.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407430CLMCynthia Ward—UHC-59138-15—3700 Hillcrest Rd, Charlotte, NC, 282260.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
CLM-412145CLMDoris Guerrero1951-01-14UHC-32145-6122331368141029 Spring St, Las Vegas, NV, 891470.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-425468CLMRobert O Bradley1991-11-22UHC-05439-115582033873—0.64Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+2 more
CLM-407024CLMYuki Larson2005-01-18——4111 Camelback Rd, Atlanta, GA, 303760.64Name re-casedTwo-digit birth yearCity re-casedGender normalised+2 more
CLM-420431CLMPaul Wang2006-01-27UHC-64029-57—315 Forest Ave, Charlotte, NC, 282730.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-431228CLMJeremy Garrett1946-10-22—61887900071633 Indian School Rd, Gilbert, AZ, 852400.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-404974CLMSofia R Hughes1957-03-08—23125729176276 Bayshore Dr, Columbus, OH, 432640.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-403793CLMJulie X Bowman2002-09-10UHC-06316-8384348212863620 Harbor Blvd, Glendale, AZ, 853490.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-426836CLMJoe Bishop1967-10-04UHC-26419-8862582594369338 Apache Blvd, Jacksonville, FL, 322260.64Name split from “Last, First”Phone reformattedMember ID reformattedState name converted to code+2 more
CLM-416316CLMMei V Stewart2006-05-24UHC-01171-55—2068 Mountain View Dr, Las Vegas, NV, 891820.64Name re-casedMember ID reformattedZIP+4 trimmedEmail lower-cased+2 more
CLM-402533CLMAndrea S Cook1969-03-28—68773793738650 Maple Ave, Scottsdale, AZ, 852980.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416290CLMWillie Li1990-06-18UHC-81208-23—8736 Jefferson Ave, Los Angeles, CA0.64Name re-casedDate of birth reformattedState name converted to codeZIP missing+2 more
CLM-423647CLMBenjamin Gonzalez1993-02-25UHC-36161-1848573478015139 Broadway, Atlanta, GA0.64Two-digit birth yearPhone reformattedAddress re-casedCity re-cased+2 more
CLM-423281CLMDouglas Jimenez1983-08-06UHC-00025-4350936666519405 Ridge Rd, Atlanta, GA, 303360.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-412795CLMJuan B Carpenter——52693441555866 Church St, Columbus, OH, 432370.64Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-428106CLMBruce Harvey2004-03-21UHC-68683-37—9486 Indian School Rd, Orlando, FL0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-425407CLMKelly Herrera1953-01-10——2612 Canyon Rd Apt 30, Austin, TX, 787500.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-419984CLMWei B Ross1978-06-09UHC-75468-3221190235865290 Oak St, Seattle, WA, 981090.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-430579CLMMatthew Long1990-05-18UHC-59379-93—5571 Meadow Ln, Glendale, AZ, 853580.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-430578CLMMatthew Long1990-05-18UHC-59379-93—5571 Meadow Ln, Glendale, AZ, 853580.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
CLM-406584CLMKelly Gordon1941-07-19UHC-60170-4180579991708001 River Rd # 681, Los Angeles, CA, 900200.64Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-426938CLMRyan Dixon2007-03-03UHC-90343-3787959791633550 Lake View Rd, San Diego, CA, 921950.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-405656CLMVictoria Evans1994-03-26UHC-19050-6221180741339661 Forest Ave, Houston, TX, 770680.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-400995CLMJason Garrett2002-09-09——4930 Lincoln Way, Tucson, AZ, 857770.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-400697CLMYuki Nichols2006-11-24——2072 Lincoln Way, Denver, CO, 802370.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-432317CLMEmma H Fields1966-05-24UHC-10590-48—7907 Church St, Plano, TX, 750720.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-405414CLMPalu Warren1950-04-14UHC-35312-3390622787088163 Hillcrest Rd Apt 38, Columbus, OH, 432530.64Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-413353CLMSarahJunk1998-07-05——5026 Hillcrest Rd, Mesa, AZ, 852860.64Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-420841CLMHeather Peterson1980-07-21UHC-87939-6222392494347025 Bayshore Dr, Charlotte, NC0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-412027CLMMargaret Harris1971-03-16—4284901970471 River Rd, Nashville, TN, 372880.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-425432CLMLarry Mendoa1992-09-08—94344621902548 Willow Ct # 883, Orlando, FL, 328090.64Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-415874CLMJudy Williams1979-09-06——1930 Apache Blvd, Tampa, FL, 336830.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-410704CLMSarha Bowman1983-04-27UHC-65972-5234366798173180 Apache Blvd, Los Angeles, CA, 900410.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
CLM-429974CLMHelen Ellis1965-08-01UHC-88505-77—7967 Church St, Eden Prairie, MN, 553060.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-401522CLMDenise Peters1980-10-22—84146944919572 Mesa Dr, San Antonio, TX, 782910.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-401470CLMJerry Pierce2004-02-27——3308 Baseline Rd, Phoenix, AZ, 850200.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
32,829 rows, page 120 of 657PreviousNext