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-51908TPAJeremy J Chapman1985-12-26UHC-44520-7635866433075814 Forest Ave, Miami, FL, 331590.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54386TPAKyle Alexander1961-02-18—47895155009366 Elm St, Scottsdale, AZ, 852980.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63775TPAVirginia Fernandez1973-06-03——3072 Ocean Ave, Jacksonville, FL, 322150.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-52351TPASantiago Day1998-05-03——9850 Church St, Las Vegas, NV, 891310.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60918TPAHannah Howard1944-04-28——2648 River Rd, Chandler, AZ0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56734TPATimothy Weber1954-08-04——3331 Mountain View Dr, Plano, TX, 750030.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-54988TPANicholas Sanders1987-06-19—94790700067213 Pine Dr Apt 24, Houston, TX, 770360.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-57869TPANathan Parker1951-06-24——2088 Desert Sky Blvd, Chandler, AZ, 852880.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-61799TPACharles Robinson1973-01-24—45553140873748 Ocean Ave, Tempe, AZ, 852770.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61687TPAEvelyn Palmer1997-04-03——8011 Church St, Tucson, AZ, 857580.64Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-55927TPAMelissa Palmer1959-06-18——1888 Cedar Ln, Denver, CO, 802670.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-54763TPASara M Kennedy2000-01-08—82763737175858 Elm St, Denver, CO0.64Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61440TPABetty Morris1960-12-10——3269 Grand Ave, Eden Prairie, MN, 553420.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51702TPAAlbert Patel1949-03-17——7524 Forest Ave, Fresno, CA0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54834TPAFatima Collins1999-12-24—63430535819073 Lincoln Way, Denver, CO, 802050.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-53783TPAKathryn Singh1939-06-05——8283 Cedar Ln, Austin, TX, 787670.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61469TPABrucce Mitchell2007-07-23—68948256305344 Ridge Rd # 434, Austin, TX, 787450.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-54183TPAMartha Singh———3687 Pine Dr, Jacksonville, FL, 322780.64Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62221TPASofia Arnold1973-09-13UHC-41265-38—423 Market St, Sacramento, CA, 958430.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-57337TPAKyle Olson1947-03-01UHC-95004-6557872380915525 Apache Blvd, Mesa, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54730TPABobby Price1980-05-25—91382444499033 Ocean Ave, Las Vegas, NV, 891860.64Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-64226TPAPiya Burke1976-02-15—95666595001398 Ridge Rd, Chandler, AZ, 852680.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-52742TPARonald Reed1947-10-26——9356 Forest Ave, Jacksonville, FL, 322540.64Name split from “Last, First”Date of birth reformattedCity re-casedGender normalised+2 more
TPA-58704TPAFrakn Crawford1956-03-28—2973393821964 Ocean Ave, Jacksonville, FL0.64Name re-casedZIP missingEmail lower-casedGender normalised+2 more
TPA-52720TPAKyle Wadr1996-05-14UHC-48973-108283322137131 Canyon Rd, Columbus, OH, 432270.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-57614TPACharlotte Gibson1948-07-04——7647 Baseline Rd, Glendale, AZ, 853020.64Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-64258TPAAnderson Carlos1946-02-24——965 Spring St # 149, Sacramento, CA, 958100.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57383TPARalph Sullivan1944-12-18——19 Washington St, Orlando, FL, 328670.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-51411TPAAdma Burke1940-09-04——1835 Hillcrest Rd, Nashville, TN, 372490.64Name re-casedTwo-digit birth yearCity re-casedGender normalised+2 more
TPA-56747TPACarolyn Fisher1959-11-11——1539 Apache Blvd, Tucson, AZ, 857310.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-54895TPAKaren Shaaw1995-04-08——9539 Camelback Rd Apt 26, Austin, TX, 787450.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62703TPAPatricia Colleman1958-05-18—6429868458—0.64Name split from “Last, First”Date of birth reformattedPhone reformattedGender normalised+2 more
TPA-50118TPAJean Vargas1994-08-16——8065 Meadow Ln, Chandler, AZ, 852650.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-57991TPAEmily Chen1949-03-07——8476 Palm Dr, Glendale, AZ, 853810.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-64115TPAKevin Mitchell——3749794017661 Valley View Dr, Dallas, TX, 752230.64Name re-casedDate of birth missingPhone reformattedStreet suffix standardised+2 more
TPA-62164TPAKimberly Elliott1980-04-02UHC-63437-77—5434 Hillcrest Rd, Seattle, WA, 981570.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-59862TPAEdward Z Sims1993-02-01——1338 Hillcrest Rd, Houston, TX, 770510.64Name re-casedTwo-digit birth yearState code upper-casedZIP+4 trimmed+2 more
TPA-60766TPADennis Ford1939-10-12——8159 Desert Sky Blvd, Fresno, CA, 937520.64Date of birth reformattedZIP+4 trimmedEmail lower-casedGender normalised+2 more
TPA-63064TPAAhmde Sanders1970-10-02—74499305957646 Willow Ct, Atlanta, GA, 303100.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59000TPALogan Welch1980-07-17—4845052970585 Washington St, Mesa, AZ, 852080.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-54371TPAMason P Brooks——7724223662563 Lake View Rd, San Diego, CA, 921740.64Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56867TPABarbara Brown1968-11-14—73090868901741 Market St, Jacksonville, FL, 322300.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61848TPATheresa Gonzales1981-09-04——6783 Meadow Ln, Tempe, AZ, 852910.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61710TPAAmanda McDonald1961-09-28——6337 Apache Blvd, Miami, FL, 331780.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-52060TPANanncy Bailey1983-09-05—74129408644842 Lincoln Way, Tampa, FL, 336250.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53659TPAGary West1998-01-17—98166124006358 Ocean Ave, Columbus, OH, 432780.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-54893TPAPatrick Alexander1969-08-09——1326 River Rd, Austin, TX, 787210.64Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
TPA-54505TPAEdwrad Cole1994-09-24——9543 Forest Ave, Fresno, CA, 937630.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-62564TPAAmber E Obrien1986-01-02——8267 Spring St, Houston, TX, 770310.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58849TPAAndrea Kim1945-04-05——4014 Washington St, Charlotte, NC, 282550.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
14,474 rows, page 68 of 290PreviousNext