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-431046CLMChristine Sullivan2007-09-24UHC-86497-82—4856 Indian School Rd, Eden Prairie, MN, 553320.54Name split from “Last, First”ZIP+4 trimmedGender normalisedWhitespace trimmed+1 more
ENR-102622ENRYuki Weber2002-03-09UHC-48105-6657467953714223 Harbor Blvd, Los Angeles, CA, 900710.54SSN last four extractedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-134729ENRJanice Elliott1978-11-21UHC-88834-7379894390237504 Sage Ct Apt 39, San Antonio, TX, 782910.54Two-digit birth yearPhone reformattedUnit split from streetGender normalised+1 more
ENR-115470ENRKaren Y Watson1972-03-12UHC-16535-9254820061306151 Jefferson Ave, Gilbert, AZ, 852240.54Middle initial moved out of first nameDate of birth reformattedState name converted to codeGender normalised+1 more
ENR-113508ENROmar X Johnson1960-09-03UHC-70459-8355182113556829 Sunset Blvd Apt 35, Tempe, AZ, 852430.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-103546ENRGerald L Santiago1972-10-13UHC-21748-463454765761743 Oak St, Houston, TX, 770770.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-105260ENREthan Rios—UHC-98500-33—4691 Harbor Blvd, Eden Prairie, MN, 553050.54Date of birth unreadablePhone missing area codeState name converted to codeWhitespace trimmed+1 more
ENR-102086ENRTony E Munoz1985-10-20UHC-87343-8672532497187270 Ridge Rd Apt 29, Nashville, TN, 372940.54Name split from “Last, First”Two-digit birth yearPhone reformattedUnit split from street+1 more
ENR-104644ENRAngela D Welch1963-11-11UHC-58809-4897253567182500 Lake View Rd, Jacksonville, FL, 322150.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133973ENRRobert Hill—UHC-09753-4123965116201360 Mountain View Dr, San Diego, CA0.54Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+1 more
PRV-21614PRVAlbert Mason1953-03-14—76959360392440 Desert Sky Blvd, Glendale, AZ, 853550.54Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-430640CLMCynthia Stone1942-04-06UHC-70398-69—3601 Canyon Rd, Fresno, CA, 937540.54Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+1 more
PRV-22713PRVWJunk1997-09-04UHC-42544-6870531177432246 Broadway Apt 10, San Diego, CA, 921260.54Two-digit birth yearUnit split from streetWhitespace trimmedPlaceholder values cleared+1 more
ENR-114832ENRJudy Nichols1977-03-04UHC-99799-36—468 Spring St, Phoenix, AZ, 850030.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
ENR-134195ENREmily Cox1960-11-28UHC-78445-65—3791 Washington St, Eden Prairie, MN, 553680.54Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+1 more
CLM-408274CLMNathan Olsoon1977-08-18UHC-73329-39—7553 Central Ave, Houston, TX, 770340.54Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+1 more
TPA-64446TPASara Butron1983-02-21——5709 Sage Ct, San Diego, CA0.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+1 more
ENR-134211ENRAlexander T Cunningham1961-02-02UHC-18955-2976243490804091 Market St, San Diego, CA, 921530.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-421816CLMWillie Y Allen1989-10-21UHC-31609-15—4882 Highland Ave, Denver, CO, 802910.54Name split from “Last, First”State name converted to codeZIP+4 trimmedWhitespace trimmed+1 more
CLM-428771CLMSandra Bradley1970-05-25UHC-59697-997829315135216 Lake View Rd, Denver, CO0.54Street suffix standardisedAddress re-casedZIP missingGender normalised+1 more
ENR-106374ENRLinda Padilla1947-02-20UHC-69153-86—7195 Cedar Ln Apt 10, Gilbert, AZ, 852690.54Name re-casedTwo-digit birth yearUnit split from streetStreet suffix standardised+1 more
ENR-102870ENRChristopher U Mendoza1940-07-08UHC-01903-5376150257643250 Meadow Ln # 944, Seattle, WA, 981100.54Unit split from streetStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-108210ENRHarold H Gonzalez1941-01-04UHC-11640-0384191835526036 Ridge Rd, Houston, TX, 770140.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-130405ENRFrances D Guerrero1985-09-19UHC-77235-4185774657855198 Main St, Mesa, AZ, 852610.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-407929CLMBryan Ryan—UHC-05334-68—1607 Desert Sky Blvd, Sacramento, CA, 958580.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-134597ENRHarold Aguilar1944-03-18UHC-68897-3924075403761195 Desert Sky Blvd, Las Vegas, NV, 891670.54Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-122927ENRJeffrey Richards1973-01-13UHC-76290-5743235746241712 Indian School Rd, Mesa, AZ, 852670.54Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+1 more
ENR-117060ENRJeremy G Castillo1981-09-28UHC-29703-0261251638363847 Grand Ave, Tempe, AZ0.54Name re-casedTwo-digit birth yearSSN last four extractedZIP missing+1 more
CLM-403112CLMChristina Meyer1954-03-22UHC-19804-16—2100 Meadow Ln, Los Angeles, CA, 900390.54Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+1 more
ENR-133044ENRKathy Guerrero1991-06-07UHC-45206-524987329186787 Cedar Ln, Phoenix, AZ, 850370.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
ENR-133218ENRJeremy Cruz1964-04-15UHC-55958-7954044800269297 Mountain View Dr # 878, Tempe, AZ, 852990.54Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+1 more
ENR-106525ENRNicole X Rice1995-03-17UHC-22461-4727896317478696 Canyon Rd Apt 39, Fresno, CA, 937850.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-109343ENRSara Cooer1938-07-03UHC-45515-34—1053 Pine Dr Apt 28, Minneapolis, MN, 554020.54Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-103123ENRHiroshi West—UHC-60964-8750196213212311 Bayshore Dr, Tucson, AZ, 857570.54Date of birth unreadablePhone reformattedZIP+4 trimmedGender normalised+1 more
CLM-415094CLMAbigail Berry2007-12-02——1668 Harbor Blvd, Columbus, OH, 432270.54Street suffix standardisedAddress re-casedState name converted to codeGender normalised+1 more
ENR-132226ENRMarcus O Parker1940-09-01UHC-00441-2942662412667772 Park Pl Apt 30, Glendale, AZ, 853220.54Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+1 more
ENR-117547ENRWalter V Gardner2006-10-02UHC-02634-7142543344834041 Bayshore Dr, Denver, CO, 802450.54Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+1 more
CLM-418869CLMDuncan Kathryn1966-07-24UHC-43519-95—8671 Forest Ave, Atlanta, GA, 303360.54Two-digit birth yearStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-139582ENRSamuel Oliver1955-11-01UHC-84083-2142364800869710 Meadow Ln, Austin, TX, 787630.54Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+1 more
CLM-428774CLMMichael Duncan———1692 Central Ave, Charlotte, NC, 282850.54Date of birth unreadableStreet suffix standardisedAddress re-casedGender normalised+1 more
ENR-116545ENRDnaiel Flores1980-08-09UHC-20989-2733323591031785 Apache Blvd, Fresno, CA, 937270.54Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-118753ENRBetty H Pena1953-10-03UHC-15755-2858866630838194 Maple Ave, Nashville, TN0.54Name split from “Last, First”Middle initial moved out of first namePhone reformattedZIP missing+1 more
ENR-138948ENRDabra T Carlson1955-01-16UHC-48214-9682255333513548 Mountain View Dr, Scottsdale, AZ, 852310.54Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+1 more
ENR-133967ENRMichael R Fernandez1976-11-07UHC-51140-0495253340446921 Harbor Blvd, Jacksonville, FL0.54Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+1 more
PRV-20734PRVJulia Ortega———9413 Jefferson Ave, Denver, CO, 802810.54Name split from “Last, First”Date of birth unreadableStreet suffix standardisedAddress re-cased+1 more
TPA-52234TPAArthur Greene2006-06-20——4014 Cedar Ln, Atlanta, GA0.54Name split from “Last, First”Date of birth reformattedState name converted to codeZIP missing+1 more
ENR-109887ENREvelyn O Woods1980-12-02UHC-04940-63—7917 Central Ave, Tampa, FL, 336530.54Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+1 more
ENR-105946ENRJoseph H Leiws2005-04-10UHC-11816-6269755442401020 Cedar Ln, Scottsdale, AZ, 852270.54Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+1 more
ENR-120482ENRCharlie Y Kelly2006-07-14UHC-86006-63—25 Jefferson Ave, Scottsdale, AZ, 852260.54Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+1 more
CLM-425362CLMSteven Park2007-11-17UHC-63840-34—9470 Pine Dr Apt 18, Austin, TX, 787510.54Name re-casedTwo-digit birth yearUnit split from streetZIP+4 trimmed+1 more
100,000 rows, page 203 of 2,000PreviousNext