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-407289CLMPaul Foster1984-02-05UHC-62285-69—4047 Washington St, San Antonio, TX, 782400.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
CLM-418555CLMSara Owens1958-12-28—21137602886873 Market St, Phoenix, AZ, 850850.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-418554CLMSara Owens1958-12-28—21137602886873 Market St, Phoenix, AZ, 850850.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-431036CLMEmily Ford1977-10-26——1597 Meadow Ln, Chandler, AZ, 852230.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-414625CLMKathleen Andrews1960-05-22UHC-09149-8730920807634573 Baseline Rd, Phoenix, AZ, 850360.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-410033CLMBetty Ellis1999-10-26—64751471048398 Market St, Minneapolis, MN, 554370.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-421763CLMAnna Ortiz1964-08-20UHC-88523-2059290686581887 Central Ave, Charlotte, NC, 282090.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-427527CLMAnn Silva1967-02-28UHC-80435-97—1602 River Rd, Tucson, AZ, 857390.66Name split from “Last, First”Date of birth reformattedZIP+4 trimmedWhitespace trimmed+1 more
CLM-428120CLMSandrra Mendoza1964-03-11UHC-30072-3230943170942553 Apache Blvd, Sacramento, CA, 958130.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-428314CLMDavid Romero2006-04-11——6332 Indian School Rd, Orlando, FL, 328990.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-411039CLMNicholas J Little1996-03-25UHC-39095-13—2786 Bayshore Dr, Scottsdale, AZ, 852790.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-400832CLMHannah Burke2008-11-14—26193414167092 Canyon Rd, Chandler, AZ, 852570.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-426198CLMJoan Spencer1943-03-13——6853 Bayshore Dr, Austin, TX, 787810.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
CLM-400276CLMAlexander Medina1962-10-09—75984846123388 Forest Ave, Atlanta, GA, 303720.66Street suffix standardisedAddress re-casedCity re-casedState name converted to code+1 more
CLM-414398CLMSantiago I Miller—UHC-35055-5532796448923679 Meadow Ln, Mesa, AZ, 852160.66Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-412764CLMDebra Feilds1973-06-12UHC-12024-33—1358 Pine Dr, Phoenix, AZ, 850930.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-431663CLMJames R Porteer1948-06-18UHC-83196-09—8111 Ocean Ave, Atlanta, GA, 303160.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
CLM-423036CLMCamila Guuerrero1977-02-06UHC-45067-31—3791 Ridge Rd, Charlotte, NC, 282180.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-403007CLMJoshua Andrews1958-05-24UHC-80667-7488668628022045 Market St, Los Angeles, CA, 900980.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-410428CLMAnna Dunn1979-05-15——1087 Hillcrest Rd, Miami, FL, 331550.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-411404CLMEmma Harrison1939-12-13—38984863361925 Mountain View Dr, Miami, FL, 331230.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-406283CLMEric Q Reed1967-11-15UHC-30938-27—6945 Ridge Rd, Atlanta, GA0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-410973CLMThomas Stephens2003-07-13——7446 Apache Blvd, Tampa, FL, 336590.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-424824CLMDennis Thompson1956-10-11UHC-99586-03—8585 Grand Ave, Denver, CO, 802120.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-426768CLMVirginia Green1963-10-26——8700 Sunset Blvd # 490, San Diego, CA, 921260.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
CLM-421096CLMMichelle Jacobs1956-04-06UHC-37499-8333444903458321 Mountain View Dr, Chandler, AZ, 852090.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403882CLMTimothy Reed1952-01-06UHC-12264-39—6718 Lincoln Way, Miami, FL, 331030.66Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-420331CLMKyle H Smith1984-10-21UHC-47052-61—2161 Jefferson Ave, Orlando, FL, 328270.66Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+1 more
CLM-422076CLMAnthony James1987-02-14UHC-64793-65—2390 Church St, Glendale, AZ, 853850.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-422077CLMAnthony James1987-02-14UHC-64793-65—2390 Church St, Glendale, AZ, 853850.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-415159CLMEdward Garcia1942-12-09—48186025445691 Lincoln Way, Austin, TX, 787860.66Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-407276CLMAnna Carr1965-06-17UHC-83901-86—6692 River Rd, Houston, TX, 770330.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-401501CLMJudy Nguyen1972-11-15UHC-34093-9077797748475497 Main St, Columbus, OH, 432770.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-416354CLMBruce K Philllips1989-05-28——5407 Hillcrest Rd, Las Vegas, NV0.66Name split from “Last, First”State code upper-casedZIP missingWhitespace trimmed+1 more
CLM-419191CLMJoan Burton1996-12-17UHC-29497-5445131168084143 River Rd, Denver, CO, 802530.66Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-407290CLMLisa Bryant1997-02-06——5893 Meadow Ln, Nashville, TN, 372240.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
CLM-423574CLMDouglas Daniels1957-01-06UHC-43682-3032339851993223 Washington St, Denver, CO, 802150.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
CLM-407537CLMVirginia Yang1988-08-28UHC-41415-626856039563200 Jefferson Ave Apt 37, Mesa, AZ, 852870.66Phone reformattedUnit split from streetState code upper-casedZIP+4 trimmed+1 more
CLM-403066CLMAlexis Garza1972-01-15——7046 Pine Dr, Eden Prairie, MN0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
CLM-411543CLMJack N Carter1997-04-23——9198 Mountain View Dr, Tucson, AZ0.66Name re-casedState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-409546CLMDouglas Tucker1992-08-22UHC-89410-87—5520 Desert Sky Blvd, Glendale, AZ, 853720.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-415866CLMAaron Simpson2005-05-22UHC-21933-26—659 Washington St, Miami, FL, 331750.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-426070CLMAnn R Bans1996-06-14———0.66Name re-casedTwo-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-408710CLMVirginia Le1958-01-16UHC-66102-15—4073 Forest Ave, Scottsdale, AZ, 852180.66Member ID reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-413479CLMCarol Gonzalez1989-12-08—54946141466677 Cedar Ln, Phoenix, AZ, 850980.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
CLM-400248CLMJonathan P Black1952-12-24UHC-08559-01—6042 Forest Ave, Seattle, WA, 981840.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
CLM-426701CLMCatherine Dean1945-09-01——417 Union St, Orlando, FL, 328660.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-403301CLMDylan Stone1961-03-05UHC-00232-4343327211701977 Market St # 466, Denver, CO, 802480.66Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+1 more
CLM-408519CLMFrnak Diaz1999-04-24UHC-16569-25—7982 Sage Ct, Columbus, OH0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
CLM-411689CLMRandy Z Malddonado—UHC-32441-24—5269 Church St, Tucson, AZ, 857820.66Date of birth reformattedDate of birth unreadableEmail lower-casedGender normalised+1 more
32,829 rows, page 162 of 657PreviousNext