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-50268TPALisa Fernandez1994-08-02—43976447336537 Lake View Rd, Nashville, TN, 372190.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-62541TPAAaron Gonzalez1962-11-03——9680 Mountain View Dr, Seattle, WA, 981030.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62580TPAAndrew Armstrong1987-05-17——7138 Main St, Fresno, CA, 937660.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54885TPAJoyce N Pierce1945-02-01—91497617603413 Spring St, Scottsdale, AZ, 852620.64Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61048TPAMaria Taylor1987-06-06——2393 Valley View Dr, Fresno, CA, 937320.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-50928TPAKatherine H Bowman1957-01-08—77063083555388 Palm Dr Apt 10, Atlanta, GA, 303160.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62992TPAKevin Jimenez1992-11-03——1553 Desert Sky Blvd, Orlando, FL, 328570.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62993TPAKevin Jimenez1992-11-03——1553 Desert Sky Blvd, Orlando, FL, 328570.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-62446TPAGerald Garza1945-04-09——3829 Main St, Denver, CO, 802340.64Name split from “Last, First”Date of birth reformattedState code upper-casedZIP+4 trimmed+2 more
TPA-63651TPARichard Robertson1966-12-04——7513 Mesa Dr, Seattle, WA0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-60191TPAMegan Lawrence1963-11-26UHC-76908-8346173114125603 Baseline Rd, Phoenix, AZ, 850010.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51431TPABilly Robinson1984-10-12UHC-48999-54—8106 Main St, Tucson, AZ0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-58465TPASimpson Tyler1958-12-13——8568 Cedar Ln, Denver, CO, 802720.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62525TPAScott Kelley1995-07-25UHC-50527-9070959049129189 Canyon Rd, Seattle, WA0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58621TPARcahel Wagner1967-02-28—68843017023551 Palm Dr, Columbus, OH, 432100.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61538TPADouglas Edwards1960-12-22—70071706805647 Maple Ave, Scottsdale, AZ, 852440.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-64398TPAAna Howell1940-02-13——8360 Pine Dr, Minneapolis, MN, 554970.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-51438TPAMatthew Howell1973-06-12UHC-16485-71—8776 Maple Ave, Chandler, AZ, 852780.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59938TPADyylan Ramos1961-07-22UHC-33618-3781859985851058 Sunset Blvd, Atlanta, GA, 303360.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56989TPANathan Estrada1946-10-02UHC-05405-1750782497465744 Washington St, Jacksonville, FL, 322730.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61396TPAGary Torres1950-01-13——3540 Harbor Blvd, Chandler, AZ, 852870.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-55960TPAIsaella Payne1990-06-09——2458 Forest Ave, Houston, TX, 770190.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-56391TPASandra Guzman1941-03-22—30994035961098 Central Ave, Chandler, AZ, 852410.64Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-63612TPALawrence Silva1974-07-17—20834876665164 Canyon Rd, Fresno, CA, 937260.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58210TPAEthan Davis1973-12-20—62920194416281 River Rd, Eden Prairie, MN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-57819TPAAdam Reyes2000-06-15——4390 Church St, Minneapolis, MN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-60142TPASteve Maldonado1985-04-19——1352 Desert Sky Blvd, Minneapolis, MN0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-50557TPAFrank Park1940-10-09—64327029249254 Cedar Ln, Sacramento, CA, 958860.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53135TPABrandon Yang2002-08-16—57347700556100 Main St, Nashville, TN, 372330.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61016TPALuis Cruz1945-09-05——8064 Park Pl, Orlando, FL, 328110.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-61684TPAJoan Morales1945-05-09——2787 Union St, Jacksonville, FL, 322180.64Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
TPA-51499TPAEthan Arnold2005-02-01—61768749261015 Oak St Apt 21, Gilbert, AZ, 852860.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56383TPADavid Simmons1959-08-06—61521176381491 Lake View Rd # 546, Fresno, CA, 937130.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-55749TPANatalie Moore1940-10-09——4797 Cedar Ln, Glendale, AZ, 853220.64Name re-casedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-58082TPACamila Ramos1952-05-01—31568154328909 Market St, Charlotte, NC, 282130.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-51824TPAJonathan Richards1968-09-07—69143422074292 Camelback Rd, Charlotte, NC0.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50046TPAWilliam Dean1981-02-05—22069017798983 Spring St, Austin, TX, 787890.64Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-54960TPAChristopher T Reed1952-11-16——1263 Desert Sky Blvd, Tampa, FL, 336420.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-61619TPAGloria Alvarez1956-09-04—48421543986186 Ocean Ave, Denver, CO, 802410.64Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-58200TPACharles Armstrong1998-09-13——1851 Maple Ave, Seattle, WA, 981840.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55312TPAJerry Woods1940-11-09UHC-42920-25—3444 Bayshore Dr, San Diego, CA, 921450.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-56493TPACarl Watson1947-06-14——7251 Washington St, Seattle, WA, 981890.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-64315TPACarl Simmons2003-03-11UHC-25020-08—5222 Ocean Ave, Denver, CO0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-50982TPANoah Cox1963-08-03—21448911171809 Grand Ave, Los Angeles, CA, 900700.64Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-59572TPABetty Jimenez1979-11-25——5854 Lake View Rd, Atlanta, GA, 303780.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60712TPANathan Payne1974-09-14——8774 Canyon Rd, San Antonio, TX, 782990.64Name re-casedDate of birth reformattedState name converted to codeGender normalised+2 more
TPA-58806TPAEmma Gardner1951-08-19—74995490256009 Maple Ave, Miami, FL, 331920.64Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+2 more
TPA-56250TPAEric Freeman1961-04-07UHC-11481-11—533 Highland Ave, Dallas, TX, 752520.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60064TPAAngela D Carlson1968-09-22—79556423394333 Church St, Seattle, WA, 981340.64Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51284TPASarah X Oliver1994-07-09UHC-54619-49—1962 Market St, Minneapolis, MN0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
14,474 rows, page 61 of 290PreviousNext