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-128714ENRTerry Hawkins1953-07-21UHC-65368-0998851141929206 Spring St Apt 28, San Antonio, TX, 782770.54Name re-casedPhone reformattedUnit split from streetState name converted to code+1 more
ENR-108993ENREugene Fisher1969-09-25UHC-45550-4240971579538143 Baseline Rd Apt 36, Chandler, AZ, 852580.54Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+1 more
ENR-125239ENRCheryl C Woods1970-12-19UHC-99601-9892047318916217 Lake View Rd, Minneapolis, MN, 554480.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-124976ENRCharles Sullivan1963-10-07UHC-02731-7882666772593599 Maple Ave, Orlando, FL, 328580.54Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+1 more
ENR-115600ENRRger X Montgomery—UHC-06433-8938321141968238 Sunset Blvd, Miami, FL0.54Middle initial moved out of first nameName re-casedDate of birth missingPhone reformatted+1 more
ENR-141190ENRChristna Bowman1990-10-08UHC-26516-085475891740722 Cedar Ln, Austin, TX, 787240.54Name split from “Last, First”Two-digit birth yearPhone reformattedSSN last four extracted+1 more
ENR-115418ENRZachary Henry—UHC-50301-6356064210924745 Palm Dr, Glendale, AZ, 853310.54Name split from “Last, First”Date of birth unreadablePhone reformattedGender normalised+1 more
ENR-120890ENRYuki Hughes2004-12-26UHC-05636-4052988387374661 Market St, Columbus, OH, 432070.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-106326ENRAnn T Blel1956-02-23UHC-51687-65—712 Indian School Rd, Mesa, AZ, 852580.54Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-117859ENRPauul A Bradley2005-01-19UHC-81814-3782531653943539 Ocean Ave # 665, San Antonio, TX0.54SSN last four extractedUnit split from streetCity re-casedZIP missing+1 more
ENR-101898ENRGerald Roberts—UHC-67087-6184996437284789 Baseline Rd # 864, Seattle, WA, 981560.54Name re-casedDate of birth missingPhone reformattedUnit split from street+1 more
ENR-140220ENRFrances L Burke2000-04-23UHC-81574-0676674353442627 Desert Sky Blvd, Mesa, AZ, 852700.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-141497ENRLaura J Nichols—UHC-18482-5151933024106981 Willow Ct, Denver, CO, 802810.54Name re-casedDate of birth missingMember ID reformattedSSN last four extracted+1 more
ENR-100838ENRHarold McDonald2006-09-18UHC-00925-1081652950931397 Bayshore Dr, Orlando, FL, 328320.54Name split from “Last, First”Date of birth reformattedState name converted to codeGender normalised+1 more
ENR-109157ENRPriya P Webb1983-06-28UHC-01077-3239529175512650 Oak St # 165, Chandler, AZ, 852140.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-140874ENRJoshua J Watson1989-01-28UHC-57517-2972738536785300 Lake View Rd, Atlanta, GA, 303660.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-113650ENRSamuel X Wislon1965-03-08UHC-34455-894118906679866 Forest Ave, Tempe, AZ, 852900.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-126632ENRMartha Y Nichols1989-04-27UHC-63051-72—1787 Jefferson Ave, Mesa, AZ, 852400.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-102338ENRJustin M Gibson—UHC-22092-5041673727682598 Central Ave, Phoenix, AZ, 850250.54Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-136049ENRYuki N Burton2001-06-17UHC-06392-96—1866 Willow Ct, Tempe, AZ, 852440.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-107771ENRAleaxnder Reed1960-08-02UHC-32257-0843527313287671 Church St, Austin, TX0.54Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-120169ENRBrenda Harris1982-06-13UHC-10906-7985253053117288 Elm St Apt 21, Plano, TX, 750330.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-139356ENRMateo Y Gardner1991-11-03UHC-88333-70—2185 Market St, Minneapolis, MN, 554680.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-103248ENRJason Harvey1967-02-16UHC-58543-4626440613937451 Desert Sky Blvd, Tampa, FL0.54Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-130089ENRMark A Garrett1994-11-07UHC-56857-90—9121 Jefferson Ave, Houston, TX, 770950.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117392ENRKimberly Lawson1977-01-25UHC-30977-8990743030474007 River Rd, Denver, CO, 802980.54Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+1 more
ENR-108880ENRDoris Y Cooper1969-06-21UHC-46929-1932283044024151 Valley View Dr Apt 28, Glendale, AZ, 853740.54Phone reformattedUnit split from streetState name converted to codeGender normalised+1 more
ENR-113561ENRJesse Herrera—UHC-64854-8355765931242531 Grand Ave, Miami, FL, 331860.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-137072ENRRyan S Walker1979-07-19UHC-79552-9458973111539299 Hillcrest Rd, Las Vegas, NV, 891020.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-142181ENRJesse Vasquez—UHC-78649-5454989682596969 Indian School Rd, Atlanta, GA, 303310.54Date of birth unreadableSSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-104960ENRMaria Wood1941-12-26UHC-46790-7433899725458674 Hillcrest Rd, Los Angeles, CA, 900070.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-117660ENRDoorthy O Myers1983-07-22UHC-06278-2629699977388147 Harbor Blvd, Houston, TX, 770410.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-117661ENRDoorthy O Myers1983-07-22UHC-06278-2629699977388147 Harbor Blvd, Houston, TX, 770410.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-136008ENRKevin X Cunningham1985-04-13UHC-16391-2093571762497364 Highland Ave, Fresno, CA, 937680.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-138509ENRCheryl S Sanchez2004-10-26UHC-38922-463358407861126 Willow Ct, Miami, FL, 331310.54Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+1 more
ENR-136826ENRKimberly Z Moreno1979-07-04UHC-01332-3383144380214360 Baseline Rd, Miami, FL, 331540.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-142632ENRWillie Bennett—UHC-41101-83—1924 Highland Ave, Columbus, OH, 432250.54Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-142631ENRWillie Bennett—UHC-41101-83—1924 Highland Ave, Columbus, OH, 432250.54Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-132228ENRValentina Kennedy1943-08-06UHC-03137-7335251452535500 Ocean Ave, Glendale, AZ, 853690.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-120944ENRPaul L Henry1950-12-23UHC-44952-3077790248976812 Elm St, Austin, TX, 787560.54Name re-casedDate of birth reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-134289ENRAnthony S Hernandez1959-08-28UHC-52509-78—8419 Lincoln Way, Dallas, TX, 752890.54Date of birth reformattedSSN last four extractedZIP+4 trimmedGender normalised+1 more
ENR-107857ENRArjun H Lucas1945-10-23UHC-89462-9478264658268270 Market St, Fresno, CA, 937200.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-104553ENRChrristian V Munoz1992-02-12UHC-66109-89—1973 Cedar Ln, Sacramento, CA, 958940.54Two-digit birth yearSSN last four extractedZIP+4 trimmedWhitespace trimmed+1 more
ENR-121499ENRWilliam F Simmons1940-08-12UHC-29547-53—3201 Apache Blvd, Nashville, TN, 372240.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-142656ENRJereym Q Walsh—UHC-83689-77—2882 Lincoln Way, Orlando, FL, 328560.54Name split from “Last, First”Date of birth unreadableZIP+4 trimmedWhitespace trimmed+1 more
ENR-112775ENRDiane Dellgado1973-05-02UHC-09723-27—8266 Elm St, San Antonio, TX, 782480.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-104282ENRDaniel Santiago1998-07-24UHC-56034-9968570130545968 Park Pl, Phoenix, AZ, 850280.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117448ENRKeith M McCoy1999-07-22UHC-96522-2637256115166187 Maple Ave, Minneapolis, MN, 554090.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
ENR-122427ENREmily E Wallace1997-05-22UHC-54030-645119659260189 Palm Dr, Scottsdale, AZ, 852830.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-115640ENRJesse H Martin1958-10-04UHC-46287-4335357405302119 Pine Dr, Las Vegas, NV, 891930.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
43,101 rows, page 105 of 863PreviousNext