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-62849TPAJustin Ruiz1971-06-17——4303 Grand Ave, Las Vegas, NV, 891340.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-55363TPAEmma Simmons2001-06-02——1515 Cedar Ln, Austin, TX, 787810.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52992TPAAngela P Ross1939-12-23—54289002596160 Ridge Rd, Tucson, AZ, 857220.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-50159TPAHelen Luna1955-01-13—38786534966305 Palm Dr, Dallas, TX, 752590.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-52205TPAGabriel Sandoval1948-01-09—6976934152464 Sunset Blvd # 832, Plano, TX, 750630.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-56232TPADaniel J Larson1969-07-04——5189 Jefferson Ave, Seattle, WA, 981940.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60657TPABrian Thomas1968-11-22—71673989214478 River Rd, San Diego, CA, 921830.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60224TPAMark Howell2000-10-15UHC-59331-7552262529898095 Bayshore Dr, San Diego, CA0.62Date of birth reformattedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-50494TPAGregory P Salazar1967-09-26——7702 Apache Blvd # 213, Seattle, WA, 981310.62Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
TPA-52966TPAMaria Robinson1962-12-03—2829200240717 Grand Ave, Columbus, OH, 432810.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53416TPADaniel Wang1963-08-01——1901 Valley View Dr, Denver, CO0.62Street suffix standardisedAddress re-casedCity re-casedState code upper-cased+3 more
TPA-61365TPABrian Davis1966-07-20——6652 Park Pl, Jacksonville, FL, 322140.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-60806TPATerry J Hunter1961-07-17UHC-31301-6168362966846487 Oak St, Houston, TX, 770840.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57789TPAWayne Carter1991-01-27——473 Forest Ave, Plano, TX, 750380.62Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
TPA-60329TPADiego Fields1958-05-17—85066460407626 Union St, Los Angeles, CA, 900920.62Date of birth reformattedSSN last four extractedCity re-casedEmail lower-cased+3 more
TPA-50699TPAMelissa Willis1939-06-04UHC-08965-1749695814198088 Lincoln Way, Chandler, AZ0.62Phone reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-59765TPAPatrick Orteega2001-07-20—8212622405348 Cedar Ln, Atlanta, GA, 303050.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53864TPAJohnJunk1998-09-14——8543 Pine Dr, Tampa, FL, 336420.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63238TPAMartha Hunter1960-05-25—20270526525179 Ridge Rd, Nashville, TN, 372160.62Name re-casedDate of birth reformattedPhone reformattedSSN last four extracted+3 more
TPA-58730TPARonald Fowler2001-04-05—86080267601894 Elm St, Glendale, AZ, 853700.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-58731TPARonald Fowler2001-04-05—86080267601894 Elm St, Glendale, AZ, 853700.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60740TPAOmar Perez1976-02-05——5497 Canyon Rd, Las Vegas, NV, 891460.62Date of birth reformattedStreet suffix standardisedAddress re-casedEmail lower-cased+3 more
TPA-50886TPABryan Harrison——80321365356618 Oak St, Austin, TX, 787130.62Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
TPA-58997TPAMaria Romero1964-03-15——4347 Willow Ct, Dallas, TX, 752750.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53464TPAGerald Martinez1955-10-03——4734 Grand Ave, Dallas, TX, 752980.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-54843TPATom Z Berry1992-07-25—88857939831895 Hillcrest Rd, San Diego, CA, 921460.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64179TPASamuel Carter1993-11-27——4509 Sage Ct, Seattle, WA, 981900.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-62464TPAAdam Obrien1982-04-02——4314 Sunset Blvd, Chandler, AZ, 852080.62Name split from “Last, First”Name re-casedDate of birth reformattedStreet suffix standardised+3 more
TPA-57270TPAKeith Ortiz1947-05-06—93826909899658 Washington St, Tempe, AZ, 852760.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54240TPABrryan Martinez2008-10-21—81021988504682 Washington St, Orlando, FL0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50824TPADennis G Spencer2008-11-06——2302 Palm Dr, Scottsdale, AZ, 852060.62Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59680TPAJulie Flores2005-12-02—7857529815354 Lake View Rd, Orlando, FL, 328180.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-57967TPAJennifer Santos1944-02-16—67074618604465 Hillcrest Rd, Seattle, WA, 981300.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60706TPABrenda Carpenter1953-05-23——4125 Canyon Rd, Minneapolis, MN, 554190.62Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
TPA-53088TPABradley Vega1938-06-13—94960894487952 Spring St, Gilbert, AZ, 852740.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64385TPADenise Sullivan1965-08-05—83779444927428 Lincoln Way, Chandler, AZ, 852720.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63708TPABenjamin Jones1989-02-11—79364777545630 Baseline Rd, Plano, TX, 750190.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61583TPAWei James———7550 Sage Ct, Orlando, FL, 328220.62Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+3 more
TPA-57229TPARaymond Santos1959-02-12—89461000251830 Spring St, Atlanta, GA, 303110.62Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-60962TPALori Sanders1943-10-16——1021 Maple Ave, Mesa, AZ0.62Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-55856TPALisa Chapman1946-10-13——9436 Ocean Ave, Dallas, TX, 752140.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50666TPADaniel Wright1970-12-24——1934 Valley View Dr, Orlando, FL, 328560.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52097TPAJason Gomez1945-04-03—37637805396458 Park Pl, Denver, CO, 802330.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64078TPAAbby Carlson1990-04-13—51285595981325 Ocean Ave, Los Angeles, CA, 900890.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51954TPANicole Smith1957-12-16——1545 Willow Ct, Tampa, FL0.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-64250TPAAisha Lawrence1987-04-07—60166936782297 Elm St, Scottsdale, AZ, 852360.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-50789TPARobert Lawrence1947-08-14—30462838502875 Elm St, Columbus, OH, 432370.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50589TPAVincent Roberts1986-05-22UHC-46711-6841462984034910 Mountain View Dr, Sacramento, CA, 958520.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53083TPAJanet McDonald1982-06-05UHC-29446-6039753371655152 Sunset Blvd, Tempe, AZ, 852970.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58144TPAMaria O Harper1941-06-14UHC-43044-73—48 Grand Ave, Seattle, WA, 981570.62Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
14,474 rows, page 35 of 290PreviousNext