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-122667ENRMaria L Ryan1965-03-01UHC-53814-0728981184928437 Lake View Rd, Atlanta, GA0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-62301TPATimothy Parker1997-01-11—32663797728235 Market St, Eden Prairie, MN, 553680.52Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-115594ENRCarl E Morrison1981-05-14UHC-43729-2421027090692448 Central Ave, Seattle, WA, 981380.52Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+2 more
ENR-105613ENRDaniel K Evans1998-08-16UHC-32054-3973575455906814 Willow Ct # 204, Fresno, CA, 937900.52Name split from “Last, First”Date of birth reformattedUnit split from streetStreet suffix standardised+2 more
ENR-119432ENRWillie McCoy—UHC-22083-4487598473591428 Cedar Ln, Fresno, CA, 937810.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-407497CLMMartha Weaver1987-08-11UHC-63216-91—7449 Jefferson Ave, Scottsdale, AZ, 852260.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-424698CLMRonald Valdez1978-10-18UHC-61056-5572874688169019 Central Ave, Jacksonville, FL, 322340.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-416196CLMCarol Dunn1959-09-09UHC-98857-51—5140 Apache Blvd, Fresno, CA, 937310.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-26002PRVKeith Gordon1965-09-11UHC-14722-6639362931229536 Lake View Rd, Dallas, TX, 752400.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
PRV-26188PRVMariana Montgomery1998-05-26UHC-54015-8681287250365809 Baseline Rd, Fresno, CA, 937150.52Name split from “Last, First”State name converted to codeEmail lower-casedGender normalised+2 more
CLM-429152CLMSusan Hanson1982-10-01UHC-29460-4527152302714755 Maple Ave Apt 23, Minneapolis, MN, 554880.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-52073TPASteven Alvarez1980-01-26—98233050996128 Oak St, Gilbert, AZ, 852770.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-137049ENRJoey C Lynch1949-03-22UHC-21147-7960676074747688 Church St, Tempe, AZ, 852760.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-56289TPAAhmed Marshall1985-05-08——4444 Canyon Rd # 987, Sacramento, CA, 958390.52Two-digit birth yearUnit split from streetCity re-casedGender normalised+2 more
ENR-108640ENRVictoria N Bell1966-06-07UHC-63670-39—6719 Desert Sky Blvd, Fresno, CA0.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-20748PRVChristian Webb1970-03-12UHC-18196-2593064516162076 Mountain View Dr Apt 36, San Antonio, TX, 782590.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-115105ENRSarah W Olson2000-06-19UHC-48451-8475026043085496 River Rd Apt 31, Seattle, WA, 981810.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-126357ENRAnn P Bishop1950-06-14UHC-44942-9054647802541560 Mountain View Dr, Seattle, WA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-126358ENRAnn P Bishop1950-06-14UHC-44942-9054647802541560 Mountain View Dr, Seattle, WA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-109863ENRKeith F Nguyen—UHC-46334-9450880791446118 Harbor Blvd, Phoenix, AZ, 850780.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112888ENRJustin Gibson2005-01-06UHC-79224-70—8984 Maple Ave, Columbus, OH0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
ENR-141456ENRBrandon Moreno1983-09-07UHC-40927-0645238522881197 Hillcrest Rd, Columbus, OH, 432120.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-428027CLMCarl Russell1970-11-28UHC-40882-68—3970 Palm Dr, Dallas, TX, 752040.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-121904ENRDorothy W Wagner1999-11-07UHC-27472-49—1607 Forest Ave # 301, Tucson, AZ, 857330.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-112373ENRIsabella Berry1945-04-01UHC-10949-4768639285508659 Sage Ct Apt 37, Tucson, AZ, 857220.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-139404ENRSara Little—UHC-35431-6972676748996080 Mesa Dr, Atlanta, GA, 303270.52Date of birth unreadableMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117512ENRLawrence G Anderson2001-08-07UHC-75461-1958435695676884 Meadow Ln, San Diego, CA0.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-105325ENRAustin I Rodriguez1994-10-26UHC-11337-6190743487319749 Mesa Dr # 336, Mesa, AZ, 852880.52Two-digit birth yearMember ID reformattedUnit split from streetStreet suffix standardised+2 more
ENR-125963ENRHarold Q Peterson2004-06-22UHC-40852-8332799388607323 Harbor Blvd, Las Vegas, NV, 891910.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-103065ENRJoseph I Moore1968-12-18UHC-87309-8390882735921466 Desert Sky Blvd Apt 20, Dallas, TX, 752390.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-412842CLMGeorge P Evans1942-02-04UHC-58786-7186256003364569 Mesa Dr, Scottsdale, AZ, 852960.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-418020CLMJessica Gordon———7519 Pine Dr, Sacramento, CA, 958100.52Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-429084CLMMariena Williamson1967-04-01—48588576832955 Church St, Fresno, CA0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-138525ENRPatrick F Ford1995-10-11UHC-51035-4180373028509774 Willow Ct, Tampa, FL, 336870.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-108169ENRNoah Fox1999-04-07UHC-77666-11—4470 Meadow Ln, Dallas, TX, 752860.52Name split from “Last, First”Date of birth reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-135905ENRMaargaret Diaz—UHC-18648-6361620966657146 Willow Ct, Columbus, OH0.52Name re-casedDate of birth unreadablePhone reformattedZIP missing+2 more
ENR-126372ENRMegan Guerrero1963-08-27UHC-90598-755893801480370 Forest Ave # 232, Austin, TX, 787560.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-111138ENRJudith S Owens1944-02-28UHC-30369-2694567313634041 Maple Ave, Fresno, CA, 937820.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-60612TPASofia Barnes——41650472342982 Highland Ave Apt 36, Eden Prairie, MN, 553460.52Name re-casedDate of birth unreadableUnit split from streetStreet suffix standardised+2 more
TPA-54117TPABrian Hawkins1990-02-01——9646 Spring St, Nashville, TN, 372750.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-142031ENRBeverly Tran1961-08-17UHC-27198-302719576487112 Canyon Rd Apt 31, Chandler, AZ0.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-400624CLMHarold E Martin1989-10-04—89026719451613 Highland Ave, Seattle, WA, 981250.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-126586ENRBradley Dainels1951-03-27UHC-82783-2159920174894074 Jefferson Ave, Austin, TX, 787510.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53443TPAJudy Little2002-04-17——1140 Cedar Ln Apt 35, Columbus, OH, 432920.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-413734CLMFrank Austni1964-07-03UHC-35904-15—93 Oak St Apt 26, Austin, TX, 787510.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-125852ENRAngela L Wagner1942-12-13——1573 Maple Ave, Tucson, AZ, 857130.52Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-107254ENRJulia Y Morales1986-01-20UHC-43213-7940551220062365 Oak St Apt 2, Plano, TX, 750330.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-139631ENRRonald George1953-09-04UHC-01862-0265988498407249 Palm Dr, Houston, TX, 770960.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123345ENRLogan Yaang1967-09-12UHC-36471-898243758064622 Main St, Chandler, AZ, 852200.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-57493TPADiane Maldonado1965-07-17—61496733358807 Broadway, Minneapolis, MN0.52Name split from “Last, First”Phone reformattedState name converted to codeZIP missing+2 more
100,000 rows, page 141 of 2,000PreviousNext