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-403620CLMBrandon V Lopez1955-02-03—3293167866—0.52Name re-casedTwo-digit birth yearSSN last four extractedGender normalised+2 more
TPA-60669TPAPeter Wells1946-05-19——2917 Mesa Dr, Miami, FL, 331280.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-128465ENRBilly Z Castillo1961-03-08UHC-03191-11—4676 Harbor Blvd, Atlanta, GA, 303990.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
PRV-23968PRVStephanie S Castillo1999-07-09—35766520336638 Grand Ave, Houston, TX0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
PRV-27636PRVKathryn Warren1959-03-12—31671364606289 Jefferson Ave, Los Angeles, CA, 900130.52Name re-casedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-119543ENRRandy Meyer1984-07-26UHC-39293-8870726199052773 Mountain View Dr, Tucson, AZ, 857530.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-107102ENRVirginia N Smith2001-07-22UHC-62024-7389023009519017 Palm Dr, Atlanta, GA, 303820.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-102670ENRSandra F Wong1991-10-17UHC-64829-08—2833 Ocean Ave, Orlando, FL, 328450.52Two-digit birth yearMember ID reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-125757ENRGeorge J Cooper1988-06-04UHC-06641-6246780914015636 Willow Ct, Tampa, FL, 336690.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-424167CLMMark Reyes1985-09-11——5171 Sage Ct, Gilbert, AZ, 852040.52Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
TPA-60745TPADanialle Pattersoon1947-08-04—74659635105328 Elm St Apt 33, Fresno, CA, 937680.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-404337CLMRuth Q Hamilton1955-10-14UHC-05019-35—8217 Oak St, Phoenix, AZ, 850950.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-409420CLMRichards Luis1969-08-21UHC-28814-4392046173396338 Indian School Rd # 705, Gilbert, AZ, 852250.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-103812ENRBruce L Campbell2000-03-02UHC-55606-0737641560827816 Desert Sky Blvd, Atlanta, GA0.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
PRV-27969PRVKelly Z Perez——51281887248643 Lincoln Way, Sacramento, CA0.52Date of birth missingZIP missingEmail lower-casedGender normalised+2 more
CLM-408384CLMJoe Robinson1941-10-27—26341068895475 Lake View Rd, Jacksonville, FL0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115166ENRNancy Willis1990-11-10UHC-80349-4992588121407572 Bayshore Dr, Los Angeles, CA, 900790.52Date of birth reformattedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-123999ENRJuan S Estrada1965-08-13UHC-86762-06—1448 Main St, Jacksonville, FL0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
PRV-21721PRVDeborah Baker1994-06-22—57151857093889 Canyon Rd, Plano, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-115968ENRStephen Hayes1954-03-20UHC-21260-7064334714673539 Union St, Scottsdale, AZ, 852030.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135484ENRBeverly Andrews1967-12-18UHC-52608-7951663472462649 Canyon Rd Apt 13, Nashville, TN, 372990.52Name re-casedPhone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-425672CLMPaul Richardson—UHC-64897-23—2787 Park Pl, Tampa, FL, 336690.52Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-116372ENRMateo Garza1977-06-20UHC-27538-3572274710496866 Central Ave, Atlanta, GA, 303520.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-21011PRVBradley Gilbert2005-03-24——600 Maple Ave, Las Vegas, NV, 891230.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
CLM-424701CLMSarah Guzman1958-02-16UHC-06472-19—2816 Sage Ct, San Antonio, TX, 782820.52Name re-casedTwo-digit birth yearPhone missing area codeStreet suffix standardised+2 more
ENR-100774ENRJudith J Chavez1947-08-17UHC-03402-97—3704 Sunset Blvd Apt 2, Orlando, FL, 328930.52Name split from “Last, First”Date of birth reformattedUnit split from streetCity re-cased+2 more
ENR-104951ENRGerald F Miller1983-04-03—85063317603450 Maple Ave Apt 39, Denver, CO, 802180.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
TPA-58542TPAWei Fisher2004-10-11—88769848013607 Meadow Ln, Houston, TX, 770740.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-118628ENRJessica N Pena1967-12-17UHC-66466-5370296773636112 Washington St, Fresno, CA, 937460.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-138761ENRMelissa Y Delgado2007-07-28UHC-61902-2147350654615380 Apache Blvd, Fresno, CA, 937690.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403093CLMSharon Olson1999-08-10UHC-00596-77—8016 Willow Ct, Houston, TX, 770600.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-24700PRVJennifer Wong1988-03-02—72356249182502 Sunset Blvd # 313, San Antonio, TX, 782580.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
TPA-61291TPAMichael Baker2003-07-12——3497 Oak St Apt 25, Eden Prairie, MN, 553040.52Name split from “Last, First”Unit split from streetCity re-casedGender normalised+2 more
ENR-117798ENRHeather Ramirez1985-09-07UHC-96401-9467566956873843 Main St, Plano, TX, 750500.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137881ENROlivia Montgomery—UHC-04428-7988561618369665 Market St Apt 40, Gilbert, AZ, 852000.52Name re-casedDate of birth unreadablePhone reformattedUnit split from street+2 more
ENR-122535ENRWayne E Morris1984-06-07UHC-85819-24—3686 Main St, Charlotte, NC, 282670.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-137698ENRPatricia Coleman1958-05-18UHC-71949-76—6613 Apache Blvd, Atlanta, GA, 303440.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-112486ENRPriya K Weber1977-01-08UHC-74953-2068954537247071 Forest Ave Apt 21, Glendale, AZ, 853980.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
TPA-50386TPACharlotte Stevens1957-02-02——4201 Spring St, Gilbert, AZ, 852260.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-417231CLMHiroshi Vazquez1939-07-09UHC-36775-70—1689 Grand Ave, Dallas, TX, 752580.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-403229CLMMegan Perkins1985-09-03——3220 Camelback Rd Apt 8, Seattle, WA, 981960.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-108659ENRDenise T Henderson1969-04-06UHC-14987-5652050087405931 Jefferson Ave, Tampa, FL, 336110.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-111392ENREmma I Kennedy2004-08-12UHC-01628-5685557733813560 Hillcrest Rd, Scottsdale, AZ, 852040.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-129390ENRMichelle I Pierce1994-12-08UHC-38324-3338535748461752 Washington St, Gilbert, AZ0.52Name split from “Last, First”Phone reformattedMember ID reformattedZIP missing+2 more
ENR-120031ENRWillie T Gonzales1977-08-26UHC-39002-3771150878197499 Canyon Rd, San Antonio, TX, 782990.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127459ENRJeremy Clark1978-02-18UHC-95821-8772391837876975 Ridge Rd, Houston, TX, 770140.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137767ENRNatalie A Alvarez2001-11-26UHC-85005-3334694631859730 Canyon Rd, Austin, TX, 787600.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
TPA-53372TPANatalie Burton1967-05-28——523 Main St Apt 11, Tucson, AZ0.52Name re-casedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-410694CLMDavid Woods2007-12-12—57167532619773 Washington St Apt 24, San Antonio, TX, 782830.52Two-digit birth yearPhone reformattedUnit split from streetZIP+4 trimmed+2 more
CLM-401259CLMNancy Delgado1969-01-08——6958 Park Pl, Orlando, FL, 328160.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
100,000 rows, page 183 of 2,000PreviousNext