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-52864TPAGeorge Greene1953-01-17——2020 Union St, Seattle, WA, 981980.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56395TPAMateo Wood1955-03-07—46647868536013 Washington St, Seattle, WA, 981760.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50310TPACarolyn Jones1975-12-23——6889 Elm St, Mesa, AZ, 852230.64Street suffix standardisedAddress re-casedEmail lower-casedGender normalised+2 more
TPA-62771TPAJaniceJunk1962-07-21——4623 Highland Ave, Chandler, AZ, 852340.64Date of birth reformattedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
TPA-54164TPAZachary Perry——63925819281235 Main St, Charlotte, NC, 282370.64Date of birth unreadablePhone reformattedCity re-casedZIP+4 trimmed+2 more
TPA-62681TPAJoe Perry1940-12-09——4480 Willow Ct, Denver, CO0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-62680TPAJoe Perry1940-12-09——4480 Willow Ct, Denver, CO0.64Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52568TPAJordan Duncan1993-06-11——4713 Indian School Rd, Houston, TX, 770660.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59864TPAJlia Certer1993-12-09——7784 Apache Blvd, Columbus, OH, 432660.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-63239TPAChristian Morris1948-10-22——1364 Baseline Rd, Chandler, AZ, 852640.64Two-digit birth yearStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-53126TPAHannah Rose1969-11-16—24653558093727 Sunset Blvd, Denver, CO, 802800.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-55926TPAJoan Dixon1979-07-25——9487 Central Ave, Miami, FL, 331210.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-53886TPABeth Soto1942-07-20UHC-24398-25—4815 Valley View Dr, Tampa, FL, 336580.64Two-digit birth yearMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-50200TPAPhilip B Mendez2005-08-23——7910 Willow Ct, Nashville, TN, 372190.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-61304TPAWilliam Phillips1952-12-19——1219 Desert Sky Blvd, Charlotte, NC, 282220.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-57790TPALogan Davis1977-12-22——6326 Washington St, Mesa, AZ, 852370.64Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60475TPABryan Hamilton2002-06-03—33585433512921 Ocean Ave, Denver, CO, 802230.64Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-64278TPACharles Nunez1953-05-25——1663 Mesa Dr, Seattle, WA0.64Date of birth reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-52447TPAChristine Ward———1291 Lincoln Way, Mesa, AZ, 852160.64Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
TPA-56854TPASusan Padilla1952-06-25—40421611777190 Sunset Blvd, Glendale, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56855TPASusan Padilla1952-06-25—40421611777190 Sunset Blvd, Glendale, AZ0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59338TPANathan Nelson1980-02-19—71485702542023 Park Pl, Tampa, FL, 336080.64Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-59689TPAMary Ramirez1986-05-21——9497 Willow Ct, Eden Prairie, MN, 553790.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62734TPARoger Ross2000-12-27——5420 Valley View Dr, San Antonio, TX0.64Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56569TPAWayne Aguilar1998-01-22——8546 Hillcrest Rd, Columbus, OH, 432040.64Street suffix standardisedAddress re-casedState code upper-casedGender normalised+2 more
TPA-58654TPAChristine Clark1968-02-23UHC-92710-4367249994134908 Elm St, Los Angeles, CA, 900110.64Street suffix standardisedAddress re-casedState name converted to codeEmail lower-cased+2 more
TPA-62139TPAVirginia Chaevz1973-09-22——4032 Meadow Ln, Miami, FL, 331500.64Date of birth reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-56618TPADiego Armstrong1954-07-13—95755832666146 Canyon Rd, Dallas, TX, 752840.64Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-55940TPAKatherine Hunt1961-01-06—24863446606525 Apache Blvd, Mesa, AZ, 852140.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-50811TPASamuel Myers1979-04-02UHC-50709-05—2560 Baseline Rd, Fresno, CA, 937720.64Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-56180TPASamuel Berry1941-01-06—25961640479512 Indian School Rd Apt 34, Tampa, FL, 336570.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-57123TPABillyJunk1964-12-16——9252 Market St, Tucson, AZ, 857080.64Name re-casedStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
TPA-53819TPAVincent Gordon1973-01-03——1710 Central Ave, Miami, FL, 331900.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-60955TPATyler Weber1960-04-13—76592511203535 Market St, Charlotte, NC0.64Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60573TPAJeremy Elliott1977-09-03——1576 Grand Ave, Tucson, AZ, 857840.64Street suffix standardisedAddress re-casedCity re-casedGender normalised+2 more
TPA-54786TPADoris Syms1987-06-10—57893598219430 Grand Ave, Chandler, AZ, 852470.64Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56365TPARoger Graham1985-04-21——8975 Sage Ct # 390, Phoenix, AZ, 850460.64Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57892TPABetty Patel1959-02-07—74277946311321 River Rd # 866, Charlotte, NC, 282910.64Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-57682TPAEvelyn Jensen2005-05-28——9886 Sage Ct, Phoenix, AZ, 850520.64Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63538TPANicole Reynolds1976-07-11——1456 Meadow Ln, Nashville, TN, 372600.64Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-56036TPAJonathan Burns1966-05-01—86371386518059 Palm Dr, San Diego, CA, 921420.64Name split from “Last, First”Phone reformattedState name converted to codePlan code upper-cased+2 more
TPA-51109TPAGerald Howell1941-04-08UHC-70632-7571840393712627 Baseline Rd, Minneapolis, MN, 554230.64Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
TPA-58183TPAKayla Cunningham1964-01-07——8778 Cedar Ln, Atlanta, GA, 303560.64SSN last four extractedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
TPA-53172TPABruce Hart1963-04-13UHC-75859-8380429214228947 Market St, Chandler, AZ, 852880.64Name re-casedTwo-digit birth yearPhone reformattedCity re-cased+2 more
TPA-62883TPALuis Gray2000-03-07——1486 Willow Ct, Denver, CO, 802160.64Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63726TPAStephen Washington1950-03-07—95390446567605 Sunset Blvd # 439, Las Vegas, NV, 891300.64Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-63508TPAHolmes Brittany1989-02-22——1374 Apache Blvd, Columbus, OH, 432660.64Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60449TPAWei Powell1941-11-23—71542872194263 Cedar Ln, Glendale, AZ, 853430.64Name re-casedPhone reformattedSSN last four extractedGender normalised+2 more
TPA-51937TPAWei Gardner1971-04-01UHC-94736-96—7039 Apache Blvd, Columbus, OH, 432440.64Name split from “Last, First”Two-digit birth yearCity re-casedEmail lower-cased+2 more
TPA-61006TPABruce O Cok1960-11-05—4154129145993 Willow Ct, Minneapolis, MN, 554710.64Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
14,474 rows, page 67 of 290PreviousNext