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-58475TPABenjamin Q Robinson1996-03-16—5977630116625 Park Pl, Tucson, AZ, 857700.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-55679TPAIsabella Rose1952-12-19——7391 Church St, Jacksonville, FL, 322720.82Name re-casedTwo-digit birth yearPlaceholder values cleared
TPA-55137TPAMarilyn Q Marshall1942-03-23——8369 Hillcrest Rd, Chandler, AZ, 852260.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60281TPAAna Foster1989-09-08—3276168309—0.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-62449TPAKevin Matthews1965-08-15———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-63503TPAHeather Ramirez1986-12-06—36336026438776 Apache Blvd, Minneapolis, MN, 554880.82Name re-casedGender normalisedWhitespace trimmed
TPA-50220TPABobby Rios1977-09-18——6800 Mesa Dr Apt 10, San Antonio, TX, 782160.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-56414TPASofia Anderson1984-01-21—3165778943—0.82Name split from “Last, First”Phone reformattedPlaceholder values cleared
TPA-51688TPAMaria Munoz1974-05-22——7712 Cedar Ln, Tempe, AZ, 852570.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-60198TPAAndrea Stewart1963-09-05——9243 Pine Dr, Chandler, AZ0.82ZIP missingWhitespace trimmedPlaceholder values cleared
TPA-60010TPASharon Sims1954-10-15——6678 Canyon Rd, Atlanta, GA, 303490.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-56707TPATyler L Chapman2005-02-26——6201 Mountain View Dr, Sacramento, CA, 958110.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62893TPASara Romero1961-01-11——1684 Market St, Tucson, AZ, 857340.82State name converted to codeEmail lower-casedPlaceholder values cleared
TPA-61013TPADenise Alexander1954-06-06—40855209218510 Central Ave, Miami, FL, 331210.82Name re-casedGender normalisedPlaceholder values cleared
TPA-62702TPAPatricia Coleman1958-05-18——6613 Apache Blvd, Atlanta, GA, 303440.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56006TPABetty Simmons1972-11-14——797 Maple Ave, San Diego, CA, 921700.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-58946TPARalph Harrison1982-05-22—72744817237695 Union St, Austin, TX, 787830.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-63536TPALisa Y Larson1984-07-02——6402 Sage Ct, Orlando, FL, 328900.82Phone missing area codeWhitespace trimmedPlaceholder values cleared
TPA-52072TPADan Butler1953-12-10UHC-11269-20—5515 Maple Ave, Las Vegas, NV, 891790.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56914TPANoah Black2000-05-15———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-54416TPAPriya Aguilar2000-10-24——6298 Pine Dr, San Diego, CA, 921430.82Name re-casedStreet suffix standardisedAddress re-cased
TPA-62181TPADonald Adams1946-11-07——9804 Sunset Blvd, Plano, TX, 750030.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-52785TPAJanice Ellis1972-04-17———0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53758TPAWilliam Hayes1968-09-28—2172709195—0.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-52874TPAAllbert Banks1998-02-12—88457812584654 Lake View Rd, San Diego, CA, 921440.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-53643TPACamila Williams1956-07-24UHC-48033-98—9110 Mesa Dr Apt 3, Sacramento, CA, 958470.82Date of birth reformattedUnit split from streetPlaceholder values cleared
TPA-58501TPAGabriel Espinoza1939-11-25———0.82Name re-casedGender normalisedPlaceholder values cleared
TPA-57152TPADiana Owens1973-10-06——8103 Willow Ct, Minneapolis, MN, 554930.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57154TPASteven Guzman1960-11-07UHC-93254-06—1507 Central Ave, Houston, TX, 770230.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-59697TPANancy Ryan1989-03-05——249 Spring St, Plano, TX, 750530.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-54745TPAJustin Estrada1999-10-01——6120 Maple Ave # 470, Jacksonville, FL, 322620.82Unit split from streetWhitespace trimmedPlaceholder values cleared
TPA-54113TPAKyle Li1946-05-20——1871 Ocean Ave, Charlotte, NC, 282170.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-56966TPABetty Hart1993-04-17——4852 Union St, Charlotte, NC, 282290.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-61550TPAAnn U Bailey2005-01-06——6633 Oak St, Chandler, AZ, 852100.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57779TPALauren Stevens1963-09-02———0.82Date of birth reformattedGender normalisedPlaceholder values cleared
TPA-53760TPAYuki Gibson2005-09-19—30845094054005 Main St, Glendale, AZ, 853460.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-53509TPALawrence Diaz1938-06-03—9309440897—0.82Phone reformattedSSN last four extractedWhitespace trimmed
TPA-53287TPATeresa Hansen———5250 Jefferson Ave, Minneapolis, MN, 554620.82Date of birth unreadableWhitespace trimmedPlaceholder values cleared
TPA-52145TPAMargaret Gonzalez2005-07-08———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-62717TPALarry Ryan1963-05-24——7997 Pine Dr, Fresno, CA, 937420.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-55732TPAKelly Evans1964-05-28UHC-76873-84—9234 Lake View Rd # 148, Atlanta, GA, 303620.82Unit split from streetState code upper-casedPlaceholder values cleared
TPA-55678TPABobby Long1978-05-14——6499 Desert Sky Blvd, Charlotte, NC, 282550.82Gender normalisedWhitespace trimmedPlaceholder values cleared
TPA-53239TPAArthhur Gilbert1963-09-27——3720 Sage Ct, Fresno, CA, 937750.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-62677TPAVincent Jordan1980-03-11———0.82Two-digit birth yearWhitespace trimmedPlaceholder values cleared
TPA-54313TPABruce Alvarez1981-05-04——8112 Main St, Dallas, TX, 752910.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-52920TPAJoe Stephens2008-02-05———0.82Name split from “Last, First”Date of birth reformattedPlaceholder values cleared
TPA-57356TPAJerry F Willis1998-02-11——5985 Camelback Rd, Glendale, AZ, 853960.82Name split from “Last, First”Whitespace trimmedPlaceholder values cleared
TPA-53674TPAJoe Robinson1941-10-27——5475 Lake View Rd, Jacksonville, FL, 322900.82Street suffix standardisedAddress re-casedPlaceholder values cleared
TPA-57669TPABilly Edwards1985-12-05—21073508035729 Camelback Rd, Tempe, AZ, 852010.82Two-digit birth yearPhone reformattedPlaceholder values cleared
TPA-51924TPALias Campbell1965-10-22——1629 Pine Dr, Denver, CO, 802750.82Name re-casedStreet suffix standardisedAddress re-cased
14,474 rows, page 208 of 290PreviousNext