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-120929ENRAlan Mills1998-02-18UHC-85719-06—6345 Church St, Eden Prairie, MN0.52Name re-casedPhone missing area codeCity re-casedZIP missing+2 more
CLM-429140CLMCarl Gibson1986-02-04——1931 Camelback Rd, Jacksonville, FL, 322360.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
PRV-26956PRVBryan Franklin1981-12-17——325 Valley View Dr, Scottsdale, AZ, 852000.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136258ENRMargaret R Cook1996-09-07UHC-09865-4567036151978085 Grand Ave # 180, Orlando, FL, 328450.52Name split from “Last, First”Phone reformattedMember ID reformattedUnit split from street+2 more
ENR-112819ENRYuki Lynch1963-06-01UHC-60388-32—1153 Canyon Rd Apt 20, Gilbert, AZ, 852230.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-415488CLMRebecca U Hart1962-03-15——2012 Jefferson Ave, Dallas, TX, 752840.52Two-digit birth yearPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-113964ENRMei Chavez1997-10-09UHC-94469-58—3316 Mesa Dr, Austin, TX, 787990.52Phone missing area codeMember ID reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115534ENRBeverly Walker—UHC-69135-96—588 Baseline Rd, Orlando, FL0.52Name re-casedDate of birth missingStreet suffix standardisedAddress re-cased+2 more
ENR-131944ENRDennis H Ford1939-10-12UHC-80301-90—8159 Desert Sky Blvd, Fresno, CA, 937520.52Name re-casedPhone missing area codeSSN last four extractedStreet suffix standardised+2 more
PRV-24880PRVLori Lee1943-09-07—77938283077843 Sunset Blvd, Scottsdale, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-57955TPADoroty Griffin1942-08-16——968 Camelback Rd, Austin, TX, 787700.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-117737ENREugene T Hanson1955-06-03UHC-51392-8379943569824699 Washington St, Atlanta, GA, 303240.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-25456PRVNoah Munoz1973-01-26——5381 Pine Dr, Houston, TX, 770950.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-51138TPAEugene Robinson1958-11-01UHC-47358-7779468471716267 Oak St, Las Vegas, NV, 891200.52Name split from “Last, First”Phone reformattedZIP+4 trimmedGender normalised+2 more
ENR-110439ENRRandy L Murphy1944-02-26UHC-31162-508496614340243 Central Ave, Charlotte, NC, 282500.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-414236CLMLori I Austin2003-07-23UHC-45897-76—500 Camelback Rd, San Diego, CA, 921210.52Two-digit birth yearStreet suffix standardisedAddress re-casedGender normalised+2 more
CLM-407771CLMBrian Wang1954-12-26UHC-03998-29—2019 Valley View Dr # 248, Eden Prairie, MN, 553560.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-133873ENRAmy J Jacobs1952-01-01UHC-84427-3137098163635267 Main St, San Diego, CA, 921580.52Name re-casedPhone reformattedSSN last four extractedStreet suffix standardised+2 more
ENR-135603ENRGrace Davis2000-05-18UHC-22284-676634670721436 Spring St, Denver, CO0.52Date of birth reformattedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-58407TPAEugene Fields1946-04-17—23279904918134 Valley View Dr, Columbus, OH, 432320.52Name split from “Last, First”Date of birth reformattedPhone reformattedZIP+4 trimmed+2 more
CLM-401095CLMDaniel Bailey1967-02-12——6151 Desert Sky Blvd, Mesa, AZ, 852760.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-59042TPAJuan Lewis1964-04-09UHC-51931-2192827597924772 Jefferson Ave, Scottsdale, AZ0.52Phone reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-121215ENRSara Lee1949-02-03UHC-92684-75—7622 Desert Sky Blvd, Denver, CO, 802980.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-123404ENRSusan Y Herrera—UHC-06139-0766248509511060 Meadow Ln, Las Vegas, NV, 891560.52Date of birth missingPhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-419850CLMMcDonald Eric2006-08-23—75027900874372 Central Ave, Minneapolis, MN, 554640.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-133390ENRJeff V Soto2006-08-10UHC-86836-12—4743 Desert Sky Blvd, Fresno, CA, 937340.52Two-digit birth yearPhone missing area codeMember ID reformattedStreet suffix standardised+2 more
PRV-20254PRVJeffrey S Dixon2007-02-12——3804 Hillcrest Rd, Mesa, AZ, 852230.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-136204ENRVictoria F Clark1988-04-08UHC-71043-4439663566409334 Grand Ave, Minneapolis, MN, 554370.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-403187CLMYuki A Herrera2004-09-05—22091782551268 Palm Dr, Minneapolis, MN0.52Phone reformattedStreet suffix standardisedAddress re-casedZIP missing+2 more
PRV-23634PRVNoah E Sims2002-05-14UHC-54449-78—7793 Harbor Blvd, Chandler, AZ, 852150.52Two-digit birth yearStreet suffix standardisedAddress re-casedState name converted to code+2 more
ENR-140759ENRJanice Z Marshall1985-02-22——5578 Bayshore Dr, Sacramento, CA, 958240.52SSN last four extractedStreet suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-131029ENRYukki Elliott1992-02-18UHC-02081-1956782898684413 Church St, Chandler, AZ, 852730.52Name split from “Last, First”Date of birth reformattedPhone reformattedState name converted to code+2 more
CLM-400484CLMSantiago Peters1999-11-21——8248 Willow Ct Apt 7, San Antonio, TX, 782100.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-103791ENRChristina D Crawford1956-06-26UHC-10362-8942454444435106 Desert Sky Blvd, Eden Prairie, MN, 553100.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-107283ENRHelen Y Nichols1953-01-22UHC-51783-9828226847183877 Washington St, Plano, TX, 750160.52Middle initial moved out of first nameName re-casedStreet suffix standardisedAddress re-cased+2 more
ENR-142725ENRSantiago W McDonald—UHC-59608-3368966737296607 Jefferson Ave, Miami, FL, 331760.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
PRV-23264PRVDebra Hill1947-12-10—30665532363871 Bayshore Dr, Phoenix, AZ, 850410.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-100146ENRAnna H McDonald1972-03-16UHC-61383-3178375943695798 Union St, Los Angeles, CA, 900150.52Name split from “Last, First”Two-digit birth yearPhone reformattedStreet suffix standardised+2 more
CLM-406511CLMKayla Henry1969-11-11UHC-88085-99—5247 Spring St, Columbus, OH0.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP missing+2 more
ENR-114865ENRJudith M Fox1948-03-11UHC-81588-9342463302483009 Mountain View Dr, Minneapolis, MN0.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-142072ENRGrace C Oliver1954-02-20UHC-79868-4725798876255167 Willow Ct, Gilbert, AZ, 852340.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-406859CLMWalter Murray—UHC-21262-70—9728 Mesa Dr, Las Vegas, NV, 891660.52Date of birth missingStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63165TPADonald Chapman2003-08-09—435394871858 Palm Dr, Las Vegas, NV, 891450.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-140372ENRLarry W Hudson—UHC-70621-9553721562167931 Elm St, San Diego, CA, 921610.52Date of birth unreadableStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-139962ENRSara N Alvarado2003-01-03UHC-48967-8782390927933430 Desert Sky Blvd, Houston, TX0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-103323ENROivia R Hughes1985-02-19UHC-11245-9623797197586459 Lake View Rd, Denver, CO, 802280.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-112425ENREtan Alvraez1955-12-04UHC-95573-589707017180349 Mountain View Dr, Nashville, TN, 372690.52Name split from “Last, First”Phone reformattedMember ID reformattedStreet suffix standardised+2 more
ENR-104502ENRTimothy Hamilton1952-01-26UHC-90711-4582046088046114 Church St, Eden Prairie, MN, 553590.52Name split from “Last, First”Date of birth reformattedPhone reformattedStreet suffix standardised+2 more
ENR-110970ENRAlexander I Shaw1938-03-04UHC-11225-3949054399615813 Market St, Orlando, FL0.52Middle initial moved out of first nameDate of birth reformattedPhone reformattedZIP missing+2 more
TPA-64257TPAJack Graham1981-03-04——9805 Camelback Rd, Eden Prairie, MN0.52Name re-casedTwo-digit birth yearStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 166 of 2,000PreviousNext