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-25257PRVDebra Andesron1963-10-07UHC-15730-68—4484 River Rd, Atlanta, GA0.48Name re-casedDate of birth reformattedMember ID reformattedCity re-cased+4 more
ENR-133629ENRRonald D Morales1948-01-28UHC-99938-6356099625822228 Church St, Phoenix, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-60680TPARebecca Myers1985-12-02—52394438162515 Palm Dr, Tucson, AZ, 857670.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-141547ENRAndrew Hoffman—UHC-49164-7555243922708112 Meadow Ln # 918, Tampa, FL, 336900.48Date of birth missingPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-133964ENRCarol H Day1965-09-01UHC-08350-0578994287244642 Lake View Rd # 217, Sacramento, CA, 958560.48Member ID reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-57060TPACamila W Walsh1960-01-13—77168857682775 Harbor Blvd, Tempe, AZ, 852150.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
TPA-55854TPACarolyn Patterson1975-02-10UHC-74389-7368193742092439 Valley View Dr, Los Angeles, CA0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117665ENRAdam I McCoy—UHC-56750-6225527094796072 Canyon Rd, San Antonio, TX, 782630.48Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-132970ENRMichele J Tucker1939-07-22UHC-99041-10—5313 Broadway # 171, Gilbert, AZ, 852690.48Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+4 more
ENR-135571ENRJordan D Padilla2000-03-12UHC-26828-2739546947041639 Baseline Rd, Phoenix, AZ, 850320.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
TPA-62445TPASantiago Adams1981-12-07——9625 Camelback Rd, Jacksonville, FL, 322740.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-21852PRVJoe F Bishop2006-09-16UHC-31239-0521153423994760 Canyon Rd, Phoenix, AZ, 850940.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-104454ENRJessica G Brns2007-05-20UHC-28147-7348636337358189 Sage Ct, Seattle, WA0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-402266CLMCamila Snyder1953-12-15—34199190785462 Union St, Austin, TX, 787760.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-406098CLMPhilip White1963-09-19UHC-62738-03—9889 Canyon Rd, Chandler, AZ0.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-414468CLMWill Allen1953-06-12—3647074187430 Highland Ave # 819, Dallas, TX, 752670.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-409533CLMSharno Morrison1990-09-15UHC-24318-5874945162322424 Cedar Ln Apt 26, Seattle, WA, 981570.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-131942ENRJeffrey Watson1977-11-28UHC-56766-4937154674831332 Central Ave, Tempe, AZ, 852360.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-131734ENRJanet Knight—UHC-89314-6652654652028349 Forest Ave, Seattle, WA, 981530.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-105545ENRSandra Q Henry1954-08-15UHC-32427-8376161168316380 Union St, Miami, FL, 331590.48Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-107504ENRNathan O Adams1963-09-07UHC-35012-6445140505816781 Pine Dr, Houston, TX, 770120.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
PRV-26597PRVMarshall Larry1971-07-04—52842090871466 Grand Ave Apt 21, Minneapolis, MN, 554100.48Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-404683CLMValentina Ward1990-11-26UHC-06830-3576139351828511 Harbor Blvd, Charlotte, NC0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-404454CLMLarry F Martin2001-01-13——4620 Valley View Dr, San Antonio, TX, 782560.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131044ENRAlan T Thompson1972-10-05UHC-77689-9658162881262288 Sunset Blvd, Eden Prairie, MN0.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-100602ENRPatrick D Jensen1979-11-07UHC-29674-5565158492725738 Forest Ave, Houston, TX, 770680.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-411966CLMMegan Herrera1991-02-23—70871729704453 Indian School Rd Apt 40, Denver, CO0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
PRV-21723PRVVictoria K Webb1951-07-08UHC-59648-0151868709441681 Desert Sky Blvd, Miami, FL0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-114163ENRKeneth G Wells1941-09-05UHC-28757-58—6601 Highland Ave, Chandler, AZ, 852840.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
TPA-55021TPAYuki O Hill1993-11-25—86992086078400 Mountain View Dr, Atlanta, GA, 303890.48Middle initial moved out of first nameDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-106792ENRMarilyn Aguilar1977-06-02UHC-97377-9027634837971454 Jefferson Ave # 544, Phoenix, AZ, 850250.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-404851CLMRussell M Elliott2003-09-13——1646 Grand Ave, Atlanta, GA, 303300.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
TPA-51341TPAArthur H Rice2001-04-24UHC-69841-7335690546014593 Highland Ave, Nashville, TN0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-421746CLMAlan G Bradley1971-09-10—44951704825458 Oak St, Tampa, FL, 336330.48Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-403443CLMDonna Berry1994-09-24UHC-30521-3384652549558353 Bayshore Dr, Atlanta, GA, 303290.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-423625CLMEric Simpson1998-10-18UHC-65773-7098437521108776 Canyon Rd, Columbus, OH, 432890.48Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+4 more
CLM-417175CLMShirley Bennnett1955-08-22——8915 Canyon Rd, Plano, TX, 750240.48Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-117524ENRJeremy Romero1954-11-14UHC-73018-0434678712254322 Bayshore Dr, Sacramento, CA, 958340.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-406850CLMDiego Gonzales1982-03-26——3904 Market St, Minneapolis, MN, 554080.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-122063ENRMichelle P Reed1962-08-23UHC-33270-8065063692028956 Central Ave, San Diego, CA, 921730.48Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+4 more
CLM-427172CLMBryan Black1940-01-26—3844308523985 Apache Blvd # 477, Minneapolis, MN0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-121803ENRBruce G Cox1991-04-12UHC-19418-0571359481191550 Harbor Blvd, Houston, TX, 770670.48Name re-casedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-138757ENRArthur Vassquez2002-12-15UHC-91248-73—2169 Baseline Rd, Mesa, AZ, 852710.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-113526ENRAngela J Foster1989-05-22UHC-87261-1861368555795359 Baseline Rd, San Antonio, TX, 782840.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-142182ENRRaymond Richardson1987-01-13UHC-30484-3144890623475745 Pine Dr, Gilbert, AZ, 852310.48Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-127017ENRSoofia Peters2001-05-16UHC-73843-8076658779774433 Camelback Rd Apt 33, Glendale, AZ, 853840.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
CLM-423096CLMKaren Green1953-06-27—67261323241578 Camelback Rd, Dallas, TX, 752980.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108861ENREddward Delgado1986-01-16UHC-98565-1044531764778051 Market St, Atlanta, GA, 303800.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-108860ENREddward Delgado1986-01-16UHC-98565-1044531764778051 Market St, Atlanta, GA, 303800.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-23939PRVHeather S Ramirez1985-09-07—67566956873843 Main St, Plano, TX0.48Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
100,000 rows, page 53 of 2,000PreviousNext