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-109645ENRCharlotte E Saanchez1994-04-17UHC-17804-0474586450917218 Washington St # 498, Orlando, FL, 328450.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
ENR-136366ENRAlbert B Chavez1998-08-22UHC-44798-0757338047281017 Central Ave, San Antonio, TX, 782330.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-119568ENRDoris N Laswon1997-10-27UHC-56459-0856729681757664 Cedar Ln, San Antonio, TX, 782620.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-102561ENRElizabeth C Hamilton1950-12-01UHC-48977-8678547423644500 Maple Ave # 816, Seattle, WA, 981960.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
ENR-132570ENREric E Lopez2005-06-03UHC-22440-9463342988604847 Market St, Scottsdale, AZ, 852030.62Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
ENR-120634ENRSharon L Hanson1981-04-25UHC-31736-8664087965228200 Oak St, Tampa, FL, 336850.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
ENR-128999ENRBruce Little1939-07-09UHC-57607-9377950545975733 Baseline Rd, Los Angeles, CA0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120695ENRPatricia Y Oliver1956-09-08UHC-10035-0224175750543500 Cedar Ln, Mesa, AZ, 852800.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122388ENRCooer Joan1991-01-05UHC-11316-5729951735522610 Sage Ct, Jacksonville, FL, 322720.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-123551ENRGeorge Silva1972-09-06UHC-43784-68—9064 Camelback Rd, Glendale, AZ0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133364ENRAshley N Woods1974-05-27UHC-73202-2952767815978709 Oak St, Eden Prairie, MN, 553830.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133365ENRAshley N Woods1974-05-27UHC-73202-2952767815978709 Oak St, Eden Prairie, MN, 553830.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125446ENRGrace C Henry1966-01-23UHC-49759-8844840134451034 Cedar Ln, Mesa, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125223ENRYuki Perkins1967-05-28UHC-55774-2388185181565842 Jefferson Ave, Gilbert, AZ, 852630.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-119969ENREdward E Garcia1942-12-09UHC-82255-2148186025445691 Lincoln Way, Austin, TX, 787860.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110492ENREthan N Fields1982-11-04UHC-38617-4957958656548099 Ridge Rd, Gilbert, AZ, 852540.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127661ENRKatherine W Adams1942-07-08UHC-28383-126486388366554 Park Pl, Los Angeles, CA0.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-138363ENRAlan McDonald1978-06-07UHC-93299-857688792119775 Jefferson Ave, Orlando, FL, 328140.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-117359ENRAlbert Fisher1971-06-06UHC-40609-8256197619148806 Park Pl, San Antonio, TX, 782120.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-119551ENRGregory U Ramos1984-08-11UHC-69287-983377004135843 Harbor Blvd, Nashville, TN, 372020.62Date of birth reformattedPhone reformattedCity re-casedState name converted to code+3 more
ENR-132129ENRBeverly Soto1948-01-21UHC-14300-4664369093993256 Elm St, Orlando, FL, 328690.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-112252ENRPat O Webb1991-07-23UHC-74916-65938751901431 Palm Dr, Jacksonville, FL, 322660.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140498ENRNoah Black1994-02-07UHC-57024-9587328612231296 Willow Ct # 287, Chandler, AZ, 852280.62Phone reformattedMember ID reformattedUnit split from streetStreet suffix standardised+3 more
ENR-102369ENRPatrick U Franklin1976-12-05UHC-08591-47—8100 Camelback Rd # 181, Tempe, AZ, 852490.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-121469ENRLucia J Fuller1976-05-01UHC-16929-8225723832988952 Park Pl, Fresno, CA, 937300.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110986ENRJustin Q Wright1963-11-15UHC-25235-54—4940 Elm St, Plano, TX, 750570.62Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
ENR-135802ENRFatima F Freeman1986-09-04UHC-38123-2654382163986623 Church St, Glendale, AZ, 853780.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-124926ENRCarol B Gibson1941-01-10UHC-92939-3434652222036007 Oak St, Tempe, AZ, 852350.62Name split from “Last, First”Date of birth reformattedPhone reformattedCity re-cased+3 more
ENR-136009ENRAhmed N Grant1988-04-16UHC-81442-4923075584008056 Sage Ct Apt 20, Nashville, TN, 372790.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
ENR-100801ENRLerry S Richardson—UHC-30947-57—8965 Palm Dr, Phoenix, AZ, 850940.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
ENR-108685ENRJean Young1984-04-15UHC-65180-97—9692 Canyon Rd, Dallas, TX, 752210.62Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125985ENRChristina W Lewis1955-08-23UHC-10969-4453485967428303 Indian School Rd, Chandler, AZ0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-139830ENRTomas Robinson1986-01-11UHC-59732-2732295272038098 Sunset Blvd, Miami, FL, 331690.62Date of birth reformattedPhone reformattedSSN last four extractedCity re-cased+3 more
ENR-109408ENRHenry E Miller1963-04-22UHC-82425-5239476735525024 Valley View Dr, Los Angeles, CA, 900430.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-142832ENRSandra C Simpson1957-03-28UHC-38213-6579357573796764 Apache Blvd, San Antonio, TX, 782260.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127900ENRJanet E Brown1939-08-23UHC-78003-2061972997201614 Washington St, Dallas, TX, 752880.62Street suffix standardisedAddress re-casedCity re-casedEmail lower-cased+3 more
ENR-114241ENRAlexis W Freeman1939-02-06UHC-84619-947013294433199 Bayshore Dr, Charlotte, NC, 282900.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
ENR-102876ENRRoger I Kennedy2008-08-26UHC-64119-9084683936563119 Desert Sky Blvd, Tampa, FL, 336150.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-134426ENRAlan O Greene1944-11-23UHC-55208-9553973317499748 Oak St, Columbus, OH, 432430.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-104484ENRBaker F Roy1990-07-17UHC-57070-1425564903673701 Washington St, Tampa, FL, 336070.62Middle initial moved out of first nameName re-casedDate of birth reformattedPhone reformatted+3 more
ENR-113520ENRAmber T Wong1996-09-06UHC-10320-6452394318362507 Harbor Blvd, Scottsdale, AZ, 852840.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-108713ENRDonald Torres1963-09-18UHC-28843-5675874857544999 Jefferson Ave, Charlotte, NC, 282400.62Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-116259ENRJanice T Hanson1966-12-14UHC-80875-4885071437005303 Willow Ct, Tempe, AZ, 852710.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-122814ENRGeorge Mejia1981-02-28UHC-53320-7038632464066007 Lake View Rd, Dallas, TX, 752570.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-125879ENRJack Byrant1943-03-28UHC-24204-3932232827685800 Willow Ct, Sacramento, CA, 958280.62Name split from “Last, First”Date of birth reformattedPhone reformattedMember ID reformatted+3 more
ENR-105712ENRCatherine A Richardson1988-01-10UHC-00641-2142482231464471 Elm St, Seattle, WA, 981890.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-110168ENRRonald Harrison2004-05-22UHC-33242-3563532812128077 Maple Ave, Denver, CO, 802670.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-142316ENRGeorge U Sims1980-09-19UHC-72547-6950228444766943 Lincoln Way, Jacksonville, FL, 322660.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-125960ENRAmber P Bradley1985-11-09UHC-76447-81399719962661 Market St, Houston, TX, 770430.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-102239ENRJacob V Diaz1951-10-15UHC-98946-09262935769537 Camelback Rd, Glendale, AZ, 853270.62Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+3 more
43,101 rows, page 140 of 863PreviousNext