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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-56425TPAAmy Romero1953-04-25—73071981425444 Union St Apt 7, Phoenix, AZ, 850610.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
CLM-400252CLMJeremy Adams1971-07-04UHC-96734-6239879072244817 Oak St, Austin, TX, 787750.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-105582ENRWilliam U Simpson1979-05-20UHC-38745-5793268716754262 Mountain View Dr, Miami, FL, 331160.46Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-20925PRVGeorge Willis1939-10-03UHC-36586-6477544868014974 Maple Ave # 728, Phoenix, AZ, 850760.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-117827ENRJoshua Bell1951-09-15UHC-79259-4996853900368805 Market St, Chandler, AZ, 852030.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-105887ENRLogan N Bell1970-08-22UHC-88125-0522475983458447 River Rd, Miami, FL, 331450.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-50609TPANick Perry1972-02-16UHC-33463-1930354906213968 Sunset Blvd Apt 30, San Antonio, TX, 782210.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-135258ENRAhmed Willis—UHC-12380-2496835890256230 Church St # 660, Atlanta, GA, 303690.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
ENR-105478ENRCamila M McDonald1999-07-27UHC-24344-8874180108151494 Canyon Rd, Scottsdale, AZ, 852950.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-105113ENRBrian Aguilar—UHC-26234-5138673189198816 Cedar Ln, Miami, FL, 331760.46Name re-casedDate of birth unreadablePhone reformattedSSN last four extracted+5 more
CLM-405980CLMLuis Reynolds1946-04-03UHC-81820-6540526450215142 Baseline Rd, Tucson, AZ0.46Name re-casedDate of birth reformattedPhone reformattedCity re-cased+5 more
PRV-28788PRVNoha Salazar2006-01-25—59957191981356 Meadow Ln, Tempe, AZ, 852730.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
ENR-113476ENRJustin Ruiz1975-08-01UHC-71419-1420521394314997 Lake View Rd, Tempe, AZ, 852190.46Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-131040ENRDianna O Sanchez1999-03-10UHC-38109-6342246420129681 Desert Sky Blvd Apt 28, Sacramento, CA, 958220.46Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+5 more
ENR-118268ENRGregory L Marquez1958-06-14UHC-09727-0272484357855659 Ridge Rd, Los Angeles, CA, 900540.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-402256CLMDebra Hoffman1989-03-03UHC-99555-5984271034129110 Grand Ave, Scottsdale, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-27672PRVLisa Harrison1953-06-05—51168783556571 Ocean Ave, Dallas, TX, 752660.46Name re-casedDate of birth reformattedPhone reformattedCity re-cased+5 more
ENR-105358ENRPatricia Rios2001-05-20UHC-27480-2083568815686561 Highland Ave, Phoenix, AZ, 850700.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-127331ENRYuki Simpson1971-08-19UHC-94703-7723589920905732 Maple Ave, Austin, TX, 787560.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-126850ENRCamila Richardson1972-05-10UHC-85070-5274022652471818 Sage Ct, Sacramento, CA, 958790.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-429371CLMLogan P Sanders1963-11-27—69949506985114 Forest Ave, Fresno, CA, 937690.46Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+5 more
ENR-136506ENRMaria Wells1971-03-17UHC-00047-1469873861655314 Apache Blvd, San Diego, CA0.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-133325ENRAustni Lucas1946-01-03UHC-48528-9995766453966727 Church St, Mesa, AZ0.46Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
TPA-51639TPASrah Snyder1944-01-02—29385832488118 Canyon Rd, San Diego, CA0.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-410181CLMSandra Tucker1962-06-06—74951522514843 Grand Ave Apt 34, San Diego, CA, 921760.46Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+5 more
CLM-403010CLMDennis Nguyen2000-08-27UHC-55252-8894556563772025 Willow Ct, Nashville, TN, 372240.46Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+5 more
ENR-139967ENRGordon Natalie1981-08-11UHC-02756-8991431183043906 Oak St # 102, Orlando, FL, 328140.46Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+5 more
ENR-132720ENRWayne Obrieen1973-01-20UHC-06710-3545978046841154 Mountain View Dr, Denver, CO, 802930.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
CLM-432545CLMJdy Wells1989-06-18——5771 Indian School Rd, Scottsdale, AZ0.46Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+5 more
ENR-125317ENRDavid N Schultz2002-11-23UHC-36109-0747147071573708 Baseline Rd, San Antonio, TX, 782570.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-28062PRVDouglas T Hawkins1949-10-14UHC-29754-96—9435 Harbor Blvd, Nashville, TN, 372740.46Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+5 more
TPA-53709TPACarol Myers1977-12-17UHC-11827-9649988957086335 Church St, Seattle, WA, 981260.46Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+5 more
ENR-113921ENRBrittany Dean1956-10-08UHC-88757-028323029322579 Ridge Rd, Denver, CO, 802040.46Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+5 more
CLM-402845CLMJanet W Lopez—UHC-53522-2351361974587540 Mountain View Dr, Miami, FL, 331400.46Name re-casedDate of birth unreadablePhone reformattedMember ID reformatted+5 more
ENR-125233ENRCynthia H Lopez2003-11-17UHC-81064-9633197254034377 Washington St Apt 1, Austin, TX, 787150.46Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+5 more
ENR-103228ENREthan K Estrada1966-04-28UHC-68529-8929136274245007 Apache Blvd, Chandler, AZ, 852290.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
ENR-117285ENRKevin Le1955-05-21UHC-36777-51—37 Park Pl, Austin, TX0.46Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+5 more
ENR-131465ENRCharles G Perry1953-09-03UHC-24528-8588196109043200 Mesa Dr, Glendale, AZ, 853070.46Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-55992TPAElijah Y Castillo1939-10-27—78073033242196 Elm St, Chandler, AZ0.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-114951ENRWei Young—UHC-83500-0927381626233320 Sunset Blvd, Scottsdale, AZ, 852950.46Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+5 more
ENR-132091ENR—Junk1954-10-10UHC-35421-7895991790218938 Union St, Gilbert, AZ, 852120.46Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
PRV-23298PRVTerry Arnold1952-02-27——5298 Elm St, Sacramento, CA, 958770.46Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+5 more
CLM-429334CLMBarbara Kennedy1967-03-23UHC-82530-0254261642664915 Elm St, Tampa, FL0.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-130446ENRRichard Hansen1959-10-08UHC-25477-1035058924021452 Cedar Ln # 851, Nashville, TN, 372150.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
ENR-110645ENRRandy Wood1981-05-19UHC-10379-1973575207394592 Desert Sky Blvd, Glendale, AZ0.46Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
PRV-20069PRVElijeh Pena1997-07-20—63742860057649 Union St, Tucson, AZ, 857940.46Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-61274TPACheryl Perez1990-04-03——260 Lake View Rd, San Diego, CA, 921010.46Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-63158TPAHennry Dominguez2000-08-01—55167892879538 Mesa Dr, Tampa, FL, 336620.46Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
CLM-423417CLMEmily Snyder1990-07-08——5701 Hillcrest Rd, Seattle, WA, 981500.46Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
ENR-104513ENRNancy V Santiago1977-01-19UHC-01581-3484042229007831 Market St # 701, Las Vegas, NV, 891160.46Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
100,000 rows, page 51 of 2,000PreviousNext