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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-59903TPALori Wang1973-04-24———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-56625TPADanielle Kelley2003-01-07——3285 Forest Ave, Fresno, CA, 937150.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57771TPANicole Butler1997-01-10UHC-48354-10——0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-50071TPAWashington Paul1978-03-11——3488 Central Ave, San Diego, CA, 921880.82Name re-casedGender normalisedPlaceholder values cleared
TPA-54442TPASamuel Tucker1993-06-19———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55052TPAMarcus Arnold———9643 Cedar Ln, San Diego, CA, 921180.82Date of birth missingEmail lower-casedWhitespace trimmed
TPA-60672TPAStephanie Porter1974-01-20——3850 Jefferson Ave, Los Angeles, CA, 900860.82State name converted to codeWhitespace trimmedPlaceholder values cleared
TPA-60149TPAKaren Green1953-06-27———0.82Two-digit birth yearPlan code upper-casedPlaceholder values cleared
TPA-59720TPARalph Espinoza1983-11-01—4522005935—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-52572TPAJacob Sullivan2008-05-24——1349 Ocean Ave, Scottsdale, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-54279TPAFrances T Chen1986-11-13——1441 Grand Ave, Gilbert, AZ, 852420.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-60897TPARonald Valdez1978-10-18——9019 Central Ave, Jacksonville, FL, 322340.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63398TPAOmar Hamilton1962-12-08———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-63731TPAPamela Bailey1976-09-06——3492 Meadow Ln, Eden Prairie, MN, 553730.82SSN last four extractedWhitespace trimmedPlaceholder values cleared
TPA-53609TPASandra Ryan1995-12-02——3076 Spring St, Chandler, AZ, 852500.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61290TPAAshley Valdez1991-07-04——9171 Main St, Miami, FL, 331920.82Name re-casedGender normalisedPlaceholder values cleared
TPA-52424TPALori Fowler1972-10-21——194 Church St, Tampa, FL0.82ZIP missingEmail lower-casedPlaceholder values cleared
TPA-62518TPAMegan Maldonado1998-02-15———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-64013TPACarolyn Spencer1938-09-09——9870 Oak St, Atlanta, GA, 303340.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-57823TPACeryl Cunningham1963-02-20——9223 Elm St, Seattle, WA, 981920.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64043TPALauren P Thomas1956-10-12——8053 Pine Dr, San Diego, CA, 921430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56817TPAMei Hart1961-06-13—49267845846536 Mesa Dr, Sacramento, CA, 958430.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-58074TPADenise Ward1959-07-06—96943747728358 Lake View Rd, Miami, FL, 331130.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-59804TPABetty Black2008-06-15—83458405735994 Highland Ave, Charlotte, NC0.82Date of birth reformattedZIP missingPlaceholder values cleared
TPA-57514TPAJonathan Ford1955-02-08——1229 Broadway, Nashville, TN, 372790.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-59108TPARoy Andrewws1942-06-18—4702131669—0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-63446TPAJuan Munoz1945-07-17——9843 Central Ave, Tempe, AZ, 852150.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63447TPAJuan Munoz1945-07-17——9843 Central Ave, Tempe, AZ, 852150.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54616TPABradley Perkins2003-08-26—4055901924616 Lincoln Way, Sacramento, CA, 958980.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-55989TPAHannah Day1991-08-23——914 Indian School Rd, Minneapolis, MN, 554690.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-52515TPAKenneth Medina1992-03-26——4894 Ocean Ave, Las Vegas, NV, 891120.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59366TPAAmanda Hall2005-05-01——9017 Church St, Mesa, AZ, 852150.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62730TPARobert Cole1997-08-17——8349 Sage Ct, Minneapolis, MN, 554980.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61256TPAArthur O Contreras1948-04-08—30345214901470 Canyon Rd, Charlotte, NC, 282990.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-64360TPARussell Jacobs1986-02-10——3278 Spring St, Denver, CO, 802250.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55706TPAGrgeory Schultz1969-02-25——5342 Lincoln Way, Las Vegas, NV, 891940.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-51045TPAKeith Price1986-07-18—48957285989495 Palm Dr, Austin, TX, 787490.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-50756TPAAlexander R Marquez1969-06-04—75528374495581 Lincoln Way, Minneapolis, MN0.82Phone reformattedZIP missingPlaceholder values cleared
TPA-50404TPABrandon Munoz1965-08-06—4199034858466 Desert Sky Blvd, Jacksonville, FL, 322530.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-64003TPASamantha Thompson1977-08-09UHC-17634-87—5712 Pine Dr, Glendale, AZ, 853060.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51571TPAHarold Ward1957-12-22——8758 Camelback Rd, Los Angeles, CA, 900760.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59217TPAWilliam Freeman1954-03-22——765 Highland Ave, Plano, TX, 750710.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52077TPANatalie Welch1981-10-07UHC-77444-76—218 Valley View Dr, Tempe, AZ, 852740.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59740TPASandra Robertson1970-03-20UHC-96193-90—8779 Baseline Rd, Mesa, AZ, 852750.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52791TPAEmily Cruz2006-02-24——9514 Spring St, Mesa, AZ, 852450.82Name re-casedGender normalisedPlaceholder values cleared
TPA-52631TPASteve Ortega1941-03-27——1456 Jefferson Ave, Tempe, AZ, 852390.82Name re-casedState name converted to codePlaceholder values cleared
TPA-55764TPAChristopher Ward1976-10-01UHC-13167-68—886 Jefferson Ave, San Diego, CA, 921780.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-63237TPATerry Henderrson1940-10-05UHC-17287-55—6152 Meadow Ln, Minneapolis, MN, 554610.82Street suffix standardisedAddress re-casedWhitespace trimmed
TPA-62663TPAAustin W Allen1993-03-24—39936047702083 Cedar Ln, Phoenix, AZ, 850790.82Phone reformattedState name converted to codePlaceholder values cleared
TPA-56416TPAIsabella Sanchez1952-07-26UHC-07904-9195752664633413 Valley View Dr, San Antonio, TX, 782840.82Name split from “Last, First”Phone reformattedMember ID reformatted
14,474 rows, page 209 of 290PreviousNext