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

Third-party administrator, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-60734TPABetty Scott1987-07-27——3319 Washington St, Plano, TX, 750060.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57536TPAArjun Ramos1999-09-18——5493 Apache Blvd, Dallas, TX, 752800.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-54554TPANathan E Ramirez———6336 Canyon Rd, Columbus, OH, 432270.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-53276TPAThersea Little1957-10-27—24754023813599 Meadow Ln, Eden Prairie, MN0.66Name re-casedPhone reformattedZIP missingGender normalised+1 more
TPA-64400TPAChris Porter1972-09-25——3330 Washington St, Tempe, AZ, 852220.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-63375TPANatalie Z Silva1982-06-24——6923 Bayshore Dr, Eden Prairie, MN0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-61974TPAJeremy Howell1981-03-25—42451353756008 Sage Ct, Minneapolis, MN, 554740.66Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-61183TPAAna Fernandez1968-02-05——5819 Hillcrest Rd, Fresno, CA, 937890.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-60390TPAFank Ruiz1947-03-26—46171427672396 Lake View Rd, Eden Prairie, MN, 553400.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56422TPAChristopher Robertson1969-07-26—66140270202940 Valley View Dr, Orlando, FL, 328220.66Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55707TPAGregory Schultz1969-02-25UHC-14832-94—5342 Lincoln Way, Las Vegas, NV, 891940.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-50851TPAMatt Carpenter1955-06-10UHC-33751-8223637035816282 Desert Sky Blvd, Orlando, FL, 328570.66Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+1 more
TPA-64205TPALogan Marshall—UHC-13279-34——0.66Name re-casedDate of birth unreadableGender normalisedWhitespace trimmed+1 more
TPA-59738TPAJanet Ryan1948-04-08——1484 Mesa Dr, San Antonio, TX, 782030.66Street suffix standardisedAddress re-casedState name converted to codePlan code upper-cased+1 more
TPA-61347TPAEmily Knight1985-04-13——7278 Harbor Blvd, Jacksonville, FL0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-61666TPARachel Kennedy1975-07-09—94262408818703 Park Pl, Phoenix, AZ, 850290.66Name split from “Last, First”Phone reformattedCity re-casedZIP+4 trimmed+1 more
TPA-51873TPASue Sanchez1984-01-12——8249 Desert Sky Blvd, Tampa, FL, 336570.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-56970TPAVirginia M Mejia1986-09-13——6665 Lake View Rd, Austin, TX, 787060.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-61943TPAAustin Powell1946-05-25—51940916289114 Indian School Rd, Los Angeles, CA, 900060.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-61594TPAVirginia Mejia2006-02-17—24123145545994 Canyon Rd # 872, Fresno, CA, 937670.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-60519TPABrenda Perez1983-01-14UHC-39508-6330470508326158 Camelback Rd Apt 23, Houston, TX, 770700.66Phone reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
TPA-56199TPAJoan A Alvarado1946-07-21——8314 Forest Ave, Miami, FL, 331820.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-50021TPAChristian Ruiz1940-09-26——1131 Union St Apt 26, Columbus, OH, 432730.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-63060TPAPamela Kim1980-03-14—76997531972856 Washington St, Minneapolis, MN, 554080.66Name split from “Last, First”Phone reformattedState name converted to codeWhitespace trimmed+1 more
TPA-54909TPAAlan Hoffman1983-06-23UHC-11329-12—3527 Bayshore Dr Apt 5, Fresno, CA, 937780.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-62686TPALori Franklin1982-04-15——3386 Washington St, Jacksonville, FL0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-50460TPAJustin Weber1948-06-28——9726 Palm Dr, Miami, FL, 331310.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55505TPALauren Holmes1992-02-16—21078859498144 Camelback Rd, Austin, TX0.66Name re-casedPhone reformattedState name converted to codeZIP missing+1 more
TPA-57549TPAAnna Coleman1971-06-19——5577 Elm St, Gilbert, AZ, 852380.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-63315TPAJohn Matthews1957-08-27——5065 Indian School Rd, Plano, TX, 750290.66Name re-casedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-60344TPAAdam Morgan1970-12-26——7848 Bayshore Dr, Chandler, AZ, 852680.66Name re-casedTwo-digit birth yearCity re-casedState name converted to code+1 more
TPA-55713TPALaura C Hill1985-12-11——3213 Sunset Blvd, Sacramento, CA, 958970.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-58768TPAMarcus Wallace1951-09-12UHC-87858-93—1408 Forest Ave, Dallas, TX, 752820.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-55501TPADenny Dunn1984-02-25——4708 Valley View Dr, Tucson, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-52257TPACarlos I Richardson1953-10-16——7392 Highland Ave, Las Vegas, NV, 891210.66Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+1 more
TPA-50465TPAMelissa M Moreno2000-09-17——7186 Lake View Rd, Chandler, AZ, 852070.66Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-55108TPAGabirel Hunter1960-02-28——7884 Pine Dr, San Diego, CA, 921680.66Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
TPA-61087TPAChristopher Payne1996-03-28——5133 Canyon Rd, Houston, TX0.66Name re-casedCity re-casedState name converted to codeZIP missing+1 more
TPA-60192TPAChristine Cunningham1980-12-13—34641287119251 Ridge Rd, Dallas, TX, 752960.66Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55804TPACharlotte Gomez1939-09-12—45597288227981 River Rd, Sacramento, CA0.66Two-digit birth yearPhone reformattedZIP missingWhitespace trimmed+1 more
TPA-58827TPALisa Z Bradley1983-04-28—64585012584817 Baseline Rd, Nashville, TN, 372630.66Two-digit birth yearPhone reformattedGender normalisedWhitespace trimmed+1 more
TPA-54937TPALawrence Ray1985-09-17——8789 Sunset Blvd, Miami, FL, 331590.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-54326TPABen Castillo1995-12-09—86961113985381 Jefferson Ave # 581, Austin, TX, 787090.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-58186TPASophia Snider1943-04-09—64447998729603 Jefferson Ave, Fresno, CA, 937470.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-60885TPAJoyce Sanchez1966-10-24UHC-16910-0950790715392620 Market St, Las Vegas, NV0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-52015TPAJudy Long2001-05-20——4143 Apache Blvd, Gilbert, AZ, 852720.66Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-51427TPAJudith Gilbert1955-10-23—73765446767478 Market St, Austin, TX, 787150.66Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-54764TPALaura Ortiz2008-12-16——6655 Grand Ave # 574, Nashville, TN, 372190.66Unit split from streetStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63917TPALauren Ryan1942-09-26—3286179340514 Lake View Rd, Glendale, AZ, 853140.66Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-55127TPAAndrea Espinoza1995-10-20——4990 Church St, Eden Prairie, MN, 553120.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
14,474 rows, page 81 of 290PreviousNext