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
CLM-430510CLMRuth Schultz2007-02-04UHC-03534-7074652808561937 Bayshore Dr, San Antonio, TX, 782930.40Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-137422ENRAbigayl Morris1970-06-04UHC-59571-9037058123524579 Central Ave, Miami, FL, 331610.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-57546TPAStephen Martinez———6738 Indian School Rd, Tampa, FL, 336650.40Date of birth missingSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-409914CLMGerald Reyes1994-04-26UHC-79915-5865285665213662 Grand Ave, Gilbert, AZ, 852090.40Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-101201ENRMason N Reynolds1978-09-19UHC-75443-6547138903864261 Ocean Ave, Dallas, TX0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
CLM-420716CLMSandra Owens1972-03-03UHC-34059-29—7000 Harbor Blvd Apt 16, Chandler, AZ, 852710.40Name split from “Last, First”Two-digit birth yearUnit split from streetStreet suffix standardised+2 more
ENR-127830ENRAmy Bennett1970-10-21UHC-28725-9349561175881308 Bayshore Dr, Denver, CO, 802900.40Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-57694TPAJoseJunk1965-08-18——7293 Camelback Rd, Plano, TX, 750650.40Name re-casedState name converted to codeZIP+4 trimmedGender normalised+2 more
PRV-27749PRVAaron Davis—UHC-45592-8477278381641381 Highland Ave, San Antonio, TX0.40Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-131940ENRRuth X Howard1995-01-05UHC-04494-26—8779 Camelback Rd, Orlando, FL, 328690.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-124068ENRDon A Hayes1949-04-16UHC-91495-7180221043435151 Jefferson Ave # 153, Los Angeles, CA0.40Phone reformattedSSN last four extractedUnit split from streetZIP missing+2 more
TPA-52346TPAArjun Nunez1967-01-13—58991435371279 Bayshore Dr, Nashville, TN, 372140.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23217PRVCatherine Cunningham1972-06-16——615 River Rd, Sacramento, CA, 958370.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-402224CLMKimberly Morris1946-08-16——3790 River Rd Apt 2, Tucson, AZ, 857920.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-113745ENRAngela Sims1957-11-02UHC-40464-36—4117 Lake View Rd, Gilbert, AZ, 852090.40Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-119784ENRPamela Austin1943-06-16UHC-05115-47—4921 Grand Ave, Scottsdale, AZ, 852500.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-400426CLMJacqueline Chen1997-08-07UHC-37309-92—5143 Grand Ave, Los Angeles, CA0.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-129939ENRAustin L Contreras1946-03-21UHC-46475-4636522391381920 Pine Dr, Miami, FL, 331450.40Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedSSN last four extracted+2 more
ENR-107659ENRWallace Barbara—UHC-80497-35—3506 Willow Ct, Phoenix, AZ, 850810.40Date of birth unreadablePhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-424742CLMMason Reynolds—UHC-47917-8084725240494475 Indian School Rd, Charlotte, NC, 282760.40Name split from “Last, First”Date of birth unreadablePhone reformattedSSN last four extracted+2 more
TPA-63594TPATeresa Chen1943-11-11—58332527142986 Apache Blvd, Houston, TX, 770590.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-428471CLMKyle Brown2002-05-02UHC-94017-832363788633901 Lincoln Way Apt 11, Seattle, WA, 981370.40Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-56766TPAKeith Williamson1976-03-27—30087778321299 Valley View Dr, Phoenix, AZ0.40Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-139424ENRBenjamin F Taylor1965-12-19UHC-86199-0690283459918247 Lake View Rd Apt 27, Gilbert, AZ, 852170.40Name split from “Last, First”Date of birth reformattedSSN last four extractedUnit split from street+2 more
ENR-111155ENRBrenda Garrett1985-09-28UHC-01984-2425473331683668 Ridge Rd Apt 3, Phoenix, AZ0.40Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-136929ENRKimberly P Henderson1942-10-18UHC-39645-38—4544 Mountain View Dr, Eden Prairie, MN, 553770.40Phone missing area codeStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-121284ENRJose Moore—UHC-25875-0758664088621197 Mountain View Dr # 832, Denver, CO, 802010.40Date of birth unreadableUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-430583CLMAhmed H Sullivan—UHC-97738-74—8848 Desert Sky Blvd, Charlotte, NC, 282960.40Middle initial moved out of first nameDate of birth unreadablePhone missing area codeStreet suffix standardised+2 more
ENR-126387ENRDonald K Wells1959-12-16UHC-76669-77—96 Hillcrest Rd, Jacksonville, FL0.40Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
TPA-61151TPAJosh Ellis1998-09-02UHC-44602-44—1169 Grand Ave, Los Angeles, CA, 900700.40Two-digit birth yearPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
ENR-139008ENRCarol Rose1947-05-13UHC-87748-8941658700228587 Sunset Blvd, Austin, TX0.40Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-102294ENRBradley Rice1983-03-12UHC-06356-6528073810034855 Bayshore Dr, Atlanta, GA0.40Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
CLM-410993CLMCarlos Alvarez1946-05-24UHC-45709-79—2196 Harbor Blvd, Houston, TX, 770960.40Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
CLM-419879CLMDJunk1968-12-08UHC-94194-4643858487493230 Oak St, Houston, TX, 770920.40Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-134339ENRZachary N Schultz1966-05-06UHC-17530-0997880021709272 River Rd, Seattle, WA0.40Name split from “Last, First”City re-casedState name converted to codeZIP missing+2 more
CLM-408488CLMAustin Dominguez1943-02-20UHC-60615-04—6619 Main St, Glendale, AZ, 853200.40Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-423246CLMSophia Lawrenke1989-05-04——2752 Valley View Dr, Charlotte, NC, 282150.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-410025CLMAndrea Morris—UHC-84486-67—3845 Maple Ave, Denver, CO, 802800.40Name split from “Last, First”Date of birth missingStreet suffix standardisedAddress re-cased+2 more
PRV-25064PRVKelly Torres1948-09-25—49588073454174 Ocean Ave, Eden Prairie, MN, 553040.40Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
CLM-416791CLMPark Luis1961-06-19UHC-49347-2778892369847004 Harbor Blvd, Sacramento, CA, 958760.40Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-109369ENRRachel P Aguilar2004-01-13UHC-94877-9057858160612416 Valley View Dr, San Diego, CA, 921210.40Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-126558ENRWei K Griffin1983-07-13UHC-18705-8066941146906937 Union St, Houston, TX, 770010.40Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-141725ENRAnna Griffin—UHC-16810-6859481542869125 Oak St, Tampa, FL, 336070.40Date of birth unreadablePhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-112809ENRJennifer Carr—UHC-51101-2843057557201164 Forest Ave, Las Vegas, NV, 891480.40Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-135096ENRDaniel W Bennett1976-03-28UHC-68092-51—1864 Market St, Austin, TX, 787610.40Phone missing area codeSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-55475TPAAlice L Henry1942-11-22——4514 Indian School Rd, Denver, CO, 802960.40Name split from “Last, First”Middle initial moved out of first nameTwo-digit birth yearStreet suffix standardised+2 more
ENR-135770ENRAlan Walker1985-11-02UHC-20775-123763105842759 Union St, Glendale, AZ, 853870.40Name re-casedTwo-digit birth yearState name converted to codeZIP+4 trimmed+2 more
ENR-115120ENRSantiago C Yang2003-12-24UHC-56718-7573155602598600 Sunset Blvd, San Diego, CA, 921760.40Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedStreet suffix standardised+2 more
ENR-139610ENRBarbara D Flores1961-03-06UHC-29272-0922432946135681 Washington St, Las Vegas, NV0.40Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-429873CLMAmber James1942-02-27UHC-46412-5583986074133347 Forest Ave, Sacramento, CA0.40Name re-casedTwo-digit birth yearSSN last four extractedStreet suffix standardised+2 more
100,000 rows, page 38 of 2,000PreviousNext