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
PRV-26724PRVNoah Brown2003-02-09UHC-23265-67—8408 Bayshore Dr, Seattle, WA, 981290.50Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+3 more
ENR-133488ENRKimberly Bryant1999-01-19UHC-33003-665967351509767 River Rd Apt 12, Scottsdale, AZ, 852920.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-124490ENRDouglas F Day1946-08-13UHC-15264-5455539472483209 Washington St, Orlando, FL, 328140.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133327ENRNancy Gybson—UHC-33101-1953446994598766 Indian School Rd, Las Vegas, NV, 891490.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135669ENRRalph Turner1971-04-25UHC-77031-5896982980671371 Apache Blvd, Houston, TX, 770070.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-135513ENRMariana Williamson—UHC-04332-28—8477 River Rd Apt 35, Gilbert, AZ, 852580.50Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+3 more
CLM-432418CLMMateo Morneo—UHC-15058-8451230382631447 Ridge Rd # 976, Tempe, AZ, 852990.50Date of birth unreadablePhone reformattedUnit split from streetStreet suffix standardised+3 more
CLM-421270CLMStephen Wang1979-08-11UHC-64067-18—1084 Washington St, Austin, TX, 787670.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-429430CLMDorothy Collins2002-11-16——7220 Forest Ave, Mesa, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-120514ENRLori Roberts1999-01-04UHC-78605-1736147022119741 Canyon Rd, Houston, TX, 770710.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
ENR-111888ENRBrittany Z Wheeler1971-09-05UHC-55556-4596170438301233 Forest Ave, Miami, FL, 331620.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115962ENRDaniel Y James1948-12-17UHC-82075-2489399835626549 Spring St Apt 29, Gilbert, AZ, 852790.50Two-digit birth yearPhone reformattedMember ID reformattedUnit split from street+3 more
ENR-114054ENRMason P Carter—UHC-49290-1748061236804253 Mountain View Dr, Houston, TX, 770950.50Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+3 more
ENR-134309ENRStephen Meyer1960-04-21UHC-55817-7452962262599395 Sage Ct, Jacksonville, FL0.50Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
CLM-423893CLMCarol Riley1995-12-18UHC-60140-2627068659806128 Main St, Tampa, FL, 336270.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-420449CLMAaron Andrews1995-07-06UHC-11785-20—4074 Central Ave, Charlotte, NC, 282690.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-56210TPAGibson Michael1986-02-27—81573794516105 Main St, Los Angeles, CA, 900790.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29245PRVAbigail I Ruiz1976-09-10—95636802185194 Lake View Rd # 322, Miami, FL, 331320.50Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
ENR-131686ENRPhilip Warren1964-04-26UHC-00906-326237643552416 Meadow Ln, Nashville, TN, 372600.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113182ENRJean J Williamson1954-07-12UHC-15361-5665087190785902 Apache Blvd, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-111224ENRVincent J Stevens1975-10-05UHC-60712-5947239524321528 Baseline Rd # 847, Sacramento, CA, 958450.50Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+3 more
ENR-136021ENRWayyne Castillo1957-03-05UHC-95042-5963872668708324 Desert Sky Blvd, San Antonio, TX, 782470.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60120TPAChristine Graham1955-05-24—65980308121820 Mesa Dr, Denver, CO, 802980.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
CLM-413134CLMMarilyn Aguilar1989-02-22——4665 Baseline Rd, Chandler, AZ, 852350.50Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+3 more
TPA-63332TPAOmar C Jacobs1943-10-14——1000 Washington St, Dallas, TX0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-50007TPAKathryn Austin1955-03-27——4907 Spring St, Denver, CO0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
PRV-20561PRVSharon O Patterson—UHC-01025-6848921404217671 Central Ave, Atlanta, GA, 303640.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-106951ENRSophia Schultz1979-05-28UHC-23034-2523387509242062 Jefferson Ave, Phoenix, AZ, 850190.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61311TPALuis Green1964-04-24UHC-57723-185752658492873 Indian School Rd, Fresno, CA, 937830.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-28862PRV—Junk2006-03-14—49287317678767 Harbor Blvd, Sacramento, CA0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-417574CLMElizabeth Baker1994-09-04UHC-60905-9520543339349587 Park Pl, San Antonio, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416819CLMDiana Chen1971-06-13UHC-87642-8139981800063556 Meadow Ln, Eden Prairie, MN, 553130.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-416818CLMDiana Chen1971-06-13UHC-87642-8139981800063556 Meadow Ln, Eden Prairie, MN, 553130.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-406840CLMJacob W Jenkins1968-04-24——3294 Union St # 479, Glendale, AZ, 853550.50Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-131805ENRJack K Mendez1985-06-04UHC-80621-1246857546529614 Highland Ave, Jacksonville, FL, 322750.50Date of birth reformattedPhone reformattedMember ID reformattedState name converted to code+3 more
CLM-417965CLMSofia Ramirez1976-11-13—48266153728190 Camelback Rd # 946, Jacksonville, FL0.50Phone reformattedUnit split from streetCity re-casedState name converted to code+3 more
CLM-418220CLMStephen Brown1992-11-14——2974 Baseline Rd, Austin, TX, 787430.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-56835TPARuth Hall1968-09-24—2722957547470 Apache Blvd, Columbus, OH, 432900.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-108203ENRElijah E Ryan1991-11-22UHC-60945-0292699428841873 Meadow Ln # 811, Austin, TX, 787910.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-101832ENRHeather H Le1960-09-15UHC-10593-3565954861905299 Desert Sky Blvd Apt 33, Austin, TX, 787400.50Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-100433ENREmma Tucker—UHC-98732-6094946553232705 Valley View Dr, San Antonio, TX, 782290.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-29430PRVJohn Luna1982-01-25UHC-17026-9351981737752837 Jefferson Ave, Mesa, AZ, 852940.50Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-115349ENRJoseph P Lee1974-05-25UHC-49849-9554641746125814 Sage Ct, Scottsdale, AZ, 852540.50Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-130515ENRRachel Schmidt1990-01-10UHC-48968-9440237574044772 Sage Ct # 163, San Antonio, TX, 782540.50Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
CLM-418998CLMCynthia Mitchell1944-10-20—35373541496540 Meadow Ln, Charlotte, NC, 282190.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
PRV-22754PRVJudy Rius1956-10-21—69893888667327 Meadow Ln, Plano, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
PRV-22755PRVJudy Rius1956-10-21—69893888667327 Meadow Ln, Plano, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57835TPABryan Simmons1947-11-10—552793883967 Bayshore Dr, Atlanta, GA, 303640.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129961ENRKayla Mills—UHC-01587-5288678569193905 Apache Blvd, Miami, FL, 331310.50Name re-casedDate of birth missingPhone reformattedSSN last four extracted+3 more
ENR-129678ENRBetty Cox1944-01-01UHC-09867-5028336299983527 Central Ave, Jacksonville, FL, 322750.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
100,000 rows, page 126 of 2,000PreviousNext