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-103465ENRLawrence Morales1957-08-11UHC-63515-18—5156 Forest Ave, Gilbert, AZ, 852620.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-418205CLMSharon Fowler1998-12-14—72433457659896 Apache Blvd, Mesa, AZ, 852620.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
TPA-51269TPAWillie Williamson1980-02-11—47464656267994 Canyon Rd Apt 10, San Antonio, TX, 782390.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-125572ENRPatricia Z Padiilla1941-12-17UHC-08197-5447744156548746 Maple Ave, Minneapolis, MN0.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-113668ENRBrian I Hall1946-06-06UHC-70681-11—7724 Ridge Rd, Dallas, TX0.52Street suffix standardisedAddress re-casedState code upper-casedZIP missing+2 more
ENR-111091ENRDoris Nguyen1955-02-12UHC-74700-9290388433514996 Highland Ave, Atlanta, GA, 303560.52Name re-casedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
PRV-26431PRVTeresa D Simpson1957-04-18——1259 Mountain View Dr, Orlando, FL, 328200.52Date of birth reformattedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
ENR-116768ENRDebra K Fields1973-06-12UHC-12024-3370152799011358 Pine Dr, Phoenix, AZ, 850930.52Name split from “Last, First”Phone reformattedSSN last four extractedStreet suffix standardised+2 more
PRV-26001PRVRoger Fisher1980-08-23UHC-56175-5339171212267021 Meadow Ln, Tempe, AZ, 852060.52Phone reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
CLM-429138CLMRoger Lawrence—UHC-53970-063713574526305 Pine Dr, Las Vegas, NV, 891080.52Date of birth unreadablePhone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-418947CLMBobby Hicks1953-02-05UHC-64037-39—9653 Palm Dr, Glendale, AZ, 853820.52Name split from “Last, First”Member ID reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-53759TPADiane Butler1984-02-05—4077191224309 Hillcrest Rd, Charlotte, NC0.52Phone reformattedState name converted to codeZIP missingEmail lower-cased+2 more
CLM-421897CLMMartha Watson1963-10-20——3899 Spring St # 106, Seattle, WA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-416648CLMChristine Simpson1943-05-14——5125 Hillcrest Rd Apt 22, Phoenix, AZ, 850920.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-123012ENRPatricia RJunk1992-08-25UHC-68939-9490897613945270 Highland Ave, Chandler, AZ, 852270.52Name re-casedTwo-digit birth yearPhone reformattedStreet suffix standardised+2 more
ENR-141388ENRKenneth S Ross1947-09-04UHC-26589-5290683959744605 Hillcrest Rd, Phoenix, AZ0.52Phone reformattedState name converted to codeZIP missingEmail lower-cased+2 more
CLM-419260CLMSteve Grant1948-05-25——2957 Desert Sky Blvd Apt 30, Las Vegas, NV, 891170.52Date of birth reformattedUnit split from streetState name converted to codeGender normalised+2 more
CLM-419259CLMSteve Grant1948-05-25——2957 Desert Sky Blvd Apt 30, Las Vegas, NV, 891170.52Date of birth reformattedUnit split from streetState name converted to codeGender normalised+2 more
ENR-101510ENRYuki W Riley1914-05-23UHC-96554-3239198195022940 Oak St Apt 23, Eden Prairie, MN, 553320.52Date of birth reformattedPhone reformattedUnit split from streetZIP+4 trimmed+2 more
ENR-118602ENRLori M Ferguson2006-08-26UHC-87498-5128490262762459 Highland Ave Apt 17, Glendale, AZ, 853520.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
ENR-107073ENRKathleen L Torres—UHC-94701-7281665406596571 Desert Sky Blvd, Scottsdale, AZ, 852000.52Name split from “Last, First”Date of birth unreadablePhone reformattedStreet suffix standardised+2 more
ENR-111610ENRAlex P James1942-04-05UHC-26212-3567173907572652 Canyon Rd, Scottsdale, AZ0.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-125802ENRArthur J Baker1949-02-15UHC-95250-585405256712291 Indian School Rd, Orlando, FL, 328240.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-142519ENRChristian Vargas1962-12-25UHC-00336-953648718471827 Sage Ct # 513, Columbus, OH, 432420.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-412291CLMVirginia F Ross1999-07-13UHC-44106-88—6241 Main St, Orlando, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-412290CLMVirginia F Ross1999-07-13UHC-44106-88—6241 Main St, Orlando, FL0.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
CLM-406251CLMHarold Fisher1962-04-25UHC-14995-60—2037 Lake View Rd Apt 18, Mesa, AZ, 852730.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-133571ENRWayne Perkins1943-09-07UHC-83686-3490987719615373 Highland Ave, Mesa, AZ, 852120.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-109572ENRPatrycia Sullivan1960-08-06UHC-32585-7278881623577284 Grand Ave, Plano, TX, 750220.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-137980ENRMadison S Mendoza1979-10-28UHC-78916-7381880407707638 Lake View Rd, Dallas, TX, 752150.52Date of birth reformattedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-51385TPAHenry T Bishop1969-11-06——1886 Church St, Atlanta, GA0.52Street suffix standardisedAddress re-casedState name converted to codeZIP missing+2 more
CLM-414648CLMPhilip Shaw—UHC-81336-8494922355265551 Willow Ct Apt 26, Nashville, TN, 372430.52Name re-casedDate of birth missingPhone reformattedUnit split from street+2 more
CLM-429527CLMFrances Bryant1943-02-02——1254 Jefferson Ave, Tampa, FL, 336880.52Street suffix standardisedAddress re-casedCity re-casedZIP+4 trimmed+2 more
PRV-23309PRVKayla Carr1964-05-19—697783529137 Camelback Rd, Phoenix, AZ0.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-133042ENRZachary V Flores1966-05-17UHC-91931-944456029752138 Mesa Dr, Austin, TX, 787200.52Date of birth reformattedStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-117908ENREvans Viginia—UHC-47098-3649694045676614 Elm St, Scottsdale, AZ, 852840.52Name re-casedDate of birth unreadablePhone reformattedStreet suffix standardised+2 more
CLM-404191CLMLogan Elliott1951-02-03UHC-52877-90—3366 Harbor Blvd, Los Angeles, CA0.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
PRV-23058PRVChristina Hart1954-04-21—83998330236532 Bayshore Dr, Las Vegas, NV, 891440.52Street suffix standardisedAddress re-casedZIP+4 trimmedEmail lower-cased+2 more
ENR-101976ENRJess Medina2002-11-26UHC-92187-0779785684121120 Bayshore Dr Apt 25, Fresno, CA, 937170.52Name split from “Last, First”Phone reformattedUnit split from streetStreet suffix standardised+2 more
CLM-426984CLMLucia Ross1995-11-07UHC-91262-4120881961791906 Spring St, Charlotte, NC, 282890.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
PRV-29339PRVAshley Vargas1958-09-03—68050328379179 Cedar Ln Apt 13, Chandler, AZ, 852190.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-401809CLMJoyce Carlson1956-07-15UHC-05360-87—2610 Baseline Rd, Glendale, AZ, 853270.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-106393ENRMegan Harris1969-07-07UHC-23742-4350235380535792 Ocean Ave Apt 27, Tampa, FL, 336200.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-62799TPAWillie Gardner1989-02-19UHC-17309-82—3227 Central Ave, Atlanta, GA, 303880.52Name split from “Last, First”Street suffix standardisedAddress re-casedState name converted to code+2 more
ENR-137107ENRAna O Adams1944-07-09UHC-91260-0197690968949369 Ocean Ave, Phoenix, AZ0.52Name split from “Last, First”Street suffix standardisedAddress re-casedCity re-cased+2 more
ENR-101362ENRMartha Bailey1972-11-04UHC-06979-9951472729124540 Jefferson Ave, Charlotte, NC0.52Street suffix standardisedAddress re-casedZIP missingEmail lower-cased+2 more
TPA-54791TPAKathy Garza1962-07-25——5978 Elm St # 673, San Diego, CA, 921130.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-123652ENRRoger Cook1966-01-17UHC-57892-3487382723696721 Harbor Blvd, Eden Prairie, MN, 553480.52Name split from “Last, First”Date of birth reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-135539ENRJoseph T Gonzales—UHC-00602-4688823516578030 Elm St, Houston, TX0.52Date of birth unreadablePhone reformattedZIP missingEmail lower-cased+2 more
ENR-128795ENRKatherine P Hamilton1995-12-12UHC-73729-70309517413110 Mountain View Dr, Columbus, OH0.52Middle initial moved out of first namePhone reformattedStreet suffix standardisedAddress re-cased+2 more
100,000 rows, page 155 of 2,000PreviousNext