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-109688ENRWillie I Walsh1992-07-21UHC-23657-2397527059248861 Ridge Rd, Eden Prairie, MN, 553130.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
ENR-109689ENRWillie I Walsh1992-07-21UHC-23657-2397527059248861 Ridge Rd, Eden Prairie, MN, 553130.54Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+1 more
CLM-404469CLMJesse Santos1981-06-19UHC-21978-49—8431 Palm Dr, Phoenix, AZ, 850860.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-53721TPABryan Palmer—UHC-88787-64—7401 Lincoln Way, Los Angeles, CA0.54Name re-casedDate of birth unreadableZIP missingGender normalised+1 more
CLM-432107CLMJohn F Cox——24096568539483 Desert Sky Blvd, Houston, TX, 770620.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-59253TPAJoshua Williamson1987-07-19——2202 Apache Blvd, Jacksonville, FL0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
CLM-408024CLMAngela Salazar—UHC-63436-6469964129685809 Mountain View Dr, Minneapolis, MN, 554060.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
TPA-59315TPAWillie Le1969-09-17UHC-73240-85—6908 Oak St, Sacramento, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
CLM-425288CLMAna Banks1964-10-09UHC-54583-9062179605332552 Union St, Houston, TX, 770450.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
CLM-419592CLMJess Lane1971-09-20UHC-38571-5675892106137112 Grand Ave # 411, Phoenix, AZ0.54Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+1 more
CLM-417410CLMRobert M Soto1978-02-19—59665172371690 Church St, Miami, FL, 331320.54Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+1 more
ENR-128766ENRJenny Jensen2001-10-28UHC-53962-932922800161512 Main St Apt 36, Houston, TX, 770300.54Phone reformattedUnit split from streetState name converted to codeZIP+4 trimmed+1 more
ENR-116260ENRBobbby A Schultz1958-07-18UHC-06876-9525630731681371 Maple Ave, Seattle, WA, 981980.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-428757CLMGabirel Sanders2006-05-23—96459396701842 Broadway, Jacksonville, FL, 322490.54Phone reformattedState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
CLM-428758CLMGabirel Sanders2006-05-23—96459396701842 Broadway, Jacksonville, FL, 322490.54Phone reformattedState name converted to codeZIP+4 trimmedEmail lower-cased+1 more
TPA-58422TPAJoshua Hoffman1949-01-03——5706 Desert Sky Blvd, Denver, CO0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-120082ENRDiana Q Oliver2003-10-02UHC-09068-4132825690894633 Hillcrest Rd, Seattle, WA, 981340.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
ENR-136542ENRKimberly L Wiliamson1998-05-10UHC-18983-0526557460277202 Elm St, Miami, FL, 331270.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
ENR-136541ENRKimberly L Wiliamson1998-05-10UHC-18983-0526557460277202 Elm St, Miami, FL, 331270.54Name split from “Last, First”Middle initial moved out of first nameStreet suffix standardisedAddress re-cased+1 more
CLM-403502CLMLori Duncan1965-10-18UHC-77386-40—2740 Oak St, Plano, TX, 750930.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
TPA-53600TPAMark Park1959-03-08——8718 Church St, Gilbert, AZ0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
TPA-55265TPAHeather Graham1970-05-06——7236 Elm St Apt 7, Orlando, FL, 328350.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
CLM-400905CLMAdam Walsh1956-08-01UHC-75549-6367562200016706 Lincoln Way, Denver, CO, 802210.56Two-digit birth yearState name converted to codeGender normalisedWhitespace trimmed
CLM-410152CLMHenry I Hunter—UHC-15194-32——0.56Name split from “Last, First”Date of birth missingGender normalisedPlaceholder values cleared
ENR-112449ENRJerry Anderson2006-12-25UHC-02296-6675570093465218 Lake View Rd, San Antonio, TX, 782270.56Street suffix standardisedAddress re-casedState name converted to codeGender normalised
TPA-61861TPACarl Dominguez—UHC-67933-51—1514 Baseline Rd # 279, Gilbert, AZ, 852240.56Date of birth unreadableUnit split from streetZIP+4 trimmedPlaceholder values cleared
CLM-413141CLMSerah Olson2002-10-06UHC-21778-6775640190996116 Willow Ct, Fresno, CA, 937860.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
ENR-117256ENRSara S Espinoza1997-01-27UHC-90159-0479382003405773 Central Ave, Los Angeles, CA, 900720.56Name split from “Last, First”Two-digit birth yearEmail lower-casedGender normalised
ENR-100920ENRCarolyn Jones1975-12-23UHC-27279-41—6889 Elm St, Mesa, AZ, 852230.56Name split from “Last, First”Phone missing area codeState name converted to codePlan code upper-cased
ENR-129251ENRJanice Schmidt1959-02-27UHC-64276-118367053870658 Ocean Ave, Glendale, AZ, 853450.56Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed
ENR-102965ENRCynthia Torres1956-06-07UHC-01192-28—3928 Grand Ave, San Antonio, TX, 782810.56Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed
ENR-142096ENRJack A Yang1992-01-27UHC-07057-6143598542551847 Central Ave # 632, Gilbert, AZ, 852090.56Name split from “Last, First”Unit split from streetCity re-casedState name converted to code
PRV-22372PRVVirginia Hughes1964-08-27UHC-52299-9134891108868827 Lincoln Way, Denver, CO, 802380.56Name re-casedDate of birth reformattedPhone reformattedMember ID reformatted+6 more
CLM-429646CLMMegan Garrett1944-02-14UHC-79469-26—3207 Cedar Ln, Los Angeles, CA, 900370.56Name split from “Last, First”Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-406874CLMJonathan Ferguson1945-06-13UHC-93124-89—8474 River Rd # 349, San Diego, CA, 921900.56Phone missing area codeUnit split from streetStreet suffix standardisedAddress re-cased
PRV-26829PRVAlice L Marquez1997-08-26—75356761482926 Jefferson Ave # 615, Denver, CO0.56Unit split from streetZIP missingGender normalisedPlaceholder values cleared
ENR-140380ENRHenry Soto1968-02-26UHC-32029-1452426357658371 River Rd, Austin, TX, 787480.56Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed
CLM-416950CLMDenise X Padilla—UHC-97647-24—1651 Hillcrest Rd, Denver, CO0.56Date of birth unreadableState name converted to codeZIP missingPlaceholder values cleared
ENR-137282ENRShilrey Day1939-05-17UHC-72696-7139026856568550 Cedar Ln, Plano, TX0.56Name split from “Last, First”Phone reformattedState name converted to codeZIP missing
ENR-119476ENRJohnny Henry1944-01-19UHC-67530-0785326149989524 Desert Sky Blvd Apt 10, Atlanta, GA, 303910.56Phone reformattedUnit split from streetZIP+4 trimmedGender normalised
CLM-412075CLMRussell Williamson1947-11-06UHC-57475-82—1151 Maple Ave # 756, Miami, FL, 331200.56Two-digit birth yearUnit split from streetGender normalisedPlaceholder values cleared
ENR-107353ENRVargas A Mark1982-06-13UHC-25967-4563824183797658 Oak St, Phoenix, AZ, 850190.56Name split from “Last, First”Two-digit birth yearGender normalisedPlaceholder values cleared
CLM-409242CLMHannah Oliver1951-07-08UHC-60027-75—926 Oak St, Scottsdale, AZ0.56Two-digit birth yearStreet suffix standardisedAddress re-casedZIP missing
TPA-52048TPAVincent Contreras1992-05-18——5174 Forest Ave, Tucson, AZ, 857320.56Two-digit birth yearZIP+4 trimmedGender normalisedPlaceholder values cleared
ENR-135961ENRPhilip Q Valdez2002-07-04UHC-98601-3768550705515651 Ridge Rd, Los Angeles, CA, 900900.56Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised
ENR-111695ENRBetsy Soto1942-07-20UHC-24398-25—4815 Valley View Dr, Tampa, FL, 336580.56Phone missing area codeStreet suffix standardisedAddress re-casedGender normalised
ENR-117587ENRCamila B Snyder1951-11-11UHC-68703-0932555317808443 Valley View Dr, Austin, TX, 787620.56Name re-casedTwo-digit birth yearState name converted to codeGender normalised
ENR-135140ENRLarry R Stephens1941-12-13UHC-87488-2675738561136390 Camelback Rd, Las Vegas, NV, 891260.56Name split from “Last, First”State name converted to codeZIP+4 trimmedPlaceholder values cleared
TPA-61204TPABryan Stevens1978-01-24——2714 Harbor Blvd, Scottsdale, AZ0.56Two-digit birth yearZIP missingGender normalisedPlaceholder values cleared
ENR-136395ENRRuth S Ortiz1991-01-22UHC-29847-4858658040518190 Grand Ave # 315, Los Angeles, CA, 900680.56Name split from “Last, First”Phone reformattedUnit split from streetState name converted to code
100,000 rows, page 219 of 2,000PreviousNext