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-106143ENRCarlos N Yang1966-07-15UHC-31412-8733542562468160 Sage Ct Apt 18, Plano, TX, 750330.52Name re-casedDate of birth reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-109568ENRRachel Q Watson—UHC-77213-1135128691841928 Camelback Rd, San Diego, CA, 921320.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-103465ENRLawrence Morales1957-08-11UHC-63515-18—5156 Forest Ave, Gilbert, AZ, 852620.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-125572ENRPatricia Z Padiilla1941-12-17UHC-08197-5447744156548746 Maple Ave, Minneapolis, MN0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-113668ENRBrian I Hall1946-06-06UHC-70681-11—7724 Ridge Rd, Dallas, TX0.52Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
ENR-111091ENRDoris Nguyen1955-02-12UHC-74700-9290388433514996 Highland Ave, Atlanta, GA, 303560.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-116768ENRDebra K Fields1973-06-12UHC-12024-3370152799011358 Pine Dr, Phoenix, AZ, 850930.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-123012ENRPatricia RJunk1992-08-25UHC-68939-9490897613945270 Highland Ave, Chandler, AZ, 852270.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-141388ENRKenneth S Ross1947-09-04UHC-26589-5290683959744605 Hillcrest Rd, Phoenix, AZ0.52Phone reformattedState name converted to codeZIP missingEmail lower-cased+2 more
ENR-101510ENRYuki W Riley1914-05-23UHC-96554-3239198195022940 Oak St Apt 23, Eden Prairie, MN, 553320.52Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-118602ENRLori M Ferguson2006-08-26UHC-87498-5128490262762459 Highland Ave Apt 17, Glendale, AZ, 853520.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-107073ENRKathleen L Torres—UHC-94701-7281665406596571 Desert Sky Blvd, Scottsdale, AZ, 852000.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-111610ENRAlex P James1942-04-05UHC-26212-3567173907572652 Canyon Rd, Scottsdale, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-125802ENRArthur J Baker1949-02-15UHC-95250-585405256712291 Indian School Rd, Orlando, FL, 328240.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142519ENRChristian Vargas1962-12-25UHC-00336-953648718471827 Sage Ct # 513, Columbus, OH, 432420.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-133571ENRWayne Perkins1943-09-07UHC-83686-3490987719615373 Highland Ave, Mesa, AZ, 852120.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109572ENRPatrycia Sullivan1960-08-06UHC-32585-7278881623577284 Grand Ave, Plano, TX, 750220.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137980ENRMadison S Mendoza1979-10-28UHC-78916-7381880407707638 Lake View Rd, Dallas, TX, 752150.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-133042ENRZachary V Flores1966-05-17UHC-91931-944456029752138 Mesa Dr, Austin, TX, 787200.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-117908ENREvans Viginia—UHC-47098-3649694045676614 Elm St, Scottsdale, AZ, 852840.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-101976ENRJess Medina2002-11-26UHC-92187-0779785684121120 Bayshore Dr Apt 25, Fresno, CA, 937170.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-106393ENRMegan Harris1969-07-07UHC-23742-4350235380535792 Ocean Ave Apt 27, Tampa, FL, 336200.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-137107ENRAna O Adams1944-07-09UHC-91260-0197690968949369 Ocean Ave, Phoenix, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-101362ENRMartha Bailey1972-11-04UHC-06979-9951472729124540 Jefferson Ave, Charlotte, NC0.52Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
ENR-123652ENRRoger Cook1966-01-17UHC-57892-3487382723696721 Harbor Blvd, Eden Prairie, MN, 553480.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135539ENRJoseph T Gonzales—UHC-00602-4688823516578030 Elm St, Houston, TX0.52Date of birth unreadablePhone reformattedZIP missingEmail lower-cased+2 more
ENR-128795ENRKatherine P Hamilton1995-12-12UHC-73729-70309517413110 Mountain View Dr, Columbus, OH0.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127701ENRArthur Gray1996-05-02UHC-88638-1836182429064343 Spring St, Nashville, TN, 372130.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-134468ENRTricia Phillips—UHC-63412-3087737520431441 Harbor Blvd, Austin, TX, 787930.52Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-108251ENRMichael Z Knight1988-08-19UHC-49306-7226094390625698 Meadow Ln, Seattle, WA, 981940.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108537ENRWayne P Oliver1976-04-07UHC-87651-907625235720365 Church St, Sacramento, CA, 958310.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108175ENRLauren O Porter2007-09-10UHC-20565-2962061983831895 Elm St, Glendale, AZ, 853350.52Two-digit birth yearPhone reformattedMember ID reformattedState name converted to code+2 more
ENR-100513ENRCamila Jacobs1976-08-24UHC-42463-757473538814850 Bayshore Dr, Tempe, AZ, 852860.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-113289ENRRobert Y Hunter1967-12-10UHC-35728-26—399 Broadway Apt 2, Los Angeles, CA, 900400.52SSN last four extractedUnit split from streetEmail lower-casedGender normalised+2 more
ENR-103492ENRKaen B Dixon1993-02-27UHC-52328-184654906522439 Maple Ave Apt 34, Jacksonville, FL, 322290.52Phone reformattedUnit split from streetState name converted to codeGender normalised+2 more
ENR-127574ENRDavid Powell2004-04-27UHC-50609-6292597410021225 Canyon Rd, Austin, TX, 787980.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-116746ENRNicole Weber2008-04-01UHC-33244-2322630030868660 Broadway Apt 6, Glendale, AZ, 853540.52Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+2 more
ENR-107360ENRWilliam Bradley1964-03-20UHC-33492-5939827530159247 Jefferson Ave, Glendale, AZ, 853490.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-137681ENRJulie Q Simmons1983-02-16UHC-66793-4458172131911667 Canyon Rd, Miami, FL, 331920.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-101400ENRThomas West1961-12-16UHC-63916-2854761781075325 Hillcrest Rd Apt 7, Dallas, TX, 752110.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-101601ENRChristian Holmes1958-11-23UHC-16278-74—6194 Meadow Ln, Nashville, TN, 372950.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-138998ENRAnna P Andrews2006-02-03UHC-46033-71—1423 Bayshore Dr, Chandler, AZ, 852110.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-105074ENRNancy Gibson1957-12-21UHC-64279-7132631822198709 Forest Ave, Chandler, AZ, 852740.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-142368ENRLauren K Willis1968-03-04UHC-50537-87—3496 Ridge Rd, Seattle, WA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-121830ENRStephanie Bell1940-04-27UHC-76947-2121262171583211 Oak St, Tempe, AZ, 852800.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-121831ENRStephanie Bell1940-04-27UHC-76947-2121262171583211 Oak St, Tempe, AZ, 852800.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-111791ENRJohnson Randy1986-01-11UHC-51182-5143172927837347 Pine Dr # 974, Jacksonville, FL, 322150.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-111169ENRJoan A Johnston2001-03-18UHC-21549-4469385621738718 Desert Sky Blvd, Miami, FL, 331040.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109011ENR—Junk—UHC-18966-01—2701 Mesa Dr, Tempe, AZ, 852400.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133040ENRMadison Russell—UHC-55697-5124721857797334 Mountain View Dr, Tucson, AZ, 857060.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
43,101 rows, page 77 of 863PreviousNext