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-63940TPAEmma Richardson1980-10-14UHC-65412-7671882040042907 Sage Ct, Chandler, AZ, 852540.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58009TPAMarcus Hansen1940-03-12UHC-18688-6446969927618183 Ocean Ave, Phoenix, AZ, 850120.62Phone reformattedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51458TPAAshley Montgomery1991-10-01—25922466841873 Highland Ave, Nashville, TN, 372660.62Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
TPA-61956TPABrittany M Watson1971-04-25UHC-75844-2133483809073073 Market St, Sacramento, CA, 958740.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50240TPAMatthew Lawson1995-05-15—61870710934892 Pine Dr, Mesa, AZ, 852480.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63288TPAScott Hwoell1997-12-18——1511 Willow Ct, Scottsdale, AZ, 852410.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-55844TPATeresa Ford2007-08-17——9494 Market St, Gilbert, AZ, 852590.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-64214TPAMary Mason1942-05-25——3145 Main St, Fresno, CA, 937840.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-60162TPAScott Shaw1980-08-26—90474426036262 Highland Ave, Atlanta, GA, 303930.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63653TPANathan Schmidt1949-02-10UHC-71347-26—9863 Meadow Ln, Mesa, AZ, 852490.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-56473TPAWei Dunn——37561217026309 Lincoln Way, Plano, TX, 750410.62Name re-casedDate of birth unreadablePhone reformattedCity re-cased+3 more
TPA-52695TPAJulie Vasquez1970-04-09UHC-46484-67—3365 Willow Ct, Sacramento, CA, 958160.62Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-51498TPAOivia Hart1943-06-07——2743 Meadow Ln # 668, San Diego, CA, 921450.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-57086TPAJanice Taylor1963-03-26—31987564133353 Canyon Rd Apt 4, Eden Prairie, MN, 553970.62Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-64192TPAAngela Ortiz1957-07-23——8747 Oak St, Phoenix, AZ, 850410.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52884TPAJames Gordon1988-04-11UHC-45160-16—9822 Highland Ave, Tempe, AZ, 852430.62Name re-casedMember ID reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60061TPAAmanda Hall1938-02-04——4950 Willow Ct, Austin, TX, 787020.62Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52907TPADonald Herrera1997-10-22—25745295589786 Central Ave # 996, Minneapolis, MN, 554480.62Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-50206TPASantiago M Peters1999-11-21——8248 Willow Ct, San Antonio, TX, 782100.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53349TPASofia Castro1999-02-28—87046680833667 Cedar Ln, Charlotte, NC, 282530.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-63349TPAKnight Jaen1961-04-01—98029237099744 Jefferson Ave # 257, Fresno, CA, 937440.62Name re-casedPhone reformattedUnit split from streetState name converted to code+3 more
TPA-58125TPACarol Cook1973-12-02UHC-47697-1247664564009188 Central Ave, Nashville, TN0.62Name re-casedPhone reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-61180TPAJennifer Payne1968-12-18—93753779248320 Willow Ct # 279, Glendale, AZ0.62Date of birth reformattedPhone reformattedUnit split from streetCity re-cased+3 more
TPA-62844TPAFrank Sanchez1993-06-22——3489 Ridge Rd, Miami, FL, 331530.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62790TPAGloria Chapman1938-10-11—47826301964425 Mesa Dr, Denver, CO, 802910.62Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61242TPAPriya Smith1955-02-13——743 Ridge Rd, Tucson, AZ, 857460.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54513TPADylan Bailey1962-07-08UHC-11302-7753088599688382 Jefferson Ave, Las Vegas, NV, 891440.62Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-62939TPAHarold Butler1939-08-28UHC-48098-73—151 Valley View Dr, Seattle, WA, 981450.62Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-63379TPAPamela Wallace1988-03-20——8337 Bayshore Dr, Tempe, AZ, 852980.62Name re-casedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-52753TPAGloria Carrll1962-06-15—3744425197731 Washington St, Denver, CO, 802270.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-59283TPADennis Park1948-06-15—62398330775191 Ocean Ave, Charlotte, NC, 282220.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-61834TPASsan Wadr1976-10-13UHC-82540-45—1262 Canyon Rd # 492, Columbus, OH, 432200.62Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-52305TPADylan Hill1962-01-21UHC-19089-3726564231985307 Valley View Dr, Charlotte, NC, 282510.62Name re-casedDate of birth reformattedMember ID reformattedStreet suffix standardised+3 more
TPA-55503TPAFrances Payne1999-10-16——325 Desert Sky Blvd, San Diego, CA, 921130.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-52533TPAVirginia Grant1968-08-03——3062 Forest Ave, Columbus, OH, 432960.62Name re-casedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-53817TPACarlos Li1979-07-08——8294 Grand Ave # 401, Jacksonville, FL, 322660.62Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-59201TPAPamela Arnold1973-11-19—23993554201082 Maple Ave, San Diego, CA, 921840.62Date of birth reformattedStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-61727TPARay V Carpenter1968-04-14—980955363564 Palm Dr # 587, Tucson, AZ, 857200.62Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+3 more
TPA-58149TPAJulia Perkins1945-03-26——5328 Washington St Apt 8, Tempe, AZ, 852690.62Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
TPA-51756TPAHarold West1994-04-02—40557959794445 Sage Ct, Seattle, WA, 981620.62Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
TPA-50138TPALaura Henderson1939-09-02UHC-08977-1656843039726222 Union St, Tampa, FL0.62Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+3 more
TPA-54057TPAGabriel Richardson2002-11-01UHC-41025-9773979411212343 Lake View Rd # 599, Dallas, TX, 752740.62Name re-casedDate of birth reformattedPhone reformattedUnit split from street+3 more
TPA-52045TPAKathleen Obrien1988-02-05——9351 Elm St, Los Angeles, CA0.62Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-50471TPAHeather Ramos1952-08-23—49933695868971 Canyon Rd, San Diego, CA, 921350.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56973TPACharles Ray1951-09-17——8897 Ridge Rd, Nashville, TN, 372270.62Name re-casedDate of birth reformattedSSN last four extractedStreet suffix standardised+3 more
TPA-61805TPABobby Ferguson1975-12-21—69096795024853 Lake View Rd, Chandler, AZ, 852730.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-58739TPAAaron Ortiz1971-12-01—56769061863890 Baseline Rd, Tempe, AZ0.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-53186TPAAmber Green1981-11-20—33454514436965 Baseline Rd, Charlotte, NC, 282690.62Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-60166TPAChristina Mills1988-03-10—69790728318171 Ridge Rd, Plano, TX, 750590.62Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-56045TPABradley Fowler1996-12-25——9853 Lake View Rd, Gilbert, AZ, 852880.62Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
14,474 rows, page 41 of 290PreviousNext