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-60104TPABetty G Gomez1977-06-09———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-58409TPANicole Carr1960-06-14——7331 Pine Dr, Phoenix, AZ, 850530.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62693TPAAndrea Boyd2001-04-15UHC-99046-48—6842 Harbor Blvd, Columbus, OH, 432080.82City re-casedState name converted to codePlaceholder values cleared
TPA-58126TPAWillie Morales1995-04-17——90 Desert Sky Blvd, Glendale, AZ, 853580.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-55299TPAHeather Lynch1961-05-07——8994 Broadway, Fresno, CA, 937860.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53558TPAPamela Phillips1971-11-10——8055 Hillcrest Rd, Gilbert, AZ, 852940.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61359TPAAmber Jordan1985-02-17——1088 Sunset Blvd, Seattle, WA, 981860.82Name re-casedState name converted to codePlaceholder values cleared
TPA-59085TPAStephanie Armstrong1994-01-24———0.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-52636TPAAmber Oliver1949-08-23———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-53555TPAThomas H Esspinoza1980-07-04——8979 Market St, Eden Prairie, MN, 553020.82Name re-casedGender normalisedPlaceholder values cleared
TPA-63231TPADavid Rogers1959-11-20——9118 Mountain View Dr, Orlando, FL0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-53578TPAEmma Dunn1944-10-28—51160194611261 Highland Ave, Denver, CO0.82Phone reformattedZIP missingPlaceholder values cleared
TPA-54219TPASamantha Patterson1974-10-20UHC-44506-479198602559—0.82Phone reformattedGender normalisedPlaceholder values cleared
TPA-56140TPAPatel Austin1972-10-22——1655 Baseline Rd, Atlanta, GA, 303870.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-57326TPADavid Romero1943-01-11——5115 Willow Ct, Mesa, AZ, 852860.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51794TPABrenda Cook1969-08-03———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-51768TPAAna Fuller1978-10-18——9872 Spring St, Phoenix, AZ, 850420.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62665TPAMargaret Bradey1966-09-13——2445 Spring St, Glendale, AZ, 853140.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62038TPAJoshua Rose1961-09-22——7769 Ridge Rd, Minneapolis, MN, 554560.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-52800TPAVirginia Graham1943-12-05——4639 Palm Dr, San Diego, CA, 921930.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-54833TPAFatima Collins1999-12-24——9073 Lincoln Way, Denver, CO, 802050.82Date of birth reformattedPhone missing area codePlaceholder values cleared
TPA-55805TPABobby Gordon1980-01-03—84757400192134 Ridge Rd, Sacramento, CA, 958930.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-50165TPADavid Padilla1952-11-13——5065 Hillcrest Rd, Tampa, FL, 336330.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-53029TPAJoshua White1984-09-10——8849 Harbor Blvd, Tempe, AZ, 852380.82Name re-casedGender normalisedPlaceholder values cleared
TPA-52421TPAThomas Powell1965-12-19—42647490311837 Palm Dr, Atlanta, GA, 303970.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-56982TPANicholas Grant1998-11-06UHC-26220-94—7769 Lake View Rd, Fresno, CA, 937150.82Date of birth reformattedZIP+4 trimmedPlaceholder values cleared
TPA-62761TPALuis Perez2002-08-15UHC-57144-778839338205—0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-51220TPALawrence J Morgan1970-05-27———0.82Name re-casedSSN last four extractedPlaceholder values cleared
TPA-60141TPAKenneth Nguyeen1990-12-14——8140 Palm Dr, Las Vegas, NV, 891490.82Name re-casedZIP+4 trimmedPlaceholder values cleared
TPA-52063TPAHarold Ortega1974-01-26———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-58007TPAMegan C Crawford1938-07-24——6340 Union St, Seattle, WA, 981170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-58224TPAEdward Russell1991-02-21——7133 Meadow Ln, Tucson, AZ, 857950.82Name re-casedPhone missing area codePlaceholder values cleared
TPA-61445TPADiane Howard1966-04-12——7592 Cedar Ln, San Diego, CA0.82State code upper-casedZIP missingPlaceholder values cleared
TPA-58213TPAJessica Adams1961-07-22——1007 Oak St, Columbus, OH, 432510.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50728TPABrian K Snyder1969-11-19——6722 Grand Ave, Chandler, AZ, 852120.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60950TPAMichelle Gutierrez1998-01-28——6253 Grand Ave, Orlando, FL, 328700.82Two-digit birth yearCity re-casedPlaceholder values cleared
TPA-62933TPATom Wang1942-08-14——1523 Sage Ct, Phoenix, AZ, 850290.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-60252TPAThomas Gibson2007-04-20———0.82Two-digit birth yearPlan code upper-casedPlaceholder values cleared
TPA-59580TPAAbigail Allen1999-01-07UHC-78813-14—2171 Oak St, Tampa, FL, 336830.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-50812TPACatherine Bishop1967-10-17—2628916417—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-63119TPASharon Burke2001-12-20—3514196066655 Harbor Blvd, Glendale, AZ, 853440.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52823TPABilly Hunt1995-07-25———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56781TPAMark Hunter1941-09-01——1443 Elm St, San Diego, CA, 921700.82City re-casedZIP+4 trimmedPlaceholder values cleared
TPA-50336TPACarlos Perkins1998-11-01—3264008261—0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-50463TPAKelly Larson1965-12-05——3092 Washington St, Chandler, AZ, 852210.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61448TPAAshley Castro1970-04-21—84663034771834 Jefferson Ave, Austin, TX, 787300.82ZIP+4 trimmedWhitespace trimmedPlaceholder values cleared
TPA-50305TPAMariana Berry1988-03-20——4544 Main St Apt 30, Denver, CO, 802940.82Name re-casedUnit split from streetPlaceholder values cleared
TPA-60881TPASofia H Phillips2008-02-28——9700 Lake View Rd, Los Angeles, CA, 900730.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-51412TPAKeith E Jimenez1948-01-27——49 Canyon Rd, San Antonio, TX, 782250.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63062TPAJeffrey Phillips——2955335291—0.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
14,474 rows, page 201 of 290PreviousNext