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-126894ENRChristine Jackson1956-01-19UHC-72896-5923666319105956 Bayshore Dr, Tucson, AZ0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
TPA-60777TPAAngela Wheeler1952-02-15——1829 Grand Ave, Jacksonville, FL, 322660.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
TPA-60915TPABilly Lawrence1942-02-09UHC-31776-14—187 Cedar Ln, Seattle, WA, 981910.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
CLM-418435CLMMichelle Kennedy1950-05-17UHC-09693-8263548128815675 Cedar Ln, Austin, TX, 787800.52Two-digit birth yearSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
ENR-133440ENRLuis Y Moore2008-09-11UHC-48649-2196793366719374 Ridge Rd, Houston, TX, 770830.52Phone reformattedStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-422973CLMMelissa Owens1972-03-18UHC-20322-63—7251 Sunset Blvd # 673, San Antonio, TX0.52Unit split from streetStreet suffix standardisedAddress re-casedCity re-cased+2 more
PRV-21655PRVRebecca Franklin2008-01-09UHC-18936-068234147070—0.52Name split from “Last, First”Two-digit birth yearPhone reformattedGender normalised+2 more
CLM-403669CLMLawrence Estrada1944-10-22UHC-71464-18—4645 Harbor Blvd, Columbus, OH, 432900.52Two-digit birth yearStreet suffix standardisedAddress re-casedCity re-cased+2 more
CLM-428459CLMMartha Henderzon1970-11-08——4102 Forest Ave Apt 19, Chandler, AZ, 852780.52Date of birth reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
TPA-53457TPAKevin Chapman1967-09-13——3206 Meadow Ln, Scottsdale, AZ0.52Name re-casedStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-422244CLMMegan X Castillo1955-03-05UHC-34234-24—4037 River Rd # 420, San Antonio, TX, 782430.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
PRV-22250PRVJason Cole1993-10-28UHC-29923-1332980915917591 Market St, Eden Prairie, MN, 553810.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-21776PRVGrace Garrett1993-10-14UHC-31113-3831572229911674 Oak St # 574, Plano, TX, 750240.52Name split from “Last, First”Two-digit birth yearUnit split from streetCity re-cased+2 more
TPA-53715TPABrenda Garrett1985-09-28UHC-01984-2425473331683668 Ridge Rd, Phoenix, AZ, 850180.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-427748CLMMark Valdez1980-03-27——9126 Main St, Orlando, FL, 328800.52Name split from “Last, First”Phone missing area codeStreet suffix standardisedAddress re-cased+2 more
TPA-51493TPAAnthony N Salazar2004-01-25——3940 Hillcrest Rd, Plano, TX, 750070.52Street suffix standardisedAddress re-casedState name converted to codeZIP+4 trimmed+2 more
CLM-428963CLMLori Johnsson1990-01-12——6298 Forest Ave Apt 26, Charlotte, NC, 282510.52Name split from “Last, First”Unit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-129833ENRAnthony Rogers1975-09-08UHC-27408-94—7260 Grand Ave, Phoenix, AZ, 850300.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
ENR-130795ENRPhilip B Sipmson1940-08-26UHC-19865-6439455253309221 Market St, Minneapolis, MN, 554930.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-123242ENRDiana S Bailey1999-10-21UHC-96404-93—3860 Spring St, Miami, FL0.52Name re-casedDate of birth reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-24494PRVAndrew Larson1994-01-10UHC-19155-72—7764 Highland Ave, Austin, TX, 787100.52Phone missing area codeStreet suffix standardisedAddress re-casedCity re-cased+2 more
TPA-63381TPAHannah Bowman1997-02-18——3657 Central Ave, Charlotte, NC, 282270.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-107571ENRMichelle Harvey—UHC-39297-7087374906311657 Ridge Rd, San Diego, CA, 921910.52Name split from “Last, First”Date of birth missingPhone reformattedZIP+4 trimmed+2 more
ENR-122564ENRValentina Wood1989-02-20UHC-77504-308498752268464 Oak St, Gilbert, AZ0.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-127240ENRAnn G Russell2006-06-08UHC-35547-4838856569604502 Hillcrest Rd, San Diego, CA, 921030.52Two-digit birth yearPhone reformattedStreet suffix standardisedAddress re-cased+2 more
ENR-115922ENRWalter L Alvarez1941-06-02UHC-32233-1737537900454448 Sage Ct, Houston, TX, 770310.52Name re-casedPhone reformattedStreet suffix standardisedAddress re-cased+2 more
PRV-28811PRVScott B Howell1997-12-18—84588243381511 Willow Ct, Scottsdale, AZ, 852410.52Name split from “Last, First”Phone reformattedStreet suffix standardisedAddress re-cased+2 more
CLM-409698CLMEugene Coleman1986-01-20UHC-30788-02—9066 Ocean Ave, Austin, TX, 787480.52Name re-casedSSN last four extractedState name converted to codeGender normalised+2 more
ENR-130653ENRMadison Hawkins1950-04-28UHC-18827-8063654324043643 Forest Ave Apt 20, Gilbert, AZ, 852310.52Phone reformattedUnit split from streetStreet suffix standardisedAddress re-cased+2 more
ENR-139983ENRRalph Garcia1945-04-22UHC-55034-7437357843472592 Forest Ave, Miami, FL, 331150.52Name split from “Last, First”Phone reformattedSSN last four extractedState name converted to code+2 more
CLM-424268CLMJack Barnes1940-07-25UHC-58851-08—5734 Washington St # 920, Atlanta, GA0.52Unit split from streetStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-122114ENRAnthony Q Garcia1993-05-08UHC-14322-9638450414599491 Bayshore Dr, Houston, TX, 770300.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-115373ENRSusan Ward1959-08-18UHC-02824-24—8521 Highland Ave, Nashville, TN, 372280.52Name re-casedPhone missing area codeStreet suffix standardisedAddress re-cased+2 more
PRV-25454PRVMartha Castro1984-04-01——5565 Hillcrest Rd Apt 25, Nashville, TN, 372340.52Unit split from streetStreet suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-130349ENRKeith Griffin1979-04-15UHC-52969-8850884260499173 Lake View Rd Apt 2, Tucson, AZ, 857950.52Name re-casedTwo-digit birth yearPhone reformattedUnit split from street+2 more
CLM-409571CLMHarold Mason1940-11-11——1481 Hillcrest Rd, Gilbert, AZ, 852380.52Name split from “Last, First”Street suffix standardisedAddress re-casedEmail lower-cased+2 more
ENR-142997ENRNoah K Boyd—UHC-94724-49—474 Washington St, Glendale, AZ0.52Date of birth unreadableStreet suffix standardisedAddress re-casedZIP missing+2 more
ENR-126394ENRJoyce Watson1938-11-17UHC-18256-9240171225813969 Lincoln Way, Jacksonville, FL, 322970.52Street suffix standardisedAddress re-casedCity re-casedState name converted to code+2 more
CLM-423690CLMAaron E Johnson1978-11-04UHC-30422-6743479224159581 Indian School Rd # 523, San Antonio, TX, 782830.52Two-digit birth yearPhone reformattedUnit split from streetStreet suffix standardised+2 more
ENR-141042ENREmily X Foster1988-02-21UHC-40785-7526449499801701 Meadow Ln, Gilbert, AZ, 852820.52Name split from “Last, First”Middle initial moved out of first namePhone reformattedStreet suffix standardised+2 more
CLM-403551CLMCarolyn O Jacckson2002-11-02——2843 Mesa Dr # 494, Atlanta, GA, 303050.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-403552CLMCarolyn O Jacckson2002-11-02——2843 Mesa Dr # 494, Atlanta, GA, 303050.52Two-digit birth yearUnit split from streetStreet suffix standardisedAddress re-cased+2 more
CLM-413832CLMDoris Dominguez2001-12-16UHC-82608-31—6256 Sunset Blvd, Scottsdale, AZ, 852200.52Name split from “Last, First”Street suffix standardisedAddress re-casedGender normalised+2 more
CLM-414318CLMCheryl U Wang1959-07-15UHC-22851-7162238087712046 River Rd, Plano, TX, 750690.52Name split from “Last, First”Two-digit birth yearStreet suffix standardisedAddress re-cased+2 more
ENR-140858ENRAhmed O Coleman1957-03-03UHC-59645-1051260659714581 Forest Ave, Columbus, OH0.52Name split from “Last, First”Phone reformattedZIP missingEmail lower-cased+2 more
ENR-141185ENRKyle Cook2001-09-07UHC-25023-4421661476119327 Broadway, Scottsdale, AZ, 852410.52Name split from “Last, First”Phone reformattedSSN last four extractedCity re-cased+2 more
ENR-102571ENRMei F Estrada1958-06-13UHC-89965-96—8211 Church St, Tempe, AZ0.52Phone missing area codeStreet suffix standardisedAddress re-casedZIP missing+2 more
CLM-421357CLMLarry Bradley2001-01-13——3299 Pine Dr, Eden Prairie, MN, 553910.52Name split from “Last, First”Street suffix standardisedAddress re-casedZIP+4 trimmed+2 more
ENR-139929ENROmar Fisher1995-03-19UHC-39161-4042871506898386 Ocean Ave, Las Vegas, NV, 891060.52Phone reformattedSSN last four extractedStreet suffix standardisedAddress re-cased+2 more
TPA-59103TPAAshley W Walker1952-12-07——524 Indian School Rd, Atlanta, GA, 303100.52Name re-casedStreet suffix standardisedAddress re-casedState name converted to code+2 more
100,000 rows, page 148 of 2,000PreviousNext