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
CLM-428338CLMElizabeth Dean—UHC-02330-44—2775 Harbor Blvd, Glendale, AZ, 853720.50Name split from “Last, First”Date of birth reformattedDate of birth unreadableStreet suffix standardised+3 more
CLM-404648CLMMary Wilson2008-01-16——5888 Canyon Rd # 670, Los Angeles, CA, 900790.50Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+3 more
CLM-400360CLMAnna Stevens1970-11-09UHC-64371-858123424815582 Union St, Orlando, FL, 328280.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-429909CLMBarb Carroll1966-01-23—52396375707998 Harbor Blvd, San Diego, CA, 921160.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-136006ENRSharon Williamson—UHC-81879-835442846180938 Camelback Rd, Eden Prairie, MN, 553040.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-25831PRVSamuel Fields1973-02-01UHC-70900-7769082291532094 Desert Sky Blvd # 366, Fresno, CA, 937250.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-106118ENRMary A Wilson2008-01-16UHC-13806-99—5888 Canyon Rd Apt 34, Los Angeles, CA0.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-402522CLMMary Shaw1961-12-27UHC-19721-07—958 Palm Dr # 393, Denver, CO, 802900.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-50470TPAGloria Stone1954-03-28——7547 Broadway, Seattle, WA, 981410.50Address re-casedCity re-casedState name converted to codeZIP+4 trimmed+3 more
ENR-123407ENRFatima S Garza1972-11-26UHC-26672-9373468317731370 Lincoln Way Apt 6, Scottsdale, AZ, 852850.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-141005ENRBruce T Garrett1962-07-12UHC-64079-018223304412383 Central Ave, Miami, FL, 331140.50Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+3 more
PRV-27998PRVKimberly Larson2003-08-24—81175877132152 Desert Sky Blvd, Glendale, AZ, 853610.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-413628CLMKeith Banks——42064151388804 Camelback Rd, Las Vegas, NV, 891710.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-60498TPAJoyce Soto1969-09-28——3811 Church St, Atlanta, GA, 303430.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-141052ENRThomas M Luna1997-10-20UHC-95083-8788862756904011 Main St # 201, Orlando, FL, 328030.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-122629ENREugene K Parker1988-06-25UHC-32909-2775757222352035 Ocean Ave, Minneapolis, MN0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102596ENRRobert T Chen1981-09-28UHC-20989-0494440412523700 Willow Ct, Las Vegas, NV, 891390.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-421858CLMLauren Garza1939-08-06UHC-35044-2848456046017624 Church St, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-413025CLMKayla Gardner1947-02-13UHC-87728-37—9879 Elm St, Jacksonville, FL, 322780.50Name split from “Last, First”Two-digit birth yearMember ID reformattedStreet suffix standardised+3 more
ENR-117405ENREddie Alvarez1948-01-05——9770 Highland Ave, Fresno, CA, 937450.50Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+3 more
TPA-58242TPACarol Siingh——57526743345749 Canyon Rd, Las Vegas, NV, 891070.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-29154PRVEdward K Burton2004-10-20—83390891931763 Palm Dr, Mesa, AZ, 852440.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28354PRVSteven P Black1977-09-05—82580223367645 Sage Ct # 969, Scottsdale, AZ, 852510.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-63569TPABrittny Banks1948-07-03—9155051099493 Camelback Rd, Orlando, FL, 328580.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-405935CLMPeter Simpson1980-02-20UHC-03143-6240889074832473 Lincoln Way Apt 4, Fresno, CA0.50Date of birth reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
CLM-423022CLMCarl N Barnes1952-12-04UHC-59895-5864923582606835 River Rd # 953, San Antonio, TX0.50Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-404277CLMVirginia H Ross1944-06-04UHC-66259-5640148276088604 Maple Ave, Tempe, AZ, 852970.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-413947CLMMason Rios1950-09-14—22082205288770 Washington St, Glendale, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-422107CLMOlivia Davis1995-11-18——5346 Elm St, Columbus, OH0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108646ENREmma X Meyer1997-06-18UHC-13185-0922273022955206 Sunset Blvd, Columbus, OH, 432250.50Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-430466CLMJoyke Sanders1972-01-18—6839567999566 Union St # 641, Las Vegas, NV, 891770.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-135217ENRSean X Barnes1988-07-02UHC-81350-5998272990228435 Mesa Dr, Las Vegas, NV, 891540.50Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-25298PRVBenjamin Taylor2001-12-08UHC-67866-6594059082626565 Cedar Ln, Las Vegas, NV0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120735ENRRonald Li2005-05-05UHC-48215-1832474429867592 Canyon Rd, Chandler, AZ, 852090.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-50381TPASandra Medina——36783362412837 Willow Ct, Las Vegas, NV, 891580.50Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+3 more
ENR-104861ENRAmber R Lawrence1997-10-14UHC-47479-45—6010 Indian School Rd, San Diego, CA, 921610.50Name split from “Last, First”Middle initial moved out of first nameMember ID reformattedCity re-cased+3 more
PRV-25687PRVVincent Gilbert2005-03-11—41743291605120 Cedar Ln, San Diego, CA, 921580.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-102212ENRKylle Q Wang1939-09-22UHC-43409-2726061720075461 Indian School Rd, Fresno, CA, 937410.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120406ENRSteve I Aguilar1938-03-08UHC-51621-7054739245668456 Baseline Rd, Gilbert, AZ, 852030.50Middle initial moved out of first namePhone reformattedMember ID reformattedSSN last four extracted+3 more
TPA-62934TPAAllice Gibson1952-08-03—95695657043399 Palm Dr, Los Angeles, CA, 900620.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138726ENRJulia B Lucas1981-07-20UHC-72844-783215592607504 Sunset Blvd, Minneapolis, MN, 554470.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-105506ENRDaniel Matthews1942-11-06UHC-84431-1579939577272893 Church St # 942, Tucson, AZ, 857140.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-64274TPARussell Mitchell1992-05-13——5643 Washington St, Chandler, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
ENR-137593ENRKathy Palmer1986-09-15UHC-42607-4186332790322434 Sunset Blvd Apt 11, Phoenix, AZ, 850690.50Phone reformattedMember ID reformattedSSN last four extractedUnit split from street+3 more
ENR-100558ENRTerry I Martinez1970-10-08UHC-27731-5367238616085456 Park Pl, San Antonio, TX, 782510.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-53328TPABeverly Harris2002-03-03—29197549791193 Apache Blvd, Scottsdale, AZ, 852110.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-428959CLMRobert Carter1978-08-07——1465 Ocean Ave, Eden Prairie, MN, 553370.50Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+3 more
CLM-414509CLMSamuel Guerrero2004-08-11—35622211194432 Willow Ct, Plano, TX, 750400.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117769ENRSephen N Miller1973-09-12UHC-27582-633896210901800 Central Ave, Sacramento, CA, 958110.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141123ENRJoe Graham1972-07-05UHC-78221-8881150514068873 Harbor Blvd, Tampa, FL0.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
100,000 rows, page 137 of 2,000PreviousNext