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-138872ENRRichard Carpenter1973-01-14UHC-63811-1672122807841751 Elm St, Fresno, CA0.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136602ENRAaron Reid1968-04-25UHC-10885-7676457959131642 Apache Blvd, Miami, FL, 331460.48Name re-casedPhone reformattedStreet 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
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
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
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
ENR-119428ENRBarbara K Lynch1961-05-26UHC-36424-1540082448186512 Sage Ct, Nashville, TN, 372580.48Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-117825ENRFatima Espinoza1944-08-11UHC-02164-7068354674997168 Church St, Denver, CO, 802210.48Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-114015ENRSteven Campbell1996-09-20UHC-56403-1344327949925909 Central Ave, Orlando, FL, 328980.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-102246ENRChristian S Roobinson1950-02-06UHC-15823-8490757725014202 Grand Ave, Denver, CO, 802930.48Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-122741ENRJerry E Contreras1983-12-09UHC-90619-6093442805331086 Lincoln Way, Houston, TX0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-101466ENRChristopher U Montgomery2002-04-21UHC-85412-78—3292 Apache Blvd, Tampa, FL, 336230.48Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-138552ENRMichael N Montgomery1992-03-02UHC-33107-3422344608883406 Union St, Nashville, TN, 372730.48Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-129487ENRJudy Z Foster2002-03-24UHC-43426-863396578993638 Harbor Blvd, Minneapolis, MN0.48Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+4 more
ENR-132685ENRMason O Bradley1986-07-19UHC-43681-0352993200072852 Apache Blvd, Minneapolis, MN, 554140.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-110759ENRRoy Sandoval1991-08-11UHC-79513-08—1003 Church St, Jacksonville, FL0.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-112139ENRDennis T Bryant1949-10-22UHC-30043-1557538657671329 Hillcrest Rd, Dallas, TX, 752340.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-126202ENRJoan Le1962-09-25UHC-35979-4986333548782959 Maple Ave, San Diego, CA, 921210.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-100353ENRSara G Obrien1909-10-09UHC-90658-18—8262 Elm St, Minneapolis, MN, 554080.48Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+4 more
ENR-100182ENRMargaret Reyes1990-05-04UHC-72818-4668529226242556 Lake View Rd Apt 12, Tampa, FL0.48Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-110350ENRBrittany Q Graham1987-01-04UHC-81173-0953760236133057 Sunset Blvd, Tampa, FL, 336350.48Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133537ENRJean Brooks2004-02-06UHC-50329-0479795980879313 Meadow Ln, Tampa, FL, 336710.48Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-103778ENRKayla Thompson1999-03-06UHC-07497-4343257950837048 Cedar Ln, Tucson, AZ, 857090.48Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127977ENRPatricia Perry1975-08-04UHC-59294-1633255615296200 Grand Ave, Las Vegas, NV, 891140.48Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-136059ENRJesse Miller1943-04-13UHC-45991-1046248212791014 Jefferson Ave # 795, Seattle, WA, 981260.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-103675ENRMartha G Sanchez—UHC-34396-4572898754903891 Camelback Rd, Seattle, WA, 981860.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-125627ENRCarolyn W Ortiz1983-01-27UHC-39963-2339582413994744 Cedar Ln, Miami, FL, 331790.48Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-142646ENRCheryl Gibson1999-05-15UHC-20991-8529448190186044 Willow Ct, Los Angeles, CA0.48Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+4 more
ENR-100070ENRKaren A Green1978-04-13UHC-50857-0697632882956560 Ocean Ave, Chandler, AZ, 852530.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-141819ENRLawrence U Scott1993-10-27UHC-71983-4231765233149111 Pine Dr, Chandler, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-104393ENRBen Stewart1945-06-25UHC-28478-4333147139602391 Willow Ct, Tempe, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-136662ENRJeffrey B Hunter1974-07-13UHC-42787-3437040643623234 Sage Ct, San Diego, CA, 921760.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123609ENRSophia Q Robertson1962-08-17UHC-54909-8827449786957990 Church St, Atlanta, GA, 303950.48Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-132323ENRScott M Singh—UHC-17288-4377920450301717 Hillcrest Rd, Sacramento, CA, 958330.48Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108330ENRJason P Perez1944-06-15UHC-44943-1195196515667980 Maple Ave, Fresno, CA0.48Name re-casedDate of birth reformattedPhone reformattedState name converted to code+4 more
ENR-129787ENREvelyn J Marshall1991-07-27UHC-36370-75—2509 Spring St, Atlanta, GA, 303210.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-116294ENRBrandon Munoz—UHC-58272-47—7696 Highland Ave, Tempe, AZ, 852650.48Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+4 more
ENR-140185ENRMateo Schultz1941-01-21UHC-87360-2667326005937638 Ocean Ave, Denver, CO, 802860.48Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-123966ENRNoah Gutierrez2005-12-01UHC-54159-412576707157179 Meadow Ln, Miami, FL, 331010.48Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-101511ENRHarold P Austin1959-09-14UHC-07743-2753297378012299 Main St Apt 31, Tempe, AZ0.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-142774ENRArtthur X Howell1960-09-28UHC-88241-33—2865 Indian School Rd, Glendale, AZ0.48Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
ENR-117822ENRKeith T Banks1959-07-01UHC-64031-6642064151388804 Camelback Rd, Las Vegas, NV, 891710.48Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-116553ENRJeremy J Vega1950-08-16UHC-56071-6567581859891820 Park Pl, Sacramento, CA, 958690.48Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+4 more
ENR-112201ENRDaniel T Pena1978-06-28UHC-03725-4325669909569596 Meadow Ln, Los Angeles, CA, 900350.48Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-100176ENRBetty Weaver1963-08-01UHC-27224-845137176082662 Palm Dr, Glendale, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108475ENRJason S Ortiz1967-02-28UHC-90014-4233349559526807 Highland Ave, Chandler, AZ0.48Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
43,101 rows, page 35 of 863PreviousNext