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-56609TPAVictoria Maldonado1966-01-02UHC-88689-5079177348739385 Sage Ct, Atlanta, GA, 303480.72Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50971TPAVincent Mendez1961-01-26—3446714778721 Sunset Blvd, Mesa, AZ, 852200.72Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50383TPASarah Garrett1982-06-22—25171752779114 Indian School Rd, San Diego, CA, 921860.72Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58491TPAKenneth Bailey2002-01-05—5536167156203 Camelback Rd, Plano, TX, 750110.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56216TPAJesse Wad2002-03-04—22167341261208 Elm St, Nashville, TN, 372900.72Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-56500TPAMei Allen1991-09-17UHC-06040-5079677003802703 Main St, Tampa, FL, 336340.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-64164TPANick Mendoza1994-05-04UHC-42778-0253227786303558 Washington St, Eden Prairie, MN, 553170.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-57834TPAJacob M Ferguson1950-01-07——846 Lake View Rd, Mesa, AZ, 852380.72Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-50459TPAJacob C Hart1990-11-02—41839706717461 Market St, Tampa, FL, 336250.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-51370TPAMary Daniels1969-09-15—32624261463406 Market St, Denver, CO, 802590.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-54215TPADanielle Torres2003-09-16—85583245724732 Willow Ct, Chandler, AZ, 852930.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-61479TPAArjun Fernandez1950-04-22——3885 Park Pl, Minneapolis, MN, 554360.72Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58469TPASamuel Patterson1990-10-05UHC-60348-0122632644111457 Palm Dr, Gilbert, AZ, 852600.72Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-63983TPAMichael Howard1947-06-26—70959953722431 Park Pl, Las Vegas, NV, 891510.72Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-62906TPAReed Mateo1987-07-21UHC-56867-303566885085543 Forest Ave, Orlando, FL, 328040.72Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
TPA-62905TPAReed Mateo1987-07-21UHC-56867-303566885085543 Forest Ave, Orlando, FL, 328040.72Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
TPA-56695TPAJulia Kelly1974-10-24—3745237414271 Lake View Rd, Las Vegas, NV, 891430.72Name re-casedDate of birth reformattedPhone reformattedCity re-cased+4 more
TPA-63891TPAShirly Jenkins1973-05-17UHC-29779-72—7004 Washington St, Nashville, TN, 372070.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52863TPACarlos Grdon1983-04-28—57451552635917 Maple Ave, Plano, TX, 750400.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59448TPACarol Garza1993-10-02——2772 Ridge Rd, Denver, CO, 802800.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62522TPAHelen Gordon1948-02-03—92149408157857 Mesa Dr, Austin, TX, 787300.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51616TPAJess G Rios1950-07-04—6348221949552 Spring St, Charlotte, NC, 282380.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57122TPAJack D Hall1999-09-13—89254508845459 Canyon Rd, San Diego, CA, 921910.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61400TPARay Carlson2003-12-03——9151 Church St, Houston, TX, 770590.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59279TPACarol Li1982-07-11—21169336628392 Elm St, Jacksonville, FL, 322620.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60472TPAChris Padilla2006-02-11—25452151462873 Baseline Rd, Tucson, AZ, 857960.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56929TPAGerald Hunter2008-07-04——5105 Sunset Blvd, Columbus, OH, 432160.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56930TPAGerald Hunter2008-07-04——5105 Sunset Blvd, Columbus, OH, 432160.74Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58314TPAJuan Lane1965-04-02—71128939687809 Lake View Rd, Mesa, AZ, 852000.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53325TPAJudith Boyd1968-05-15UHC-46308-61—9713 Desert Sky Blvd, Charlotte, NC, 282580.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52560TPAMatt Ryan1972-02-10UHC-87039-0384194394852434 Willow Ct, Eden Prairie, MN, 553860.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58696TPAJesse Pena1982-07-12—70197506209522 Oak St, Las Vegas, NV, 891710.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58053TPACarolyn Arnold1948-10-11—44467804959558 Union St, Houston, TX, 770980.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-52832TPACatherine Nguyan1998-09-22—94237992539866 Mesa Dr, Jacksonville, FL, 322130.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61198TPAJuan A Graham1938-06-16——4334 Harbor Blvd, Fresno, CA, 937330.74Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61669TPAArthur Holmes1979-10-16—40058348626471 Meadow Ln, Austin, TX, 787340.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-63479TPAAndrea Dean1939-10-02—25874982561987 Meadow Ln, Tempe, AZ, 852010.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-59141TPAJonathan L Vega1952-03-24—59869304206552 Jefferson Ave, San Diego, CA, 921940.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57339TPARichard Burke2002-09-27—97072626752536 Park Pl, Miami, FL, 331300.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61841TPARyan Henry1997-02-08UHC-30848-72—5813 Grand Ave, Dallas, TX, 752250.74Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56599TPAAmber Berry1995-05-11—22941230395315 Palm Dr, Atlanta, GA, 303690.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62326TPAKeith Larson1994-01-19—29163713404843 Oak St, Dallas, TX, 752290.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61973TPAJoyce Howard1978-05-03—22354817836070 Maple Ave, Glendale, AZ, 853020.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54533TPAMatthew Hunt1964-09-03—54851134187991 Sunset Blvd, Scottsdale, AZ, 852630.74Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55182TPACarl Watson1947-06-09—63561410724297 Palm Dr, Miami, FL, 331000.74Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61857TPAVincent Z King1948-08-14—71353299655963 Valley View Dr, Tucson, AZ, 857120.74Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62854TPAMariana Williamson1967-04-01—48588576834594 Main St, Denver, CO, 802670.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50024TPAEddward Harrison1952-02-27——2915 Market St, Charlotte, NC, 282250.74Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55418TPAKevin Hernandez1969-07-03—77762541737438 Ridge Rd, Minneapolis, MN, 554730.74Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53498TPAKathryn Sims1958-10-08UHC-18011-8544568349808523 Sage Ct, Charlotte, NC, 282710.74Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
14,474 rows, page 104 of 290PreviousNext