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-61115TPAKaren Owens2002-09-07——4662 Harbor Blvd, Minneapolis, MN, 554810.82City re-casedGender normalisedPlaceholder values cleared
TPA-52241TPASantiago Kelly2003-06-14—34775589571154 Desert Sky Blvd, Miami, FL, 331450.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-56345TPASara Harper1994-03-15———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-56461TPAAlbert Brooks1974-06-08——3371 Elm St, Tempe, AZ, 852590.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-57070TPAMichelle P Taylor2003-11-02——9367 Park Pl, Tucson, AZ, 857900.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
TPA-57948TPALisa Lee1970-07-14—5949070880589 Elm St, Nashville, TN, 372270.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-55085TPAMichelle Hudson1939-08-23——3593 Main St, Los Angeles, CA, 900170.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-55248TPABarbara Marshall———4996 Central Ave, Jacksonville, FL, 322010.82Date of birth unreadableCity re-casedPlaceholder values cleared
TPA-50819TPAEmma P Lopez1982-07-16UHC-06552-137443418913932 Harbor Blvd, Tampa, FL, 336520.82Name split from “Last, First”Date of birth reformattedWhitespace trimmed
TPA-54743TPABenjamin Turner——3579393116—0.82Date of birth unreadablePhone reformattedPlaceholder values cleared
TPA-52589TPABrittany Johnston2005-06-16———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55559TPAOmar Baker1982-12-17——5030 Desert Sky Blvd, Orlando, FL, 328080.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56126TPAHiroshi Green1992-07-05———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-53099TPAAlexander Yang2004-01-15——9877 Lake View Rd, Seattle, WA, 981680.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58642TPANathan Q Robertson1997-07-22——8063 Meadow Ln, Mesa, AZ, 852740.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57502TPAMason Mills2000-04-22——2476 Main St Apt 39, Glendale, AZ, 853730.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-50575TPAAndrew Fields1995-03-23UHC-34165-43——0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-62516TPAScott Medina1938-03-06——637 Spring St, Orlando, FL, 328550.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-61621TPAGerald Harrison1965-08-14——6815 Market St, Miami, FL, 331900.82City re-casedState name converted to codePlaceholder values cleared
TPA-62575TPAMegan Edwards2006-06-04———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-63021TPABrenda Nelson1990-11-03—51396469232173 Indian School Rd, Tampa, FL, 336430.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-57055TPANoah Y Hughes1954-12-24——7724 Bayshore Dr, Tempe, AZ, 852460.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-55142TPANicholas Ryan2006-10-26——565 Sunset Blvd, Phoenix, AZ, 850300.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52858TPAMateo Vazquez1964-10-05UHC-94454-99——0.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-56920TPABrandon Hicks1956-09-03—56554337676150 Jefferson Ave, Los Angeles, CA, 900880.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-59465TPADanielle H Weaver1975-04-25——2761 Maple Ave, Houston, TX, 770110.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-63973TPAChristian McDonald1954-04-03——2592 Forest Ave, Glendale, AZ, 853220.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53597TPAAlan E Harrison1954-01-20——3847 Grand Ave, Nashville, TN, 372530.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-62414TPADeborah Fox1982-06-04——3808 Highland Ave Apt 36, Houston, TX, 770590.82Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-57786TPAJennifer F Henry1980-01-17——2409 Oak St, Jacksonville, FL, 322160.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51835TPADorys Welch1950-07-19—44289154562676 Forest Ave, Houston, TX, 770700.82Name split from “Last, First”City re-casedPlaceholder values cleared
TPA-55205TPAAaron Sandoval2006-04-13——8939 Valley View Dr, Jacksonville, FL, 322200.82Date of birth reformattedState name converted to codePlaceholder values cleared
TPA-59052TPAMary Chapman2004-11-23—2854630759—0.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-52926TPAIsabella Flores2000-06-04——3163 Forest Ave, Plano, TX, 750000.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52991TPAPat Hart1974-05-14———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-62880TPAMei D Griffin1994-03-17——9170 Union St, Tucson, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-53213TPAChristopher Cooper1968-04-23———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-59498TPAMark Silva1987-12-04——7641 Ocean Ave, Chandler, AZ, 852510.82Name split from “Last, First”State code upper-casedPlaceholder values cleared
TPA-50154TPAGrace Burton1981-01-26——8064 Maple Ave, Columbus, OH, 432790.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-57884TPARaymond Palmer1983-06-22——4428 Church St, Fresno, CA, 937750.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60494TPAKevin G Fwler1963-10-01UHC-05853-80——0.82Member ID reformattedSSN last four extractedPlaceholder values cleared
TPA-60018TPAKyle Butler1991-11-28——1483 Canyon Rd, Charlotte, NC, 282680.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60306TPAJustin Fields2004-07-17——6799 Mesa Dr, Chandler, AZ, 852880.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55001TPAElizabeth Ray1992-01-25——7416 Oak St, Las Vegas, NV, 891860.82Name re-casedGender normalisedPlaceholder values cleared
TPA-60186TPAKelly Lucas1947-12-15UHC-15635-05——0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-60185TPAKelly Lucas1947-12-15UHC-15635-05——0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-61404TPALucia Edwards1957-07-22——8838 Forest Ave, Phoenix, AZ, 850400.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-56686TPAFatima Maldonado1960-05-25——1172 Apache Blvd, Dallas, TX, 752440.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58506TPARoger Burton1957-03-22——9068 Hillcrest Rd, Scottsdale, AZ, 852430.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52384TPAMari Ramireez1999-04-23UHC-45453-34—1102 Market St, Los Angeles, CA, 900370.82Gender normalisedWhitespace trimmedPlaceholder values cleared
14,474 rows, page 213 of 290PreviousNext