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-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
PRV-24358PRVNancy C Rojas1999-06-09UHC-90304-33—6782 Pine Dr, Houston, TX0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+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
TPA-60427TPAAdam Griffin1984-03-08——889 Oak St Apt 21, Glendale, AZ, 853700.52Unit split from streetStreet suffix standardisedAddress re-casedGender normalised+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
TPA-51927TPAJohn Morris1958-12-27——5012 Ridge Rd, Miami, FL, 331060.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51926TPAJohn Morris1958-12-27——5012 Ridge Rd, Miami, FL, 331060.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-137730ENRShirley Patel1990-11-08UHC-16580-0280531789968596 Mountain View Dr, Fresno, CA, 937400.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24614PRVJacqueline Gonzales1997-03-13UHC-44443-9654322961785010 Cedar Ln, Mesa, AZ, 852260.52Street suffix standardisedAddress re-casedState name converted to codeGender normalised+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
PRV-21118PRVHannah X Nguyen1972-05-08—72355258658201 Meadow Ln, Dallas, TX, 752930.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+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
CLM-425660CLMArthur Taylor1957-04-05UHC-31787-4995524618817573 Baseline Rd, Atlanta, GA, 303730.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59281TPANoah Cuoper2007-08-28——3408 Grand Ave, Tempe, AZ, 852540.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+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
PRV-24717PRVElijah Montgomery—UHC-48585-51—6026 Sage Ct Apt 5, Denver, CO, 802300.52Name re-casedDate of birth missingUnit split from streetStreet suffix standardised+2 more
CLM-413525CLMBenjamin Peters2006-10-23UHC-96567-22—8029 Mesa Dr, Houston, TX, 770140.52Phone missing area codeStreet 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
PRV-28122PRVSarah N Washington1975-02-02UHC-90115-2831363968377915 Meadow Ln, Fresno, CA0.52Date of birth reformattedState name converted to codeZIP missingGender normalised+2 more
TPA-54341TPATommy Jensen1993-10-28—43399033202508 Maple Ave, Mesa, AZ, 852430.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-425972CLMNatalie Johnston——51442237948028 Camelback Rd, Denver, CO, 802810.52Name split from “Last, First”Date of birth unreadablePhone reformattedZIP+4 trimmed+2 more
PRV-25742PRVDanielle L Lewis1943-03-16—72798932398665 Mountain View Dr # 811, Phoenix, AZ, 850350.52Date of birth reformattedPhone reformattedSSN last four extractedUnit split from street+2 more
ENR-119862ENR—Junk1970-03-25UHC-26068-2947251750806252 Valley View Dr, Minneapolis, MN, 554480.52Phone reformattedStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-406342CLMAmber Tucker1995-05-03UHC-44715-06—8124 Camelback Rd, Sacramento, CA, 958010.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-406343CLMAmber Tucker1995-05-03UHC-44715-06—8124 Camelback Rd, Sacramento, CA, 958010.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
TPA-55798TPARoger Gibson1942-12-06——2278 Canyon Rd, San Diego, CA, 921540.52Name split from “Last, First”Date of birth reformattedZIP+4 trimmedGender normalised+2 more
PRV-20046PRVMari Davis—UHC-35556-5257547170215103 Willow Ct, Tempe, AZ, 852470.52Date of birth missingStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-421114CLMKathryn Gutierrez2000-11-17UHC-77738-1928533338421505 Palm Dr # 577, Austin, TX, 787440.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-420525CLMDenise Ramos1960-12-10UHC-80996-855257937763899 Forest Ave # 582, Denver, CO, 802560.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+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
CLM-426907CLMFrank Garcia1940-07-01UHC-99822-51—9059 Market St, Denver, CO, 802680.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415030CLMLori Campbell1985-03-01UHC-11917-9149344771663207 Valley View Dr, Orlando, FL, 328900.52Two-digit birth yearPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-108250ENRYJunk1949-11-20UHC-71270-8033447360839156 Church St, Tucson, AZ, 857920.52Two-digit birth yearStreet suffix standardisedAddress re-casedWhitespace trimmed+2 more
CLM-416732CLMKathryn I Henderson1953-11-28UHC-09847-52—4192 Market St, Las Vegas, NV, 891340.52SSN last four extractedStreet suffix standardisedAddress re-casedZIP+4 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
TPA-54899TPARussell Andrews———2725 Pine Dr, Chandler, AZ0.52Date of birth missingStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-406194CLMFatima R Perkins1992-04-14UHC-00138-756414426679107 Central Ave, Jacksonville, FL, 322100.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+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
100,000 rows, page 164 of 2,000PreviousNext