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

All sources, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
TPA-57330TPAGerald Foster1992-05-17——368 Church St, Mesa, AZ, 852440.50Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+3 more
CLM-423346CLMMadison D Kelly1952-05-25UHC-20054-54—5238 Sage Ct Apt 9, Nashville, TN, 372750.50Name re-casedDate of birth reformattedPhone missing area codeUnit split from street+3 more
ENR-120076ENRCarlos U Henderson1938-09-10UHC-04658-8388877343143916 Washington St, Plano, TX, 750930.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-129549ENRBenjamin V Payne1991-12-09UHC-66516-3433049426269168 Ocean Ave, Austin, TX, 787790.50Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+3 more
PRV-20523PRVBetty Yuong1987-10-28UHC-02259-5077824858608656 Sunset Blvd, Phoenix, AZ0.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-120567ENRRonald Hoffman1958-08-16UHC-16807-5398921992668607 Ocean Ave, Tucson, AZ0.50Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+3 more
CLM-415578CLMMark H Jones1987-07-17——1605 Central Ave, Glendale, AZ, 853130.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-109703ENRValentina P Johnston1945-05-04UHC-69203-68—7623 Cedar Ln # 378, Tampa, FL, 336570.50Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+3 more
ENR-107885ENRAbigail George1993-07-19UHC-48841-1888239718425368 Lincoln Way, Mesa, AZ0.50Name split from “Last, First”Date of birth reformattedMember ID reformattedStreet suffix standardised+3 more
CLM-424863CLMMaria Weaver1980-05-17UHC-03750-8143659754698311 Valley View Dr, Seattle, WA0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-141874ENRDonna Guzman1957-03-28UHC-41209-8360193209122470 Meadow Ln Apt 38, Austin, TX, 787380.50Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+3 more
ENR-107363ENREugene N Jimenez1984-02-04UHC-93297-6092543858441999 Willow Ct, Eden Prairie, MN, 553970.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-424523CLMBruce Obrien1991-04-12UHC-80024-15—8188 Desert Sky Blvd, Eden Prairie, MN, 553890.50Name split from “Last, First”Name re-casedStreet suffix standardisedAddress re-cased+3 more
CLM-418347CLMMadison P Watsn2001-01-27UHC-15705-4349454299253991 Pine Dr, Phoenix, AZ, 850370.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
CLM-426278CLMNancy Valdez2002-06-24——3019 Park Pl, Tucson, AZ, 857340.50Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+3 more
PRV-28329PRVWallace Thomas1978-02-12UHC-19625-0245963176624115 Market St, Las Vegas, NV0.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-127933ENRVictoria X Estrada1995-09-18UHC-18975-43—1939 Park Pl, Seattle, WA, 981240.50Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+3 more
ENR-131357ENRScott I Tran1946-11-08UHC-41541-2564598471681906 Sage Ct, Houston, TX0.50Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+3 more
ENR-121721ENRWilliam Dixon1965-10-14UHC-96330-9143932391489245 Pine Dr, Miami, FL0.50Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-140790ENRNancy C Contreras2005-09-10UHC-96093-3636078797427476 Cedar Ln Apt 3, San Antonio, TX, 782950.50Date of birth reformattedSSN last four extractedUnit split from streetStreet suffix standardised+3 more
CLM-419532CLMJack Vazquez2006-09-18—72374372297549 Broadway Apt 24, San Antonio, TX, 782820.50Name split from “Last, First”Phone reformattedUnit split from streetCity re-cased+3 more
ENR-101863ENRStephhanie A Black1984-02-20UHC-71521-2680728912713602 Meadow Ln, Mesa, AZ, 852780.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-103064ENRPamela Jensen1984-10-04UHC-45453-8163447759075245 Market St, Las Vegas, NV, 891120.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-133102ENRTeresa Campbell—UHC-61936-6793198353928865 Mountain View Dr, Eden Prairie, MN, 553570.50Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+3 more
PRV-21870PRVMarcus Turner1974-12-07——5655 Bayshore Dr, Columbus, OH, 432620.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
TPA-53767TPASamantha Alvarado1987-10-11—61024222462471 Sunset Blvd, Fresno, CA, 937770.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-431495CLMRebecca W Adams1965-02-17UHC-04443-52—7683 Meadow Ln, Tempe, AZ, 852130.50Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+3 more
PRV-24661PRVTyler Banks2001-05-24—50865463826126 Ocean Ave, Seattle, WA, 981100.50Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+3 more
CLM-419573CLMDylan O Robinson2007-07-15UHC-25806-40—3396 Maple Ave, Orlando, FL, 328190.50Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-137920ENRGary B Wang1996-04-02UHC-83488-5966928707018882 Jefferson Ave, Los Angeles, CA, 900140.50Name split from “Last, First”Two-digit birth yearPhone reformattedMember ID reformatted+3 more
CLM-422046CLMCampbell Carlos1961-06-18UHC-89227-34—1159 Bayshore Dr Apt 18, Austin, TX, 787620.50Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+3 more
ENR-105499ENRKevin Baker2001-01-12UHC-06930-2789668714869150 Church St, Jacksonville, FL, 322250.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-54978TPAFatima Robertson1960-07-14——2081 Ridge Rd, Houston, TX, 770230.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-425829CLMWalter Guerrero2001-02-15UHC-26876-3435487031928015 Apache Blvd # 113, Minneapolis, MN, 554690.50Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-408783CLMEugene Arnold1945-12-07——8379 Valley View Dr, Gilbert, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedZIP missing+3 more
TPA-62415TPADeborah Y Fox1982-06-04——3808 Highland Ave Apt 9, Houston, TX, 770590.50Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-424240CLMRebecca I Myers1985-12-02UHC-44550-43—2515 Palm Dr, Tucson, AZ, 857670.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-136489ENRWayne Z Cruz1964-09-07UHC-31174-70—5670 Indian School Rd, Seattle, WA0.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
ENR-136490ENRWayne Z Cruz1964-09-07UHC-31174-70—5670 Indian School Rd, Seattle, WA0.50Name re-casedDate of birth reformattedPhone missing area codeStreet suffix standardised+3 more
CLM-422062CLMJanet Aguilar1958-11-13——4575 Church St # 766, Tucson, AZ, 857140.50Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+3 more
CLM-407694CLMRobert Weber1982-03-12UHC-94741-69—5930 Maple Ave, Chandler, AZ0.50Two-digit birth yearStreet suffix standardisedAddress re-casedState code upper-cased+3 more
TPA-53156TPATheresa Espinosa1979-02-20—38791014658697 Mountain View Dr, Orlando, FL, 328730.50Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+3 more
CLM-404260CLMRamos Maria1940-05-22UHC-48526-6625579358783571 Sage Ct, Tempe, AZ0.50Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+3 more
ENR-137014ENRBecky C Hamilton1954-02-23UHC-26416-0321551936152665 Indian School Rd, Plano, TX, 750190.50Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+3 more
PRV-20609PRVMike Boyd1992-07-23UHC-19257-7839754317575328 Ridge Rd, San Antonio, TX, 782310.50Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+3 more
ENR-103099ENRDaniel Williams1960-04-16UHC-03175-49—2563 Park Pl, Dallas, TX, 752210.50Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+3 more
TPA-51377TPAAnthony Knight1973-06-22UHC-86954-11—7521 Market St, San Diego, CA, 921530.50Street suffix standardisedAddress re-casedState code upper-casedZIP+4 trimmed+3 more
TPA-50217TPADot X Reyes1994-07-24——8886 Lake View Rd, Orlando, FL, 328680.50Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+3 more
ENR-142303ENRJoan Price1938-10-13UHC-30347-2587752178665568 River Rd, Seattle, WA, 981440.50Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+3 more
ENR-113803ENRRussell E Murray1951-06-16UHC-02728-23—8438 Canyon Rd, Fresno, CA, 937360.50Name split from “Last, First”Date of birth reformattedPhone missing area codeStreet suffix standardised+3 more
100,000 rows, page 103 of 2,000PreviousNext