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
ENR-128063ENREmily Baker1967-12-01UHC-95533-243546649408425 Jefferson Ave, Los Angeles, CA0.36Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-53810TPAShirley Hunt1958-09-01——1390 Indian School Rd # 884, Fresno, CA0.36Name re-casedDate of birth reformattedUnit split from streetStreet suffix standardised+4 more
ENR-136124ENRAisha Webb1997-12-01UHC-57903-459848755549389 Oak St Apt 25, Mesa, AZ0.36Name re-casedMember ID reformattedUnit split from streetStreet suffix standardised+4 more
TPA-57213TPACynthia Brooks1971-07-03—48275561639713 Park Pl # 934, Minneapolis, MN, 554100.36Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
TPA-50001TPAMark Palmer2003-04-05UHC-34757-7981176686476814 Baseline Rd, Dallas, TX0.36Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-100861ENRFrank G Armstrong1968-05-17UHC-33013-4520336447572593 Lincoln Way, Tempe, AZ0.36Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+4 more
CLM-400627CLMJesse Price—UHC-05475-09—5432 Highland Ave, Mesa, AZ0.36Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+4 more
ENR-128259ENRNatalie E Johnson1968-10-03UHC-69553-3142048372223534 Sunset Blvd, Los Angeles, CA0.36Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+4 more
CLM-404297CLM—Junk1965-03-12—68179666659269 Grand Ave, Houston, TX, 770860.36Date of birth reformattedStreet suffix standardisedAddress re-casedCity re-cased+4 more
CLM-425438CLMDonna Hicks1952-04-13UHC-61983-3224393112122177 Highland Ave # 112, Tempe, AZ, 852150.36Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-118740ENRJudith X Gomez1944-02-18UHC-71940-9651427526557594 Pine Dr Apt 27, Denver, CO, 802310.36Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-60805TPAAngela Henry1969-08-26——8514 Desert Sky Blvd, San Antonio, TX, 782760.36Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-133673ENRSara E Robertson—UHC-65179-245869720474910 Forest Ave, Phoenix, AZ, 850050.36Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-124798ENRWalter Robertson1981-06-24UHC-87465-3541467380527128 Lake View Rd, Austin, TX, 787800.36Name split from “Last, First”Phone reformattedMember ID reformattedSSN last four extracted+4 more
ENR-125307ENRMadison F Wheeler1956-01-01UHC-00040-037733851670612 Oak St # 619, Jacksonville, FL0.36Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
CLM-430517CLMCarol Carter1974-11-05UHC-97175-90—6492 Washington St, Chandler, AZ0.36Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-135102ENRRebecca D Mendoza2006-03-10UHC-41468-6086963900349585 Baseline Rd, Houston, TX0.36Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+4 more
ENR-114316ENRBradley M Jacobs1996-07-12UHC-41318-7753764245723077 Bayshore Dr, Charlotte, NC0.36Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+4 more
TPA-56724TPAHannah Carr1943-07-10——8041 Cedar Ln, Sacramento, CA0.36Street suffix standardisedAddress re-casedCity re-casedState name converted to code+4 more
TPA-53943TPAAshley Hansen2005-06-15——9567 Apache Blvd, Tempe, AZ, 852600.36Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
TPA-55387TPAAdam Gordon2008-07-18——2367 Meadow Ln, Glendale, AZ, 853310.36Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+4 more
CLM-422816CLMNatalie Ferguson1942-05-16UHC-75951-23—8350 Hillcrest Rd Apt 20, Tempe, AZ0.36Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-100344ENRShirley D Reynolds1973-09-12UHC-14074-3236033876486472 Desert Sky Blvd Apt 5, Houston, TX0.36Date of birth reformattedPhone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-416025CLMBrenda Nelson1946-06-04UHC-04067-06—1315 Market St, Gilbert, AZ, 852220.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
ENR-107851ENRJanet P Davis—UHC-07165-0857592868526396 Central Ave, Orlando, FL, 328910.36Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+4 more
TPA-59251TPAGabriel Ford2003-05-10——12 Valley View Dr, Eden Prairie, MN, 553200.36Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-116528ENRRyan Martin2008-09-08UHC-11874-064108143067678 Palm Dr Apt 28, Miami, FL, 331870.36Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+4 more
ENR-105495ENRBilly N Hunter1940-03-17UHC-35886-73—7361 Spring St, Plano, TX, 750180.36Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
ENR-139035ENRDonald Payne1959-06-26UHC-97805-0477829095636405 Hillcrest Rd, Gilbert, AZ, 852760.36Name split from “Last, First”Date of birth reformattedPhone reformattedSSN last four extracted+4 more
ENR-125930ENRShirley H Fuller1949-12-03UHC-13808-1071654133002023 Highland Ave, Fresno, CA, 937480.36Name re-casedTwo-digit birth yearPhone reformattedMember ID reformatted+4 more
PRV-23102PRVHannah Rivera1967-09-15UHC-32282-4632841469233233 Central Ave, Atlanta, GA0.36Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-115311ENRHeather Sims1964-04-21UHC-55452-4876099839774593 Willow Ct # 738, Fresno, CA0.36Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-400427CLMHeather Hunt2001-05-18UHC-54458-1784443124334288 Baseline Rd, Sacramento, CA, 958900.36Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+4 more
ENR-113483ENRLisa F Morales1946-10-19UHC-21468-84—2095 Washington St Apt 1, San Diego, CA, 921930.36Name re-casedTwo-digit birth yearPhone missing area codeUnit split from street+4 more
ENR-124750ENRMartha K Gardner1995-11-13UHC-10275-6240332811795940 Pine Dr, Columbus, OH0.36Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+4 more
ENR-140639ENRBilly C Jackson—UHC-87710-7348954894205240 Sunset Blvd Apt 15, Dallas, TX, 752520.36Name split from “Last, First”Date of birth missingPhone reformattedUnit split from street+4 more
CLM-403422CLMJoshua Wood1948-11-14——1039 Jefferson Ave Apt 29, Miami, FL, 331510.36Name split from “Last, First”Date of birth reformattedSSN last four extractedUnit split from street+4 more
CLM-414290CLMValentina B Coleman1984-04-09UHC-82461-6364086114725143 Market St, Nashville, TN, 372070.36Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+4 more
TPA-59775TPACynthia Herrera2004-05-23—81461276569088 Mountain View Dr, Atlanta, GA0.36Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+4 more
ENR-108533ENRBarbara Lynch1958-02-01——8824 Maple Ave # 395, Austin, TX, 787420.36Date of birth reformattedPhone missing area codeUnit split from streetStreet suffix standardised+4 more
ENR-101993ENRChristopehr Chen1983-02-11UHC-36761-1096047953667443 Main St # 115, Chandler, AZ, 852510.36Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+4 more
CLM-419402CLMBarb Burton1969-12-14UHC-90454-50—6083 Sage Ct # 679, Glendale, AZ, 853200.36Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+4 more
PRV-29179PRVKimberly K Mills1955-12-07—80162341129137 Main St Apt 17, Gilbert, AZ0.36Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+4 more
TPA-54985TPABilly Hanseen1960-03-13—81192833308826 Grand Ave Apt 5, San Diego, CA0.36Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+4 more
ENR-125459ENRWillie F Harrison—UHC-17637-88—7270 Harbor Blvd, Dallas, TX, 752030.36Name re-casedDate of birth unreadablePhone missing area codeStreet suffix standardised+4 more
ENR-106718ENRDaniel Q Gardner1953-02-02UHC-59419-2567586215624731 Central Ave Apt 26, Orlando, FL0.36Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+4 more
ENR-142826ENRMargaret B Vasquez1962-10-26UHC-19632-9755856107207899 Church St, Scottsdale, AZ0.36Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+4 more
PRV-25401PRV—Junk1965-05-18—25478802281428 Maple Ave, Orlando, FL0.36Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+4 more
CLM-425981CLMGerald D McDonald——47546711734680 Forest Ave, Tucson, AZ0.36Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+4 more
ENR-101233ENRJohn Taylor—UHC-19378-1046738576518613 Washington St # 791, Atlanta, GA, 303740.36Name re-casedDate of birth unreadablePhone reformattedUnit split from street+4 more
100,000 rows, page 20 of 2,000PreviousNext