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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-134917ENRDonna Myers1954-01-21UHC-28456-299273674387648 Oak St, Gilbert, AZ, 852150.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-106558ENRSantiago Ross1972-09-08UHC-67982-12—2850 Lake View Rd, San Diego, CA, 921280.60Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-143082ENRBrittany Reyes1949-01-21UHC-87647-2350131710287712 Highland Ave, Eden Prairie, MN, 553730.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-143083ENRBrittany Reyes1949-01-21UHC-87647-2350131710287712 Highland Ave, Eden Prairie, MN, 553730.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-109517ENRKenneth Gordon1939-07-13UHC-62055-4220561838608838 Sage Ct, Chandler, AZ0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-133617ENRBetty M Willis1958-07-17UHC-87716-7195131241142735 Cedar Ln Apt 31, Houston, TX, 770860.60Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-120524ENRNicholas Espinoza2003-07-25UHC-39988-7029480605292471 Indian School Rd, Glendale, AZ, 853810.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-118210ENRJesssica G Perez1997-02-15UHC-75199-9689171332149284 Willow Ct, Dallas, TX, 752770.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-131691ENRNicholas Thompson1985-05-12—71536412848063 Park Pl, Minneapolis, MN, 554650.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-131776ENRCarol Bryant1990-11-22UHC-19112-8586270266765725 Baseline Rd, Seattle, WA, 981030.60Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-118942ENRAhmed A Jones1943-03-22UHC-81105-2339320815312851 Indian School Rd, Miami, FL, 331270.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-107078ENRAndrew U Gutierrez1981-04-13UHC-30348-8334065243717873 Cedar Ln, Los Angeles, CA, 900610.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-100511ENRGrace P Burton1981-01-26UHC-52024-7528894499938064 Maple Ave, Columbus, OH, 432790.60Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
ENR-101567ENRCarl Morrison1989-06-26UHC-22994-7666544918723084 River Rd, Denver, CO, 802360.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-133304ENRPamela Bailey2008-05-18UHC-81807-5093464856914529 Church St # 166, Miami, FL, 331520.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-101345ENRSue Taylor1959-08-10UHC-47369-793212126844867 Bayshore Dr, Gilbert, AZ, 852840.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123062ENREmily Johnson1975-09-13UHC-34879-8542899817787510 Meadow Ln, Miami, FL, 331030.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-134297ENRNathan H Brown2004-07-03UHC-58183-4571841698197754 Mountain View Dr, Austin, TX, 787460.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109835ENRShirley E Rice1955-01-14UHC-46384-1276288164679570 Harbor Blvd, Houston, TX, 770690.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-117248ENRAndrea P Green1946-07-01UHC-80096-47—2561 Jefferson Ave, Chandler, AZ, 852210.60Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-107520ENRRoy Cook1997-05-23UHC-10849-8176897511228933 Camelback Rd, Glendale, AZ, 853250.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-127307ENRFrances V Stevens1958-06-16UHC-72258-9478256248176045 Washington St, Chandler, AZ0.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-117802ENRAna Wheeler1947-03-19UHC-60445-4842187280784863 Lake View Rd, Fresno, CA, 937120.60Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-134564ENRRaymond D Wesst1958-12-27UHC-79449-157544736506451 Union St Apt 25, Columbus, OH, 432070.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-114591ENRAdam Rogers1991-02-14UHC-08320-64—550 Valley View Dr, Tampa, FL, 336790.60Name re-casedTwo-digit birth yearMember ID reformattedStreet suffix standardised+4 more
ENR-105563ENRCarl Y Li1956-09-06UHC-41105-7251791227978507 Highland Ave, Houston, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-125112ENRLuis N Wang1950-12-22UHC-24120-8085093697074636 Maple Ave # 122, Minneapolis, MN, 554930.60Name re-casedDate of birth reformattedPhone reformattedUnit split from street+4 more
ENR-123300ENRJack F Lawson1992-03-07UHC-45514-2020594057545849 Cedar Ln, Columbus, OH, 432070.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-126377ENRAshley Garrett1975-10-05UHC-61998-3464828399975074 Sage Ct, Phoenix, AZ, 850000.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-109745ENRAmanda Rodriguez1951-11-11UHC-01866-39—2060 Valley View Dr Apt 38, Tampa, FL, 336180.60Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-142603ENRPatricia S Richards1965-06-27UHC-53338-8881753376232662 Main St, Chandler, AZ, 852110.60Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+4 more
ENR-120674ENRAstin H Kennedy1996-05-24UHC-71747-7265960263809136 Willow Ct, Atlanta, GA, 303410.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-113951ENRDouglas A Obrien—UHC-06611-9897031757168787 Central Ave, Atlanta, GA, 303820.60Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-101113ENRHelen X Munoz1983-02-20UHC-59265-3382497467841197 Lake View Rd, Las Vegas, NV, 891950.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-135081ENRJennifer Gray1977-08-21UHC-61559-0430826450141201 Maple Ave, Atlanta, GA, 303450.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-124597ENRCarl W Banks1979-07-28UHC-44122-8577957157057792 Jefferson Ave, Fresno, CA, 937820.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-123349ENRDoris Morris1981-02-14—38199619614738 Willow Ct, Columbus, OH, 432360.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-109067ENRRobert J Tucker2004-07-14UHC-10873-9262220425612275 Sunset Blvd, Tempe, AZ, 852840.60Date of birth reformattedPhone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-108752ENRLori O Lewis1949-03-09UHC-65986-6094665655876077 Highland Ave, Atlanta, GA0.60Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-125097ENRKaren S Rivera1984-05-22UHC-62284-6164395955379144 Ridge Rd, Fresno, CA, 937790.60Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
ENR-135640ENRJackie B McCoy1972-03-15UHC-04810-61250593208839 Church St, Las Vegas, NV, 891270.60Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-135605ENRHeather Austin1994-10-27UHC-79946-2824653742104774 Harbor Blvd, Gilbert, AZ, 852440.60Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-106571ENRMarcus Ward1952-05-03UHC-01655-8088784210348789 Park Pl, Plano, TX, 750590.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-105615ENRJennifer Z Gibson1944-01-23UHC-49917-4371136075677719 Canyon Rd, Orlando, FL, 328480.60Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-118844ENRJordan Stone1989-11-22UHC-29838-9045340198092253 Sage Ct, Fresno, CA, 937950.60Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+4 more
ENR-125835ENRJustin Butler1953-11-08UHC-04020-2061093170642044 Mountain View Dr, Austin, TX, 787060.60Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
ENR-129254ENREdwerd Reed1957-05-20UHC-06276-3183365285641422 Lincoln Way, San Antonio, TX, 782070.60Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-126274ENRPriya J Duncan1990-06-08UHC-97186-6660761462302247 Bayshore Dr, Austin, TX, 787240.60Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-100481ENRBruce Henry2001-02-18UHC-59684-2597384915105877 Indian School Rd, Plano, TX0.60Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+4 more
ENR-138422ENRBrittany J Richardson1952-12-02UHC-80551-3059177106594734 Baseline Rd, Plano, TX0.60Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
43,101 rows, page 129 of 863PreviousNext