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-24037PRVMason Rios1950-09-14UHC-34110-1122082205288770 Washington St Apt 16, Glendale, AZ, 853400.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-23659PRVBrenda Henry2004-01-05—69981261062034 Cedar Ln Apt 18, Chandler, AZ0.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
ENR-113563ENRBruce C Morris1986-01-18UHC-33350-1776464395876865 Mesa Dr, Gilbert, AZ, 852580.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-103074ENRFrank Santiago1946-02-25UHC-15366-3026862141704144 Desert Sky Blvd, Tampa, FL, 336860.44Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+6 more
ENR-121051ENRBily Ortiz2006-10-20UHC-78085-1579480785153156 Bayshore Dr, Eden Prairie, MN, 553570.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-29575PRVMaria Fields1944-03-23—42498724747659 Hillcrest Rd, Minneapolis, MN, 554890.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
PRV-23726PRVMegan Wilson1956-03-14UHC-27377-9567330167079499 Market St, Denver, CO, 802470.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-402488CLMSusan Bell1980-04-10UHC-59959-1926589958026313 Jefferson Ave, Los Angeles, CA, 900230.44Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-113072ENRKathleen O Williamson1964-11-04UHC-41645-1494180566807680 Indian School Rd, Charlotte, NC, 282440.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-103718ENRDiego Valdez1962-04-06UHC-00431-81—315 Palm Dr, Tucson, AZ0.44Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-111554ENRTimothy P Weber2001-09-27UHC-91272-09—3400 Park Pl, Scottsdale, AZ0.44Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+6 more
ENR-105768ENRJeremy Chapman1985-12-26UHC-44520-7635866433075814 Forest Ave, Miami, FL, 331590.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-425779CLMMark Long1976-08-26UHC-50062-613155420342365 Camelback Rd # 468, Seattle, WA, 981710.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
PRV-21018PRVLarry L Mills1998-01-13—5265578622155 Harbor Blvd # 679, Gilbert, AZ, 852090.44Middle initial moved out of first nameDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-420844CLMJacob Jensen1942-01-19UHC-74692-4142373266495608 Meadow Ln, Denver, CO0.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-100457ENRJackie T Johnston1999-08-07UHC-56323-709353383997568 Jefferson Ave, Plano, TX0.44Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+6 more
ENR-119488ENRIsabella U Burton1980-11-25UHC-09055-5079385881033009 Apache Blvd # 188, Tempe, AZ, 852380.44Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+6 more
PRV-25231PRVCarlos S McCoy1981-10-23—23675260354191 Grand Ave, Plano, TX, 750610.44Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-116127ENRJuie Sullivan1979-09-27UHC-95420-85—5655 Union St, Las Vegas, NV0.44Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+6 more
ENR-129338ENRBruce I Dean1983-05-07UHC-92761-6145037541321899 Oak St, Houston, TX, 770330.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-115545ENREthan Kennedy—UHC-94235-3535594992142663 Hillcrest Rd # 756, Mesa, AZ, 852970.44Name re-casedDate of birth missingPhone reformattedMember ID reformatted+6 more
PRV-27018PRVBenjamin Cox1983-03-07UHC-68145-7840195488472173 Main St, San Antonio, TX, 782300.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-406009CLMGerald Richardson1957-04-11UHC-52791-3529988256601747 Sage Ct # 324, Gilbert, AZ, 852540.44Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more
CLM-412268CLMDavid W Hansen2004-02-20UHC-62023-7683235979138251 Apache Blvd, Jacksonville, FL, 322550.44Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+6 more
ENR-100688ENRMartha B Parker—UHC-19603-9760264442029366 Maple Ave Apt 24, Eden Prairie, MN, 553210.44Name re-casedDate of birth unreadablePhone reformattedUnit split from street+6 more
TPA-50089TPAMike Dunn2006-08-16—55497733347975 Church St, Glendale, AZ, 853290.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-106044ENRRandy Murray2001-09-26UHC-92433-3490459897861777 Central Ave, Miami, FL, 331170.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
CLM-423639CLMEugene Morales1976-03-11UHC-18419-7055599341767390 Bayshore Dr Apt 30, Austin, TX, 787660.44Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more
CLM-413217CLMMark F Maldonado1990-06-11UHC-07588-915335139184925 Central Ave, Eden Prairie, MN, 553250.44Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-120316ENRCynthia Alvarez1953-07-13UHC-21356-8980322616331555 Lake View Rd, Scottsdale, AZ0.44Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-120279ENRScott Guzman1989-02-04UHC-03230-1437164282662262 Cedar Ln, Tampa, FL0.44Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
CLM-415276CLMCamila Brown1951-11-17UHC-87174-4960998035563113 Forest Ave, Orlando, FL, 328320.44Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+6 more
ENR-128740ENRVincentJunk1990-12-24UHC-51856-4290891371818425 Jefferson Ave, Nashville, TN, 372450.44Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more
ENR-117815ENRSophia Hill1975-08-12UHC-72031-8929084164654128 Spring St # 237, Denver, CO, 802180.44Name re-casedPhone reformattedMember ID reformattedUnit split from street+6 more
ENR-105153ENRTimothy H Rivera1946-03-08UHC-26841-1292127258905323 Canyon Rd, Scottsdale, AZ, 852360.44Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
ENR-129154ENRJoseph M Daniiels1995-07-13UHC-26322-2581679900889477 Bayshore Dr, Phoenix, AZ0.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-124415ENRAshley E Thompson1999-11-22UHC-62776-7740784351138765 Central Ave, Eden Prairie, MN, 553200.44Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+6 more
ENR-135864ENREmily C Dominguez1985-10-01UHC-30743-9352331031064578 Pine Dr, Jacksonville, FL, 322530.44Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
PRV-21725PRVNoah Pena1977-02-21—70344085659475 Canyon Rd, Fresno, CA0.44Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+6 more
ENR-115925ENRPatricia B Kim1998-05-23UHC-30627-1951268852513503 Elm St # 816, Columbus, OH, 432510.44Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more
CLM-432054CLMAmy H Gilbert1973-11-04UHC-06665-7156536316054705 Mountain View Dr Apt 18, San Antonio, TX, 782290.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
CLM-400712CLMStephen Murphy1955-10-14UHC-00291-4368372026019309 Ridge Rd, Nashville, TN0.44Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+6 more
ENR-107898ENRRay U Ruiz1949-08-14UHC-95302-6726340701074347 Camelback Rd Apt 28, Tempe, AZ, 852450.44Date of birth reformattedPhone reformattedMember ID reformattedUnit split from street+6 more
PRV-22077PRVAustin Henderson1993-03-13UHC-20641-0246881298414944 Indian School Rd Apt 2, San Diego, CA, 921140.44Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more
ENR-135689ENRMaria G Stone1953-02-23UHC-66345-9069797974473800 Sage Ct # 456, Sacramento, CA, 958140.44Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+6 more
TPA-62493TPACheryl Yang2003-02-03—74729064483370 Bayshore Dr Apt 21, Jacksonville, FL, 322350.44Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+6 more
PRV-27343PRVKelly Burton1980-10-12UHC-06398-6176745875249072 Park Pl, Dallas, TX, 752170.44Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+6 more
CLM-417084CLMRussell Matthews1964-12-28UHC-68793-97—8711 Union St Apt 5, San Antonio, TX, 782450.44Name re-casedDate of birth reformattedMember ID reformattedUnit split from street+6 more
CLM-413656CLMAmy Sandoval1978-01-28UHC-15452-4848820548747809 Sunset Blvd, Charlotte, NC0.44Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+6 more
PRV-21329PRVRebecca Munoz1958-09-21—34857368478264 Hillcrest Rd # 969, Charlotte, NC, 282600.44Name re-casedDate of birth reformattedPhone reformattedUnit split from street+6 more
100,000 rows, page 41 of 2,000PreviousNext