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-52820TPAStephanie Burns1963-07-07—52953539642406 Indian School Rd, Charlotte, NC0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50569TPAAnthony Simpson1952-11-27—66072851788962 Forest Ave # 351, Mesa, AZ, 852490.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-64154TPAJonathan Bisohp1998-06-24UHC-27890-4072530084035797 Desert Sky Blvd, Mesa, AZ, 852150.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60720TPADiane D Dominguez1946-08-06——9605 Union St, Sacramento, CA, 958620.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62142TPAJulia Walsh———4421 Park Pl, Fresno, CA, 937980.62Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52703TPASteve W Maldonado1941-06-16UHC-08829-6961464378455247 Hillcrest Rd, Sacramento, CA0.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-54132TPABradley Fernandez1946-08-11——660 Maple Ave, San Antonio, TX, 782850.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50794TPATaresa C Chavez1953-05-09UHC-36535-4243621244131648 Valley View Dr, Eden Prairie, MN, 553430.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52488TPAGrace Singh1980-08-17—59288298053869 Central Ave, Miami, FL, 331920.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59640TPAKenneth Ryan1991-07-24——2520 Sunset Blvd, Tampa, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60368TPAHannah Brooks1959-04-20—84197001366472 Washington St, Jacksonville, FL, 322480.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61329TPAZachary Dixon1989-11-18UHC-53939-56—6095 Sage Ct, Chandler, AZ0.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61345TPAPatrick Hernandez2008-01-12——1688 Willow Ct, Columbus, OH, 432790.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54001TPABryan Ortiz1965-07-06——3376 Market St, Chandler, AZ, 852300.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55893TPASamuel Obrien2000-10-08UHC-78534-3460037059178778 Oak St, Tampa, FL0.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-54444TPAWilliam Contreras2002-04-08——3013 Grand Ave, Seattle, WA0.62Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-52751TPAMichelle J Cole1969-02-24UHC-87039-26—1395 Apache Blvd, Tampa, FL, 336450.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58892TPARebecca V Foster1972-09-20—37556381062598 Oak St, San Diego, CA, 921980.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53746TPAMateo P Hill1970-07-15—84069033572581 Elm St, Eden Prairie, MN, 553150.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58216TPACarl Lucas1946-09-27—88476408198483 Sage Ct, Austin, TX, 787480.62Name re-casedStreet suffix standardisedAddress re-casedGender normalised+3 more
TPA-62117TPAJerry Luna1979-11-14——9438 Sunset Blvd, Atlanta, GA, 303670.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55054TPAChristina Maldonado1957-06-20——8246 Valley View Dr, Eden Prairie, MN, 553790.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50781TPAHiroshi Coleman1985-04-06UHC-24824-94—3352 Central Ave, San Antonio, TX, 782420.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-59768TPARichard Schultz1960-09-04—67657226493637 Union St, Tempe, AZ, 852640.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56697TPALucia Holmes2007-02-04——8617 Highland Ave, Glendale, AZ, 853140.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52485TPADavid Burns1963-09-17——7628 Desert Sky Blvd, Scottsdale, AZ, 852540.62Date of birth reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+3 more
TPA-61542TPAGeorge Daniels1951-09-11—60294388918278 Central Ave Apt 26, Las Vegas, NV, 891870.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-55923TPAMark Gutierrez1973-08-10—27688679449527 Mesa Dr, Los Angeles, CA, 900690.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56523TPACyntia Jensen1959-05-28—2685969803454 Apache Blvd, Columbus, OH, 432770.62Name re-casedDate of birth reformattedPhone reformattedZIP+4 trimmed+3 more
TPA-59310TPAAlexander Larson2005-11-23—80129034158136 Elm St, Seattle, WA0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52642TPALori Stevens1966-06-13——8079 Sunset Blvd, Las Vegas, NV, 891130.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63308TPASarah Harvey1988-04-27—71771836874877 Church St, Las Vegas, NV, 891970.62Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
TPA-55289TPAKaren Obrien1951-02-28——9506 Highland Ave, Atlanta, GA0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52922TPAHarold Vega1946-06-06—61695949569470 Highland Ave, Orlando, FL0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57511TPABilly Reed1946-05-19UHC-86512-7121471501206977 Apache Blvd # 530, San Diego, CA, 921830.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
TPA-57256TPAAlex Prekins1959-03-26UHC-60662-97716433639526 Camelback Rd, Plano, TX, 750580.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53173TPABruce Hart1963-04-13—80429214228947 Market St, Chandler, AZ, 852880.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55807TPASusan Matthews1979-01-19—20132108639469 Ocean Ave, Charlotte, NC, 282320.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53400TPAHunt Laura1988-07-01——8070 Market St, Tampa, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57233TPABrian Bell1963-01-06——784 Camelback Rd, San Diego, CA, 921920.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52814TPAMarcus Munoz1971-08-23—73089652191896 Baseline Rd # 320, Orlando, FL, 328880.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
TPA-62894TPAIsabella Fox1977-01-22—41595515959600 Highland Ave, Columbus, OH, 432860.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64117TPAKaren Spencer1969-12-21——1338 Cedar Ln, Phoenix, AZ, 850040.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-57552TPADanny E Cooper1969-07-18—62080112096979 Desert Sky Blvd, Seattle, WA, 981670.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52300TPAKeith Hernandez1998-11-21——1394 Apache Blvd, Scottsdale, AZ, 852390.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53988TPANancy Rios1945-11-03—35298194847547 Highland Ave, Columbus, OH, 432860.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58900TPAMaria E Wells1946-03-19—73065345307304 Mountain View Dr, Phoenix, AZ, 850990.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50740TPADylan Kim2007-06-24UHC-93308-26—7800 Elm St, Dallas, TX, 752490.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59146TPAJacob Jensen1942-01-19UHC-74692-41—5608 Meadow Ln, Denver, CO, 802600.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50761TPAEthan Le1939-11-24—92535890393103 Mesa Dr, Phoenix, AZ0.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 37 of 290PreviousNext