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-50149TPAAisha Henry2005-07-22——2707 Market St Apt 36, San Antonio, TX, 782680.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-54021TPASamantha Spencer1959-02-23——1630 Lake View Rd, Dallas, TX, 752020.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-63686TPAChristian Coleman2001-06-07—63782266871394 Palm Dr, San Diego, CA, 921750.66Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-55965TPACheryl Ward1986-10-26——1170 Spring St, Nashville, TN, 372580.66Name split from “Last, First”Street suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-56821TPARussell Burton1948-06-02——5524 Valley View Dr, Seattle, WA, 981520.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-61128TPAJose E Palmer1955-11-10——778 River Rd, Columbus, OH, 432340.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-53631TPAIsabella Williams2005-12-04——1402 Maple Ave, Mesa, AZ, 852610.66Name split from “Last, First”Two-digit birth yearCity re-casedWhitespace trimmed+1 more
TPA-58354TPAAmanda King1986-07-04——1813 Maple Ave, Mesa, AZ, 852080.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-55998TPAFrances Jacobs1974-02-01——4632 Baseline Rd, Minneapolis, MN, 554740.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-51036TPARichard Patterson1998-06-23——2676 Market St Apt 31, Nashville, TN, 372430.66Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-52314TPAAlexander N Crawford1994-02-06——1954 Ocean Ave, Los Angeles, CA, 900870.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-64328TPALucia Lucas1942-09-22——6590 Grand Ave, Sacramento, CA, 958270.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50611TPAArthur B Banks1955-09-13——5876 Bayshore Dr, Seattle, WA, 981110.66Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+1 more
TPA-52921TPAAmy Daniels2007-04-08——1993 Main St, San Antonio, TX, 782930.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-63571TPAJudy Knight1961-12-28UHC-66791-46—1771 Ridge Rd Apt 24, Scottsdale, AZ, 852840.66Date of birth reformattedUnit split from streetState name converted to codeWhitespace trimmed+1 more
TPA-53129TPAStephen Ortega1981-12-09UHC-46040-53—6922 Meadow Ln, Gilbert, AZ, 852240.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-58217TPAAlice Wood1946-05-04—86495756751569 Canyon Rd # 345, Seattle, WA, 981550.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-55074TPALinda Smith1989-09-17UHC-68199-20—6905 Hillcrest Rd, Tempe, AZ, 852220.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-52435TPAJudith Riley1985-11-28——2484 Valley View Dr, Columbus, OH, 432470.66Two-digit birth yearZIP+4 trimmedEmail lower-casedWhitespace trimmed+1 more
TPA-54906TPAMark P Kennedy2004-06-24——8236 Main St, Jacksonville, FL, 322020.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-57408TPAJanet Cruz———6842 Oak St, Chandler, AZ, 852440.66Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-58866TPARoger C Wang1971-06-16——932 Park Pl, Denver, CO, 802890.66Middle initial moved out of first nameStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-63864TPASteve Mason1947-02-10——5786 Church St, Austin, TX, 787210.66Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+1 more
TPA-62503TPAMaria Little1940-06-21—42091788521334 Harbor Blvd, Phoenix, AZ, 850300.66Name re-casedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-56294TPAArjun Wells1957-11-04——8956 Desert Sky Blvd, San Diego, CA0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-61736TPACarlos C Sanchez2001-09-06——1565 Jefferson Ave, Eden Prairie, MN, 553010.66Street suffix standardisedAddress re-casedCity re-casedGender normalised+1 more
TPA-63976TPAAndrew Hoffman2004-01-28——8112 Meadow Ln, Tampa, FL, 336900.66Date of birth reformattedState name converted to codeGender normalisedWhitespace trimmed+1 more
TPA-58812TPAKimberly Ruiz———8217 Valley View Dr, Orlando, FL, 328170.66Date of birth unreadableStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-50701TPANathan Lee2006-08-25——5406 Willow Ct, Dallas, TX, 752720.66Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-60478TPAAndrea O Guzman1992-05-15UHC-33667-5243867220124778 Sage Ct, Tucson, AZ, 857730.66Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
TPA-51424TPAOmar Rios1987-10-15——5940 Camelback Rd, Nashville, TN, 372200.66Street suffix standardisedAddress re-casedZIP+4 trimmedWhitespace trimmed+1 more
TPA-52067TPAMadison Freeman1960-11-28UHC-37196-0754493315309182 Willow Ct, Seattle, WA, 981910.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-50479TPAJanet Sanchez2007-08-22——3187 Hillcrest Rd, Tucson, AZ0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-55159TPAGerald King1991-07-16——9108 Palm Dr, Tempe, AZ, 852120.66Name re-casedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-60101TPATerry Weaver1940-10-16——3798 Camelback Rd, Tempe, AZ, 852050.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-57377TPAPeter L Bennett1998-11-28——9378 Cedar Ln, Tempe, AZ0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-53845TPAAnn U Patel1977-06-01——7149 Bayshore Dr, Orlando, FL, 328390.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-52638TPAMaria Danies1982-10-09——5183 Sunset Blvd, Fresno, CA0.66Name re-casedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-50921TPAKathryn Stone1968-08-16—25763362604756 Pine Dr Apt 30, Seattle, WA, 981310.66Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
TPA-51017TPASharon Garza1965-03-01——6519 Union St, Denver, CO, 802470.66City re-casedState name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
TPA-50306TPAMarai Bell2008-04-04——7470 Spring St, Dallas, TX, 752320.66Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+1 more
TPA-58284TPAStephen Alexander1977-05-25——1435 Indian School Rd, Austin, TX, 787010.66Street suffix standardisedAddress re-casedState name converted to codeWhitespace trimmed+1 more
TPA-62916TPABrian Little2007-11-25—39427174467536 Mesa Dr, Orlando, FL, 328600.66Street suffix standardisedAddress re-casedGender normalisedWhitespace trimmed+1 more
TPA-62597TPAHannah Nelson1987-03-10——7495 Mesa Dr, Tampa, FL0.66Name re-casedZIP missingGender normalisedPlan code upper-cased+1 more
TPA-57943TPADorothy Andrews1946-10-15——8554 Hillcrest Rd, Denver, CO0.66Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+1 more
TPA-50157TPAVictoria J Lynch1995-10-10——9353 Baseline Rd, Jacksonville, FL0.66Street suffix standardisedAddress re-casedZIP missingWhitespace trimmed+1 more
TPA-53559TPAAbigail Bradley1974-05-23——3110 Church St, Mesa, AZ, 852100.66Name split from “Last, First”Date of birth reformattedState name converted to codeWhitespace trimmed+1 more
TPA-52404TPAKeith Hayes2007-06-13——6904 Indian School Rd, Dallas, TX, 752830.66Phone missing area codeStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
TPA-51040TPAElizabeth Freeman1945-09-03——3288 Valley View Dr, Denver, CO0.66Date of birth reformattedCity re-casedZIP missingGender normalised+1 more
TPA-63103TPAZachary Ellis2001-06-07——2174 Cedar Ln, Glendale, AZ, 853490.66Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+1 more
14,474 rows, page 89 of 290PreviousNext