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-59173TPAVincent Castro———6652 Valley View Dr, Orlando, FL, 328520.66Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-57186TPACarol N Ross1987-03-24——5318 Central Ave, Orlando, FL, 328450.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-62478TPAAustin Wlch1963-04-23—7728276325278 Palm Dr, Gilbert, AZ, 852770.66Date of birth reformattedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-62965TPAKatherine Porter1998-09-10——8284 Willow Ct, Eden Prairie, MN, 553920.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-51837TPAWells Jonathan1997-04-19——9341 Church St, Seattle, WA, 981600.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57138TPAEmily Brown1943-12-10—94084545418526 Valley View Dr, Eden Prairie, MN0.66Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-50919TPABenjamin Cruz2007-06-05——3939 Pine Dr, Jacksonville, FL, 322650.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-57508TPACheryl D Thomas1997-04-20——8372 Cedar Ln, Eden Prairie, MN0.66Name re-casedTwo-digit birth yearZIP missingWhitespace trimmed+1 more
TPA-57147TPAJason Montggomery1998-09-24—82562527928845 Park Pl, Orlando, FL, 328910.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50108TPAMargaret Hicks2008-06-15——2960 Central Ave, Orlando, FL, 328530.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-63028TPAMegan Elliott1999-03-18——2593 Harbor Blvd, Orlando, FL, 328220.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-50345TPAJoshua Vasquez1940-01-03—82763723558275 Washington St, Austin, TX, 787730.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-63410TPAMaria Greene1918-03-10——2309 Market St, Las Vegas, NV, 891670.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56446TPAKevin Z Morris1938-05-10—39238782872422 Willow Ct, Austin, TX, 787550.66Two-digit birth yearPhone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-58648TPAAisha Hoffman1939-04-24——341 Sage Ct, San Diego, CA, 921110.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-55314TPAMartha Cole1964-12-06——7007 Central Ave, Gilbert, AZ, 852580.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-53583TPAKyle Jackson1990-08-01——1123 Willow Ct, Atlanta, GA, 303250.66Name re-casedZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
TPA-63070TPAJonathan Gutieerrez2004-02-09——2956 Market St, Scottsdale, AZ, 852000.66Name re-casedTwo-digit birth yearCity re-casedGender normalised+1 more
TPA-57791TPAWillie Reynolds——28036126705688 Ridge Rd, Charlotte, NC, 282930.66Name re-casedDate of birth missingState name converted to codeWhitespace trimmed+1 more
TPA-59626TPABetty Griffin1955-04-26——8221 Bayshore Dr, Sacramento, CA, 958610.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-54340TPAMason Gonzalez1992-03-11——720 Pine Dr Apt 35, Atlanta, GA0.66Date of birth reformattedUnit split from streetZIP missingWhitespace trimmed+1 more
TPA-60559TPADanielle Adams1970-01-15UHC-49180-49—355 Hillcrest Rd, Phoenix, AZ, 850430.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62972TPAGloria Howerd2000-02-07UHC-86207-58—3701 Ridge Rd, Mesa, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-54964TPAJerry Fox1977-06-23——9700 Camelback Rd Apt 22, Mesa, AZ, 852450.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-55031TPAAngeela King1988-12-23UHC-91366-3156893767066442 Main St, Mesa, AZ, 852690.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-51005TPAMatt Allen1989-07-11—2306515265558 Forest Ave, Eden Prairie, MN, 553960.66Name re-casedTwo-digit birth yearPhone reformattedGender normalised+1 more
TPA-56957TPAAaron Simpson2005-05-22—6439817281659 Washington St, Miami, FL, 331750.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56958TPAAaron Simpson2005-05-22—6439817281659 Washington St, Miami, FL, 331750.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63022TPABobby Salazar1978-06-09—92739112696704 Main St Apt 24, Seattle, WA, 981940.66Phone reformattedUnit split from streetZIP+4 trimmedWhitespace trimmed+1 more
TPA-61176TPAJudy Woods1985-03-26—30972786045281 Canyon Rd, Houston, TX, 770980.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-56314TPA—Junk1938-09-25——9144 Desert Sky Blvd, Orlando, FL, 328600.66State name converted to codeEmail lower-casedWhitespace trimmedPlaceholder values cleared+1 more
TPA-56631TPAYuki Russell1942-02-14—48399047524736 Ridge Rd, Mesa, AZ0.66Phone reformattedSSN last four extractedZIP missingWhitespace trimmed+1 more
TPA-53348TPASofia Castro1999-02-28—87046680833317 Lincoln Way # 418, Las Vegas, NV, 891320.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-55407TPAAlice Gomez1942-11-04——6767 Baseline Rd, Tempe, AZ, 852580.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51762TPASandra Fuller1983-09-17UHC-21692-45—2866 Bayshore Dr, Los Angeles, CA, 900640.66Name re-casedTwo-digit birth yearZIP+4 trimmedWhitespace trimmed+1 more
TPA-52666TPAMerilyn Murphy1974-01-17——7566 Washington St, Austin, TX0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-52166TPAMariana C Hawkins1960-03-08UHC-87456-5422035090979230 Mountain View Dr, Gilbert, AZ, 852640.66Name re-casedPhone reformattedState name converted to codeGender normalised+1 more
TPA-54499TPADaniel D Alvarez1943-05-25—42767421536848 Grand Ave, Austin, TX, 787900.66Street suffix standardisedAddress re-casedState code upper-casedGender normalised+1 more
TPA-58686TPALori Murray1926-01-19——183 Harbor Blvd, San Antonio, TX0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-63214TPAJanet Olson1951-03-04——3349 Palm Dr, Atlanta, GA, 303780.66Date of birth reformattedCity re-casedState name converted to codeGender normalised+1 more
TPA-51808TPASharon B Santos1990-01-28——6404 Bayshore Dr, Denver, CO, 802720.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63880TPASusan Welch1983-01-10——6930 Cedar Ln, Minneapolis, MN, 554640.66Name split from “Last, First”Date of birth reformattedGender normalisedWhitespace trimmed+1 more
TPA-60907TPAJoyce Sanders1944-01-23—82096214599492 Ocean Ave, San Antonio, TX, 782780.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51081TPALarry Powell1947-08-03——1524 Sage Ct, Columbus, OH, 432360.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-61575TPAKyle Lawrence1997-10-11——6147 Lincoln Way, Fresno, CA0.66Street suffix standardisedAddress re-casedCity re-casedZIP missing+1 more
TPA-61510TPAWei Arnold1976-05-23UHC-93430-9159364964559213 Pine Dr, Glendale, AZ, 853310.66Name split from “Last, First”Phone reformattedZIP+4 trimmedWhitespace trimmed+1 more
TPA-59930TPAJulie Ryan2000-03-26——9125 Bayshore Dr, Gilbert, AZ, 852950.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-59888TPABrittany Wong1978-04-20——1666 Mountain View Dr, Los Angeles, CA, 900960.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-59821TPAMartha Dixon1980-12-27——1052 Ocean Ave, Chandler, AZ, 852990.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59370TPATheresa Foster———5835 Union St, Eden Prairie, MN, 553570.66Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+1 more
14,474 rows, page 72 of 290PreviousNext