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-54232TPAYuki Lynch1963-06-01——5354 Central Ave, Denver, CO0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-57318TPAMargaret Cole1973-09-02——6556 Lake View Rd, Las Vegas, NV0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-51052TPAJuith Lopez1978-05-25—94557438922945 Grand Ave, Eden Prairie, MN, 553890.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-60753TPANoah Cooper1993-07-02——1754 Sage Ct, Las Vegas, NV0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52943TPAJudith Daniels1940-03-13UHC-61314-90—862 Sunset Blvd, Phoenix, AZ0.50Street suffix standardisedAddress re-casedCity re-casedZIP missing+3 more
TPA-63450TPARalph Garcia1945-04-22——2592 Forest Ave # 444, Miami, FL, 331150.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-55722TPAMary Powell2007-09-09——2667 Indian School Rd, Atlanta, GA, 303360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55723TPAMary Powell2007-09-09——2667 Indian School Rd, Atlanta, GA, 303360.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64017TPAHeather Carpenter1995-04-21——7891 Forest Ave, San Diego, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-61122TPASofia Guerrero1958-11-24——748 Cedar Ln Apt 31, Eden Prairie, MN, 553810.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-64060TPAMichael McDonald1982-07-05——6489 Camelback Rd Apt 17, Gilbert, AZ, 852450.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-55535TPAMateo Brown1938-02-04——5088 Sunset Blvd, Jacksonville, FL, 322960.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-63176TPAAadm Sanders2005-02-09——5341 Ridge Rd, Tempe, AZ, 852060.50Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63897TPAHeather Kim2006-01-04——4203 Harbor Blvd # 558, Tempe, AZ, 852550.50Name re-casedDate of birth reformattedSSN last four extractedUnit split from street+3 more
TPA-53556TPAMelissa Gardner1949-02-05—6383769295778 Apache Blvd, Austin, TX, 787580.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60793TPAElijah Jackson1991-08-23—68088792512903 Lake View Rd # 551, Fresno, CA, 937860.50Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-61515TPADorothy Peterson1947-10-04——1631 Camelback Rd, Phoenix, AZ, 850620.50Street suffix standardisedAddress re-casedCity re-casedState name converted to code+3 more
TPA-63467TPAEvelyn F Hudson1989-06-07——1021 Grand Ave, Plano, TX, 750340.50Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54301TPACharlotte Greene———9599 Park Pl, San Antonio, TX, 782600.50Date of birth reformattedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-56364TPALinda N Patterson———9882 Oak St, San Antonio, TX, 782600.50Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-61059TPAAshley Oliver1973-04-06——229 Bayshore Dr, Gilbert, AZ, 852010.50Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-57700TPANicholas Montgomery1976-12-24—27472172898660 Baseline Rd, San Antonio, TX, 782500.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-54697TPASarah Bowman1983-04-27——3180 Apache Blvd, Los Angeles, CA0.50Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-58576TPASharon Sanchez1996-03-09——6949 Canyon Rd # 643, Tempe, AZ, 852710.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
TPA-56561TPAWei Romero1986-01-19—22285845168922 Willow Ct Apt 12, Scottsdale, AZ0.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-62193TPAWilliam Cook2002-03-27——221 Baseline Rd, Seattle, WA0.50Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+3 more
TPA-62280TPAKelly Vazquez1940-03-23——5213 Jefferson Ave, Minneapolis, MN, 554800.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-63084TPAKimberly Hayes1991-10-13——1773 Ocean Ave Apt 40, Columbus, OH, 432810.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56266TPAZachary Jensen1970-03-16—80337542604197 Hillcrest Rd, Denver, CO, 802320.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53115TPAVictoria Davis1999-02-22——159 Highland Ave, Seattle, WA, 981900.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52110TPATerry Q Watson1949-06-28——9167 Church St, Tampa, FL0.50Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-58098TPAJack Schultz1958-03-23—56963452221433 Union St # 384, Orlando, FL, 328470.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-55092TPAElizabeth Crawford2002-07-18—61135311276310 Hillcrest Rd, Houston, TX0.50Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58137TPAWei Garrett1986-11-10——2747 Harbor Blvd, Seattle, WA, 981690.50Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+3 more
TPA-50087TPASharon Patel1955-09-08——400 Washington St # 136, Chandler, AZ, 852070.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50764TPAFatima Clark1979-03-05——2705 Sage Ct, Minneapolis, MN0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-60044TPAZachary Greene1992-12-26——3732 Palm Dr, Los Angeles, CA0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-57279TPAAhmed P Fiher1986-05-01—505305669944 Elm St, Seattle, WA, 981490.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60736TPAJoe Bshop1988-10-18—52791546206422 Harbor Blvd, Nashville, TN0.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-57330TPAGerald Foster1992-05-17——368 Church St, Mesa, AZ, 852440.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-53767TPASamantha Alvarado1987-10-11—61024222462471 Sunset Blvd, Fresno, CA, 937770.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54978TPAFatima Robertson1960-07-14——2081 Ridge Rd, Houston, TX, 770230.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62415TPADeborah Y Fox1982-06-04——3808 Highland Ave Apt 9, Houston, TX, 770590.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-53156TPATheresa Espinosa1979-02-20—38791014658697 Mountain View Dr, Orlando, FL, 328730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51377TPAAnthony Knight1973-06-22UHC-86954-11—7521 Market St, San Diego, CA, 921530.50Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+3 more
TPA-50217TPADot X Reyes1994-07-24——8886 Lake View Rd, Orlando, FL, 328680.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53712TPAMargaret Hunter2005-01-01—84678276832931 Oak St, Chandler, AZ, 852720.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-63908TPADylan Carlsno1946-10-01——1363 Baseline Rd Apt 40, Atlanta, GA0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56679TPAJessica Green1964-04-06—52350459443674 Washington St, Tempe, AZ, 852810.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58784TPADouglas Wang1938-02-04—9179773554566 Pine Dr, San Diego, CA, 921450.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 12 of 290PreviousNext