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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-52643TPANick X Gonzales1999-02-28——3035 Harbor Blvd, Glendale, AZ, 853330.56Name split from “Last, First”State name converted to codeGender normalisedPlaceholder values cleared
TPA-59623TPATerry Powell1971-06-24UHC-79657-2926576341393918 Maple Ave, Austin, TX0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-62398TPADeborah Johnston1963-05-04—32653424611122 Central Ave, Los Angeles, CA, 900110.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-51057TPAMary Allen1974-10-02—94360776684111 Grand Ave, Eden Prairie, MN, 553680.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-54736TPAFatima Baker1982-12-22——7973 Apache Blvd, Chandler, AZ, 852890.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-55288TPAAdam Jacobs1956-07-03UHC-06104-5975299180012921 Mesa Dr # 424, Phoenix, AZ, 850100.58Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+5 more
TPA-52492TPABrenda Marquez1974-03-24—70799070625518 Grand Ave, Las Vegas, NV0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-63839TPATyler Ortiz1976-09-09——9412 Highland Ave Apt 29, San Antonio, TX, 782650.58Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+5 more
TPA-51752TPABruce Meyer1964-03-22—63874444991979 Jefferson Ave, Houston, TX, 770310.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-63532TPACynthia Stone1942-04-06—26542553373601 Canyon Rd Apt 10, Fresno, CA, 937540.58Name re-casedDate of birth reformattedPhone reformattedUnit split from street+5 more
TPA-59072TPAEugene Wong1941-11-04——3733 Forest Ave, Tempe, AZ, 852400.58Name split from “Last, First”Phone missing area codeState name converted to code
TPA-50615TPABenjamin B Harris1978-11-02—74142890561764 Mountain View Dr, Las Vegas, NV, 891900.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-54052TPAWalter P Meyer1980-06-04——2722 Grand Ave, Scottsdale, AZ, 852240.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-57957TPALinda Lucas1951-03-06—40027111366009 Bayshore Dr Apt 29, Eden Prairie, MN, 553260.58Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+5 more
TPA-52696TPADeborah Nguyen1982-07-12—24964568748504 Oak St Apt 34, Denver, CO, 802560.58Unit split from streetState name converted to codeGender normalised
TPA-56681TPAAndrrea Cole1964-10-12—56284706215210 Sunset Blvd, Orlando, FL0.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-62010TPAAlice Palmer1968-07-18—60225672702542 Palm Dr, Minneapolis, MN, 554020.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-61161TPAJoan Webb2005-09-03—34333870238859 Ridge Rd, Denver, CO, 802930.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-58593TPAJennifer Fisher1993-11-23——3366 Palm Dr, Jacksonville, FL, 322920.58Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-54110TPADouglas Robinson1974-11-27—54268194979031 Apache Blvd, Nashville, TN, 372420.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-64245TPAVirginia Armstrong1961-07-18UHC-99958-9784583881682450 Valley View Dr, Mesa, AZ, 852040.58Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+5 more
TPA-51554TPADennis Powell1977-07-24—93162502548141 Main St, Tucson, AZ, 857650.58Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+5 more
TPA-53876TPAAlan Cole1977-06-25—91248393374335 Ocean Ave, Mesa, AZ, 852950.58Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+5 more
TPA-54338TPAHiroshi Vazquez1978-09-11—9065836819928 Mountain View Dr # 951, Scottsdale, AZ, 852040.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-63843TPAJohn Holmes1983-10-10—35494919861760 Forest Ave, Dallas, TX, 752310.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54637TPACharlotte Gordon1943-08-12—50988061509685 Elm St, Plano, TX, 750380.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-60640TPAKevin W Howell1965-01-04——8133 Palm Dr, Denver, CO, 802760.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51222TPAJanet Harvey1964-07-22—87066829547746 Palm Dr, Tucson, AZ, 857080.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54077TPAIsabella Berry1945-04-01UHC-10949-4768639285508659 Sage Ct, Tucson, AZ, 857220.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
TPA-56792TPAJacoob Greeene1984-10-02—31496579459893 Meadow Ln Apt 22, Jacksonville, FL, 322110.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-62595TPAElliott David1955-05-20—62652964304394 Main St, Nashville, TN, 372000.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-60244TPAKeith Reid1955-08-15UHC-01857-9675065973424715 Jefferson Ave Apt 13, Las Vegas, NV, 891740.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-64200TPABenjamin Copoer1968-06-14—48944115505419 Market St, Houston, TX, 770410.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-55385TPAGabriel Guzman2007-09-24——6274 Lake View Rd, Chandler, AZ, 852760.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62988TPAEmily Roberts1955-07-11—95652869356341 Meadow Ln, Tucson, AZ, 857450.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56397TPALaura Weaver1983-03-21—83131312125819 Ridge Rd # 864, Charlotte, NC, 282070.60Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-51417TPAKenneth Cooper1999-04-06—44747745166394 Baseline Rd, Mesa, AZ, 852340.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-64322TPAValentina Mejia1964-08-16—32175245077607 Hillcrest Rd, Eden Prairie, MN, 553860.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-50883TPAMateo Carter1973-08-09——2383 Baseline Rd, Seattle, WA, 981320.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62209TPAAlan Evans1941-03-07——7622 Washington St, Sacramento, CA0.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54942TPAJessica C Vargas1971-11-27——4014 Sunset Blvd, Glendale, AZ, 853290.60Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
TPA-52985TPAGloria Estrada1945-01-03—91593946959236 Spring St, Houston, TX, 770130.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59320TPARoy Fowler2002-09-28—45992177446743 Apache Blvd, Austin, TX, 787790.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-52237TPAMary Miller1961-10-25—4732937664870 Market St, Orlando, FL, 328320.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50317TPAElizabeth Wilson1957-02-10——3145 Desert Sky Blvd, Phoenix, AZ, 850020.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61827TPAMegan Sandoval2004-12-05—89780765458968 Highland Ave Apt 37, Atlanta, GA, 303270.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-57297TPABarbara King1994-08-04UHC-36646-185698474577337 Sunset Blvd, Denver, CO, 802290.60Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
TPA-64451TPABilly Bailey1971-02-27—44425079292261 Pine Dr, Nashville, TN, 372920.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59368TPAAmy Hamilton1957-11-14—74881785846489 River Rd, Gilbert, AZ, 852290.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63302TPAAdam Vega1974-12-27—53724674983130 Cedar Ln, San Diego, CA, 921810.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
14,474 rows, page 30 of 290PreviousNext