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-424562CLMBruce Burke1979-08-05UHC-27034-47—8889 Canyon Rd Apt 27, Tucson, AZ, 857300.66Name re-casedUnit split from streetGender normalisedWhitespace trimmed+1 more
CLM-430847CLMMaateo L Grant1969-10-22UHC-05095-06—2240 Hillcrest Rd, Fresno, CA, 937360.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-404128CLMCherylJunk2002-12-17UHC-92867-0164330423723156 Baseline Rd, Sacramento, CA, 958960.66Name re-casedStreet suffix standardisedAddress re-casedPlaceholder values cleared+1 more
CLM-406669CLMJean I Bron1938-02-24——9596 Lake View Rd, Glendale, AZ, 853540.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402211CLMHarold Singh1949-12-22UHC-27892-54—7435 Lake View Rd, San Antonio, TX, 782850.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422512CLMJoseph Hamilton1978-12-24UHC-75523-9347276935849649 Harbor Blvd, Los Angeles, CA, 900360.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-406216CLMLauren Porter2007-09-10——1895 Elm St, Glendale, AZ, 853350.66Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-416550CLMDaniel Fields1944-06-14UHC-38023-03—5374 Church St, Fresno, CA, 937770.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425195CLMCharlotte Coleman1973-01-26——5053 Lincoln Way, Dallas, TX, 752640.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-409369CLMAhmed Fernandez1942-05-11UHC-73996-20—3832 Elm St, Houston, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-414035CLMChristine Bryant1964-01-02—31391130308446 Union St, Jacksonville, FL, 322340.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-418915CLMStephanie Lee1974-09-03—97663559721459 Baseline Rd # 734, Glendale, AZ, 853130.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-406681CLMJohnny Little1968-05-02UHC-51193-40—1768 Maple Ave, Gilbert, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-406682CLMJohnny Little1968-05-02UHC-51193-40—1768 Maple Ave, Gilbert, AZ0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-417448CLMKathleen Morgan1994-04-23UHC-44662-6955353077905250 Spring St, Fresno, CA, 937540.66Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-417306CLMJordan Meyer1979-11-20UHC-78701-38—2848 Sunset Blvd, Eden Prairie, MN, 553170.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-405792CLMPamela T Chen1955-10-09UHC-59611-12—2159 Maple Ave, Tucson, AZ, 857490.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-408138CLMJoseph Scott1975-08-21——7502 Desert Sky Blvd, Austin, TX, 787610.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-415166CLMDaniel Hunter1990-12-19—70196728363802 Mesa Dr, Nashville, TN, 372960.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-409525CLMElziabeth Greene1950-01-08UHC-43618-3024124587414344 Central Ave, Atlanta, GA, 303360.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-401475CLMFatima Stevens1979-04-05UHC-61847-88—715 Spring St, Scottsdale, AZ, 852500.66Member ID reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-408987CLMBetty Fields2006-08-24—54787389852940 Cedar Ln, Scottsdale, AZ, 852730.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-424524CLMRoger Nguyen1992-02-06—45673290414735 Central Ave, Eden Prairie, MN, 553550.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-429520CLMAlexander Walker———545 Desert Sky Blvd, Gilbert, AZ, 852140.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
CLM-409887CLMBobby F Ferguson1954-07-24UHC-22343-80—541 Hillcrest Rd, Orlando, FL, 328960.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-407793CLMScott Long2005-01-19UHC-92078-403365227421333 Pine Dr, San Diego, CA, 921320.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-409019CLMArjun Flores1978-12-09UHC-99969-24—2271 Elm St, Chandler, AZ, 852150.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-414880CLMRyan M Daniels1949-03-16UHC-67026-8329086820032759 Bayshore Dr, Glendale, AZ, 853310.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-427237CLMJoseph Turner1957-06-14——4916 Camelback Rd, Tampa, FL, 336820.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-403090CLMPatricia Miller1943-02-16——1760 Pine Dr, Denver, CO, 802570.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-413119CLMYuki U Ortega1976-05-26——9570 Cedar Ln, Los Angeles, CA, 900890.66Name split from “Last, First”Date of birth reformattedSSN last four extractedWhitespace trimmed+1 more
CLM-431222CLMDonna Morris2003-07-27——7992 Elm St, Nashville, TN, 372840.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-431944CLMMadison Wilson1946-10-13UHC-30657-32—6433 Pine Dr, Scottsdale, AZ, 852010.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-403843CLMKimberly T Cruz1967-03-18UHC-50312-7554882278578056 Camelback Rd, Columbus, OH, 432280.66Name re-casedDate of birth reformattedState name converted to codeGender normalised+1 more
CLM-404838CLMElizabeth Simmons1938-07-15—69927041786495 Harbor Blvd, Houston, TX, 770970.66Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+1 more
CLM-427143CLMMargaret Foster1950-06-28UHC-01099-35—9550 Highland Ave, Phoenix, AZ, 850450.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-406233CLMVictoria Schmidt1988-06-12UHC-00189-24—7090 Harbor Blvd, Tempe, AZ, 852780.66Name split from “Last, First”Two-digit birth yearState code upper-casedEmail lower-cased+1 more
CLM-420527CLMGeorge T Lopez1951-11-13—59426267679472 Sunset Blvd, San Diego, CA0.66Name re-casedPhone reformattedZIP missingGender normalised+1 more
CLM-432038CLMBobby Ortiz1946-01-03——4494 Indian School Rd, Miami, FL, 331500.66Name re-casedSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
CLM-412617CLMDiego Marquez1993-02-10——8702 Valley View Dr Apt 34, Columbus, OH, 432640.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402044CLMBrian K Wong1946-09-25UHC-95997-7298836485202639 Canyon Rd, Plano, TX, 750330.66Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
CLM-411278CLMFrank Lawrence1979-09-09UHC-94025-69—8715 Grand Ave, Atlanta, GA, 303640.66City re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
CLM-428648CLMRebecca Eztrada1998-01-03UHC-94735-5989838854069541 Jefferson Ave, Atlanta, GA, 303100.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-414831CLMGrace Coleman1953-12-14UHC-12213-4568056244173475 Union St, Austin, TX, 787070.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-421031CLMRuth Peters1939-10-27——1093 Meadow Ln, Scottsdale, AZ, 852620.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-411194CLMMadison Bowman1951-08-24UHC-02625-9783385913096821 Camelback Rd # 861, Scottsdale, AZ, 852510.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-405243CLMKathleen Berry1975-09-17UHC-51781-32——0.66Name split from “Last, First”Member ID reformattedGender normalisedWhitespace trimmed+1 more
CLM-411416CLMDiana P Howard1956-12-13UHC-95898-6575848875441940 Apache Blvd, Fresno, CA, 937270.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-425382CLMAnn Fernandez1999-10-22UHC-30255-20—6009 Apache Blvd, San Antonio, TX, 782300.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-411537CLMNoah H Miller1962-11-10UHC-78031-25—5151 Pine Dr, Glendale, AZ0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
32,829 rows, page 186 of 657PreviousNext