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-53277TPAOlivia Turner1961-10-26——3240 Sunset Blvd, Eden Prairie, MN, 553140.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+2 more
TPA-51371TPASarah Crawford1996-06-24—59483581268210 Cedar Ln, Columbus, OH0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
TPA-60446TPABrenda Munoz1979-05-11——6309 Park Pl, San Antonio, TX0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-53808TPAJohn Lee1980-12-10——7726 Mesa Dr, Nashville, TN, 372980.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-58561TPAQJunk2001-03-04UHC-59973-8764356936274763 Church St Apt 38, Plano, TX, 750680.52Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
TPA-53720TPACynthia Lewis1959-05-07——9721 Apache Blvd, Gilbert, AZ, 852140.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-52358TPAWayne Cunningham1947-05-12——1551 Lincoln Way # 746, Dallas, TX, 752650.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58441TPAKaren Rivera1984-05-22——9144 Ridge Rd Apt 12, Fresno, CA, 937790.52Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-50410TPAEmily Hudson1963-09-10——7372 Grand Ave, Fresno, CA0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-59452TPAFrank Thompson1982-09-06——5660 Valley View Dr, Fresno, CA, 937300.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-55654TPASusan K Singh1992-06-09——2587 Ridge Rd, Sacramento, CA, 958230.52Middle initial moved out of first nameStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-50622TPABobby Jordan1994-07-21——7850 Market St, Charlotte, NC0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-60427TPAAdam Griffin1984-03-08——889 Oak St Apt 21, Glendale, AZ, 853700.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51927TPAJohn Morris1958-12-27——5012 Ridge Rd, Miami, FL, 331060.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51926TPAJohn Morris1958-12-27——5012 Ridge Rd, Miami, FL, 331060.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-59281TPANoah Cuoper2007-08-28——3408 Grand Ave, Tempe, AZ, 852540.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
TPA-54341TPATommy Jensen1993-10-28—43399033202508 Maple Ave, Mesa, AZ, 852430.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55798TPARoger Gibson1942-12-06——2278 Canyon Rd, San Diego, CA, 921540.52Name split from “Last, First”Date of birth reformattedZIP+4 trimmedGender normalised+2 more
TPA-54899TPARussell Andrews———2725 Pine Dr, Chandler, AZ0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61891TPAFrank Garcia1941-07-01——9059 Market St, Denver, CO, 802680.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56398TPAArthur Pierce1950-01-16——6768 Lincoln Way, Tampa, FL, 336730.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-59469TPAJon Woods1970-07-25—9612302794727 Church St # 855, Las Vegas, NV, 891560.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-58987TPANoah Cook1982-04-09—6506429202496 Market St, Tempe, AZ, 852630.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63687TPAChristian Coleman2001-06-07—63782266871394 Palm Dr # 409, San Diego, CA0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-54706TPAJose Munoz1982-11-23——7787 Mesa Dr, Tampa, FL, 336650.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-53714TPARoy Mendez1973-06-03—77322065139475 Meadow Ln, Scottsdale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
TPA-57955TPADoroty Griffin1942-08-16——968 Camelback Rd, Austin, TX, 787700.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51138TPAEugene Robinson1958-11-01UHC-47358-7779468471716267 Oak St, Las Vegas, NV, 891200.52Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+2 more
TPA-58407TPAEugene Fields1946-04-17—23279904918134 Valley View Dr, Columbus, OH, 432320.52Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+2 more
TPA-59042TPAJuan Lewis1964-04-09UHC-51931-2192827597924772 Jefferson Ave, Scottsdale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-63165TPADonald Chapman2003-08-09—435394871858 Palm Dr, Las Vegas, NV, 891450.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-64257TPAJack Graham1981-03-04——9805 Camelback Rd, Eden Prairie, MN0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-57998TPAHayes B Gloria2006-11-05UHC-74017-49—9821 Spring St, Fresno, CA, 937700.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
TPA-63010TPAAustin Rogers1986-07-06——7743 Sage Ct, San Antonio, TX, 782730.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61873TPAKatherrine Estrada1969-09-09—51770476283002 Elm St, Dallas, TX, 752620.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-50139TPAPriya Alexander1983-03-13——1179 Canyon Rd, Tempe, AZ, 852920.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
TPA-61253TPAJoe Bradley2005-11-16——5348 Apache Blvd Apt 39, Denver, CO0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62226TPARussell Young1950-05-14——6989 Mountain View Dr, Tempe, AZ, 852720.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59506TPAArjun G Morris1999-02-21——3815 Cedar Ln, Scottsdale, AZ, 852900.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55600TPAZachary Gonzalez1994-03-17—93780451436204 Hillcrest Rd, Las Vegas, NV0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-59142TPAKaren Martin1984-04-01——3754 Main St, Miami, FL, 331490.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51660TPADoris Matthews1944-07-09——8753 Pine Dr, Orlando, FL, 328800.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-52827TPAMason Litle1947-02-26——840 Market St, Gilbert, AZ, 852040.52SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53166TPAPriya U Hunt1992-04-15——9005 Ocean Ave, Denver, CO, 802510.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-56516TPABilly L Little2002-08-12——5327 Canyon Rd, Columbus, OH, 432960.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-51964TPAChuck Jones1950-06-21—60770128161193 Ocean Ave, Mesa, AZ, 852090.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58266TPALewis Brenda1941-12-12UHC-46833-10—5805 Valley View Dr Apt 38, Charlotte, NC, 282670.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-54181TPABradley Brown2004-06-11——4265 Grand Ave, Houston, TX, 770640.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-62723TPAIsabella Hall1948-03-05—21955702619712 Washington St, Houston, TX, 770400.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-58990TPAYuki Elliott2007-03-18——6045 Oak St, Austin, TX, 787640.52Name re-casedPhone missing area codeState name converted to codeGender normalised+2 more
14,474 rows, page 21 of 290PreviousNext