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-115904ENRRusesll Williamson1947-11-06UHC-57475-8289474513211151 Maple Ave Apt 16, Miami, FL0.54Name re-casedPhone reformattedSSN last four extractedUnit split from street+1 more
CLM-428220CLMAustin Welch1963-04-23UHC-09700-72—278 Palm Dr # 115, Gilbert, AZ, 852770.54Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-50364TPAAgela R Yang1970-01-18——7662 Oak St, Austin, TX, 787020.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-106400ENRRussell M Elliott2003-09-13UHC-96694-1448567806731646 Grand Ave, Atlanta, GA, 303300.54Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+1 more
ENR-105721ENRJudy B Rose1960-02-14UHC-80661-8566131651601226 Highland Ave # 942, Sacramento, CA, 958650.54SSN last four extractedUnit split from streetCity re-casedGender normalised+1 more
ENR-116784ENRJames Jordan1997-05-17UHC-70442-50—9233 Valley View Dr, Columbus, OH0.54Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-424139CLMSofia Walker1998-10-01——3784 Oak St # 275, Mesa, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
PRV-28199PRVKevin Guerrero—UHC-55296-6537958914364927 River Rd, Fresno, CA0.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-63287TPANathan Campbell1985-11-19UHC-33373-4385252580318466 Lake View Rd, Seattle, WA, 981030.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-116030ENRMaria Matthews1967-12-24UHC-24311-209173203898380 Oak St, Minneapolis, MN, 554590.54Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-407705CLMJohn Bradley1973-03-13UHC-80398-485965673213349 River Rd, Chandler, AZ, 852660.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-106429ENRMateo K Romero1974-12-01UHC-51186-2453621282751501 Bayshore Dr # 237, Scottsdale, AZ0.54Name split from “Last, First”Phone reformattedUnit split from streetZIP missing+1 more
CLM-431133CLMNancy Ryos1977-12-11UHC-76965-35—9570 Broadway Apt 21, Scottsdale, AZ, 852940.54Date of birth reformattedUnit split from streetAddress re-casedZIP+4 trimmed+1 more
ENR-123411ENRDonald E Burns1976-06-18UHC-07422-525682396235887 Mesa Dr Apt 27, Fresno, CA, 937800.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
TPA-52092TPABradley Schmidt1954-04-16———0.54Name split from “Last, First”Two-digit birth yearGender normalisedWhitespace trimmed+1 more
CLM-400302CLMLauren Davis—UHC-98479-3653430283544206 Baseline Rd Apt 26, Scottsdale, AZ, 852640.54Date of birth missingUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-131085ENRIsabella D Cen1952-04-22UHC-16836-612087295520577 Willow Ct, Tempe, AZ, 852600.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-55164TPALaura Jensen2003-06-19——6137 Indian School Rd, Sacramento, CA, 958760.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-127675ENRLori W Johnston1998-12-05UHC-64408-2966036419779855 Valley View Dr, Sacramento, CA, 958660.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
CLM-403747CLMCynthia Castro1988-10-16—855699014965 Camelback Rd # 440, Denver, CO, 802070.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-139623ENRSophia Lynch1950-05-02UHC-90674-61—8743 Baseline Rd, Eden Prairie, MN, 553150.54Name split from “Last, First”SSN last four extractedStreet suffix standardisedAddress re-cased+1 more
ENR-126489ENRJulia O Rice1993-04-10UHC-46090-4226372145512155 Valley View Dr Apt 28, Fresno, CA, 937820.54Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-128241ENRBruce Gerza1983-07-07UHC-57480-4965983229325857 Spring St, Houston, TX, 770560.54Name re-casedDate of birth reformattedPhone reformattedStreet suffix standardised+7 more
CLM-417038CLMWalter F Bayley—UHC-39646-96—9810 Market St, Houston, TX, 770090.54Date of birth missingStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-125536ENRNoah Ellis1958-05-02UHC-84589-0764725674877018 Maple Ave, Denver, CO, 802710.54Date of birth reformattedState name converted to codeZIP+4 trimmedGender normalised+1 more
CLM-421869CLMBrenda Grant1962-10-21—74891825439067 Baseline Rd Apt 40, Sacramento, CA, 958820.54Name split from “Last, First”Date of birth reformattedUnit split from streetZIP+4 trimmed+1 more
TPA-58587TPARandy Long1990-01-25——3698 River Rd, San Diego, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-102722ENREvelyn A Fields1942-02-14UHC-07087-2524730255627549 Indian School Rd, Phoenix, AZ0.54Name re-casedDate of birth reformattedSSN last four extractedState name converted to code+1 more
ENR-107146ENRNicole Cunningham2005-01-02UHC-10640-05—7972 Meadow Ln, Phoenix, AZ, 850870.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-409622CLMLarry Moore1979-07-17——399 Sage Ct, Sacramento, CA, 958080.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-422409CLMIsabella Lopez1960-01-05UHC-82562-05—3478 Bayshore Dr, Seattle, WA, 981940.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-125701ENRAngela Flores1985-04-07UHC-81159-03—9795 Washington St Apt 26, Los Angeles, CA, 900210.54Date of birth reformattedSSN last four extractedUnit split from streetEmail lower-cased+1 more
ENR-110081ENRPeter Kelly1981-07-09UHC-28833-2554398157088295 Mountain View Dr, Las Vegas, NV, 891060.54Name re-casedTwo-digit birth yearPhone reformattedZIP+4 trimmed+1 more
CLM-416754CLMMark Sandoval2006-03-22UHC-24042-47—6181 Mountain View Dr, Houston, TX, 770480.54Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+1 more
ENR-103292ENRRaymond V Gardner1993-02-28UHC-88401-1261579796861901 Baseline Rd, Denver, CO, 802420.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-58030TPANoah Wallace1952-12-09UHC-53723-54—3878 Main St, Minneapolis, MN, 554700.54Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-127485ENRMichelle R Carpenter1960-07-18UHC-05548-9265451111328637 Ocean Ave Apt 21, Chandler, AZ, 852780.54Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+1 more
CLM-422180CLMEvelyn X Graham1968-03-17——551 Washington St, Sacramento, CA0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-102333ENRLuis Burke1949-09-03UHC-72644-35—5820 Hillcrest Rd, Houston, TX, 770770.54Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
ENR-129744ENRKaren R Duncan1971-12-27UHC-38258-24—6670 Cedar Ln # 886, Miami, FL, 331630.54Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+1 more
ENR-119859ENRJordan Ellis—UHC-92342-9940729873039877 Mesa Dr, Houston, TX, 770260.54Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+1 more
TPA-59545TPAJesse Rios1905-07-02——8321 Apache Blvd, Miami, FL, 331930.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
CLM-422024CLMRyan I Edwards2000-05-08UHC-79280-23—638 Church St, Gilbert, AZ, 852600.54Middle initial moved out of first nameStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-118337ENRNancy W Mlils1981-07-20UHC-00702-2847063893237380 Oak St # 505, Charlotte, NC0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
ENR-116701ENRBryan Hicks1953-04-25UHC-57811-46—856 Valley View Dr, Los Angeles, CA, 900130.54Name split from “Last, First”Date of birth reformattedZIP+4 trimmedEmail lower-cased+1 more
TPA-59307TPAFrances Diaz1972-11-19——5477 Hillcrest Rd, Houston, TX, 770710.54Name split from “Last, First”Date of birth reformattedState name converted to codeZIP+4 trimmed+1 more
TPA-58971TPAGloria Tran1945-05-04——403 Lake View Rd, Tampa, FL0.54Name split from “Last, First”ZIP missingGender normalisedWhitespace trimmed+1 more
CLM-417727CLMLogan Yang1967-09-12——219 Lincoln Way # 494, San Antonio, TX, 782170.54Name split from “Last, First”Two-digit birth yearUnit split from streetWhitespace trimmed+1 more
ENR-113090ENRJason Cole2007-07-06UHC-46743-1864121137221897 Washington St # 701, Phoenix, AZ, 850060.54Two-digit birth yearPhone reformattedSSN last four extractedUnit split from street+1 more
CLM-403238CLMRichard Luna1986-01-18UHC-69234-20—2149 Mesa Dr, Jacksonville, FL, 322670.54SSN last four extractedStreet suffix standardisedAddress re-casedGender normalised+1 more
100,000 rows, page 195 of 2,000PreviousNext