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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-135963ENRHenry V Obrien1954-02-08UHC-71537-8024091651201614 Camelback Rd, Atlanta, GA0.54Name re-casedState name converted to codeZIP missingGender normalised+1 more
ENR-108795ENRKelly B Richards1995-06-22UHC-61615-4886526591287406 Pine Dr, Orlando, FL0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-102019ENRJulie L Washington1939-10-25UHC-19375-2746620155174718 Union St, Scottsdale, AZ, 852980.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-102250ENRPatricia N Price1985-05-18UHC-93968-0360787485268942 Apache Blvd, Phoenix, AZ, 850970.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-104704ENRMary B Miills1967-01-21——2271 Central Ave, Tampa, FL, 336660.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-115579ENRHenry Yang1987-12-03UHC-64402-8971176058274104 Highland Ave, Dallas, TX, 752980.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133891ENRAshley H Castro—UHC-29387-6384663034771834 Jefferson Ave, Austin, TX, 787300.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-119868ENRJoseph Vasquez2003-04-28UHC-79306-78—7705 Willow Ct Apt 7, Miami, FL, 331710.54Name split from “Last, First”Date of birth reformattedUnit split from streetState name converted to code+1 more
ENR-119008ENRVincent F Holmes1948-03-13UHC-50225-8876467461038436 Spring St Apt 26, Mesa, AZ0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-104333ENRTeresa Hayes1962-10-05UHC-81477-9726236785462774 Pine Dr, Gilbert, AZ0.54Phone reformattedState name converted to codeZIP missingGender normalised+1 more
ENR-135840ENRKaren T Lopez—UHC-99332-0768880451704053 Grand Ave, Orlando, FL, 328500.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-130644ENRBetty Gonzalez1961-05-12UHC-67685-4476631610148432 Canyon Rd, Plano, TX, 750270.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-104441ENRKevin J Cunningham2002-07-11UHC-11004-7683285557217149 Park Pl, Los Angeles, CA, 900830.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-129050ENRCamila Jenkins1941-05-25UHC-40064-2171828867147015 Palm Dr, Los Angeles, CA, 900210.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-119075ENRAmanda Perkins1943-02-19UHC-49827-3776334851865497 Forest Ave, Phoenix, AZ, 850090.54Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-125050ENREdward T Park1938-02-05UHC-91172-7175778599807334 Oak St, Seattle, WA, 981400.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-108137ENRDinae A Garrett2001-11-06—48896633724719 Bayshore Dr, Gilbert, AZ, 852280.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-138366ENRBrian Medina1968-10-16UHC-58175-2126342801532973 Highland Ave, Miami, FL, 331780.54Name re-casedTwo-digit birth yearPhone reformattedState name converted to code+1 more
ENR-118339ENRDonna Ortega—UHC-71161-8635688857647419 Church St, Glendale, AZ0.54Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-105131ENRElijah P Pena1997-09-16UHC-72695-92—5445 Canyon Rd, Sacramento, CA, 958850.54SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-135543ENRKyle Taylor1943-03-04UHC-59965-33—8402 Grand Ave, Eden Prairie, MN, 553890.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117885ENRGregory Sullivan1947-01-05UHC-86749-5634425452657934 Cedar Ln, Mesa, AZ0.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-130505ENRLauren Porter1962-08-04UHC-47113-19—1731 Harbor Blvd, Orlando, FL, 328920.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-140297ENRKathleen Z Fisher1953-08-12UHC-98423-3297562695555400 Sunset Blvd Apt 8, Nashville, TN, 372190.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-111977ENRKenneth X Carroll—UHC-91935-8527766743975265 Maple Ave, Dallas, TX, 752980.54Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+1 more
ENR-100068ENRHamilton Wayne1947-06-25UHC-36182-0260658913374635 Forest Ave, Tucson, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-112686ENRJon Ortiz1970-05-23UHC-59920-83—4816 Park Pl, Minneapolis, MN, 554700.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-124950ENRPeter E Harris1953-02-27UHC-36327-95—6807 Hillcrest Rd # 322, Eden Prairie, MN, 553080.54Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+1 more
ENR-128334ENRVictoria Q Barnes2003-11-26UHC-54618-1030198011471900 Ocean Ave, Charlotte, NC, 282510.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133438ENREvelyn Nelson—UHC-74997-91—9742 Park Pl, Tempe, AZ, 852420.54Date of birth missingSSN last four extractedCity re-casedZIP+4 trimmed+1 more
ENR-138589ENRDouglas X Lewis1967-09-08UHC-76690-56—560 Spring St # 509, Dallas, TX, 752540.54Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+1 more
ENR-118550ENRAna A Willis1954-03-06UHC-64569-46—7807 Apache Blvd, Chandler, AZ, 852100.54Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-116311ENRPamela West—UHC-98149-66—2946 Sage Ct, Austin, TX, 787940.54Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-100152ENRMariana A Turnr1997-07-23UHC-20164-1234371197109224 Sage Ct, Nashville, TN, 372640.54Phone reformattedSSN last four extractedState name converted to codeZIP+4 trimmed+1 more
ENR-100420ENRRobert B Harris1983-10-27UHC-42531-3487836306187190 Main St, Charlotte, NC, 282900.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-127145ENRBrenda M Mroeno1976-06-16UHC-64839-494346432900512 Grand Ave, Tempe, AZ, 852020.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-140789ENRPeter H Banks1991-12-21UHC-77412-58—7123 Ridge Rd # 814, Orlando, FL, 328920.54Name split from “Last, First”Unit split from streetState name converted to codeWhitespace trimmed+1 more
ENR-110475ENRWillie Q Robertson1995-12-22UHC-50774-3381078443027551 Bayshore Dr, Phoenix, AZ, 850260.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-110476ENRWillie Q Robertson1995-12-22UHC-50774-3381078443027551 Bayshore Dr, Phoenix, AZ, 850260.54Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-126866ENRJose Gibson1990-06-22UHC-92557-223799991748253 Oak St, San Diego, CA, 921940.54Date of birth reformattedPhone reformattedSSN last four extractedZIP+4 trimmed+1 more
ENR-118283ENRChristina F Owens1984-12-01UHC-32060-5551132120852607 Spring St, Miami, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-124632ENRSean Dean2007-04-28UHC-44580-15—592 Bayshore Dr Apt 1, Houston, TX, 770790.54Name split from “Last, First”Date of birth reformattedUnit split from streetState name converted to code+1 more
ENR-110378ENRKyle P Mason1952-03-09UHC-06799-9485455931915448 Ocean Ave, Denver, CO0.54Name split from “Last, First”Phone reformattedZIP missingGender normalised+1 more
ENR-131767ENRJordan I Sims1976-10-19UHC-55681-8939330769526337 Main St, San Antonio, TX, 782180.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-101256ENRCristian B Knight—UHC-56122-73—5667 Broadway, San Antonio, TX0.54Date of birth missingCity re-casedState name converted to codeZIP missing+1 more
ENR-133088ENRDiego O Anderson1988-08-17UHC-62497-7782966170564945 Canyon Rd Apt 30, Houston, TX, 770120.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-142944ENRHelan Grant1960-12-26UHC-36560-363578612308135 Lake View Rd, Tucson, AZ, 857600.54Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
ENR-101208ENRJoe H Romero1978-01-13UHC-67411-72—6458 Highland Ave, Jacksonville, FL, 322740.54Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-112415ENRAhmed T Le2003-06-10UHC-34122-14—1420 Washington St, Las Vegas, NV, 891250.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-120045ENREmily Contreras1984-11-12UHC-92691-0540198514431247 Baseline Rd, San Antonio, TX, 782200.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
43,101 rows, page 104 of 863PreviousNext