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-419339CLMFatima Espinoza1987-11-15——27 Central Ave, Miami, FL, 331800.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-409682CLMJames Ashley1998-05-07UHC-24324-49—4947 Baseline Rd, Tucson, AZ, 857940.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-400677CLMCtherine Morrison1988-12-13—83325264713792 Desert Sky Blvd, Charlotte, NC, 282910.54Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+1 more
CLM-412791CLMRobert Simmons—UHC-52762-25—1818 Maple Ave, San Diego, CA, 921570.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-412790CLMRobert Simmons—UHC-52762-25—1818 Maple Ave, San Diego, CA, 921570.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-414938CLMTyler D Gray2005-10-24UHC-40253-8871079610233159 Harbor Blvd, Glendale, AZ, 853260.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413772CLMNathan L Smith1967-01-13—65723940617425 Ridge Rd, Mesa, AZ, 852150.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-430154CLMDiane Carter1974-06-22UHC-52209-86—663 Main St, San Diego, CA, 921730.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
CLM-407815CLMDinae Mendez1937-12-13UHC-02276-61—6371 Grand Ave, Las Vegas, NV, 891910.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-411280CLMBruce Morgan—UHC-19389-2434971624385416 Camelback Rd, Gilbert, AZ, 852520.54Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-411170CLMRussell Andrews1989-04-11UHC-37663-59—2725 Pine Dr, Chandler, AZ, 852270.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-402711CLMKayla Gardner1963-11-25—95529600367259 Sunset Blvd, Phoenix, AZ, 850050.54Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+1 more
CLM-402117CLMMary Pena2004-08-06——1649 Indian School Rd, Houston, TX, 770170.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-413505CLMJulie B Parker1969-01-20—60279675805927 Camelback Rd, Minneapolis, MN, 554020.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
CLM-428979CLMDaniel K Garcia1979-10-23UHC-19096-6580580445847751 Union St, Seattle, WA, 981520.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-412977CLMRuth Vazquez2006-09-08UHC-11615-5624396177941207 Lincoln Way, Charlotte, NC, 282440.54Name split from “Last, First”State name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-423088CLMEmily O Fox1945-09-08—7092720143121 Church St, Phoenix, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-427425CLMBradley Elliott1981-03-20——8883 Mesa Dr, Tucson, AZ, 857370.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-425711CLMRonald D Morales1948-01-28——2228 Church St, Phoenix, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-424899CLMDiego Freeeman1971-12-28UHC-98952-98—3303 Ocean Ave, Glendale, AZ0.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-405133CLMRichhard Silva2000-07-04——1302 Meadow Ln Apt 23, San Diego, CA, 921430.54Two-digit birth yearPhone missing area codeUnit split from streetWhitespace trimmed+1 more
CLM-410846CLMLaura Powell1969-05-21——3187 Harbor Blvd Apt 27, Eden Prairie, MN0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-416897CLMCarl Hall2004-04-28UHC-68238-77—6376 Desert Sky Blvd # 229, Phoenix, AZ, 850180.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-431726CLMAhmed Sims1972-07-07UHC-36382-81—7759 Harbor Blvd, Dallas, TX, 752570.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431190CLMTerry Williams1939-10-17UHC-02175-3280362814799227 Cedar Ln # 376, Nashville, TN0.54Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+1 more
CLM-428409CLMNancy Rojas2007-10-03UHC-59612-318799502293309 Ocean Ave, Austin, TX, 787000.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-419493CLMBrittany Turnre1962-11-15UHC-11003-49—2023 Pine Dr, Jacksonville, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-422463CLMDiana Cooper1993-02-21UHC-93659-248206167600855 Pine Dr, Phoenix, AZ, 850470.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-405452CLMAustin Simmons1962-02-28UHC-19960-7864453050031678 Palm Dr, Scottsdale, AZ, 852490.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413741CLMChristian Y Burton1976-03-16UHC-48813-22—3628 Lake View Rd, Miami, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-427703CLMJacqueline Mitchell1984-06-10——7226 Broadway, Denver, CO, 802230.54Name split from “Last, First”Two-digit birth yearAddress re-casedGender normalised+1 more
CLM-400268CLMDonald Ruiz1956-07-18UHC-28641-21—7520 Cedar Ln Apt 1, Tempe, AZ, 852460.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-415415CLMCarolyn Jordan1952-10-12——3878 Market St, Charlotte, NC, 282450.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-415798CLMJoe Diaz2001-03-25——3111 Maple Ave, Glendale, AZ0.54Two-digit birth yearZIP missingGender normalisedWhitespace trimmed+1 more
CLM-406596CLMHiroshi Lewis1954-09-13——3962 Main St, Scottsdale, AZ0.54Name split from “Last, First”Two-digit birth yearZIP missingWhitespace trimmed+1 more
CLM-406093CLMAmber Valdez1954-09-28UHC-35139-2678097882087773 Highland Ave, Miami, FL, 331030.54Name split from “Last, First”Two-digit birth yearPhone reformattedState name converted to code+1 more
CLM-423053CLMDennis G Ward———9793 Harbor Blvd, Plano, TX, 750670.54Date of birth unreadableStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-411493CLMGerald Marquez1943-05-27——7247 Valley View Dr, Tempe, AZ, 852790.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402008CLMArthur M Grant1960-10-23UHC-68341-6360573983633750 Sunset Blvd, Nashville, TN, 372210.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401561CLMJessica Elllis1963-07-27—88863215492220 Central Ave, Fresno, CA, 937810.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-407074CLMAngela Sanders1975-04-10——2301 Grand Ave, Jacksonville, FL, 322170.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-400608CLMKenneth Dunn1950-03-15——345 Harbor Blvd # 650, Atlanta, GA, 303900.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-419188CLMZachary Payne1948-03-24UHC-70686-74—4827 Baseline Rd, Eden Prairie, MN, 553980.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407888CLMRebecca F Hughes1982-04-18UHC-55608-51—6044 Palm Dr, San Diego, CA, 921700.54Two-digit birth yearState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-427312CLMDouglas Edwards1996-09-28UHC-70622-63—1861 Bayshore Dr, Sacramento, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-405464CLMEthan Hill1966-05-05UHC-93821-06—9861 Bayshore Dr Apt 14, Mesa, AZ, 852320.54Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-423185CLMStephen Henry———5848 Forest Ave, Plano, TX, 750030.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-420071CLMChristine I Olson1984-12-03UHC-78090-69—7619 Pine Dr, Fresno, CA, 937380.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-419920CLMDouglas E Wang1938-02-04——566 Pine Dr, San Diego, CA, 921450.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-410740CLMAnna Scott1966-07-27UHC-14025-28—5407 Harbor Blvd, San Diego, CA, 921010.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
32,829 rows, page 60 of 657PreviousNext