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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
CLM-407143CLMDylan Watkins2007-10-27——343 Bayshore Dr, Seattle, WA, 981910.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-127805ENRBrian Fuller1992-11-16UHC-89616-1440762373298939 Spring St, Phoenix, AZ0.54Name split from “Last, First”Phone reformattedZIP missingEmail lower-cased+1 more
ENR-105091ENRRobert T Young1978-11-18UHC-06031-999233945781393 Willow Ct, Tampa, FL, 336860.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-118779ENRMegan Watson1975-04-10UHC-62910-319274237287257 Pine Dr, Miami, FL, 331640.54Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-414983CLMHenry Gray1948-10-20——9612 Jefferson Ave, Charlotte, NC0.54Name split from “Last, First”Two-digit birth yearCity re-casedZIP missing+1 more
TPA-62756TPAAisha Hudson1969-07-28—35159303067330 Sunset Blvd # 237, Tucson, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-62755TPAAisha Hudson1969-07-28—35159303067330 Sunset Blvd # 237, Tucson, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-140809ENRRob Mason1979-01-24UHC-58571-0470255152974934 Mountain View Dr, Orlando, FL, 328390.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-142008ENRDiane A Carr2005-08-14UHC-71365-7563247670892848 Lake View Rd # 813, Seattle, WA, 981020.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-62865TPARoy Wood1950-08-01—76557545815991 Church St # 616, Sacramento, CA, 958810.54Name split from “Last, First”Phone reformattedUnit split from streetGender normalised+1 more
ENR-142080ENREdward Foster1959-01-26UHC-59926-49—9708 Cedar Ln, Mesa, AZ, 852470.54Name split from “Last, First”Phone missing area codeCity re-casedZIP+4 trimmed+1 more
TPA-55633TPABrian Burke1995-01-24——6480 Valley View Dr, Austin, TX, 787760.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-63700TPAFatima Price1945-11-18——3822 Lincoln Way, San Diego, CA, 921740.54State name converted to codeZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-106480ENRAndrea Berry1949-10-18UHC-08295-53—5291 Main St Apt 22, Phoenix, AZ, 850100.54Name split from “Last, First”Two-digit birth yearUnit split from streetState code upper-cased+1 more
CLM-422571CLMValentina Wong—UHC-87911-51——0.54Name split from “Last, First”Date of birth unreadableGender normalisedWhitespace trimmed+1 more
PRV-21097PRVAlbert Marshall1938-08-12—68126721321431 Ocean Ave, San Diego, CA0.54Street suffix standardisedAddress re-casedState name converted to codeZIP missing+1 more
ENR-108985ENRAaron Smith1947-09-28UHC-12751-91—6483 Washington St, Gilbert, AZ, 852530.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
TPA-61318TPALarry Grant1947-01-22UHC-85640-98—5685 Washington St, Austin, TX, 787850.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-102666ENRWayne Jimenez1962-12-03UHC-31574-79—6937 Grand Ave # 107, Las Vegas, NV, 891610.54Date of birth reformattedUnit split from streetZIP+4 trimmedGender normalised+1 more
ENR-116388ENRBeverly Y Hunt1984-05-06UHC-39169-4933733360931902 Maple Ave, Gilbert, AZ, 852460.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-142351ENRJames R Thompson1980-11-03UHC-35914-0184079614076516 Park Pl, Sacramento, CA, 958290.54Name split from “Last, First”Phone reformattedMember ID reformattedZIP+4 trimmed+1 more
ENR-117409ENRJoan A Hamilton2005-09-16UHC-96999-97—9063 Central Ave, Columbus, OH, 432100.54Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+1 more
ENR-129389ENRDaniel Z Black2005-02-09UHC-29762-3895085773414370 Spring St # 194, Phoenix, AZ, 850780.54Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+1 more
ENR-110170ENRStephanie R Murray1978-06-14UHC-88833-2575931342344629 Main St, Eden Prairie, MN0.54Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-134448ENRCamila Chen1977-01-12UHC-66437-324166840302130 Harbor Blvd, Glendale, AZ, 853270.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-134447ENRCamila Chen1977-01-12UHC-66437-324166840302130 Harbor Blvd, Glendale, AZ, 853270.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-122673ENRAmanda Colle1962-01-02UHC-85854-0436547570107895 Camelback Rd, Charlotte, NC, 282700.54Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
PRV-25820PRVNicole Carlson1941-10-20——8802 Pine Dr Apt 3, Tampa, FL, 336630.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58826TPAGloria Torres1991-11-21——156 Sunset Blvd # 548, Charlotte, NC, 282680.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-131881ENRJoyce Sandoval1952-02-20UHC-20229-5723761708328989 Spring St, Chandler, AZ0.54Name split from “Last, First”State name converted to codeZIP missingEmail lower-cased+1 more
CLM-426420CLMWei Nichols———8744 Sunset Blvd, Chandler, AZ0.54Date of birth missingState name converted to codeZIP missingWhitespace trimmed+1 more
CLM-407424CLMPriya Ortiz1946-06-05——3345 Baseline Rd, Tucson, AZ, 857830.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-133644ENRMatthew Z Johnston1962-06-27UHC-06763-5832563134976365 Bayshore Dr, Fresno, CA, 937060.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-137021ENRJoan B Vazquez1958-10-06UHC-66979-80—2813 Valley View Dr, Chandler, AZ, 852830.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-120251ENRMarilyn Stephens2008-08-13UHC-46235-7865053050357632 Camelback Rd Apt 37, Eden Prairie, MN0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54848TPANicole Sandoval1956-12-15—65743447855628 Ridge Rd, Atlanta, GA, 303160.54Two-digit birth yearPhone reformattedState name converted to codeZIP+4 trimmed+1 more
ENR-135963ENRHenry V Obrien1954-02-08UHC-71537-8024091651201614 Camelback Rd, Atlanta, GA0.54Name re-casedState name converted to codeZIP missingGender normalised+1 more
ENR-108795ENRKelly B Richards1995-06-22UHC-61615-4886526591287406 Pine Dr, Orlando, FL0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-423584CLMHaroold O Howell—UHC-51378-7448443126282564 Valley View Dr, Tucson, AZ0.54Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-102019ENRJulie L Washington1939-10-25UHC-19375-2746620155174718 Union St, Scottsdale, AZ, 852980.54Two-digit birth yearPhone reformattedZIP+4 trimmedGender normalised+1 more
ENR-102250ENRPatricia N Price1985-05-18UHC-93968-0360787485268942 Apache Blvd, Phoenix, AZ, 850970.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-104704ENRMary B Miills1967-01-21——2271 Central Ave, Tampa, FL, 336660.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-115579ENRHenry Yang1987-12-03UHC-64402-8971176058274104 Highland Ave, Dallas, TX, 752980.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133891ENRAshley H Castro—UHC-29387-6384663034771834 Jefferson Ave, Austin, TX, 787300.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-58087TPAMelissa Peters1963-11-08—30292776971103 Forest Ave # 117, Eden Prairie, MN, 553860.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-411784CLMBarbara M Yang2003-08-06——2610 Palm Dr # 245, Sacramento, CA0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-119868ENRJoseph Vasquez2003-04-28UHC-79306-78—7705 Willow Ct Apt 7, Miami, FL, 331710.54Name split from “Last, First”Date of birth reformattedUnit split from streetState name converted to code+1 more
ENR-119008ENRVincent F Holmes1948-03-13UHC-50225-8876467461038436 Spring St Apt 26, Mesa, AZ0.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-104333ENRTeresa Hayes1962-10-05UHC-81477-9726236785462774 Pine Dr, Gilbert, AZ0.54Phone reformattedState name converted to codeZIP missingGender normalised+1 more
PRV-28482PRVDeborah Richards1955-06-14——7280 Bayshore Dr, Atlanta, GA, 303960.54Two-digit birth yearPhone missing area codeZIP+4 trimmedWhitespace trimmed+1 more
100,000 rows, page 208 of 2,000PreviousNext