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-126251ENRCharles K Baker1979-05-09UHC-20459-987306289105784 Park Pl, Tucson, AZ, 857050.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103453ENRAnthoony Martin1982-10-23UHC-47088-1537723177972343 Oak St Apt 31, Phoenix, AZ, 850450.52Phone reformattedMember ID reformattedSSN last four extractedUnit split from street+2 more
ENR-126713ENRMichelle Y Spencer2002-07-28UHC-58399-69—4328 Pine Dr # 939, Plano, TX, 750940.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-110471ENRJulia X Soot1986-12-17UHC-52203-0156966916719040 Mountain View Dr, Minneapolis, MN, 554860.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142777ENRAustin Hughes2000-10-06UHC-15363-444455878753576 Highland Ave, Tampa, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-135843ENRDiana Z Lng2007-11-05UHC-77612-5535621538407104 Sage Ct, Houston, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-133191ENRPamela R Arnold1974-03-06UHC-14514-4931793129443833 Willow Ct, Tempe, AZ0.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-108164ENRRuth George1964-10-19UHC-96926-0390550087562934 Sunset Blvd, Chandler, AZ, 852090.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-105658ENRJoshua E Vega1996-03-27UHC-02385-4736691590012246 Mesa Dr, Dallas, TX, 752090.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-130763ENREugene K Nguyen1992-09-24UHC-72367-6028527965006870 Camelback Rd Apt 37, Dallas, TX, 752490.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-100748ENRCarlos P Kim1967-12-10UHC-90592-8967823362641107 Park Pl, Columbus, OH, 432330.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103362ENRLusi Vega1938-07-28UHC-18828-5689842596192560 Ocean Ave, Minneapolis, MN, 554580.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-126026ENRCharles E George1984-08-28UHC-68001-45—8364 Camelback Rd, Nashville, TN, 372250.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-114142ENRCharlotte Little1977-08-05UHC-17946-9194266617842244 Canyon Rd, Denver, CO0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-102817ENRAndrew C Cooper1975-01-17UHC-60313-72—7383 Bayshore Dr, Columbus, OH0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-136908ENRMei L Clark1987-03-09UHC-15546-2076589629294102 Sunset Blvd, Glendale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-131329ENRAisha Y Gilbert1971-08-08——8619 Elm St, Houston, TX, 770470.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
ENR-142614ENRJason James1957-02-14UHC-94506-0474132840419716 Mountain View Dr # 769, Glendale, AZ, 853520.52Phone reformattedUnit split from streetCity re-casedZIP+4 trimmed+2 more
ENR-105847ENRGloria V Ortega2007-02-20UHC-54492-8262566424504707 Highland Ave, Tempe, AZ, 852520.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
ENR-105848ENRGloria V Ortega2007-02-20UHC-54492-8262566424504707 Highland Ave, Tempe, AZ, 852520.52Middle initial moved out of first nameName re-casedPhone reformattedStreet suffix standardised+2 more
ENR-127948ENRMichelle O Clark1987-06-28UHC-76779-1271862752434196 Union St # 234, Miami, FL, 331160.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-100741ENRAmy Z Sullivan1964-12-06UHC-96279-9592550248083192 Willow Ct, Austin, TX, 787750.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-134616ENRJuile Rojas1950-04-23UHC-51780-1633671266005396 Meadow Ln # 617, San Diego, CA, 921390.52Name re-casedPhone reformattedSSN last four extractedUnit split from street+2 more
ENR-117831ENRTeresa H Walsh1949-10-07UHC-14924-5485865719161450 Meadow Ln, Las Vegas, NV, 891560.52Name split from “Last, First”Street suffix standardisedAddress re-casedState code upper-cased+2 more
ENR-138064ENRRaymond W Mason1997-01-09UHC-02558-9549691593652597 Mountain View Dr, Austin, TX, 787470.52Date of birth reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-128841ENRCynthia I Kelley1951-10-26UHC-66524-4233555132452490 Meadow Ln, Sacramento, CA, 958220.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112884ENRMason Wood2006-11-17UHC-07180-7237123431119111 Cedar Ln, San Diego, CA, 921340.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-120503ENRHannah P Carter2003-02-12UHC-42439-8931732797226743 Church St, Tempe, AZ, 852330.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-141235ENR—Junk2002-09-26UHC-55937-6042285731475295 Main St, Mesa, AZ, 852410.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-122611ENRJesse Ramos—UHC-50341-3639392439682438 Ocean Ave, Denver, CO, 802810.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-117346ENRAnn X Fields1946-01-03—28028245565259 Valley View Dr, Tempe, AZ, 852410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123544ENRElizabeth U Hanson1962-04-16UHC-09556-36—1298 Meadow Ln, Glendale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-135201ENRLucia K Cox1978-07-03UHC-24416-48—7527 Hillcrest Rd, Tucson, AZ, 857330.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-126229ENRJohn Mendez1971-06-11UHC-77811-8439659576174815 Pine Dr Apt 25, Chandler, AZ, 852800.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-137829ENRLori Fuller1985-09-22UHC-99756-5678192048492591 Camelback Rd, Tampa, FL, 336240.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-122738ENRHolmes U Arjun1978-11-22UHC-29447-82—5851 Main St, Glendale, AZ, 853330.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-105436ENRPriya U Chavez1999-09-07UHC-11128-2042736220843976 Market St, Chandler, AZ, 852780.52Name split from “Last, First”Two-digit birth yearCity re-casedState name converted to code+2 more
ENR-126834ENRBrooks Robert1956-03-14UHC-20176-4233886175538962 Central Ave, San Diego, CA0.52Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-113166ENRMartha J Payne1943-11-21UHC-73293-1385257803575082 Maple Ave, Charlotte, NC, 282060.52Middle initial moved out of first nameName re-casedTwo-digit birth yearPhone reformatted+2 more
ENR-142083ENRChristopher F Parker1978-01-19UHC-38984-8829649949882280 Sage Ct Apt 15, Columbus, OH0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-132845ENRDiane W Wells1941-11-24UHC-04452-606145750929754 Apache Blvd Apt 31, San Diego, CA, 921190.52Date of birth reformattedSSN last four extractedUnit split from streetStreet suffix standardised+2 more
ENR-116470ENRKyle S Jensen1954-08-01UHC-25407-0133442299915279 Spring St, Las Vegas, NV0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102723ENRHelen Muray1952-12-22UHC-97100-194794401429432 River Rd, Los Angeles, CA, 900510.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111077ENRLogan J Clark1938-12-28UHC-88925-675217388404217 Elm St, Gilbert, AZ, 852650.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-101354ENRWillie Austin1998-09-20UHC-42539-11—8903 Baseline Rd, Houston, TX, 770650.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-140459ENRRoger Marshall1998-11-17UHC-50010-56—9125 Camelback Rd, Minneapolis, MN, 554180.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-115081ENRArjun N Cooper1997-01-20UHC-97990-0191021064683243 Ocean Ave, Fresno, CA, 937940.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-129373ENRSharon Campbell—UHC-06772-044465041093878 Canyon Rd, Tucson, AZ, 857180.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-113468ENRMary Knight1949-03-23UHC-69884-47—3855 Camelback Rd, Orlando, FL, 328930.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-107575ENRMartha O Austin1992-04-23UHC-77689-5732030480964820 Ocean Ave, Denver, CO, 802040.52Middle initial moved out of first nameMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
43,101 rows, page 76 of 863PreviousNext