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

Enrollment, lowest dq score first

RecordSourceNameDOBMember IDPhoneAddressQuality scoreFlags
ENR-106484ENRGabriel J Owens1992-12-11UHC-29998-6536666543535073 Desert Sky Blvd, Houston, TX, 770410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142760ENRJeremy O Pierce1955-06-26UHC-58693-807413043936959 Lincoln Way, Jacksonville, FL, 322830.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-130010ENRZachary Black1942-11-02UHC-41546-11—292 Hillcrest Rd Apt 16, Denver, CO, 802780.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-111373ENRKayla S Scott1952-09-07UHC-27673-03—4856 Willow Ct Apt 38, Chandler, AZ, 852560.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-142811ENRAnn Lewis1960-10-11UHC-05814-4381593435537741 Mesa Dr, Tampa, FL, 336810.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-132457ENRDiego Luucas1978-03-27UHC-75643-3064075794798646 Washington St, Denver, CO, 802020.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-112720ENRAnthony P Graham1963-10-09UHC-93791-0797875318108414 Highland Ave, Las Vegas, NV, 891650.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-132359ENRArjun Meyer2002-05-20UHC-42340-6664359503515146 Valley View Dr, Mesa, AZ, 852350.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-112569ENRDouglas Tucker1992-08-22UHC-89410-8797699685325520 Desert Sky Blvd, Glendale, AZ, 853720.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-116991ENRKaren Snyder1983-11-04UHC-39600-5275696212068467 Camelback Rd, Scottsdale, AZ, 852370.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100663ENRCarol B Muphy—UHC-59734-8022165987055507 Elm St, Charlotte, NC, 282640.52Date of birth missingPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-118343ENRVargas Sean1992-06-05UHC-30722-6471682579691611 Lincoln Way, Mesa, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119795ENRHiroshi E Kelly1949-11-19UHC-22344-4167894532155959 Camelback Rd, San Antonio, TX0.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-119347ENRCynthia M King1956-04-22UHC-47003-5528099042071946 Jefferson Ave, Austin, TX, 787750.52Street suffix standardisedAddress re-casedZIP+4 trimmedGender normalised+2 more
ENR-117182ENRNatalie L Elliott1978-11-20UHC-09220-5561087609236038 Desert Sky Blvd # 245, Miami, FL, 331770.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
ENR-116437ENRDouglas E Simpson1967-03-11—40321371387773 Hillcrest Rd Apt 26, Orlando, FL, 328860.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-107745ENRStephanie Hunt1938-10-16UHC-49424-9345620207861688 Grand Ave, San Diego, CA, 921430.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-105151ENRLarry Welch2003-04-21UHC-16931-54—108 Sunset Blvd, Atlanta, GA, 303830.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-141203ENRRobert Miller1984-11-03UHC-71350-3048776955364044 Market St, Minneapolis, MN, 554030.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100756ENRTheresa X Ortiz1985-08-24UHC-35785-1936750860995028 Cedar Ln, Scottsdale, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-125840ENRMei Munoz1964-12-03UHC-70129-3271051937988580 Lake View Rd Apt 2, Tucson, AZ0.52Name split from “Last, First”Date of birth reformattedPhone reformattedUnit split from street+2 more
ENR-141432ENRJulia B Daniels1957-03-11UHC-14003-41—507 Forest Ave # 375, Jacksonville, FL, 322780.52Name re-casedPhone missing area codeUnit split from streetStreet suffix standardised+2 more
ENR-113001ENRBryan Williams2007-08-09UHC-08951-3221983656683380 Park Pl # 671, Tempe, AZ, 852010.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-129786ENRMariana R Little1994-12-11UHC-63829-1838987850261124 Ocean Ave, Seattle, WA, 981960.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-108323ENRYuki Perry1986-12-26—20461521182416 Indian School Rd, San Antonio, TX0.52Name split from “Last, First”Phone reformattedZIP missingEmail lower-cased+2 more
ENR-125382ENRSophia Bell1946-11-12UHC-20089-4654863680091968 Hillcrest Rd, Glendale, AZ, 853920.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-104856ENRAdam V Snigh2002-01-12UHC-60218-2095938368725610 Camelback Rd # 457, Nashville, TN, 372170.52Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+8 more
ENR-137730ENRShirley Patel1990-11-08UHC-16580-0280531789968596 Mountain View Dr, Fresno, CA, 937400.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-117148ENRWillie Y Moore1998-03-23UHC-93388-1131675995536226 Ocean Ave, Eden Prairie, MN0.52Street suffix standardisedAddress re-casedZIP missingGender normalised+2 more
ENR-104887ENRGloria Fox1957-08-02UHC-63442-7557162475511475 Lake View Rd, Sacramento, CA0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-139205ENRTimothy J Tucker1952-07-12UHC-58261-2192785739196457 Hillcrest Rd, Nashville, TN, 372660.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103956ENRJuan S Silva1974-10-08UHC-07687-3365128263895111 Mountain View Dr, Las Vegas, NV, 891750.52Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more
ENR-142068ENRNicholas M Hill1939-12-25UHC-19819-2452376259247755 Canyon Rd, Los Angeles, CA, 900890.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-109043ENRSamuel Williamson2003-10-11UHC-27141-39—8488 Valley View Dr, Austin, TX, 787980.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-137887ENRJean Q Johnson1947-06-09UHC-89715-52—6754 Canyon Rd, Nashville, TN, 372770.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-136328ENRPeter Y West1975-01-06UHC-81086-8169860863649360 Elm St, Los Angeles, CA, 900760.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-116050ENRLaura I Clark2003-12-25UHC-21114-8471058089305815 Grand Ave, Fresno, CA, 937100.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137262ENRWaltre B Bowman1971-04-16UHC-06407-4882938959639491 Apache Blvd, Houston, TX, 770350.52Middle initial moved out of first nameDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119862ENR—Junk1970-03-25UHC-26068-2947251750806252 Valley View Dr, Minneapolis, MN, 554480.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
ENR-123324ENRBrandon I Bell—UHC-96760-8292576789221250 Apache Blvd, Gilbert, AZ, 852180.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-108250ENRYJunk1949-11-20UHC-71270-8033447360839156 Church St, Tucson, AZ, 857920.52Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
ENR-102575ENRAlan Moreno—UHC-82912-03—5285 Ocean Ave, San Diego, CA, 921400.52Name re-casedDate of birth unreadableStreet suffix standardisedAddress re-cased+2 more
ENR-133405ENRStephen Y Webb1950-06-21UHC-02013-7870286412623827 Camelback Rd # 983, Mesa, AZ, 852150.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-137800ENRBarbara X Vargas1982-10-19UHC-68487-655535404131302 Indian School Rd, Glendale, AZ, 853950.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-119147ENRDiana Mendez1997-04-20UHC-96329-81—9376 Pine Dr, Jacksonville, FL, 322600.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-110956ENRDiego D Nguyen1985-12-09UHC-13195-6030684927937290 Hillcrest Rd, Tempe, AZ, 852780.52Name split from “Last, First”Phone reformattedState name converted to codeGender normalised+2 more
ENR-114708ENRBeverly L Wilson1994-07-13UHC-95133-676424395390554 Pine Dr, Atlanta, GA, 303490.52Name split from “Last, First”Middle initial moved out of first nameDate of birth reformattedPhone reformatted+2 more
ENR-124425ENRNoah S Rodriguez1988-05-14UHC-97176-0278369764388528 Harbor Blvd # 702, Los Angeles, CA, 900820.52Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-129453ENRAlexis Ross2001-04-24UHC-76669-0687438088362335 Baseline Rd Apt 19, Atlanta, GA, 303860.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-130122ENRNatalie Payne1972-03-19UHC-54535-1258833607943159 Maple Ave, Columbus, OH, 432680.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
43,101 rows, page 81 of 863PreviousNext