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-414375CLMAmber Wlch1942-02-28UHC-68756-9277693795956817 Church St, Glendale, AZ, 853480.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431571CLMKatherine Greene1968-09-02UHC-18898-9142863347592684 Union St, Jacksonville, FL, 322540.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-421149CLMMatthew Marquez1984-02-09—80573329896565 Maple Ave # 808, Glendale, AZ, 853220.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-415344CLMGeorge Dominguez2001-04-12UHC-62241-744545634232974 Sage Ct # 437, Seattle, WA, 981940.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-410583CLMTerry Cunningham1966-10-11UHC-72436-5766184210031040 Baseline Rd, Austin, TX, 787840.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
CLM-418786CLMJesse Snyder1989-03-27UHC-23086-52—6453 Grand Ave, Scottsdale, AZ, 852660.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-403834CLMAmanda Hunt1954-01-17UHC-86125-9753323187676446 Cedar Ln, Austin, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422056CLMEric Davis1981-02-16UHC-06409-8020641639289238 Market St # 108, Plano, TX, 750900.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-405779CLMAisha Griffin2005-09-04UHC-65002-8136678424515361 Elm St, Chandler, AZ, 852290.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-407616CLMBarbara Rojas1974-05-22—31168965918037 Church St, Miami, FL, 331610.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-425378CLMTucker Philip1982-02-21—73263632699361 Jefferson Ave, Orlando, FL, 328730.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-432726CLMSarah Fuller1958-03-06UHC-44743-03—5274 Maple Ave, Glendale, AZ, 853340.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-420440CLMNoah Cook1982-04-09UHC-47414-31—496 Market St, Tempe, AZ0.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-414805CLMAnnna Kelly1985-03-14UHC-87375-5182774527157578 Mesa Dr, Las Vegas, NV, 891450.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-431149CLMRaymond Lee2004-11-09UHC-27065-55—2487 River Rd # 708, Las Vegas, NV, 891710.60Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
CLM-428953CLMSusan T Richardson1946-05-15—25693600031926 Pine Dr, Tampa, FL, 336040.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-428328CLMJerry E Snyder2004-07-14—89521229262995 Ridge Rd, Fresno, CA, 937910.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-417612CLMMei Flores—UHC-58714-51—129 Union St, Fresno, CA, 937870.60Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
CLM-411485CLMNathan Palmer1974-01-04UHC-78327-09—7701 Ocean Ave, Tampa, FL, 336690.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-400528CLMBoby Alexander2000-12-16UHC-78998-2931630774283251 Highland Ave, Dallas, TX0.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402752CLMCharlotte Henderson1977-12-06——2897 Elm St, Denver, CO, 802080.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-404978CLMJack Marshall1963-06-13UHC-15423-91—4285 Main St Apt 15, Mesa, AZ, 852630.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409257CLMArjun Elliott1997-06-07UHC-67426-3757975935136148 Grand Ave, Tampa, FL, 336540.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-431660CLMAlexis Singh1985-11-15UHC-47408-8164346038454394 Canyon Rd Apt 32, Las Vegas, NV, 891070.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-428156CLMKimberly Henderson1942-10-18UHC-39645-3876573074664544 Mountain View Dr, Eden Prairie, MN, 553770.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424662CLMHenry Jackson1964-04-28UHC-50017-2060457861146329 River Rd, Las Vegas, NV, 891230.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-431497CLMAdams W Rebecca1965-02-17UHC-04443-5263266268147683 Meadow Ln, Tempe, AZ, 852130.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
CLM-407920CLMLong Abby1996-01-22UHC-33129-3786151553104841 Oak St, Scottsdale, AZ, 852340.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-423476CLMMariana C Obrien1971-10-08UHC-70943-354699982916884 Lake View Rd, Orlando, FL, 328000.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408929CLMKevin Powell1944-02-06—45844831168193 Union St, Tucson, AZ, 857620.60Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+4 more
CLM-416975CLMBenjamin Franklin1976-05-28UHC-88306-24—6093 Central Ave, Eden Prairie, MN0.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-402666CLMYuki Herrera1996-01-20UHC-52366-24—301 Elm St Apt 16, San Diego, CA, 921480.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409879CLMRuth Ownes1988-01-27UHC-38282-21—8039 Washington St, Houston, TX, 770150.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-409878CLMRuth Ownes1988-01-27UHC-38282-21—8039 Washington St, Houston, TX, 770150.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-432697CLMNoah Andrews1948-09-25——7736 Grand Ave, Denver, CO, 802510.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403988CLMCynthia Burton1960-07-26UHC-26454-1251160062117275 Apache Blvd, Charlotte, NC, 282160.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-416190CLMSteven O Brooks1991-05-11UHC-72425-7435349808556614 Camelback Rd, Tampa, FL, 336990.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-415403CLMWayne Robinson1981-03-08UHC-81887-4992081121785518 Grand Ave, Miami, FL, 331320.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422984CLMJeffrey Payne1966-11-15UHC-28815-1941087377038073 Lake View Rd Apt 2, Tempe, AZ, 852560.60Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+4 more
CLM-403091CLMPatricia Miller1943-02-16—31220109881760 Pine Dr, Denver, CO, 802570.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-424265CLMWatkins Frances1946-10-08UHC-87981-39—983 Highland Ave, Orlando, FL, 328640.60Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+4 more
CLM-405258CLMFrak Padilla1964-02-14UHC-18739-54—3588 River Rd, Minneapolis, MN0.60Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408175CLMAisha V Davis2006-03-03UHC-31947-8431439401779578 Spring St, Nashville, TN, 372290.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404973CLMAaron Mendez2006-05-23—39942845834835 Main St, Orlando, FL, 328670.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408338CLMGary West1998-01-17UHC-19798-1298166124006358 Ocean Ave, Columbus, OH, 432780.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-418396CLMHelen Oliver1978-08-26—74466773287301 Church St, Columbus, OH, 432500.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-407313CLMTommy Espinoza2002-10-08—82889126041690 Willow Ct, Nashville, TN, 372290.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-408893CLMJean Carr1969-06-27——901 Central Ave, Los Angeles, CA, 900950.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423641CLMNoah Weaver2004-03-09UHC-88070-2755446414853816 River Rd Apt 31, Scottsdale, AZ, 852070.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-431646CLMBrandon S Flores2001-04-20UHC-22774-2629887951089616 Apache Blvd Apt 1, Mesa, AZ, 852320.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
32,829 rows, page 71 of 657PreviousNext