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-423215CLMAna U Nunez2003-12-07UHC-27580-319778153177183 Main St, Orlando, FL, 328400.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-402518CLMEthan Estrada1966-04-28——5007 Apache Blvd, Chandler, AZ, 852290.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-425906CLMKyle P Fields1952-05-23UHC-45606-15—7188 Broadway, Plano, TX, 750980.66Middle initial moved out of first nameName re-casedGender normalisedWhitespace trimmed+1 more
CLM-430127CLMMelissa B Maldonado1971-06-16UHC-80701-5866049877887835 Church St, San Antonio, TX, 782720.66Date of birth reformattedCity re-casedZIP+4 trimmedGender normalised+1 more
CLM-411921CLMKyle Kennedy1942-03-20UHC-01849-87—5973 Meadow Ln, Orlando, FL, 328760.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-420677CLMRoger Carr1985-11-04UHC-61108-95—5490 Sunset Blvd, Mesa, AZ, 852090.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413522CLMGeorge Gomez1947-02-03——5861 Highland Ave, Glendale, AZ, 853900.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-400972CLMBeverly Gonzales1995-09-04——8059 Church St, Minneapolis, MN, 554920.66SSN last four extractedStreet suffix standardisedAddress re-casedEmail lower-cased+1 more
CLM-415929CLMHawkins Lucia2008-01-14——6889 Ocean Ave, Tempe, AZ, 852180.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-400684CLMElizabeth C Bailey1992-07-17UHC-28857-39—2559 Main St, Dallas, TX, 752020.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407325CLMKaren Reynolds—UHC-08446-48—1841 Spring St, Seattle, WA, 981150.66Name re-casedDate of birth unreadableCity re-casedGender normalised+1 more
CLM-410524CLMAnn W Hudson1944-06-11——1546 Highland Ave, Nashville, TN, 372780.66Date of birth reformattedZIP+4 trimmedGender normalisedPlan code upper-cased+1 more
CLM-408246CLMJack Martinez2006-09-24UHC-79485-18—5313 Forest Ave, Minneapolis, MN, 554030.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
CLM-414373CLMKimberly H George—UHC-06108-113043669565—0.66Name split from “Last, First”Date of birth missingPhone reformattedMember ID reformatted+1 more
CLM-409044CLMDoirs Ford1985-08-03—27449380964869 Meadow Ln, Mesa, AZ, 852590.66Name split from “Last, First”Phone reformattedCity re-casedState name converted to code+1 more
CLM-416298CLMStevne Guzman1960-11-07UHC-93254-06—1507 Central Ave, Houston, TX, 770230.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-425928CLMMegan D Le1994-01-18UHC-47871-3681747429252768 Lake View Rd, Scottsdale, AZ, 852470.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-420672CLMMary Weber1964-12-04—69494017678305 Ocean Ave, Glendale, AZ, 853010.66Date of birth reformattedPhone reformattedState name converted to codeGender normalised+1 more
CLM-429726CLMCharlotte Rojjas1962-09-24——1589 River Rd, Seattle, WA, 981630.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-420948CLMJason Murray1983-04-12——4758 Market St, Dallas, TX, 752780.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414387CLMCarl Vasquez——3964821958—0.66Name re-casedDate of birth unreadablePhone reformattedGender normalised+1 more
CLM-410794CLMTerry F Gardner1984-03-27——1972 Pine Dr Apt 22, Tempe, AZ, 852140.66Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-428183CLMMatthew Sandoval1956-02-01UHC-42875-42—7835 Cedar Ln, Austin, TX, 787860.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedEmail lower-cased+1 more
CLM-408558CLMNathan Guerrero1992-10-27—78877174788022 Sunset Blvd, Minneapolis, MN0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-400975CLMSean F Hunter1944-01-18UHC-33259-01—5604 Pine Dr, Austin, TX, 787950.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-401946CLMChristina Nguyen2003-04-20UHC-52000-64—9150 Harbor Blvd, San Diego, CA, 921820.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-420794CLMDiane Lewis2003-08-05—7765354065566 Baseline Rd, Atlanta, GA, 303280.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-427185CLMAlbert Johnston1961-05-09UHC-58242-5755487785045512 Highland Ave, Tucson, AZ, 857500.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-403509CLMKevin Espinnoza1957-12-15UHC-95455-88—5811 Union St, Denver, CO, 802160.66Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412478CLMDorothy Padilla2002-12-01UHC-67215-44—412 River Rd, Tucson, AZ, 857510.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-400834CLMJulie Webb1951-02-14UHC-82880-5284491531393557 Palm Dr, Eden Prairie, MN, 553310.66Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+1 more
CLM-428625CLMDouglas Kelly1995-05-25UHC-63043-2696444243329857 Washington St, Charlotte, NC, 282310.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-413102CLMKelly Guarrero1998-08-13—3754796593285 Cedar Ln, Tempe, AZ, 852060.66Name re-casedDate of birth reformattedState name converted to codeGender normalised+1 more
CLM-403570CLMDennis H Larson1965-09-05UHC-54035-725948665211290 Camelback Rd, Charlotte, NC, 282720.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-429981CLMSusan H Williamson2008-12-09—88672847742677 Hillcrest Rd, Sacramento, CA, 958460.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-414888CLMDavid R Ryan1956-10-15UHC-48337-47—5705 Pine Dr, Tempe, AZ, 852470.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-414887CLMDavid R Ryan1956-10-15UHC-48337-47—5705 Pine Dr, Tempe, AZ, 852470.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-402871CLMWang E Lisa1986-12-04—21782956654350 Elm St, San Diego, CA, 921020.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-429222CLMAisha Laron1949-09-22UHC-69901-39—3250 Broadway, Eden Prairie, MN, 553810.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-430576CLMArthur Robertson1989-05-18UHC-01568-37—1090 River Rd, Glendale, AZ, 853150.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-408684CLMElijah Vega1948-05-08——925 Spring St, Chandler, AZ, 852150.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-421470CLMWilliam V Pyne—UHC-94750-48—6262 Sunset Blvd, Charlotte, NC, 282040.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-416983CLMWalter C Washington1981-12-16——6312 Park Pl, Nashville, TN, 372850.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-416585CLMStephen Meyer1994-05-10UHC-06552-81—3258 Ridge Rd, San Diego, CA0.66State code upper-casedZIP missingGender normalisedWhitespace trimmed+1 more
CLM-413195CLMJackie Watson2005-05-22UHC-06280-1152049235491973 Cedar Ln Apt 8, Tucson, AZ, 857330.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-412159CLMBenjamin Rice2001-11-22—87452655265390 Baseline Rd, Los Angeles, CA0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-423170CLMBrandon Long1963-11-17UHC-49927-3470092306956600 Ocean Ave, Tampa, FL, 336490.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-404595CLMAmber W Mejia1953-02-17——5149 Mesa Dr, Gilbert, AZ, 852650.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
CLM-409452CLMRachel Walker1968-02-06UHC-21212-5276699102936585 Maple Ave, Chandler, AZ, 852660.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430946CLMSara Brown1977-11-21UHC-51882-4571829716713994 Broadway, Los Angeles, CA, 900680.66Two-digit birth yearPhone reformattedState name converted to codeWhitespace trimmed+1 more
32,829 rows, page 188 of 657PreviousNext