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-60179TPAWillie BJunk1998-11-15—47728308879044 Mountain View Dr, Las Vegas, NV, 891630.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-58301TPAEthan Reid1958-02-10—7423328602123 Park Pl, Los Angeles, CA, 900170.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56997TPAPatrick Fisher1985-08-03—77732959538910 Camelback Rd, Plano, TX, 750990.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-61132TPABilly Peterson1983-03-22—42966320935022 Willow Ct, Tampa, FL, 336850.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-50384TPAAlbert Hanson1940-03-10——7146 Central Ave, Seattle, WA, 981910.60Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+4 more
TPA-53677TPASophia Brooks2005-02-26UHC-28019-5660152769437594 Highland Ave, Columbus, OH, 432320.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-63732TPAPamela Bailey1976-09-06——3492 Meadow Ln, Eden Prairie, MN, 553730.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-56267TPAGabriel Freeman1943-05-03——7013 Highland Ave, Jacksonville, FL, 322240.60Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+4 more
TPA-58472TPACynthia Lopez2003-11-17——4377 Washington St, Austin, TX, 787150.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-52133TPAJulie Brooks2000-01-15——2139 Park Pl, Scottsdale, AZ, 852690.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51064TPACharles Crawford1956-01-01UHC-28011-91—733 Willow Ct, Seattle, WA, 981680.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59422TPADenise Wang2005-07-13UHC-08918-74—1095 Bayshore Dr # 652, Sacramento, CA, 958630.60Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
TPA-54186TPAJoseph Williams1974-04-11—55994030136312 Hillcrest Rd Apt 37, Mesa, AZ, 852200.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
TPA-52028TPAAngela Chapman1938-05-15—48993629282648 Cedar Ln, San Antonio, TX, 782640.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
TPA-56779TPAJuse Reyes1942-06-27——5287 Valley View Dr, Charlotte, NC, 282500.60Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+4 more
TPA-61593TPAMartha Marquez1964-06-05—70477380912207 Central Ave, Tempe, AZ, 852660.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
TPA-63395TPASamueel Gray1970-08-06—21422362655075 Meadow Ln, Scottsdale, AZ, 852070.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-51810TPARyan Mendez1969-06-26—89659945652216 Lake View Rd, Fresno, CA0.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
TPA-63535TPARebecca J Gardner1948-03-04——9408 Union St, Eden Prairie, MN, 553770.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56065TPAScott H Hamilton1944-01-26—6845883514234 Broadway, Orlando, FL0.62Name re-casedPhone reformattedState code upper-casedZIP missing+3 more
TPA-56551TPARandy B Meyer1984-07-26UHC-39293-8870726199052773 Mountain View Dr, Tucson, AZ, 857530.62Member ID reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-59474TPAFrances X Vega2006-03-18UHC-07350-60—2973 Elm St, Miami, FL, 331500.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57615TPANancy Hughes—UHC-92987-8067578554877424 Cedar Ln, Las Vegas, NV, 891310.62Date of birth unreadableStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-56224TPAMary Owens1943-01-19—6479082878726 Sunset Blvd, Atlanta, GA, 303940.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63005TPAMartha Carpenter2001-04-23——8661 Valley View Dr, Seattle, WA, 981220.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52946TPARyan Russell1973-05-02UHC-72695-195829805593351 Ocean Ave, Tempe, AZ, 852600.62Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-61963TPARuth E Bishop1990-05-13—5734364466804 Oak St, Atlanta, GA, 303470.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-57535TPARuth Z Price1971-01-26—34389507854460 Mesa Dr, Las Vegas, NV, 891870.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54486TPASteven Rogers1984-08-23—59346623785940 Mesa Dr, Minneapolis, MN, 554340.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-61010TPANoah Mendoza1975-08-12—31998805164158 Valley View Dr, Phoenix, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58612TPAZachary Evans1988-09-27—4344142493724 Forest Ave, Scottsdale, AZ, 852650.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-62558TPANicholas Santos1973-05-25UHC-65934-1364191712586211 Main St Apt 18, Mesa, AZ, 852370.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-62229TPAPamela Harvey1953-11-17——5210 River Rd Apt 25, San Antonio, TX, 782520.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-58278TPARandy Woods1976-04-09—39470420401919 Market St, Phoenix, AZ, 850570.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51442TPAEvelyn Montgomery1980-09-25—38071023923702 Valley View Dr, Eden Prairie, MN, 553790.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50109TPAJeremy Adams1971-07-04——4817 Oak St, Austin, TX, 787750.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61027TPAJason Willis1938-04-20—7248061970684 Baseline Rd, Orlando, FL, 328120.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50965TPAAlan Gomez1970-09-14——4112 Central Ave, Plano, TX, 750380.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50964TPAAlan Gomez1970-09-14——4112 Central Ave, Plano, TX, 750380.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53728TPABrian Jensen2001-09-21—29741668323976 Canyon Rd, Charlotte, NC, 282760.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-53418TPANoah Milller2003-01-20——468 Bayshore Dr, Scottsdale, AZ0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-61787TPATyler Wag1941-12-14—27551962991579 Lincoln Way, Dallas, TX, 752170.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57179TPABradley D Burton1996-09-28—36130399712223 Valley View Dr, Tucson, AZ, 857750.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-51770TPARoy Hill1977-08-12—61250303835091 Maple Ave, Orlando, FL, 328630.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54116TPABrian Hawkins———9646 Spring St, Nashville, TN, 372750.62Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+3 more
TPA-50489TPAHannah Padilla1982-06-18UHC-70306-47—1746 Spring St, Dallas, TX0.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-51326TPADenise Bennett2003-06-18——3143 Mountain View Dr, Denver, CO, 802860.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53376TPA—Junk1990-12-12—80293123711686 Hillcrest Rd, Columbus, OH, 432270.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62130TPASamuel Romero1939-09-27—74851284675854 Bayshore Dr, Mesa, AZ0.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-54632TPAHarold Rojas———1296 Forest Ave, San Antonio, TX, 782830.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 34 of 290PreviousNext