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-432197CLMMary Masoon1942-05-25UHC-32557-0244944134103145 Main St, Fresno, CA0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423118CLMBarbara Reed1968-01-07—46623196383533 Ridge Rd, Miami, FL0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-401490CLMMateo Austin1971-01-19——7939 Church St # 675, Houston, TX, 770880.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-431718CLMMaria M Armstrong1955-12-24UHC-22895-17—9894 Ocean Ave # 236, Jacksonville, FL, 322110.60Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
CLM-426686CLMLias Stevens1996-02-06UHC-86214-2640066253243580 Park Pl, San Antonio, TX, 782380.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426744CLMBrenda Butler1947-12-28UHC-40588-93—3051 Church St, Los Angeles, CA, 900270.60Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
CLM-420053CLMAustin R Martinez2003-05-20——2801 Park Pl, Los Angeles, CA, 900640.60Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-405266CLMEmma Willis1954-08-24UHC-58209-4139467268902532 Grand Ave, Austin, TX, 787580.60Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421726CLMMason Garrett2005-06-06UHC-88787-5887251992676530 Bayshore Dr, Nashville, TN, 372810.60Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-412299CLMLawrence J Watson1995-10-04—90298640819551 Camelback Rd, Minneapolis, MN, 554830.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-407358CLMEric L Palmer1964-11-24UHC-87376-8474232251717424 Palm Dr, Los Angeles, CA0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416405CLMDanielle Ross1997-05-10UHC-36430-99—6832 Main St, Austin, TX, 787280.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-419438CLMAdam Henry1946-11-28UHC-90187-326534105907580 Mountain View Dr, Tempe, AZ, 852310.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-413033CLMBrittany Lucas2000-03-27UHC-42291-53—1258 Park Pl, Plano, TX, 750170.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-409346CLMTimothy X Weber2004-08-09UHC-38193-0284859108172356 Meadow Ln, Minneapolis, MN0.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-426747CLMRusell Marshall1971-08-06—2437149342962 Spring St # 219, Tempe, AZ, 852780.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-423651CLMMei George1968-04-10UHC-01431-9395098847229607 Pine Dr, Plano, TX, 750500.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-417108CLMLori Meyer1992-05-01UHC-60823-7083871354434365 Sunset Blvd, Las Vegas, NV, 891040.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407370CLMJeremy Harvey1965-06-25UHC-56546-03—3677 Pine Dr # 468, Houston, TX, 770460.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-416468CLMGregory F Campbell2003-06-18—68787804186371 Mountain View Dr Apt 20, Austin, TX, 787910.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-408723CLMWei R Walsh1983-12-11UHC-26657-5361788854714054 Willow Ct, Chandler, AZ, 852100.60Middle initial moved out of first nameName re-casedPhone reformattedMember ID reformatted+4 more
CLM-409193CLMJerry Rojas1995-09-22UHC-85772-6021828060634528 Maple Ave, Mesa, AZ, 852930.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425929CLMStephenie Hayes1946-07-03——2981 Park Pl, Charlotte, NC, 282470.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403830CLMLori Wells1955-02-07UHC-79504-51—7001 Meadow Ln, Los Angeles, CA, 900360.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403363CLMDonald W Harris1956-04-18UHC-35499-5263632355382294 Valley View Dr, Plano, TX, 750730.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-405121CLMSteve Knight2004-04-20—89955107783377 Apache Blvd, Nashville, TN, 372020.60Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
CLM-424825CLMDennis Thompson1955-10-11—46875863808585 Grand Ave, Denver, CO, 802120.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402090CLMCharlotte Moore2002-02-05UHC-23929-6383576569173631 Market St, Minneapolis, MN, 554750.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-421051CLMFrank Howard1984-09-13UHC-75968-9825146284494846 Elm St, Glendale, AZ, 853530.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-420758CLMMark Chen1961-09-23—36241855395207 Maple Ave, Dallas, TX0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416430CLMAnn U Luna2007-08-13—91586271966600 Hillcrest Rd, Tucson, AZ, 857110.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-429839CLMRachel Taylor—UHC-19337-8047669298425103 Indian School Rd, Atlanta, GA, 303470.60Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
CLM-411274CLMDiego George——9444057800251 Apache Blvd, Tucson, AZ, 857920.60Name re-casedDate of birth reformattedDate of birth unreadablePhone reformatted+4 more
CLM-411741CLMPriya Tucker1981-02-07—3497194168619 Ocean Ave, Jacksonville, FL, 322480.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-428070CLMMei Meyer1998-09-05UHC-45772-1940677691857851 Sunset Blvd, Phoenix, AZ, 850440.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-423828CLMAndrea O Guzman1992-05-15UHC-33667-5243867220124778 Sage Ct # 798, Tucson, AZ, 857730.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-404600CLMDeborah Vazquez2002-04-08——7172 Bayshore Dr, Tucson, AZ0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417296CLMBetty Garcia1999-09-19UHC-86761-69—3070 Park Pl, San Diego, CA, 921780.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416146CLMHarold Greene1994-12-16——7545 Ocean Ave, Seattle, WA, 981320.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416834CLMTerry Gomez1945-07-27UHC-19314-17—9617 Lake View Rd, Denver, CO, 802550.60Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
CLM-416835CLMTerry Gomez1945-07-27UHC-19314-17—9617 Lake View Rd, Denver, CO, 802550.60Name re-casedPhone missing area codeMember ID reformattedStreet suffix standardised+4 more
CLM-424998CLMTomas N Sanchez1943-03-28——9360 Highland Ave, Jacksonville, FL, 322290.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-422248CLMGabriel Bradley1946-03-05UHC-00034-6246843868331795 Church St, Fresno, CA, 937420.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-429069CLMCatherine I Sanchez2004-06-08UHC-09685-1231799047309542 Mountain View Dr, Charlotte, NC, 282310.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-412302CLMMei Flores1961-10-21UHC-84637-6840444865798565 Park Pl, Austin, TX0.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-431978CLMJeffrey Grant1983-09-13UHC-11675-92—8815 Oak St, Eden Prairie, MN, 553000.60Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-406542CLMWalter Z Phillips1997-01-14UHC-80241-6746620554154901 Forest Ave, Jacksonville, FL, 322550.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-409670CLMJessica Grant2004-10-17—37768479271043 Cedar Ln, Gilbert, AZ, 852410.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417520CLMRichard Kelely1963-12-07UHC-11767-95250227267868 Desert Sky Blvd, Tucson, AZ, 857190.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-401595CLMMelissa Willis1939-06-04—49695814198088 Lincoln Way, Chandler, AZ, 852980.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
32,829 rows, page 65 of 657PreviousNext