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-61624TPAAlexander M Young1952-05-28—49020036565866 Main St, Plano, TX, 750720.48Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-54828TPADaivd Knight1981-12-18——5178 Baseline Rd Apt 32, Plano, TX, 750120.48Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+4 more
TPA-51410TPAJean Contreras1943-06-21UHC-29251-6525559301533730 Hillcrest Rd, San Antonio, TX, 782020.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58722TPAGrace Perkins2008-07-20UHC-06554-4722560176959709 Willow Ct Apt 21, Tempe, AZ, 852690.48Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
TPA-63997TPAGabriel Gilbert1987-01-10—69131996139797 River Rd, Tucson, AZ, 857230.48Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-58165TPARalhp Montgomery1968-03-03—47132203868841 Central Ave, Jacksonville, FL, 322230.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61729TPAElijah Moorales1950-03-08——7332 Forest Ave # 968, Columbus, OH, 432160.48Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
TPA-55425TPAAngela Richardson1947-10-24—88471437947082 Oak St, Houston, TX, 770460.48Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
TPA-61361TPAArjun Marshall1974-03-22——4070 Willow Ct # 774, Tampa, FL0.48Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-55277TPAAlbert Butler2008-06-20—87169099984427 Jefferson Ave, Tempe, AZ, 852380.48Name re-casedTwo-digit birth yearPhone reformattedSSN last four extracted+4 more
TPA-60917TPAElizabeth Jones1996-02-25——9833 Oak St, Los Angeles, CA, 900870.48Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
TPA-62447TPABrandon Collins1981-07-08—33052091221704 Desert Sky Blvd, Tampa, FL0.48Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56696TPABobby Porter——76657443469479 Camelback Rd, Sacramento, CA, 958340.48Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
TPA-53027TPAGace Vargas1954-05-26—5905289339955 Ocean Ave # 337, Minneapolis, MN0.48Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-50493TPASara Jaes1964-06-24—51520872172639 Sage Ct, Tempe, AZ0.48Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54389TPAFatima Simmons———388 Church St # 621, Columbus, OH, 432390.48Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+4 more
TPA-56423TPAVirrginia Hart1982-10-13—50674988224504 Church St # 736, Miami, FL, 331390.48Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-60086TPABradley Bryant1990-12-16—20342111543422 Lake View Rd, Atlanta, GA, 303700.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62003TPARonald Bennett1988-11-01——3179 Camelback Rd, Fresno, CA, 937940.50Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-61688TPAEvelyn Palmer1997-04-03—60923909248011 Church St Apt 11, Tucson, AZ, 857580.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-60464TPADennis Alvarez1979-08-21—95877397723110 Desert Sky Blvd, Plano, TX, 750630.50Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-51215TPAEugene Espinoza1945-12-11—75929237124711 Mountain View Dr, Houston, TX0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53451TPACarol Cruz2005-10-21——4813 Washington St, Houston, TX, 770650.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53110TPAEmma Tucker1955-10-18—35961167664116 Market St, Mesa, AZ, 852450.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52805TPAWei Mejia1960-05-08——7400 Apache Blvd Apt 19, Los Angeles, CA, 900350.50Unit split from streetStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-58013TPALori Z Willis2008-09-22—25737818701029 Pine Dr, Columbus, OH, 432490.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50558TPAFank Y Park1940-10-09—64327029249254 Cedar Ln, Sacramento, CA, 958860.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60007TPASantiago Carolyn——33350907153514 Indian School Rd, Atlanta, GA, 303550.50Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58845TPAJacqueline Evns1967-02-19——9777 Elm St, Tucson, AZ, 857060.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54920TPAJustin Garcia1993-09-18——6008 Cedar Ln # 762, Scottsdale, AZ0.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-56998TPACharlotte Lopez1954-05-07——4337 Sage Ct, Houston, TX, 770530.50Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54536TPAVyncent K Smith1954-08-27——2219 Canyon Rd, San Diego, CA, 921840.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51262TPAAnna Freeman2005-05-18UHC-84558-26—9520 Apache Blvd, Nashville, TN0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-63275TPASamuel Q Greene———2210 Main St, Charlotte, NC, 282130.50Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-59755TPABrandon James1955-10-27—33664598759899 Central Ave, Chandler, AZ, 852630.50Name re-casedPhone reformattedState name converted to codeZIP+4 trimmed+3 more
TPA-58979TPADominguez Helen2000-05-20——320 Pine Dr, Eden Prairie, MN, 553690.50Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55936TPALarry H Freeman1973-10-19——8114 Sage Ct, Tampa, FL, 336880.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
TPA-54523TPAGeorge King1943-04-06——3734 Grand Ave Apt 30, Denver, CO, 802180.50Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+3 more
TPA-63555TPASarah Evans——7863518033834 Cedar Ln, Eden Prairie, MN, 553560.50Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56156TPAMary I Ruiz2009-03-26——4939 Ocean Ave, San Antonio, TX0.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-62339TPAElliott Barbara1941-02-08—93679118776512 Canyon Rd, Columbus, OH, 432510.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64058TPALauren Jackson2004-04-04—89034567517895 Harbor Blvd, Houston, TX0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61082TPACarolyn Daniels1946-12-25—78677929675483 Cedar Ln, Austin, TX, 787160.50Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-58396TPAJudith Burns1978-04-16——8847 Pine Dr, Nashville, TN, 372580.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-58280TPAAnn Garrett1977-01-19—48657001766583 Oak St # 765, Houston, TX, 770840.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-52288TPAThomas Boyd1984-09-28——7546 Sunset Blvd, Sacramento, CA, 958830.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-59224TPABrittayn Hudson1966-07-21——1462 Canyon Rd # 775, Minneapolis, MN, 554470.50Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-61159TPAAhmed Hoffman1979-12-22——1307 Pine Dr, Dallas, TX, 752000.50Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+3 more
TPA-53951TPAArjun Flores1978-12-09——2271 Elm St, Chandler, AZ0.50Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50673TPAHeather Kelly1971-01-25——6489 Central Ave, Nashville, TN0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
14,474 rows, page 10 of 290PreviousNext