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
ENR-125587ENRDonna Luna1994-02-02—96398935084405 Willow Ct Apt 19, Eden Prairie, MN, 553330.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-116126ENRRalph Bowman1941-08-25UHC-50182-6958955603118891 Camelback Rd, Dallas, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56246TPAStephen Q Evans1941-07-16—5667832046539 Indian School Rd, Houston, TX, 770160.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
TPA-63621TPAEthan Gilbert1974-06-16—45939998775664 Washington St, Houston, TX0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-60385TPAAaron Rojas1938-03-27——7749 Mesa Dr, Gilbert, AZ0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116476ENRArthur V Santiago1957-01-17UHC-93303-9942390856808326 Main St, Tempe, AZ, 852600.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108165ENRKathryn Ramirez—UHC-00624-0286162125489294 Park Pl, Gilbert, AZ, 852810.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-139588ENRCatherine Riley1999-11-09UHC-20404-2452390398817227 Canyon Rd, Mesa, AZ0.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-111577ENRKaren F Jackson1947-05-22UHC-05379-6885433793291428 Jefferson Ave, Los Angeles, CA, 900230.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-114138ENRLauren Perry—UHC-79257-9496643269691166 Camelback Rd, Eden Prairie, MN, 553000.48Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+4 more
TPA-62413TPAWilliam Hughes1978-01-02—82245637919230 Canyon Rd, Minneapolis, MN0.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-128852ENRDouglas Q Perry1979-03-18UHC-12328-7138265463991326 Apache Blvd Apt 37, Austin, TX, 787720.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-412112CLMBenjamin Shaw1992-05-24UHC-42535-6063591949244124 Bayshore Dr, San Antonio, TX, 782980.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-113751ENROlivia Riz1980-03-08UHC-33228-2328397552114821 Market St, Austin, TX, 787650.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-58816TPAJeeremy Robertts1994-12-02—53187153019863 Sage Ct # 320, Columbus, OH, 432600.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-428863CLMArthur Johnson1954-04-15UHC-46807-70895433447458 Spring St, Houston, TX, 770350.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-124461ENRDebra Y Ortega1998-11-09UHC-53202-9429937264623452 Meadow Ln, Orlando, FL0.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
PRV-21243PRVMarilyn Wyllis1997-06-15UHC-30752-1282729270438924 Grand Ave, Atlanta, GA0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-104311ENRScott Barnes1999-01-19UHC-33275-9468773966928037 Forest Ave, Chandler, AZ, 852800.48Two-digit birth yearPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-106646ENRDiana O Harrison1966-08-06UHC-09874-0340131855297744 Central Ave, Gilbert, AZ0.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-417875CLMMadison Stephens1951-08-04——1893 Washington St, Chandler, AZ, 852430.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-123936ENRDylan C Reed2005-08-19UHC-39800-7531574499194465 Desert Sky Blvd # 550, Austin, TX, 787350.48Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
PRV-27056PRVLisa Wnog1966-09-13UHC-10089-2059155788256788 Oak St, Tucson, AZ, 857220.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54950TPAJerry Greene1968-01-26—34992935636098 Sunset Blvd, Tempe, AZ, 852020.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-126954ENRDot Hall—UHC-15763-5483078413346357 Highland Ave, Las Vegas, NV0.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-114204ENRBenjamin Turner1949-04-08UHC-47719-1835793931163818 Canyon Rd # 799, Tempe, AZ, 852820.48Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+4 more
ENR-107721ENRRalph R Williamson1987-07-26—48053001721667 Palm Dr # 816, Scottsdale, AZ, 852540.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-105038ENRTimothy P Reed1952-01-06UHC-12264-39—6718 Lincoln Way, Miami, FL, 331030.48Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+4 more
CLM-406161CLMNoah Bryant1967-08-07—36693184065278 Mountain View Dr # 784, Columbus, OH, 432560.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-103739ENRElizabeth Mendez1941-01-06UHC-68235-5887862619876053 Church St, Tampa, FL0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107203ENREmily R Lopez1943-12-14UHC-00216-3464683539196843 Camelback Rd Apt 4, Chandler, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
CLM-412875CLMDonna F Le1965-02-06UHC-38557-9338391334526110 Valley View Dr Apt 10, Chandler, AZ, 852620.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-141053ENRThomas M Luna1997-10-20UHC-95083-8788862756904011 Main St, Orlando, FL, 328030.48Middle initial moved out of first nameName re-casedPhone reformattedCity re-cased+4 more
ENR-102759ENRCynthia L George1997-10-13UHC-88626-78—8035 Lincoln Way, Los Angeles, CA, 900330.48Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-130538ENRJon Petersun1958-09-11UHC-98787-1537021079068169 Sunset Blvd, Houston, TX, 770710.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-138872ENRRichard Carpenter1973-01-14UHC-63811-1672122807841751 Elm St, Fresno, CA0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-418818CLMJoseph Evans1996-07-02UHC-53901-4795749169167198 Oak St, Tempe, AZ, 852360.48Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-136602ENRAaron Reid1968-04-25UHC-10885-7676457959131642 Apache Blvd, Miami, FL, 331460.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62272TPAAustin Gibson1985-01-01——8410 Sage Ct, Seattle, WA, 981370.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-114555ENRMei N Gibson1976-07-16UHC-57095-0953732600778772 Union St, Seattle, WA, 981210.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-422814CLMNatalie Ferguson1942-05-16UHC-75951-2355167531468350 Hillcrest Rd, Tempe, AZ, 852060.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-134944ENRSandra Martin2003-11-26UHC-35036-0497785383415929 Indian School Rd, Columbus, OH, 432270.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-140890ENRIsabella Parrk1943-09-21UHC-62319-5689434379232082 Lake View Rd, Minneapolis, MN, 554500.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-418946CLMPat Ford1991-01-12—90433071446567 Mountain View Dr, Mesa, AZ, 852350.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-111204ENRGregory Martinez1950-05-21UHC-78137-3080333773454284 Jefferson Ave, Las Vegas, NV, 891720.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-102177ENRGrace M Valdez2002-08-14UHC-35478-1696868211892005 Elm St, Jacksonville, FL, 322980.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-136206ENRMargaret Ryan1961-09-12UHC-30630-7824188577343627 Mountain View Dr, Nashville, TN, 372290.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
PRV-27837PRVRalph Kelley1975-09-22UHC-28952-8283958799041320 Pine Dr, Tempe, AZ0.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-141777ENRMason I Mason1956-07-17UHC-59847-779004442189682 Main St, Columbus, OH, 432450.48Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-127510ENRElijah Phillips1995-11-21UHC-93293-7795250915432832 Baseline Rd # 432, Sacramento, CA, 958200.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
100,000 rows, page 64 of 2,000PreviousNext